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