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!!!