4. Filter Views

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.

Screen Shot 2017-01-04 at 2.50.43 PM.png

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!

Screen Shot 2017-01-04 at 2.52.11 PM.png

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, Screen Shot 2017-01-04 at 2.53.24 PM.png, in the top menu. Clicking on the small triangle beside it, you can then select to “Create a New Filter View.”

screen-shot-2017-01-04-at-2-53-59-pm

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.

Screen Shot 2017-01-04 at 2.56.32 PM.png

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!

output_k1fJ0x.gif

3. /edit

For each GSuite Tool there is a unique URL.  Each URL sends the user to that specific Google Doc, Google Sheet, Google Drawing, Drive Folder etc.

screen-shot-2017-01-03-at-4-26-38-pm
The URL is highlighted at the top of the screen.

It is quite handy – you can paste it into an email, send it through Hangouts, embed it behind an image or a button.

But this URL has the power to do a lot more than redirect someone to your Google Doc!  At the end of the URL, you will see a “/edit.”

Screen Shot 2017-01-03 at 4.28.07 PM.png

By changing these four letters, you will be able to control permissions and editing rights on an single click:

/copy forces the user to make a copy right away:

Screen Shot 2017-01-03 at 4.32.17 PM.png

/preview showcases the work as if it was published on the web:

Screen Shot 2017-01-03 at 4.32.39 PM.png

Now that one URL has just become a whole lot more powerful!