IT 220 Network Standards and Protocol Final Project – Scope of Work

T.J. Smelt Enterprises Network Design and Installation
NDE Scope of Work Document

This document is intended for use in the implementation of retail/wholesale business networks. The contents of this document are in support of and in accordance with current MediocrIT NDE specifications. This document is approved for internal use only and supersedes all others.
Included in this document are:

  • Design and Implementation Scope of Work
  • Customer’s Requirements
  • Bill of Materials
  • Floor Plans with Cable Layout
  • Projected Time Table for Completion
  • Network Logical Design
  • Security Procedures, suggested

It will be the responsibility of MediocrIT Inc. to provide updates and document maintenance in the event of changes to the MediocrIT NDE specification. It will be the responsibility of the site level team to manage the implementation of these designs into the space.
Any deviation from the NDE design package will constitute the need for a custom engineering design package. The creation of any custom engineering (non-NDE) designs and documentation will be the responsibility of the site team. MediocrIT will be responsible to act in the role of design reviewer for any proposed deviation from this NDE design. Any and all such changes will require proper change control documentation, review, and approval by the MediocrIT Inc. engineering team for technical and operational impact.

Table of Contents
Scope of Work                                  3
Customer’s Requirements               5
Customer’s Instructions                  5
Bill of Materials                              9
Suggested Security Procedures          10
Appendix A                                        14
Appendix B                                        20

Scope of Work # 15487968
Please review this information and ensure its accuracy. Any discrepancies should be reported to MediocrIT Inc. as soon as possible.
Contact Info:
Smelt Enterprises
T.J. Smelt Sr.
1162 Moreland Avenue Southeast
Atlanta, GA 30316

Phone: 414.555.5896 Fax: 414.555.2547
Email: management@smeltent.com

Current Inventory:
N/A
(Customer is installing entire system. No current equipment will be used as part of this network.)

Overview:
Current customer concerns are:
• Ensuring secure connections between areas of the building.
• Allowing for a 10% expansion in the near future.
• Ensuring that all locations have access to software needed for day to day operations.
Scope of Work Requested:
Smelt Enterprises has requested MediocrIT Inc. to install and configure a new Local Area Network (LAN), The LAN will consist of 3 floors in the current building. The three floors will consist of the first floor which is mainly the retail store and training, the second floor which is mainly the call center and all management and support staff for the company, and the third floor which is the warehouse and the network room.

  • The server will reside in the basement of the building. The servers will be a rack-mounted blade style Dell PowerEdge R610 and a Dell PowerEdge R610 for Server DFS replication. This server will be placed in the server room inside of cabinets.
  • There will be 86 workstations installed and configured on location. These workstations will have Windows Server 2008 Service Pack 2 and be networked via 10/100/1000 Ethernet, 802.11 b/g/n wireless networking, and 50/125 Fiber Optic cable. All workstations will be configured to log in to the server located in the server room. Five laptops were be purchased and issued to management from the IT department.
  • Dell 1135n laser printers will be installed in ten departments. All departments will have one with the exception of the warehouse and corporate security. The warehouse will have a special printer locally installed in the shipping and receiving area for shipping responsibilities.
  • Each location will be equipped with a Panasonic KX-T7720 phone. These phones will be at each computer location minus the 15 computers set aside for the warehouse use. The phones will operate on their own sub-network within the greater network of T.J. Smelt Enterprises.
  • Pelco’s SD4-B1 cameras will be installed in nine key locations and connected to the network. The server will use Pelco’s software that will allow anyone with proper access to watch the cameras from any workstation. This software will also be configured to push video feed to key stake holders within the company upon certain key events decided upon by corporate security and management.
  • MediocrIT will configure and install the 3 Cisco Routers and 3 Cisco Switches that will be used for the LAN connections.
  • MediocrIT will configure and install the 3 Cisco Routers and 3 Cisco Switches that will be used for the LAN connections. Each location will be wired for CAT 5e Unshielded Twisted Pair Ethernet and configured with a Brocade FastIron 10/100 Mbps 48 port Switches and 10/100/1000 Mbps Cisco 2911/K9 Routers.
  • MediocrIT will configure the Network to be a Windows TCP/IP based network addressed in the 186.32.0.1 – 186.32.0.62 (Call Center/Training), 186.32.0.65 – 182.32.0.126 (Retail/Internal), and the remaining two subnets will be used by the phones, with a subnet mask of 255.255.192.0. 802.3 and 802.11 standards will be the only protocols used in the installation of this network. All of the standards set down in ANSI/TIA 568 C and 569 B, where applicable, will be strictly adhered to for this installation.
  • The Microsoft Server will be configured with Active Directory, DHCP, DNS, email, firewall, e-commerce, print, and file servers.
  • All cables, panels, and network nodes will be colored-coded and labeled according to the ANSI/TIA-606-A standard.
  • The call center will have the phones running within its own networks through a Voice over Internet Protocol gateway configured into the network.
  • On each workstation Microsoft Office 2010, Microsoft One Note 2010, Live Meeting, and Microsoft Communicator installed for day to day productivity.
  • McAfee Antivirus Plus 2011 security suite will be installed for system security. To allow for updates all network and security software the network MUST have access to the internet. In the event that internet access is not available, the customer will be responsible for keeping the Anti-Virus definitions and security software up to date. All users will be assigned network accounts and Email boxes. Since the internet is going to be used, MediocrIT will additionally configure the Kismet/Wireshark packet sniffers, Nessus Vulnerability Scanner, and OSSEC for the Intrusion Detection and Protection System (IDPS) to protect the network from internet threats. In addition MediocrIT will install and configure Cisco’s Virtual Private Networking (VPN) service for access to network resources over the WAN for select users.
  • The server will be configured to automatically backup itself up every morning at 1:30am. These backups will be stored offsite over the Wide Area Network (WAN). Microsoft Office 2010 will be installed on each workstation with the default installation options.
  • MediocrIT will not install and configure the Point-Of-Sale software on all applicable computers. No other software will be installed or configured.
  • Upon the completion of this installation any support needed for the software installed can be handled by our phone support. The hours of operation and billing costs are listed below. MediocrIT will also provide a packet of suggested procedures for administration and security.
  • Customer Requirement’s

All assumptions MUST be correct to validate this scope of work. If anything listed below is inaccurate contact MediocrIT immediately. Any inaccuracies will result in increased labor.

  • The Server and workstations MUST be placed within 6 Foot of a 110volt grounded outlet.
  • The Server and workstations MUST be placed within 10 Feet of a Switch or CAT5e Network drop location.
  • The server MUST be placed in a secure, well ventilated area.
  • Internet access is REQUIRED for automatic Software Updates
  • Labor will be billed per man-hour plus travel.
  • Customer MUST be properly licensed for all software that will be installed.
  • The Customer is responsible for coordinating with the local loop provider and/or the ISP to ensure that T1 or greater connectivity is available between the offices BEFORE the install date.
  • Full time 24/7 network internet access is required to send and receive internet email. If the internet is not available, the customer will only be able to E-Mail within the WAN (Between offices).
  • The Switches, Routers, and Firewalls will need to be installed on a shelf, in the plenum, or mounted to the wall.
  • These devices must be placed within 4 feet of a grounded 110Volt outlet.
  • There is rack system or hardware quoted. All network electronics MUST be mounted on shelves, in the rack, or on the wall. Contact your sales rep if you are interested in any expansion of the hardware.
  • Procedures in regards to network access and security are the responsibility of the customer, T.J. Smelt Enterprises.
  • The customer is responsible for the installation and maintenance of Customer Relations Management (CRM) software.

Customer Instructions:
Please carefully review this document. The dispatched technician will ONLY be authorized to perform work that is specifically listed in the above scope of work. Any additional work will need to be scheduled as a future service call by executing a Change Order. The customer is responsible for having access to all software currently installed on their PC’s. Failure to have CDs or DVDs can significantly increase the time spent onsite and could make completing the service call impossible. The customer should have access to all required hardware prior to the install date. Any revisions to this Scope of Work must be recorded by execution of a Change Order.
Current MediocrIT Time and Material Labor Rates during business hours:
– Onsite Network Service (Labor-Network) $175.00/Hour
– Onsite System Repair work (Labor-Onsite) $150.00/Hour
– Depot Repair Rate (Labor-Depot) $120.00/Hour
– Network Phone Support (Labor-NetworkPhone)
(15Min Increments) $50.00/Hour
– Travel is billed one way at current rate.
– Overtime rates apply outside of business hours
– Business Hours are Monday-Friday 8:00am to 6:00pm (excluding holidays).

To accept this scope of work, please sign & date below where indicated. Fax the Scope of work document to (503) 555-8547 or by emailing a signed PDF copy to PM@mediorcitconsulting.com. To ensure quick response time, after faxing please call (503) 555-8795×888 and speak to the MediocrIT dispatcher. Reference the above scope of work number and ask to schedule a service call. At the completion of this scope of work you will be asked to sign as to its completion. No additional service call can begin until this scope of work is complete. Please keep original at your location. The onsite technician will pick it up. At the completion of the scope of work, a copy will be attached to your invoice.
By signing below you are agreeing to the terms and conditions listed in the scope of work above. No changes or additions to the scope of work will be accepted after the date that appears below. Additional work MUST be scheduled as a separate service call by executing a Change Order.
Please agree by signing below and faxing to (503) 555-8547 or by emailing a signed PDF copy to PM@mediorcitconsulting.com.

Floor Plans, Cable Runs, and Network Design:

Basic Python: Learning Modules

Here’s the source code for a real basic program that I wrote for my Introduction to Programming class at ITT Tech.

#Michael Jenks
#Introduction to Programming
#This program is designed to calculate the state, county, and total taxes
#based off of monthly sales.
def main():
print ‘Welcome to your Monthly Tax Report Calculator’
print
monthlysales = monthly_sales()
countytax = county_tax()
statetax = state_tax()
totaltax = total_tax(countytax, statetax)
print_info(monthlysales, countytax, statetax, totaltax)
print ‘Thank you for using your Monthly Tax Report Calculator’
def monthly_sales():
monthlysales = input(‘What was your monthly sales in dollars?’)
return monthlysales
def county_tax():
countytax = monthlysales * .02
return countytax
def state_tax():
statetax = montlysales * .04
return statetax
def total_tax(countytax, statetax):
totaltax = statetax + countytax
return totaltax
def print_info(monthlysales, countytax, statetax, totaltax):
print ‘Your stated montly sales were:

, monthlysales

print ‘The County taxes are:

, countytax

print ‘The State taxes are:

, statetax

print ‘The total taxes are:

, totaltax

#Michael Jenks#Introduction to Programming
#This program is designed to calculate the state, county, and total taxes#based off of monthly sales.
def main():    print ‘Welcome to your Monthly Tax Report Calculator’    print    monthlysales = monthly_sales()    countytax = county_tax()    statetax = state_tax()    totaltax = total_tax(countytax, statetax)    print_info(monthlysales, countytax, statetax, totaltax)    print ‘Thank you for using your Monthly Tax Report Calculator’
def monthly_sales():    monthlysales = input(‘What was your monthly sales in dollars?’)    return monthlysales
def county_tax():    countytax = monthlysales * .02    return countytax
def state_tax():    statetax = montlysales * .04    return statetax
def total_tax(countytax, statetax):    totaltax = statetax + countytax    return totaltax
def print_info(monthlysales, countytax, statetax, totaltax):    print ‘Your stated montly sales were:

, monthlysales    print ‘The County taxes are:

, countytax    print ‘The State taxes are:

, statetax    print ‘The total taxes are:

, totaltax

Extra Project: Build your own PC

This was an extra credit project where I was to build a PC that I would use within a $1000 budget. The budget was just for the computer itself and what the exercise was for was picking all the basic components and making sure that everything worked together. This was for my Introduction to PCs class.

The style of computer that I would build at this time would have a very specific use. Since I would like to start my own IT Consulting style business, my thoughts wandered to a home server to learn on and sharpen my teeth. In that frame of mind is how I approached this project and with the intention of actual building this sometime soon. First I will list out the components I chose then discuss why I went with them.

Part Product Price
Processor AMD 955 $160.00
Motherboard ASUS M4A78T-E $115.00
Power Supply COOLMAX CTI-600B 600W ATX12V $50.00
Memory G. Skill Ripjaw 2GB PC12800 DDR3 1600 RAM X4 $220.00
Hard Drive Transcend SSD 32GB with 2.5” to 3.5” adapter $134.00
Seagate Barracuda 1.5TB 3.5” HDD $100.00
Seagate Barracuda 1.5TB 3.5” HDD $85.00
Optical Drive LITE-ON DVD ROM +/-RW, DVD RAM, CD +/-RW 24X $30.00
Case Thermaltake V9 $100.00
Total $994.00

I started my search by looking for a case. I knew that I wanted to make a small server that would host a few things. I was thinking of a website, maybe some email, and some databases related to the business that I want to start. So with that in mind I knew that I would want this home server to be on all the time so cooling would be a huge factor. I started by looking on a site called frozencpus.com for home server cases. These are REALLY expensive so a small jump over the the gaming cases. After a little bit of debating and comparing specifications, the winner was the Thermaltake V9 mid tower. (This was partly due to a combo deal to get a discount on one of the hard drives). This case can take the ATX motherboard that was choosing and provided a good amount of cooling power. With a total of four fans, two 120mm and two 230mm fans should provide ample airflow to dissipate the heat. In addition this case has seven expandable slots. This would allow for some pretty extreme flexibility depending on what circumstances came up in the future of this case. Whether that included cards for eSATA connections, more USB ports, or anything else that can take advantage of those PCI/PCIe slots. Good thing the motherboard that was choosing has a plenty of slots to take advantage of this.

The ASUS M4A78T-E motherboard is one of the ones that was recommended from the AMD website for the CPU that was chosen. This was sufficient as it has enough SATA ports to cover the hard drives and power supply. Being able to support up to 5 SATA connections, 16GB of DDR1333 DIMM RAM, and easily fitting into the case was a great bonus. With the word of mouth and the reviews that I have read about ASUS motherboards helped in my decision, plus it has the new AM3 socket, which is needed for the CPU. The new generation of processors coming out of AMD include a technology called Hyper Transport, which with this board takes the front side bus speed from 2600Mhz to 5200 (MT/s). The Phenom II 955 does such a thing.

The Phenom II quad core 3.2Ghz processor is the brain behind this machine. Keeping in mind that I wanted to host at least one website, an email server, and a database or two I wanted to be sure that the processor itself would slow down under some increased traffic. This processor also contains 4512KB L2 Cache and 6MB of L3 Cache which will help with increased processing demand on this CPU. So far we are starting to gather a lot of power draw, so what kind of power supply was my next question.

After answering the questions on http://www.newegg.com, in their power supply section for, “What power supply do I need?”, I found out that my draw would be around 471 watts. In reading about the Thermaltake case from customer reviews, at least one mentioned getting a power supply that had a fan that faced forward and back, not on the top. This reviewer was mentioning something about how the dust flows, so I took him at his word. I also wanted to be sure to have enough power to power any bus-powered device that might be plugged into the build. 600 watts seemed sufficient and in combination with the fan orientation, meant that my selection would be a bit more limited. Still keeping cost in mind I found my way to the COOLMAX CTI-600B. It is black which goes with the casing color (yay!) and most of the reviews came out at 4 or 5 stars. It has four SATA connectors, which is exactly what I need for this set up, three for the hard drives and one for the DVD RW drive. A 5 year limited warranty on parts and labor doesn’t hurt either!

The drives that will be running this tower is a little bit more complicated. I basically just went with the customer recommended drive from New Egg and it ended up being a Lite-On DVD RW 24X. It is handy that it is a SATA connector for the speed and simplicity of the matter. Now with a server I found out something really important, the system files are super important. The data itself can be replaced fairly easily is a Operating System is still in place. With that in mind I went about designing my hard drive configuration. I wanted a Solid State Drive to house my OS files and knowing that the 30-32GB size was around $100 dollars helped to cement that in place. The case I chose just happen to come as a combo deal with a 1.5TB hard drive and this was a good start for home server storage capacity. Just adding one more of those 1.5TB hard drives brings me up to a total of 3TB of storage outside of my OS. Since the business that I want to run would just be a start up I wouldn’t need the storage capacity of IBM or Google, but 3TB seems like it would hold data for quite some time before an upgrade was needed.

To wrap up the last little bits of hardware before going on to the Operating System will be fairly quick. The 790GX chipset on the motherboard is the same as an ATI Radeon HD3300 and since I won’t be gaming or video editing on this machine that is more than enough. The Via sound card built in can support up to 8 channels, which means if I wanted to stream some internet radio to where I was working on the server I could get surround sound. Once again more than enough for the purpose. And the motherboard has a Gigabit ethernet port, so as far as networking goes for this startup idea, just right. Now the Operating System.

This about taps out the budget that was given, but that was the plan. From the beginning I planned on using a Linux distribution for this home server. All of the main ones come in a 64-bit version, allowing the software to address more than the 3GB limit of a 32-bit OS, and it has no cost in its installation of usage. At least all of the main line server distributions come with pre-compiled packages for what servers I want to host, the set up would be fairly simple. So far I have not found any hardware detection issues with main stream components on using this OS as the community is pretty good about making sure any hardware can run Linux. Specifically, I was going to use Ubuntu Server because I am already familiar with the Ubuntu community and if I wanted to play around with Cloud Computing, this server is set up to work with Amazon’s EC/2 already.

An Operating System Question

This article came from week 3 in my Introduction to PCs course. It was a scenario of upgrading a companies server.

Current Setup

Microsoft Small Business Server 2003

Current Usage

Company webpage hosting, company email, company calendar, customer database, inventory database, company financial information, and point of sale

Reasons to upgrade/change

A quick internet search found many security exploits for this software, there is an increasing cost to maintain this software and soon Microsoft will no longer offer support, the software is just outdated. As technology, business software, and the users move forward, a time comes when the software is just outdated and needs to be updated. Microsoft Operating Systems are famous for crashing constantly, do you remember any time the server crashed?

Proposal

Switch to modern Linux based software. This will bring an increase in security, the software is community built. So rather than a small handful of smart programmers, there is a wide variety of minds working on improving the software. The software based off of the Linux kernel has more stability. Those programmers also collaborate on the core kernel and have had a chance to work out a lot more of the bugs. Most important reason, money. Since this software is considered open source, the cost for the software is $0. In addition no licensing fees need to be paid to the company for permission to use the software. So with lower costs means increased profits.

CPU Block Diagram

This is a block diagram that I made for my Introduction to PCs class at ITT Tech in Portland, OR.

Assignment 1-1 Block Diagram