Computing

Y6 Computing

Key Stage 2

Year 6

Spreadsheets

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.

What is a spreadsheet?

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.


Modifying spreadsheets


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


What's the formula?

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.


Calculate and duplicate

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. 




Event planning


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.


Key Stage 2, Computing, Spreadsheets

What is a spreadsheet?

Modifying spreadsheets

What's the formula?

Calculate and duplicate

Event planning

Presenting data