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

OR

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

Weekly challenge 4

1st grade

Graded 96.87%

Question 1

A data analytics team labels its files to indicate their content, creation date, and version number. The team is using what data organization tool?

A. File-naming conventions

B. File-naming verifications

C. File-naming attributes

D. File-naming references

The correct answer is A. File-naming conventions

Question 2

Your boss assigns you a new multi-phase project and you create a naming convention for all of your files. With this project lasting years and incorporating multiple analysts it’s crucial that you create data explaining how your naming conventions are structured. What is this data called?

A. Metadata

B. Named convention

C. Descriptive data

D. Labeled data

The correct answer is A. Metadata

Question 3

Which of the following are examples of effective file names? Select all that apply.

• NewCustomerSurvey 2020-6-20 V03
• NewCustomerSurvey-2020-6-20-V03
• NewCustomerSurvey_2020_6_20_V03
• NewCustomerSurvey_2020-6-20_V03

Question 4

Foldering may be used by data analysts to organize folders into what?

A. Databases

B. Versions

C. Tables

D. Subfolders

The correct answer is D. Subfolders

Question 5

A data analyst deletes an old project’s files from their active project folder. A few months later, they have to review the work that they completed on this project but cannot find the older project files. What should the data analyst have done?

A. Archive the project

B. Delete the project

C. Email the project

D. Print the project

The correct answer is A. Archive the project

Question 6

Fill in the blank: Data analysts create _____ to structure their folders.

A. hierarchies

B. scales

C. sequences

D. ladders

Data analysts create hierarchies to structure their folders

Question 7

Using encryption to protect data is an example of what?

A. Data ethics

B. Data validation

C. Data security

D. Data integrity

The correct answer is C. Data security

Question 8

A data analyst wants to share spreadsheet tab A with their team. They’re still working with tabs B and C, and they don’t want their team members to access them yet. Hiding tabs B and C will protect them from being accessed. True or False?

A. True

B. False

2nd grade

Passed 100%

Question 1

Which of the following are best practices when organizing data? Select all that apply.

• Align your naming and storage practices with your team
• Use foldering to organize files into folders
• Delete your old project data
• Apply logical and descriptive naming conventions

Question 2

Your boss assigns you a new multi-phase project and you create a naming convention for all of your files. With this project lasting years and incorporating multiple analysts it’s crucial that you create data explaining how your naming conventions are structured. What is this data called?

A. Labeled data

B. Descriptive data

C. Metadata

D. Named convention

The correct answer is C. Metadata

Question 3

A data analyst is working with a file from a customer satisfaction survey. The survey was sent to anyone who became a new customer between April and June, 2020. Which of the following are effective names for the file?

A. NewCustomerSurvey_2020-6-20_V03

B. Apr2020_CustSurvey_V

C. April_May_June_2020_Responses_to_New_Customer_Survey_ANALYSISDATA_928310

D. Survey_Responses

The correct answer is A. NewCustomerSurvey_2020-6-20_V03

Question 4

As a data analyst, you will have multiple files for any given project. What is the process called to organize these files in a useful manner?

A. Decluttering

B. Naming convention

C. Foldering

D. Project structure

The correct answer is C. Foldering

Question 5

Data analysts use archiving to separate current from past work. What does this process involve?

A. Please reviewing current data files to confirm they’ve been cleaned

B. Reorganizing and renaming current files

C. Using secure data-erase software to destroy old files

D. Moving files from completed projects to another location

The correct answer is D. Moving files from completed projects to another location

Question 6

As a data analyst, folder organization is key to being efficient at your job. A common practice is to lay out your folders with broad topics at the top with more specific topics at the bottom. What’s the name of this approach?

A. Bottom to top

B. Hierarchy

C. Left to right

D. Heterachy

The correct answer is B. Hierarchy

Question 7

A data analyst wants to ensure only people on their analytics team can access, edit, and download a spreadsheet. They can use which of the following tools? Select all that apply.

• Filtering
• Templates
• Encryption
• Sharing permissions

Question 8

You are working on an in-depth spreadsheet that contains multiple complex formulas. You decide that these formulas are creating clutter in the spreadsheet. What housekeeping step can you take to clean up the spreadsheet?

A. Copy the tab

B. Protect the tab

C. Hide the tab

D. Delete the tab

The correct answer is C. Hide the tab