All subjects · Information Technology · WIT14 3 hour practical exam on database solutions
Analysing user needs and designing for them
Edexcel IAL Information Technology · WIT14 3 hour practical exam on database solutions
A database is only useful if it fits the people who use it. Specification 17.2 asks you to analyse users' needs in different contexts, design for their characteristics and skills, and evaluate how well a design meets those needs.
Who are the users and what do they need?
Start every design by listing:
- The users: the owner, counter staff, managers, customers, administrators. There may be several groups.
- Their tasks: what each must enter, find, change or print, and how often.
- Their IT skills and experience: novice, regular, expert.
- Other characteristics: age, first language, disabilities (for example visual impairment), the devices and screen sizes they use, the time pressure they work under.
- The outputs they need: on-screen lookups, printed reports, charts, exported files.
In the exam these needs are inside the scenario text. Underline every requirement and every fact about the users before you build anything.
Designing for user characteristics
| User characteristic | Design response |
|---|---|
| Novice, little IT experience | Forms with clear labels, instructions, drop-down lists, buttons for each task; hide tables and design views |
| Expert, frequent user | Dashboard of shortcuts, keyboard-friendly tab order, fewer confirmation prompts |
| Works under time pressure | Default values (today's date), auto-generated IDs, minimal typing |
| Visual impairment | Large readable fonts, high contrast, no meaning shown by colour alone |
| Different first language | Plain, consistent wording; short labels; icons with text |
| Manager who needs an overview | Summary reports and charts rather than raw records |
Evaluating a design against user needs
To evaluate, take each need in turn and ask whether the design meets it, partly meets it or fails it, with evidence. Then suggest an improvement for each weakness, linked to the user:
- 'The form meets the need for fast entry because the date defaults to today, but the bike type is typed freely, so spelling errors are likely. A combo box listing the four types would fix this for the part-time staff.'
Avoid generic comments such as 'make it more user friendly'. Say what to change and why it helps that user.
Worked example
Harbour Bike Hire's counter staff are students working summer shifts. They must book hires quickly while customers wait. List two needs and a design response for each.
- Need 1: speed, because customers are waiting. Response: a booking form where HireDate defaults to today and HireID is generated automatically.
- Need 2: accuracy with little training. Response: a drop-down list of customers and bikes instead of typed IDs, plus validation that Days is at least 1 with a clear error message.
Answer: Each design response is linked to a stated characteristic of the users.
Check yourself
- Which design choice best suits users with little IT experience?
- Access to the table design view
- A menu form with clearly labelled buttons for each task
- A blank query window
- Field names such as fldCstID
Show answer
A menu form with clearly labelled buttons for each task. Novices need guidance: clear labels and one button per task.
- Staff at a busy ticket desk complain that entering a sale is slow. Which change most directly helps?
- Adding a decorative background image
- Removing all validation
- Printing a weekly report
- Setting default values and auto-generating the sale number
Show answer
Setting default values and auto-generating the sale number. Defaults and automation cut typing; removing validation would harm accuracy.
- A user has a visual impairment. Which design feature is most appropriate?
- Red text to show errors with no message
- Large fonts with high contrast between text and background
- Small labels so more fits on screen
- Pale grey text on a white background
Show answer
Large fonts with high contrast between text and background. Readable size and contrast support users with visual impairments; never rely on colour alone.
- A manager wants to see at a glance which bike types earn the most. What output best meets this need?
- The full hire table in datasheet view
- A data entry form for new bikes
- A chart of total income by bike type
- An input mask on BikeID
Show answer
A chart of total income by bike type. Managers need summaries; a chart compares totals at a glance.
- A form asks users to type the department name for each staff member, and the data contains 'Sales', 'sales' and 'Slaes'. Suggest an improvement and explain how it helps the users.
Show answer
Replace the text box with a drop-down list of departments, so users choose a correctly spelled value instead of typing it.. A lookup (combo box or list) means users select from fixed, correctly spelled values, which is faster and consistent.
- In the exam, what should you do first with the scenario text before building anything?
- Start creating tables straight away
- Choose a colour scheme
- Identify every stated requirement and fact about the users
- Write the evaluation
Show answer
Identify every stated requirement and fact about the users. Every mark is tied to the scenario's requirements, so extract them first.
Sources
- Pearson Edexcel International Advanced Level in Information Technology specification (Issue 2, February 2021): Unit 4, Topics 17 to 19
- Pearson: IAL Information Technology scheme of work for Unit 4
Last updated 8 November 2026. Spotted a mistake? Tell us.