slide1
Download
Skip this Video
Download Presentation
The Project – Spreadsheet Design. The following is the high mark band for the spreadsheet design:

Loading in 2 Seconds...

play fullscreen
1 / 4

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


  • 87 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' The Project – Spreadsheet Design. The following is the high mark band for the spreadsheet design:' - giulia


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
slide1

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

slide2

The Project – Spreadsheet Design.

Below is what the specification requires of this section.

slide3

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.

slide4

The Project – Spreadsheet Design.

One way of creating a data dictionary is like this:

Etc….

ad