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 decisions

Week 20 · Unit 7.4: The power of data · 3 lessons
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.
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?
AB
1Cost per kit4
2Price per kit7
3Kits sold25
4Profit?
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.
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.
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.