Google Apps Script
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 9 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 16 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 13 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 11 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 148 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 29 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: 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.
Recommended by 98 educator(s)
Problem: How can overburdened school administrators manage their workflow to enable short mini-observations aligned to a teacher effectiveness framework like Danielson without getting locked into expensive, proprietary software?
Abstract: This well thought-out template, created by a collaboration between a highly successful NYCDOE principal and an Apps Script developer, makes data entry a snap, helps administrators prioritize observations, and supports communications with teachers.
Recommended by 9 educator(s)
Problem: How can I get a Google Form to add content to the end of a user-selected Google Document?
Abstract: The docAppender script installs on the form-containing spreadsheet and provides users a web app where they can easily select which document they want to append. 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.
Recommended by 7 educator(s)
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 8 educator(s)
- 1 of 2