multiple choice quiz

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
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?
Photo of Kellz

Kellz

  • 140 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
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?
Photo of Kellz

Kellz

  • 140 Points 100 badge 2x thumb
The answers are going to be the same I just need it to calculate the percentage and make a value for the answer.
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
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.
Photo of Kellz

Kellz

  • 140 Points 100 badge 2x thumb
thank you !