American Evaluation Association: Using Word and Excel to Analyze Qualitative Data- eStudy 130

Presenter:
Seth Tucker, Analyst, Evaluation and Learning

Extracting meaningful findings from qualitative data requires an evaluator to have the right tools to able to organize, code and immerse themselves in the data. This can be difficult when dealing with large amounts of data or when there is a lack of access, comfort level or desire in using coding software. However, rigorous and transparent qualitative analysis can be done using tools that many people are already familiar with – Microsoft Word and Excel. In this interactive workshop, Seth will provide participants with the steps and definitions they need to conduct rigorous qualitative analysis, and demonstrate how to use Microsoft Word and Excel to define, organize and analyze qualitative data in a way that is practical, efficient, rigorous and fun. Participants will leave this session with greater understanding of qualitative analysis and another tool in their qualitative data analysis toolbox without the need to buy or learn analysis software.

Learning Outcomes:

By the end of this course, participants will have a greater understanding of

• Different types of qualitative coding techniques, vocabulary and concepts
• Extracting findings and presenting qualitative data
• The necessary steps to collect data and conduct qualitative analysis
• How to code and analyze qualitative data in Word and Excel