Popular searches in the last week:

2026, 2027, 2025, plants, english, time, poetry, history, forces, science

Create your own sports performance spreadsheet

Topics Year 4/5
This unit is part of Computational Thinking and Creativity Spreadsheets and Databases

Download all files

Objectives

Computing

  • Use Excel to analyse, evaluate and present data and information.
  • Be responsible, competent, confident and creative users of ICT.
  • Evaluate and apply IT, including new or unfamiliar technologies, analytically to solve problems.

Maths

  • Complete, read and interpret information in tables.
  • Use simple formulae.

PE

  • Compare performances with previous ones and demonstrate improvement to achieve their personal best.

Lesson Planning

Are you the next big thing in football? Develop and create a personal spreadsheet to record and track your running performance in PE.

Teaching Outcomes:

  • To create a spreadsheet to track and demonstrate sports performance.
  • To create spreadsheet formulae to track sports performance.
  • To record current running performance and set goals for improving this.

Children will:

  • Create a spreadsheet to track and demonstrate improvement in PE performance.
  • Develop formulae to help track performance.
  • Begin to compare personal performances.

Provided Resources

  • Instructions for setting up an Excel spreadsheet
  • Excel formatting skills cards

You Will Need

  • Outdoor running space marked out
  • Stopwatch

Log in or sign up to get access to this resource

School Subscription

Reduce teacher workload

From £200 (+ VAT) per year. Access to all key stages for multiple users.

Sign up

Individual Subscription

For inspirational teaching

Just £60 (£50 + VAT) per year to get access to all resources.

Sign up

Early Career Teacher

Develop your teaching

Just £42 (£35 + VAT) to get access to all resources for 2 years.

Sign up

Taster Account

100s of resources

Register to access all free resources.

Sign up

Already subscribed?

Log in to get access.