Day 17: Scoring Question Answers
Previous Topic  Next Topic 

In the last lesson we asked you to. If you have not done that, go back and do it now before continuing with this lesson.

This lesson will show you how to give MENU question answers a score that can later be summoned in calculations.


Now do the following.

    1. Create a new survey and save it “Day 17”. Change the QUESTION PROMPT in QUESTION ZERO so that it reads “Name”, making sure it remains a TEXT question.

    1. Create a NUMBER question titled “Age”. Set the NUMBER OF DIGITS so there are only 2 whole parts. Select an OPTIONAL size check with a lower limit of “0” and an UPPER LIMIT of “99”. Set the NAVIGATION to SPIN BUTTONS.

    1. Add a MENU question with a prompt of “Gender”. Give it two choices “Male” and “Female”. Create another MENU question named “Do you like wine?” Add two choices “Yes” and “No”.

    1. Create another MENU question called “How many bottles do you drink per week?” Add 4 choices “1 – 2”, “3 – 5”, 6 – 9” and “10 +”. Now drag out the dividing bar to the left of the MENU column so you can see the number 0 aligned with each menu choice in a separate column. This column is used to score question answers so that these numbers can later be summoned usually for analytical purposes. You should add a score of “1” for the MENU choice 1 – 2, “2” for 3 – 5, “3” for 6 – 9 and “4” for 10 +. INSERT the question.

    1. The _MENUSCORE is an inbuilt system variable that comes automatically from PocketSurvey. System variables are recognisable by all containing an underscore before their name. In order for you to collect the menu score from a question answer, you must create a _MENUSCORE system variable using a CALCULATION question. This must be done before another MENU question with scoring is created. Add a CALCULATION question with a question prompt of “M1”. Select _MENUSCORE from the VARIABLE menu so that it appears in the EXPRESSION box. Set the DATA DESTINATION FILE to NONE and INSERT after the question, HOW MANY BOTTLES DO YOU DRINK PER WEEK?

    1. Create a MENU question named “Are you a smoker?” with two choices “Yes” and “No”.

    1. Create a MENU question entitled “How many cigarettes do you smoke per week?”. Add six menu choices:

“0 – 10”, “10 – 30”, “30 – 50”, “50 – 70”, “70 – 100” and “100 +”.

Give them all number scores from “1” to “6” (“1” for 0 – 10 etc…).

    1. Again create a CALCULATION question to collect the menu score with a question prompt “M2”. Add the system variable _MENUSCORE to the EXPRESSION box. Make sure the DATA DESTINATION FILE is set to NONE.

    1. Create a MENU question with the question prompt “Do you eat fast food?” with two menu choices “Yes” and “No”.

    1. Create another MENU question titled “Fast food meals consumed per week”. Add 6 menu choices scored from 1 to 6 of:

“1 – 2”, “3 – 4”, “5 – 6”, “7 - 8”, “9 – 10” and “11 +”.

    1. Create a CALCULATION question that collects the menu score with a question prompt “M3”.

    1. Add a MENU question called “Do you regularly exercise?” with two choices, “Yes” and “No”. Score NO with the number “5”. Create a calculation question to collect the menu score entitled “M4”.

    1. Next add a CALCULATION question and give it the question prompt of “Total”. Add the following expression in order to add up each menu score:

{{M1}} + {{M2}} + {{M3}} + {{M4}}

In order for your TOTAL score to mean anything coherent, you need to set up an IF ELSE CALCULATION. This will use your total score to provide you with a relevant end message derived from your question answers. Create a new CALCULATION question named “Overall”. Click in the EXPRESSION box and select the IF ELSE button twice.

    1. We want to set up the expression so that a score under 7 displays one message, a score between 8 and 14 displays another message and a score over 15 displays another different message. Your EXPRESSION box should contain the following:

IF ({{Total}} < 7) "you are in good health"

ELSE IF ({{Total}} > 15) "your health is terrible!"

ELSE "your health can be improved."

    1. The survey is nearly complete but it needs to be set up so that the user is guided through the survey depending on their question answer choices. Click on the question, DO YOU LIKE WINE? In the JUMP TO column next to the MENU choice NO, select ARE YOU A SMOKER? from the list. This prevents anyone who doesn’t like wine being asked any further questions on the subject and will skip them to questions about smoking.

    1. Now select the question, ARE YOU A SMOKER?. Set up this question so that if you select NO, you will jump to the question, DO YOU EAT FAST FOOD?. Go to the question, DO YOU EAT FAST FOOD? and set this to jump to, DO YOU REGULARLY EXERCISE? only if NO is selected.

    1. Now all that is left to do is create a MESSAGE question that will display all of these variables. Call this question “Message” and enter the following text in the TEXT TO DISPLAY box:

You got a score of {{Total}}. This means {{Overall}}

    1. {{Total}} will be display your total collected menu score, and {{Overall}} will display which message is appropriate from the OVERALL question.

The next lesson will be a continuation of what you have leant today. You will learn more about the calculation IF ELSE question and how it can be used to generate analytical messages in your survey.

Final Tip

HandHeld Systems Ltd ©