AdvertisementYour brand could be hereYour brand hereOn every Darslab page · students, parents and teachersinfo@darslab.comAsk for pricesPricesinfo@darslab.com
☰ Year plan · Computing

Models and choices

Week 15 · 2.1 Spreadsheets and analysing data · 3 lessons
1

Is the model worth it?

Computing 9: Topic 2.1, pp. 168–197
GoalWeigh the benefits and drawbacks of a spreadsheet model, and test it with ordinary and unusual data.
New words
model · a representation of a real object or system, used to study it or to predict how it will behavewhat-if analysis · changing one value in a model to see how the results changescenario · one situation, with its own set of values, that is tried in a model
Explanation

A model is a simplified copy of something real. It can be a physical object, such as a model boat, or a set of numbers and formulas in a spreadsheet. People use models because trying an idea on a model is cheaper and safer than trying it for real, and because you can ask what-if questions again and again. Models also have drawbacks. Testing takes time and sometimes money, and a model cannot copy everything, especially when nobody knows enough about the real thing. A model can also be wrong in a place where it was not built to be used. The results of a model can be no better than the data put into it, so test it with ordinary values, extreme values and unusual values, and check that the results are sensible.

Benefits of a modelDrawbacks of a model
cheaper than a real trialtakes time to build and test
safer for people and equipmenttesting may cost money
what-if questions are quicknot enough is known about some real things
mistakes show up before buildingmay fail in places it was not designed for
Worked examples
B4fx=B2*B3
AB
1ItemValue
2Roof area (m²)40
3Rain (mm)25
4Water collected (litres)1000
A tank model. A school wants to know how much rainwater a roof can collect. One millimetre of rain falling on one square metre of roof gives one litre. The roof is 40 m² and the rain is 25 mm, so the model in B4 calculates 40 × 25 = 1000 litres.
ScenarioRoof (m²)Rain (mm)Litres collected
dry spell4000
light rain4010400
usual rain40251000
storm40602400
What-if questions. Only the rain in B3 is changed each time, and everything else stays the same. The results are 400 litres for 10 mm, 0 litres for 0 mm, and 2400 litres for 60 mm. Changing one value at a time shows which input has the effect.
B5fx=B2*B3
AB
1ItemValue
2Roof area (m²)40
3Rain (mm)25
4Tank size (litres)800
5Water collected (litres)1000
Testing finds a weakness. The school’s tank holds only 800 litres, but the model says that 1000 litres were collected. The model does not know that a tank has a limit, so it gives an impossible answer. A model that is tested with many scenarios shows up gaps like this before anybody trusts it.
Class activity

Model the classroom (no computer). Build a small model on paper: a table that shows how many glasses of water a class of pupils drinks in a day, from the number of pupils and the glasses per pupil. Try three what-if scenarios by changing one number at a time. Then list two things that your model leaves out, such as visitors or hot days, and decide whether leaving them out matters.

Practice
1
Use the tank model. The roof is 60 m² and the rain is 15 mm. How many litres are collected? What if the rain doubles? What if the roof area is halved and the rain is 15 mm?
B4fx=B2*B3
AB
1ItemValue
2Roof area (m²)60
3Rain (mm)15
4Water collected (litres)?
2
Say whether each is a benefit or a drawback of using a model. (a) Testing a new layout for a school pond on a model costs very little. (b) Little is known about a rare insect, so the model is partly guesswork. (c) One hundred settings can be tried in an hour. (d) A model of a pond in summer is used to predict the pond in winter.
3
A learner tests the tank model with a 40 m² roof and 500 mm of rain, and the model says that 20000 litres were collected by an 800-litre tank. What is wrong, and what should the learner do next?
4
Why is it not enough to test a model with only usual values?