Using the Query Function to Filter and Sort Data

Earth week is around the corner. To make the students more aware of their trash output, we're using the first day of earth week to have students "carry their trash" instead of disposing of it to make them more aware of what they consume and throw away. I made a simple google form for them to submit how many and what type of trash students collected at the end of the day.

One of my projects is to help students visualize this information from the data that comes in as it's submitted. The "Query" formula has become my saving grace and is a super cool way to filter data based on a specific column and push it into another tab so we can look for trends from the data. Here is a tutorial which shows you how to do it. Enjoy!