Teachers are responsible for monitoring student learning on a regular basis. One way to do this is by analyzing student data, and if you have that data in Google Sheets, you’ll really appreciate how Google Explore makes it so much easier to connect you to your students and their learning.
What Is Google Explore?
Google Explore is a built-in application interface that monitors what you type and responds with related, on-the-fly content. It wasintroducedin the fall of 2016 and is available for not only Google Sheets, but for Google Docs and Slides as well. You can also find it onAndroidand now oniOS, too. Think of it as another set of hands (and eyes!) to help you examine student data to better ensure mastery.
Explore in Sheets helps you decipher your data easily, whether you’re new to spreadsheets or are a pro with them. Just ask Explore and get answers about your data. You can ask questions like “Which person has the top score?” This equates to less time spent crunching numbers and more time finding key insights and using them to help your students.
How to Get Answers About Your Data
As you examine how to use Google Explore, use thisExample Grade SheetI created that contains some simple data. To use Google Explore:
Open a spreadsheet in Google Sheets.
In the bottom right, click the green Explore icon.
Under “Answers,” type your question in the box and press the Enter key. Try asking some of these questions:
Which student has the top score on Test 1?” (Note: You must use the fields that exist in your spreadsheet. For example “student” and “test 1”)
Which five students have the lowest score on Test 1?
What is the average of Assignment 1?
Google will give you some suggestions to explore as well. To see the suggestions, click on the suggestions under the text box.