Review Questions with Spreadsheets

I wanted to use a new method of reviewing with students as we wrap up our cell activity unit. I've been working with my students on forming questions with the question formulation strategy around content as well as finding new ways to build content knowledge resources. We're at the point in the year where detailsRead More

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

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