How to convert grades into percentages in the New Google Forms Quiz

I love the quiz feature in the new Google Forms because you can format it to allow your students to see their marks right away. However, the mark does not appear as a percentage, instead it appears only as number of correct answers, for example: 16/25. As a teacher, sometimes you need to convert that result into a percentage.

I am not a Google Sheets person, so I turned to my super geeky and talented friend, Jen Giffen for some help. Here is her solution:

  1. Insert two blank columns to the right of your marks.

screen-shot-2017-02-10-at-10-53-50-am

  1. In the first blank column in row 2, type =left(

screen-shot-2017-02-10-at-10-55-47-am

  1. Click the first mark in column B. B2 will automatically appear (or whatever cell number the first mark is in)

screen-shot-2017-02-10-at-10-56-49-am

  1. Type ,2) then hit Enter

screen-shot-2017-02-10-at-10-57-51-am

  1.  The original mark will appear in the C column. Now click on the D column.

screen-shot-2017-02-10-at-10-59-01-am

  1. Type = then tap the mark in the B column.

screen-shot-2017-02-10-at-11-00-26-am

  1. Type / and the total your quiz is out of, then tap the % symbol

screen-shot-2017-02-10-at-11-02-47-am

  1. You will now get a percentage in column D.

screen-shot-2017-02-10-at-11-03-33-am

9. To complete all percentage conversions, drag down the bottom right corner of Column C.

screen-shot-2017-02-10-at-11-07-54-am

  1. Now do the same for Column D

screen-shot-2017-02-10-at-11-09-02-am

  1. NOTE: If you try to cut and paste these percentages on a new spreadsheet, you will get this:

screen-shot-2017-02-07-at-5-44-47-pm

  1. So you need to use “Paste special” then “Paste values only”.

screen-shot-2017-02-07-at-5-44-52-pm

THANKS, JEN!!!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s