Cover lesson · Geography · Year 11 · Advanced
DCF: Data and computational thinking → Problem-solving and modelling
Name: Class: Date:
Print: this sheet, one per pupil, and the stimulus sheet “Pont-rhaf flood options briefing”, one between two. No computers are needed, but every pupil needs a calculator. If you are in a computer room, the model inputs are in pont-rhaf-flood-model.csv and the spreadsheet formulae are given in Step 3.
Run: 5 min read sections 1–3 of the briefing aloud and do Step 1 · 10 min Step 2, today's flood damage · 15 min Step 3, the four options · 10 min Step 4, the weighted matrix · 8 min Step 5, the what-if scenario · 10 min Step 6, recommendation and evaluation.
Collect: this sheet. The town and the figures are invented, so the answer key on the worked example is the only correct set of numbers. There is no single right recommendation, but it must follow from the pupil's own figures.
Pont-rhaf has £2.0 million to spend on flood protection and four ways to spend it. You are going to build a model that turns flood chances into money, and use it to compare the options fairly. Then you will add the things money cannot measure and test whether your answer survives a wetter future. Decisions like this are made about real Welsh towns. The model is the tool, not the answer.
(a) Zone 1 flooded last winter. A resident says: “That was our 1-in-10-year flood, so we're safe for nine years.” Explain what is wrong with this.
(b) Zone 1's chance of not flooding in any one year is 1 − 0.1 = 0.9. The chance of no flood in ten years in a row is 0.9 multiplied by itself ten times. Work out the chance that Zone 1 floods at least once in the next ten years, as a percentage.
The expected annual damage (EAD) is what flooding costs on average each year, over a very long time. For each zone:
| Zone | Homes | Annual chance | Damage per home (£) | EAD today (£ per year) |
|---|---|---|---|---|
| 1 | 40 | 0.1 | 30,000 | |
| 2 | 60 | 0.02 | 30,000 | |
| 3 | 100 | 0.005 | 30,000 | |
| Total EAD if the council does nothing | ||||
Which zone costs the town most each year, even though it has the fewest homes? Why?
Use the new chances and damage figures from section 4 of the briefing. Only the inputs change; the formula stays the same.
Spreadsheet users: in the CSV, put =D2*C2*E2 in F2 and fill down to F16. Then total each option with, for example, =SUMIF(A2:A16,"A - flood wall",F2:F16).
| Option | Zone 1 | Zone 2 | Zone 3 | Total EAD |
|---|---|---|---|---|
| A — wall | ||||
| B — natural | ||||
| C — resilience | ||||
| B+C |
| Option | Annual benefit (£) | 50-year benefit (£) | 50-year cost (£) | BCR (2 d.p.) | Up-front cost within £2.0m? |
|---|---|---|---|---|---|
| A — wall | |||||
| B — natural | |||||
| C — resilience | |||||
| B+C |
A BCR above 1 means the option prevents more damage than it costs. Which option gives the best value for money, and why might that still not be the right choice?
Score value for money from your BCR, and score “homes still flooded in a 1-in-50-year flood” by working out which zones still flood in a flood of that size. Use the rules in section 5 of the briefing and copy the other three scores from it. Then work out each stakeholder's weighted total (score × weight, added up).
| Option | Homes still flooded in a 1-in-50 | Value score | Homes score | Environment | How soon | Community | Finance officer total | Residents' total | Ecologist total |
|---|---|---|---|---|---|---|---|---|---|
| A — wall | |||||||||
| B — natural | |||||||||
| C — resilience | |||||||||
| B+C |
Which option does each stakeholder prefer? Is any stakeholder's favourite ruled out by the budget?
Use the what-if scenario in section 7 of the briefing: double every annual chance and run the model again for doing nothing, Option A and Option B+C. Costs do not change.
| Doubled chances | Total EAD (£ per year) | Annual benefit (£) | 50-year benefit (£) | BCR (2 d.p.) |
|---|---|---|---|---|
| Do nothing | — | — | — | |
| A — wall | ||||
| B+C |
Does the scenario change which of these two options is better value? Does it change whether the wall is worth building, or whether it can be afforded?
Paragraph 1: recommend one option to the council. Use at least three pieces of evidence from Steps 3 to 5, and say who will be disappointed and why.
Paragraph 2: name three ways this model is simpler than reality. For each one, say whether it makes the options look better or worse than they really are.