Year 6 - Computing
Formatting a spreadsheet
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 identify cells in a spreadsheet and how the data has been formatted.
Key Notes
- An individual item of data is recorded in a spreadsheet cell.
- Cell references combine the column letter and row number to individually identify every cell in a spreadsheet.
- Data formats are applied to cells of a spreadsheet so that it is clear what the data entered represents.
Vocabulary To Learn
- cell: a rectangular box in a spreadsheet used to store data
- data format: the way in which data is arranged and presented in a spreadsheet
Common Mistakes To Avoid
- Spreadsheet software is so good now that you don't need to spend time formatting cells for the expected data as it will do it automatically.
3 Quick Questions (With Answers)
1. Describe the system or process from this lesson in clear steps.
An individual item of data is recorded in a spreadsheet cell. Cell references combine the column letter and row number to individually identify every cell in a spreadsheet.
2. Define this computing term and give one practical example. 'cell'
a rectangular box in a spreadsheet used to store data. Add one real device or system example to prove understanding.
3. Correct this common computing misconception.
Mistake: Spreadsheet software is so good now that you don't need to spend time formatting cells for the expected data as it will do it automatically. Correction: Spreadsheet software can help, but you still need to format cells correctly to make sure the data will be displayed in the exact way you need it to be. Software doesn't always get this right.
More Lessons In This Unit
Browse all guides in the Year 6 Computing guide library.