...
Let’s say you have a survey that’s made up of 3 questions.
For simplicity, each Question will only have 2 possible Answer Choices.
We will allocate Points to each Answer Choice. (Allocating of allocating Points to each Answer Choice is what you covered in step 2: Allocate points to each survey question's Answer Choices )
Question 1: What's your favourite food? has 2 answer choices
Cake = 2 points
Chocolate = 3 points
Question 2: what's your favourite drink? has 2 answer choices
Orange Juice = 5 points
Lemonade = 12 points
Question 13: what's your favourite place? has 2 answer choices
Beach = 20 points
Forest = 35 points
...
Now you need to set a formula that can be used to calculate a Total Survey Score for each respondent.
The formula can be extremely simple, e.g. simple additions, or you can make it more complex by using
Multiplying
Dividing
Subtracting
Brackets
as well as Adding
Let’s For example it could be Total Survey Score = Points from the answer to Question 1 multiplied by the Points to the answer to Question 2 minus 7 divided by Points from the answer to Question 3. But that's quite complicated! Although it is doable.
So let’s go with a simple example for now.
Let’s say the formula you want to use is "Total Survey Score = Points from the answer to Question 1 + Points from the answer to Question 2 + Points from the answer to Question 3",
You’ll add that formula using the Formula Popup on the survey’s page
Once you press save, Makerble is able to start calculating a Total Survey Score for each respondent.
...
Let’s imagine that James is one of your respondents. His answers to the three questions in the 3 question survey were are as follows:
Favourite Food = Cake
Favourite Drink = Orange Juice
Favourite Place = Forest
Makerble already knows the Points to allocate to each of these Answers. The points would be
Favourite Food = Cake = 2 points
Favourite Drink = Orange Juice = 5 points
Favourite Place = Forest = 35 points
Using the points, Makerble can now use your Formula to calculate the Total Survey Score for each respondent.
Given that the formula is: Total Survey Score = Question 1 + Question 2 + Question 3
Then plugging in the points for James looks like this: Total Survey Score = 2 + 5 + 35 = 42
So now we know the Total Survey Score for James is 42.
...
Let’s say that for the type of work you do, you consider
a Total Survey Score between 0 and 30 to be a FAIL
a Total Survey Score between 31 and 40 to be a PASS
and a Total Survey Score between 41 and 100 to be a MERIT
Makerble will let you add include those verdicts of Fail, Pass and Merit, to within your survey so that they can be pronounced automatically based on each respondent’s Total Survey Score. (This is what is covered in step 4: Assign a verdict to each range of scores)
See the change in Verdicts and Total Survey Scores over time
To make your reporting easier, Makerble will generate a table of survey respondents in each project and album
From here you can see how each respondent’s Verdict has changed over time (this is covered here See the Verdicts based on scores calculated from survey responses )
...
Steps: how to add a formula to a survey
Go to the Edit Survey page of the survey you want to calculate verdicts for (or stay on the Create Survey page if you are continuing from Part 2 and you have not yet pressed Save)
Scroll down to the bottom of the page
Press the text that says Advanced to open the Advanced Settings section
In the Formula section, press the Add Component button
This causes a popup to load
Within the popup: select Number
Then enter '1'
Then press Save in the popup
The popup closes
Scroll to the bottom of the page and press Save
You arrive on the Survey Template page
On the left of the Survey Template page is the Formula box. Click the Edit button
A popup appears. Press the Add coefficient button
Select the first dropdown list
Start the formula with a Number or an Indicator (an Indicator is a Multiple Choice question [progress tracker])
Based on the option you choose in the first dropdown, the option on the right side will update accordingly to allow you to
Select a mathematical symbol: Plus, Minus, Multiply, Divide
Select a multiple choice question
Enter a number
Press the Add coefficient button again to enter the next part of your formula
When you have finished adding the formula, press Save in the popup
The popup closes
The formula that you have added is now displayed within the Formula box on the left of the Survey Template page
Now you can move onto Part 4: How to assign a verdict to each range of scores
...