Top 10 Google Apps Scripts for Education

Posted by
Today's guest blog post is contributed by Andrew Stillman, he is a 15-year veteran STEM and outdoor educator and Senior Systems Developer at New Visions for Public Schools, where he supports 76 NYC secondary schools in the use of Google Apps for Education and other sustainable technologies.  His goal is to foster efficient, high-capacity urban schools through the development of automation and system-building tools that allow educators to solve their own systems and workflow challenges.  Andrew is also the author and collaborator of numerous popular Google Apps Scripts for educators that are featured in this post.  

Google Apps Scripts are an invaluable tool that enable educators to extend and automate functionality inside of Google Apps for Education. We will explain how the top 10 Google Apps Scripts for Education can enhance teacher workflow and student learning experience. 

Top 10 Google Apps Scripts for Education

1. Doctopus is a document management script for student projects in Google Docs. Written by an educator for educators, the free Doctopus script gives educators the ability to auto-generate, pre-share, and manage grading and feedback on templated Docs for group and individual projects.

2. Flubaroo by Dave Abouav is a free script that helps you quickly grade multiple-choice or fill-in-blank assignments automatically using Google Forms. This script was also written by an educator for other educators and in addition to automatically grading, Flubaroo also computes average assignment score, computes average score per question, and flags low-scoring questions. It can show you a grade distribution graph and gives you the option to email each student their grade, and an answer key.

3. autoCrat is a script that was written to be a multi-purpose document merge tool that allows you to take any personalized, row-based spreadsheet data and create, save, attach to email, and share templated documents. No scripting ability required to use.  It can be used in the classroom to automatically create individualized feedback for students.

4. gClassFolders by Bjorn Behrendt is a free, Google-Spreadsheet-based add-on for Google Apps for Education that creates class folders for students and educators to simplify and streamline their experience of using Google's world class productivity and collaboration tools in the classroom. It has the ability to run in "Single Teacher Mode" or "School Mode" - school mode anticipates use over multiple semesters and at the scale of many classrooms. It also has the ability to add students and classes over time without recreating all folders, and features an internationalized interface that runs in over 70 languages.

5. gClassHub is a gallery of scripts that allows any teacher running gClassFolders to instantly launch spreadsheets containing useful scripts like Doctopus and autoCrat. When installed via gClassHub, the scripts are pre-populated with student roster and student assignment folder IDs! 

6. formMule is script that is useful for automating lookups, emails and calendar events created dynamically from Google Forms. Using formMule educators can automate targeted emails and calendar appointments to loop in the right people around regular occurrences such as behavior incidents, absences at attendance and at after-school tutoring.

7. formEmailer by Henrique Abreu allows you to easily set up flexible e-mail merge in your spreadsheets and automatic emailing to your forms. The best part is that you need NO javascript knowledge, and everything is set up in a simple interface. Educators can use this script to automatically personalize emails to all the students in their classes.

8. formRanger is a script that allows you to automatically populate the options in any multiple-choice, checkbox, or listbox style question in a Google Form from any column in the attached spreadsheet. 

9. formLimiter is a script that easily allows you to restrict the number of responses, set a time limit, or evaluate a cell value to automatically stop accepting responses on a Google Form. For educators who are teaching students through Google Forms, this tool can be great for setting deadlines on quizzes and tests.

10. docAppender is a script that allows to take data submitted through a Google Form to add content to the end of a user-selected Google Document. This is especially useful for logging meeting takeaways or keeping running records on faculty or student files. Very mobile friendly, as all usage involves URLs that can be loaded in a smartphone or tablet.

Synergyse is on a mission to teach the world how to use Google Apps, providing interactive in-application training for schools around the world running Google Apps for Education. If you know any other useful Google Apps Scripts for Education please let us know in the comments!
Synergyse provides a revolutionary e-learning system for Google Apps™, click above to find out how we can help your organization.