VCE Data Analysis Definitions Worksheet: Requirements, constraints and scope and Design tools for databases, spreadsheets and visualisations (Modules 68–80)
Name:
Date:
Class:
✎
Key terms
Write what each term means, in your own words.
1
scope
2
requirements list
3
Interpreting a brief
4
IPO chart
5
annotated diagram
6
spreadsheet mock-up
7
Data visualisation mock-up
8
Query design
9
Fields, Criteria, Sort
10
Interpreting a design
Answer Key
VCE Data Analysis · Modules 68–80 · Student wording will vary for definitions
1scope — The boundary of what a solution will and will not include. Features inside the boundary are in scope. Features left out, or saved for later, are out of scope.
2requirements list — A list that sorts what a solution must do (requirements) from the limits it must work within (constraints), for one problem. Each item should be clear and testable.
3Interpreting a brief — Reading a teacher's brief to find the data, calculations and outputs needed, the constraints that limit the solution, and what is out of scope.
4IPO chart — A three-column table listing a solution's inputs (data entered), the processes applied to that data, and the outputs it produces, such as a total or report.
5annotated diagram — A diagram of a database or spreadsheet with labels and notes on its parts, such as tables, fields, data types, cells, formulas and validation, explaining what each part does.
6spreadsheet mock-up — A sketch of a spreadsheet's worksheet names, header labels, data areas, formatting and result cells, drawn before building to show how it will look and where results will go.
7Data visualisation mock-up — A sketch of a chart or graph made before building it, showing the chart type, titles, labels, colours, fonts and layout so the design can be checked and improved.
8Query design — A plan for a database query that lists the table, the fields to show, the criteria used to filter records and the sort order, written before the query is built.
9Fields, Criteria, Sort — The three parts of a query design: which fields to show, which records match the criteria (using AND/OR), and how results are sorted, so the output meets the requirement.
10Interpreting 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.