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.

Practise this in the app: instant marking and a fix for every mistake. Free, no email needed to start.

Practise this lesson

Who are the users and what do they need?

Start every design by listing:

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 characteristicDesign response
Novice, little IT experienceForms with clear labels, instructions, drop-down lists, buttons for each task; hide tables and design views
Expert, frequent userDashboard of shortcuts, keyboard-friendly tab order, fewer confirmation prompts
Works under time pressureDefault values (today's date), auto-generated IDs, minimal typing
Visual impairmentLarge readable fonts, high contrast, no meaning shown by colour alone
Different first languagePlain, consistent wording; short labels; icons with text
Manager who needs an overviewSummary 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:

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.

  1. Need 1: speed, because customers are waiting. Response: a booking form where HireDate defaults to today and HireID is generated automatically.
  2. 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.

Key idea: List users, tasks, skills and other characteristics; design for them (novices need guided forms, experts shortcuts, time-pressed staff defaults and automation); evaluate each need with evidence and suggest specific improvements.

Check yourself

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

Practise with instant feedback

Sources

Last updated 8 November 2026. Spotted a mistake? Tell us.