If you are here you probably have an idea what is System Usability Scale, if not there are plenty of information online to learn more about it. The problem with SUS is that it requires some calculation and I was not able to find a tool that can handle both Matrix survey and SUS calculations so I decided to come up with my own solution.
Like always I am using my blog as a note taking tool for my future reference, but if someone else find it useful, it will be my pleasure.
That’s what I did
- Setup you Matrix survey on Qualtrics and publish it
2. Once you have some inputs from users, go to Data&Analysis =>Export Data => Excel => Download all fields
3. Open the file, select and copy all the responses to another Excel sheet.
Your another Excel sheet should look something like this.
Basically what we do here is using formula to match text with points:
Strongly Disagree: 1 point
Disagree: 2 points
Neutral: 3 points
Agree: 4 points
Strongly Agree: 5 points
Here is a formula I am using to convert text into points:
=IF(AND(B2=”Agree”), 4, IF(OR(B2=”Disagree”), 2, IF(OR(B2=”Strongly Disagree”), 1, IF(OR(B2=”Neutral”), 3, IF(OR(B2=”Strongly Agree”), 5)))))
Calculating X (odd):
=(SUM(L2,N2,P2,R2,T2))-5
Calculating Y (even):
=25-SUM(M2,O2,Q2,S2,U2)
Total SUS score
=(W2+V2)*2.5
Some resources I was using:
Simplifying Data Analysis: Mastering Excel’s IF Statements with Multiple Conditions
The IF function is really versatile and can be used in all sorts of ways to make logical comparisons and return…
System Usability Scale: What it is, Calculation + Usage
Learn more about the uses of the system usability scale with examples of questions used in a SUS questionnaire and also…
If you want to use my file, you can download it here