Year 7 – Lesson 5 – Level up your data skills!

Curriculum KS3 Unit Lesson

This lesson will introduce learners to three more functions — COUNTIF, AVERAGE, and IF — and to how they can sort and filter a spreadsheet. Learners will work on a larger data set to get a feel for analysing real-world data using spreadsheets.

Learning objectives

  • Analyse data
  • Use a spreadsheet to sort and filter data
  • Use the functions AVERAGE, COUNTIF, and IF in a spreadsheet

Package contents

  • Lesson plans
  • Slide decks
  • Learner resources
  • Homework