aiMOOC

Collecting and presenting data with digital tools - Computing Year 5

QR-Code

Introduction

A class wants to choose a theme for a reading display. A colourful chart might look convincing, but what was counted, who answered and were the records checked? You will organise a small fictional dataset, find category totals, plan a spreadsheet chart and explain what the evidence supports.

The supplied data are invented. They contain no real pupils' information. You can work on paper or use a school-approved spreadsheet. By the end, you should be able to distinguish records from fields, check consistency, explain sorting and filtering, use a simple total formula and present a labelled chart with a limitation. This is an editorial Year 5 route within England's Key Stage 2 computing programme.

Ask a question and collect only what is needed

Start with a question that the data can answer: “Which of these three reading-display themes was chosen most often in our fictional survey?” The options are Mystery, Fantasy and Non-fiction. Each fictional respondent chooses exactly one option. We are counting choices, not testing reading ability, counting pages or deciding which theme is objectively best.

A dataset is an organised collection of data. A field describes one kind of information, such as chosen theme. A record contains the fields for one entry. In a table, columns commonly hold fields and rows hold records. Column headings should explain what their values mean.

Define the rules before collecting

Use one response per person, the same question for everyone and clear options. A blank response is not the same as choosing Non-fiction. A response selecting two options does not meet our one-choice rule and needs a recorded decision about how it will be handled. Do not quietly invent an answer to make the table complete.

For a real classroom activity, ask your teacher to approve the question and collection method. Do not collect names, contact details, account information or sensitive personal details merely because a digital form permits them. A small survey can be identifiable even without names when other details reveal people. The fully invented records here avoid that problem.

Before using a tool

Write a two-sentence plan: what question will be answered and which fields are needed. A digital tool organises data; it does not decide whether the collection was fair or appropriate.

Build a clean table of records

Here is the complete invented dataset. The response identifiers are fictional record labels, not pupil numbers. Each row represents one response.

Response label	Chosen theme
R01	Mystery
R02	Fantasy
R03	Mystery
R04	Non-fiction
R05	Mystery
R06	Fantasy
R07	Mystery
R08	Mystery
R09	Fantasy
R10	Non-fiction
R11	Mystery
R12	Fantasy
R13	Mystery
R14	Non-fiction
R15	Fantasy
R16	Mystery

Check entry, not just appearance

There should be sixteen records, unique response labels and one permitted theme in each row. Compare every entered row with the supplied data. If you accidentally type “Mstery”, a tool might treat it as a different category. Correct a copying error against the source and record that correction. Do not replace a real respondent's unclear choice with your own guess.

A missing response and a duplicate record are different issues. A missing value lacks an answer; a duplicate repeats an entry that should occur once. Two different records can legitimately choose the same theme. Repeated preferences are not duplicates simply because their theme cells match.

Sorting and filtering

Sorting rearranges records, for example by theme. Keep each complete row together: sorting only the theme column can attach a choice to the wrong response label. Filtering temporarily shows records that meet a condition, such as theme equals Fantasy. It should not silently erase all other records. Keep an untouched copy before exploring.

Try filtering for Fantasy on paper by marking the matching response labels. Then remove the marks to represent clearing the filter. The full dataset still contains sixteen records.

Summarise categories and test a formula

Count the matching records for each theme, then check that the category totals add to the number of valid one-choice responses. A summary table is different from the record table: one summary row represents a category, not a respondent.

A: Theme	B: Number of choices
Mystery	8
Fantasy	5
Non-fiction	3

In a new spreadsheet sheet, place Theme in A1 and Number of choices in B1. Enter the three category rows in A2:B4 in the order shown. Put Total in A5 and the formula =SUM(B2:B4) in B5. The colon specifies the range from B2 through B4, inclusive. With these values, the result should be sixteen.

A formula is an instruction for calculating a value. Typing 16 directly is a fixed entry; it does not express how that total depends on other cells. The displayed result and the formula are different things. Check the formula bar or the tool's equivalent to see what a cell contains.

Predict an update

On a copy of the summary sheet, change Fantasy's count in B3 from five to six. With automatic calculation enabled, the formula result should change from sixteen to seventeen. A typed 16 would stay 16. Restore the original data after the experiment, or label the copy as a modified scenario. Do not present the altered summary as though it still matches the original sixteen records.

Different tools or language settings can display function names differently. Use your school-approved tool's help if needed. You can also check the arithmetic manually: eight plus five plus three is sixteen. Creating a formula on paper is not evidence that you executed a spreadsheet; label which method you actually used.

Choose and label a useful chart

A bar chart is suitable for comparing these separate categories. Each bar represents a theme and its length represents a count. Use a zero baseline for these count bars, equal scale intervals, equal bar widths and gaps between the categories. Bar lengths should communicate the same scale for every theme.

Build the survey chart

Select the summary headings and three theme rows, A1:B4. Do not include the Total row as a fourth theme: it counts the same responses again rather than adding another preference. Choose a simple column or horizontal bar chart. Add the title “Reading-display choices: sixteen fictional responses”, category labels and an axis label “Number of choices”. A count scale from zero to ten in steps of one is suitable.

A horizontal chart is also valid: place the category names beside the bars and the count scale along the other axis. Avoid three-dimensional effects that make lengths harder to compare. Use text labels and an accompanying table so colour is not the only way to identify categories.

The Commons example has multiple series rather than our one count per theme. You are not being asked to copy its arrangement or interpret its bars as our survey values. Use it to discuss which labels a reader would need.

Khan Academy demonstrates reading bar graphs. Pause before an answer and identify the category, scale and value. Then return to our summary: the Mystery bar should reach eight, Fantasy five and Non-fiction three.

A line graph would suggest ordered progression or change between positions, which these theme categories do not have. A pie chart could represent their shares of the whole, but a simple bar chart makes the requested count comparison easier here. Choose a chart for the question, not for its decoration.

Write conclusions that the data support

A clear observation identifies the dataset, comparison and values. “Mystery received eight of the sixteen fictional choices” is supported. “Mystery received three more choices than Fantasy” is also supported because eight minus five is three.

What the chart does not prove

It does not prove that Mystery is the best kind of reading, that all children prefer it or that it caused people to read more. The question did not measure those things. Our example data are invented, so they do not even provide evidence of a real class's preferences. They are a model for practising a method.

In a real approved survey, the options can influence the answers. If comics are not offered, a person who prefers comics may choose a second favourite or decline to answer. A small voluntary sample may differ from the whole class or school. State such limits alongside the chart rather than hiding them in a file name.

A display decision

A fictional team might use these choices to propose a Mystery-themed display, while still including other reading opportunities. The data can inform a decision without telling the team that the five Fantasy and three Non-fiction choices do not matter. A different decision might consider cost, available books and accessibility as additional evidence.

Make the work reproducible

Keep the original table, a correction note if needed, the category summary, the formula or written calculation, a labelled chart and two bounded observations. A screenshot of a chart alone does not show whether the underlying data or formula are correct. If using a spreadsheet, change one count on a copy, observe whether the total updates, and record the actual result. If working on paper, describe that as a paper simulation rather than a software test.

Interactive Tasks

Quiz: Test Your Knowledge

What question does the fictional survey answer? (Which of three offered display themes was chosen most often in these records.) (!Which type of reading is objectively best for everyone.) (!How many pages every real pupil has read.) (!Why every child likes mystery stories.)

What is a record in the supplied table? (One fictional response with its label and chosen theme.) (!Every column heading combined with the chart title.) (!Only the total of all categories.) (!A decoration around the spreadsheet.)

Which is a field in the record table? (Chosen theme.) (!The whole collection of sixteen records.) (!The final chart image only.) (!The entire internet.)

Two different responses both choose Fantasy. What follows? (They can both be valid records because repeated choices are allowed.) (!One must be deleted as a duplicate without checking.) (!Both choices must be changed to Mystery.) (!The dataset has no usable information.)

Why should complete rows stay together during sorting? (To preserve the relationship between a response label and its choice.) (!To make every theme have the same count.) (!To remove the need for headings.) (!To prevent any record from being displayed.)

What does filtering for Fantasy normally do? (Show matching records while the other records remain in the dataset.) (!Permanently delete every other theme automatically.) (!Change all choices to Fantasy.) (!Prove that Fantasy has the most choices.)

What is the original total of the three category counts? (Sixteen.) (!Eight.) (!Thirteen.) (!Twenty-one.)

What should an automatically recalculated total become if five changes to six while eight and three remain? (Seventeen.) (!Sixteen regardless of the change.) (!Fourteen.) (!Eighty-three.)

Why should the Total row be excluded from this theme chart? (It combines the existing choices rather than representing a fourth theme.) (!Totals are always secret information.) (!A chart cannot contain more than two bars.) (!Including it makes every category equal.)

Which conclusion is supported by the invented summary? (Mystery has three more choices than Fantasy in this example.) (!All real children prefer Mystery.) (!Mystery stories cause better reading results.) (!No one outside these records likes Non-fiction.)

Memory Game

Dataset	An organised collection of data.
Field	One kind of information recorded for entries.
Record	The information belonging to one entry.
Formula	An instruction calculating a value from inputs or references.
Filter	Show the records meeting a stated condition.
Limitation	A reason to restrict what the evidence can establish.

Drag and Drop

Sort complete rows	Rearrange records while keeping related fields together.
Check permitted categories	Find a copying error such as Mstery.
Sum the category counts	Check agreement with the number of valid one-choice records.
Label the count axis	Tell readers what the bar lengths represent.
State the sample boundary	Avoid treating a small survey as the views of everyone.

Crossword Puzzle

record	One entry in the original dataset.
field	A type of information represented by a column.
filter	Temporarily show entries meeting a condition.
formula	A calculating instruction rather than a fixed typed total.
scale	The consistent numerical intervals used to read a chart.
sample	A selected set of responses rather than necessarily a whole population.

LearningApps

Optional extra practice. Choose an appropriate activity with your teacher. If the external collection is unavailable, use the native activities and independent tasks in this course.

Cloze Text

Open Tasks

Easy

Specify a reading-display survey: Write the exact question, three options and one-choice rule. Explain why pages read is not a required field for this question.
Check the sixteen invented records: Copy or enter the table and compare every row with the source. Record the number of entries and any copying correction.
Find the Fantasy records: List the matching response labels without deleting other entries. Explain the difference between filtering and removing records.
Create a category tally: Count each offered theme and check that the totals match the number of valid records. Show how you checked.

Standard

Plan a spreadsheet summary: Place the summary in the specified cells and write the B5 total formula. Explain the difference between its displayed value and its contents.
Test a changing count: On a clearly labelled copy, change Fantasy from five to six, predict the new total and record the actual spreadsheet result or a labelled paper simulation.
Design a labelled bar chart: Chart only the three categories. Use a zero baseline, suitable equal intervals, category labels, a title and count units. Include the summary table.
Write two bounded observations: Use exact counts to make two comparisons, then add one statement that these invented data cannot establish.

Advanced

Repair a sorting mistake: Explain what goes wrong if only the theme column is sorted. Show a two-row illustration and describe how to preserve record integrity.
Evaluate a misleading fourth bar: A chart includes Mystery, Fantasy, Non-fiction and Total. Explain why that presentation double-counts the same set conceptually and redesign it.
Review survey-option bias: Suppose a real approved survey omits a popular genre. Explain how the options might influence responses and propose a clearer collection plan.
Audit a complete data product: Review an original table, summary, total calculation, chart and two conclusions. Identify one check at each stage and separate actual software evidence from predictions.

Learning Check

Explain the table structure: Identify the fields and records, count the entries and explain why repeated theme values are not automatically duplicate records.
Reproduce the summary: Use the full table to find each count, the total and the difference between Mystery and Fantasy.
Distinguish a formula from a fixed value: Explain what belongs in B5, predict a one-count increase and describe how you would verify the result.
Justify the chart choice: Describe a chart that answers the question and explain why the Total row is excluded.
Evaluate a strong claim: Someone says the chart proves all children read more because they prefer Mystery. Explain at least two unsupported steps and write a valid alternative.

Worked checks and assessment guidance

The two fields are response label and chosen theme; each of sixteen rows is one fictional response. Different response labels can legitimately share a choice. A duplicate concern would involve repeating an entry intended to occur once.
Mystery occurs eight times, Fantasy five and Non-fiction three. The total is sixteen and Mystery exceeds Fantasy by three. Counts should be checked against the complete table rather than guessed from a picture.
For the specified A1:B4 layout, =SUM(B2:B4) totals the three count cells. It gives sixteen initially and seventeen if B3 changes from five to six with automatic recalculation. A typed 16 stays fixed; actual software observation or a labelled paper simulation must be recorded honestly.
A simple bar or column chart compares the three categories with a zero baseline, equal intervals, headings and count units. The total is a summary of those same responses, not another offered choice, so it should not be a fourth category bar.
The records are invented and do not represent real children. The question records a theme choice, not how much someone reads or what causes a change. A valid alternative is that Mystery has eight of sixteen choices in the fictional example, three more than Fantasy.

Learning evidence

Knowledge: Explain dataset, field, record, category, sort, filter, formula, scale and sample limitation.

Skills: Check records, preserve row relationships, calculate a summary, select an appropriate representation and distinguish a comparison from a causal claim.

Products: Keep the original fictional table, any correction log, category summary, formula or calculation, chart and bounded observations. Identify the source and invented status of the data.

Transfer: Adapt the process to another teacher-approved, non-sensitive question while reconsidering fields, response rules and sample limitations.

Tool evidence: If using software, retain the editable file and a test showing expected and actual recalculation. If using paper, label it as a paper model. Do not submit real pupil records or infer software competence from quiz completion alone.

OER and Wikipedia

Department for Education: computing programme. The relevant key-stage work includes selecting digital tools to collect, analyse and present information; the Year 5 teaching sequence is editorial.

Microsoft: using SUM with a cell range and LibreOffice Calc: Sort. Primary tool documentation for the stated operations. The survey, records, summaries and assessments here are original invented examples.

Photograph: International books at Kent Library, Roc0ast3r, CC0. Unmodified; the pictured library did not supply the fictional survey.

Diagram: Simple bar chart.svg, Masur, public domain release as documented on the file page. Unmodified grouped-chart illustration, not a visualisation of this lesson's data.

Video: Reading bar graphs: Applying mathematical reasoning, Khan Academy. Streamed from the original YouTube upload; the written route and tabulated values support learning without the video.