The Project – Spreadsheet Design. The following is the high mark band for the spreadsheet design: The candidate has
The following is the high mark band for the spreadsheet design:
The candidate has
• Analysed a given data set and designed suitable worksheets that will allow data to be presented and manipulated efficiently. The design will include suitable titles, column and row headings and cell formats and will
include validation rules that will control data input and limit errors. It will detail the formulae and functions needed to achieve the required outcomes
• Produced designs for input formats that propose features to aid data entry and for outputs that illustrate the intended layout and content
• Produced designs for an interface to aid user efficiency. The design indicates that accessibility and usability have been considered
• Identified and fully described a range of automated routines that will aid user efficiency
Below is what the specification requires of this section.
A good format for this document may be like this for example:
Worksheet descriptions and overview
Worksheet interface design – using blank excel templates showing column and row headings, sub headings, positioning of variables etc. Show navigation round the system
Show any User forms Designs.
Data table structures for each page including variables and any validation – Create a Data dictionary for each sheet – see last slide.
Security and protection
Formulas, validations used throughout.
Inputs into the system
Outputs from the system from single variables to designs of any printed outputs
Efficiency – design of macros and buttons
Keep referencing back to each part especially back to the Worksheet interface design.
One way of creating a data dictionary is like this: