Year 6 Introduction to spreadsheets worksheet

“Collecting and labelling data” is free to print, with no account. It is the first sheet in the Year 6 computing unit “Introduction to spreadsheets”, for children aged 10 to 11, and takes about 20 minutes.

Print it on A4. The child's pages come first; the answers, and what each wrong answer tells you, are on the grown-up page that follows. Weeks 19 to 24 of the year, 6 sheets in the unit.

Free sample · answers on the last page

Collecting and labelling data

Name: ____________ · Date: ____________
Year 6 · Computing · about 20 minutes
Answers are on the grown-up page

Today I can collect data and label it so that anyone can understand it.

A Look back3 min

1.
Number these steps to save a file in the right order. Write the numbers in the boxes.
1. Click save
2. Open the file
3. Type the title
2.
The robot starts on the left square. Circle the arrows that take it to the goal square.
→ →↓ ↓→ ↓
3.
Sort these into the two columns. Write each card under the right heading.
Your favourite colourYour passwordYour home address
Keep private Fine to share

B Watch me, then you4 min

Ola asks six friends for their favourite fruit. Her raw notes are: apple, pear, apple, banana, apple, pear. She counts each fruit to see what the notes show.

Watch me

The raw notes are the six fruit words, in the order they were said.

Count each fruit: apple 3, pear 2, banana 1.

Ola writes the heading Favourite fruit above the counts, so anyone knows what the numbers mean.

Now you

1.
Sam asks five friends for a favourite pet. The notes are: dog, cat, dog, fish, dog. Count each pet, then write a heading above the counts.

C Your turn6 min

Each question changes one thing. Read the list, count carefully, then answer.

1.
Ola writes the colour of six cars: red, blue, red, white, red, blue. Count each colour. Then write a label above the colours and a label above the counts.
2.
Ola counts more cars and gets red 5, blue 2, white 1. She writes no heading. What might a friend think the 5 means? Write one idea.
3.
Ola's counts are red 5, blue 2, white 1. Circle the best heading for the column that lists red, blue and white.
Car colourLunchShoe size
4.
Raw data has no headings. Information has headings that tell you what it means. Ali's table reads: Name, Score, Ali 7, Bea 9. Is it raw data or information? Circle it.
Raw dataInformation

Say it out loud: Which question needed a heading to make sense, and why?

D Spot the mistake3 min

Kit says: “My numbers are 7, 9 and 3. I know what they mean, so I don't need any headings.”

1.
Why is Kit wrong? Write one or two sentences.

E Think deeper4 min

1.
Pick five things you can count at home, such as books or spoons. Count each one. Write a heading above the names and a heading above the counts. Then tell a grown-up why the headings help.

How did it feel?

I can do it Nearly Not yet

For the grown-up

Collecting and labelling data · 2 minutes to read

Answers, and what a wrong one tells you

A

1. 1 Open the file · 2 Type the title · 3 Click save If your child puts Click save first, they may think saving comes before there is anything to save. Ask: what must exist before you can save it?

2. → → If your child circles → ↓, the robot ends one square down, not on the goal. Ask your child to trace the path with a finger, one square at a time.

3. Keep private: Your password, Your home address · Fine to share: Your favourite colour

B

1. Look for: Counts of dog 3, cat 1, fish 1, with a heading that says what the counts are about, such as Favourite pet.

C

1. Look for: Counts of red 3, blue 2, white 1, with one label naming the colours and one naming the counts. If your child writes the counts with no labels, ask: would a friend who never saw the cars know what the 3 means?

2. Look for: A guess about what 5 could mean, showing a reader cannot tell without a heading.

3. Car colour

4. Information

D

1. Look for: Other readers need labels to know what the numbers mean, so labels make the data clear to everyone. your child may think labels are only for the person who wrote the data. Ask: what would a friend think if they only saw 7, 9 and 3?

E

1. Look for: Five countable things at home with a count for each, a heading over the names and over the counts, and a reason that other people can understand the list.

Words to use

Say“Which heading would help someone who has never seen this list before?”

Instead of“Don't worry about headings, just write the numbers down.”

After the sheet

For two minutes, count the red cars passing the window together. Write the raw marks on paper, then add a heading and talk about the difference.

Tick what your child got right in StudyDen. Anything missed comes back in a later Look back box, so there's no need to redo the sheet.

The rest of this unit

5 more sheets come with a StudyDen plan, in teaching order:

Formatting for Clear Data(with a plan)
Formulas that use cells(with a plan)
Totals with functions(with a plan)
Planning a party budget(with a plan)
Charts and tables together(with a plan)

Every Year 6 computing worksheet

The worksheets plan opens a printable sheet for every lesson in Years 1 to 6, each with its answers on a separate page for you. It costs £6.99 a month or £59 a year for the whole family, with no free trial.

The full StudyDen plan adds the lessons themselves, marked as your child works, with the worksheets included. It is 7 days free, then £29.99 a month.

Get the worksheets Try the full plan free

Both start with a free account; you choose the plan when you sign up.