DATA 2100 COMPREHENSIVE EXAM QUESTIONS WITH
SOLUTIONS 2025 GRADED A+
✔✔Marker variable - ✔✔A variable that exists solely to indicate whether a task has
been completed or not
✔✔Try/Except - ✔✔An effective way to validate user data entry
requires users to keep inputting values until they come up with a valid value
✔✔Outputting SQl thing in python - ✔✔cursor.execute("select....")
for row in cursor:
print row
✔✔SDLC - ✔✔Planning
Analysis
Design
Development
Testing
Implementation
Maintenance
✔✔Front-end - ✔✔the user interface that users will use
✔✔business case - ✔✔a document that describes the project and makes a "case" for
pursuing it in terms of its potential net benefits(i.e., it's profitability)
✔✔stakeholders - ✔✔those managers and other whose work and work performance
may be affected (whether positively or negatively) by the project
✔✔specifications document - ✔✔a document that specifies all of the requirements that
the completed project will fulfill
✔✔Comp - ✔✔a graphically designed mock-up of an interface
✔✔critical path - ✔✔set of steps on which the rest of the schedule is dependent - these
are key things that need to be done before the next step of the project can start
✔✔Dev environment - ✔✔consists of an exact copy of the actual, live website and all
supporting data structures at the time the project starts
✔✔QA environment - ✔✔facilitates testing (stands for quality assurance)
, ✔✔production environment - ✔✔the actual, live system used by users
✔✔Waterfall - ✔✔The project passes from one phase to the next, never returning back
to an earlier phase
✔✔Agile - ✔✔Involves a number of development cycles, also called sprints. Each sprint
involves most or all the steps of SDLC. In each sprint, a segment of the project is
planned, analyzed, designed, developed, and tested
✔✔Bias and Decision making - ✔✔Data analysis helps take some of the bias out of
decision making
✔✔Predictive Data analysis - ✔✔Tries to look at relationships between data points from
past events in order to predict a future outcome
✔✔Diagnostic Analysis - ✔✔Looks at events that already occurred with the intent of
understanding why they occurred
✔✔population - ✔✔the set of all relevant observations that exist, have existed, or will
exist in the universe
✔✔Sample - ✔✔Any subset of the population
✔✔n (count) - ✔✔how many times the values were observed
✔✔mean - ✔✔average value for the measurement of interest
✔✔Median - ✔✔if we were to line up all the values from smallest to largest in a data set,
it would be found in the exact middle
✔✔Range - ✔✔indicates the range of possible values from the lowest (the minimum
value) to the highest (the maximum value). It gives a sense of what values are possible
for all observations of a measurement
✔✔Standard Deviation - ✔✔On average, how far away each observed value is from the
mean
if an observed value is 5 above the mean or below the mean, each of those count as "5
units away".
Basically, then, if we have three values: 2, 5, and 8, then the mean would be 5
((2+5+8)/3=5)
SOLUTIONS 2025 GRADED A+
✔✔Marker variable - ✔✔A variable that exists solely to indicate whether a task has
been completed or not
✔✔Try/Except - ✔✔An effective way to validate user data entry
requires users to keep inputting values until they come up with a valid value
✔✔Outputting SQl thing in python - ✔✔cursor.execute("select....")
for row in cursor:
print row
✔✔SDLC - ✔✔Planning
Analysis
Design
Development
Testing
Implementation
Maintenance
✔✔Front-end - ✔✔the user interface that users will use
✔✔business case - ✔✔a document that describes the project and makes a "case" for
pursuing it in terms of its potential net benefits(i.e., it's profitability)
✔✔stakeholders - ✔✔those managers and other whose work and work performance
may be affected (whether positively or negatively) by the project
✔✔specifications document - ✔✔a document that specifies all of the requirements that
the completed project will fulfill
✔✔Comp - ✔✔a graphically designed mock-up of an interface
✔✔critical path - ✔✔set of steps on which the rest of the schedule is dependent - these
are key things that need to be done before the next step of the project can start
✔✔Dev environment - ✔✔consists of an exact copy of the actual, live website and all
supporting data structures at the time the project starts
✔✔QA environment - ✔✔facilitates testing (stands for quality assurance)
, ✔✔production environment - ✔✔the actual, live system used by users
✔✔Waterfall - ✔✔The project passes from one phase to the next, never returning back
to an earlier phase
✔✔Agile - ✔✔Involves a number of development cycles, also called sprints. Each sprint
involves most or all the steps of SDLC. In each sprint, a segment of the project is
planned, analyzed, designed, developed, and tested
✔✔Bias and Decision making - ✔✔Data analysis helps take some of the bias out of
decision making
✔✔Predictive Data analysis - ✔✔Tries to look at relationships between data points from
past events in order to predict a future outcome
✔✔Diagnostic Analysis - ✔✔Looks at events that already occurred with the intent of
understanding why they occurred
✔✔population - ✔✔the set of all relevant observations that exist, have existed, or will
exist in the universe
✔✔Sample - ✔✔Any subset of the population
✔✔n (count) - ✔✔how many times the values were observed
✔✔mean - ✔✔average value for the measurement of interest
✔✔Median - ✔✔if we were to line up all the values from smallest to largest in a data set,
it would be found in the exact middle
✔✔Range - ✔✔indicates the range of possible values from the lowest (the minimum
value) to the highest (the maximum value). It gives a sense of what values are possible
for all observations of a measurement
✔✔Standard Deviation - ✔✔On average, how far away each observed value is from the
mean
if an observed value is 5 above the mean or below the mean, each of those count as "5
units away".
Basically, then, if we have three values: 2, 5, and 8, then the mean would be 5
((2+5+8)/3=5)
