Question: City School District is a large, urban
City School District is a large, urban school district that operates 27 schools serving 22,000 students from kindergarten through grade 12. All schools are networked into a regional WAN that connects the schools to the district central office and each other. The district has a total of 5,300 client computers. The following table shows the annual costs. Calculate the real TCO (without wasted time).
Budget Item Annual ___________________ Cost
IT staff salaries ……………………………………........ $7,038,400
Consultants ……………………………………................ 1,340,900
Software …............................................................... 657,200
Staff training ……………………………………................. 545,900
Client computers …………………………………………. 2,236,600
Servers ……………………………………........................... 355,100
Network …………………………………….......................... 63,600
Supplies and parts ……………………………………...... 2,114,700
2. City School District, Part 2:
Read and complete Mini-case I. Examine the TCO by category. Do you think that this TCO indicates a well-run network? What suggestions would you have?
3. Central Textiles:
Central Textiles is a clothing manufacturer that operates 16 plants throughout the south- ern United States and in Latin America. The Information Systems Department, which reports to the vice president of finance, operates the central mainframe and LAN at the head-quarters building in Spartanburg, South Carolina, and the WAN that connects all the plants. The LANs in each plant are managed by a separate IT group at each plant that reports to the plant manager (the plant manager’s report to the vice president of manufacturing). The telephone communications system and long-distance agreements are man- aged by a telecommunications department in the head- quarters that reports to the vice president of finance. The CEO of Central Textiles has come to you asking about whether this is the best arrangement, or whether it would make more sense to integrate the three functions under one new department. Outline the pros and cons of both alternatives.
4. Indiana University:
Reread Management Focus 12-5. Take another look at Figure 12-1. If this is a typical traffic pattern, how would you suggest that they improve performance?
FIGURE 12-1: Device management software used on Indiana University’s core
backbone network
Focus 12-5:
Internet2 is a high-performance backbone that connects about 400 Internet2 institutions in more than 100 countries. The current network is primarily a 10 Gbps ï¬ber-optic network.
The network is monitored 24 hours a day, 7 days a week from the network operations center (NOC) located on the campus of Indiana University. The NOC oversees problem, conï¬guration, and change management; network security; performance and policy monitoring; reporting; quality assurance; scheduling; and documentation. The center provides a structured environment that effectively coordinates operational activities with all participants and vendors related to the function of the network.
The NOC uses multiple network management software running across several platforms. One of the tools used by the NOC that is available to the general public is the Internet2WeatherMap (noc.net.internet2.edu). Each of the major circuits connecting the major Internet2 giga-pops is shown on the map. Each link has two parts, showing the utilization of the circuits to and from each pair.
Required:
1. City School District is a large, urban school district that operates 27 schools serving 22,000 students from kindergarten through grade 12. All schools are networked into a regional WAN that connects the schools to the district central office and each other. The district has a total of 5,300 client computers. The table below shows the annual costs. Calculate the real TCO (without wasted time).
2. Read and complete Minicase I. Examine the TCO by category. Do you think that this TCO indicates a well-run network? What suggestions would you have?
3. Central Textiles is a clothing manufacturer that operates 16 plants throughout the southern United States and in Latin America. The Information Systems Department, which reports to the vice president of finance, operates the central mainframe and LAN at the headquarters building in Spartanburg, South Carolina, and the WAN that connects all the plants. The LANs in each plant are managed by a separate IT group at each plant that reports to the plant manager (the plant managers report to the vice president of manufacturing). The telephone communications system and long-distance agreements are managed by a telecommunications department in the headquarters that reports to the vice president of finance. The CEO of Central Textiles has come to you asking about whether this is the best arrangement, or whether it would make more sense to integrate the three functions under one new department. Outline the pros and cons of both alternatives.
4. Take another look at Figure 12-1. If this is a typical traffic pattern, how would you suggest that they improve performance?
> Is it important to have the fastest wireless LAN technology in your apartment? What about in the library of your school? Explain.
> What is a bottleneck, and why do network managers care about them?
> What are typical speeds for the LAN, building backbone, and campus backbone? Why?
> For what is HTML used?
> What is the difference between a building backbone and a campus backbone, and what are the implications for the design of each?
> What are the seven network architecture components?
> What is the turnpike effect, and why is it important in network design?
> What issues are important to consider in explaining a network design to senior management?
> What is a network baseline, and when is it established?
> What are some major problems that can cause network designs to fail?
> What are the key parts of an RFP?
> What are the keys to designing a successful data communications network?
> How does dynamic addressing work?
> What is a subnet mask?
> For what is HTTP used? What are its major parts?
> What is a subnet and why do networks need them?
> How does TCP establish a session?
> How is TCP different from UDP?
> Compare and contrast the three types of addresses used in a network.
> What are the parts of TCP/IP and what do they do? Who is the primary user of TCP/IP?
> Describe the anatomy of a router. How does a router differ from a computer?
> What is the transmission efficiency of a 5,000-byte file sent in response to a Web request HTTP, TCP/IP, and Ethernet? Assume that the HTTP packet has 100 bytes in addition to the 5,000-byte file. Assume that the maximum packet size is 1,200 bytes. Remem
> What is the transmission efficiency of a 1,000-byte file sent in response to a Web request HTTP, TCP/IP, and Ethernet? Assume that the HTTP packet has 100 bytes in addition to the 1,000-byte file. Remember from Chapter 4 that deficiency = user data/total
> What is the transmission efficiency of a 10-byte Web request sent using HTTP, TCP/IP, and Ether-net? Assume that the HTTP packet has 100 bytes in addition to the 10-byte URL. Remember from Chapter 4 that deficiency = user data/total transmission size.
> What type of routing does a TCP/IP client use? What type of routing does a TCP/IP gateway use? Explain.
> What is a network computer?
> How does static routing differ from dynamic routing? When would you use static routing? When would you use dynamic routing?
> Why does HTTP use TCP and DNS use UDP?
> Explain how the client computer in Figure5-16 (128.192.98.xx) would obtain the data link layer address of its subnet router.
> Explain how multicasting works.
> What does the network layer do?
> Compare and contrast unicast, broadcast, and multicast messages.
> What is QoS routing and why is it useful?
> What is a session?
> What are the differences between connectionless and connection-oriented messaging?
> How does decentralized routing differ from centralized routing?
> Compare and contrast the three cloud computing models.
> What are the different types of application architectures?
> Which is best for the International Services Division, a dedicated-server network or peer-to-peer LAN? Explain your choice. 2. Draw a network plan using Microsoft Visio that includes the general layout of the LAN (computers, servers, cables, hubs/switche
> One important issue in designing Ethernet lies in making sure that if a computer transmits a frame, any other computer that attempts to transmit at the same time will be able to hear the incoming frame before it stops trans- mitting, or else a collision
> Computer Dynamics is a microcomputer software development company that has a 300-computer network. The company is located in three adjacent five-story buildings in an office park, with about 100 computers in each building. The LANs in each building are s
> Review the topics in this chapter. Prepare an agenda for your training session. The agenda should be an outline, showing topics and subtopics with enough detail to allow the reader to follow. Remember Bob Jones' advice on what the management and staff wi
> Suppose that you are the network manager for Central University, a medium-sized university with 13,000 students. The university has 10 separate colleges (e.g., business, arts, journalism), 3 of which are relatively large (300 faculty and staff members, 2
> What file transfer protocols would you recommend? Be prepared to support your recommendations. 2. Prepare a brief position paper on the types of errors you can expect in the NDAS network and the steps you believe NDAS can take to prevent, detect, and cor
> Smith, Smith, Smith, and Smith is a regional accounting firm that is putting up a new headquarters building. he building will have a backbone network that connects eight LANs (two on each floor). he company is very concerned with network errors. What adv
> Fred Jones, a distant relative of yours and president of Deals-R-Us Brokers (DRUB), has come to you for advice. DRUB is a small brokerage house that enables its clients to buy and sell stocks over the Internet, as well as place traditional orders by phon
> Briefly describe the current state of Next Day Air Service's office automation, system integration, and networking. Begin by explaining how each department uses information technology, what hardware it uses, and what functions currently are automated. Al
> Eureka! is a telephone- and Internet- based concierge service that specializes in obtaining things that are hard to find (e.g., Super Bowl tickets, first-edition books from the 1500s, Faberge eggs). It currently employs 60 staff members who collectively
> John Adams is the chief information officer (CIO) of Global Consultants (GC), a very large consulting firm with offices in more than 100 countries around the world. GC is about to purchase a set of several Internet-based financial software packages that
> Prepare a report outlining the major security threats faced by NDAS. Be sure to identify those that you think are major threats and those that are minor threats. 2. Prepare a partial risk assessment for NDAS that includes their major assets, threats and
> Belmont State Bank is a large bank with hundreds of branches that are connected to a central computer system. Some branches are connected over dedicated circuits and others use Multi-Protocol Label Switching(MPLS). Each branch has a variety of client com
> What type of Internet access technologies would you recommend for the Atlanta, New Orleans, and the corporate office in Tampa and other locations as well? 2. Outline the advantages and disadvantages of the three approaches to for creating a web presence
> Your cousin Cathy runs a part-time business out of her apartment. She buys and sells collectibles such as antique prints, baseball cards, and cartoon cells and has recently discovered the Web with its many auction sites. She has begun buying and selling
> With your knowledge of NDAS's network, what service would you recommend for the future to connect the remote offices to the hubs at Atlanta and New Orleans and the hubs to the corporate office in Tampa? Will the current facilities be adequate? 2. Preside
> Cookies Are Us runs a series of 100 cookie stores across the mid-western United States and central Canada. At the end of each day, the stores send sales and inventory data to headquarters, which uses the data to ship new inventory and plan marketing camp
> For this case, one may assume that there are LANs in four department offices (Data Processing, Accounts Payable, Information Services, and Agent Operations) and at Fleet Maintenance and Dispatch in the Secondary Building. What type of backbone network do
> Pat’s Engineering Works is a small company that specializes in complex engineering consulting projects. The projects typically involve one or two engineers who do data-intensive analyses for companies. Because so much data are needed, t
> Prepare a brief management summary on the technical essential aspects of the Internet and the World Wide Web and how they work. Remember, the audience is not technical. He is confused about the relationship between the World Wide Web and the Internet and
> Use the following information to compute the confidence interval for the population proportion. a) n = 715 and x = 329, with 95% confidence b) n = 284 and p^ = .71, with 90% confidence c) n = 1250 and p^ = .48, with 95% confidence d) n = 457 and x = 270,
> The following table displays round-trip flight prices from 14 major U.S. cities to Atlanta and Salt Lake City. a. Compute the mean price for a round-trip flight into Atlanta and the mean price for a round-trip flight into Salt Lake City. Is At
> Data collected by the Oil Price Information Service from more than 90,000 gasoline and convenience stores throughout the U.S. showed that the average price for a gallon of unleaded gasoline was $3.28 (MSN Auto website). The following data show the price
> Consider a sample with data values of 27, 25, 20, 15, 30, 34, 28, and 25. Compute the range, interquartile range, variance, and standard deviation.
> Consider a sample with data values of 10, 20, 12, 17, and 16. Compute the variance and standard deviation.
> Consider a sample with data values of 10, 20, 12, 17, and 16. Compute the range and interquartile range.
> The current value of a company is $25 million. If the value of the company six year ago was $10 million, what is the company’s mean annual growth rate over the past six years?
> If an asset declines in value from $5000 to $3500 over nine years, what is the mean annual growth rate in the asset’s value over these nine years?
> Suppose that at the beginning of Year 1 you invested $10,000 in the Stivers mutual fund and $5000 in the Trippi mutual fund. The value of each investment at the end of each subsequent year is provided in the table below. Which mutual fund performed bette
> Consider a sample with data values of 10, 20, 21, 17, 16, and 12. Compute the mean and median.
> Annual revenue for Corning Supplies grew by 5.5% in 2014, 1.1% in 2015, −3.5% in 2016, −1.1% in 2017, and 1.8% in 2018. What is the mean growth annual rate over this period?
> A production process is checked periodically by a quality control inspector. The inspector selects simple random samples of 30 finished products and computes the sample mean product weights x̅. If test results over a long period of time show that 5% of t
> Based on a survey of master’s programs in business administration, magazines such as U.S. News & World Report rank U.S. business schools. These types of rankings are based in part on surveys of business school deans and corporate re
> The following table shows the total return and the number of funds for four categories of mutual funds. a. Using the number of funds as weights, compute the weighted average total return for these mutual funds. b. Is there any difficulty associated wit
> The grade point average for college students is based on a weighted mean computation. For most colleges, the grades are given the following data values: A (4), B (3), C (2), D (1), and F (0). After 60 credit hours of course work, a student at State Unive
> Martinez Auto Supplies has retail stores located in eight cities in California. The price they charge for a particular product in each city varies because of differing competitive conditions. For instance, the price they charge for a case of a popular br
> The U.S. Bureau of Labor Statistics collects data on unemployment rates in each state. The data contained in the file UnemploymentRates show the unemployment rate for every state and the District of Columbia over two consecutive years. To compare unemplo
> In automobile mileage and gasoline-consumption testing, 13 automobiles were road tested for 300 miles in both city and highway driving conditions. The following data were recorded for miles-per-gallon performance. City: 16.2 16.7 15.9 14.4 13.2 15.3 16.8
> The creator of a new online multiplayer survival game has been tracking the monthly downloads of the newest game. The following table shows the monthly downloads (in thousands) for each month of the current and previous year. a. Compute the mean, media
> Nielsen tracks the amount of time that people spend consuming media content across different platforms (digital, audio, television) in the United States. Nielsen has found that traditional television viewing habits vary based on the age of the consumer a
> OutdoorGearLab is an organization that tests outdoor gear used for climbing, camping, mountaineering, and backpacking. Suppose that the following data show the ratings of hardshell jackets based on the breathability, durability, versatility, features, mo
> Consider a sample with data values of 10, 20, 12, 17, and 16. Compute the mean and median.
> A researcher reports survey results by stating that the standard error of the mean is 20. The population standard deviation is 500. a. How large was the sample used in this survey? b. What is the probability that the point estimate was within ±25 of the
> A random sample of 30 colleges from Kiplinger’s list of the best values in private college provided the data shown in the file BestPrivateColleges (Kiplinger website). The variable named Admit Rate (%) shows the percentage of students that applied to the
> The Russell 1000 is a stock market index consisting of the largest U.S. companies. The Dow Jones Industrial Average is based on 30 large companies. The file Russell gives the annual percentage returns for each of these stock indexes for the years 1988 to
> Over the past 40 years, the percentage of homes in the United States with smoke detectors has risen steadily and has plateaued at about 96% as of 2015 (National Fire Protection Association website). With this increase in the use of home smoke detectors,
> Department of transportation’s study on driving speed and miles per gallon for midsize automobiles resulted in the following data:
> The file StockComparison contains monthly adjusted stock prices for technology company Apple, Inc., and consumer-goods company Procter & Gamble (P&G) from 2013–2018. a. Develop a scatter diagram with Apple stock price on the horizontal axis and P&G stock
> Five observations taken for two variables follow. a. Develop a scatter diagram for these data. b. What does the scatter diagram indicate about a relationship between x and y? c. Compute and interpret the sample covariance. d. Compute and interpret the
> Five observations taken for two variables follow. a. Develop a scatter diagram with x on the horizontal axis. b. What does the scatter diagram developed in part (a) indicate about the relationship between the two variables? c. Compute and interpret the
> The Bureau of Transportation Statistics keeps track of all border crossings through ports of entry along the U.S.-Canadian and U.S.-Mexican borders. The data contained in the file BorderCrossings show the most recently published figures for the number of
> Fortune magazine’s list of the world’s most admired companies for 2014 is provided in the data contained in the file AdmiredCompanies (Fortune magazine website). The data in the column labeled “Return” shows the one-year total return (%) for the top rank
> Consumer Reports provides overall customer satisfaction scores for AT&T, Sprint, T-Mobile, and Verizon cell-phone services in major metropolitan areas throughout the United States. The rating for each service reflects the overall customer satisfactio
> Three firms carry inventories that differ in size. Firm A’s inventory contains 2000 items, firm B’s inventory contains 5000 items, and firm C’s inventory contains 10,000 items. The population standard deviation for the cost of the items in each firm’s in
> Annual sales, in millions of dollars, for 21 pharmaceutical companies follow. a. Provide a five-number summary. b. Compute the lower and upper limits. c. Do the data contain any outliers? d. Johnson & Johnson’s sales are the large
> Naples, Florida, hosts a half-marathon (13.1-mile race) in January each year. The event attracts top runners from throughout the United States as well as from around the world. In the race results shown below 22 men and 31 women entered the 19â
> A data set has a first quartile of 42 and a third quartile of 50. Compute the lower and upper limits for the corresponding boxplot. Should a data value of 65 be considered an outlier?
> Show the five-number summary and the boxplot for the following data: 5, 15, 18, 10, 8, 12, 16, 10, 6.
> Show the boxplot for the data in exercise 46. Exercise 46: Consider a sample with data values of 27, 25, 20, 15, 30, 34, 28, and 25. Provide the five-number summary for the data.
> Consider a sample with data values of 27, 25, 20, 15, 30, 34, 28, and 25. Provide the five-number summary for the data.
> The New York Times reported that Apple has unveiled a new iPad marketed specifically to school districts for use by students (The New York Times website). The 9.7-inch iPads will have faster processors and a cheaper price point in an effort to take marke
> A sample of 10 NCAA college basketball game scores provided the following data. a. Compute the mean and standard deviation for the points scored by the winning teams. b. Assume that the points scored by the winning teams for all NCAA games follow a bel
