Home Page

Grove Primary School and Nursery

'Bringing out the best in everyone'

Spreadsheets:

Lesson 1:Conversions of Measurements

• Children can create a formula in a spreadsheet to convert m to cm.

• Children can apply this to creating a spreadsheet that converts miles to km and vice versa.

Lesson 2: The Count Tool

• Children can use a spreadsheet to work out which letters appear most often.

• Children can use the ‘how many’ tool.

Lesson 3: Formulae Including the Advanced Mode

• Children can use a spreadsheet to work out the area and perimeter of rectangles.

• Children can use these calculations to solve a real-life problem.

Lesson 4: Using Text Variables to Perform Calculations

• Children can create simple formulae that use different variables.

• Children can create a formula that will work out how many days there are in x number of weeks or years.

Lesson 5: Event Planning with a Spreadsheet

• Children can use a spreadsheet to model a real-life situation and come up with solutions that can be practically applied.