Cover lesson · Geography · Year 8 · Intermediate

Modelling cliff retreat at Porth y Rhedyn

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 “Porth y Rhedyn: a cliff on the move”, one between two. Pupils need a pen and a calculator. No computers are needed: pupils design the spreadsheet on paper. If you are in a computer room, pupils who finish Step 5 may type their Step 4 design into a spreadsheet to check it.

Run: 4 min pupils read the stimulus in pairs · 5 min Step 1, why the cliff retreats · 5 min Step 2, break down the problem · 9 min Step 3, the retreat rate · 7 min Step 4, design the spreadsheet · 8 min Step 5, run the model · 9 min Step 6, test two scenarios · 10 min Step 7, test and evaluate, alone. Total 57 minutes.

Collect: this sheet. Steps 3, 5 and 6 are numeracy work and must show working: the mean retreat rate, time = distance ÷ rate, a 25% increase, a 60% decrease and rounding. Steps 2, 4 and 7 show the digital modelling. The village and all figures are invented. All answers are on the worked example.

What you are doing

The soft 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, so it can plan ahead. You will build a computer model of the cliff on paper, in the form of a spreadsheet, run it, try out two futures and decide how far it can be trusted.

Step 1: why the cliff retreats

Use section 2 of the stimulus. Explain each process in your own words.

ProcessHow it makes the cliff at Porth y Rhedyn retreat
Hydraulic action
Abrasion
Weathering
Slumping

Give two reasons why a boulder clay cliff retreats much faster than a cliff of hard rock.

Step 2: break down the problem

Every model has inputs (the data you start with), a rule (what the model does with them) and outputs (the answers you want).

InputsRuleOutputs

Write one thing your model will assume about the cliff that might not be true.

Step 3: the retreat rate

Use the survey record in section 4. Show your working in every row.

BetweenRetreat (m)YearsRate (m per year)
2002 and 200651.0 − 45.8 = 5.245.2 ÷ 4 = 1.3
2006 and 2010
2010 and 2014
2014 and 2018
2018 and 2022
2022 and 2026

(a) Work out the mean rate from 2002 to 2026: total retreat ÷ total years.

(b) Which period is very different from the rest? Use the surveyor’s note to explain why.

Step 4: design the spreadsheet

In a spreadsheet, a formula starts with = and uses cell names: =E5-F5 takes F5 away from E5, * means multiply and / means divide. A $ sign, as in $E$5, keeps a cell fixed when the formula is copied down. Write a formula in each empty cell of rows 3, 4, 5, 7 and 11.

ABCD
1Survey year20022026
2Distance M1 to edge (m)51.015.0
3Years between
4Total retreat (m)
5Mean rate (m per year)
6Scenario multiplier1
7Rate used (m per year)
9YearPath (m left)Caravans (m left)Road (m left)
10202672032
11

Row 11 is copied down to row 24 (the year 2040). Which one cell would you change to run a different scenario?

Step 5: run the model

Be the computer. Use the rate from Step 3. A feature is reached in the first year when the distance left is 0 m or less. Circle that year in each column.

YearPathCaravansRoadYearPathCaravansRoad
20267.020.032.02034
20272035
20282036
20292037
20302038
20312039
20322040
2033

The road and the houses are too far away to reach by 2040. Instead of adding rows, use time = distance ÷ rate. Round the years up to a whole number, because the model counts whole years. Show your working.

FeatureDistance (m)Time = distance ÷ rateRounded upYear reached
Road32
Houses56

Write the spreadsheet formula that would work out the years for the houses, using cell B7.

Step 6: test two scenarios

(a) More storms: work out a rate 25% faster than your mean rate. (b) Rock armour: work out a rate 60% slower. Show your working. Keep every digit until the final answer.

FeatureMore stormsRock armour
Time (years), workingYear reachedTime (years), workingYear reached
Path (7 m)
Caravans (20 m)
Road (32 m)
Houses (56 m)

(c) The rock armour lasts about 50 years. Which of your rock armour answers should the council not trust? Why?

Step 7: test and evaluate the model

(a) Imagine it is 2010 and you only have the 2002, 2006 and 2010 surveys. Work out the mean rate from those, then use it to predict the distance from M1 to the edge in 2026. Compare with the real 2026 survey.

(b) Write a short report for the council. Say how far the model can be trusted, give two of its assumptions and explain why each might be wrong, and suggest one way to improve the model.

Step by step

  1. 4 min Read the stimulus with a partner.
  2. 5 min Step 1: explain the four processes.
  3. 5 min Step 2: inputs, rule, outputs and one assumption.
  4. 9 min Step 3: work out the retreat rate, with working.
  5. 7 min Step 4: write the spreadsheet formulae.
  6. 8 min Step 5: run the model and use time = distance ÷ rate.
  7. 9 min Step 6: test the storm and rock armour scenarios.
  8. 10 min Step 7: test the model against 2026 and write your report, on your own.

Success criteria

If you finish early