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
  • Slide decks
  • Learner resources
  • Homework