Year 7 – Lesson 1 – Getting to know a spreadsheet

Curriculum KS3 Unit Lesson

This lesson introduces learners to the concept of spreadsheets and why spreadsheets are useful. They will learn how to navigate a spreadsheet via its rows and columns, and become familiar with the cell referencing system. They will locate and select ranges of cells and change cells’ background colour and border properties.

Learning objectives

  • Identify columns, rows, cells, and cell references in spreadsheet software
  • Use formatting techniques in a spreadsheet

Package contents

  • Lesson plans
  • Slide decks
  • Learner resources
  • Homework