Unit 5 Data Modelling Assignment A (Distinction)

UNIT 5 DATA
MODELLING By:


ASSIGNMENT A

,TABLE OF CONTENT
• What is data modelling
• Stages of decision making
• Features of spreadsheet software used to supp
the process of decision making
• Analyzing the features of spreadsheet software
how contributes to the process of decision mak
• Evaluating spreadsheet software and how it
contributes to the process of decision making
• Pros of using Excel in a decision-making proces
• Cons of using Excel in a decision-making proce

,DATA MODELLING

Data modeling is the process of using a
worksheet or another tool to simulate a real-
world situation where business decisions need t
be made.
Data modelling is the act of creating a visual
representation of a full information system or a
subset of it to communicate linkages between
data items and structures.

,STAGES IN Understanding the Scenarios

DECISION Identifying information and sources

MAKING Factors affecting the quality of information

Analysing the information

Identifying alternatives

Identifying consequences of implementing
the alternatives
Making and justifying a decision

Communicating the decision to others

, UNDERSTANDI • The scenario clarifies what the spreadsheet mu
able to achieve.it is a situation whereby a data

NG THE is needed. It essentially provides a description
subject matter or topic you'll be modelling.

SCENARIOS • Majority of your data models will include a scen
based on the type of business.