Garantie de satisfaction à 100% Disponible immédiatement après paiement En ligne et en PDF Tu n'es attaché à rien
logo-home
Unit 5: Data Modelling - 2022/23 - Assignment 1 (Learning Aim A) (All Criterias Met) (Word) €11,16   Ajouter au panier

Dissertation

Unit 5: Data Modelling - 2022/23 - Assignment 1 (Learning Aim A) (All Criterias Met) (Word)

5 revues
 641 vues  12 fois vendu
  • Cours
  • Établissement

2022/23 - This essay covers DISTINCTION level work for Unit 5: Data Modelling - Assignment 1 - Learning Aim A. To complete your assingment in the quickest time use the NAVIGATION PANE in Word to follow my layout in order to achieve any grade. (Pass, Merit & Distinction). All of the following...

[Montrer plus]
Dernier document publié: 2 année de cela

Aperçu 4 sur 24  pages

  • 26 septembre 2022
  • 1 octobre 2022
  • 24
  • 2022/2023
  • Dissertation
  • Inconnu
  • A+

5  revues

review-writer-avatar

Par: emran7002 • 2 semaines de cela

review-writer-avatar

Par: kapoorshally88 • 4 mois de cela

review-writer-avatar

Par: mialyons • 1 année de cela

reply-writer-avatar

Par: JoshuaHall • 1 année de cela

Hi Mialyons, I hope I have helped you clear up any confusion you had with your brief. If you need anymore help please message me directly again. Thanks, Joshua Hall

review-writer-avatar

Par: sultandurrani9994 • 1 année de cela

review-writer-avatar

Par: saadilyas • 2 année de cela

avatar-seller
Joshua Hall Assignment 1 – Learning Aim A Unit 5 – 2022



Table of Contents

Unit 5 – Data Modelling...............................................................................................................................3

Introduction.................................................................................................................................................3

..................................................................................................................................................................... 3

Stages in Decision Making Process..............................................................................................................4

Understanding the Scenario....................................................................................................................4

Identifying Information and Sources.......................................................................................................4

Factors Affecting the Quality of Information...........................................................................................5

Analyzing the Information.......................................................................................................................7

Identifying Alternatives............................................................................................................................7

Identifying Consequences of Implementing the Alternatives..................................................................8

Making and Justifying the Decision..........................................................................................................8

Communicating decision to others..........................................................................................................9

Clients..................................................................................................................................................9

Supervisor..........................................................................................................................................10

Project Sponsor..................................................................................................................................10

Spreadsheet Features of Data Modelling..................................................................................................10

Formatting Data.....................................................................................................................................10

Using Formulae and Functions...............................................................................................................11

Validation and Verification of Data.......................................................................................................12

1|Page

,Joshua Hall Assignment 1 – Learning Aim A Unit 5 – 2022


Analyzing and Interpreting Data............................................................................................................14

Presenting Data.....................................................................................................................................15

Using Data Modelling to Consider Alternatives.........................................................................................16

Identifying Inputs Required for Model...................................................................................................16

Range of Outputs that can be Produced................................................................................................16

Benefits of Alternative Solutions...........................................................................................................17

Limitations of Alternative Solutions.......................................................................................................18

Impact and Consequences of Alternative Solutions...............................................................................18

Identifying the Best Produce Alternative Solution.................................................................................19

Evaluating Models.....................................................................................................................................19

How the Current Model Reflects the Scenario......................................................................................19

Decisions using the Model.....................................................................................................................19

Data Model Improvements....................................................................................................................20

Other Factors.........................................................................................................................................21

Documenting and Justifying Decisions.......................................................................................................21

Summarizing the situation.....................................................................................................................21

Identifying the Information Sources......................................................................................................22

Indicating Factors Considered................................................................................................................22

Method Used to Reach Decisions..........................................................................................................23

Justifying Choices...................................................................................................................................23



2|Page

,Joshua Hall Assignment 1 – Learning Aim A Unit 5 – 2022


Choice of information........................................................................................................................24

Factors Considered............................................................................................................................24

Methods Used...................................................................................................................................24


Unit 5 – Data Modelling


Introduction

In this assignment, I will be investigating the process of the decision-making process for data modelling.

Therefore, I will first explain the stages in the decision-making process along with others such as

spreadsheet features, considering alternatives, evaluating models and being able to provide

documentation and justifications of the models.


Before you can start designing or creating a spreadsheet for your clients you first need to know what

data modelling is and how it can be applied correctly in fulfilling your client’s needs. Data modelling is

used to help create and consider alternative choices when your client has given you certain tasks that

they would like completed.


Data modelling is the process of creating a visual representation of either a whole information system or

parts of it to communicate connections between data points and structures. The goal is to illustrate the

types of data used and stored within the system, the relationships among these data types, the ways the

data can be grouped and organized and its formats and attributes.




3|Page

, Joshua Hall Assignment 1 – Learning Aim A Unit 5 – 2022



Stages in Decision Making Process

Understanding the Scenario

First of all, you need to understand the scenario that the data model is going to be applied to. If you do

not understand the scenario, then you will not be able to create an effective data model as you will not

understand where it going to be applied to. This would be a problem for the client as the data model will

not be fully optimized to run their scenario as it was created by someone who does not fully understand

what they were creating it for. You need to know the reason as to why this data model is being created.

These reasons will include who wants the data model, why they need it and what they would like to

show from it. By understanding these points and knowing the scenario this will allow you to create a

spreadsheet which will be used to its full extent.


This means that if you make a spreadsheet which allows them to see what is likely to happen from each

possible alternative and in the end showing them the best result that the client will be happy with. If the

client wants, you to create a spreadsheet to decide then price of a newly released product. This

spreadsheet would need to cover the wide range of topics such as how many items have been made,

how many will be sold, the total cost of creating the product, and the profit wanted from the product. If

you understand the scenario to its fullest extent, it will allow you to create the spreadsheet with much

more detail and the customer will be much happier as it will fulfil their needs.


Identifying Information and Sources

All data models need information so by this point in your decision-making process you should know

where the information you will be using will come from and if it is reliable information that you can use.




4|Page

Les avantages d'acheter des résumés chez Stuvia:

Qualité garantie par les avis des clients

Qualité garantie par les avis des clients

Les clients de Stuvia ont évalués plus de 700 000 résumés. C'est comme ça que vous savez que vous achetez les meilleurs documents.

L’achat facile et rapide

L’achat facile et rapide

Vous pouvez payer rapidement avec iDeal, carte de crédit ou Stuvia-crédit pour les résumés. Il n'y a pas d'adhésion nécessaire.

Focus sur l’essentiel

Focus sur l’essentiel

Vos camarades écrivent eux-mêmes les notes d’étude, c’est pourquoi les documents sont toujours fiables et à jour. Cela garantit que vous arrivez rapidement au coeur du matériel.

Foire aux questions

Qu'est-ce que j'obtiens en achetant ce document ?

Vous obtenez un PDF, disponible immédiatement après votre achat. Le document acheté est accessible à tout moment, n'importe où et indéfiniment via votre profil.

Garantie de remboursement : comment ça marche ?

Notre garantie de satisfaction garantit que vous trouverez toujours un document d'étude qui vous convient. Vous remplissez un formulaire et notre équipe du service client s'occupe du reste.

Auprès de qui est-ce que j'achète ce résumé ?

Stuvia est une place de marché. Alors, vous n'achetez donc pas ce document chez nous, mais auprès du vendeur JoshuaHall. Stuvia facilite les paiements au vendeur.

Est-ce que j'aurai un abonnement?

Non, vous n'achetez ce résumé que pour €11,16. Vous n'êtes lié à rien après votre achat.

Peut-on faire confiance à Stuvia ?

4.6 étoiles sur Google & Trustpilot (+1000 avis)

78998 résumés ont été vendus ces 30 derniers jours

Fondée en 2010, la référence pour acheter des résumés depuis déjà 14 ans

Commencez à vendre!
€11,16  12x  vendu
  • (5)
  Ajouter