Case Scenario:
Campus Travel has recently found that its Internet connections between offices are becoming slow, especially during certain periods of the day. Since all the online traffic is maintained by another company, an increase in capacity requires a formal approval from the general manager. The IS manager has proposed to increase the capacity of the company's network; in a few days, he has to present the business case for this proposal at the weekly meeting of the department heads. You are asked to prepare graphs for the presentation to support the IS manager's business case. In the (illustarted below), you will find information about the network traffic for a one-week period. Prepare the following graphs:
1.) Total bandwidth used for each day (line graph)
2.) Bandwidth used per day, by time period (line graph)
3.) Average bandwidth used in each two-hour period (line graph)
Format the graphs in a professional manner and print out each graph on a separate page (Hint: if you are using Microsoft Excel's Chart Wizard, select "Place chart: As New Sheet" in step 4).
Bandwidth Used (MB)
Department 01-Sep-07 02-Sep-07 03-Sep-07 04-Sep-07 05-Sep-07 06-Sep-07 07-Sep-07
8-10am 5 6 5 7 8 0 0
10-12pm 8 10 7 9 8 3 3
12pm-2pm 12 12 15 14 12 0 0
2pm-4pm 22 25 20 18 17 9 8
4pm-6pm 13 12 15 17 15 0 1