multiple choice quiz

• 0
• Question
• Updated 2 months ago
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?
• 140 Points

Posted 2 years ago

• 0
• 31,678 Points
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?
• 140 Points
The answers are going to be the same I just need it to calculate the percentage and make a value for the answer.
• 31,678 Points
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.
• 140 Points
thank you !
• 470 Points
What if you have a multi-select text, is it the same concept with the same formula?