Year 7 - Computing
Formatting data in a spreadsheet
Data modelling
Study Hub
Study Guides
This pupil-friendly study guide includes a unit summary, clear notes, common mistakes, and quick questions with answers.
Unit Summary
By the end of this unit pupils should be able to model data within a spreadsheet. Pupils will progress from using basic formulas to using inbuilt functions. Pupils will apply sorting and searching techniques to data and explore how conditional formatting can be used to present data effectively.
Lesson Summary
You will learn to identify the components of a spreadsheet and apply formatting to improve the presentation of data.
Key Notes
- A spreadsheet is a tool used to store and analyse data.
- In a spreadsheet, data is stored in cells, which are arranged in rows and columns.
- Formatting can be applied to data in a spreadsheet to make the data easier to read and understand.
Vocabulary To Learn
- cell: a rectangular box that holds data in a spreadsheet
- column: a vertical group of cells that runs from the top to the bottom
- row: a horizontal line of cells that runs from left to right
- formatting: modifying the appearance of data in a spreadsheet
Common Mistakes To Avoid
- The order of column and row in a cell reference are unimportant as columns are labelled with letters and rows are labelled as numbers.
3 Quick Questions (With Answers)
1. Describe the system or process from this lesson in clear steps.
A spreadsheet is a tool used to store and analyse data. In a spreadsheet, data is stored in cells, which are arranged in rows and columns.
2. Define this computing term and give one practical example. 'cell'
a rectangular box that holds data in a spreadsheet. Add one real device or system example to prove understanding.
3. Correct this common computing misconception.
Mistake: The order of column and row in a cell reference are unimportant as columns are labelled with letters and rows are labelled as numbers. Correction: Spreadsheet cell references are presented as the combination of the column letter followed by the row number, (eg. A1, B2). If the order is interchanged any other part of the spreadsheet that references them will not be able to locate them.
More Lessons In This Unit
Browse all guides in the Year 7 Computing guide library.