Models and decisions
Answers are for parents and teachers.
1
Choose a spreadsheet or a database for each job and give a reason: (a) the scores and total points of five teams in a quiz, (b) a list of the pupils in the school choir with their class and voice type, so that the teacher can find all sopranos, (c) the monthly cost of a family’s electricity bills.
(a) Spreadsheet: adds numbers. (b) Database: records that are searched with a query (VoiceType = Soprano). (c) Spreadsheet: numbers and totals or averages.
2
Use the model: cost per kit is 4, the price is 7 and 25 kits are sold. What is the profit? What happens to the profit if the price changes to 6? Which price would give a profit of 100?
| A | B | |
|---|---|---|
| 1 | Cost per kit | 4 |
| 2 | Price per kit | 7 |
| 3 | Kits sold | 25 |
| 4 | Profit | ? |
Profit = 25 × (7 − 4) = 75. At 6 it is 25 × 2 = 50. A profit of 100 needs 25 × (price − 4) = 100, so price − 4 = 4 and the price is 8.
3
Rustam says: ‘The cake-sale spreadsheet tells us exactly how much money we will make on Saturday.’ Write three or four sentences to reply. Say what the model is good for and name two things it cannot know.
Model answer: The spreadsheet is a data model, so it lets us try different prices quickly and safely and see how the profit changes. But it only uses the numbers and rules we typed in. It cannot know how many people will really come, or whether rain will keep customers away. So it gives a good estimate, not an exact answer.
4
Write a test plan with three tests for a formula =B2*C2 that works out the cost of buying B2 pens at the price C2. Work out the expected outcomes first.
Model answer: Test 1: 3 pens at 2, expected 6. Test 2: 0 pens at 5, expected 0. Test 3: 10 pens at 1, expected 10. Any three tests with correct expected outcomes are right.
5
Look back at Unit 7.4. Copy and complete: ‘I can explain a primary key. For example, in a table of pets, … is a good primary key because …’. Then write one more thing from the unit that you can now do.
Model answer: PetID is a good primary key because every pet has a different PetID, but many pets share a name. Another thing: I can write the criteria Pages > 200 to search a table, or I can use $ to keep a cell reference fixed.