Name: Tasnim Sultana Unit 5 Date:
30/09/2022
Data modelling - Investigate data modelling and how it can
be used in the decision making process
Introduction to the assignment-
In this assignment, I will be investigating the process of the decision making process for data
modelling. Therefore, I will explain the stages in the decision making process along with
others such as spreadsheets features, using data modelling to consider alternatives,
Evaluating models and being able to provide documentation and justification of the models.
It's important for us to understand what data modelling is and how it can be applied correctly
to create spreadsheets for the clients. In the event that a client asks to complete certain
tasks, We can use data modelling to create and consider alternative options.
As part of data modelling, connections between data points and structures are visually
represented to illustrate how an information system or its components are connected. It is
intended to illustrate how data is used and stored within the system, its relationships among
data types, and the ways that it can be categorised and organised.
Stages in the decision making process-
1. Understanding the scenario
2. Identifying information and sources
3. Factors affecting the quality of informations
4. Analysing the information
5. Identifying alternatives
6. Identifying consequences of implementing the alternatives
7. Making the justifying the decision
8. Communicating decisions to others.
Understanding the scenario-
Before doing anything with your data modelling, it's required to understand the scenario
because it allows you to understand what your spreadsheet needs to be able to do. On the
other hand if you don't understand the scenario it's going to cause some problems in your
spreadsheet and you might not be able to solve it. The first thing is to figure out who wants
this spreadsheet. It's important because it gives you the information about the owner and
who’s going to use it. You will be able to find out why they want it, why it’s important and
what they want to display from the spreadsheets. These are the basic questions you will be
answered when you have a good understanding about the scenario.
For example- In the scenario that I was given on the assignment brief, I was asked to design
and create a spreadsheet model to predict the potential impact of changes in exercise diet
on a person's BMI. In addition the model I develop should be designed to be used by people
who do not have a background in IT. so, who wants the sheet? The local leisure centre
Who will be using the spreadsheet? Other people. Why do they need it? To predict the
potential impact of changes in exercise diet on a person's BMI.
, Name: Tasnim Sultana Unit 5 Date:
30/09/2022
Identifying information and sources-
To make your decision and data modelling, you have to identify the information you get.
Such as where did the information come from and is it reliable to use because wrong
information will end up with negative assaults. There are 3 types of information in data
modelling.
Required Information:
The information required is for the spreadsheets. I have to find and Identify this information
for the spreadsheet. To predict BMI, for example, exercise and diet information must be
collected over a period of 10 weeks, so the data sources can be verified. Since you could
compare the data to the requirements, this list of requirements would be a great tool for
verifying the data.
Information that is already given:
Figuring this out is easier than required information, because some of the information will be
given to you through the scenario. All you have to do is read and understand the scenario
carefully and then identify the information from it. For example you might want to find out
how many days they want to check their BMI.
Additional required information:
After you found the useful information from the scenario, then you might need some
additional information as well for your spreadsheet and modelling process. This information
will not be in the scenario. You have to find this information from somewhere else and
include it in a spreadsheet. For example, if you need to know how to collect a person’s
BMI.Then you have to do a research on the internet cause you might not know how to
calculate.
Factors affecting the quality of informations
Currency of data
In terms of data currency, it refers to how recently it has been collected. Data that is
outdated becomes less relevant as time goes on, whereas information that is current
becomes more valuable. As far as your model is concerned, it is best to leave behind the
information that has lost its currency, as it is not as useful as current data. Suppose a
restaurant wanted to know when their busiest time would be; the answer would depend on
the currency of the data. Data from 10 years ago about people going to the restaurant
mostly in January isn't accurate if people go in June now. So they would have to find recent
information such as the busiest time from last year.
External factors
An external factor is something that is from the outside, which could possibly affect your data
model. They can be anything, it may have a good effect or a bad effect, on the information
you have collected. For example, relating to the restaurant scenario, they could have taken a
survey of the amount of customers in june, but it could've been events such as festivals
taking place in the same time period leading to an increased amount than any normal
30/09/2022
Data modelling - Investigate data modelling and how it can
be used in the decision making process
Introduction to the assignment-
In this assignment, I will be investigating the process of the decision making process for data
modelling. Therefore, I will explain the stages in the decision making process along with
others such as spreadsheets features, using data modelling to consider alternatives,
Evaluating models and being able to provide documentation and justification of the models.
It's important for us to understand what data modelling is and how it can be applied correctly
to create spreadsheets for the clients. In the event that a client asks to complete certain
tasks, We can use data modelling to create and consider alternative options.
As part of data modelling, connections between data points and structures are visually
represented to illustrate how an information system or its components are connected. It is
intended to illustrate how data is used and stored within the system, its relationships among
data types, and the ways that it can be categorised and organised.
Stages in the decision making process-
1. Understanding the scenario
2. Identifying information and sources
3. Factors affecting the quality of informations
4. Analysing the information
5. Identifying alternatives
6. Identifying consequences of implementing the alternatives
7. Making the justifying the decision
8. Communicating decisions to others.
Understanding the scenario-
Before doing anything with your data modelling, it's required to understand the scenario
because it allows you to understand what your spreadsheet needs to be able to do. On the
other hand if you don't understand the scenario it's going to cause some problems in your
spreadsheet and you might not be able to solve it. The first thing is to figure out who wants
this spreadsheet. It's important because it gives you the information about the owner and
who’s going to use it. You will be able to find out why they want it, why it’s important and
what they want to display from the spreadsheets. These are the basic questions you will be
answered when you have a good understanding about the scenario.
For example- In the scenario that I was given on the assignment brief, I was asked to design
and create a spreadsheet model to predict the potential impact of changes in exercise diet
on a person's BMI. In addition the model I develop should be designed to be used by people
who do not have a background in IT. so, who wants the sheet? The local leisure centre
Who will be using the spreadsheet? Other people. Why do they need it? To predict the
potential impact of changes in exercise diet on a person's BMI.
, Name: Tasnim Sultana Unit 5 Date:
30/09/2022
Identifying information and sources-
To make your decision and data modelling, you have to identify the information you get.
Such as where did the information come from and is it reliable to use because wrong
information will end up with negative assaults. There are 3 types of information in data
modelling.
Required Information:
The information required is for the spreadsheets. I have to find and Identify this information
for the spreadsheet. To predict BMI, for example, exercise and diet information must be
collected over a period of 10 weeks, so the data sources can be verified. Since you could
compare the data to the requirements, this list of requirements would be a great tool for
verifying the data.
Information that is already given:
Figuring this out is easier than required information, because some of the information will be
given to you through the scenario. All you have to do is read and understand the scenario
carefully and then identify the information from it. For example you might want to find out
how many days they want to check their BMI.
Additional required information:
After you found the useful information from the scenario, then you might need some
additional information as well for your spreadsheet and modelling process. This information
will not be in the scenario. You have to find this information from somewhere else and
include it in a spreadsheet. For example, if you need to know how to collect a person’s
BMI.Then you have to do a research on the internet cause you might not know how to
calculate.
Factors affecting the quality of informations
Currency of data
In terms of data currency, it refers to how recently it has been collected. Data that is
outdated becomes less relevant as time goes on, whereas information that is current
becomes more valuable. As far as your model is concerned, it is best to leave behind the
information that has lost its currency, as it is not as useful as current data. Suppose a
restaurant wanted to know when their busiest time would be; the answer would depend on
the currency of the data. Data from 10 years ago about people going to the restaurant
mostly in January isn't accurate if people go in June now. So they would have to find recent
information such as the busiest time from last year.
External factors
An external factor is something that is from the outside, which could possibly affect your data
model. They can be anything, it may have a good effect or a bad effect, on the information
you have collected. For example, relating to the restaurant scenario, they could have taken a
survey of the amount of customers in june, but it could've been events such as festivals
taking place in the same time period leading to an increased amount than any normal
