Creating an Excel spreadsheet

All | IT & Computing | 11-16

Learning Objectives

  • To be able to organise a spreadsheet on excel.
  • To be able to use the SUM and AVERAGE functions on Excel.​​
  • To explain why spreadsheets are better than paper questionnaires.
  • To apply knowledge to create an excel spreadsheet for the Spirit scoring system in Ultimate frisbee.

Lesson Description

These two lessons guide students learning on several Microsoft Excel skills and the use of questionnaires.  The context of the SPIRIT scoring system of Ultimate frisbee will help students see a real-life use of how ICT skills can assist a sporting context.  



For immediate access to all of our free Key stage 3 and 4 STEM teaching resources.

1.Teaching Presentation
2.Student activity 1
3.Student activity 2
4.Teacher template 1
5.Teacher template 2


All, IT & Computing

Key Stage

Please login or register to discuss these resources.