Pin It

Excellent Google Sheets Tools for Assessment and Grading

July 29, 2015
Google Sheets add-ons store has a multitude of excellent educational apps teachers can employ to enhance their productivity and improve their classroom workflow. Today we spent sometime wading through these extensions and curated the list below. This is a collection of some useful add-ons to help you with the assessment and grading of your students work.

1- Flubaroo

‘Flubaroo is a FREE add-on to Google Forms/Sheets which lets you quickly grade and analyze student performance on multiple choice and fill-in assignments. Within a minute you'll be able to:

  * Get scores for each student, and identify students in need of extra help.
  * View average score, and a histogram of scores.
  * Quickly identify questions which a majority of the students missed.
  * Email students their scores, along with optional notes to the class and/or to each student.
  * Assign your own score to open-ended questions.’

2- Doctopus

‘Doctopus gives teachers the ability to mass-copy (from a starter template), share, monitor student progress, and manage grading and feedback for student projects in Google Drive…Doctopus increases student collaboration and enables a powerful shift in teacher workflow --  scaling teachers' ability to manage and assess writing tasks and projects that motivate rich, authentic student production and collaboration (e.g. the development of core career, college, and 21st-century skills).’

3- Super Quiz

‘Super Quiz adds brilliant functionality to a quiz made with Google Forms. By completing the quiz once with an answer key, all future submissions are automatically graded correct or incorrect. What’s more - you can get a break down of class understanding and a list of incorrect students for each question - perfect for intervention!’

4- Online Rubric

‘Use Online Rubric for any assignment, including presentations, performance, and participation grades, and send grades to your students without the hassle and waste of paper and copiers.Online Rubric supports multiple emails for each student in the case of revisions and allows you to use previously created rosters and rubrics within the add-on.’