Year 7
Lesson 4 Become a data master!
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
- Learning graphs
- Unit overviews
- Activities
Not registered yet?
Create an account and get access to over 500 hours of free teaching resources.