The Project – Spreadsheet Design. The following is the high mark band for the spreadsheet design:

1. The Project – Spreadsheet Design. 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

2. The Project – Spreadsheet Design. Below is what the specification requires of this section.

3. The Project – Spreadsheet Design. 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.

4. The Project – Spreadsheet Design. One way of creating a data dictionary is like this: Etc….