Forum Discussion

MatthewJones's avatar
MatthewJones
Qrew Trainee
6 years ago

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

------------------------------
Matthew Jones
------------------------------
  • AndrewFry's avatar
    AndrewFry
    Qrew Assistant Captain
    What do you have setup already? Tables? Fields? Automations? User Roles? Etc ..... ??

    ------------------------------
    Andrew
    andrew.fry25@gmail.com
    ------------------------------
    • MatthewJones's avatar
      MatthewJones
      Qrew Trainee
      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
      ------------------------------
      • AndrewFry's avatar
        AndrewFry
        Qrew Assistant Captain
        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
        The Score fields would be formula numeric fields.
        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
        andrew.fry25@gmail.com
        ------------------------------
  • Here's some examples. 


    Example 1 - multiple choice text and convert to answer


    Q1 Formula (formula text)
     Case([Q1],
    "a. interact with many different people, strangers included.", "D",
    "b. talk one-on-one mostly with people you already know.", "N",
    "c. use the opportunity to make important contacts.", "A",
    "d. leave as soon as it is polite to do so.", "C")
    Total D's (formula numeric)
    var text letter = "D";
    
    var number a = If([Q1 Formula]=$letter, 1, 0);
    var number b = $a+ If([Q2 Formula]=$letter, 1, 0);
    var number c = $b+ If([Q3 Formula]=$letter, 1, 0);
    var number d = $c+ If([Q4 Formula]=$letter, 1, 0);
    var number e = $d+ If([Q5 Formula]=$letter, 1, 0);
    var number f = $e+ If([Q6 Formula]=$letter, 1, 0);
    var number g = $f+ If([Q7 Formula]=$letter, 1, 0);
    var number h = $g+ If([Q8 Formula]=$letter, 1, 0);
    var number i = $h+ If([Q9 Formula]=$letter, 1, 0);
    var number j = $i+ If([Q10 Formula]=$letter, 1, 0);
    var number k = $j+ If([Q11 Formula]=$letter, 1, 0);
    var number l = $k+ If([Q12 Formula]=$letter, 1, 0);
    
    $lā€‹



    Example 2 - show one question at a time (yes I made a progress bar out of the tabs with onclick goes to next tab, hey it works)



    Q3 Formula (formula rich text)
    var text divstyle = "style=\"width: 100%; overflow: auto; display: inline;\"";
    var text astyle = "style=\"width: 12px; display: inline;\"";
    var text pstyle = "style=\"border: 1px solid black; border-image: none; width: 250px; height: 75px; text-align: center; color: rgb(82, 87, 91); line-height: 70px; font-size: 20pt; text-decoration: none; display: inline-block; cursor: pointer;\"";
    var text optionone = "Submissive";
    var text optiontwo = "Self Sacrificing";
    var text optionthree = "Sociable";
    var text optionfour = "Strong Willed";
    
    
    "<div "& $divstyle &">" & 
    "<a "& $astyle &"onmouseover=\"$(this).children().css({'background-color':'#be1e2d', 'color':'#fff'});\" onmouseout=\"$(this).children().css({'background-color':'#fff', 'color':'#52575b'});\" onclick=\"$('#_fid_61').val('" & $optionone & "'); $(this).siblings().children('p').css({'background-color':'#fff', 'color':'#52575b'}); $(this).children().css({'background-color':'#be1e2d', 'color':'#fff'}); setTimeout(function(){var nextTabLink = $('li.ui-tabs-selected').next().children('a'); $(nextTabLink).click();},750); $('#tab_t3_link').css('background-color','lightgreen'); return false\">" &
    "<p "& $pstyle &">" & $optionone & "</p>" &
    "</a>" &
    "<a "& $astyle &"onmouseover=\"$(this).children().css({'background-color':'#be1e2d', 'color':'#fff'});\" onmouseout=\"$(this).children().css({'background-color':'#fff', 'color':'#52575b'});\" onclick=\"$('#_fid_61').val('" & $optiontwo & "'); $(this).siblings().children('p').css({'background-color':'#fff', 'color':'#52575b'}); $(this).children().css({'background-color':'#be1e2d', 'color':'#fff'}); setTimeout(function(){var nextTabLink = $('li.ui-tabs-selected').next().children('a'); $(nextTabLink).click();},750); $('#tab_t3_link').css('background-color','lightgreen'); return false\">" &
    "<p "& $pstyle &">" & $optiontwo & "</p>" &
    "</a>" &
    "<a "& $astyle &"onmouseover=\"$(this).children().css({'background-color':'#be1e2d', 'color':'#fff'});\" onmouseout=\"$(this).children().css({'background-color':'#fff', 'color':'#52575b'});\" onclick=\"$('#_fid_61').val('" & $optionthree & "'); $(this).siblings().children('p').css({'background-color':'#fff', 'color':'#52575b'}); $(this).children().css({'background-color':'#be1e2d', 'color':'#fff'}); setTimeout(function(){var nextTabLink = $('li.ui-tabs-selected').next().children('a'); $(nextTabLink).click();},750); $('#tab_t3_link').css('background-color','lightgreen'); return false\">" &
    "<p "& $pstyle &">" & $optionthree & "</p>" &
    "</a>" &
    "<a "& $astyle &"onmouseover=\"$(this).children().css({'background-color':'#be1e2d', 'color':'#fff'});\" onmouseout=\"$(this).children().css({'background-color':'#fff', 'color':'#52575b'});\" onclick=\"$('#_fid_61').val('" & $optionfour & "'); $(this).siblings().children('p').css({'background-color':'#fff', 'color':'#52575b'}); $(this).children().css({'background-color':'#be1e2d', 'color':'#fff'}); setTimeout(function(){var nextTabLink = $('li.ui-tabs-selected').next().children('a'); $(nextTabLink).click();},750); $('#tab_t1_link').css('background-color','lightgreen'); return false\">" &
    "<p "& $pstyle &">" & $optionfour & "</p>" &
    "</a>" &
    "</div>"ā€‹


    ------------------------------
    Everett Patterson
    ------------------------------
    • MatthewJones's avatar
      MatthewJones
      Qrew Trainee
      So i like the way example 1 looks, but how did you create it to look like that. I am still learning Quickbase so kinda lost on it.

      ------------------------------
      Matthew Jones
      ------------------------------
      • EverettPatterso's avatar
        EverettPatterso
        Qrew Captain
        Make a new field for question 1, Text - Multiple Choice and fill in each answer (a, b, c, d, e)


        Put the new field on your Form, and for the new field you should see the option to Display choices as radio buttons (instead of a dropdown) and change the label to the question


        ------------------------------
        Everett Patterson
        ------------------------------