Course 1 & 2 Vocabulary

Question 1

A question whose answers lead to change

Answer 1

Action-oriented question

Question 2

A process or set of rules followed for a specific task

Answer 2

Algorithm

Question 3

Qualities and characteristics associated with using facts to solve problems

Answer 3

Analytical skills

Question 4

The process of identifying and defining a problem, then solving it by using data in an organized, step-by-step manner

Answer 4

Analytical thinking

Question 5

A characteristic or quality of data used to label a column in a table

Answer 5

Attribute

Question 6

A spreadsheet function that returns an average of the values from a selected range

Answer 6

AVERAGE

Question 7

Large, complex datasets typically involving long periods of time, which enable data analysts to address far-reaching business problems

Answer 7

Big data

Question 8

Lines that can be added around two or more cells on a spreadsheet

Answer 8

Borders

Question 9

The question or problem that data analysis resolves for a business

Answer 9

Business task

Question 10

A cell or a range of cells in a worksheet typically used in formulas and functions

Answer 10

Cell reference

Question 11

A place to keep data online, rather than a computer hard drive

Answer 11

Cloud

Question 12

The condition in which something exists or happens

Answer 12

Context

Question 13

A spreadsheet function that counts the number of cells in a range that meet a specific criteria

Answer 13

COUNT

Question 14

A tool that monitors live, incoming data

Answer 14

Dashboard

Question 15

A collection of facts

Answer 15

Data

Question 16

The collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision-making

Answer 16

Data Analysis

Question 17

The six phases of ask, prepare, process, analyze, share, and act whose purpose is to gain insights that drive informed decision-making

Answer 17

Data analysis process

Question 18

Someone who collects, transforms, and organizes data in order to draw conclusions, make predictions, and drive informed decision-making

Answer 18

Data analyst

Question 19

The science of data

Answer 19

Data analytics

Question 20

How information is organized

Answer 20

Data design

Question 21

Using facts to guide business strategy

Answer 21

Data-driven decision-making

Question 22

The various elements that interact with one another in order to produce, manage, store, organize, analyze, and share data

Answer 22

Data ecosystem

Question 23

Exploring different data sources to find out what they have in common

Answer 23

Data-inspired decision-making

Question 24

The sequence of stages that data experiences, which include plan, capture, manage, analyze, archive, and destroy

Answer 24

Data life cycle

Question 25

A field of study that uses raw data to create new ways of modeling and understanding the unknown

Answer 25

Data science

Question 26

The management of the people, processes, and tools used in data analysis

Answer 26

Data strategy

Question 27

The graphical representation of data

Answer 27

Data visualization

Question 28

A collection of data stored in a computer system

Answer 28

Database

Question 29

A collection of data that can be manipulated or analyzed as one unit

Answer 29

Dataset

Question 30

A calculation that involves addition, subtraction, multiplication, or division (also called a math expression)

Answer 30

Equation

Question 31

A quality of data analysis that does not create or reinforce bias

Answer 31

Fairness

Question 32

A box in the lower-right-hand corner of a selected spreadsheet cell that can be dragged through neighboring cells in order to continue an instruction

Answer 32

First handle

Question 33

The process of showing only the data that meets a specified criteria while hiding the rest

Answer 33

Filtering

Question 34

A set of instructions used to perform a calculation using the data in a spreadsheet

Answer 34

Formula

Question 35

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

Answer 35

Function

Question 36

A method for examining and evaluating the current state of a process in order to identify opportunities for improvement in the future

Answer 36

Gap analysis

Question 37

The first row in a spreadsheet that labels the type of data in each column

Answer 37

Header

Question 38

A question that steers people toward a certain response

Answer 38

Leading question

Question 39

A calculation that involves addition, subtraction, multiplication, or division (also called an equation)

Answer 39

Math expression

Question 40

A function that is used as part of a mathematical formula

Answer 40

Math function

Question 41

A spreadsheet function that returns the largest numeric value from a range of cells

Answer 41

MAX

Question 42

A question whose answers can be quantified and assessed

Answer 42

Measurable question

Question 43

A single, quantifiable type of data that is used for measurement

Answer 43

Metric

Question 44

A measurable goal set by a company and evaluated using metrics

Answer 44

Metric Goal

Question 45

A spreadsheet function that returns the smallest numeric value from a range of cells

Answer 45

MIN

Question 46

The attributes that describe a piece of data contained in a row of a table

Answer 46

Observation

Question 47

Data that is available to the public

Answer 47

Open data

Question 48

A symbol that names the operation or calculation to be performed

Answer 48

Operator

Question 49

Using parentheses to group together spreadsheet values in order to clarify the order in which operations should be performed

Answer 49

Order of operations

Question 50

A chart created from the fields in a pivot table

Answer 50

Pivot chart

Question 51

A data summarization tool used to sort, reorganize, group, count, total, or average data

Answer 51

Pivot table

Question 52

The area of analysis that encompasses every activity affecting or affected by a problem

Answer 52

Problem domain

Question 53

The various problems that data analysts encounter, including categorizing things, discovering connections, finding patterns, identifying themes, making predictions, and spotting something unusual

Answer 53

Problem types

Question 54

A subjective and explanatory measure of a quality or characteristic

Answer 54

Qualitative data

Question 55

A specific and objective measure, such as a number, quantity, or range

Answer 55

Quantitative data

Question 56

A request for data or information from a database

Answer 56

Query

Question 57

A computer programming language used to communicate with a database

Answer 57

Query language

Question 58

A collection of two or more cells in a spreadsheet

Answer 58

Range

Question 59

Restating a problem or challenge, then redirecting it toward a potential resolution

Answer 59

Reframing

Question 60

A question that has significance to the problem to be solved

Answer 60

Relevant question

Question 61

A static collection of data periodically given to stakeholders

Answer 61

Report

Question 62

A formula that uses the metrics of investment and profit to evaluate the success of an investment

Answer 62

Return on investment (ROI)

Question 63

The total amount of income generated by the sale of goods or services

Answer 63

Revenue

Question 64

The reason why a problem occurs

Answer 64

Root cause

Question 65

An agreed-upon outline of the tasks to be performed during a project

Answer 65

Scope of work (SOW)

Question 66

Small, specific data points typically involving a short period of time, which are useful for making day-to-day decisions

Answer 66

Small data

Question 67

A tool for determining a question’s effectiveness based on whether it is specific, measurable, action-oriented, relevant, and time-bound

Answer 67

SMART methodology

Question 68

The process of arranging data into a meaningful order to make it easier to understand, analyze, and visualize

Answer 68

Sorting

Question 69

A question that is simple, significant, and focused on a single topic or a few closely related ideas

Answer 69

Specific question

Question 70

A digital worksheet

Answer 70

Spreadsheet

Question 71

Refer to Structured Query Language

Answer 71

SQL

Question 72

People who invest time and resources into a project and are interested in its outcome

Answer 72

Stakeholders

Question 73

A computer programming language used to communicate with a database

Answer 73

Structured Query Language (SQL)

Question 74

The process of recognizing the current problem or situation, organizing available information, revealing gaps and opportunities, and identifying options

Answer 74

Structured thinking

Question 75

A spreadsheet function that adds the values of a selected range of cells

Answer 75

SUM

Question 76

The ability to break things down into smaller steps or pieces and work with them in an orderly and logical way

Answer 76

Technical mindset

Question 77

A question that specifies a timeframe to be studied

Answer 77

Time - bound question

Question 78

The rate at which employees voluntarily leave a company

Answer 78

Turnover rate

Question 79

A question that makes assumptions or is difficult to answer honestly

Answer 79

Unfair question

Question 80

(Refer to data visualization)

Answer 80

Visualization