Cover lesson · Geography · Year 8 · Intermediate
DCF: Data and computational thinking → Problem-solving and modelling
Name: Class: Date:
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.
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.
Use section 2 of the stimulus. Explain each process in your own words.
| Process | How 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.
Every model has inputs (the data you start with), a rule (what the model does with them) and outputs (the answers you want).
| Inputs | Rule | Outputs |
|---|---|---|
Write one thing your model will assume about the cliff that might not be true.
Use the survey record in section 4. Show your working in every row.
| 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 | |||
| 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.
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.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Survey year | 2002 | 2026 | |
| 2 | Distance M1 to edge (m) | 51.0 | 15.0 | |
| 3 | Years between | |||
| 4 | Total retreat (m) | |||
| 5 | Mean rate (m per year) | |||
| 6 | Scenario multiplier | 1 | ||
| 7 | Rate used (m per year) | |||
| 9 | Year | Path (m left) | Caravans (m left) | Road (m left) |
| 10 | 2026 | 7 | 20 | 32 |
| 11 |
Row 11 is copied down to row 24 (the year 2040). Which one cell would you change to run a different scenario?
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.
| Year | Path | Caravans | Road | Year | Path | Caravans | Road |
|---|---|---|---|---|---|---|---|
| 2026 | 7.0 | 20.0 | 32.0 | 2034 | |||
| 2027 | 2035 | ||||||
| 2028 | 2036 | ||||||
| 2029 | 2037 | ||||||
| 2030 | 2038 | ||||||
| 2031 | 2039 | ||||||
| 2032 | 2040 | ||||||
| 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.
| Feature | Distance (m) | Time = distance ÷ rate | Rounded up | Year reached |
|---|---|---|---|---|
| Road | 32 | |||
| Houses | 56 |
Write the spreadsheet formula that would work out the years for the houses, using cell B7.
(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.
| Feature | More storms | Rock armour | ||
|---|---|---|---|---|
| Time (years), working | Year reached | Time (years), working | Year 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?
(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.