Cover lesson · MFL · Year 9 · Advanced
LNF: Numeracy → Learning that statistics represent data and that probability models chance helps us make informed inferences and decisions → Interpreting data · DCF: Data and computational thinking → Data and information literacy
Name: Class: Date:
What this practises: interpreting multi-variable travel data in French. Pupils compare 3 ways for a Year 9 exchange group of 30 pupils to travel from Cardiff to Paris (coach and ferry, train and Eurostar, and plane). They calculate journey durations across the 1-hour time-zone change (GMT to CET), total CO2 per pupil and for the group of 30, and cost per pupil in euros and pounds, then write 4 comparative sentences in French using plus ... que, moins ... que and parce que.
Board: open the supply teacher presentation Comparing Transport Carbon Footprints and Timetables in French for slides, timers and script.
Print: this worksheet, one per pupil, and the stimulus sheet Voyage scolaire Cardiff-Paris : horaires, prix et bilan carbone (CO2), one between two. Calculators are recommended. No computers are needed.
Run: 5 min settling starter · 5 min brief and key words · 10 min Step 1, timetable durations across GMT to CET · 10 min Step 2, CO2 and cost calculations for 30 pupils · 12 min Steps 3 and 4, data interpretation and 4 comparative sentences in French · 5 min partner check · 3 min plenary review. Total 50 minutes.
Collect: this worksheet at the end of the lesson.
Quick checks: Step 1 real durations (after subtracting 1 hour from Paris CET arrival): Option A 12 h 30 min (06:00 to 18:30 GMT); Option B 6 h 15 min (07:15 to 13:30 GMT); Option C flight only 1 h 30 min (10:20 to 11:50 GMT), plus 3 h check-in/transfers = 4 h 30 min door to door. Step 2 (Group CO2 / Price in £ per pupil / Group cost in £): Option A 1,260 kg / £90.00 / £2,700.00; Option B 540 kg / £130.00 / £3,900.00; Option C 5,940 kg / £150.00 / £4,500.00. Step 3: Option C breaks both the £135 budget cap and the 1,500 kg CO2 cap (emitting 11 times as much CO2 as the train); Option B meets both caps and is twice as fast as the coach.
Planning an international school exchange means balancing three competing factors: journey time across time zones, ticket price and environmental impact (carbon footprint). Today you will analyse a French travel dossier for 30 Year 9 pupils travelling from Cardiff to Paris, calculate the real durations, costs and CO2 totals, and justify the best option in French.
Key words:
£1.00 = 1,20 €, divide the euro cost by 1.20 to find the cost in pounds.Use Part A of the stimulus sheet. First convert each Paris arrival time from CET into UK time (GMT) by subtracting 1 hour, then calculate the real travel duration and the total door-to-door time.
| Transport option | Departs Cardiff (GMT) | Arrives Paris (CET) | Arrives Paris in GMT (−1 h) | Travel duration | Door-to-door duration (with check-in/transfers) |
|---|---|---|---|---|---|
| A: Le car et le ferry | 06:00 | 19:30 | 18:30 | 12 h 30 min | 12 h 30 min (no extra wait) |
| B: Le train et l’Eurostar | 07:15 | 14:30 | |||
| C: L’avion (add 3 h transfers) | 10:20 | 12:50 |
What mistake would a pupil make if they forgot the time-zone change when working out the train duration from 07:15 to 14:30?
Use Part B of the stimulus sheet. Multiply by 30 for the group totals, and divide the euro price by 1.20 to convert into pounds (£).
| Option | CO2 per pupil (kg) | Total CO2 for 30 pupils (kg) | Price per pupil (€) | Price per pupil (£) | Total cost for 30 pupils (£) |
|---|---|---|---|---|---|
| A: Coach + Ferry | 42 kg | 108 € | |||
| B: Train + Eurostar | 18 kg | 540 kg | 156 € | £130.00 | £3,900.00 |
| C: Plane | 198 kg | 180 € |
Use the glossary and sentence builder in Parts C and D of the stimulus sheet. Write 4 complete sentences in French comparing the options and recommending the best choice for the school. You must use plus ... que at least twice, moins ... que at least twice, parce que in every sentence, and quote your figures from Steps 1 and 2.