Popular searches in the last week:

2026, 2027, 2025, english, history, forces, plants, 2023, science, instructions

Spreadsheets in sport

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.
  • Construct pie charts and line graphs; use simple formulae.

Lesson Planning

The Premier and Super Leagues want you to explore their performance tracking spreadsheets. Understand why and how formulae are created, and manipulate the data to represent it graphically for each sporting league.

Teaching Outcomes:

  • To explore, analyse and manipulate sports data spreadsheets, suggesting why the information is useful and presenting it in different ways.
  • To use and create simple formulae for spreadsheets; manipulate a sports data spreadsheet to create graphic representations.

Children will:

  • Explore football data spreadsheets and suggest why the information is useful.
  • Learn how to create formulas for spreadsheets.
  • Manipulate a football spreadsheet to create simple graphic representations.

You Will Need

You do not need any particular resources for this session.

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.