BrentColey.com
  • Home
  • Books
    • Stories of EduInfluence
    • The Gift
  • Podcast
  • Blog
  • Speaking
  • Videos
    • Video Tutorials: Google Forms
    • Video Tutorials: Google Documents
    • Video Tutorials: Audacity
    • Math Review Videos
  • Resources
    • StudyCast
    • Student Podcast
    • Literature Circles
    • Flowchart Notes
    • Classroom Income Tax
  • About Brent
  • Contact Info

Thoughts on Teaching, Leadership, and Educational Technology

Cool Tool - EZ Query Google Sheets Add-on

7/3/2015

1 Comment

 
Tweet
Picture
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!

1 Comment
Michele McCabe
9/20/2018 12:45:01 pm

I attended a CUE session of yours a couple of years ago and have loved the tools/tips you shared. The EZ Query add-on has seemed to disappear. Have you found a different tool that can be used for the same purpose?

Reply

Your comment will be posted after it is approved.


Leave a Reply.

    About Brent

    Brent has worked in the field of education as a teacher and administrator for 29 years. A former elementary school teacher and principal, he is currently Coordinator of Elementary Education in the Murrieta Valley Unified School District in Southern California. Read more about Brent here.


    Follow @brentcoley

    View my profile on LinkedIn

    RSS Feed


    Archives

    February 2025
    May 2024
    April 2024
    March 2024
    May 2023
    July 2022
    October 2021
    September 2021
    January 2021
    December 2020
    July 2020
    June 2020
    November 2019
    January 2019
    September 2018
    December 2017
    July 2017
    June 2017
    May 2017
    December 2016
    August 2016
    July 2016
    June 2016
    February 2016
    January 2016
    July 2015
    April 2015
    March 2015
    February 2015
    October 2014
    July 2014
    April 2014
    March 2014
    January 2014
    December 2013
    October 2013
    July 2013
    May 2013
    March 2013
    January 2013
    December 2012
    August 2012
    July 2012
    June 2012
    April 2012


    Categories

    All
    Admin
    Android
    Assistant Principal
    Cell Phones
    Classroom Management
    Classroom Website
    Collaboration
    Cool Tool
    Copyright
    Creative Commons
    Ed Tech
    Eduinfluence
    Games
    General
    Google
    Ipad
    Iphone
    Ipod
    Language Arts
    Leadership
    Mac
    Mentor
    Organization
    Pe
    Plagiarism
    Plc
    Podcasting
    Productivity
    Self Care
    Story
    Studycast
    Teamwork
    Texting
    Vocabulary
    Whativelearned

Picture
Copyright (C) 2025 Brent Coley
Photos from somegeekintn, woodleywonderworks, Joybot, British Council Singapore, jseliger2, berkuspic, toddwendy, Alexandra E Rust, skippyjon, crdotx, tharrin, roybuloy, .FuturePresent., Just some dust, frankpierson, Jair Alcon Photography, Luigi Mengato, Muffet, stevendepolo, Pilar Soro, Sander van der Wel, jblyberg, jonathangarcia, DraXus, angeloangelo, Sthetic
  • Home
  • Books
    • Stories of EduInfluence
    • The Gift
  • Podcast
  • Blog
  • Speaking
  • Videos
    • Video Tutorials: Google Forms
    • Video Tutorials: Google Documents
    • Video Tutorials: Audacity
    • Math Review Videos
  • Resources
    • StudyCast
    • Student Podcast
    • Literature Circles
    • Flowchart Notes
    • Classroom Income Tax
  • About Brent
  • Contact Info