Card sort analysis using a spreadsheet
Saturday, December 23rd, 2006
Following up from Digital Web Magazine and my card sort article, here is one way of analysing your results using a spreadsheet.
In the spreadsheet we need to set up two tables which will sit next to each other:
- Table 1 stores the number of users and their cards.
- Table 2 counts cards and identify patterns.
Download your own copy of the spreadsheet to tinker with, at http://www.ruthstalkerfirth.com/CardSortSample.xls

