Slide 1 of 7 · Settling starter · Science · Year 8
4 minutesModelling a bike ride with speed formulae
Year 8 at Ysgol Cwm Gwyn are planning a 30 km sponsored bike ride along Llwybr Cwm Gwyn for the mountain rescue team. Ms Pritchard needs to know how long it will take, what time the group will arrive and whether they will catch the minibus home. You will answer that by building a model: a spreadsheet on paper that you can run, test and change.
While the register is called: write your name, class and date on your worksheet, then read the stimulus sheet. Underline the start time, the minibus time and the weather forecast.
Starter question: What time does the ride start, what time does the minibus leave, and which section does the wind affect?
Slide 2 of 7 · Today’s brief and key words · Science · Year 8
2 minutesYour brief: build the model, run it, test it, break it, fix it
You will write the speed formula in words, symbols and spreadsheet formulae, design the model, run it to find the arrival time, test it against a real practice ride, fix Elis’s broken version, ask “what if?” about the wind and the café stop, and say where the model falls short.
Speed formula
Speed = distance ÷ time, so s = d / t. Rearranged: d = s × t and t = d / s.
Model
A simplified version of the ride you can run, test and change. Here, a spreadsheet with 1 row per section.
Cell reference
A formula such as =B2/C2 uses the cells, not typed numbers, so changing 1 input updates the whole model.
Substitute
Put the numbers into the formula with their units: 9 km ÷ 12 km/h = 0.75 h.
Slide 3 of 7 · Steps 1 and 2: symbols, then the design · Science · Year 8
15 minutesStep 1 & Step 2: speed in symbols, then design the model
Step 1 (8 min): (a) the speed formula in words and symbols; (b) rearrange for d and for t; (c) complete the table below; (d) the 5 time conversions; (e) convert 18 km/h to m/s, showing each step.
Step 2 (7 min): (a) why break the ride into 5 sections; (b) the 5 headings with units and the formulae for D2, E2, B7, E7 and B9; (c) what D2 becomes when copied down to D4.
| In words | In symbols | As a spreadsheet formula |
|---|---|---|
| Time in hours = distance ÷ speed | t = d / s | =B2/C2 |
| Time in minutes = time in hours × 60 | minutes = 60 × t | =D2*60 |
Slide 4 of 7 · Steps 3 and 4: run it, then test it · Science · Year 8
17 minutesStep 3 & Step 4: be the spreadsheet, then test it against the practice ride
Step 3 (10 min): copy the 5 distances and planned speeds from the stimulus, work out every time in hours and minutes, and the totals. Then (a) full working for section 3 with units, (b) the arrival time from a 09:30 start, (c) the average speed in B9 and why it is not simply 12 km/h.
Step 4 (7 min): use the practice ride graph. (a) Steepest part, and what happened between P and Q. (b) Real speeds for O to P and Q to R. (c) Which section is wrong, which cell to change, and the new total.
| Row | A: Section | B: Distance (km) | C: Speed (km/h) | D: Time (h) | E: Time (min) |
|---|---|---|---|---|---|
| 2 | 1 | 6 | 15 | 0.40 | 24 |
| 3 | 2 | 4.5 | 9 | 0.50 | 30 |
Slide 5 of 7 · Steps 5 to 7: debug, what if, limits · Science · Year 8
18 minutesStep 5, Step 6 & Step 7: fix Elis’s model, ask what if, and find the limits
Step 5 (6 min): Elis’s spreadsheet on the stimulus sheet has 2 wrong formulae. (a) Which cell in column D, what did it really calculate, and the correct formula. (b) What E7 leaves out. (c) Convert D7 to minutes and explain how that check finds the errors.
Step 6 (8 min): start from your correct Step 3 model each time. Fill the what-if table, write the heading for column F and the new E7, then decide whether the group catches the 13:00 minibus and prove 1 fix. Step 7 (4 min): 2 ways the real ride differs from a constant speed per section, and how each changes the prediction.
| What if… | Cell changed or added | New total time | New arrival time |
|---|---|---|---|
| 1. The headwind halves the speed on section 3 | C4 changed from 12 to 6. D4 = 9 ÷ 6 = 1.5 h = 90 min | 154 − 45 + 90 = 199 min (3 h 19 min) | 12:49 |
Slide 6 of 7 · Self and partner check · Science · Year 8
2 minutesCheck your work as if you were Ms Pritchard
Tick each success criterion you have met. Then correct 1 thing: the most common slip is a number substituted without its unit.
- I can write the speed formula in symbols, rearrange it for distance and time, and translate between words, symbols and spreadsheet formulae.
- I substituted values with their units and converted correctly between hours and minutes, and between km/h and m/s.
- I broke the ride into sections, designed a model with headings, units and formulas that work when copied down, and ran it to predict the total time and arrival time.
- I tested the model against a distance-time graph, explained what the slope and a flat line show, and said which input to change.
- I found and fixed the errors in someone else’s model and used a check to catch them.
- I changed inputs to answer “what if?” questions and explained the assumptions that could make the model wrong.
Slide 7 of 7 · Plenary review · Science · Year 8
2 minutesQuick-check answers before handing in
Check your main answers before your worksheets are collected.
| Question | Correct answer |
|---|---|
| How long does the planned ride take, and what time does the group arrive? | 154 minutes (2 h 34 min), arriving at 12:04. |
| Which formula in Elis’s column D is wrong, and what should it be? | D4 says =C4/B4 (speed ÷ distance); it should be =B4/C4. |
| With the headwind and the 20 minute stop, do they catch the 13:00 minibus? | No: 219 minutes gives 13:09. Starting at 09:15 gives 12:54. |