Year 7 – Lesson 4 – Become a data master!

Curriculum KS3 Unit Lesson

In this lesson, learners will discover how to use functions to analyse data in a spreadsheet. As well as learning how to automatically create charts from data, they will be introduced to four functions: SUM, MAX, MIN, and COUNTA. Functions allow you to very quickly calculate results. The functions covered in this lesson are used to calculate totals, find the maximum and minimum values in a range, and count populated (i.e. non-blank) cells.

Learning objectives

  • Analyse data
  • Create appropriate charts in a spreadsheet
  • Use the functions SUM, COUNTA, MAX, and MIN in a spreadsheet

Package contents

  • Lesson plans
  • Slide decks
  • Learner resources
  • Homework