VCE Data Analysis Crossword: Requirements, constraints and scope and Design tools for databases, spreadsheets and visualisations (Modules 68–80)
Name:
Date:
Class:
✎
Crossword
Read each clue and write the matching term in the grid. Numbers in brackets show the letters in each word.
1
2
3
4
5
6
7
8
9
Across
- 2. A sketch of a ______'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. Word 2 of: ___________ ____-up (4)
- 5. Word 1 of the term in 4 Down: ____________ a _____ (12)
- 6. Word 1 of the term in 2 Across: ___________ ____-up (11)
- 8. 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. Word 1 of: ___ chart (3)
- 9. A ______ 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. Word 2 of: annotated _______ (7)
Down
- 1. A ______ 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. Word 2 of: requirements ____ (4)
- 3. The three parts of a query design: which fields to show, which records match the ______ (using AND/OR), and how results are sorted, so the output meets the requirement. Word 2 of: Fields, ________, Sort (8)
- 4. Reading a teacher's ______ to find the data, calculations and outputs needed, the constraints that limit the solution, and what is out of scope. Word 3 of: ____________ a _____ (5)
- 6. The boundary of what a solution will and will not include. Features inside the boundary are in ______. Features left out, or saved for later, are out of ______. (5)
- 7. 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. Word 1 of: ____ visualisation ____-up (4)
Answer Key
VCE Data Analysis · Modules 68–80
1L
I
2M
O
3C
K
S
4B
R
5I
N
T
E
R
P
R
E
T
I
N
G
I
T
6S
P
R
E
A
7D
S
H
E
E
T
C
F
A
R
O
T
I
8I
P
O
9D
I
A
G
R
A
M
E
Across
2MOCK — A sketch of a ______'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. Word 2 of: ___________ ____-up
5INTERPRETING — Word 1 of the term in 4 Down: ____________ a _____
6SPREADSHEET — Word 1 of the term in 2 Across: ___________ ____-up
8IPO — 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. Word 1 of: ___ chart
9DIAGRAM — A ______ 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. Word 2 of: annotated _______
Down
1LIST — A ______ 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. Word 2 of: requirements ____
3CRITERIA — The three parts of a query design: which fields to show, which records match the ______ (using AND/OR), and how results are sorted, so the output meets the requirement. Word 2 of: Fields, ________, Sort
4BRIEF — Reading a teacher's ______ to find the data, calculations and outputs needed, the constraints that limit the solution, and what is out of scope. Word 3 of: ____________ a _____
6SCOPE — The boundary of what a solution will and will not include. Features inside the boundary are in ______. Features left out, or saved for later, are out of ______.
7DATA — 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. Word 1 of: ____ visualisation ____-up