Calculating SUS Score With Google Form

This 3 minutes demo intended to demonstrate how to compute the SUS Responses from Google Form.

As I have mentioned before during the class, for questions [1,3,5,7,9] found in SUS questionnaire are all in positive sentiment. Whereas for questions [2,4,6,8,10], there are about negative perceptions that the user felt after interacting with your prototype.

For questions in the sequence of odd number, you would need to minus the receive Likert Scale response with the value of 1, whereas for even number question, we would need to use a value of 5 to minus the given Likert response.

Then, the sum of the total score for question 1-10 has to be multiplied by the value of 2.5.

[Thebobwil]

Here is the formula for the first part if it helps anyone (make sure it fits your sheet):

[WGLYYL]

You saved my day haha, reading articles abt how to calculate this is still a bit confusing for me

[viniared]

Thank you a lot! This video is really straightforward and helpful!

[robearle]

REally great demo thanks for the help!

[ClaireDurrantUX]

You know if you click on the corner of the cell with the formula and drag it down, it will apply the formula to the rows beneath?

The formula looks good, but you cannot just copy this to the next rows. Your second row for example is an even number, while your first row is an uneven number.

[vanessaavalos]

Thank you a lot! This video is really straightforward and helpful!