Google Sheets course

Sheets Lesson 10

Final Accessible Sheets Workplace Tracker

First-time setup and success checks

Lesson goal in plain language: Create an accessible shared-work tracker using fictional data, formulas, documentation, and safe permissions.

Prepare before step 1

  1. Open the correct application, website, or device screen and wait for its name to be announced.
  2. Open Sheets manual and review the matching procedure if any command or term is unfamiliar.
  3. Use only fictional, public, disposable, or instructor-provided practice information. Make a copy before changing an important file.
  4. Read all numbered instructions once before performing them so you know the intended final result.

Commands used or referenced

Tab, Shift+Tab, Insert+Tab,, NVDA+Tab,

For a plus-sign command, hold the modifier key, press and release the final key, then release the modifier. For a sequence, press and release each key in order. Stop after every command and listen for the result.

Work and verify

  1. Perform one numbered instruction and stop. Identify the active window, focused control, selected item, cell, slide, message, field, or device area before continuing.
  2. Compare the result with the lesson goal. A sound alone is not enough; verify the name, state, value, location, permission, or content.
  3. If the result is wrong, press Escape once to leave an unexpected menu, identify focus again, and use Undo only when the change is safely reversible.
  4. Save or synchronize at natural stopping points. Confirm the filename and location before closing.
  5. Complete the “Before submitting” checklist from top to bottom. Correct missing items before marking the lesson complete.
  6. Close and reopen the practice item, or return to it from the product’s main screen, to prove you can locate and verify the result independently.

Success standard: Explain what each major command did, show the finished result, and recover from one harmless focus or navigation error without another person naming the next key.

Goal

Create an accessible shared-work tracker using fictional data, formulas, documentation, and safe permissions.

Prepare safely

Step-by-step instructions

  1. Read the Google Sheets manual sections on accessibility, screen readers, file formats, and compatibility.
  2. Open Google Sheets and confirm the window title or browser tab, active file, and current account when applicable.
  3. Navigate the main controls using only the keyboard. Record the labels announced by JAWS, Narrator, or NVDA.
  4. Create an accessible shared-work tracker using fictional data, formulas, documentation, and safe permissions.
  5. Save frequently in the program’s preferred editable format. If working in a browser, confirm that changes are saved before closing.
  6. Review the work from the beginning using keyboard and screen-reader navigation. Correct unclear structure, labels, or data.
  7. Create a separate Microsoft-compatible or requested exchange copy. Do not overwrite the editable original.
  8. Open or re-import the exchange copy when possible and compare content, formatting, formulas, notes, links, and accessibility.
  9. Write a short compatibility report naming anything that changed and how it was corrected.
  10. Save the submission using the filename sheets-Lesson-10.xlsx.

Screen-reader help: Use Tab and Shift+Tab for controls and listen to the current accessible name. JAWS users can use Insert+Tab, NVDA users NVDA+Tab, and Narrator users Scan Mode commands when appropriate. Application and web-editor commands may differ after updates.

Your assignment

Create an accessible shared-work tracker using fictional data, formulas, documentation, and safe permissions.

Include the finished work and a brief accessibility and compatibility review. Save it as sheets-Lesson-10.xlsx.

Before submitting

Ready for the final quiz?

After reviewing all ten lessons, take the Google Sheets final quiz. Score 80 percent or higher to create a printable completion certificate.