How to calculate for a passing mark

  • Profile Image
    Sandy_Green
    Asked on December 09, 2020 at 09:01 AM
  • Profile Image
    Sam_G
    Answered on December 09, 2020 at 09:51 AM

    HI Sandy_Green,

    Thank you for contacting Support.

    Here's my test form: https://form.jotform.com/203433598472966. You can make a test submission and see how it works. If that's what you are expecting, then you can follow the steps below: 

    1. First, all my questions that will be scored are in the "Single Choice" field, this is optional and you can use other fields. 

    15045973762017-09-05_15-31-01.png


    2. Now the radio button, checkboxes, drop-down fields can have a calculation value. Here's a guide about it: https://www.jotform.com/help/301-How-to-Assign-Calculation-Value. You can find that option under the "Properties" window of the field. 

    15045977082017-09-05_15-33-43.png

    3. In my case, I have two options "Yes" and "No". For testing purposes, I'll set a value of "1" to "Yes", which means this is the correct answer and have a value of 1 point. While the "No" option will have "0". Now do the same with the other fields. 

    15045977712017-09-05_15-34-22.png

    4. I will then add a Form Calculation widget, this is where the calculation of the scores will happen. 

    15045978042017-09-05_15-40-21.png

    5. In the Form Calculation widget, I'll simply add all the 5 question fields. Basically, I have a 5 point scoring here. Of course, you can have your own calculation. 

    15045976102017-09-05_15-41-23.png

    To perform calculations, please check the following guides:

    Calculation using the Form Calculation widget: https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget 

    Calculation using the Conditional Logic feature: https://www.jotform.com/help/268-Conditional-Logic-Inserts-Text-Calculation-Into-A-Field 


    6. We don't want the score to show up in live preview, so we will hide it. 

    15045976462017-09-05_15-41-40.png


    7. Next is that we want to inform our users if they pass or not. Depending on what you prefer, you can inform them by email or by a custom "Thank You" page. But the main feature we'll use here is the Conditional Logic.

    I'll use a custom "Thank You" page here. Below, navigate to Settings->Conditions and select Change "Thank You" Page.

    15045979162017-09-05_15-39-49.png


    8. Here you can set conditions on what message to display based on an input or a value of a field. Here, I'll set an "IF" statement that says that if the "Score" is less than 3, which means 2 and below then show a custom message. 

    15045979362017-09-05_15-45-24.png


    9. Now the custom message is shown below. You can see that I'm using {score} / 5, which will inform the user of his score. You can get the {score} tag under the "Form Fields" drop down option in the text editor. 

    15045979552017-09-05_15-45-06.png


    Now repeat steps 7-9 to create another condition for the passing mark. 

    To learn more about conditional logic on how to change "Thank You" messages, you can check this guide: https://www.jotform.com/help/372-How-to-Change-Thank-You-Message-Using-Conditional-Logic


    For the email, this is somewhat similar. You can create multiple email alerts, then create a condition to trigger those email alerts based on the score value. 

    To learn more about the email alerts, you can check this guide: https://www.jotform.com/help/30-Explanation-of-Email-Notification-and-Autoresponder-Settings

    To learn how to trigger the email alerts based on conditions, you can check this one: https://www.jotform.com/help/167-How-to-Send-Email-Based-on-Selection 


    I hope that helps.