Slide 1 of 7 · Settling starter · PE · Year 7
5 minutesFitness data tracking: comparing a whole class
A Year 7 class of 24 did 3 fitness tests: the bleep test, the standing long jump and sit-ups in 60 seconds. Nobody’s name is in the data. Every pupil has a code, P01 to P24. Today you describe the class, not individual pupils.
While the register is called: write your name, class and date on your worksheet, then read the data table. Find the highest and lowest value in each of the 3 columns and ring them.
Starter question: Which pupil code is highest in every column, and which is lowest in every column?
Slide 2 of 7 · Today’s brief and key words · PE · Year 7
2 minutesYour brief: average, spread, chart, conclusions
You will work out the average and the spread for each test, tally the bleep test into bands, draw a bar chart, and then write what the numbers do and do not prove.
Mean
The class average. Add up every value in the column and divide by 24.
Range
The spread. The largest value minus the smallest value in the column.
Band
A group of values, such as 6.0 to 6.9. Tallying into bands lets you draw a bar chart.
Anonymised
Names replaced by codes, P01 to P24, so nobody’s score is attached to their name.
Slide 3 of 7 · Task 1: average and spread · PE · Year 7
12 minutesTask 1: work out the mean, lowest, highest and range for each test
Work each column out to 1 decimal place. The range is the largest value minus the smallest. The first row is on the board as a model; fill in the other 2 rows yourself.
| Test | Class average (mean) | Lowest | Highest | Range |
|---|---|---|---|---|
| Bleep test level | 7.0 (the 24 levels add up to 168, and 168 ÷ 24 = 7) | 5.4 (P07) | 9.3 (P09) | 3.9 |
On a computer: =AVERAGE(B2:B25), =MIN(B2:B25), =MAX(B2:B25), and the range as =MAX(B2:B25)-MIN(B2:B25).
Slide 4 of 7 · Tasks 2 and 3: tally and bar chart · PE · Year 7
13 minutesTask 2 & Task 3: tally the bleep test into bands, then draw the bars
Tally every pupil’s bleep test level into a band. Check the tally totals 24 before you draw anything. Then draw 1 bar per band on the grid, label both axes and give the chart a title.
| Band | Tally | How many pupils | Which pupils |
|---|---|---|---|
| 5.0 to 5.9 | IIII | 4 | P03, P07, P13, P21 |
| 6.0 to 6.9 | IIII III | 8 | P01, P05, P08, P11, P15, P18, P20, P24 |
Chart: “Bleep test band” along the bottom, “Number of pupils” up the side, whole numbers 0 to 10, and a title that says what is being counted, for example Bleep test levels, 7B, 24 pupils, September.
Slide 5 of 7 · Task 4: what the data says · PE · Year 7
12 minutesTask 4: what the data does and does not prove
Answer (a) to (d) in full sentences.
(a) 2 things the data does show about this class. Use a number in each sentence.
(b) One test has a much wider spread than the others once you compare each range with its own average. Which, and what might explain it?
(c) 1 thing this data cannot tell you.
(d) Why is every pupil recorded as a code, P01 to P24, instead of by name?
Model sentence for (a): “The average bleep test level for the class is exactly 7.0, and 15 of the 24 pupils sit in the 2 middle bands, 6.0 to 6.9 and 7.0 to 7.9.”
Slide 6 of 7 · Step 5: self and partner check · PE · Year 7
3 minutesStep 5: swap sheets and tick the success criteria
Swap with a partner. Tick each criterion their sheet meets. Then take your sheet back and correct 1 thing.
- I can calculate a mean, a minimum, a maximum and a range from a real data set, and my 3 means are correct.
- I can group continuous data into bands and check the totals against the number of pupils.
- I can draw a bar chart with both axes labelled, a sensible scale and a title that says what is being counted.
- I can state a conclusion the data actually supports, using a figure from the table.
- I can say what a data set cannot tell you, and explain why fitness results are anonymised.
Slide 7 of 7 · Plenary review · PE · Year 7
3 minutesQuick-check answers before handing in
Check your main answers before your worksheets are collected.
| Question | Correct answer |
|---|---|
| What are the 3 class means? | Bleep test 7.0, standing long jump 171 cm, sit-ups 32. |
| How many pupils are in the 6.0 to 6.9 band, and what must the 5 bands total? | 8 pupils, and the bands must total 24. |
| Why are pupils recorded as codes instead of names? | A fitness score is personal information; codes stop the data being used to tease or rank individuals. |