Module 2 Flashcards

1
Q

Database

A

a collection of data stored in a computer system

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

In the data life cycle, which phase involves using data to solve problems, make good decisions, and support business goals?

A

Analyze

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

6 stages of the data life cycle

A

Plan, capture, manage, analyze, archive, destroy

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Plan

A

Decide what kind of data is needed, how it will be managed, and who will be responsible for it

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Capture

A

Collect or bring in data from a variety of different sources

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Manage

A

Care for and maintain the data. This includes determining how and where it is stored and the tools used to do so

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Analyze

A

Use the data to solve problems, make decisions, and support business goals

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Archive

A

Keep relevant data stored for long-term and future reference

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Destroy

A

Remove data from storage and delete any shared copies of the data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Stakeholders

A

People who have invested time and resources into a project and are interest in the outcome

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

2 popular spreadsheets that data analysts use

A

Microsoft Excel and Google Sheets

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Formula

A

A set of instructions that performs a specific calculation using the data in a spreadsheet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Function

A

A preset command that automatically performs a specific process or task using the data in a spreadsheet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Query language

A

A computer programming language that allows you to retrieve and manipulate data from a database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly