Google Tricks

Using simple formatting techniques Google Sheets users can create spreadsheets that are easier to read and more effective for viewing and display data. Working with spreadsheet data doesn’t have to be intimidating. As educators, we often need to collect, analyze and visualize data to truly understand trends in our classrooms, schools or districts. I’ve compiled some tips for Google Sheets newbies that will help you navigate sheets and make them easier to view.

Users with multiple Google accounts can toggle between users easily in Chrome by understanding the difference between "add account" and "add person"

Google Drive shared with me files can be organized into folders of your Google Drive to make them easier to find and access.

Google Drive allows users to organize the SAME file into multiple folders without duplicating the file. Any changes to the file will be reflected globally in all folders for you and your collaborators. This feature is particularly important given the collaborative nature of G Suite. The ability to access a file from multiple folders is very helpful when you are sharing items or as a way to help you stay organized.  For example, I can save a lesson plan into a folder for a particular unit and also add the same file to a shared department curriculum folder.

You can remotely log out Gmail and Google Drive from any device to end all open web sessions by following these simple steps.

Formatting Google Forms questions using data validation and question description fields can lead to a more professional look and better data summaries.