Instructions on Creating Automated Exam Scoring Sheets Using Gemini

To improve the quality of teaching, teachers should combine various AI tools to quickly generate content. For exams created using Gemini, teachers can use Google Forms to create multiple-choice answer forms and grade them using Google Sheets. Below is a guide on creating multiple-choice answer forms and grading them using Google Sheets with Gemini.

How to Grade Exams Automatically Using Gemini

Step 1:

We prepare the exam questions in advance , perhaps using a matrix exam created with Gemini. Then, upload the exam to Gemini and enter the command below to write the Google Apps Script code to create an online Google Form grading sheet.

If the exam is entirely multiple-choice , you can simply omit the descriptive/essay section.

Step 2:

We access Google Drive, then click on New , select More apps from the menu that appears, and then select Google Apps Script .

First, give the project a new name and delete all the existing code in the interface . Then, paste all the code from Gemini into this interface , click the save icon, and select Run to execute the command.

Now you need to grant permission to run this code.

Step 3:

Once this process is complete, you will see a link to the Google Form you are using .

In the Google Forms interface, click on Responses and then click Link to Sheet to proceed.

Then you need to link to a new worksheet, click Create to do so .

Step 4:

Return to the Gemini interface and enter the command to create a scoring script on the Sheets file .

This prompt seems to be for your reference and you can adjust it to suit your test format and grading system. In the meantime, send the Google Form to the students to complete so they can see the results.

English example text

Step 5:

Next, open the Google Sheets file where you created the scoring, click on Utilities, and then select Apps Script .

Teachers will copy the grading code generated in Gemini into this script project . Then, save it and wait until the students have completed the quiz and submitted their full results before running the project .

Step 6:

Open Google Sheets and you'll see the student grading section , along with highlighted incorrect answers.