Google Docs fascinated me in our last cohort class when we created a Powerpoint/Keynote using the Google Presentation. For my last technology skill, I explored Google Forms, and for my new skill, I wanted to learn how to use the Spreadsheet tool. One of the best features of the spreadsheet is the ability to have students edit the document without having to login to anything. The secret is in how the document is shared. After selecting “Share with the World,” choose the option “Let people edit without signing in.” Then copy and paste the URL onto your class web site, Quia page, or HCPS Link page for students to follow. It’s that easy.
Since I am English teacher, I use spreadsheets as a way to quickly organize and sort information rather than to perform calculations. It’s a great tool for word sorts. My students really enjoyed using the spreadsheet, but a few words of caution: be prepared for students to accidentally delete a portion of the spreadsheet. I had that happen at least once in every block. Also, there is a chat feature that enables students who are viewing the same spreadsheet to instant message. This is a great for collaboration, but some students are more excited about chatting than focusing on the task at hand. As long as I had a copy of the spreadsheet open on my screen, I could monitor the chat and gently prod a few students back to work. When they realized I could see what they were typing, they were quick to refocus.
