Building a Custom Registration Form with Google Apps

One of the main responsibilities my team has is offering and running training on a number of resources teachers in the district have access to. The most popular, because of their new-ness, are Google Apps (GSuite...whatever) and Canvas. Because we offer so many workshops, our Drive is full of copies of copies of copies ofRead 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

How To Get Text Messages into Google Form Responses

Continuing on my data collection and analysis streak, I've got a little project to throw out into the wild and see what happens. Student response systems are expensive and can be clunky. Google Forms are taking over the role of the stand-alone response system because of their flexibility in the wild during collection (device agnostic)Read 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

If You’re Not Going to Use Attribution, I’ll Just Do It For You

It's important to use attribution online. When you pull a picture, make sure you tell other people where it's from. Some sites make it easy for you to do that, others...not so much. Flickr used to be great at making attribution easy, but their latest redesigns have made it harder to accomplish. Alan Levine hasRead More

How To: See Any Site as it Appears on Mobile

I was working on a Chrome Extension (feel free to download and use it) this evening and I noticed something awesome. If you right click on a webpage in Chrome, one option in the menu is "Inspect Element." It shows a lot of programming mumbo jumbo which is extremely useful in programming, but not necessarilyRead More