Skip to main content

Prepare Interview Data

Purpose

Preparing the data for analysis in MAXQDA

Responsible Party

Project Lead 

Interdependencies

Interviews have concluded + data has been downloaded from Qualtrics and cleaned

Directions

For MAXQDA analysis:

  1. Open CLEANED data set (if there is not one, you will have to go to qualtrics, export the data, then save as with a .xlsx)
  2. Delete all columns up to the "fulfilling" question. 
  3. Add two columns to the far left, titling the first, "Document Group," and the second, "Document Name."
  4. The document group column will be the same for the whole set. (Ex. Project-typeofdata, ITCC-Interview) Type in the first cell and copy for all cells in that column.
  5. The document name will be a unique code for each row. Label the first cell: Project-XX (ITCC-01), then drag down to apply to the rest of the column.
  6. For MAXQDA, the headers will become the code that organizes questions, make sure that those codes are representative of the data. For example, some headers may read, "Space_Dislike_1" where the next row down tells us that it is about individual workstations, so you would want to change, "Space_Dislike_1" to "Dislike_Individual Workstation."
  7. Ensure that all headers are updated and SaveAs.
Resources