multiple choice quiz
I am needing to make a multiple choice quiz that the employees can login and take and show me the results. Pass / Fail type thing. Any help would be great as im new this. Thanks --------------...
Forum Discussion
What do you have setup already? Tables? Fields? Automations? User Roles? Etc ..... ??
------------------------------
Andrew
[email protected]
------------------------------
------------------------------
Andrew
[email protected]
------------------------------
So quickbase is up and running for other things, I have created a app area for testing. I started to create a test using a form but idk if this is the right direction, i do have the question in it as multiple choice but i am really needing to be bale to create many quizzes at we move on. But at the same time i need to make sure the other employees cannot see the quizzes other people have completed also so they cannot cheat.
------------------------------
Matthew Jones
------------------------------
------------------------------
Matthew Jones
------------------------------
- I think that I would probably do the following:
Setup a table or two.
Have some basic fields, such as:
- User
- Question 1 ..... Question X
- Score 1 .... Score X
- Summary (Total) of all Scores
- Summary (Count) of all Questions
You could use a CASE or IF statement to capture the correct answer, giving a 1 or correct and 0 for incorrect.
Then you could sum all the scores and divide them by the number of questions to get your overall score.
You could use roles and permissions to restrict users from seeing reports, charts, data, etc.
You could use dynamic form rules to make your form more user friendly.
That is one basic idea on how to go about doing it.
------------------------------
Andrew
[email protected]
------------------------------- Not good at creating the formula can you give me a example.
------------------------------
Matthew Jones
------------------------------- Perhaps something like:
If([Question1] = "Quickbase",1,0)
Basically, it is saying: If the field [Question1] is equal to the selection "Quickbase", then show a 1, else show a 0.
Granted, this would be entirely dependant on how you have your table setup, the fields you created, etc.
Good luck!
P.S. You could make it more elegant by using CASE instead of IF, but follow the syntax for CASE.
P.P.S I highly recommend going through the Quick Base University if you haven't already. It will increase understanding of how quickbase functions, relationships, formulas (wink wink), dynamic form rules, etc. Very instructional.
------------------------------
Andrew
[email protected]
------------------------------