Scoring of the correct/incorrect answers | XM Community
Skip to main content

Dear Qualtrics-masters, please help me with this issue.

 

For my master-research I have created a survey with 20 questions. Each question has 3 answer options of which only one is correct. 

In the scoring of the survey I chose 1 point for the correct answers and left the other two empty, assuming that in the end it'll score the total for 20 questions based on the number of correct answers.

See screenshot

 

Now I have the data exported to CSV as numeric values. The survey is long closed, so I can't correct the design of it (i didn't do any embedded things in the flow to calculate the score automatically, that was way to complicated for me).

 

And in the CSV file I see that it shows which answer the respondents chose, just number 1, 2 or 3. But didn't score if it was wrong or correct. As sometimes 1 was correct, sometimes 3 was correct, so just summing up the numbers won't help me to see how well they scored on the test.

 

 

How can I fix this? How can I export the data from Qualtrics into an CSV table, but then with 1 for correct answer and 0 for wrong answer.

HI,

You can add scoring categories even after data collection is over.

You probably already have a field in your dataset containing the total score (from 0 to 20). If you need a 0/1 field for each of your questions, you’ll need to create 20 scoring categories (one for each question) with 0 for the wrong answers and 1 for the correct one.

 

 

Thanks! 

For now I found out that if I recode values for each question and then export the data again then there will be correct numeric values for the wrong and correct answers in my file. I'll try this first.

Leave a Reply


Terms & Conditions