Data drives our world. We use it to identify interventions for students, we use it to provide feedback to our teaching methods, we use it to make assumptions or to start inquiring about a topic.
Google Sheets allows us to view large amounts of data at once all while collaborating with as many people as we would like.
Take this Google Sheet for example. We have multiple columns which can be sorted. If we wanted to, we could sort the “Class Level” column in order.
When you do this though, you will notice that the entire sheet shifts rows to match your recent sort. Super handy if you are the only one looking at the data, but frustrating for everyone else in the Google Sheet as you have just changed their view too!
Filter Views in Google Sheets solves this problem. Each person can select their own Filter View which will ONLY change their view, not the entire spreadsheet.
You can find filter views under the martini glass, , in the top menu. Clicking on the small triangle beside it, you can then select to “Create a New Filter View.”
When you have selected a filter view, you will notice that the row and column headers are now black. This is your indication that you are in the filter view.
From here, you can name your filter view to save it for next time. So if I wanted to create a filter view that sorts the Class Level and a new filter view that sorts the major, I could do that. Now that information is easily accessible to me and all who use the Google Sheet without changing everyone’s view!