Unit Award Scheme
113533 USING FORMULAE AND GRAPHS IN SPREADSHEETS
In successfully completing this unit, the Learner will have | Evidence needed | |
|---|---|---|
demonstrated the ability to | ||
| 1 | open a spreadsheet | Summary sheet |
| 2 | use an AutoSum tool to successfully calculate the total of at least two cells | Summary sheet |
| 3 | input a formula for addition | Summary sheet |
| 4 | input a formula for subtraction | Summary sheet |
| 5 | input a multiplication formula | Summary sheet |
| 6 | input a division formula | Summary sheet |
| 7 | use the average function to find the average value of at least two cells | Summary sheet |
| 8 | format a table to make its content clear | Summary sheet |
| 9 | insert a graph | Summary sheet |
| 10 | label the graph | Summary sheet |
| 11 | outline what the graph shows | Summary sheet |
| 12 | save their work and exit the software | Summary sheet and/or student completed work |
shown knowledge of | ||
| 13 | at least two ways spreadsheets can be used in business and industry. | Summary sheet |
All outcomes recorded on an AQA Summary Sheet
Approved 28 April 2020Level - Level One