Lesson 5: Shared spreadsheets

Having collected their data, pupils use a shared spreadsheet program to explore spreadsheets and learn how to extract information from the data

Learning Objectives

  • Understanding how to use a shared spreadsheet to explore data

  • Exporting data to a spreadsheet

  • Highlighting data using conditional formatting

  • Using a spreadsheet to calculate averages and sums of numbers

Lesson Plan

Shared spreadsheets
See the plan

Teacher Video: Google Sheets

Presentation: Google Sheets


Conditional formatting
Created by:
Siobhan Morgan,  
Computing specialist
Head of Computing at Exeter Junior School, Siobhan Morgan has nine years of computing teaching experience as well as experience from her role of ‘Subject Genius for Computing’ on TES. Siobhán enjoys spending time with her family and searching for the Gruffalo…
Find out more
video-icon icon-checked
I have completed this lesson