[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

[Daily Agenda] Tuesday, November 10, 2020

Clock-In PIN

11001011

Topic

E-Mail

Standards

1. 7.0 Use technology to enhance communication skills utilizing electronic mail.

Essential Questions

1. What are some of the advantages and disadvantages of using e-mail?
2. What is the domain for DCPS student e-mail addresses?
3. What will you do today to be better than you were yesterday?

Mise En Place [~3-5 Minutes]

Every day you should:

1. Login to DCPS OneView.
2. Read your DCPS e-mail.
3. Login to Teams, even if face-to-face.
4. Open your Standards Excel spreadsheet.
5. Follow any additional instructions from the teacher.

Instruction [~10-15 Minutes]

Students will discuss how to create automatic replies in Outlook as well as creating calendar invites.

Work [~30-45 Minutes]

Break Down [~5 Minutes]

Before you leave please do the following::

1. BACKUP your data in at least two locations.
2. RESTART the computer.
3. TURN OFF the monitor.
4. COLLECT your materials.
5. WAIT quietly to be dismissed.
6. PUSH in your chair when you leave.
7. THROW away any trash in the trashcan as you leave.

Homework

Finish any class work not completed during the period.

Read for fun, at least 20 minutes.

[Daily Agenda] Wednesday, November 04, 2020

Clock-In PIN

11000101

Topic

E-Mail

Standards

1. 7.0 Use technology to enhance communication skills utilizing electronic mail.

Essential Questions

1. What are some of the advantages and disadvantages of using e-mail?
2. What is the domain for DCPS student e-mail addresses?
3. What will you do today to be better than you were yesterday?

Mise En Place [~3-5 Minutes]

Every day you should:

1. Login to DCPS OneView.
2. Read your DCPS e-mail.
3. Login to Teams, even if face-to-face.
4. Open your Standards Excel spreadsheet.
5. Follow any additional instructions from the teacher.

Instruction [~10-15 Minutes]

Students will need to complete the following activities in Unit 7: Business E-mail and Personal Information Management.

1. Read "Page 84": Introduction to Business E-mail
1. Make sure to watch the Lesson 7: Business E-mail and Personal Information Management video.
2. Read "Page 85" How E-Mail Works
1. Create a PowerPoint for each of the following terms. Include the definition and a picture relevant to the term. Save your file as lastname_firstname_email_vocab.
   • Simple Mail Transfer Protocol
   • MTA
   • MDA
   • POP3
   • IMAP
   • Username
   • Domain
   • Browser E-mail
   • Web-based E-mail
   • MIME
   • Secure MIME
   • Pretty Good Privacy (PGP)
   • GNU Privacy Guard
3. Complete Exercise 7-1: Mail User Agents
4. Complete Exericse 7-2: E-mail Encryption

Work [~30-45 Minutes]

If you have not completed the Sugar Skull project please use the following play list to do so.

Break Down [~5 Minutes]

Before you leave please do the following::

1. BACKUP your data in at least two locations.
2. RESTART the computer.
3. TURN OFF the monitor.
4. COLLECT your materials.
5. WAIT quietly to be dismissed.
6. PUSH in your chair when you leave.
7. THROW away any trash in the trashcan as you leave.

Homework

Finish any class work not completed during the period.

Read for fun, at least 20 minutes.

[Digital Art] [Enrichment] Photoshop Battle #00: Athletes with Instruments

The image above was the inspiration for this project idea. It is a funny picture that also requires significant photo editing skills. For this project you need to:

• Find a picture of at least one athlete competing in a game or match. Save it to your computer and / or USB drive.
• Find a picture of one or more musical instruments. Save those pictures to your computer and / or USB drive.
• Use Paint.net or GNU Image Manipulation Project Portable to create an image showing the athletes playing the instruments.
  • In-class examples will use Paint.net for demonstration purposes.

Content Rubric

• FIRST NAME and LAST INITIAL only in BOTTOM RIGHT CORNER. [5 Points]
• Must show at least one athlete playing instrument in a match / game. [2.5 Points]
• Must show athlete holding/playing/actually touching the instrument!
• Any equipment [bats, hockey sticks, basketballs, etc.] REMOVED from picture. [2.5 Points]
• Helmets, jerseys, and other articles of clothing do not need to be edited out of the picture.
• Image demonstrates investment of time and effort. [10 Points]

Process Rubric

• File name is lastname_firstname_photoshopbattle00 [5 Points]
• File format is .png or .jpg or .gif [5 Points]
• Create a compressed folder that contains
  1. The original pictures you downloaded.
  2. The picture you created.
• Due Date: Submitted to Focus by 11/09/2020 at 11:59PM. [20 Points]
• Past-Due: November 16, 2020 at 3:00PM.

Tutorial Video

Teacher Example

Before

PLUS

EQUALS

[Daily Agenda] Monday, November 02, 2020

Clock-In PIN

11011001

Topic

E-Mail

Standards

1. 7.0 Use technology to enhance communication skills utilizing electronic mail.

Essential Questions

1. What are some of the advantages and disadvantages of using e-mail?
2. What is the domain for DCPS student e-mail addresses?
3. What will you do today to be better than you were yesterday?

Mise En Place [~3-5 Minutes]

Every day you should:

1. Login to DCPS OneView.
2. Read your DCPS e-mail.
3. Login to Teams, even if face-to-face.
4. Open your Standards Excel spreadsheet.
5. Follow any additional instructions from the teacher.

Instruction [~10-15 Minutes]

Students will need to complete the following activities in Unit 7: Business E-mail and Personal Information Management.

1. Read "Page 84": Introduction to Business E-mail
1. Make sure to watch the Lesson 7: Business E-mail and Personal Information Management video.
2. Read "Page 85" How E-Mail Works
1. Create a PowerPoint for each of the following terms. Include the definition and a picture relevant to the term.
   • Simple Mail Transfer Protocol
   • MTA
   • MDA
   • POP3
   • IMAP
   • Username
   • Domain
   • Browser E-mail
   • Web-based E-mail
   • MIME
   • Secure MIME
   • Pretty Good Privacy (PGP)
   • GNU Privacy Guard
3. Complete Exercise 7-1: Mail User Agents
4. Complete Exericse 7-2: E-mail Encryption

Work [~30-45 Minutes]

If you have not completed the Sugar Skull project please use the following play list to do so.

Break Down [~5 Minutes]

Before you leave please do the following::

1. BACKUP your data in at least two locations.
2. RESTART the computer.
3. TURN OFF the monitor.
4. COLLECT your materials.
5. WAIT quietly to be dismissed.
6. PUSH in your chair when you leave.
7. THROW away any trash in the trashcan as you leave.

Homework

Finish any class work not completed during the period.

Read for fun, at least 20 minutes.