Project 1-
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 file ServerLogs.xls, you will find information about the network traffic for a one-week period.
1. Open the SERVERlOGS.XLS FILE (on ANGEL)
2. Prepare a graph/chart for the Total bandwidth used for each day (line graph)
3. Prepare a graph/chart for the bandwidth used per day, by time period (line graph)
4. Prepare a graph/chart for the average bandwidth used in each two-hour period (line graph)
5. All graphs/charts should be placed on their own worksheet
6. Format each graph/chart to include an appropriate title, and to look professional
7. Save the file as YourLastName_Project 4-1 and upload your completed spreadsheet to the Project 4-1 Dropbox on ANGEL.
Project 2-
Note: This project requires the use of the SUMPRODUCT function. If you are not familiar with this function, you should research the function, its purpose, and how to use it, before starting this project.
Campus Travel is interested in integrating its business processes to streamline processes such as purchasing, sales, human resource management, and customer relationship management. Because of your success in implementing the e-commerce infrastructure, the general manager asks you for advice on what to do to streamline operations at Campus Travel. Use the data provided in the file ERPSystems.xls to make a recommendation about which ERP system to purchase. The file includes ratings of the different modules of the systems and the weights assigned to these ratings.
1. Open the ERPSystems.xls file (on ANGEL)
2. Determine the product with the highest overall rating (Hint: use the SUMPRODUCT function to multiply each vendor's scores with the respective weights and add the weighted scores)
3. Prepare the necessary graphs/charts to compare the products on the different dimensions and the overall score.
4. All graphs/charts should be placed on their own worksheet
5. Format each graph/chart to include an appropriate title, and to look professional
6. Save the file as YourLastName_Project 4-2 and upload your completed spreadsheet to the Project 4-2 Dropbox on ANGEL.
Project 3-
Note: This project requires the use of the COUNTIF function. If you are not familiar with this function, you should research the function, its purpose, and how to use it, before starting this project.
Campus Travel has recently started selling products on the Internet; the managers are eager to know how the company's Web site is accepted by customers. The file CampusTravel.xls contains the information for the past three days, generated from the company's Web server, including IP addresses of the visitors, whether a transaction was completed, and the transaction amount. You are asked to present the current status of the e-commerce initiative.
1. Open the CampusTravel.xls file (on ANGEL)
2. Prepare a graph highlighting the total number of site visits and the total number of transactions per day (Hint: to calculate the total number of site visits and the total number of transactions, use the COUNTIF function to count the number)
3. Prepare a graph/chart highlighting the total sales per day
4. All graphs should be placed on their own worksheet
5. Format each graph to include an appropriate title, and to look professional
6. Save the file as YourLastName_Project 4-3 and upload your completed spreadsheet to the Project 4-3 Dropbox on ANGEL.