Supply teacher deck · Science · Year 8

Modelling a Bike Ride with Speed Formulae

Slide 1 of 7
04:00

Slide 1 of 7 · Settling starter · Science · Year 8

4 minutes

Modelling 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?

DCF: Data and computational thinking → Problem-solving and modelling Calculator needed · no computers needed

Slide 2 of 7 · Today’s brief and key words · Science · Year 8

2 minutes

Your 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.

LNF: Numeracy → Developing mathematical proficiency → Communicating with symbols Keep units on every number you substitute

Slide 3 of 7 · Steps 1 and 2: symbols, then the design · Science · Year 8

15 minutes

Step 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
Steps 1 and 2 on your worksheet · 15 minutes Distance in B2, speed in C2, time in hours in D2

Slide 4 of 7 · Steps 3 and 4: run it, then test it · Science · Year 8

17 minutes

Step 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
Steps 3 and 4 on your worksheet · 17 minutes Target: 154 minutes and 12:04. Different numbers mean a slip in Step 3

Slide 5 of 7 · Steps 5 to 7: debug, what if, limits · Science · Year 8

18 minutes

Step 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
Steps 5, 6 and 7 on your worksheet · 18 minutes Use your Step 3 model, not the Step 4 change

Slide 6 of 7 · Self and partner check · Science · Year 8

2 minutes

Check 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.
2 minutes · self check Finished early? Try the extension questions at the bottom of your sheet

Slide 7 of 7 · Plenary review · Science · Year 8

2 minutes

Quick-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.
Check your name and class are on your worksheet Leave stimulus sheets and calculators neat on the desk