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

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

Looking for Help with Canvas LMS

We're using Canvas this year in our district and I'm trying to figure out how to actively (and successfully) utilize the Learning Mastery gradebook alongside the traditional gradebook...sort of a hybrid SBG. I have Outcomes set for the entire year (the AP Bio curriculum) and I'm assigning Outcomes to each assignment. This is transferring nicelyRead 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

More on Licensing Culture and Owning What You Pay For

I was talking with our school librarian today about why we don't offer ebooks for students to check out. It came up because I grabbed a real, hardcover library book six weeks ago and had just finished it this week. It's only 400ish pages, and taking that long to read a short/medium length book wasRead More