Google Calendar and Webcal Feeds
Approximately 3 years ago I wrote a post on using Apps Script to copy events from a calendar feed to your primary Google Calendar. The purpose was to efficiently and …
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 …
Bulk Delete Specific Google Calendar Events
For many of us, we rely on Google Calendar to help us structure our work days. It does a lot of things really well, but one limitation is the ability …
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
As the new school year approaches, I’d like to share a free DIY approach to simply managing your school’s Google Classrooms using Google Sheets. I have worked with free add-ons …
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 …
Approval Workflow Add-ons for Everything
Think of all the paper forms you still use in your school or organization that require an approval process. Does it really need to be a paper based system? Think …
Google Forms and Repeating Event Requests
Google Calendar is an incredibly robust and useful planning tool, but it has limitations related to scheduling approved event requests. Many people use Google Forms to collect information about an …
Curriculum Mapping with Google Workspace
Curriculum Mapping with Google Workspace is a free approach to documenting and organizing your school’s curriculum planning documents. At its core, Curriculum Mapping with Google Workspace consists of an internal …
Digital Badges with Google Forms, Sheets and Data Studio
Google Forms, Sheets and Data Studio can be used to manage your micro-credentialing needs. The interactive example below shows how digital badges can be conditionally displayed in a Data Studio …