# Discussions

View Only

## multiple choice quiz

• #### 1.  multiple choice quiz

Posted 02-24-2017 18:10
i need to make a multiple choice quiz. It should calculate what you got right and show your percentage. How would  go about doing that?

• #### 2.  RE: multiple choice quiz

Top
Contributor
Posted 02-24-2017 18:19
Is this a one off situation where the questions and answers are always going to be the same (almost like a survey)?  Or you looking to make an app that will allow you to make multiple quizzes, and change the questions and answers regularly?

• #### 3.  RE: multiple choice quiz

Posted 02-24-2017 21:43
The answers are going to be the same I just need it to calculate the percentage and make a value for the answer.

• #### 4.  RE: multiple choice quiz

Top
Contributor
Posted 02-25-2017 03:34
If your questions are all going to have different 'weight' values, one way to do this (even though its not the most scalable) is to create an [Points awarded] field for each of the questions.

Example:
[Q1] What color are banana's?
Multiple Choice Options:
A - Red
B - Yellow
C - Blue

[Q1 - Value]   (Make this a formula numeric field, with a similar equation)

`If([Q1]="B - Yellow", 5, 0)`

That will award 5 points for the right answer, and 0 for anything else.

Then you can take all your [Q - Value] fields and add them up, and divide by the total points possible.

[Score]
`Sum([Q1 - Value], [Q2 - Value], ..... [Q20 - Value]) / 100`

(Set the properties to display as a percent)

There is another way you can do it with a few tables and relationships, but if you are just doing this once, this might be your best option.

• #### 5.  RE: multiple choice quiz

Posted 02-27-2017 14:23
thank you !

• #### 6.  RE: multiple choice quiz

Posted 03-06-2019 17:31
What if you have a multi-select text, is it the same concept with the same formula?