Skip to main content

Self Grading Rubrics

Grading is definitely NOT one of most teachers' favorite tasks.  Feedback is so vital to the learning process, yet providing that feedback is time-consuming and sometimes soul-crushing.  In a previous blog post, I talked about using your phone to grade a rubric quickly using Google Forms while students were presenting.  Today we'll explore the useful tools automatically created for you when using Google Forms as a rubric.

Using the simple rubric example from the previous post, we assigned the grade ourselves.  Using the Individual tab in the Responses section, you can see each individual presentation you graded. 

You can click the three dots and select 'Print all responses' to print a copy of the graded rubric to share with your students. 

Automatic Grading with a Rubric

Creating a related Google Sheet:

One of the fabulous features of Google Forms is that you can create a linked spreadsheet with one click.  Click the Green + sign on the Responses tab and generate a linked spreadsheet.

This Google Sheet will automatically update whenever you submit a form.   The image below shows what my spreadsheet looks like:

I added a drop-down question with each student's email in my class.  (I used their email in case I want to go a step further and share my graded rubric with them from the spreadsheet.)  Notice the email address in column B.  I did this so I can easily pick which student presented on my phone.  

I can easily duplicate the question if I have 3 students presenting as a group, grading the group.

Calculating the Grade:

The Sheet populates the numbers I selected from the linked Google Form/rubric.  One of the great things about spreadsheets is their ability to calculate. 

Spreadsheets use the column names and row numbers to identify an individual cell.  For example, the cell identifier for the first respondent's score in the Design column is C2.

You can create a formula in Google Sheets by clicking on a cell and beginning with the = sign.

Let's think through the math for grading this presentation.

Raw Score

To have the spreadsheet calculate the raw score, you would just add up the scores in cells C2, D2, and E2.  If I want my grade to appear in Column G (Grade), I place my cursor in that column and type:

Click Enter.   Sheets automatically calculates the number for you! Drag the formula down the column for all respondents' grades to calculate.

Percentage Score

To calculate the percentage, just take the raw score and divide by points possible.  (In our case 15)


*(The  /  sign means to divide.)

Click Enter, and the calculated score appears!  Drag the formula down column G for all respondents' grades to calculate automatically.

Weighted Score

Let's say that you want to weight the scores:  Design 10%, Text 20%, Content 70%. 

You would want to take the score received in the category, divide by the total points possible in the category (5), and multiply that answer by the category weight.  For the Design category, the formula for the grading cell would look like this:


(The * sign means to multiply in the spreadsheet world.)

Create weighted calculations for each column and add them up:

The formula calculates the percentage score based on your weighted categories.  

This might seem complicated, but it is actually relatively simple when you see it in action.  

Google Forms and Google Sheets can be powerful allies for grading.  If you need some assistance, just ask!  I am more than happy to help you create a rubric that will help you grade faster!


Popular posts from this blog

Grading in Google Classroom - Using the Comment Bank & More!

Google Classroom updates in August incorporated some big changes!  Grading in Google Classroom has been upgraded with a new grading feedback tool that features a Comment Bank.  Feedback is a huge part of the learning process, and the Comment Bank is designed to make giving and receiving feedback faster and easier.

New Features in Grading

Comment Bank Watch this excellent (and short!) video by Google Classroom/Google Sheets Guru Alice Keeler on how to use the Comment Bank.

For a quick recap (and for speedy feedback):
The Grading/Feedback tool automatically defaults to 'Suggestion' mode.

Use the shortcut keys Option + Command + M on a Mac to invoke comments.

Within the comment box, type #to open the Comment Bank. *  *Google Classroom will show the last 5 comments you have used.  Most teachers will have more than 5 comments in the Comment bank.  If you want to use a comment that isn't shown, type the #(hashtag) and begin typing a word found in the comment you want!  The list wi…

Brain Research and Studying: Top Two Strategies you can help your students use

As midterm exams approach, your students are facing the challenge of preparing for them.  Cognitive learning research provides insight into the best practices for studying. 

 The Top 2 Study Strategies are Retrieval Practice and Spaced Learning: Retrieval Practice  Retrieval Practice is the act of pulling information out of your brain.  For example, you remember what you know about a word, topic, or lesson, pull itout of your brain and then articulate it in some way.  For example, you write down everything you remember.  This is the way your brain really wants to learn!  
Retrieval Practice is the opposite of reviewing notes or the textbook and trying to 'stuff' the knowledge into your brain!

Teacher Action:   If you are holding review session(s) or providing review documents, incorporate places for students to write everything they can remember about the topic before they interact with your review material.  Encourage them to not only write but create images, tables, whatever …

Just Released! Intelligent Search in Google Drive

Google has been busy this week, updating both GMail and Google Drive!

I have been excitedly waiting for the Intelligent Search feature in Google Drive.  Everyone could use a little help finding items in their Drive!

You are familiar with the Quick Access files Google shows you via their Artificial Intelligence (AI). 

Place your cursor in the search box located above your Google Drive.

Courtesy of Google Artificial Intelligence, you see a new list of options:

First:  Suggested search queriesNext:  Top collaboratorsNext:  File types, edit history, priority items, and more! Do you miss the old search box where you have additional criteria you can add?  Click the Advanced Search found at the bottom of the box.  The advanced search dialogue box you opens for your use!