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

Drawing Notes

I used to make fill-in-the-blank notes for my students to complete while watching a video. For a particular subset of students, that works well. Helping lower the barrier for learning by providing a construct for information gathering led to more engagement when it came time to use the information. Then I took on AP Biology.Read 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

Turning an Old Laptop into a Video Kiosk

My father-in-law came to me with an interesting idea. He wanted to create video kiosk for our church which would play videos on different mission organizations we're involved with. The wall - previously - had photos and text about each missionary or organization, but he wanted to revamp. We initially tried to use PowerPoint andRead More