Year 6 – Lesson 3 – What's the formula?
Learners will begin to use formulas to produce calculated data. They will understand that the type of data in a cell is important (e.g. numbers can be used in calculations whereas words cannot). Learners will create formulas to use in a spreadsheet using cell references and identify that changing inputs will change the output of the calculation.
Learning objectives
To explain that formulas can be used to produce calculated data
- I can explain which data types can be used in calculations
- I can construct a formula in a spreadsheet
- I can identify that changing inputs changes outputs
Package contents
- Lesson plans
- Slide decks
- Learner resources
- Homework
Don't have an account?
Enjoyed teaching these lessons? Found a mistake?
Fill in a short form to give feedback on these resources.