Unit Question:
How can we use data analysis in our day-to-day life to make informed decisions?
Criteria A: Investigation –
ICT
A music artist who needed help with keeping
record of his album sales approached me. He has come to me seeking help as he
has been keeping record of his sales through books. So many people are buying
his albums and he is now struggling with calculating his profits and losses for
each one. He is hoping that I will have a solution to his problem as it is
causing big issues for him. He is also losing track of if he is receiving the
right amount of payments. To solve his problem, I have decided to use excel to
make it easer for him, I will store a list of all his albums with their cost
price, selling price, profit/loss and how many have been sold worldwide and in
different countries. This way he will be able to access and update the
information easily. To complete this, I will need a list of all his albums with
their prices and selling prices and this way I will be able to calculate if it
is profit or loss. I will also need a laptop with the excel software downloaded
onto it. The information and excel software with allow me to get right on
track.
How
do I create a solution using appropriate computer software?
-
Using appropriate computer software, this will make it easy for the
music artist to keep track of his records as they will become easier to access
and update.
How
can it help my customer to perform automatic calculations?
-
On excel, there are settings you can adjust which will allow you
automatically calculate your data.
Requirements
I
will need all of Mr. Eminem’s data files. I will have different columns that
will be labeled Album Names, Album Manufacturing Price, Album Selling Price;
Number Of Album sold per year and Album profit/loss.
