Week 5 · Answer and observation guide

Part 1 · Microsoft Excel: Make a sheet that makes sense without color

Goal 1 (post-test item 18): Make a sheet that still makes sense without color: add words next to the color, and know that charts need labels or patterns too.

Evidence: Color: in Excel, each learner types a sign-in sheet with four fictional names, colors the Done cells green and red with Fill Color, adds the words Complete and Not yet so the sheet makes sense without color, and saves Sign-in sheet in Documents. They can say that a chart needs labels or patterns for the same reason.

Check: A chart shows two stores as blue and orange bars. In gray they look alike. What fixes it? Label each bar, or give one store stripes. Labels or patterns carry the meaning when color cannot.

Common problems

• Cannot find the arrow next to Fill Color? It is a tiny triangle right beside the paint bucket on the Home tab.
• Painted the wrong cells? Press Ctrl and Z to undo, then select the right cells and try again.
• A box asks you to sign in? Close it with the X. You do not need an account tonight.

Part 2 · Microsoft Edge: Secure a new account

Goal 2 (post-test item 19): Secure a new account with a long password used nowhere else, and turn on two-step verification.

Evidence: Account: on the practice sign-up page, each learner enters a made-up example.com email, sees a short password refused, enters the long practice passphrase, sees it accepted with the reminder to use it nowhere else, chooses a text code, types the code from the drawn phone, and reads Two-step verification is on.

Check: A friend uses her long email password for her new bank login. What is wrong with that? One lost password opens both accounts. One lost password can open every account that shares it.

Check: What does two-step verification add to your password? A second lock: a code sent to your phone. After the password, the site asks for a code that only your phone receives.

Common problems

• Cannot find the gold button? Click the Week 5 · Worksheet tab, then roll the mouse wheel toward you until you see Part 2.
• The page says the email is not allowed? Practice pages only take emails that end in @example.com.
• The page keeps saying the password is too short? It needs 12 or more characters. Type the four practice words with a space between each.

Part 3 · Practice Mail: Check a message that rushes you

Goal 3 (post-test item 20): Check a suspicious message or caller a safer way: spot the pressure, read where a link really goes, and verify through a route you already trust.

Evidence: Message: in Practice Mail, each learner opens the Week 5 message, finds the pressure words, points at the link without clicking and reads where it really goes, compares the message’s phone number with the number on the letter, reports the message, and writes a safer route on the worksheet.

Check: An email says: pay in 30 minutes or lose power. What is the safest first move? Do not click. Call the number on your paper bill. A number you already had is a trusted route. The email is not.

Check: A caller wants the code just texted to you, right now. What do you do? Hang up. Call the number on your bill. Asking for a code is a warning sign. Use the number on your bill.

Common problems

• Cannot find the gold button? Click the Week 5 · Worksheet tab, then roll the mouse wheel toward you until you see Part 3.
• Clicked the link by mistake? Nothing happened. Practice Mail shows a warning and stays on the page. In real life, close the page and tell someone.
• Cannot see the address at the bottom left? Hold the pointer still on the blue words for a second. Practice Mail also writes it under the link.

End-of-class check

• your Excel sign-in sheet with the words Complete and Not yet
• the practice sign-up page saying Two-step verification is on
• your reported Practice Mail message
• your My result page, every box filled in

Record Independent, With prompt or Needs practice for each. Re-show only the missing step.

My result page

• The words I added so my sign-in sheet does not need color
• My rule for a password: how long it is, and where I use it
• Two-step verification: is it on? What did the page say?
• The pressure words I found in the message
• Where the link in the message really went
• My trusted route for checking a message or a caller
• One habit I will use

Collect the page, or read it on screen. Every box should hold the learner's own words.