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