TCEA 2014 Google Academy

I attended the Google Academy at TCEA 2014 in Austin a few weeks back, and created thebelow to share the many resouces I gained. Through all of the resources, one session stood out in my mind. That is a session about scripts that can be inserted into spreadsheets. I had added scripts to spreadsheets before but found new scripts that will assist teachers in their communication with students. 

Here are just a few of my favorite scripts:

• FormEmailer - Script- This script allows you to send out emails that you have gathered through a form. How to video.
• gClassFolders - This script sets up folders for each of your students/classes. You can drop files into it that the students can edit or view. It will also set up a individual student folder where they will share documents directly with the teacher. More Info.
• Doctopus - This script sends out documents to students as individuals, in groups, or one document shared by the entire class. The teacher can even turn off editing rights when the assignment is due and send messages to the students. With Doctopus, teachers can use the script Goobric, which is a rubric, and can be found in the assessment section. More info.
• Goobric - script attaches a rubric created in google forms to a document that you sent to students with Doctopus. It allows you to grade the assignment and it will then attach the rubric to the document and send an email with the rubric to the student. More Info.
• autoCrat - This script allows you to complete a mail merge and produce either PDFs or google docs which can be editable or viewed only. These documents are emailed to the recipient, and can be placed in their google drive. More Info.