EXPERIENTIAL LEARNING
  • Home
  • Blog - Online Learning
  • Blog - Research
  • About
  • Media Coverage
  • Experiential Learning Examples
    • Experiential Learning Vietnam 2017
    • Monopoly for Teamwork
    • Learning in Hanoi
    • Hanoi Community Service
    • Saigon Starbucks Experience
    • Saigon Class Concert
    • Outside the Classroom
  • Blog - Personal

Analyzing qualitative data - excel & word (QDA)

6/2/2019

0 Comments

 
I have struggled to find the best way to compile and structure my interview data for analysis. The analytic methods will follow the direction provided by Saldaña (2015, pp. 14-15). These methods will include transcription of the recorded interviews, coding the transcribed data, categorizing the data, and developing themes and concepts. See Figure 3 below from Saldaña (2015, p. 14) for a graphic illustration of the process. The written report on the data will follow the recommendations of Saldaña (2015) and Seidman (2013). See the first figure below. This shows the process of developing categories and themes following coding of the interview data.

The challenge is in the process of finding an efficient method to analyze as many as 38 interviews, comprising first and second interviews from 19 participants. For researchers with similar challenges, I am sharing an article by Solveig Ose (2016) that provides a process to convert the MS Word transcripts of the interviews into tables in Excel for coding and analysis. See the second figure below. This is an illustration of the data copied from Word to Excel. This is part of the qualitative data analysis (QDA) process.
Picture
Figure 1. A model for moving from data through codes to themes and theories (Saldaña, 2015, p. 14).
Picture

Figure 2. Example of transcribed text in Excel (Ose, 2016, p. 5).
Ose, S. O. (2016). Using Excel and Word to Structure Qualitative Data. Journal of Applied Social Science, 10(2), 147–162. https://doi.org/10.1177/1936724416664948

Saldaña, J. (2015). The coding manual for qualitative researchers (Third ed.): Sage.
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    Paul mcafee

    This blog summarizes research about active and experiential learning that I have read, and research that I have conducted.

    Archives

    January 2020
    July 2019
    June 2019
    May 2019
    April 2019
    January 2019
    December 2018
    November 2018
    August 2018
    May 2018
    April 2018
    February 2018
    October 2017
    August 2017
    July 2017
    June 2017
    April 2017

    Categories

    All
    Active Learning
    Analyzing Interview Data
    Coding Interview Data
    EndNote
    Experiential Learning
    Honor Society
    NVivo
    Online Teaching
    Passive Learning
    Paul McAfee
    Problem Based Learning
    Problem-Based Learning
    Project Based Learning
    Project-Based Learning
    Qualitative Data
    Qualitative Research
    Research Interviews
    Research Paradigms
    STEM Higher Education
    Veteran
    Vietnam
    Vietnam Education Foundation
    Voyant Tools

    RSS Feed

Copyright 2013-2019 Paul McAfee
LinkedIn Profile: www.linkedin.com/in/paulmcafee