Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Create a multiple choice quiz that self scores

192 2
cancel
Showing results for 
Search instead for 
Did you mean: 

I need to create a test/quiz for my employees in order for them to be certified in a subject area.

I'd like to create a form with 30 questions, each question with up to 4 multiple choice answers.  I have an answer key, indicating which of the answers is correct

Is there a way for the employee to complete the form and submit and AT automatically compares the answers to the answer key and provides the number answers correct and the percentage of answers correct out of 100.

2 Replies 2

This might be easier with an (albeit long) formula field rather than a separate answer key (which I assume is either a separate table, or 30 fields in the same table with the correct answer identified).

That formula could look like:

SUM(

  IF({Question 1 field} = "Correct Answer", 1, 0),

  IF({Question 2 field} = "Correct Answer", 1, 0),

  IF({Question 3 field} = "Correct Answer", 1, 0),

  ...

  IF({Question 30 field} = "Correct Answer", 1, 0)

)/30

 ^ Format the result as a percentage

You can create a table with 30 single-select fields, where each field is one question, and the single-select choices are the possible answers. Then have the answer key in the formula field as Kamille describes.