Parsing a JSON log feed with Python

I have several Google Sheets doing several things on their own through Google Apps Script. I've started to make it a habit that each action is logged to a separate, isolated spreadsheet so I can pop in and look for error messages in one places rather than several. This poses a small problem. I haveRead More

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

Easily Filter Large Data Sets in Google Sheets

I use Google Sheets in my classroom a lot. I used to rely on combinations of the vlookup, importrange, and index/match functions to get information, but I've recently switched to using if and filter to return arrays of information from master spreadsheets. Using filter is nice because it takes multiple conditions and you can setRead More

My Robot Will Fight Your Robot

Spam on Twitter feels like an all-time high right now. Twitter itself is woefully horrible at taking reports of abuse and spamming and all a user can do is use the completely un-fulfilling "Report Tweet" option to block the user. When they spam hashtags, companies create robots faster than you can report. Twitter spam isRead More

Getting the Axes Right in Google Sheets

I think I finally figured it out. Getting charts and graphs created in Google Sheets (or Excel for that matter) has always been somewhat of a wrestling match between what I want the software to do and what the software thinks I want it to do. Predictive and suggestion-based user interface is nice, but notRead More

QR Codes Everywhere

In my continuing effort to make things more available for students, I've started rearranging my Google Drive files. I've realized that thinking of Drive as a traditional file system isn't as effective as using it more like a topical organizer and then power searching for quick results. Because of this change in mindset, I'm gettingRead More