Who reads this screen?
Oakfield Youth Club is made up. A volunteer types in new members on Saturday morning. A parent reads the activity list on the notice board.
They look at the same data, but they need different screens. Designing both on paper first saves a lot of time later.
By the end of this lesson
Note
I can sketch an input form and an output report that match the fields of a table.
Key words
| Word | What it means |
|---|---|
| Input form | a screen where a person types in data |
| Output screen | a screen that shows data to a person |
| Report | a tidy printed or on-screen list of chosen data |
| Control | a box, tick box or list on a form |
| Design document | the plans that say how to build the tables |
The cells students fill in are left blank in this preview.
Starter: what you already know
Have a go
Starter: what you already know
3 questionsYour answers are marked here and are not kept. A college account keeps every student’s marks.
A design document holds all the plans
A design document is everything somebody needs to build the tables. It holds the data dictionary (a table that describes each field) and the validation rules. Validation means checks on entered data. It holds the ERD and sketches of the forms and reports. It also holds a test plan (a list of tests and what should happen) with test data (values to try).
A good design lets a person who was not there build the same tables.
The parts of a design document
| Part | What it shows | Who uses it |
|---|---|---|
| Data dictionary | Every field, its type, size and format | The person building the tables |
| Validation rules | The check for each field | The person building the tables |
| ERD | The tables and their links | Everybody |
| Input form sketch | Where each control goes | The person entering data |
| Report sketch | What each output shows | The reader of the report |
| Test plan | What to test and what should happen | The tester |
The cells students fill in are left blank in this preview.
Check
Have a go
Check
3 questionsYour answers are marked here and are not kept. A college account keeps every student’s marks.