Google Apps Script

Problem: There isn't a shortage of assessment & gradebook tools/platforms these days & too often the enterprise systems are complex and too intimidating for teachers to adopt on their own (they also cost money!).
Abstract: This is an attempt to create a simple tool that a team of teachers could use to track indicator-level data on shared assessments. It's low-stakes, hopefully approachable and can be customized to fit the team's needs.
Recommended by 14 educator(s)
Problem: Learning how to set goals and become accountable for them is critical to college readiness. With a class of 30 students, this can be a daunting task to setup and then monitor.
Abstract: Using a script stolen from another project and a student template, this platform will allow a teacher to enter in their classroom roster, hit a button and automatically create goal setting sheets for their class and monitor their students' progress!
Recommended by 9 educator(s)
Problem: Creating google templates, instructing students to share appropriately and then organizing all the shared files correctly can be a time-consuming task.
Abstract: This is a simple script housed in a google sheet that allows teachers to create handouts for their classroom, shares the student appropriately and organizes the handouts in a collection. It can be used to create sheets as well as docs.
Recommended by 19 educator(s)
Problem: How can you efficiently allow for users to sign up for events with limited seats, time slots, resources, potluck items, etc. without opening up a spreadsheet for the world to edit?
Abstract: This hack provides starter templates for a pair of Google Docs worksheets (one private, one public) that can then be connected using (included) Apps scripts to encourage users to submit Google forms only for open time slots or resources. Test.
Recommended by 16 educator(s)
Problem: Many schools are rife with inefficient operational processes, poor internal communications systems, and relative data-blindness. These persistent issues prevent many otherwise talented teams from truly taking flight. How can school-level staff create clean, cheap, and easy-to-use data capture, reporting, and operations systems that are flexible enough to evolve with the dynamic needs of an innovative school?
Abstract: This introductory module provides what you need to start building the modular and lightweight data system of your dreams. The first installment is a "Lateness Zapper" that automates logging, communications, and reporting on student lateness.
Recommended by 23 educator(s)
Problem: Visualizations of student progress are notoriously poor in many online learning platforms. How do you provide students and parents with real-time, online progress charts if you are using Google spreadsheets to calculate your grades?
Abstract: This hack shows how to install a Google Apps Script in your Google Site to look up the grades of the currently logged-in student or parent and generate a live bar of progress from your Google spreadsheet!
Recommended by 20 educator(s)
Problem: How do you give students, teachers, and parents a private view of live, individualized reports without locking into a rigid, expensive commercial portal?
Abstract: The Reportlet Script, written in Google Apps Script, serves up easily-templated tabular reports that can include custom data, images, and charts keyed to the logged in user. Power users get a dropdown to allow viewing of any report.
Recommended by 17 educator(s)
Problem: How do automate the creation of personalized documents and emails from the cloud?
Abstract: The autoCrat Script 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.
Recommended by 290 educator(s)
Problem: How can you quickly automate targeted emails and calendar appointments to loop in the right people around regular occurrances like behavior incidents, absences at attendance at after-school tutoring, etc.?
Abstract: The formMule (aka "The Mule") is a Google Apps script that is useful for automating lookups, emails and calendar events created dynamically from Google Forms.
Recommended by 64 educator(s)
Problem: How can teachers harness all the awesomeness, ubiquitous access, and collaborative authoring power made possible by Google Docs without creating a document management nightmare?
Abstract: This tutorial presents the pre-Add-on version of Doctopus. Written by an educator for educators, the free doctopus script gives teachers the ability to auto-generate, pre-share, and manage grading and feedback on templated Docs for group and individual projects. For tutorials on the new version of Doctopus, see
Recommended by 188 educator(s)
Syndicate content