Skip to main content

Year 6

Lesson 3 What's the formula?

Curriculum > KS2 > Unit > Lesson

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
  • Learning graphs
  • Unit overviews
  • Activities
Log in to download

Not registered yet?

Create an account and get access to over 500 hours of free teaching resources.

Help us make these resources better

Provide your feedback

Or email us at [email protected]