Term 2 — Lessons 5–7 | Year 7

Lesson 5 — Data Modelling: Formulas

What you'll achieve: build a Premier League spreadsheet and calculate goal difference using a formula and autofill.

Excel

Formula: An instruction in a spreadsheet cell that starts with = and calculates a result.
SUM: A formula that adds up a group of numbers.
Average: The typical value in a group of numbers, found by adding them up and dividing by how many there are.
Autofill: Dragging the small fill handle to copy a formula down a column automatically.

I Do

Watch your teacher open a spreadsheet of Premier League clubs with columns for Club, Played, Won, Drawn, Lost, GoalsFor, GoalsAgainst and Points. See how =SUM totals the goals scored across every club, and how =AVERAGE works out the average points.

We Do

As a class, write a =MIN formula to find the fewest wins in the league.
Write a =MAX formula to find the most wins.
Discuss what each formula is actually doing to the numbers.

You Do

Open your own copy of the Premier League dataset.
Add a new column labelled "Goal Difference".
Write a formula that subtracts GoalsAgainst from GoalsFor for the first club.
Drag the fill handle down to autofill the formula for every club.
Use =MAX to find out which club has the best goal difference.

📊 Excel reference →

Before You Go

What did you learn today? Explain in your own words.

Name Year

Exit Ticket

Show what you've learned today.

Open Exit Ticket →

Lesson 6 — Charts That Tell a Story

What you'll achieve: compare a bar chart and a pie chart made from the same data and pick the one that best supports a headline.

Excel

Bar chart: A chart that uses bars to compare separate amounts side by side.
Pie chart: A circular chart split into slices to show how a total is shared out.
Data journalism: Using real data to support or check a news story or headline.

I Do

Watch your teacher build the same football data as two different charts: a bar chart of points, and a pie chart showing each club's share of total wins.

We Do

As a class, build a "which chart type" decision guide together: use a bar chart to compare exact amounts, and a pie chart to show how parts make up a whole — but only when there aren't too many slices.

You Do

Read the headline you've been given, e.g. "This team scored nearly a third of all goals this season!"
Decide whether a bar chart or a pie chart best supports that claim.
Build that chart in Excel using the football data.
Add a clear title and label your axes or legend.
Write one sentence explaining why you chose that chart type.

📊 Excel reference →

Before You Go

What did you learn today? Explain in your own words.

Name Year

Exit Ticket

Show what you've learned today.

Open Exit Ticket →

Lesson 7 — micro:bit — Loops & Light

What you'll achieve: build a heartbeat LED animation with a forever loop, then plan and code your own mood lamp.

micro:bitMakeCode

Loop: A block of code that repeats over and over.
Forever loop: A loop that keeps repeating for as long as the micro:bit is switched on.
pause (ms): A block that makes the micro:bit wait for a set number of milliseconds before continuing.

I Do

Watch your teacher drag out a forever loop and a pause (ms) block, and explain milliseconds — 1000ms is one second.

We Do

Build a heartbeat animation together: show a small heart icon, pause, show a big heart icon, pause.
Put the whole animation inside a forever loop so it repeats.

You Do

Plan your mood lamp first: what mood, what icons or LEDs, what timing?
Fill in the short planning grid before you start coding.
Build your mood lamp programme using a forever loop.
Use pause (ms) blocks to control the timing of your mood.
Download it to your micro:bit and test it.

💡 micro:bit reference →

Before You Go

What did you learn today? Explain in your own words.

Name Year

Exit Ticket

Show what you've learned today.

Open Exit Ticket →