Qualitative and Quantitative Analysis Techniques for Qualitative Data

Learn how to use Excel and other computer-assisted tools to turn evaluation interviews into clear and useful findings!

This intermediate level workshop introduces techniques for analysing qualitative data such as interview results. By the end of the workshop, participants will be able to conduct these types of analyses in a clear and systematic manner. The workshop will review the main techniques using MS Excel. A general overview of computer-assisted qualitative analysis software will also be presented. Key techniques will be presented step-by-step, using a real-life case study. An Excel file workbook will be provided so that workshop registrants can apply the techniques discussed directly. Among other things, best practice in quantifying data using percentages and proportions will be discussed, as will the pros and cons of quantifying qualitative data.

Learning outcomes: Apply qualitative and quantitative analysis techniques for qualitative data, understand the pros and cons of quantifying qualitative data

Course Competencies:

Technical practice

• Collect, analyze and interpret data using appropriate methods.
• Use findings to answer evaluation questions and, where appropriate, to develop recommendations

Reflective

• Know evaluation theories, models, methods and tools and stays informed about new thinking and best practices.
• Use self-awareness and reflective thinking to continually improve practice

About the Qualitative Evaluation Series:

This workshop is part of the Qualitative Evaluation Series, a two-part learning opportunity focused on qualitative data collection and analysis for program evaluation professionals. Feel free to register for either session in the series as your learning needs require! Participants who register for both sessions can receive a 10% discount on registration costs. Contact us to learn more!

About the Facilitators:

Simon Roy, PhD, CE is a GGI Senior Associate and has over 28 years of program evaluation experience. Simon has a PhD in Sociology (University Paris -Nanterre) and is a Credentialed Evaluator. Since 2001, Simon has facilitated multiple intermediate level and advanced level workshops for the Canadian Evaluation Society, at national conferences and for many chapters. He has also designed courses for the CES, including the current version of the online survey course; he delivered this course multiple times. Most recently he delivered a half-day workshop at the CES Conference in Quebec City on qualitative and quantitative approaches to analyzing qualitative data. He is also part-time professor at Ottawa University and l’École nationale d’administration publique, where he teaches program evaluation and performance measurement at the graduate level on a regular basis. Simon is also a published author. He recently published a book chapter on the professionalization of evaluation (with B. Gauthier).

Pascale Latulippe, MA is a Senior Consultant at GGI with more than 5 years of experience working in program evaluation. Pascale has a Graduate Diploma in Program Evaluation (University of Ottawa), a Master’s degree in International Development (University of Queensland), and, a Bachelor degree in Peace & Conflict Studies (University of Toronto). Pascale has co-facilitated a number of workshops including this half day workshop at a Canadian Evaluation Society Conference.