Why uses spreadsheet in usability studies?
When you are during the usability studies. You might be taking notes on all of the observations on a single piece of paper. So you are going to have a lot of pieces of paper. You’ll need to organize all of the observations in one place. A simple and easy method is called spreadsheet note-taking.
No, let’s do that. To create your spreadsheet structure, you can use Google sheet, Microsoft Excel.
For example, we have 3 participants in these studies. So add each participant to their own column at the top of the spreadsheet.
And in the left row add your observations. You can fill up these rows before start studies whit participants when your tasks were ready for the start.
All of the observations were divided into three categories:
Note: We use four colors to distinction the categories.
- When they complete their tasks, it was easy or difficult, etc.(blue)
- Their feedback for usefulness. (red)
- Their ton of voice. (green)
You can attach plus rows when observations do not fit into three categories, black color for these rows.
If the observation was true, add 1 and if it was false, it’s empty.
Great job. You have a spreadsheet for organized moderated or unmoderated usability studies.