Lesson 5: Shared spreadsheets

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

Before the lesson

Download classroom resources

Learning objective

  • To understand how to use a shared spreadsheet to explore data

National curriculum

Pupils should be taught to:

  • Select, use and combine a variety of software (including internet services) on a range of digital devices to design and create a range of programs, systems and content that accomplish given goals, including collecting, analysing, evaluating and presenting data and information
  • Understand computer networks, including the internet; how they can provide multiple services, such as the World Wide Web, and the opportunities they offer for communication and collaboration

Success criteria

Cross-curricular links

Attention grabber

Main event


For pupils needing extra support: Refer them to the Activity: Conditional formatting resource to support them.

Pupils working at greater depth: Should be encouraged to explore creating graphs using their data. Allow them to tinker with the data they have collected to see what they can find out.

Wrapping up

Assessing pupils' progress and understanding


Created by:
Cat Lamin,  
Computing specialist
Cat was a committed primary school teacher for twelve years. After starting her independent consultancy ‘Crossover Solutions’ she has travelled to Argentina, Brazil and America to share her wealth of knowledge of computer science with other teachers. Her enjoyment for…
Find out more