Scroll to content
Westwood Primary School home page

Westwood Primary School

'If you believe you can do it, you can and you will!'

Content Scroll

Spreadsheets

KS1

In KS1 the children are introduced to 2Calculate which enables them to begin to create spreadsheets. They learn how to insert images and text and how to lock these in place and move them around.

 

                

 

Then they progress to using copy/paste and totalling tools, which enables them to use a spreadsheet for calculations.

 

Here, as a class, they have collected data on a variety of subjects and were then able to input the data to produce different graph types.


 

       

 

 

 

 

LKS2

 

In Lower KS2 our children extend their Spreadsheet skills to include making counting and conversion machines, along with different methods of handling data. They learn how to collect data, both individually and collaboratively, and then input their data into 2Calculate to display it in a variety of ways.

They are also able to use the advanced mode of 2Calculate to learn about cell references and to format cells as currency, percentage, decimal to different decimal places or fraction.

 

 

UKS2

In Upper KS2 the children's skills are further extended to using spreadsheets to model real-life situations including a plan for a class party, which they really enjoy.

 

In this example the children created a computational model to help decide the best value tickets to buy for a concert. They had to format cells appropriately and use different formulae as additional information was provided to them.