Last week I posted a video about how to use pivot tables in Google Sheets. Manipulating the way that data is displayed is one of many ways that you can use Google Sheets in your classroom. Here are five other ways to use Google Sheets in your classroom.
Build Multimedia Timelines
The timeline project is as old as history classes. Today, you can put a modern spin on that project by having students build timelines that include videos, audio recordings, pictures, and interactive maps. Timeline JS is a service that students can use to turn a spreadsheet of dates, text, and media links into a timeline. Watch the following video to learn how to use Timeline JS.
Online Rubric is a free Google Sheets Add-on makes it easy to create a rubric. This Add-on does more than just format your Google Sheet into a rubric template. With Online Rubric you can enter scores, write comments for your students, and email your students directly from the Sheet. When you send an email from the Sheet your students receive a copy of their scores, your comments, and the descriptors from the rubric.
Schedule Reminder Emails
Add Reminders is a Google Sheets add-on that you can use to schedule reminder emails to be sent to your students, their parents, to colleagues, or anyone else. To use this Add-on just fill in the template with email addresses, recipient names, the tasks they need to be reminded of, and the due dates for the tasks.
Create a Random Name Selector
Flippity.net offers eighteen Google Sheets templates. One of those templates is a random name selector. Simply make a copy of the name selector template, insert your class roster, and then publish your spreadsheet to use Flippity’s random name selector.
One of the frequently overlooked features of Google Sheets is buried in the lower, right corner of your Google Sheets. That feature is the “Explore” function. Click on Explore to see the graphs that Google makes and suggests based on the data in your spreadsheet.
Learn more about these features in my upcoming course, Getting Going With G Suite.