Expanding the SBG Tracking Gradebook

I mentioned Evan Weingberg's standards-based tracking system in a short snippet a couple weeks back. I want to expand on that thought a little bit. Essentially, he uses a Google Sheet to aggregate quiz performance to make sure standards are actually learned over time. This has been incredibly valuable to me because I felt thatRead 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

Quickly Format Articles for Annotations

We're working very hard with students on annotating articles in preparation for the new state test sections. The goal is to help them find pertinent information in multiple texts which can be used to construct thorough written responses. We have a standard format...circling unknown words, underlining main ideas, etc, which help students transfer the skillRead 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

Making Endnotes from Footnotes

Update 12.22.2016 Since this has become quite a popular script, I've converted it into a Google Docs Add On so it can be used across documents. Check out the blog post or the Endnote Generator website for more information. Update 8.27.2016 As Phil noted in the comments, the script didn't format anything over two digitsRead More