Computational Thinking and Creativity

Block C - Spreadsheets and Databases

Understand the timeline of the main developments since the invention of the World Wide Web. Learn about the great creative minds and internet entrepreneurs who have contributed to the biggest innovations. Be inspired and solve your own challenges! Create webpages, develop a fantasy football database, use 3D modelling software, design a stop motion animation, create your own computer game and much more!

The Premier League and Women’s Super League need your help! Analyse their spreadsheets on team and individual performances then create one to track and analyse your own performance. Can you develop a fantasy football database then select your own ‘fantasy team’ to compete in your in-house league?

This Topic is written for Upper Key Stage 2. If you want to use this Topic for a different Key Stage, you will need to consider how to adapt the outcomes, content, delivery methods, resources and differentiation, as well as the relevant National Curriculum objectives.

Supporting documents for topic
  • Week
  • Title
  • Download
+ Details
01: Spreadsheets in sport

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.

+ Details
02: Create your own sports performance spreadsheet

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

+ Details
03: Design your own fantasy team sports database

You have been challenged to set up your own database of top footballer performers to help create your own fantasy football team.

+ Details
04: Choose your team

Add in your performance data on football players to your new database. Try it out and select your own fantasy ‘team’ to follow. Will your team win the league? Can you now share all of your data in sports know-how in a ‘masterclass’ for your friends?