Published using Google Docs
Sheets AFB TTT 2016 (External)
Updated automatically every 5 minutes

Google Sheets Material

Outline and Exercises

AFB and Google Train the Trainer workshop

December 2016

You are welcome to link to and use this material.  Since it might be updated in the future, it is best to point to this page rather than copy the material.

 

Introduction

With Google Sheets you can handle task lists, create project plans, analyze data with charts and filters, and much more. You can create and edit spreadsheets right in your web browser—no special software is required. Even better, multiple people can work at the same time, you can see people’s changes as they make them, and every change is saved automatically.

 

Sheets is a web application (as well as Docs and Slides).  As such, the interaction model is more like a desktop application than a flat web page.  Docs, Sheets and Slides all have an application menu, context menu, toolbars and edit area.

 

The screen reader should automatically enter application mode when you open a Doc, Sheet or Presentation.  If it does not, turn off virtual cursor if using JAWS or switch to focus mode if using NVDA.  The screen reader should remain in application mode when working on the content, accessing the menus or accessing the tool bars.  When a dialog is opened (e.g. sharing), The screen reader can remain in application/forms mode.  However, to access some info in the dialogs, you may wish to turn virtual cursor on if using JAWS or switch to browse mode if using NVDA.

 

For more information on how to use Google Sheets , including a one-time setup step, check out the getting started resources listed below:

 

Exercises

Note that these exercises are based on usage of an account that has been setup for the AFB train the trainer workshop.

 

Exercise 1 - Enter Basic Data and Formula

  1. Create a Google Sheets file in the exercises folder.
  2. Create an Order sheet with:
  1. Enter about 3 rows of data.
  2. Enter a formula to sum the quantities, and totals.

Hints:

 

Exercise 2 - Multiple Sheets

  1. Rename the first sheet as Order 1.
  2. Create new sheet and rename it to Order 2.
  3. Copy the content from Order 1 into Order 2.
  4. Change a few items in Order 2 so quantity and totals are different.
  5. Add a new sheet and call it Orders.
  6. In Orders sheet, add three rows with two columns:

Hints:

 

Exercise 3 - Formatting

  1. Change the column headers to be bold.
  2. Change the order total to be dollar formatted.

Hints:

 

Exercise 4 - Work with Columns and Rows

  1. Turn on always read row and column titles.
  2. Move around the sheet and notice the titles being announced.
  3. Turn off title announcements
  4. Move to the last cell with content in the sheet.
  5. Use the shortcuts to read the column and row.
  6. Insert multiple rows and add content to those rows (e.g. copy and paste).
  7. Analyze the quantity column.
  8. Sort based on unit cost.
  9. Undo sort.

Hints:

 

Exercise 5 - Collaborators

  1. Partner up with a person sitting next to you.
  2. Both of you open the same document.
  3. Move around in the file and notice the collaborator announcements.
  4. Turn off collaborator announcements.
  5. Review who has the file open.

Hints:

Exercise 6 - Share a File

  1. Use the share item in the file menu to Share your file with user: a11ytrainer1@gmail.com and the person to your right.
  2. Unshare the file with a11y.trainer1

Hints:

 

Exercise 7 - Comments

  1. Add several comments in the document.
  2. Move to next/previous comments.
  3. Read existing comments.
  4. +Tag your partner with in a comment.

Hints: