week 6
B2 Spreadsheet model design
A design which shows how the spreadsheet model will look and work.
Producing worksheet structure diagrams that show:
layout and presentation
A layout and presentation diagram is important, this diagram will enable users to use the model effectively and efficiently so that there is reduced opportunities for miss-interpretation or understanding of data entry requirements or output. Each entry point must be clear and labeled with understandable titles and headings. Within this diagram, the selection of any graphs should be identified.
processing
The processing diagram is needed to present the formulae and functions, this will outline the calculations that will happen and where. It is advised that you explain what these calculations are doing.
The use of macros will need to be presented in a diagrammatic manner also, this can be using program flowchart or the use of JSP (Jackson Structured Programming) diagrams.
data entry and validation
Diagrams to identify the data entry points of the data model are required, these will also identify information on the validation rules and alerts that will be implemented in the system.
navigation
output.
The definition of the outputs of a data model needs careful consideration. The presentation of the information derived from the model will enable users to make an informed decision based on it. In your diagrams, you should clearly identify the information that is being outputted.
Producing a test plan to show:
Your test plans should follow a clear structure to enable fair testing and recording of the results of the tests undertaken.
Here you can see a proposed structure for your plan.
| Test Number | Test Description | Test Data | Expected Result | Actual Result | Pass/Fail | Action Taken | Re-test Number |
test data
When creating or using test data, you need to be clear that you understand the output of this data in calculations and functions to enable you to be able to qualify the results are accurate and correct. Your test data must also push the system to check for any potential failures. For example, inputting text data in to an integer expected cell.
purpose of the test
You should ensure that the test data has meaning and purpose and is not just to fill a section of the model as this is where you will be able to refine and improve the model based on its output.
expected result.
Last Updated
2019-02-25 11:33:26
Links to Learning Outcomes |
Links to Assessment criteria |
|
|---|---|---|
English
Maths
How 2's Coverage
Anonymous Assessment - Learners assess an anonymous piece of work containing deliberate mistakes against given success criteria.
Anonymous Assessment - Learners assess an anonymous piece of work containing deliberate mistakes against given success criteria.
Files that support this week
Week 5←
PrevWeek 6←
PrevWeek 7←
Prev→
Next→
Next
