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