Thursday, June 27, 2013
Three Google Sheets Scripts That Help Teachers Save Time
Flubaroo is an easy-to-use script that will grade multiple choice quizzes for you. You can even set-up the script to email all of your students their grades with just one click. Complete directions for using Flubaroo can be found here.
gClassFolders is a script that will create folders for you for as many course sections as you need. The concept behind it is this; students have a "dropbox" folder in their Google Drive accounts that you have shared with them. To submit work students drag files into that "dropbox" folder. From there gClassFolders sorts submissions to the correct folder for each student. You can find complete directions for gClassFolders here.
Doctopus is a Google Spreadsheet script that can help teachers manage the flow of shared work in in their Google Drive accounts. The basic concept behind the script 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. Find directions for Doctopus here or watch the videos embedded below.