Here's how to use them -
from RITS Member Melinda Waffle,I would encourage the second route, and here is why. Filters. Using filters you can turn the view-able data on and off, allowing you to see exactly what you want.
Calhoun Intermediate School District, REMC 12E
Let's say a teacher is using a Google Form as a way to gather exit slips from their students each week. They are faced with a dilemma - create a new form each week and deal with a whole bunch of spreadsheets, or deal with a single spreadsheet with a whole bunch of data.
When looking at your spreadsheet, the filter is an icon of a funnel -
To use the filter, highlight the data you want to filter, then click on the filter icon.
This will cause the top row of data (which should be your header information) to turn color and add a little arrow next to each header -
Clicking on the arrow, you have several options. The first is the ability to sort right there, in either direction -
The second is the powerful option. It will have listed every entry choice for that field. You can turn on and off the choices, so you can display exactly the data you want to see -
You can even set the parameters for multiple fields. The arrows will turn to a funnel where you are using filters.
So, let's say I am viewing my data from exit slips and want to see all of them for a specific student - I can do that quickly with filters. Or I want to see all of them for a particular date - I can do that quickly with filters.