Lab Work to Turn in:
STEP ONE: Select 2 universities from each time zone (Eastern Time zone, Mountain Time zone, Central Time zone and Pacific Time zone), and 2 universities from Asia. Ping each of the 10 universities’ website 10 times by using ping –n 10 “destination”. Destination is the Web URL of the university. Use tracert to find the number of hops. Use any Distance Finder to calculate the distance between your city to the destination.
STEP TWO: Open the given Excel file “ITM 332 Project One Data File” and use Save As to rename it to “YourLastName_First_Initial_P_1” as your Lab One file.
STEP THREE: Record your findings for all 10 universities to your Lab One file. When one PING or TRACERT returns “Time Out …”, just try another one. There are many university/college which are able to be PING/TRACERT.
STEP FOUR: Check if you got the data from 10 universities as required. Be sure the unit of distance in miles (1.6 km equals 1 mile). Then Sort the data ascending by the average time.
STEP FIVE: Draw one Excel chart with two lines: one line the average time and the other line is the number of hops for all the 10 universities. The x-axis of the chart is the 10 universities. The chart must have two y-axis, one is the Average Time and the second is the number of hops. Use different mark for the two lines. Place the chart following the data on the left side
STEP SIX: Draw another Excel chart with two lines: one line the average time and the other line is the number of distance for all the 10 universities. Set this chart same thing as the one in Step Four. Place the chart following the data on the right side
STEP SEVEN: Insert a textbox bellow the charts to type your comment about this lab project, the data you collected, the chars and your finding as following:
- Is the average round-trip time related to the number of hops?
- Is the average round-trip time related to the distance?
- Is the Loss Rate related to number of hops and/or the distance?
- What did learn from the lab? What is the good of the lab?
- Which part needs to be change/modify?
- What else you think it is better to add to this lab?
- Any other words you want to share with me about this lab.
Create a Footer for your lab Excel file. Enter the current semester/year on the left section, your FULL name in the middle, and the city, state, and zip code you completed the lab on the right section.