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 learn that a spreadsheet is a computer application which allows users to organise, analyse, and store data in a table. We will be introduced to the importance of data headings.
1 Slide deck
1 Worksheet
1 Quiz
1 Video
In this lesson, we will be taught that objects can be described using data. We will build a data set (a collection of related data that can be manipulated using a computer) within a spreadsheet application and apply appropriate number formats to cells.
1 Slide deck
1 Worksheet
2 Quizzes
1 Video
In this lesson, we will begin to use formulas to produce calculated data. We will learn that the type of data in a cell is important (e.g. numbers can be used in calculations whereas words cannot). Then we will create formulas to use in our spreadsheets using cell references
1 Slide deck
1 Worksheet
2 Quizzes
1 Video
In this lesson, we will recognise that data can be calculated using different operations: multiplication, subtraction, division and addition. We will create formulas in a spreadsheet. We will then understand the importance of creating formulas that include a range of cells.
1 Slide deck
1 Worksheet
2 Quizzes
1 Video
In this lesson, we will plan and calculate the cost of an event using a spreadsheet. We will use a list to choose what we would like to include in our event, and use our spreadsheet to answer questions on the data we have selected.
1 Slide deck
1 Worksheet
2 Quizzes
1 Video
In this lesson, we will acquire the skills to create charts in Google Sheets. We will evaluate results based on questions asked using the chart that we have created. Finally, we will appreciate there are different software tools available within spreadsheet applications to present data.
1 Slide deck
1 Worksheet
2 Quizzes
1 Video