WorksheetsGrd 6 Unit 2: Managing Data - Formative
Total questions: 20
Worksheet time: 10mins
What is discrete data? Fill in the blank: Discrete data is numerical data that can only have certain values, often ________ (e.g., shoe size or the number of people).
whole numbers
fractions
decimals
percentages
What is continuous data? Fill in the blank: Continuous data is numerical data that can have ________ within a certain range, often including decimals (e.g., temperature or height).
any value
only whole numbers
fixed categories
a single value
What is categorical data? Fill in the blank: Categorical data is data that can be ________, often words (e.g., colors or animal types).
grouped into categories
measured in numbers
used for calculations
represented as fractions
Which of the following is an example of a tool used to keep track of expenses?
Spreadsheets
Databases
Data loggers
Forms
Which tool is best described as a collection of information?
Spreadsheets
Databases
Data loggers
Forms
Which tool is used to record temperatures every hour?
Spreadsheets
Databases
Data loggers
Forms
When collecting continuous data using a form, what type of question is often best to use?
Multiple choice questions
Open text questions
True/False questions
Matching questions
It is important to organize data when we collect a large amount of it because:
it helps us find and use information easily.
it makes the data more difficult to understand.
it increases the chances of losing data.
it prevents us from analyzing the data.
What is a cell reference in a spreadsheet?
It is how we locate a specific box (cell) in the spreadsheet.
It is a formula used to calculate totals in a spreadsheet.
It is the name of a spreadsheet file.
It is a type of chart used in spreadsheets.
Which symbol is used for addition in spreadsheet arithmetic operators?
-
+
*
/
Which function is used to add a group of numbers together in a spreadsheet?
SUM
AVERAGE
MULTIPLY
DIVIDE
What does the AVERAGE function do in a spreadsheet?
It finds the mean of data.
It sorts the data alphabetically.
It multiplies all the numbers together.
It finds the highest value in the data.
What is a database?
A database is a way of storing data on a computer so that it can be easily used and added to.
A database is a type of computer virus.
A database is a programming language used to create websites.
A database is a device used to print documents.
In a database, what is a field?
A field is the category or column heading of data in a database.
A field is a type of database software.
A field is the name of a database user.
A field is a type of network protocol.
In a database, what is a record?
A record is a row of data in a database, containing all the information about one item.
A record is a column in a database that stores only numerical data.
A record is a type of database software.
A record is a command used to delete data from a database.
In a database, what is an attribute?
An attribute is the individual piece of data found within one field of a record.
An attribute is a type of database software.
An attribute is a collection of tables in a database.
An attribute is the process of updating a database.
What are two main ways to organize data in a database?
Ordering and Filtering.
Copying and Deleting.
Printing and Scanning.
Encrypting and Decrypting.
What does ordering mean in the context of databases?
Ordering means instructing the computer to arrange the information in a specific way, such as alphabetical order or numerical order.
Ordering means deleting all the information from the database.
Ordering means creating a backup of the database.
Ordering means encrypting the data for security purposes.
What does filtering mean in the context of databases?
Filtering means instructing the computer to show only the records that match a certain condition.
Filtering means deleting all records from the database.
Filtering means creating a backup of the database.
Filtering means sorting the records in alphabetical order.
What is phrase searching in a database?
Phrase searching is finding information by searching for more than one word in the database, which helps narrow down your search results.
Phrase searching is searching for a single letter in the database.
Phrase searching is using only numbers to find information in the database.
Phrase searching is searching for information by using only one word at a time.
