ACARA Digital Technologies Years 9–10 Word Scramble: Analysing and Visualising Data (Modules 378–412)
Name:
Date:
Class:
🔤
Word scramble
Unscramble the letters and write each key term on the line.
1
OBOCM HTCRA
A chart that mixes types, like columns plus a line, and puts one series on a secondary axis so two data sets with different units, such as sales and temperature, can be read together.
2
=A21BU00B.ICE(1L:QRIN,T)
Finds Q1, the value 25% of the way up the data. Use 3 for Q3. IQR = Q3 - Q1. A value more than 1.5 times the IQR below Q1 or above Q3 is flagged as an outlier.
3
ESLPO NAD TPECRIETN
SLOPE gives m and INTERCEPT gives c of the best-fit line, so a prediction can be written as y = m*x + c. Both functions take known_y first, then known_x.
4
AELVU DFILE NTSESTGI
A pivot table option that changes what is calculated for each group, such as Sum, Count or Average. It can also show values as a % of column total and set the number format.
5
ORPUG
A pivot table feature that bundles dates into months or years, or numbers into equal-sized ranges, so the summary shows useful chunks. Right-click a value, then choose ______.
6
OITAHRCPTV
A chart linked to a pivot table. It updates whenever you change the pivot table's fields or filters. Create it with Insert > ______.
7
RSETNI > CELRSI
Adds a panel of buttons for one field. Click a button to filter the pivot table and its pivot chart. Hold Ctrl to select several buttons at once.
8
RSNEIT > NETIELIM
A timeline slicer filters a pivot table by dragging along a date range. Pick months, quarters or years from the time level drop-down. It needs a date field.
Answer Key
ACARA Digital Technologies Years 9–10 · Modules 378–412
1OBOCM HTCRA → Combo chart — A chart that mixes types, like columns plus a line, and puts one series on a secondary axis so two data sets with different units, such as sales and temperature, can be read together.
2=A21BU00B.ICE(1L:QRIN,T) → =QUARTILE.INC(B2:B100,1) — Finds Q1, the value 25% of the way up the data. Use 3 for Q3. IQR = Q3 - Q1. A value more than 1.5 times the IQR below Q1 or above Q3 is flagged as an outlier.
3ESLPO NAD TPECRIETN → SLOPE and INTERCEPT — SLOPE gives m and INTERCEPT gives c of the best-fit line, so a prediction can be written as y = m*x + c. Both functions take known_y first, then known_x.
4AELVU DFILE NTSESTGI → Value Field Settings — A pivot table option that changes what is calculated for each group, such as Sum, Count or Average. It can also show values as a % of column total and set the number format.
5ORPUG → Group — A pivot table feature that bundles dates into months or years, or numbers into equal-sized ranges, so the summary shows useful chunks. Right-click a value, then choose Group.
6OITAHRCPTV → PivotChart — A chart linked to a pivot table. It updates whenever you change the pivot table's fields or filters. Create it with Insert > PivotChart.
7RSETNI > CELRSI → Insert > Slicer — Adds a panel of buttons for one field. Click a button to filter the pivot table and its pivot chart. Hold Ctrl to select several buttons at once.
8RSNEIT > NETIELIM → Insert > Timeline — A timeline slicer filters a pivot table by dragging along a date range. Pick months, quarters or years from the time level drop-down. It needs a date field.