Information and communication: What information is needed, and how should it be communicated?
Monitoring: How will you monitor what is happening?
|Mark breakdown per task|
|A (instruction sheets)||4|
|B (data input sheet)||3|
|High Distinction||Distinction||Credit||Pass||Unsatisfactory (Fail)|
· Purpose of spreadsheet
· Description of layout
· How to enter data
· Formula for each ratioused
· Examples of special features in report (e.g. conditional formatting)
Professional quality. Concise and error free.Structure of the spreadsheet is very clear. Clear examples of special features, such as slicers, provided.
All basic requirements but some errors.
Instructions mostly clear, and suitable for distribution to a professional audience.
Examples provided for all features, but difficult to understand.
All basic requirements but some errors. Instructions could be clearer, but the instructions are usable.
Examples provided for some, but not all, special features (slicers/form controls, spark lines, conditional formatting)
|Meets basic requirements but should not be distributed without editing. E.g. some poor grammar, structure of workbook or some variable definitions not explained well.||
Does not meet basic requirements.
Instructions missing or hard to understand. Document contains many errors. Cannot be distributed to a professional audience.
|4 marks||3.5 marks||3 marks||2.5 marks|
Three different rules to highlight invalid data on all four input sheets. Each rule must apply to multiple cells, and overall, all data cells must be tested. For example, you could test whether cells contain the correct data type (text in columns A and B, numbers elsewhere), or that numbers are not too high or low.
In Excel, this can be done via the Data Validation command with the circle invalid data option enabled, or via conditional formatting.
Google Sheets does not have a circle invalid data option, so you have to use conditional formatting.
Note that this is a challenging task that may require a formula-based rule to highlight cells that contain numbers instead of text.
Two different rules to highlight invalid data on all four input sheets, or three rules but not all input sheets or not all data cells covered.
||One rule to highlight invalid data||
This is an advanced task for students attempting to obtain an overall grade of more than pass.
|3 marks||2 marks||1 mark|
Separate calculation sheet(s)
Values are from formulas or pivot tables and not hard-coded
|No calculation sheets added, or some data on calculations sheet is hard-coded (not from formulas or pivot tables).|
|1 mark||0 marks|
Meets Pass requirements, creative and attractive dashboard design that is also functional (e.g. don’t use exotic and hard-to-interpret designs, such as 3D charts unless you have a reason).
· One graph or table is interactive. Use a slicer, a form control,an Active-X control, or similar. A pivot table on its own is not sufficiently interactive.
· Spark lines in a table
· Icons or a colour scale from conditional formatting used in a table. The icons or colours must be explained within the dashboard.
|Meets pass requirements, creative and attractive dashboard design, plus two of the three high distinction requirements (interactive, spark lines, conditional formatting).||
Meets pass requirements, creative and attractive dashboard design, plus one of the three high distinction requirements (interactive pivot table, spark lines, conditional formatting)
· Dashboard fits within a widescreen display with a 1440 x 900 resolution
· 3 or more ratios, including day’s inventory on hand, and gross marginpercentage
· 1-3 graphs and 1-2 tables, but not more than 4 graphs/tables
· Reports based on calculations, not hard coded numbers.
· Your name appears in the footer section of the page when printed
|Does not meet basic requirements (e.g. less than 3 ratios shown, too large, not enough graphs/tables, or report based on hard coded numbers.|
|7 marks||6 marks||5 marks||4 marks|