Downloading Google Spreadsheets with a Screenreader

I got an email from someone not too long ago asking for more details on how to download a spreadsheet from Google Docs using a screenreader. (Not going to tell you who it is, since I don't have their permission, but it was someone I really rather admire in the accessibility field. Got all giddy about it and everything, 'cuz I'm just like that.) Thought I'd post it here in case anyone else needs it.

Keep in mind that Google is saying they will have Docs (and the other Edu apps) accessible by Fall 2011, so this may not necessarily be a necessary procedure for long. Also, the nature of webapps being what it is, Google may change everything around in the next 10 minutes and this technique may no longer work. Your mileage may vary, yada yada yada.

Google Docs and Accessibility, Part 4: The Other Stuff

Other Stuff? What Other Stuff?
In the Google Docs app grouping at the time of this writing there are a few other capabilities: Drawings, Collections, and Forms. We're going to tackle all three today.

Google Docs and Accessibility, Part 3: Presentations

Here we are again, looking at the accessibility of Google Apps (the Presentations section, this time) and how it can both be a benefit and a barrier for students with disabilities. This has become quite a hot topic since my last post, as the National Federation of the Blind has filed a complaint with the U.S. Department of Justice regarding the inaccessibility of Google Apps for users with vision impairments. I will leave you (and the DOJ) to make your own judgements about what should happen in this case, but thought I'd mention it as we move along. After all, looking for information on this complaint is how some of you landed here to read this post. Quite a few of you, actually, according to Google Analytics.

Meanwhile, back at the farm...

Google Docs and Accessibility, Part 2: Spreadsheets

Google Spreadsheets has become much more feature-rich since its inception. It is now possible to do many of the things you'd do in Excel - including formulas and charts - with this free webapp. It has many of the same benefits and drawbacks that I highlighted last time about Google Documents. However, Spreadsheets does have some of its own unique benefits and barriers.

Google Docs and Accessibility, Part 1: Documents

Here's the dealio. Google Docs, at this point, incorporates word processing documents, spreadsheets, presentations, forms, and drawings. It's a big chunk 'o stuff, and frankly, I doubt anyone's got the patience to read through a blog post that covers the accessibility of them all. Today's post will tackle just Documents, the word processing portion of Google Docs. I'll get to the others in turn. (If you have a burning desire to hear about one of them next, just drop me a note in the comments!)

Keep It All Organized with Google Calendar

Last week, I posted about the benefits and barriers of Gmail for students with disabilities. This week's topic is Google Calendar- a webapp I love, love, love. Once again, we'll be taking a look at the ways that Google Calendar can make life easier for students with disabilities, as well as some of the need-to-know accessibility info.

The Disability Skinny on SOU's Gmail Switchover

In December, SOU switched student email accounts from NetMail to Gmail. Hopefully, this is not news to you, dear student, what with the news broadcasts and on big honkin' banners on campus.

The switch affects more than just which email service you use, however. SOU students now have a huge number of tools and resources in the Google Apps for EDU umbrella, including Gmail, Google Calendar, Google Docs, and Google Talk. Personally, I'm thrilled about this development. GoogleApps gives us opportunities to work, organize, study, and communicate in ways we couldn't even begin to do with our older systems. I'm eagerly awaiting the faculty/staff switchover during spring break.

Every change brings both new opportunities and new challenges for people - with and without disabilities. Over a series of blog posts, we'll be taking a look at the opportunities and challenges that GoogleApps present for students with disabilities. Today, we start with Gmail, Google's flagship app.

Making the Switch

There are oodles of great guides to using Gmail out there, so I'm not going to duplicate them. Instead, I'll point you to:

• the GAapps SOU page for some handy how-to-switch and how-to-use resources
• some helpful guidance on using Gmail as a universal inbox
• the Lifehacker guide to controlling your email
• Google's Top 10 Reasons to Use Gmail

For some of you, being able to use the keyboard to access Gmail's functions is critical; for others, it's just darn handy. There is a list of keyboard shortcuts from Gmail help, but I really like the way that HTS Tech Tips' keyboard shortcut list is organized.

The Bottom Line: Gmail Accessibility

Let's face it, nothing has perfect accessibility for all users, and Gmail is no exception. Fortunately, Google employs accessibility rockstar T.V. Ramen, so there is actually some thought put into it! If you're interested (and a little geeky), check out Google's statement about Gmail accessibility. I'm going to hit the highlights here of accessibility barriers and any recommended workarounds.

• AJAX scripting and screenreaders: Some of Gmail's advanced features require scripts that throw screenreaders in a bit of a tizzy. Workarounds: use the plain HTML view, learn to use the standard view with a screenreader, or use a familiar email program to retrieve your email (MS Outlook, for example)
• Color contrast and glare issues: For some students, the white page background creates reading difficulties, and for others, color contrasts need to be set in certain ways to allow students to read the material. Workarounds: Gmail has great customizability. Use Themes to control how Gmail appears and make it easy to read.
  

Unique Ways GMail Benefits Students with Disabilities

• The aforementioned keyboard shortcuts
  
• Simplify your inbox and reduce email clutter - use filters
• Highlight those messages you really need to see! - use labels. You might, for example, create a bright red label with a star for anything from Financial Aid or Disability Resources. Just a thought, y'know.
• Conversation view also reduces email clutter and makes following what's happened so far much, much easier. This is the default view, so you don't need to do anything to make it happen. Follow the link to find out how to turn it off and see individual emails all by their lonesomes again.
• Auto-saving as you write emails means that what you've written will never disappear with a power surge or outage!
  

Gmail Settings & Labs for Accessibility

Settings, like in every other program, allow you to customize how Gmail works. Gmail Labs are experimental features that you can add on without waiting for program updates. I'll highlight some here that have particular interest for students with disabilities.

Settings

• Number of conversations per page: Set this at a low number (25) if you get overwhelmed by the amount of info on a page or scrolling is difficult. Set it at a higher number (50 or 100) if mobility or dexterity impairments make loading another page cumbersome.
• Keyboard shortcuts - sayin' it again! This is where you actually set to allow them.
• Undo send: Do you tend to send without really thinking it through, or without actually attaching the attachment? Enable this to allow you to pull a sent message back if you do it quickly

Labs

• Google Calendar gadget: I'll be discussing the neato-keen benefits of Google Calendar in the next post. Adding this lab puts a small calendar right into your email page, so you always know what's coming up.
• Auto-advance: brings up the next email after you archive, delete, or mute one. Saves a couple of clicks
• Custom keyboard shortcuts: (gahhh, am I bringing up keyboard shortcuts again??) If you find that Google's pre-assigned shortcuts interfere with other assistive tech you've got installed, change the shortcuts to ones that don't cause problems

Stay tuned for the next post, which will give you all you need to know about Google Calendar. In the meantime, if you have questions you'd like answered or features I've missed, please hit up the comments.

Are You My Tweep?

There was a cell phone company that, not long ago, had a commercial that gave stats on how many people were tweeting right now, then followed it with the number of people who had no idea what tweeting was. At first glance, Twitter seems rather self-promoting. You throw 140 characters of what you're thinking out into the world. However, there are great reasons for students to use Twitter; most of which have already been covered in other venues. Here's a few:

• College Student's Guide: Twitter 101
• 25 Twitter Tips for College Students
• Twitter for Academia

Accessible Twitter Applications

The Twitter website itself has some accessibility issues. But don't despair! There are alternate ways to access Twitter. Here's a few accessible ways to do so:

• Accessible Twitter is a website alternate for the Twitter website, but ensures accessibility
• Qwitter is a Twitter client designed for blind and low vision users, compatible with screenreaders
• Tweets60 is an accessible version for the Nokia S60 smartphone

You can follow Disability Resources on Twitter at @EqualAccessSOU.

Accessible Surveys from Survey Monkey?! Really!

Woohoo! Survey Monkey recently announced that they have made their web survey templates compliant with Section 508.

Why is this such a big deal? Well, most survey tools are not designed for accessibility for people using assistive technology. In fact, most make it darn difficult to complete a survey using AT, especially using screenreaders. By actually gaining 3rd-party certification of their compliance (from RampWEB Accessibility Consulting group), Survey Monkey has demonstrated a commitment to hear from everyone, not just people without disabilities.

Again, woohoo! And thanks to Sean Keegan and Jayme Johnson from HTCTU for the heads-up.

This means, my friends, you have no excuse for ignoring those survey invites in your student email from Student Affairs and other groups on campus that really do want to hear from you. You now have access to a voice and a vote as to what happens on campus. Don't let them pass you by!