Font size
WorksheetsUnit 3 - Managing data (Grade 6)
Total questions: 39
Worksheet time: 57mins
A computer application that uses rows and columns to organise data and carry out calculations using that data.
(a)
An area where a row and column intersect and data can be entered.
(a)
A combination of letters and numbers used to identify individual cells in a spreadsheet. e.g. the top left cell is A1
(a)
Multiple cells grouped together. The cell reference for a range is the top left cell, followed by a ":", followed by the bottom right cell. e.g. B2:D3
(a)
A combination of numbers, mathematical symbols, cell references and functions used to process data in a spreadsheet.
(a)
An area in the spreadsheet window where a formula can be entered.
(a)
The act of searching a database for records based on conditions the user inputs.
(a)
Symbols used to compare values, e.g. >= meaning greater than or equal to.
(a)
+, –, *, / and other symbols that can be used for maths.
(a)
Something that is checked to determine whether it is true or false.
(a)
The act of making a cell automatically look different depending on a specific rule.
(a)
what do we call this comparison operator:
<=
(a)
what do we call this comparison operator:
>=
(a)
what do we call this comparison operator:
!=
(a)
what do we call this comparison operator:
>
(a)
what do we call this comparison operator:
<
(a)
what do we call this comparison operator:
<>
(a)
what are the two methods of data analysis?
(a)
A computer application that is used to organise data that can then be stored, processed and accessed electronically.
(a)
One column of a database.
(a)
The title of a field; a word or phrase used to describe the contents of a field in a database.
(a)
A value that is unique for every record in a database and can be used to identify a record.
(a)
A form designed to collect data for a specific task.
(a)
A computer application that is used to organise data that can then be stored, processed and accessed electronically.
(a)
Easy to use or understand.
(a)
A particular way in which a computer can store data.
(a)
A whole number.
(a)
the following words best describes (a) :
interactive, real-time, training
the following words, best describes (a) :
Data, predict and copies real-life
a special kind of sheet or document that helps us collect and organize information about different things.
(a)
what are the 3 criteria for an effective data capture form?
(a)
a digital data representation of a real life scenario, the scenario is broken down into individual attributes which are represented as data items.
(a)
Raw facts and figures.
(a)
A model that is interactive using formulae to change the model in real-time. Simulators can be used to predict outcomes and are particularly useful in training and experiments.
(a)
a type of business or money-making activity
(a)
Is a simplified version of something that helps us understand how it works. This is like a smaller representation of a bigger idea.
(a)
a special type of computer program or device that mimics, or copies, the way something works in real life.
(a)
Explain what is a model
explain what is a simulator
