Google
 

Tuesday, October 27, 2015

9 Google Apps Productivity Tools & Tips for Teachers

The one thing that every teacher wants more of, besides salary, is time. I can't give you more time in the day. What I can do is point you to some tools and techniques for completing routine tasks more efficiently.

Email:
Auto Text Expander for Google Chrome is a convenient Chrome extension that I've recently started using. The extension enables me to create keyboard shortcuts for words and phrases that I frequently use in emails. In the video embedded below I provide a short overview of how this helpful Chrome extension works.


Add Reminders is a Google Sheets add-on that enables you to send emails from a spreadsheet. The add-on will format your spreadsheet so that you simply enter reminder messages and email addresses then specify a date on which you want your reminders sent. The Add Reminders Add-on allows you to send the same reminder to everyone in your email list or you can send individualized reminders to everyone in your email list. In the video embedded below I demonstrate how to use the Add Reminders Google Sheets Add-on.


The Add Reminders add-on for Google Sheets is great if you just need to send reminder emails. However, ff you want to create custom, personalized emails then you're going to need a slightly different spreadsheet script. Doing this requires adding a script to a Google Spreadsheet containing email addresses. It might sound complicated, but it really isn't. Watch the short video below from the Google Developers team to learn the process.



When you receive a document that needs to be signed, you don't need to print it if you use Hello Sign. Hello Sign offers a Google Drive app. You can also use it without integrating it into your Google Drive account. Learn more about Hello Sign in the video below.


Grading:
Flubaroo is a popular Google Sheets Add-on that enables me to grade all at once all of my students' responses to a quiz created in Google Forms. The autograde option in Flubaroo allows you to have students automatically receive their scores after submitting their responses to a quiz you created in Google Forms. The autograde feature will send students an email with their scores and the answer key (you can exclude the answer key). With autograding enabled students do not have to wait for you to run the grading process or wait for you to send emails. You can also print grades from Flubaroo and or save them as a PDF.

Online Rubric is a Google Spreadsheets Add-on that enables to you create rubrics, enter scores, and email scores to students all from one place. Online Rubric provides very clear instructions for each step of the processes of creating a roster sheet, creating a rubric, and emailing grades to students. The video below provides a demonstration of how to use the Online Rubric Add-on.


Doctopus is a Google Spreadsheet Add-on that can help teachers manage the flow of shared work in in their Google Drive accounts. The basic concept behind the Add-on is to enable teachers to quickly share documents with all of the students on a roster, monitor usage of shared documents, and give students feedback within that roster spreadsheet. When Google launched Google Classroom it seemed that Doctopus might become redundant, but that has not exactly become the case as Justin Brink demonstrates in the videos embedded below.



Scheduling:
Lab Scheduler is a neat Google Sheets Add-on that enables you to easily create and maintain a lab or room reservation system for your school. It is designed for schools that use a labeled block schedule (for example, the high school in my district uses "period 1" through "period 8" even though there are only four periods in a given day). Once you have added Lab Scheduler to your Google Spreadsheet it will walk you through the process of creating blocks of time and lab/room space in your spreadsheet. You can set your Lab Scheduler to maintain a preview of as many dates as you like. The preview is what people will see when they want to make a reservation. Share the spreadsheet with your staff and they can reserve a block of time in it.

YouCanBook.Me is a meeting scheduling tool that integrates with your Google Calendar and is easier to use than the appointment slots feature in Google Apps for Education calendars. YouCanBook.Me allows people to book fixed blocks of time in your calendar. You identify the times in your calendar that you are available to meet. Then when someone needs to schedule a meeting with you, you send him or her a link to your booking calendar. Visitors to your calendar click a block and enter their email addresses to reserve a block of your time. When a block of time is reserved you receive an email alert and the other person receives a confirmation email.