Years 7–8 Data & Information Definitions Worksheet: Acquiring, storing and validating data to Using digital tools and conventions (Modules 47–80)
Name:
Date:
Class:
✎
Key terms
Write what each term means, in your own words.
1
Create table
2
sort and filter
3
SELECT Name, Score FROM Students
4
WHERE Score > 80
5
ORDER BY Score DESC
6
aggregate function
7
prediction
8
match the tool to the task
9
Help and tooltips
10
Ctrl+C, Ctrl+V, Ctrl+Z
Answer Key
Years 7–8 Data & Information · Modules 47–80 · Student wording will vary for definitions
1Create 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.
2sort 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.
3SELECT Name, Score FROM Students — A query that lists the fields to show. Only Name and Score appear, in that order, so other columns are left out. SELECT * shows every field.
4WHERE 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.
5ORDER 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.
6aggregate 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.
7prediction — 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.
8match the tool to the task — Choose the program whose features suit the job: a word processor for writing, a spreadsheet for numbers, slides for talks, or a drawing tool for pictures.
9Help 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.
10Ctrl+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.