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

Build and judge a system

Week 17 · 2.2 Creating real-life systems and evaluating pre-existing spreadsheets · 3 lessons
Answers are for parents and teachers.
1
Think of a real-life task, such as keeping the scores of a family quiz game. Write a plan: purpose, inputs, outputs and one fixed number, if any. Then draw the layout with the field names in row 1.
2
A garden contest marks Plants out of 30 (weight 50) and Tidiness out of 10 (weight 50). Work out the overall mark for each garden and its band using =IF(D2>=75,"Fine",IF(D2>=55,"Fair","Weak")).
D2fx=B2/30*50+C2/10*50
ABCD
1GardenPlants (/30)Tidiness (/10)Overall (%)
2A249?
3B186?
4C155?
5D98?
3
The sheet should show the total number of books read by the class. Check the formula and write what it shows, what it should show and the repair.
B7fx=SUM(B2:B5)
AB
1WeekBooks
213
325
434
546
659
7Total18
4
Write a nested IF for the cell B2 that gives Cold for a temperature below 10, Mild for 10 up to but not including 25, and Hot for 25 or more. Then give the result for 10, 24.9 and 25.
5
Marcia’s sheet has all formulas correct, but the text is light grey on white and the columns have no headings. Is the sheet suitable? List two improvements and say whether each is functional or non-functional.