WGU D465 TEST PREP COURSEWORK
SCRIPT STUDY SHEET 2026 GRADED A+.
⫸ CASE. Answer: A SQL statement that returns records that meet
conditions by including an if/then statement in a query
⫸ CAST. Answer: A SQL function that converts data from one
datatype to another
⫸ Causation. Answer: When an action directly leads to an outcome,
such as a cause-effect relationship
⫸ Cell reference. Answer: A cell or a range of cells in a worksheet
typically used in formulas and functions
⫸ Ruby. Answer: An object-oriented programming language for web
application development
⫸ Sample. Answer: In data analytics, a segment of a population that
is representative of the entire population
⫸ Sampling bias. Answer: Overrepresenting or underrepresenting
certain members of a population as a result of working with a sample
that is not representative of the population as a whole
,⫸ Scatterplot. Answer: A data visualization that represents
relationships between different variables with individual data points
without a connecting line
⫸ Schema. Answer: A way of describing how something, such as
data, is organized
⫸ Scope of work (SOW). Answer: An agreed-upon outline of the
tasks to be performed during a project
⫸ Second-party data. Answer: Data collected by a group directly
from its audience and then sold
⫸ SELECT. Answer: The section of a query that indicates from
which column(s) to extract the data
⫸ SELECT INTO. Answer: A SQL clause that copies data from one
table into a temporary table without adding the new table to the
database
⫸ Small data. Answer: Small, specific data points typically involving
a short period of time, which are useful for making day-to-day
decisions
⫸ SMART methodology. Answer: A tool for determining a question's
effectiveness based on whether it is specific, measurable, action-
oriented, relevant, and time-bound
,⫸ Social media. Answer: Websites and applications through which
users create and share content or participate in social networking
⫸ Soft skills. Answer: Nontechnical traits and behaviors that relate to
how people work
⫸ Sort range. Answer: A spreadsheet menu function that sorts a
specified range and preserves the cells outside the range
⫸ Sort sheet. Answer: A spreadsheet menu function that sorts all data
by the ranking of a specific sorted column and keeps data together
across rows
⫸ Sorting. Answer: The process of arranging data into a meaningful
order to make it easier to understand, analyze, and visualize
⫸ Specific question. Answer: A question that is simple, significant,
and focused on a single topic or a few closely related ideas
⫸ SPLIT. Answer: A spreadsheet function that divides text around a
specified character and puts each fragment into a new, separate cell
⫸ Sponsor. Answer: A professional advocate who is committed to
moving forward the career of another
, ⫸ Spotlightling. Answer: Scanning through data to quickly identify
the most important insights
⫸ Spreadsheet. Answer: A digital worksheet
⫸ SQL. Answer: (Refer to Structured Query Language)
⫸ Stakeholders. Answer: People who invest time and resources into a
project and are interested in its outcome
⫸ Static data. Answer: Data that doesn't change once it has been
recorded
⫸ Static visualization. Answer: A data visualization that does not
change over time unless it is edited
⫸ Statistical power. Answer: The probability that a test of
significance will recognize an effect that is present
⫸ Statistical significance. Answer: The probability that sample results
are not due to random chance
⫸ Statistics. Answer: The study of how to collect, analyze,
summarize, and present data
SCRIPT STUDY SHEET 2026 GRADED A+.
⫸ CASE. Answer: A SQL statement that returns records that meet
conditions by including an if/then statement in a query
⫸ CAST. Answer: A SQL function that converts data from one
datatype to another
⫸ Causation. Answer: When an action directly leads to an outcome,
such as a cause-effect relationship
⫸ Cell reference. Answer: A cell or a range of cells in a worksheet
typically used in formulas and functions
⫸ Ruby. Answer: An object-oriented programming language for web
application development
⫸ Sample. Answer: In data analytics, a segment of a population that
is representative of the entire population
⫸ Sampling bias. Answer: Overrepresenting or underrepresenting
certain members of a population as a result of working with a sample
that is not representative of the population as a whole
,⫸ Scatterplot. Answer: A data visualization that represents
relationships between different variables with individual data points
without a connecting line
⫸ Schema. Answer: A way of describing how something, such as
data, is organized
⫸ Scope of work (SOW). Answer: An agreed-upon outline of the
tasks to be performed during a project
⫸ Second-party data. Answer: Data collected by a group directly
from its audience and then sold
⫸ SELECT. Answer: The section of a query that indicates from
which column(s) to extract the data
⫸ SELECT INTO. Answer: A SQL clause that copies data from one
table into a temporary table without adding the new table to the
database
⫸ Small data. Answer: Small, specific data points typically involving
a short period of time, which are useful for making day-to-day
decisions
⫸ SMART methodology. Answer: A tool for determining a question's
effectiveness based on whether it is specific, measurable, action-
oriented, relevant, and time-bound
,⫸ Social media. Answer: Websites and applications through which
users create and share content or participate in social networking
⫸ Soft skills. Answer: Nontechnical traits and behaviors that relate to
how people work
⫸ Sort range. Answer: A spreadsheet menu function that sorts a
specified range and preserves the cells outside the range
⫸ Sort sheet. Answer: A spreadsheet menu function that sorts all data
by the ranking of a specific sorted column and keeps data together
across rows
⫸ Sorting. Answer: The process of arranging data into a meaningful
order to make it easier to understand, analyze, and visualize
⫸ Specific question. Answer: A question that is simple, significant,
and focused on a single topic or a few closely related ideas
⫸ SPLIT. Answer: A spreadsheet function that divides text around a
specified character and puts each fragment into a new, separate cell
⫸ Sponsor. Answer: A professional advocate who is committed to
moving forward the career of another
, ⫸ Spotlightling. Answer: Scanning through data to quickly identify
the most important insights
⫸ Spreadsheet. Answer: A digital worksheet
⫸ SQL. Answer: (Refer to Structured Query Language)
⫸ Stakeholders. Answer: People who invest time and resources into a
project and are interested in its outcome
⫸ Static data. Answer: Data that doesn't change once it has been
recorded
⫸ Static visualization. Answer: A data visualization that does not
change over time unless it is edited
⫸ Statistical power. Answer: The probability that a test of
significance will recognize an effect that is present
⫸ Statistical significance. Answer: The probability that sample results
are not due to random chance
⫸ Statistics. Answer: The study of how to collect, analyze,
summarize, and present data
