← VCE Data Analysis

Interpreting a given design

Reading a design's IPO chart, annotations, mock-ups and query designs together to work out what must be built, and checking it matches the requirements.

Part of: VCE Applied Computing - U1O1 - Data analysis — Module 80, VCE Data Analytics - U3O1 - Data Analytics — Module 37, VCE Applied Computing U1O2 Programming: Requirements and design tools — Module 22

Understanding Interpreting a given design in VCE Data Analysis

What it does: A query criteria line that filters by suburb shows the design meets the filtering requirement. A mock-up shows layout, whereas an IPO chart shows data flow, so the mock-up is the right tool for screen positions. Each design tool shows a different view. Reading them together shows what must be built and whether the parts match. Matching the design to the requirements means checking every requirement has an input, process or output. A missing process is a gap. When detail is missing, look at the other design parts first. If it is still unclear, ask the designer or teacher instead of guessing.

Common mistakes: The IPO chart says the process is to average the marks. SUM only adds them, so the build must use =AVERAGE(B2:B4). The requirement asks for names from A to Z. The query design must sort Name ascending (A to Z), not Z to A.

Class: _____________________  ·  Name: _____________________  ·  Date: _________

Free printable worksheet with full answer key — or add this module to a class and your students practise it interactively.

🖨 Print worksheet + answer key Add Interpreting a given design to a class →

This module's key terms are also in a printable crossword (Modules 68–80) and word search (Modules 56–80).

Take this worksheet further — free with Cloodit

Each concept is reinforced from every angle — learned, then applied, then tested.

Learning
Duo
A teacher gives you an IPO chart, an annotated mock-up and a query design. What is the best way to work out what to build?
Read only the mock-up and ignore the other partsRead all the design parts together and check they agree
Matches
IPO chart: Process = (blank), Output = Average mark
↓
Missing detail: the Process column does not say how the average is calculated, so the developer cannot build it
Applying
Meanings
Term
Interpreting a design
Meaning
Reading a design's IPO chart, annotations, mock-ups and query designs together to work out what must be built, and checking it matches the requirements.
Practice
READ IPO chart, annotations, mock-up, query
Testing
Gaps
: Hours * Rate
Check Answer
Spots
3Output: average mark
4Build: =SUM(B2:B4)

Cloodit turns curriculum-aligned coding content into journeys students work through one biome at a time.

The 'Cheetah' badge — Savannah Sprinter, one of Cloodit's 106 collectible badges
Students earn collectable badges

Over 100 of them, across seven natural biomes.

Study Buddy
Students build a real study resource

Turns their work into revision material ready for Flash Cards and Exam study.

Diamond Dash — one of Cloodit's live, competitive Sprint games
Students lock in with Sprints

Live, competitive practice for the start of the lesson or a teacher-led lesson finisher.

A Cloodit certificate of achievement, ready to personalise and print
Custom printable certificates

Honour your top performers, or encourage a student who's trying hard — ready to print in seconds.

Add to class →

Quick Questions

1. A teacher gives you an IPO chart, an annotated mock-up and a query design. What is the best way to work out what to build?
A. Read all the design parts together and check they agree ✓
B. Read only the mock-up and ignore the other parts
Each design tool shows a different view. Reading them together shows what must be built and whether the parts match.
2. A requirement says the spreadsheet must calculate each student's average mark. The IPO chart has no process for averaging. What have you found?
A. Missing detail in the design ✓
B. A design that fully meets the requirement
Matching the design to the requirements means checking every requirement has an input, process or output. A missing process is a gap.
3. Which design tool is best for showing where buttons, headings and charts will sit on screen?
A. An IPO chart
B. A mock-up ✓
A mock-up shows layout and appearance. An IPO chart lists inputs, processes and outputs instead.
4. Which design tool is best for showing what data goes in, what happens to it and what comes out?
A. A mock-up
B. An IPO chart ✓
An IPO chart is organised into input, process and output columns, so it shows the flow of data.
5. A mock-up has a label that says 'Total' but does not say how the total is worked out. What should you do?
A. Check the IPO chart or annotations for the calculation, and ask if it is missing ✓
B. Guess the calculation and build it anyway
When detail is missing, look at the other design parts first. If it is still unclear, ask the designer or teacher instead of guessing.

Match the Pairs

IPO chart: Input = student marks → Shows the data the solution must receive before any processing can start
Annotation: 'Show total in red if < 50' → A note on the design that tells the developer exactly how an output must look or behave
Matching a design to requirements: the requirement says users must filter by suburb, so the query design must include this → Criteria: Suburb = [Enter suburb]
Choosing the right design tool: to show where fields and buttons sit on a screen, use a mock-up → Mock-up: layout of form with labelled fields
IPO chart: Process = (blank), Output = Average mark → Missing detail: the Process column does not say how the average is calculated, so the developer cannot build it
Requirement: show sales by month. Mock-up: table of customer names only → The design does not match the requirement because the mock-up has no sales or month data

Key Term

Interpreting a design
Reading a design's IPO chart, annotations, mock-ups and query designs together to work out what must be built, and checking it matches the requirements.

Fill in the Blanks

1. Input: Hours, Rate Process: Hours * Rate Output: Weekly pay
Hint: Type the IPO chart column that describes the calculation step.
2. Requirement: show passes (50 or more) Field: Score Criteria: >=50
Hint: Type the comparison operator that matches 'or more'.
3. Task: show where charts sit on the page Best tool: mock-up
Hint: Type the design tool that shows the visual layout of a page.
4. Requirement: list names A to Z Field: Surname Sort: Ascending
Hint: Type the sort order that puts names from A to Z.
5. Requirement: show total sales Input: Sales column Process: SUM(Sales)
Hint: Type the function name that adds up a column of values.

Spot the Error

Question 1
A Input: mark1, mark2, mark3
B Process: average the marks
C Output: average mark
D Build: =SUM(B2:B4)
Line D — The IPO chart says the process is to average the marks. SUM only adds them, so the build must use =AVERAGE(B2:B4).
Question 2
A Need: Year 11 names, A to Z
B Table: Students
C Criteria: Year = 11
D Sort: Name Z to A
Line D — The requirement asks for names from A to Z. The query design must sort Name ascending (A to Z), not Z to A.
Question 3
A Requirement: show total cost
B Output: average price
C Input: price, quantity
D Process: price * quantity
Line B — The requirement is to show the total cost, so the IPO output must be total cost. An average price does not match the requirement.
Question 4
A Mock-up: chart below table
B Annotation: chart beside data
C Build: place chart in column F
Line A — The annotation and build step put the chart beside the data. The mock-up must show the chart to the right of the table so the design is consistent.
Question 5
A Need: show layout of a screen
B Tool: IPO chart
C Reason: shows where items go
Line B — A layout is shown with a mock-up. An IPO chart lists inputs, processes and outputs. It does not show where items sit on the screen.

Student with a class code? Join your class →