Thursday, November 19, 2020

[Assignment] [Excel] Internet Speed Test Project

Background Info.

For this project, students will conduct some Internet speed tests to collect data. Students will enter this data into an Excel spreadsheet to organize the data. After all students have entered their data, students will learn how to add important formulas to analyze the data. Students will also learn to create charts and graphs using the data.

Please use the following website to conduct the speed test: Speedtest.net.

Please use this link to access the Internet Speedtest Data Spreadsheet.

Vocabulary PowerPoint.

You will need to perform four Internet speed tests using different servers. The servers used should be as follows:

  1. One in Jacksonville, FL.
  2. One in any U.S. state other than Florida.
  3. One not in the U.S. but in the Western hemisphere (i.e. Canada, Mexico, Central or South America)
  4. One in the Eastern hemisphere (Europe, Asia, Australia, Africa).

The data you will need to record is as follows:

  1. First Name, Last Initial
  2. Class Period. JUST the number, First Period put 1, Second Period put 2, etc.
  3. Date
  4. Time
  5. Your ISP
  6. Server ISP
  7. Server City
  8. Server State (If Applicable)
  9. Server Country
  10. Ping (ms)
  11. Download (Mbps)
  12. Upload (Mbps)

Due Date

You need to complete the four speed tests by Monday, April 13, 2020 at 11:59PM. When you complete your speed tests you need to e-mail me and let me know you finished them.

Completing all four speed tests correctly is worth 20 points.

Tutorial Video