TDC 461 Final Examination

Summer Quarter, 1998

Exam Instructions

1. Exams are to be completed independently, with no help from classmates, roommates, or other individuals. Use all other resources available to you: Textbooks, course web pages, etc.

2. Exams must be word-processed and spell checked. Drawings may be hand-drawn or computer-generated. Please make sure that your full name is on every page of the exam, that each page of the exam is numbered, and that you clearly indicate the question number beside the answer.

3. Save the answers to all questions in a single file. Name your exam file using the following syntax: [lastname][fin].doc (e.g., sadlerfin.doc) If you use visio or some other drawing tool for diagrams, please combine all files into a zip file (e.g., yourname.zip).

4. Exams are due no later than 5:00pm on Monday, 24 August, 1998. You may turn in your exam using one of the following methods:

5. If you have questions about the exam, please mail me directly (lsadler@mail.depaul.edu). DO NOT post questions to the HyperNews group. If someone asks as question about the exam that I think you all need to see, I will repost the question and the answer to the HyperNews group.

About the Exam

The goal of this exam is to provide you with an opportunity to apply what you have learned thus far in class to real-world problems and to demonstrate your understanding of the areas covered. There is one scenario in this exam and all questions are based on that scenario. The weight of the question (points possible) and approximate time expected to complete the question is provided beside the question number for your information. Completion times are approximate—use as much time as you need/have to complete each question adequately. Comprehensive answers are expected, but I do not expect you to rewrite (or copy!) the book. Feel free to use tables and drawings in addition to or in place of narrative.

The Exam:

You are a consultant with Chicago Communications Associates, a medium-sized tele- and data communications consulting firm. You have been contracted out to Magliazzi Brothers, a large, multi-site automotive sales, leasing, and repair company in Chicago. Magliazzi Brothers has four loctions. In the Lakeview office, which is also their headquarters, they sell BMW and Saab autos. They have a West Lakeview office where they sell General Motors products (Chevrolet, Oldsmobile, Pontiac). The Glencoe branch sells Mercedes and Porsches, and the Schaumburg branch sells all three German manufacturers: Mercedes, BMW, and Porsche.

Each of these automotive manufacturers have become increasingly technologically sophisticated in the last two years, and the Magliazzi brothers (Tom and Ray) believe that it is time to invest in new voice and data networking technologies to allow them to take full advantage of computer-based and online information and services, so that they can pass the efficiencies on to their customers.

The following table describes the current technology installed at each branch.

Branch

Voice System

# of Lines

Data Networking

# of Workstations

Lakeview

Key Telephone System. Intercom and voice mail are only peripherals.

20 lines for 65 staff members. 40 station sets (sales, parts, and service staff share station sets)

Windows '95 "sharing " (peer to peer networking) between cashier, finance person, and owners. Stand-alone workstations for sales staff, with individual modems for web connectivity and e-mail. Dial-up connections on six PCs in parts and service for access to manufacturers online information and ordering services.

25

West Lakeview

Key Telephone System. Intercom and voice mail as peripherals.

10 lines for 35 staff; 20 station sets.

Windows '95 "sharing " (peer to peer networking) between cashier, finance person, and owners. Stand-alone workstations for sales staff, with individual modems for web connectivity and e-mail. Dial-up connections on six PCs in parts and service for access to manufacturers online information and ordering services.

15

Glencoe

Key Telephone System with intercom and voice mail peripherals.

5 lines for 20 staff. 12 station sets.

Windows '95 "sharing " (peer to peer networking) between cashier, finance person, and owners. Stand-alone workstations for sales staff, with individual modems for web connectivity and e-mail. Dial-up connections on six PCs in parts and service for access to manufacturers online information and ordering services.

10

Schaumburg

Key Telephone System with intercom and voice mail peripherals.

20 lines for 68 staff; 48 station sets.

Windows '95 "sharing " (peer to peer networking) between cashier, finance person, and owners. Stand-alone workstations for sales staff, with individual modems for web connectivity and e-mail. Dial-up connections on six PCs in parts and service for access to manufacturers online information and ordering services.

38

The key telephone systems at each of the branches is the same brand and vintage. None of the key telephone systems are networked with the other key telephone systems. Calls to other branches are billed as regular calls on the system (e.g., no 4-digit dial).

The Magliazzi brothers have spoken with representatives from the auto manufacturers they represent, and with several other dealers of their size across the U.S., and have formulated an initial set of needs to be met. Your job is to develop a plan that will (a)meet the needs set forth by the Magliazzis, (b)scale for 7% expected growth in staff over the next three years at each location, and (c)make financial sense. Develop a comprehensive technology plan that includes the following sections.

  1. Executive summary of issues and recommendations.
  2. Telecommunications Plan
    1. Section A: Needs and Options (KTS/Centrex/PBX). The Magliazzis have specified the following system requirements.
      1. 4-digit-dial between all four sites
      2. voicemail for all staff
      3. announcements while callers are on hold
      4. call detail for each station
      5. automated attendant that routes customer calls to sales, parts, service, or an individual by touch-tone selection
      6. uniformity in premises equipment and services at all four locations
    2. Section B: Recommendations and Justification
    3. Section C: System diagram
  3. Data Networking Plan
    1. Section A: Needs and Options. The Magliazzis have specified the following system requirements.
      1. Local area network at each site for resource sharing (CD-ROMs, printers, file, and application sharing). Independent LANs at each location must be linked (WAN) so that files and other resources may be shared between sites.
      2. Web server from the Lakeview headquarters available worldwide 24x7.
      3. Intranet server, also housed at the Lakeview headquarters, that is available only to IP addresses from the Magliazzi domain (160.172.xx.xxx). This server will provide e-mail to all employees, house sales and customer demographics data, store all parts catalogs and service bulletins from the various manufacturers represented, and provide links to manufacturer services such as on-line part-ordering and financing information (credit bureau reports, on-line loan processing, etc.).
      4. Each desktop workstation must have full Internet (non-firewalled) and intranet (firewalled) services.
      5. Provide for one networked printer for every 5 desktop workstations at each site.
    2. Recommendations and Justification. This section must include:
      1. Recommended cable plant for data at both LAN and WAN levels;
      2. Recommended access method for Internet access (ISP vs. PAP; dial-up vs. direct connect; in-house routing or contracted routing services)
      3. Recommended ISP or PAP;
      4. Recommended LAN technology;
      5. Recommended WAN technology;
      6. Recommended firewall technology;
      7. Justifications for recommendations (financial, ease of use, ease of management, etc.)
    3. Network diagram. If you have specified the same network technology at all sites, show one site in detail and note that the other three are identical (or point out any individual differences). Be sure to show all points of interconnectivity, clearly marking carrier service and cable plant. Be sure to show all necessary network components.
  4. Personnel Resource Requirements

Recommend a staff size and positions that will be needed to support the recommended voice and data networks. Assume that the Magliazzis already have one PC technical support person (help desk and basic hardware maintenance) and one key telephone system technician on staff. Will they require more resources? If so, list the positions they will need to fill and ballpark salaries for those positions.