Scenario

Assessor Checklist-For Teacher use

Section A01 Design

Task 1

User Needs

Task 2

Print the sheet below and use it to help design your Spreadsheet.  You must include all Formulas, Formatting, Colours Shadings etc to be used

Planning

Example Spreadsheet Design

Task 3

Creating the Spreadsheet

Task 4

Creating a Second Worksheet

Task 5

Explaining the Formatting of your Spreadsheet

Task 6

Changing Variables

Task 7

Charts

Task 8

Making Drop Down Lists

Filtering a spreadsheet-to gain a merit/distinction you must filter using 2 fields.

Customising a Filter

Sorting Data-to gain a merit/distinction you must sort on 2 fields.

Task 9

Adding comments to help the user

For Merit and Distinction you must show lots of examples of user help.  Showing one or two comments is not sufficient

Task 10

Validation

Task 11

Protection

Protecting the formulas

Task 12

Hide Show Rows

Task 13

Linking Sheets

Task 14

Predictions-For a pass you must make 2 predictions.  For a merit or distinction you must also write about your investigation and the results.

Task 15

Macros

Creating a Macro for 2 tasks

Creating a Macro button

Macro Code

For Merit and Distinction all macro codes should be printed and annotated.  An explanation of what the code does should be given.

Task 16

Conditional Formatting

Functional Skills

Spreadsheets (1.2i)

Pupil Self Assessment Tick sheet