Slide 1 of 7 · Settling starter · Geography · Year 8
4 minutesModelling cliff retreat at Porth y Rhedyn
The soft boulder clay cliff at Porth y Rhedyn is being eaten away by the sea. The council needs to know when the cliff edge will reach the coast path, the caravan park, the lifeboat station road and the houses. Today you build a spreadsheet model of the cliff on paper, run it, and decide how far it can be trusted.
While the register is called: write your name, class and date on your worksheet, then read the stimulus sheet with your partner. Look hard at section 2 and the survey record in section 4.
Starter question: In 2026, how far is it from the cliff edge to the coast path, and how far to the houses of Heol y Môr?
Slide 2 of 7 · Today’s brief and key words · Geography · Year 8
2 minutesYour brief: build a model, run it, test it, trust it the right amount
You will explain why the cliff retreats, break the problem into inputs, a rule and outputs, work out the mean retreat rate, write spreadsheet formulae on paper, run the model year by year, test 2 scenarios and write a short report for the council.
Model
A simplified copy of the real cliff made of inputs (the data), a rule (what the model does with them) and outputs (the answers).
Retreat rate
How far the cliff edge moves inland each year, in metres per year. Total retreat ÷ total years.
Assumption
Something the model takes to be true that might not be, such as the cliff losing the same amount every year.
Scenario
A possible future you test by changing 1 input: more storms (25% faster) or rock armour (60% slower).
Slide 3 of 7 · Steps 1 and 2: why it retreats, and the problem broken down · Geography · Year 8
9 minutesStep 1 & Step 2: explain the 4 processes, then inputs, rule, outputs
Step 1 (5 min): use section 2 of the stimulus. Explain hydraulic action, abrasion, weathering and slumping in your own words, then give 2 reasons why boulder clay retreats much faster than hard rock.
Step 2 (4 min): fill in the inputs, rule and outputs table, then write 1 thing the model will assume that might not be true.
| Process | How it makes the cliff at Porth y Rhedyn retreat |
|---|---|
| Hydraulic action | Big waves from the south-west hit the cliff foot and force water and air into cracks. The pressure breaks lumps of clay off. |
Slide 4 of 7 · Steps 3 and 4: the rate, then the spreadsheet · Geography · Year 8
15 minutesStep 3 & Step 4: work out the retreat rate, then write the formulae
Step 3 (9 min): use the survey record in section 4. Show working in every row, then (a) the mean rate 2002 to 2026 and (b) the period that is very different, explained with the surveyor’s note.
Step 4 (6 min): write a formula in each empty cell of rows 3, 4, 5, 7 and 11. A formula starts with =, * multiplies, / divides, and $B$7 keeps B7 fixed when copied down. Name the 1 cell you would change to run a different scenario.
| Between | Retreat (m) | Years | Rate (m per year) |
|---|---|---|---|
| 2002 and 2006 | 51.0 − 45.8 = 5.2 | 4 | 5.2 ÷ 4 = 1.3 |
| 2006 and 2010 | 45.8 − 40.2 = 5.6 | 4 | 5.6 ÷ 4 = 1.4 |
Slide 5 of 7 · Steps 5 to 7: run, test, evaluate · Geography · Year 8
23 minutesStep 5, Step 6 & Step 7: be the computer, test 2 futures, write the report
Step 5 (8 min): take 1.5 m off each column every year. Circle the first year each feature has 0 m or less. For the road and houses use time = distance ÷ rate, rounded up.
Step 6 (8 min): work out a rate 25% faster and a rate 60% slower, with working. Fill in the scenario table, then (c). Step 7 (7 min, alone): test the model using only the 2002, 2006 and 2010 surveys, then write your report for the council.
| Year | Path | Caravans | Road |
|---|---|---|---|
| 2026 | 7.0 | 20.0 | 32.0 |
| 2027 | 5.5 | 18.5 | 30.5 |
Slide 6 of 7 · Self and partner check · Geography · Year 8
2 minutesCheck your work as if you were the council engineer
Tick each success criterion you have met. Then correct 1 thing: the most common slip is rounding years down instead of up.
- I can explain why a boulder clay cliff retreats quickly, using hydraulic action, abrasion, weathering and slumping.
- I broke the problem into inputs, a rule and outputs, and named an assumption.
- I calculated the mean retreat rate from the survey data and showed my working.
- I designed a spreadsheet model on paper with correct formulae and ran it year by year.
- I used time = distance ÷ rate, a percentage increase and decrease, and rounded sensibly.
- I tested my model against a real survey and evaluated its assumptions and limits.
Slide 7 of 7 · Plenary review · Geography · Year 8
2 minutesQuick-check answers before handing in
Check your main answers before your worksheets are collected.
| Question | Correct answer |
|---|---|
| What is the mean retreat rate from 2002 to 2026? | 36.0 m ÷ 24 years = 1.5 m per year. |
| In which year does the model say the coast path is reached, and the houses? | Path 2031, houses 2064 (56 ÷ 1.5 = 37.33, rounded up to 38). |
| Which 1 cell do you change to run the rock armour scenario, and to what? | B6, set to 0.4 (1.25 for more storms). |