Year 7 - Computing
Spreadsheet calculations
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 use formulas in a spreadsheet to complete calculations.
Key Notes
- Formulas are used in spreadsheets to perform arithmetic calculations.
- Cell references are used in formulas to use values stored in other parts of the spreadsheet.
- Formulas that use cell references recalculate when the values in those reference cells change.
- The fill handle tool can easily replicate formulas and data across a range of cells.
Vocabulary To Learn
- formula: performs calculations in a spreadsheet
- cell reference: tells you the location of a cell and is made from the column letter and row number, separated by a colon
- fill handle: a tool used in a spreadsheet to replicate cell data across a range of cells
Common Mistakes To Avoid
- Pupils may believe that each time data is changed in a spreadsheet the formulas will also need to be changed.
3 Quick Questions (With Answers)
1. Describe the system or process from this lesson in clear steps.
Formulas are used in spreadsheets to perform arithmetic calculations. Cell references are used in formulas to use values stored in other parts of the spreadsheet.
2. Define this computing term and give one practical example. 'formula'
performs calculations in a spreadsheet. Add one real device or system example to prove understanding.
3. Correct this common computing misconception.
Mistake: Pupils may believe that each time data is changed in a spreadsheet the formulas will also need to be changed. Correction: Using cell references within a formula means that the formula will recalculate when the values in those reference cells change.
More Lessons In This Unit
Browse all guides in the Year 7 Computing guide library.