Review tasks (2)
In the final task several features are used together. For example, sheet 1 holds the grand total and sheet 2 holds the values by class (for example the number of books collected); a cell on sheet 1 is linked to sheet 2 by a formula like =SUM(Sheet2!B2:B5), so if a number on sheet 2 changes, the total updates itself. A share is calculated with part · 100 : whole, a pie chart is built on sheet 3, and the values are sorted in descending order and filtered by a condition if needed. When finished, check that headers, units and chart titles are right. Save the file regularly and keep a backup on another device or in the cloud; when sharing files with personal data give “view only” permission and use a strong password. The program should be legal: free LibreOffice or Google Sheets are a good choice.
| A | B | |
|---|---|---|
| 1 | Class | Books |
| 2 | 1 | 120 |
| 3 | 2 | 80 |
| 4 | 3 | 100 |
| 5 | 4 | 100 |
| 6 | 400 |
In preparing for a class event, three groups each wrote on their own sheet how many hours they worked, and a summary sheet added the hours up. When one group corrected its number, the overall total changed straight away.
Accountants, project leaders and research teams combine numbers from several sources into one total.
With three friends, each write three invented numbers, then work out the grand total on one sheet.
“Final project”: a group builds a 3-sheet workbook with made-up data: data, calculation and chart; applies sorting and a filter, and presents the result to the class.