Unit Award Scheme
72212 ADVANCED EXCEL - FORMATTING AND ENHANCED DESIGN
In successfully completing this unit, the Learner will have | Evidence needed | |
|---|---|---|
demonstrated the ability to | ||
| 1 | identify at least three pieces of data from a given worksheet, eg iterms for sale, cost, sales price | Summary sheet |
| 2 | identify the correct headings to be used when the data is inputted into a new Excel spreadsheet | Summary sheet |
| 3 | enter data into relevant cells under the correct headings | Summary sheet |
| 4 | insert a formula to perform a simple calculation within the worksheet, eg total cost multiplied by quantity | Summary sheet |
| 5 | link individual excel worksheets into one excel spreadsheet | Summary sheet |
| 6 | rename individual worksheet with appropriate worksheet name | Summary sheet |
| 7 | add appropriate formatting to the spreadsheet | Summary sheet |
| 8 | apply conditional formatting to self-identified sections | Summary sheet |
| 9 | include complex formulas, eg statements to the spreadsheet | Summary sheet |
| 10 | test and screenshot evidence | Summary sheet |
| 11 | print out spreadsheet and screenshot evidence of testing. | Student completed work |
All outcomes recorded on an AQA Summary Sheet
Approved 30 June 2015Level - Level Two