Creating an database to automatically grade multiple choice tests

Topic Labels: Formulas
2922 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I am looking to create a database to automatically grade multiple choice exams. I have one sheet with the correct grades and then one sheet with the student grades.

There are a couple of ways to do it with Excel - the easiest is to create an extra grading sheet that uses a Boolean countif to check the student’s answers against the correct answers cell by cell and add 1 to all the cells that are correct [COUNTIF(Student!E5, Correct!E$2)].

Is there any way to set up something similar with Airtable?

1 Reply 1

Hi @Gavin_Brooks - not sure about recreating the Excel method, but this is how I would do it:

  • Have a table with a single row containing the correct answers:


  • Then have another table which contains each student and their answers. Link each row to the answers table:


Then have a series of columns for each question:


“Q1 Answer” is a lookup from the model answer table. Score Q1 is a formula which compares the student’s answer to the model answer:

IF(Q1 = {Q1 Answer}, 1, 0)

At the end, you have a “total score” field which adds the “Score QX” field.

There is a bit of set-up to do, but once it is done it will give you the score just by making the link to the answer table. For usability you can hide the QX Answer and Score QX fields to give you this:

Screenshot 2019-07-12 at 22.03.49.png