Years 7–8 Data & Information Word Scramble: Acquiring, storing and validating data to Using digital tools and conventions (Modules 47–80)
Name:
Date:
Class:
🔤
Word scramble
Unscramble the letters and write each key term on the line.
1
TREAEC BLATE
Make a new table by adding fields in design view, then type each record into its own row in datasheet view. Save the table so your data is kept.
2
RSTO NDA ILTREF
Sort puts records in order by one field, either ascending (A to Z, small to big) or descending. Filter shows only the records that match a chosen value and hides the rest.
3
HEERW EROCS > 08
A criterion that limits a query to records where the condition is true, so only Score values above 80 are shown. Compare with =, <>, <, >, <=, >=. Text goes in quotes.
4
EORRD YB CEROS CDES
Sorts query results by the Score field from highest to lowest. Use ASC for lowest to highest. Add a second field after a comma to sort ties, like ______, Name.
5
GGRGEATAE ONTUICNF
A query function like COUNT, SUM, AVG, MIN or MAX that looks at many records and gives one answer, such as how many records match or the average of a field.
6
IICEPDTONR
Extending a trend past the known data, such as running a trendline forward, to estimate a future value. It is an estimate, not a certainty, and gets less reliable the further ahead you go.
7
LHPE DAN STIOPLTO
Hover over a button to read its tooltip, open the Help menu or type your task into the app's search box, then try the feature on a copy of your file so you can undo any mistakes.
8
TLCC+R, TVLR+C, ZTCL+R
Keyboard shortcuts that copy, paste and undo faster than using menus. Ctrl+X cuts, Ctrl+S saves and Ctrl+F finds. On a Mac, press Cmd instead of Ctrl.
Answer Key
Years 7–8 Data & Information · Modules 47–80
1TREAEC BLATE → Create table — Make a new table by adding fields in design view, then type each record into its own row in datasheet view. Save the table so your data is kept.
2RSTO NDA ILTREF → sort and filter — Sort puts records in order by one field, either ascending (A to Z, small to big) or descending. Filter shows only the records that match a chosen value and hides the rest.
3HEERW EROCS > 08 → WHERE Score > 80 — A criterion that limits a query to records where the condition is true, so only Score values above 80 are shown. Compare with =, <>, <, >, <=, >=. Text goes in quotes.
4EORRD YB CEROS CDES → ORDER BY Score DESC — Sorts query results by the Score field from highest to lowest. Use ASC for lowest to highest. Add a second field after a comma to sort ties, like ORDER BY Score DESC, Name.
5GGRGEATAE ONTUICNF → aggregate function — A query function like COUNT, SUM, AVG, MIN or MAX that looks at many records and gives one answer, such as how many records match or the average of a field.
6IICEPDTONR → prediction — Extending a trend past the known data, such as running a trendline forward, to estimate a future value. It is an estimate, not a certainty, and gets less reliable the further ahead you go.
7LHPE DAN STIOPLTO → Help and tooltips — Hover over a button to read its tooltip, open the Help menu or type your task into the app's search box, then try the feature on a copy of your file so you can undo any mistakes.
8TLCC+R, TVLR+C, ZTCL+R → Ctrl+C, Ctrl+V, Ctrl+Z — Keyboard shortcuts that copy, paste and undo faster than using menus. Ctrl+X cuts, Ctrl+S saves and Ctrl+F finds. On a Mac, press Cmd instead of Ctrl.