VCE Spreadsheets, SQL & Visualisation Crossword: Querying data with SQL to Purposes and types of data visualisations (Modules 55–70)
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 ______ whose design, like a cut-off axis, 3D effects or a cherry-picked range, makes the data look different from what it truly shows. Word 2 of: misleading _____ (5)
- 3. ______ changes field values and DELETE FROM removes records. Always add WHERE so only the chosen records change. Without it, every record in the ______ is changed or deleted. Word 1 of: ______ _____ SET field = _____ WHERE condition; (6)
- 5. Predict the rows a ______ should return from a small sample, run it, then compare the actual result with your prediction. Check row counts, boundary values and JOIN matches. Word 3 of: Test a _____ (5)
- 6. Word 2 of the term in 3 Across: ______ _____ SET field = _____ WHERE condition; (5)
- 8. A chart with touching columns showing how many values fall in each numeric bin. Bins go on the x axis, frequency on the y axis. It shows the shape of the data, unlike a bar chart of categories. (9)
- 9. An SQL clause that sorts rows into groups sharing the same field value, then applies an aggregate like AVG or COUNT to each ______, giving one result row per ______ (e.g. average score per class). Word 1 of: _____ BY (5)
Down
- 1. A chart that plots each record as a point using two number columns, one on the x axis and one on the y axis, to show whether two things are related. Word 1 of: _______ graph (7)
- 2. Two things can rise or fall together without one causing the other. A trend shows a relationship, not the reason, so a hidden third factor may explain both. Word 1 of: ___________ is not causation (11)
- 4. A visualisation that helps an audience learn how something works or understand a topic step by step, such as a labelled diagram or a process explained in stages. Word 1 of: _________ visualisation (9)
- 7. Word 5 of the term in 3 Across: ______ _____ SET field = _____ WHERE condition; (5)
Answer Key
VCE Spreadsheets, SQL & Visualisation · Modules 55–70
1S
C
A
2C
H
A
R
T
3U
P
D
A
T
4E
O
T
D
R
E
5Q
U
E
R
Y
R
C
E
6T
A
B
L
E
T
A
7V
8H
I
S
T
O
G
R
A
M
N
I
L
9G
R
O
U
P
U
N
E
Across
2CHART — A ______ whose design, like a cut-off axis, 3D effects or a cherry-picked range, makes the data look different from what it truly shows. Word 2 of: misleading _____
3UPDATE — ______ changes field values and DELETE FROM removes records. Always add WHERE so only the chosen records change. Without it, every record in the ______ is changed or deleted. Word 1 of: ______ _____ SET field = _____ WHERE condition;
5QUERY — Predict the rows a ______ should return from a small sample, run it, then compare the actual result with your prediction. Check row counts, boundary values and JOIN matches. Word 3 of: Test a _____
6TABLE — Word 2 of the term in 3 Across: ______ _____ SET field = _____ WHERE condition;
8HISTOGRAM — A chart with touching columns showing how many values fall in each numeric bin. Bins go on the x axis, frequency on the y axis. It shows the shape of the data, unlike a bar chart of categories.
9GROUP — An SQL clause that sorts rows into groups sharing the same field value, then applies an aggregate like AVG or COUNT to each ______, giving one result row per ______ (e.g. average score per class). Word 1 of: _____ BY
Down
1SCATTER — A chart that plots each record as a point using two number columns, one on the x axis and one on the y axis, to show whether two things are related. Word 1 of: _______ graph
2CORRELATION — Two things can rise or fall together without one causing the other. A trend shows a relationship, not the reason, so a hidden third factor may explain both. Word 1 of: ___________ is not causation
4EDUCATING — A visualisation that helps an audience learn how something works or understand a topic step by step, such as a labelled diagram or a process explained in stages. Word 1 of: _________ visualisation
7VALUE — Word 5 of the term in 3 Across: ______ _____ SET field = _____ WHERE condition;