Year 7 – Lesson 2 – Quick calculations

Curriculum KS3 Unit Lesson

In this lesson, learners will practise entering text into cells of a spreadsheet and then learn how to perform calculations on the data using basic formulas and cell references. They will learn how to use the autofill tool to duplicate cells and continue a linear pattern, and then combine the autofill tool with basic formulas to quickly populate a results column with calculations.

Learning objectives

  • Use basic formulas with cell references to perform calculations in a spreadsheet (+, -, *, /)
  • Use the autofill tool to replicate cell data

Package contents

  • Lesson plans
  • Slide decks
  • Learner resources
  • Homework