Tuesday, 20 January 2015

P2 Describe the purpose and user requirements for the spreadsheet

Good morning year 12L2 IT

Designing your spreadsheet

When designing anything you first need to start with a design plan!

Your design should include:

The intended purpose of the user requirements

Design documentation that includes:

  • a working structure diagram showing the proposed layout, calculations, processes (e.g. formula and functions) and data input method (e.g. labeling and row and column use, forms, cell formatting, validation, conditional formatting)
  • user input interface identifying appropriate tools and techniques
  • user output data (e.g. ideas for presentation showing formats and tools and techniques
  • onscreen user navigation and guidance (e.g. navigation prompts, input messages and validation (including lists)
  • test plan with test data to test functionality (e.g.test, expected results, actual results)
  • a brief outline of alternative design ideas (e.g. choice of calculations and artistic style of the solution). 
For L1 pass learners as a minimum should identify the purpose and the user requirements for their spreadsheet design

Deadline date:

Example spreadsheet here - cashflow forecasting that uses the following data here

No comments:

Post a Comment