M1 by abuzar251

VIEWS: 15 PAGES: 2

									South Birmingham College (Centre No: 20104D)
Division: Information and Communication Technology
BTEC Level 3 Extended Diploma in IT - Group (2C)
Unit No: 42 – Unit Title: Spreadsheet Modelling



    a) You need to carry out analysis and interpretation of the calculated data. Carry out
       analysis of the data by using methods such as converting data to useful charts or
       graphs, producing sorted or filtered lists, trends, patterns, results and draw
       conclusions.



                                 Monthly Expenditure Chart
  5000
  4500
  4000
  3500
  3000
  2500
  2000
  1500
  1000
   500
      0




                        Tshirts Sold      Football Sold   Accesories Sold   Total Income




In spreadsheets data can be displayed in terms of a chart that makes it useful for the
club to examine the clubs progress. By using charts the club can monitor the income of
each game they play.

For example on the chart above we can observe the t-shirts sold, football sold,
accessories sold and the total income of each games. It helps the football club to analyse
the progress of their club and by observing the charts they can predict their upcoming
income from games.

Thus they can set their goals and targets for the upcoming five or ten years. As graphs
are easier to understand and instead of reading through all the data in spreadsheet
project managers use graphs and charts to display the data. It is much simpler, efficient
and takes less time.




Student name: Muhammad Yasir Uddin
Unit Tutor: Bahman Parsapour
South Birmingham College (Centre No: 20104D)
Division: Information and Communication Technology
BTEC Level 3 Extended Diploma in IT - Group (2C)
Unit No: 42 – Unit Title: Spreadsheet Modelling




Above chart is taken from profit and loss calculation tables. It shows the calculation of
attendance per match against the sales of tickets. The bar chart is simplified so the staff
of the club can check how many tickets have been sold and what the attendance at that
game is. Calculations have been done to get the total income ticket sales.




Student name: Muhammad Yasir Uddin
Unit Tutor: Bahman Parsapour

								
To top