Code frame tab
The Code frame tab in your output Excel file contains the complete list of themes and ideas (codes) used to categorize your verbatim responses. This tab is essential for reviewing your coding structure and for further quantitative analysis.
What does the code frame tab show?
- All themes and ideas: Every code used in the thematization process, organized by main themes and sub-themes.
- Occurrences: The number of times each idea or theme appears in your coded data.
- Structure: The hierarchical organization of your code frame, making it easy to see how ideas are grouped.
Structure of the tab
Each row typically includes:
- The code (e.g., 100, 101, 102)
- The label or description of the theme/idea
- The count of occurrences (can be calculated using Excel formulas)
Example
| Code | Theme/Idea | Occurrences |
|---|---|---|
| 100 | Design | 12 |
| 101 | Likes the design | 7 |
| 102 | Modern look | 5 |
| 200 | Performance | 9 |
| 201 | Powerful | 6 |
How to use the code frame tab
- Count occurrences:
Quickly count how many times each idea appears by using Excel formulas, such as:
=COUNTIF(Thematization!C:C, CodeFrame!A2) - Review structure: Ensure your code frame is logical and comprehensive.
- Adjust and iterate: If you notice important ideas with low or zero occurrences, consider refining your code frame and re-running the codification.
Adding subtotals and NETS
- You can add your own subtotals or NET groupings in this tab for reporting purposes (e.g., combining several codes under a broader category).
tip
The code frame tab is your reference for the structure and coverage of your qualitative analysis. Use it to validate your coding and to support further quantitative work.