Using Google Sheets in the Classroom

Not sure how you might use Google Sheets with your students? Read on for 3 ideas.

One useful application of Google Sheets with students is to create a task tracker, whether it be for a multi-step project or as a way to organize activities within a week or unit. Create the dropdown menus using data validation, color-code the responses using conditional formatting, and you have a visual representation of progress that is easy for you and your students to understand. Students get to practice their project management skills, while you get quick data on which students might need intervention.

Midterms Week Task Tracker

Reading Tracker Sample

While a shared spreadsheet is a great place to log data, it can also generate data in a student-friendly way. In our English 10 class, we use a reading tracker in Google Sheets that helps us implement our independent reading program. Once students log a new book in the sheet, it calculates a weekly page goal and an estimated finish date - two crucial pieces of data that help us with accountability. The sheet also allows us to keep a running total of how many books each student has read; finally, by keeping notes on our student conferences in the sheet, we keep all of our student reading data in one place.

Finally, think about integrating Google Sheets with your Canvas classroom. Did you know that you can not only share Google Sheets (and Docs, Slides, Forms, etc.) directly in Canvas, but also make them editable for students? Try it by following the directions below.

EMBED EDITABLE SPREADSHEET/DOC/SLIDES

Update sharing permissions → anyone at RJUHSD can edit
Share > Publish to web > Embed > copy embed code
Paste embed code into Canvas
Replace the URL part of the embed code (everything before /pubhtml) with the edit URL (the one in your browser):

Page updated

Google Sites

Report abuse