Skip to main content

Year 6

Lesson 4 Calculate and duplicate

Curriculum > KS2 > Unit > Lesson

Learners will calculate data using the operations of multiplication, subtraction, division, and addition. They will use these operations to create formulas in a spreadsheet. Learners will then begin to understand the importance of creating formulas that include a range of cells and the advantage of duplicating in order to apply formulas to multiple cells.

Learning objectives

To apply formulas to data

  • I can calculate data using different operations
  • I can create a formula which includes a range of cells
  • I can apply a formula to multiple cells by duplicating it

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]