Essay
Essay Unit 5 - Data Modelling A2 Grade D
- Module
- Unit 5 - Data Modelling
- Institution
- PEARSON (PEARSON)
this essay has achieved grade Distinction.
[Show more]
Seller
Follow
Content preview
Unit 5 Data ModellingAssignment 2
Models and Decision
Making
, Functional Specification
Introduction
My name is Atanas, in this assignment I have being asked as a trainee data analyst to produce a
spreadsheet which covers the important data for the company “The Fine Cheese Co”. in this data It
should cover the prices the cheese has being bought, calculate the UK sales prices with a markup
value of 40%, get live exchange rates from pounds to euros and the amount of money the company
will earn at the end of the month.
First thing I will have to do is 3 designs so the client can pick which design suits best.
Functions the model must perform:
User Interface: the user will consider a minimum of two or three designs which will portrait how the
spreadsheet will look like in a finish format. I will be using Microsoft Excel to provide all the data and
from this I will be create a design showing how my data model will look like before moving forward
with the tasks. My tables will contain Macro buttons which will allow the user to navigate through the
spreadsheet much easier and without opening the wrong sheet.
Buttons: for the spreadsheet I will use macro buttons which should allow the user to navigate through
out the spreadsheet with one click of the button,
Spinner: A spin button is used to make increase or decrease in a value much easier you just need to
press either up or down arrow. Looking at what the client wants I might have to use the spin button.
Constraints: the disadvantages I will have been that I am restricted to data so I will have to use
formulars to find the data I need to specific cell.
Time: This will take a lot of time to do because I need to work with a lot of sensitive data which I
should 100% be sure that is correct not only that I will have to meet a lot of requirements set by the
company
, Software available – software I will be using is Excel 2019
Meeting with client – I will have to allocate time so I can make a meeting with the client to discuss
the work I will be doing. I will try to arrange a Face-to-Face meeting with the client and if the client
can’t do face to face then I will try get an online meeting because for me to be able to do this work I
will have to have contact with the client at least once per 2 days.
Success Criteria.
The success criteria that are needed for this data model is to show my successful and good working
system that I will created and make users aware of what is expected of them and to motivate them to
extend themselves by looking each bit on the tables.
Company: the company ‘The Fine Cheese Co’.
Client satisfaction: my aim is to make the client very satisfy by my work so for this to happen I will
have to create and carefully choose the designs for the model with the help of other people’s opinions.
Spreadsheet Model Design and
justification 3 designs are needed.
User Interface: here I will show my 3 designs layouts. I will try to make it reasonable so it can be
understood what page what for example will be background colours or the layouts of the tables.
Layout & Presentation and design justification
Design 1
Dashboard
This is the dashboard
page, and, in this
page, it should
Time graphs graphs graphs contain some graphs
and a clock that will
show the live time and
Graphs
graphs
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller naskomirchev1. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £9.09. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
73918 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy revision notes and other study material for 14 years now