Cover lesson · Geography · Year 11 · Advanced

Flood risk decision modelling

DCF: Data and computational thinking → Problem-solving and modelling

Name: Class: Date:

Cover teacher — you need no subject knowledge

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.

What you are doing

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.

Step 1 — what does “1-in-10” mean?

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

Step 2 — the model: today's flood damage

The expected annual damage (EAD) is what flooding costs on average each year, over a very long time. For each zone:

EAD = annual chance × number of homes × damage per flooded home
Zone Homes Annual chance Damage per home (£) EAD today (£ per year)
1400.130,000
2600.0230,000
31000.00530,000
Total EAD if the council does nothing

Which zone costs the town most each year, even though it has the fewest homes? Why?

Step 3 — run the model for each option

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

3a — expected annual damage with each option (£ per year)

Option Zone 1 Zone 2 Zone 3 Total EAD
A — wall
B — natural
C — resilience
B+C

3b — benefits and costs over 50 years

annual benefit = EAD if we do nothing − EAD with the option 50-year benefit = annual benefit × 50 50-year cost = up-front cost + (yearly upkeep × 50) benefit–cost ratio = 50-year benefit ÷ 50-year cost
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?

Step 4 — add what money cannot measure

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 Environ­ment How soon Commu­nity 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?

Step 5 — test the model: a wetter future

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?

Step 6 — recommend and evaluate

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.

Step by step

  1. 5 min — Read sections 1–3 of the briefing. Answer Step 1.
  2. 10 min — Step 2: expected annual damage for each zone today, and the total.
  3. 15 min — Step 3: run the model for all four options, then work out benefits, costs and BCRs.
  4. 10 min — Step 4: score each option and work out the three stakeholders' weighted totals.
  5. 8 min — Step 5: double the chances and run the model again.
  6. 10 min — Step 6: write your recommendation and your evaluation of the model.

Success criteria

If you finish early