Rainbow Spreadsheets
A rainbow sheet consists of a spreadsheet where researchers can document behavioral patterns presented by users and testing (or observation) participants. Every time a participant exhibits a new note-worthy behavior the researcher writes the observation in the left-most column of the rainbow sheet. Towards the right of the observations, each participant is assigned a color and a label. If a participant performs a recorded behavior (or observation), the participant’s cell is filled in with the participant’s assigned color.
The rainbow sheet could be used during or after user testing sessions. If it’s used during the testing sessions, every note-worthy behavior should be added efficiently under the observation column. It requires a significant amount of attention and effort from every observer and researcher. If it’s used after user testing sessions, a quick debrief after each testing session is recommended. It ensures every team member contribute to the Rainbow Sheet, because most importantly, the rainbow sheet is a collaborative tool.
ADDITIONAL RESOURCES:
The Rainbow Spreadsheet: A Collaborative Lean UX Research Tool
The Rainbow Sheet: A Visual Method for Research Analysis
The Rainbow Sheet – A Collaborative Tool to Quickly Generate Insights from User Testing
Source: Source: https://uxdesign.cc/the-rainbow-sheet-a-visual-method-for-research-analysis-a7e7d2011058
Source: http://ixd.prattsi.org/2019/11/the-rainbow-sheet-a-collaborative-tool-to-quickly-generate-insights-from-user-testing/
« Back to Glossary Index