Skip to content
Richard A. Anderson
Menu
  • Types of Projects
  • About Me
  • Work with me
  • Store
    • Privacy Policy
    • Terms of Service
    • Support

Author: Richard Anderson

Google Sheet
Google Sheets

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 Calendar

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 Sheets / Looker Studio

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, …

Google Classroom / Google Sheets

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 …

Google Forms / Google Sheets / Hangouts Google Chat

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 …

Google Docs / Google Forms / Google Sheets / Internal Add-on

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 Calendar / Google Forms / Google Sheets

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

Curriculum Mapping with Google Workspace

The updated Google Workspace Add-on approach is located here. Curriculum Mapping with Google Workspace is a free approach to documenting and organizing your school’s curriculum planning documents. At its core, …

Google Forms / Google Sheets / Looker Studio

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 …

Google Calendar

Teacher Schedules, Webcal Feeds, Google Calendar and Apps Script

G Suite schools know the power of Google’s collaborative apps and how they facilitate learning, yet few schools venture to leverage their customizable powers to create custom solutions to age …

Posts navigation

Newer posts
  • Types of Projects
  • About Me
  • Work with me
  • Store
    • Privacy Policy
    • Terms of Service
    • Support
  • Employee Portfolios: An Internal Google Workspace Add-on for managing goal setting, observations, reflections and more.
  • Sub Manager: An internal Google Workspace Add-on for tracking and managing class coverage within a school
  • Looker Studio and Access Control List Tables
  • Assessment Tracker with Google Workspace
  • Google Workspace Internal Add-on: Sign-up Manager
Stay Connected
Copyright © 2023 Richard A. Anderson – OnePress theme by FameThemes