Year 7 - Computing
Analysing and visualising data
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 analyse data using functions and summarise findings using charts.
Key Notes
- A spreadsheet function is a predefined formula that performs calculations.
- Spreadsheet functions can be used to analyse data.
- Charts can be used to visualise data in a way that is easier to understand.
Vocabulary To Learn
- function: a predefined formula that performs a calculation
- chart: a graphical representation of data
Common Mistakes To Avoid
- All range references in a spreadsheet needs to be the same as cell references in the format of column letter followed by row number (e.g. A1:A4).
3 Quick Questions (With Answers)
1. Describe the system or process from this lesson in clear steps.
A spreadsheet function is a predefined formula that performs calculations. Spreadsheet functions can be used to analyse data.
2. Define this computing term and give one practical example. 'function'
a predefined formula that performs a calculation. Add one real device or system example to prove understanding.
3. Correct this common computing misconception.
Mistake: All range references in a spreadsheet needs to be the same as cell references in the format of column letter followed by row number (e.g. A1:A4). Correction: If you want to reference the whole column you can remove the row numbers (e.g. A:A). Note that this is the only case where cell references do not have to follow the column:row convention.
More Lessons In This Unit
Browse all guides in the Year 7 Computing guide library.