Five Ways to Turn Up the Power of Google Sheets in the Classroom
Google Sheets can be much more than a simple spreadsheet application. Turn up the power of Sheets with these five add-on’s found in the Chrome App Store.
Attched to a Google Sheet, Flubaroo is a powerful grading tool. Not only can it grade assignments that in a Google Sheet, but if you have the student email, you can return their grades to their shared folder. Using one of my favorite application in Pear Deck? You can send your Pear Deck results to a Google Sheet and use Flubaroo to grade them.
Doctopus is a great way to distribute classroom assignments in a paperless classroom. Students simply look in their “Shared With Me” folder for their assignment. The thing that’s great about Doctopus (of which Google Classroom recently added) is that it provides a way to differntiate assignments among the students in your class. Want student “A” to do all of the questions on the worksheet while student “B” should only do half of them, it’s easy to send out separate assignments. Once the due date for the assignment has arrived, you can “ingest” the assignment for grading and return the digital copy.
Goobric takes that rubric you have on a Google Sheet and attaches it to student work for easy grading. It works hand in hand with Doctopus. Once you’ve got the student work in Doctopus, attach the Goobric, grade and return — it’s really easy to do and makes grading simple.
Rostersync is heaven sent for those that are typing rosters into a spreadsheat to use for different applications such as grading apps. It works in conjunction with Google Classroom in that it pulls your roster from Classroom or vice versa sending a roster from your spreadsheet to Google Classroom. It works great when you want to set up a class with Doctopus.
Autocrat is a document merge app that takes information you have on a spreadsheet and moves it to a Google Doc or PDF. For example, you’ve asked the students to sign in using Google Forms when attending an after school study session because want to give the students a certificate of participation. The Google Form is connected to a Google Sheet for easy reference. You can take the information on the Google Sheet and create certificates of participation using Autocrat. It’s also great for use at staff meetings. The staff signs in through a Google Form that’s tied to a Google Sheet. Use Autocrat to create a certificate of attendance.