Glossary: Terms and definitions

We’ve covered a lot of terms—some of which you may have already known, and some of which are new. To make it easy to remember what a word means, we created this glossary of terms and definitions.

To use the glossary for this course item, click the link below and select “Use Template.”

Link to glossary: Week 1 Glossary

OR

If you don’t have a Google account, you can download the glossary directly from the attachment below.

Course 5 Week 1 Glossary _ DA terms and definitions (1)

Weekly challenge 1

1st grade

Question 1

Which phase of the data analysis process has the goal of identifying trends and relationships?

A. Prepare

B. Act

C. Process

D. Analyze

The correct answer is D. Analyze

Question 2

During which of the four phases of analysis do you gather the relevant datasets into an usable structure for a project?

A. Format and adjust data

B. Get input from others

C. Transform data

D. Organize data

The correct answer is D. Organize data.

Question 3

A data analyst is working on a dataset and begins the transform dataphase of analysis. What are some of the actions that they will take? Select all that apply.

• Performing a calculation with data
• Deleting data
• Finding a correlation in data
• Archiving data

Question 4

A data analyst investigating a data set is interested in showing only data that matches given criteria. What is this known as?

A. Filtering

B. Measuring

C. Modeling

D. Sorting

The correct answer is A. Filtering

Question 5

A data analyst is sorting data in a spreadsheet. They select a specific collection of cells in order to limit the sorting to just specified cells. Which spreadsheet tool are they using?

A. Sort Range

B. Limit Range

C. Sort Sheet

D. Limit Sort

The correct answer is A. Sort Range

Question 6

A data analyst sorts a spreadsheet range between cells F19 and G82. They sort in ascending order by the second column, Column G. What is the syntax they are using?

A. =SORT(F19:G82, 2, FALSE)

B. =SORT(F19:G82, 2, TRUE)

C. =SORT(F19:G82, B, FALSE)

D. =SORT(F19:G82, B, TRUE)

The correct syntax is B. =SORT(F19:G82, 2, TRUE)

Question 7

You are querying a database that contains data about music. Each musical genre is given an ID number. You are only interested in data related to the genre with ID number 2. The genre IDs are listed in the genre_id column.

You write the following SQL query, but it is incorrect. What is wrong with the query?

SELECT *
FROM Track
WHERE composer = 2

A. Composer is not capitalized in line 3.

B. Composer should be genre_id in line 3.

C. SELECT, FROM, and WHERE are capitalized.

D. Line 3 contains an equal sign.

The correct answer is B. Composer should be genre_id in line 3.

Question 8

You are working with a database that contains invoice data about online music purchases. You are only interested in invoices sent to customers located in the city of Delhi. You want to sort the invoices by order total in ascending order. The order totals are listed in the total column.

You write the SQL query below. However this query is incorrect. What is wrong with it?

SELECT *
FROM invoice
WHERE billing_city = “Delhi”
ORDER BY order_total

A. SELECT, FROM, WHERE, and ORDER BY are capitalized.

B. In line 3, “Delhi” has quotation marks.

C. In line 4, order_total should be total.

D. Line 4 contains the word BY.

The correct answer is C. In line 4, order_total should be total.

2nd grade

Question 1

Which of the following tasks would a data analyst perform during the analyze phase of the data analysis process? Select all that apply.

• Preparing a report for the stakeholders
• Visualizing the data with charts
• Getting input from others
• Organizing data into understandable sections

Question 2

After collecting the relevant datasets for their analysis, a data analyst compares this data to external sources. In which of the four phases of analysis does this occur?

A. Get input from others

B. Organize data

C. Transform data

D. Format and adjust data

The correct answer is A. Get input from others

Question 3

Which of the following actions might occur when transforming data? Select all that apply.

• Identify a pattern in your data
• Recognize relationships in your data
• Make calculations based on your data
• Eliminate irrelevant into from your data

Question 4

A data analyst working on a very large dataset decides to narrow the scope of the data that they are working with in order to make the analysis more manageable. What can they use to narrow the amount of data?

A. Modelling

B. Sorting

C. Measuring

D. Filtering

The correct answer is D. Filtering

Question 5

A data analyst is sorting spreadsheet data. They use the spreadsheet tool Sort Sheet. What does this tool do?

A. It allows the analyst to sort by a specific sorted row.

B. It sorts all of the data in a spreadsheet by a specific sorted column.

C. It sorts all of the data in a spreadsheet by the ranking of a specific sorted row.

D. It allows the analyst to sort a specific selection of cells only.

The correct answer is B. It sorts all of the data in a spreadsheet by a specific sorted column.

Question 6

A data analyst uses a function to sort a spreadsheet range between cells H1 and K65. They sort in ascending order by the first column, Column H. What is the syntax they are using?

A. =SORT(H1:K65, A, TRUE)

B. =SORT(H1:K65, A, FALSE)

C. =SORT(H1:K65, 1, TRUE)

D. =SORT(H1:K65, 1, FALSE)

The correct answer is C. =SORT(H1:K65, 1, TRUE)

Question 7

You are querying a database that contains data about music. Each album is given an ID number. You are only interested in data related to the album with ID number 3. The album IDs are listed in the album_id column.

You write the following SQL query, but it is incorrect. What is wrong with the query?

SELECT *
FROM Track
WHERE album = 3

A. SELECT, FROM, and WHERE should be capitalized.

B. In line 3, album is not capitalized.

C. Line 3 contains an equal sign.

D. In line 3, album should be album_id.

The correct answer is D. In line 3, album should be album_id.

Question 8

You write the SQL query below. However this query is incorrect. What is wrong with it?

SELECT *
FROM invoice
WHERE billing_city = “Chicago”
ORDER total

A. SELECT, FROM, WHERE, and ORDER are capitalized.

B. Line 4 is missing column = between ORDER and total.

C. In line 3, “Chicago” has quotation marks.

D. Line 4 is missing the BY between ORDER and total.

The error is Line 4 is missing the BY between ORDER and total

3rd grade

Passed 100%

Question 1

In the data analysis process, which of the following refers to a phase of analysis? Select all that apply.

• Format data using sorts and filters
• Visualize the data
• Organize data into understandable sections
• Get input from others

Question 2

A data analyst is collecting all the datasets that are relevant to their project. Which of the four phases of analysis is the data analyst in?

A. Format and adjust data

B. Transform data

C. Get input from others

D. Organize data

The correct answer is D. Organize data

Question 3

A data analyst examining a data set attempts to determine if there are any patterns in the data. What phase of analysis is the analyst in?

A. Organize data

B. Get input from others

C. Transform data

D. Format and adjust data

The correct answer is C. Transform data

Question 4

Typically, a data analyst uses filters when they want to expand the amount of data they are working with. True or False?

A. True

B. False

It is false statement

Question 5

A data analyst is sorting spreadsheet data. What tool should they use to make sure that the data across rows is kept together when they rearrange the data?

A. Sort rows

B. Sort column

C. Sort sheet

D. Sort together

The correct answer is C. Sort sheet

Question 6

A data analyst sorts a spreadsheet range between cells A15 and G71. They sort in ascending order by the second column, Column B. What is the syntax they are using?

A. =SORT(A15:G71, B, TRUE)

B. =SORT(A15:G71, 2, TRUE)

C. =SORT(A15:G71, 2, FALSE)

D. =SORT(A15:G71, B, FALSE)

The correct answer is B. =SORT(A15:G71, 2, TRUE)

Question 7

You are querying a database that contains data about music. Each musical genre is given an ID number. You are only interested in data related to the genre with ID number 2. The genre IDs are listed in the genre_id column.

You write the following SQL query, but it is incorrect. What is wrong with the query?

SELECT *
FROM Track
WHERE composer = 2

A. Composer is not capitalized in line 3.

B. Line 3 contains an equal sign.

C. SELECT, FROM, and WHERE are capitalized.

D. Composer should be genre_id in line 3.

The correct answer is D. Composer should be genre_id in line 3.

Question 8

You are working with a database that contains invoice data about online music purchases. You are only interested in invoices sent to customers located in the city of Delhi. You want to sort the invoices by order total in ascending order. The order totals are listed in the total column.

You write the SQL query below. However this query is incorrect. What is wrong with it?

SELECT *
FROM invoice
WHERE billing_city = “Delhi”
ORDER BY order_total 

A. Line 4 contains the word BY.

B. SELECT, FROM, WHERE, and ORDER BY are capitalized.

C. In line 3, “Delhi” has quotation marks.

D. In line 4, order_total should be total.

The correct answer is D. In line 4, order_total should be total.