I love Google Forms. As an elementary school principal, I use them all the time. All. The. Time. From a parent contact log to gathering staff meeting feedback to finding out which parents are interested in joining our PTA Board, I use Google forms on a daily basis. If you're not already familiar with this powerful tool, check out this series of tutorial videos on what has become my favorite online tool.
The great thing about a Google Form is that the data gathered from the form is neatly organized in a Google Spreadsheet (A.K.A. Google Sheet) that can then be sorted and/or filtered.
Last year I created two new Google Forms my teachers could use to submit their agendas and notes from their weekly Professional Learning Community (PLC) meetings. My goal was to provide teachers an easy-to-use method of submitting their grade level's agenda and notes while providing me a central location for all their responses. It worked great. I had one form and corresponding spreadsheet for their PLC agendas and one form and spreadsheet for their PLC notes. Each week, I could sort the responses by grade level to see what each team was working on.
The problem came as the year progressed. With each passing week, more and more responses populated each spreadsheet. While I was able to sort the data by grade level, I still had to do a lot of scrolling due to the growing number of responses and large amount of text in some of the fields. What I needed was a way to filter the data for each grade level into a different worksheet (or tab) within the same spreadsheet. That's when I discovered EZ Query.
EZ Query is a free add-on for Google Sheets that enables you to create different worksheets (tabs) within one spreadsheet that show only the data you want. This easy-to-use add-on makes the already-amazing Google Forms/Sheets combination even better. Rather than write about how it works, allow me to show you in the short video below. Enjoy!
Brent has worked in the field of education as a teacher and administrator for 25 years. He is currently Principal of Alta Murrieta Elementary School in Murrieta, California. Read more about Brent here.
Brent on Twitter