How to assign scores for each option in different questions and get a summation at the end of all questions (composite index)

[ochaba]

Hi, I have difficulty in assigning scores for each option in a question. Some questions have three options and others have two options. At the end I want a summation of the scores based on options selected. The total score obtained will be used for categorization. I need help on this please.

[Kal_Lam]

Welcome to the community, @ochaba! Maybe these post discussed previously should help you solve your issue:

How to build an eligibility criteria from the weight assigned to certain conditions (composite index)

OK, here is the revised one. This should work as you outline: In the survey tab of your xlsform: [Image 1] In the choices tab of your xlsform: [Image 2] Data entry screen as seen in Enketo: when conditions are not met [Image 2.5] Data entry screen as seen in Enketo: when conditions are not met [Image 3] Data entry screen as seen in Enketo: when conditions are not met [Image 4] Data entry screen as seen in Enketo: when conditions are met [Image 5] Reference xlsform: Eligibility Cr…

This one too …

Calculate based on respondent selection (composite index)

OK, in this case you could do the same as outlined in the image shared below: In the survey tab of your xlsform: [Image 1] In the choices tab of your xlsform: [Image 2] Data entry screen as seen in Enketo: Mild [Image 3.1] Data entry screen as seen in Enketo: Mild [Image 3.2] Data entry screen as seen in Enketo: Severe [Image 4.1] Data entry screen as seen in Enketo: Severe [Image 4.2] Data entry screen as seen in Enketo: Very Severe [Image 5] Reference xlsform: Composite Inde…

And this one too …

Calculate using IF Formula with Multiple Expression (composite index/weighted score)

Well if this is your requirement, you could design your survey project using the following if-statement as outlined in the image shared below: In the survey tab of your xlsform: [Image 1] In the choices tab of your xlsform: [Image 2] Data entry screen as seen in Enketo: If option 1 is selected, the system gives a score of 3 [Output 1] Data entry screen as seen in Enketo: If option 3 or option 2 is selected with 1, the system gives a score of 3 [Output 2.1] Data entry screen as seen …

Here is another one …

Question Selection and point Calculation (weighted score/simple composite index)

Hi @PALASH9698, You could do this in a simple way as outlined in the image below: In the survey tab of your xlsform: [Image 1] In the choices tab of your xlsform: [Image 2] Data entry screen as seen in Enketo: [Image 3] Reference xlsform: Weighted Score Sample.xlsx (11.9 KB) Have a great day!

And this one too …

Hide field until 5 or more questions have been answered (composite index)

You could do the same as outlined in the image below: In the survey tab of your xlsform: [Image 1] In the choices tab of your xlsorm: [Image 2] Data entry screen as seen in Enketo: (when the conditions are not met) [Image 3] Data entry screen as seen in Enketo: (when the conditions are met) [Image 4] Reference xlsform: Severity_scale_V2.xlsx (12.6 KB)

And one more …

Assigning a certain value from a question's choice (composite index)

OK, you could do the same as outlined in the image shared below: In the survey tab of your xlsform: [Image 101] In the choices tab of your xlsform: [Image 102] Data entry screen as seen in Enketo: when no entries is made [Image 103] Data entry screen as seen in Enketo: when “Yes” is selected in Q1 [Image 104] Data entry screen as seen in Enketo: when “No” is selected in Q1 [Image 105] Reference xlsform: Weighted Score Sample.xlsx (11.4 KB)

One more …

Reverse score calculations (composite index)

Welcome to the community @ashirley! Maybe you could do the same as outlined in the image as shared below: In the survey tab of your xlsfrom: [Image 1] In the choices tab of your xlsform: [Image 2] Data entry screen as seen in Enketo: [Image 3] Reference xlsform: Weighted Score Sample.xlsx (11.7 KB)

And one final one …

How to calculate a weighted score (a simple composite index) while collecting data with KoBoToolbox?

Hi @bamaiyi, You could do this following the instructions outlined below: In the survey tab of your xlsform: [Image 1] Data entry screen as seen in Enketo: [Image 2] Reference xlsform: Weighted Score Sample.xlsx (10.2 KB) Have a great day!

[ochaba]

Thank you so much Kal_Lam. I found the illustrations very helpfull.

[ivonne_salamanca]

@ochaba

Hi, I have difficulty in assigning scores for each option in a question. Some questions have three options and others have two options. At the end I want a summation of the scores based on options selected. The total score obtained will be used for categorization. I need help on this please.

Hello everyone,

I’m Ivonne, I’m new to the community and to xlsforms and kobotoolbox. I searched in the forum for my issue, but didn’t quite find an answer, and probably it has a very easy solution, but I’ve spent hours trying to solve it with different options I found. I have 4 blocks of questions, and for each block I’m delivering a score to participants based on their responses. All blocks of questions are select_one, 3 blocks just yes/no/don’t know and the last block has other type of choices including “don’t know”. The scores are based specifically on a government assessment result and score which are the following:

,
,

.
I haven’t been able to make my calculations work when trying to include the “don’t know” choice. Could you please help me make calculations work and logical and based on the images?
Habitat condition survey_v6_4h_calc.xlsx (614.5 KB)

Thank you.