The Project – Spreadsheet Design.
This presentation is the property of its rightful owner.
Sponsored Links
1 / 4

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


  • 53 Views
  • Uploaded on
  • Presentation posted in: General

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

Download Presentation

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

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


The project spreadsheet design the following is the high mark band for the spreadsheet design

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


The project spreadsheet design the following is the high mark band for the spreadsheet design

The Project – Spreadsheet Design.

Below is what the specification requires of this section.


The project spreadsheet design the following is the high mark band for the spreadsheet design

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.


The project spreadsheet design the following is the high mark band for the spreadsheet design

The Project – Spreadsheet Design.

One way of creating a data dictionary is like this:

Etc….


  • Login