EXPERIENTIAL LEARNING
  • Home
  • Higher Education Topics - Blog
  • Applied and Experiential Learning - Blog
  • Research & Teaching Critical Thinking - Blog
  • About
  • Media Coverage
  • Experiential and Applied Learning Examples
    • Experiential Learning Vietnam 2017
    • Monopoly for Teamwork
    • Learning in Hanoi
    • Hanoi Community Service
    • Saigon Starbucks Experience
    • Saigon Class Concert
    • Outside the Classroom

Excel & Word for qualitative data analysis

6/16/2019

0 Comments

 
I have continued to experiment with the use of MS Excel and Word to analyze qualitative date -- in this case, interview data for my PhD dissertation. The method described by Ose (2016) is amazing, although it has a few disadvantages.

Disadvantages include having online one major code for each interviewee quote. In my spreadsheet, I have an additional column for a secondary code, but I do not include that column when going through Ose's (2016) steps to convert the Excel file for Word. I use the added column as a reference as I work with the Word file during my secondary coding, categorizing, and creation of themes.

If you use her method as described in her paper, you will need to enlarge the Figure 10 and 11 screen shots. The concatenation instructions are complex, but trust what she writes, and pay special attention to the following on page 9:
F1 cell: =CONCATENATE(D1;"(";A1;"_";B1;"_";C1;")")
The "_" underscore symbols represent spaces, not use of the symbol, and in my instance of Excel, the semicolons were commas when I used the Function feature to create this string.

This is what the formula looks like in my file: 
=CONCATENATE(D1,"(",A1," ",B1," ",C1,")")

The screen shot below is Ose's (2016) Figure 6 image on page 9. Keep in  mind that there are additional "Text" boxes that aren't visible in this image.

Reference
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


Picture
#dataanalysis #qualitativedata #interviewdata
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

    March 2023
    February 2023
    January 2023
    December 2022
    July 2022
    June 2022
    January 2022
    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