Unit 5: Data Modelling Level: 3 Unit type: Internal Guided learning hours: 60 Unit in brief Learners study how data modelling can be used to solve problems. They will design and
implement a data model to meet client requirements.
Unit introduction In all aspects of life, individuals are constantly faced with situations where they must
weigh up the available information in order to produce alternatives and make decisions.
In a working environment, effective decision making can ensure the successful
development of organisations. Poor decision making can have significant negative
consequences and can even lead to the demise of an organisation.
In this unit, you will investigate the fundamentals of the decision-making process. You
will find out how using data modelling provides the computational ability to compare
consequences, and determine a preferred course of action. You will develop the skills
and techniques necessary to create complex spreadsheets in order to produce accurate
information that informs decision making. You will examine a scenario and then design,
develop and test a spreadsheet; you will review your spreadsheet and make refinements
based on user feedback, providing an evaluation of the effectiveness of the alternatives
produced.
The skills developed in this unit are useful for progression to computing or business-
related higher education courses and for use in decision making in the workplace.
Learning aims In this unit you will:
A Investigate data modelling and how it can be used in the decision-making process
B Design a data model to meet client requirements
C Develop a data model to meet client requirements.