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

Tracking Missing IDs with a Google Sheet

Like many schools, our students are asked to wear their student ID's when they come into the building each day. During the day, they don't need to have them on...just in the morning so we can make sure people coming in are part of our student body. If a student doesn't have their ID, weRead 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