Skip to Main Content
It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.

QDA Workshop for EDD: Home

Qualitative Data Analysis Workshop

What is Qualitative Data Analysis?

QDA consists of both the exploration of qualitative data as well as the analysis of qualitative data in order to identify and measure patterns, themes, and trends.


In this hands-on workshop, we will cover:

  1. Exploring interview transcripts with BUTANE
  2. Coding surveys with Excel
  3. Introduction to NVivo

Download Workshop Materials

  1. State of the Union Addresses (Text files)
  2. Survey of Trump Supporters in 2016 (Excel)
  3. Interview Transcript from Baylor Institute of Oral History (Word)

 

Procedures

Data Used:Transcript_BaylorInstituteOralHistory_13288.docx

Tool Used: Butane: Baylor University Transcript Analytics & Exploration Tool

Analysis:

Investigate the 4 W's and the H:
This Jupyter Notebook is designed to walk you through 7 broad areas in order to explore your transcripts.

  1. Setup, where the Notebook installs all necessary libraries and you upload your transcript(s).
  2. Who is Speaking?, where you specify the narrators you want to analyze
  3. What are the Narrators Speaking About?, where you will explore word frequencies, word clouds, and topic modeling.
  4. Who, Where, and When are the Narrators Speaking About?, where you will identify locations mentioned by the speakers.
  5. How are the Narrators Speaking?, where you will identify the sentiment, or emotional tone, of the language used by the speakers.
  6. Why are the Narrators Discussing a Particular Topic?, where you will visualize words within proximity of targeted keyword searches.

Data Used: Survey_TrumpSupporters2016.xlsx

Tool Used: Microsoft Excel

Analysis: Coding (assigning thematic tags) to survey responses

  • Method #1: Create a new column in Column I named Codes and then assign codes by typing codes per row, separated by commas.
  • Method #2: Use the formula below in J2 to count the instances of a search term in J1. Can be copied to the right.

=SUM(LEN($H2)-LEN(SUBSTITUTE(LOWER($H2),J$1,"")))/LEN(J$1)

Analysis: Visualizing (time and interest permitting)

  • Pivot Table
    • Rows: State
    • Values: A coding column
  • Copy and paste values to another sheet
  • Insert map

Tip: To use this method with transcript(s), use BUTANE and export step 5 (sentiment) to Excel.

Link to NVivo Walkthrough

Overview:

  1. Importing: Unstructured documents, transcripts, surveys
  2. Coding: Manual, keyword searching, auto-coding, (also machine learning, but not covered here)
  3. Case attributes
  4. Exporting

University Libraries

One Bear Place #97148
Waco, TX 76798-7148

(254) 710-6702