Spreadsheets can be intimidating to a lot of teachers and students. I have to admit that at one time working with spreadsheets was a daunting task for me too. Fortunately, Google Sheets has made it much easier for the average computer user to work with spreadsheets. Once you get the hang of working with Google Sheets there are a lot of great ways to use spreadsheets as a teacher or as a student. Here’s a run-down of some of my favorite things to do with Google Sheets in the classroom.
Map spreadsheet data:
One of the overlooked and or misunderstood features of Google My Maps is the option to import spreadsheet data. Provided that your spreadsheet contains at least one column that has location information in it, you can have the data in the spreadsheet displayed as placemarks on a map. In the video embedded below I provide a demonstration of how this can be done.
StoryMap JS is a nice tool for creating mapped stories. On StoryMap JS you create slides that are matched to locations on your map. Each slide in your story can include images or videos along with text. As you scroll through your story there are simple transitions between each slide. StoryMap JS integrates with your Google Drive account. To get started with StoryMap JS you have to grant it access to your Google Drive account. StoryMap JS will create a folder in your Google Drive account where all of your storymap projects will be saved. With StoryMap JS connected to your Google Drive account you will be able to pull images from your Google Drive account to use in your StoryMap JS projects.
Create multimedia timelines from a spreadsheet:
Timeline JS creates a timeline based on entries made in a Google Spreadsheets template provide by Timeline JS. Your entries can include links to videos, images, and maps. I made a video on how to use Timeline JS. That video is embedded below.
Guided/ Automatic Data Visualizations:
The Explore function in Google Sheets will help students see and understand data sets in new ways. Now when students open a Google Sheet they will have the option to click the Explore function to have a set of suggested graphs and charts based on the data in the Sheet they’re viewing. The Explore function is found in the bottom, right corner of the Google Sheet you’re viewing. The Explore function won’t work in every spreadsheet. It is dependent on the spreadsheet having data like locations, currencies, or demographics. See how it works in the video embedded below.
Grade students’ assignments:
Flubaroo is a popular Google Sheets Add-on that enables me to grade all at once all of my students’ responses to a quiz created in Google Forms. The autograde option in Flubaroo allows you to have students automatically receive their scores after submitting their responses to a quiz you created in Google Forms. The autograde feature will send students an email with their scores and the answer key (you can exclude the answer key). With autograding enabled students do not have to wait for you to run the grading process or wait for you to send emails.
Online Rubric is a Google Spreadsheets Add-on that enables to you create rubrics, enter scores, and email scores to students all from one place. Online Rubric provides very clear instructions for each step of the processes of creating a roster sheet, creating a rubric, and emailing grades to students. The video below provides a demonstration of how to use the Online Rubric Add-on.
Email reminders:
Add Reminders is a Google Sheets Add-on that will set-up your spreadsheet so that you simply enter reminder messages and email addresses then specify a date on which you want your reminders sent. The Add Reminders Add-on allows you to send the same reminder to everyone in your email list or you can send individualized reminders to everyone in your email list. Watch the video below to learn how to use the Add Reminders Add-on.