Assessor Checklist-For Teacher use. Also see unit 1 checklist.
In Excel you must now create your spreadsheet.
Pass-It must meet all the user needs and include at least two of the following +, -, *, /. Relative or absolute cell referencing must be used. The spreadsheet may only have 1 sheet. Functions from two categories will be used (See assessment sheet)
Merit-It must meet all the user needs and include all of the following +, -, *, /. Functions from three categories will be used (See assessment sheet). The spreadsheet will have more than one sheet linked by formulas.
Distinction-It must meet all the user needs and include all of the following +, -, *, / and brackets. The spreadsheet will have three sheets linked by formulas.
Speak to your teacher before attempting this task
Click on the links for examples of how to do the following. You do not need to show how you have done this as you will explain it in task 4.
Pass-Include text and background colours. Adjust row heights, column widths and merge cells. Set text direction.
Merit/Distinction-Include text and background colours which distinguish between different types of cells (E.g. formulas and variables). Wrap text.
Annotated example Create and annotate final model rather than evidence each step. Include borders, shading column widths etc.
Task 6-Change data
Pass-Change data for two scenarios and note the results
Merit/Distinction-Change data for two scenarios and note and explain the results
Task 7-Scale to fit (Merit/Distinction)
Task 8-Set print area (Merit/Distinction)
Task 9-(Pass, Merit, Distinction) Add a footer to your work, then print out your spreadsheet in both normal and formula view. Your printouts must be in landscape and fit to one page.
End of Unit 1
Task 11 (Pass, Merit, Distinction)
Two types of graph-Pass. Three types of graphs. These should compare values from different data sets-Merit/Distinction
Task 12-Distinction
Creating drop down lists/ Hide show columns
Task 13 (Pass, Merit, Distinction)
Filtering a spreadsheet-Pass one field. To gain a Merit/Distinction you must filter using 2 fields.
Customising a Filter-Distinction only
Task 14 (Pass, Merit, Distinction)
Sorting Data-to gain a Merit/Distinction you must sort on 2 fields.
Task 15 (Pass, Merit, Distinction)
Adding comments to help the user
1 Cell comment=Pass/Merit
Several suitable comments=Distinction
For Merit and Distinction you must show lots of examples of user help. Showing one or two comments is not sufficient
Task 16 (Pass, Merit, Distinction)
1 example of validation=Pass/Merit
Several examples of validation=Distinction
Task 17 (Distinction)
Task 18 (Pass, Merit, Distinction)
Merit and distinction candidates must describe the problem, what they did to solve it and the solution. E.g. The manager has asked what sales the company would have to make to produce a profit of £500 in January. I used goal seek to solve this problem and found the company would have to sell 446 Mp3's. Screenshots should accompany your explanation.
Task 19 (Pass, Merit, Distinction)
Macro code-Pass Must be for 2 Tasks!
Macro code-Merit/Distinction Macro button-Pass, Merit, Distinction
For Merit and Distinction all macro codes should be printed and annotated. An explanation of what the code does should be given.
Task 20-(Merit/Distinction)
Task 21-(Pass, Merit, Distinction)
You only need to make improvements if any are found. It is not to be done just for evidences' sake.
Extreme and abnormal data e.g. 1 billion, 0.00000000000009
Functional Skills
Spreadsheets (1.2i)
Pupil Self Assessment Tick sheet