WorksheetsUnit 5 Data Modelling
Total questions: 10
Worksheet time: 7mins
Which of the following are recognised stages in the decision making process?
Understanding the scenario
Analysing the information
Justifying the decision
Making stuff up
Which of the following are factors that affect the quality of information?
currency of data
accuracy of data
external factors
how big the numbers are
When you carefully consider all the known
alternatives before recommending or implementing a solution.
Identifying alternatives
Identifying consequences
Justify the solution
The data model process
Entering and editing data in a spreadsheet is...
Easy
Not possible
Too hard, use another application for this
Which function would show how
many cells contain the text ‘Pass’ in the three thousand cells from B1 to D1000.
=COUNTIF(B1:D1000,‘Pass’)
=COUNTA(B1:D1000,‘Pass’)
=SUMIF(B1:D1000,‘Pass’)
=AVERAGE(B1:D1000,‘Pass’)
Helps to prevent or reduce the number of mistakes when entering data into a spreadsheet.
Validation
Verification
Pivot tables
Macros
Using data modelling to consider
alternatives ...
can be used by
the data modeller to identify possible alternatives and to
choose the best of them
is something that spreadsheets won't help with.
is usually done by testing
different input values.
can lead to many incorrect conclusions.
What are the impacts or consequences of each alternative
solution? Factors to consider are:
risk (does a solution produce more or less)
differences in timescales
differences in costs
how nice the charts and graphs look
You need to consider many factors when
evaluating your model including:
how well it reflects the scenario
the decisions it supports
whether it can be improved
if the model could be extended.
Justifying choices
Make sure that you justify:
your choice of information sources
the factors considered
the methods used
how nice the graphs and charts look
