Cleaning and Presenting Data

Gathering Data

100

This is a list of questions aimed at gathering specific data from a particular group of people.

Survey

200

This term means to ask, inquire, question, interrogate, or search.

Query

300

This is a type of survey question that forces users to answer two questions at once.

Double-barreled questions

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

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

Cleaning Data

100

The process of putting data into organized groups.  

Categorizing Data

200

The process of amending or removing data that is incorrect, incomplete, improperly formatted or duplicated.

Data Cleaning

OR

Data Scrubbing

300

Data that has been gathered but contains problems is known as what? 

Dirty Data

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

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

Understanding Data

100

What is the difference between editing data and formatting data?

Editing changes the meaning of data

Formatting changes the appearnace of data

200

A pattern of change over time.

Trend

300

This type of data is numerical.  For example:  Height, weight, speed, amount.

Quantitative Data

400

This type of data is categorical.  For example:  color, gender, location

Qualitative Data

500

A term used to describe the use of graphical displays to summarize and present information about a data set.

Data Visualization

Presenting Data

100

Name 2 ways that the results from a Google Form survey can be presented.

Summary

Spreadsheet or Datasheet

Chart or Graph

Table 

200

This is an online tool used to identify trends and patterns about a particular topic.

Google Trends

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

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

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

Random

100

A type of chart that presents data in vertical bars.  

Column Chart

200

A data statistics term that means average

Median

300

What type of chart is this?

Scatter Plot Chart

OR 

Scatter Chart

400

In Google Sheets, where are the tools for editing and formatting charts located 

In the "Chart Editor" window

500

What does a slicer do? 

Filters data