# M1 by abuzar251

VIEWS: 15 PAGES: 2

• pg 1
```									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
project managers use graphs and charts to display the data. It is much simpler, efficient
and takes less time.

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.