Gathering Data
Cleaning Data
Understanding Data
Presenting Data
Random
100
This is a list of questions aimed at gathering specific data from a particular group of people.
Survey
100
The process of putting data into organized groups.
Categorizing Data
100
What is the difference between editing data and formatting data?
Editing changes the meaning of data
Formatting changes the appearnace of data
100
Name 2 ways that the results from a Google Form survey can be presented.
Summary
Spreadsheet or Datasheet
Chart or Graph
Table
100
A type of chart that presents data in vertical bars.
Column Chart
200
This term means to ask, inquire, question, interrogate, or search.
Query
200
The process of amending or removing data that is incorrect, incomplete, improperly formatted or duplicated.
Data Cleaning
OR
Data Scrubbing
200
A pattern of change over time.
Trend
200
This is an online tool used to identify trends and patterns about a particular topic.
Google Trends
200
A data statistics term that means average
Median
300
This is a type of survey question that forces users to answer two questions at once.
Double-barreled questions
300
Data that has been gathered but contains problems is known as what?
Dirty Data
300
This type of data is numerical. For example: Height, weight, speed, amount.
Quantitative Data
300
This is a data set that is organized into a table so that it is easier to manipulate and understand.
Summary Table
OR
Pivot Table
300
What type of chart is this?
Scatter Plot Chart
OR
Scatter Chart
400
This is a type of survye question that forces a user to answer in a way that does not accurately express their opinion.
For example: What is your favorite class; Computer or History.
Loaded Queston
400
The rules enforced on the data columns of a table. These are used to limit the type of data that can go into a table. This ensures the accuracy and reliability of the data in the database.
Data Constraint Rules
400
This type of data is categorical. For example: color, gender, location
Qualitative Data
400
List 3 different ways that data can be presented (can't use the same category twice)
Chart or Graph (pie, line, column, bar, area, scatter)
Table (pivot or summary)
Infographic or Graphic Design
Written Summary or Data Story
400
In Google Sheets, where are the tools for editing and formatting charts located
In the "Chart Editor" window
500
A large database that collects, manages, and stores data sets used for data analysis, sharing and reporting.
Data Repository, Data Library, or Data Archive
500
Validating one form control based on the value of another. For example: data showing how many points scored by each player on a team must equal the point total for the entire team.
Cross Field Validation
500
A term used to describe the use of graphical displays to summarize and present information about a data set.
Data Visualization
500
List the 4 main steps for creating a column chart in Google Sheets
Select the data,
Click the "Insert Menu",
Select "Chart",
Choose Column
500
What does a slicer do?
Filters data