Years 7–8 Data & Information Crossword: Acquiring, storing and validating data to Using digital tools and conventions (Modules 47–80)
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
10
Across
- 5. 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. (10)
- 7. 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. Word 3 of: Help and ________ (8)
- 9. A query ______ 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. Word 2 of: aggregate ________ (8)
- 10. 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. Word 1 of: _____ BY _____ DESC (5)
Down
- 1. A query that lists the fields to show. Only Name and ______ appear, in that order, so other columns are left out. ______ * shows every field. Word 1 of: ______ Name, _____ ____ Students (6)
- 2. Word 4 of the term in 1 Down: ______ Name, _____ ____ Students (4)
- 3. ______ puts records in order by one field, either ascending (A to Z, small to big) or descending. ______ shows only the records that match a chosen value and hides the rest. Word 1 of: ____ and ______ (4)
- 4. Choose the program whose features suit the job: a word processor for writing, a spreadsheet for numbers, slides for talks, or a drawing ______ for pictures. Word 3 of: match the ____ to the task (4)
- 6. Word 3 of the term in 3 Down: ____ and ______ (6)
- 8. Word 3 of the term in 1 Down: ______ Name, _____ ____ Students (5)
Answer Key
Years 7–8 Data & Information · Modules 47–80
1S
E
L
2F
E
3S
4T
5P
R
E
D
I
C
T
I
O
N
O
O
T
R
O
6F
M
7T
O
O
L
T
I
P
8S
L
C
9F
U
N
C
T
I
O
N
E
R
10O
R
D
E
R
Across
5PREDICTION — 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.
7TOOLTIPS — 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. Word 3 of: Help and ________
9FUNCTION — A query ______ 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. Word 2 of: aggregate ________
10ORDER — 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. Word 1 of: _____ BY _____ DESC
Down
1SELECT — A query that lists the fields to show. Only Name and ______ appear, in that order, so other columns are left out. ______ * shows every field. Word 1 of: ______ Name, _____ ____ Students
2FROM — Word 4 of the term in 1 Down: ______ Name, _____ ____ Students
3SORT — ______ puts records in order by one field, either ascending (A to Z, small to big) or descending. ______ shows only the records that match a chosen value and hides the rest. Word 1 of: ____ and ______
4TOOL — Choose the program whose features suit the job: a word processor for writing, a spreadsheet for numbers, slides for talks, or a drawing ______ for pictures. Word 3 of: match the ____ to the task
6FILTER — Word 3 of the term in 3 Down: ____ and ______
8SCORE — Word 3 of the term in 1 Down: ______ Name, _____ ____ Students