VCE Spreadsheets, SQL & Visualisation Word Scramble: Querying data with SQL to Purposes and types of data visualisations (Modules 55–70)
Name:
Date:
Class:
🔤
Word scramble
Unscramble the letters and write each key term on the line.
1
RUOGP YB
An SQL clause that sorts rows into groups sharing the same field value, then applies an aggregate like AVG or COUNT to each group, giving one result row per group (e.g. average score per class).
2
ETTS A YQREU
Predict the rows a query should return from a small sample, run it, then compare the actual result with your prediction. Check row counts, boundary values and JOIN matches.
3
TRTECAS RPHGA
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.
4
RGTIAOSHM
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.
5
RNNDTIELE
A straight or curved line fitted to the points on a chart. It shows the overall direction of the data, such as going up or down. Add it with Add Chart Element > ______.
6
NALGMIDEIS TARCH
A chart whose design, like a cut-off axis, 3D effects or a cherry-picked range, makes the data look different from what it truly shows.
Answer Key
VCE Spreadsheets, SQL & Visualisation · Modules 55–70
1RUOGP YB → GROUP BY — An SQL clause that sorts rows into groups sharing the same field value, then applies an aggregate like AVG or COUNT to each group, giving one result row per group (e.g. average score per class).
2ETTS A YQREU → Test a query — Predict the rows a query should return from a small sample, run it, then compare the actual result with your prediction. Check row counts, boundary values and JOIN matches.
3TRTECAS RPHGA → scatter graph — 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.
4RGTIAOSHM → histogram — 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.
5RNNDTIELE → Trendline — A straight or curved line fitted to the points on a chart. It shows the overall direction of the data, such as going up or down. Add it with Add Chart Element > Trendline.
6NALGMIDEIS TARCH → misleading chart — A chart whose design, like a cut-off axis, 3D effects or a cherry-picked range, makes the data look different from what it truly shows.