Internet connections between offices are becoming slow

Assignment Help Computer Networking

Reference no: EM13757847

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.

Reference no: EM13757847

Questions Cloud

Identify informal fallacies in manipulative appeals : Identify the informal fallacies, assumptions, and biases involved in manipulative appeals and abuses of language. Create written work utilizing the concepts of critical thinking.

Design a high-level conceptual view of a data warehouse : Design a high-level conceptual view of a data warehouse using Microsoft Visio that shows the following: Integration layers and The data warehouse

Samples means and also compute the population mean : Assuming that you sample without replacement, select all possible samples of n = 2 and construct the sampling distribution of the mean. Compare the mean of all the samples means and also compute the population mean. Are they equal? What is the proper..

Different users and implement their permissions using sql : Create at least two different users and implement their permissions using SQL statements. Create a matrix to indicate the permissions (read, insert, delete, modify) you would grant to different users of your database

Internet connections between offices are becoming slow : 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 form..

Disscuss the concept of dimand schedule : Disscuss the concept of dimand schedule

Discussion about wireless technologies and networks : Write a 350- to 700-word summary of the discussion about wireless technologies and networks in work environments

Basic technology underlying health care information systems : Analyze the basic technology underlying health care information systems. Argue that the need for technological innovation and / or modification is most pressing. Support the argument with examples

Description of current outsourcing and offshoring activities : Details regarding the type of business that the company is engaged in. A description of current outsourcing and offshoring activities

User Account

All Pages