Models and choices
Answers are for parents and teachers.
1
A model is used to plan how much paint a school needs for its classrooms. Give two benefits and two drawbacks of using the model before ordering the paint.
Benefits: a wrong order is found before money is spent; several what-if sizes can be tried quickly. Drawbacks: the model may leave out uneven walls or doors; testing it takes time, and the real paint use may differ from the model.
2
A scooter hire shop charges 5 an hour, but only 4 an hour if the scooter is hired for more than 3 hours. The hours are in B2:B5, and the formula in C2 is =IF(B2>3,B2*4,B2*5). Work out the four costs.
| A | B | C | |
|---|---|---|---|
| 1 | Customer | Hours | Cost |
| 2 | a | 2 | ? |
| 3 | b | 3 | ? |
| 4 | c | 4 | ? |
| 5 | d | 6 | ? |
2 hours cost 10. 3 hours cost 15, because 3 is not more than 3. 4 hours cost 16. 6 hours cost 24.
3
Baggage costs depend on the mass in B2: up to and including 7 kg is free (0), over 7 kg and up to 15 kg costs 20, and over 15 kg costs 40. Write the formula and work out the cost for 5, 7, 7.5, 15 and 16 kg.
=IF(B2<=7,0,IF(B2<=15,20,40)). 5 kg costs 0. 7 kg costs 0. 7.5 kg costs 20. 15 kg costs 20. 16 kg costs 40.
4
This formula should show Cold below 10, Mild below 22 and Hot otherwise, but it does not work: =IF(B2<10,Cold,IF(B2<22,"Mild","Hot") Find both faults.
The word Cold needs double quotation marks, and the closing bracket for the first IF is missing at the end. Repaired: =IF(B2<10,"Cold",IF(B2<22,"Mild","Hot")).
5
Explain what filling a formula down does. Use the formula =B2*4 in C2 filled to C3 and C4 as your example.
Filling copies the formula into the cells below, and each copy keeps the same shape, but its row numbers move down. C3 holds =B3*4 and C4 holds =B4*4. This saves retyping and makes every row follow the same rule.