I have added a couple of columns to the Google Sheet Responses for a quiz created using Google Forms. When creating the response sheet (created in the "Responses" tab of the quiz, it automatically creates a column labeled "Score" that tells the number of correct responses. For example, If a student misses 2 questions on an exam with 25 questions the column will show "23/25". I added a column that takes that, and creates a percentage grade. I then use the new "Percentage Grade", in an additional column I have created that states "PASSED" only if the student made 100% on the quiz. NOTE: This is a safety test whereas they MUST make 100% to pass, and can take the quiz multiple times.
I am currently highlighting and dragging the formulas into the newly submitted responses in order to obtain the "Percentage Grade", and "PASSED" information, but would like to see if Sheets can do this automatically.
My question is this, is it possible to make Google Sheets automatically calculate the "Percentage Grade", and "PASSED" columns as the students submit their quiz as it does with the default "Score" column?