VCE Data Analytics U3O1 Word Scramble: Sourcing, validating and referencing data to Statistical analysis of data (Modules 50–91)
Name:
Date:
Class:
🔤
Word scramble
Unscramble the letters and write each key term on the line.
1
ATAD ITAIOANDVL
A spreadsheet tool that limits cells to allowed entries, like a whole number from 1 to 100 or a drop-down list, and shows an error message if someone types anything else.
2
EMVEOR PEDCSUILTA
A spreadsheet tool that deletes rows repeating the same values in the columns you choose to compare, keeping the first match. Always keep a copy of the raw data first.
3
IMGSINS LEVAU
An empty cell where data should be. Find it with a filter for blanks, then delete the row, fill it from a reliable source or exclude it so AVERAGE and COUNT are not distorted.
4
=AVAE2(LU)
Converts text that looks like a number, such as '45' stored as text, into a true number so it can be added, averaged and sorted correctly. Left-aligned numbers are a warning sign.
5
=TEFL(23,A)
Text functions split text or join it. LEFT, RIGHT and MID take part of a value; CONCAT or & joins parts into one. This formula returns the first 3 characters of cell A2.
6
RERRO AUVEL
A message starting with # (such as #DIV/0!, #N/A, #VALUE! or #REF!) that a cell shows when a formula fails. It hints at what went wrong so you can fix the formula or data.
7
=BX3(IN:MM3)-22B(0B:B0A)
The range is the largest value minus the smallest value. It measures spread, and one outlier can make it much bigger.
8
=B9CB22(OC:9L,RE:CR)
Finds Pearson's r for two equal-length number ranges. The result is from -1 to 1: near 1 is strong positive, near -1 is strong negative, near 0 is no linear link.
9
ENTRNIDEL
A line fitted through a chart's points that shows the overall direction of the data. A chart tool can add one with its equation, and the R-squared value shows how well it fits.
Answer Key
VCE Data Analytics U3O1 · Modules 50–91
1ATAD ITAIOANDVL → Data Validation — A spreadsheet tool that limits cells to allowed entries, like a whole number from 1 to 100 or a drop-down list, and shows an error message if someone types anything else.
2EMVEOR PEDCSUILTA → Remove Duplicates — A spreadsheet tool that deletes rows repeating the same values in the columns you choose to compare, keeping the first match. Always keep a copy of the raw data first.
3IMGSINS LEVAU → missing value — An empty cell where data should be. Find it with a filter for blanks, then delete the row, fill it from a reliable source or exclude it so AVERAGE and COUNT are not distorted.
4=AVAE2(LU) → =VALUE(A2) — Converts text that looks like a number, such as '45' stored as text, into a true number so it can be added, averaged and sorted correctly. Left-aligned numbers are a warning sign.
5=TEFL(23,A) → =LEFT(A2,3) — Text functions split text or join it. LEFT, RIGHT and MID take part of a value; CONCAT or & joins parts into one. This formula returns the first 3 characters of cell A2.
6RERRO AUVEL → error value — A message starting with # (such as #DIV/0!, #N/A, #VALUE! or #REF!) that a cell shows when a formula fails. It hints at what went wrong so you can fix the formula or data.
7=BX3(IN:MM3)-22B(0B:B0A) → =MAX(B2:B30)-MIN(B2:B30) — The range is the largest value minus the smallest value. It measures spread, and one outlier can make it much bigger.
8=B9CB22(OC:9L,RE:CR) → =CORREL(B2:B9,C2:C9) — Finds Pearson's r for two equal-length number ranges. The result is from -1 to 1: near 1 is strong positive, near -1 is strong negative, near 0 is no linear link.
9ENTRNIDEL → trendline — A line fitted through a chart's points that shows the overall direction of the data. A chart tool can add one with its equation, and the R-squared value shows how well it fits.