Google Sheets analysis (Qual)

Purpose

The purpose of qualitative analysis in a DORIS research project is to identify themes and patterns in experience through organizing, coding, and sorting/filtering data from stakeholder interviews.

Responsible Party

Project Strategist, Research Associate

Interdependencies

The data has been downloaded from Qualtrics and cleaned. People have been assigned to analysis.

Directions

1. Copy data from Raw Data spreadsheet and paste into the appropriate theme/bucket sheet (tabs along the bottom)
2. Copy data one column/question at a time
3. Organize like content into rows and write a description of the content into the Possible Finding column.
   
4. You don't have to keep all the text from a cell in the same row, and data can be duplicated into multiple themes if needed
5. If needed, create new "Bucket" tabs for emergent themes
6. Once you have sorted all the data from a question/column, turn the Question cell gray on the data tab to indicate that it's bucketed.

Resources

Google Sheet Interview Analysis Template