Summary of unit Learning aim Key content areas Assessment approach A Investigate data
modelling and how it
can be used in the
decision-making process
A1 Stages in the decision-
making process
A2 Spreadsheet features
used to support data
modelling
A3 Using data modelling to
consider alternatives
A4 Evaluating models
A5 Documenting and
justifying decisions
A presentation or report
evaluating the role of
data modelling in the
decision-making process.
B Design a data model
to meet client
requirements
B1 Functional specification
B2 Spreadsheet model
design
B3 Reviewing and refining
data model designs
A practical activity,
involving the design and
development of a data
model to fulfil identified
client requirements.
A functional specification,
design documentation,
spreadsheet development
and testing logs.
A report that evaluates
the effectiveness of the
alternatives considered,
and suggests ways in which
the alternatives could be
improved if the task were
to be repeated.
C Develop a data model
to meet client
requirements
C1 Developing a data
model solution
C2 Testing the data model
solution
C3 Reviewing and refining
the data model solution
C4 Skills, knowledge and
behaviours
