Building a Custom Registration Form with Google Apps

One of the main responsibilities my team has is offering and running training on a number of resources teachers in the district have access to. The most popular, because of their new-ness, are Google Apps (GSuite...whatever) and Canvas. Because we offer so many workshops, our Drive is full of copies of copies of copies ofRead More

Introducing: Endnote Generator Add On

A year ago, I posted a script which converts footnotes in a Google Doc into endnotes. I've gotten great comments and feedback and have made the standalone script better, which is still available. The Endnote Generator Add-On is now available in the Chrome Web Store for Docs. Install it once and you'll be able toRead More

Link Two Google Docs for Translating

An interesting Stack Overflow question popped up about auto-translating one document into another when edits are made. Most Google services have things called "triggers" which run functions after some kind of event - opening the doc, making a change, etc. A Google Doc does not have access to the onEdit trigger, so there is noRead More

Tracking Missing IDs with a Google Sheet

Like many schools, our students are asked to wear their student ID's when they come into the building each day. During the day, they don't need to have them on...just in the morning so we can make sure people coming in are part of our student body. If a student doesn't have their ID, weRead More

Building a Custom Web App from Google Sheets

I'm working with a group of teachers to run a mock election this week. They had a basic Form set up for students to vote along with two other "pie-in-the-sky" ideas: Assign electoral votes by homeroom to simulate the Electoral College. Have a live-update view of the election teachers could show in their classrooms. ElectoralRead More

Displaying Aggregate Data in Google Sheets

Our students are required to have their student ID on when they come into the building each day. This is mainly for security, but their ID also allows cafeteria, library, and other office staff to scan their ID for various clerical tasks. When a student doesn't have their ID, they're issued a temporary wristband soRead More

Using the Hypothes.is API in a Google Apps Script

I've started using the Hypothes.is annotation tool more lately, mostly at the behest of Kris Shaffer. He started writing about it's potential for public discourse on research back in April and has since created Pypothesis to turn his annotations into a blog post using Python and the Hypothes.is API. The API is pretty simple -Read More

Quickly Make Bulletin Board Words

Marc Seigel is always doing great things in his classroom and he tweeted out a great picture of a bulletin board that now lives at the front of his room. My new bulletin board at the front of the #roomofawesome No more boring announcement board. Now positive messages are what the students will see everyRead More