Looker Studio and Access Control List Tables
The Filter by Email function in Looker Studio Reports is a powerful way of targeting data to the logged in user. However, this assumes a 1:1 relationship between the email …
Assessment Tracker with Google Workspace
The Assessment Tracker Add-on for Google Workspace is now available for install in the Google Workspace Marketplace. Contact me to set-up your free trial.
DIY Sign-up Manager
If you host a lot of free virtual events, managing registrations and sending calendar invites can quickly become an administrative nightmare. With some help with a little Apps Script we …
Dismissal Tools for Google Sheets
While my Google Sheets Add-on, Dismissal Guru, goes a long way in facilitating school dismissal workflows. I also build custom solutions for schools. These are essentially more robust versions of …
Auditing “Shared with Me” Google Drive Files
The “Shared with Me” space in Google Drive can feel overwhelmingly chaotic and even anxiety inducing if you have the desire and need to organize everything in Google Drive. Here’s …
Let me get that QR Code for you!
QR Codes are amazing little bridges that connect our physical world to our digital one. It’s so much more practical scanning a QR Code, than typing in a full url …
Generating Unique PIN numbers in Google Sheets
Sometimes a need arises for creating, multiple random unique ids. When I created our Google Forms-based dismissal workflow, I needed to generate unique PIN numbers for every student. Here was …
Google Classroom List View
If you’ve recently been added as a co-teacher to several classes you may be wondering “How am I going to find anything?”. Until Google Classroom develops its own list view, …
Centrally Manage your Google Classrooms from a Google Sheet
Update 08/02/2021: I’ve updated this approach in an all new workshop video. Please check out the video below for links to the latest templates. This workflow replaces the one described …
Reimagining Dismissal Workflows with Google Workspace
Many schools are likely reviewing their dismissal plans for next year ensuring they comply with social distancing guidelines. I’ve been thinking a lot about how our existing communication tools can …