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 3 Glossary

OR

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

Weekly challenge 3

1st

Grade received 87.50%

Question 1

Fill in the blank: A business is determining who should be responsible for the data in their current data analysis project. This means that the company is in the ______ stage of the data life cycle.

A. manage

B. capture

C. plan

D. analyze

The correct answer is C. plan

Question 2

The destroy stage of the data life cycle might involve which actions? Select all that apply.

• Using data-erasure software
• Shredding paper files
• Storing data for future use
• Uploading data to the cloud

Question 3

In the analyze phase of the data life cycle, what might a data analyst do? Select all that apply.

• Create a report from their data
• Chooses the format of their spreadsheet headings
• Use a formula to perform calculations
• Use spreadsheets to aggregate data

Question 4

Fill in the blank: Data analysis has six process steps whereas the data life cycle has six _____.

A. data analytics tools

B. key questions

C. stages

D. steps

So the correct answer is C. stages

Question 5

Fill in the blank: In the act phase of the data analysis process, a company may need to _____ the insights of the data analysis team.

A. calculate

B. validate

C. revise

D. accomplish

The correct answer is B. validate

Question 6

A set of instructions used to perform a specified calculation is known as what?

A. A function

B. A formula

C. A predefined statement

D. A particular value

The correct answer is B. A formula

Question 7

In the course of their current project, a data analyst uses a query to retrieve and request information. Which of the following is a third option they can use a query for?

A. Visualizing data

B. Updating data

C. Deleting data

D. Collecting data

The correct answer is B. Updating data

Question 8

Fill in the blank: Structured query language (SQL) enables data analysts to retrieve, update, and request information from a database. The tool they use to do this is called a _______.

A. dashboard

B. query

C. visualization

D. spreadsheet

The correct answer is B. query

2nd

Grade received 93.75%

Question 1

In the plan stage of the data life cycle, what decisions would a data analyst make? Select all that apply.

• How the data will be analyzed
• Who will be responsible for the data
• What kind of data is needed
• [] How the data will be managed

Question 2

Fill in the blank: Shredding paper files and using data-erasure software would be actions taken by a data analyst in the _________ stage of the data lifecycle.

A. Manage

B. Archive

C. Destroy

D. Plan

Question 3

In the analyze phase of the data life cycle, what might a data analyst do? Select all that apply.

• Use spreadsheets to aggregate data
• Chooses the format of their spreadsheet headings
• Create a report from their data
• Use a formula to perform calculations

Question 4

Fill in the blank: The data life cycle has six stages, whereas data analysis has six _____.

A. key questions

B. process steps

C. data analytics tools

D. data types

Question 5

A business analyst recently completed a project that their company has decided to use to solve a larger business problem. What step is this in the data analysis process?

A. Share

B. Analyze

C. Act

D. Process

Question 6

What is the main difference between a formula and a function?

A. A formula can be used multiple times in a spreadsheet; a function can only be used once.

B. A formula is a set of instructions used to perform a specified calculation; a function is a preset command that automatically performs a specified process.

C. A formula begins with an equal sign (=); a function begins with an asterisk (*).

D. A formula is used to add or subtract; a function is used to multiply or divide.

Question 7

Which of the following is an example of what a data analyst uses a query for?

A. Deleting data

B. Visualizing data

C. Collecting data

D. Requesting data

Question 8

Why is SQL the most popular structured query language? Select all that apply.

• SQL allows data analytics to use spreadsheets
• SQL is the most secure database on the market
• SQL works with a wide variety of databases
• SQL is easy to understand

3rd

Question 1

Fill in the blank: A business decides what kind of data it needs, how the data will be managed, and who will be responsible for it during the _____ stage of the data life cycle.

A. manage

B. capture

C. analyze

D. plan

Incorrect. The correct answer is C. analyze

Question 2

In the destroy phase of the data lifecycle, a data analyst might shred paper files. True or False?

A. True

B. False

Question 3

A data analyst is working at a small tech startup. On their current project they are in the analyze stage of the data life cycle. What might they do in this stage?

A. Determine who is responsible for managing the data

B. Use a formula to perform calculations

C. Validate the insights provided by analysts

D. Choose the format of their spreadsheet headings

Question 4

Fill in the blank: Data analysis has six process steps whereas the data life cycle has six _____.

A. steps

B. stages

C. key questions

D. data analytics tools

Question 5

A business analyst recently completed a project that their company has decided to use to solve a larger business problem. What step is this in the data analysis process?

A. Analyze

B. Share

C. Act

D. Process

Question 6

In data analysis, a predefined operation is known as what?

A. A particular value

B. A function

C. A predefined statement

D. A formula

Question 7

Which of the following is an example of what a data analyst uses a query for?

A. Deleting data

B. Visualizing data

C. Collecting data

D. Requesting data

Question 8

A data analyst wants to retrieve information from a database. Select the correct tool from the data analyst’s toolkit.

A. Spreadsheet

B. Query

C. Visualization

D. Dashboard

4th

Question 1

Fill in the blank: A business is determining who should be responsible for the data in their current data analysis project. This means that the company is in the ______ stage of the data life cycle.

A. manage

B. analyze

C. capture

D. plan

It is false answer.

Question 2

In the destroy phase of the data lifecycle, a data analyst might shred paper files. True or False?

A. True

B. False

It is true statement.

Question 3

A data analyst uses a spreadsheet function to aggregate data. Then, they add a pivot table to show totals from least to greatest. This would happen during which phase of the data life cycle?

A. Capture

B. Analyze

C. Plan

D. Manage

The correct answer is B. Analyze

Question 4

Fill in the blank: The data life cycle has six _____ .

A. process steps

B. key questions

C. data analytics tools

D. stages

The data life cycle has six stages.

Question 5

A company takes insights provided by its data analytics team, validates them, and finalizes a strategy. They then implement a plan to solve the original business problem. This describes which step of the data analysis process?

A. Act

B. Share

C. Analyze

D. Process

The correct answer is A. Act

Question 6

A set of instructions used to perform a specified calculation is known as what?

A. A particular value

B. A function

C. A predefined statement

D. A formula

The correct answer is D. A formula

Question 7

In the course of their current project, a data analyst uses a query to retrieve and request information. Which of the following is a third option they can use a query for?

A. Visualizing data

B. Updating data

C. Deleting data

D. Collecting data

It is false answer.

Question 8

A data analyst wants to retrieve information from a database. Select the correct tool from the data analyst’s toolkit.

A. Query

B. Spreadsheet

C. Visualization

D. Dashboard

The correct answer is A. Query

5th

Question 1

You are in the plan stage of the data lifecycle for your current project. What action might you take during this stage?

A. Shred paper files

B. Decide what kind of data is needed

C. Validate insights provided by analysts

D. Use a formula to perform calculations

The correct answer is B. Decide what kind of data is needed

Question 2

A data analyst is working at a small tech startup. They’ve just completed an analysis project, which involved private company information about a new product launch. In order to keep the information safe, the analyst uses secure data-erasure software for the digital files and a shredder for the paper files. Which state of the data life cycle does this describe?

A. Archive

B. Manage

C. Plan

D. Destroy

The correct answer is D. Destroy

Question 3

In the analyze phase of the data life cycle, what might a data analyst do? Select all that apply.

• Use spreadsheets to aggregate data
• Create a report from their data
• Chooses the format of their spreadsheet headings
• Use a formula to perform calculations

Question 4

Describe how the data life cycle differs from data analysis.

A. The data life cycle deals with making informed decisions; data analysis is using tools to transform data.

B. The data life cycle deals with identifying the best data to solve a problem; data analysis is about asking effective questions.

C. The data life cycle deals with transforming and verifying data; data analysis is using the insights gained from the data.

D. The data life cycle deals with the stages that data goes through during its useful life; data analysis is the process of analyzing data.

The correct answer is D. The data life cycle deals with the stages that data goes through during its useful life; data analysis is the process of analyzing data.

Question 5

Fill in the blank: In the _____ phase of the data analysis process, a data analytics team might validate the insights provided by analysts.

A. act

B. share

C. analyze

D. process

In the act phase of the data analysis process, a data analytics team might validate the insights provided by analysts.

Question 6

Fill in the blank: A formula is a set of instructions used to perform a specified calculation; whereas a function is _____.

A. a particular value

B. a computer programming language

C. a predefined operation

D. a question written by the user

A formula is a set of instructions used to perform a specified calculation; whereas a function is a predefined operation

Question 7

What does a data analyst use to request information within a database?

A. Query

B. Formula

C. Dashboard

D. Calculation

The correct answer is A. Query

Question 8

Structured query language (SQL) allows a data analyst to retrieve and request data from a database. What else is SQL used for?

A. Updating databases

B. Visualizing data within a database

C. The revising phase of the data life cycle

D. The sharing phase of the data life cycle

The correct answer is A. Updating databases