Ketso doesn’t do your analysis for you, but there are some really useful ways you can quickly get a sense of the key ideas.
The Ketso Analysis Spreadsheet allows for sorting and analysis of data from multiple felts from one or more workshops with the same focus. A series of simple forms in the spreadsheet leads you through the process of entering the ideas from each leaf.
The spreadsheet allows you to sort and filter by theme (branches on the felts),type of question asked (colour of leaf) and level of priority of the ideas (whether or not participants placed icons by the ideas).
There is a button called ‘Charts and Tables’ that automatically produces charts from the data you enter. You can use these charts a report to show the distribution of different types of ideas overall and the distribution of ideas by theme. It can be informative to see which themes have ideas around what works, versus problems, or where most of the suggestions for improvement are clustered.
You can also add your own cross-cutting themes, and generate charts showing the distribution of types of ideas by the themes you have developed.
We recommend that you enter the leaves from all felts from the same workshop into one spreadsheet, so that you can analyse ideas from several groups and see patterns across the felts.
The spreadsheet for recording the results from a Ketso Action Planning grid, such as an action plan or evaluation matrix, is useful not just for recording the results, but also as an ongoing way of managing a project and recording and developing actions.