BTEC Nationals Information Technology Student Book + Activebook
This essay/assignment covers Unit 5 - Data Modelling Assignments 2 and 3 with all criterias met to achieve the highest grade (Distinction) along with correct structure. Just follow the content step by step to save time and also to reduce complexity.
Note: This will support those in achieving disti...
2024 Unit 3 Using Social Media in Business - Assignment 1 (Learning aim A at Distinction level) (ALL YOU NEED TO GET A DISTINCTION)
Unit 3: Social Media in Business - Learning Aim B&C
Unit 3: Social Media in Business - Learning Aim A
Alles voor dit studieboek
(38)
Geschreven voor
BTEC
PEARSON (PEARSON)
Information Technology 2016 NQF
Unit 5 - Data Modelling
Alle documenten voor dit vak (2)
64
beoordelingen
Door: nonsodaniel007 • 7 maanden geleden
Door: arjunpillai • 7 maanden geleden
Door: sezika • 1 jaar geleden
Door: jsjejjsns • 1 jaar geleden
Door: mariam9 • 1 jaar geleden
Door: mathurvidur2007 • 1 jaar geleden
Door: joshwadsy • 1 jaar geleden
Bekijk meer beoordelingen
Verkoper
Volgen
johnatkinson
Ontvangen beoordelingen
Voorbeeld van de inhoud
Name: John Atkinson Unit 5 – Learning Aim B Date: 13/06/2019
Data Modelling – Assignment 2
Introduction:
In this assignment, I have recently been chosen to join a new company as a trainee data analyst.
Firstly, I will be willing to produce an efficient spreadsheet model which can predict the potential
impact of exchange rate fluctuations on the company profit margins. From this, I will create designs
for a data model so that each of the client requirements are met successfully which will include
worksheet structure diagrams and being able to provide a test plan. Then, I will be reviewing the
design with other clients to identify and inform improvements.
Furthermore, I will be explaining my justification to how the requirements are fully fulfilled and then
providing a well- detailed and reasoned evaluation of the optimised data model against client
requirements that already exist.
Nature of the problem:
The nature of the problem is that number of challenges that the user has previously been faced and
this would be the currency change issue that resulted with inaccuracy with both pounds and euros.
Functions the model must perform:
For the section, there are many functions that the model must perform. Generally, these functions
require complex calculation that is built in the project named “Microsoft Excel”. The functions that
currently exist in this project are:
SUM – This function will be used to calculate the total cost between number1 and number2 by
adding up these together. An example could be adding all numbers in the cells of B1 and F5 and then
providing the equals sign to get the total cost of the product.
AVERAGE – This function is used to average all the numbers in the cells from B1 to F5. Also, this
function can also be entered as part of a formula in a cell of a worksheet.
COUNT – This function is usually used to count the number of cells that contains numbers and then
counts the numbers within the list of arguments. Additionally, this function will get the number of
entries in a number field that includes range of array of numbers. An example of this could be
entering the following formula to count the numbers in the range.
COUNTIF – This function is generally used to count how many numbers in cells B1 to F5 are higher
than 50. Also, it will also be used to count how many 70s are in the cells from B1 to F5. The counting
process will be
, Name: John Atkinson Unit 5 – Learning Aim B Date: 13/06/2019
IF – This function can perform a logical test to check whether the conditions are met and returns one
value of false and another value of true. For instance, if the exchange rate of 0.7 is greater 0.3 or 0.6,
it would result with a pass but if it is less then it will result with a fail instead.
LOOKUP – This function would be used to search one column and would return the corresponding
value from another one-column or one-row range. In general, the function “LOOKUP” would make it
useful for solving certain problems in Excel. For example, if I wanted to search for a value of the total
currency (in pounds), I would select that specific column and then another column to find an overall
value.
User interface:
The user interface will consider including a minimum of at least two or three design layouts. In
addition to this, I will be using Microsoft Excel to provide all the data into an entity and from this, I
will be drawing rough designs to include the display of how my data model will look like before
implementing this. Furthermore, my table will contain links such as including buttons so that it
navigates to another page. The other page will be my form to include the labels and fields for users
to input information. Also, I will also comprise a data analyst such as graphs to track the changes
being made and if the costs of sale are lower or higher predicting the results to be changed over
time.
Constraints:
For this part, I will be considering the constraints that could occur during the process of my data
modelling using the project “Microsoft Excel”. This would help me to improve and make sure that I
do not encounter the same problems again in the future. One of these constraints will include:
Time – This will be one of the constraint issues that can exist as I may not have enough time to finish
off the project and to make it accurate and efficient as possible. Furthermore, the limit of time could
affect me with calculations as it may usually take long to figure out the data to be calculated.
Cost – This would be another issue of my constraint as the amount of budget I have may not be
enough to meet each of the hardware requirements and which ones to buy. The limitations with
these will possibly prevent me to continue with the data modelling process since the hardware that I
have may not function properly after having to purchase a cheaper hardware (PC, Laptop).
Skills - The skills would be another common issue as part of my constraint because I may have a lack
of skills that would need to be required when dealing with the tools that have been provided on the
project “Microsoft Excel”. There are some tools that I may not know about or have a clue, and this
would show that I have less skills which wouldn’t meet the criteria or requirement.
Hardware – The use of hardware that I use may process slower than expected and will be wasting
time as I would have to wait until it loads each time I create a column and inputting the data. If the
loading process takes too long, then it will buffer and result with having to exit the application and
restart.
Voordelen van het kopen van samenvattingen bij Stuvia op een rij:
Verzekerd van kwaliteit door reviews
Stuvia-klanten hebben meer dan 700.000 samenvattingen beoordeeld. Zo weet je zeker dat je de beste documenten koopt!
Snel en makkelijk kopen
Je betaalt supersnel en eenmalig met iDeal, creditcard of Stuvia-tegoed voor de samenvatting. Zonder lidmaatschap.
Focus op de essentie
Samenvattingen worden geschreven voor en door anderen. Daarom zijn de samenvattingen altijd betrouwbaar en actueel. Zo kom je snel tot de kern!
Veelgestelde vragen
Wat krijg ik als ik dit document koop?
Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.
Tevredenheidsgarantie: hoe werkt dat?
Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.
Van wie koop ik deze samenvatting?
Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper johnatkinson. Stuvia faciliteert de betaling aan de verkoper.
Zit ik meteen vast aan een abonnement?
Nee, je koopt alleen deze samenvatting voor €12,38. Je zit daarna nergens aan vast.
