Summer Term

How can data be used to model information?

Spreadsheets - Lower Ability 2025

Booklet[1].pdf

Help Sheets to Support

Slides - Year 7 - Modelling Data - Spreadsheets - Lesson 1

Starter Activity - Olympic medals

Activity 1 - Bingo game

Activity 2 - Pixel art flags

Activity 2 - Spreadsheet-friendly flags

Slides - Year 7 - Modelling Data - Spreadsheets - Lesson 2

All activities

Slides - Year 7 - Modelling Data - Spreadsheets - Lesson 3

Starter activity - Formulas recap

Plenary - Word matching

Slides - Year 7 - Modelling Data - Spreadsheets - Lesson 4

Starter activity – Cake popularity

Activity 1 – Sports day fundraiser

Activity 2 - Party planning

Slides - Year 7 - Modelling Data - Spreadsheets - Lesson 5

Activity 2 - Olympic data questions

Activity 2 - Olympic medal data

Activity 2 - Premier League data questions

Activity 2 - Premier League data

Activity 2 - YouTube data questions

Activity 2 - YouTube data

Slides - Year 7 - Modelling Data - Spreadsheets - Lesson 6

Activity 1 - Conditional formatting

Assessment – UK forestry data

How can you use a spreadsheet to plan and create a budget?

Student Reward Shop Purchases

Budget - £250

Create a spreadsheet with the following:

Labels: Product Name, Cost, Amount of Items and Weblink

Extended Task - Add a totals column and overall total using SUM function

Shop Purchases 2025

Challenges

Wizard's_Challenge

Crack the Code

Magic number

The Train Journey

creating_spells

Formula Practice

Page updated

Report abuse