Lessons (6)
These resources will be removed by end of Summer Term 2025.
Switch to our new teaching resources now - designed by teachers and leading subject experts, and tested in classrooms.
In this lesson, we will introduce the concept of spreadsheets and why spreadsheets are useful. We will learn how to navigate a spreadsheet via its rows and columns, and become familiar with the cell referencing system.
1 Slide deck
1 Worksheet
1 Quiz
1 Video
In this lesson, we will practise entering text into cells of a spreadsheet and then learn how to perform calculations on the data using basic formulas and cell references. We will learn how to use the autofill tool to duplicate cells and continue a linear pattern.
1 Slide deck
1 Worksheet
2 Quizzes
1 Video
In this lesson, we will begin with a recap of the previous lessons content and some further practise of using formulas. We will discover the difference between data and information, and between primary and secondary sources of data.
1 Slide deck
1 Worksheet
2 Quizzes
1 Video
In this lesson, we will discover how to use functions to analyse data in a spreadsheet. As well as learning how to automatically create charts from data. We will be introduced to four functions: SUM, MAX, MIN, and COUNTA.
1 Slide deck
1 Worksheet
2 Quizzes
1 Video
In this lesson, we will introduce three more functions "COUNTIF, AVERAGE, and IF" and to how they can sort and filter a spreadsheet. We will work on a larger data set to get a feel for analysing real-world data using spreadsheets.
1 Slide deck
1 Worksheet
2 Quizzes
1 Video
In this lesson, we will discover how to use conditional formatting, whereby the appearance of a cell changes automatically depending on the data it contains, according to rules you set. We then complete an end-of-unit summative assessment.
1 Slide deck
1 Worksheet
2 Quizzes
1 Video