Year 6 - Computing
Collecting data
Introduction to spreadsheets
Study Hub
Study Guides
This pupil-friendly study guide includes a unit summary, clear notes, common mistakes, and quick questions with answers.
Unit Summary
This unit introduces pupils to how spreadsheets can be used to organise data and create their own data sets. They will discover the importance of formatting data to support calculations, while also examining how formulas can be used to produce calculated data and how graphs can present this data.
Lesson Summary
You will learn to collect data and organise it in a spreadsheet.
Key Notes
- We can collect data about the what happens in the world around us.
- Data that is organised is easier to understand.
- Tables can be used to organise data in rows with each value described by labelled column headings.
- A spreadsheet is a tool on a computer that can be used to organise recorded data.
Vocabulary To Learn
- data: facts and figures in their raw form
- row: a line of data in a table that runs horizontally
- column: a group of data in a table that runs vertically
- spreadsheet: an electronic document that stores data arranged in rows and columns
Common Mistakes To Avoid
- When data is being recorded, if the person recording knows what each value represents, column labels are not needed.
3 Quick Questions (With Answers)
1. Describe the system or process from this lesson in clear steps.
We can collect data about the what happens in the world around us. Data that is organised is easier to understand.
2. Define this computing term and give one practical example. 'data'
facts and figures in their raw form. Add one real device or system example to prove understanding.
3. Correct this common computing misconception.
Mistake: When data is being recorded, if the person recording knows what each value represents, column labels are not needed. Correction: Column labels are important to make the data clear and easy to understand for everyone, even if the person recording it knows what it means.
More Lessons In This Unit
Browse all guides in the Year 6 Computing guide library.