Prepare Survey Data

Purpose

Prepares data for analysis

Responsible Party

Project Lead 

Interdependencies

Survey data collection is complete

Directions

1. Open

   Download the surveydata onfrom Qualtrics.

Qualtrics
2. Exporting Data from Surveys in Qualtrics

   1. Navigate to DataQualtrics

   and

   2. exportClick the project's survey

   data

   

   to

   3. Excel. DownloadClick "Data & Analysis"

   

   4. Click "Export & Import"

   

   5. Click "Export Data..."

   

   6. Click "Excel"

   

   7. Click "Use choice text.text"

   

   8. Click "

Download"

3. 

   9. Save the file into the project's folder on Box.

Box

4. Clean the data

   Clean survey data in Excel

   1. Open the file.

survey
5. Checkdata Excel file

   

   2. Click here to select all cells

   

   3. Click "Wrap Text" twice to turn it off in all cells

   

   4. In column C, look for any rows that contain Survey Preview

   

   5. Right-click the firstRow fewHeader

   

   6. Click "Delete"

   

   7. Select Columns A–Q

   

   8. Right-click the Q Column Header

   

   9. Click "Delete"

   

   10. Click the A Column Header

   

   11. Right-double-click the A Column Header

   

   12. Click "Insert" to add a column

   

   13. Click here

   

   14. Type "Document Name [[Enter]]"

   15. Type "Project-Survey-001 [[Enter]]"

   16. Select the anchor point of the cell and drag it down to fill all rows []with andnames deletein anysequence

   entries

   

   (entire

   17. rows)Review that+ cameensure fromall Surveycolumns Preview.

6. Confirm that each column hashave a shortshort, descriptive name in therow second row.2. If anynot, areuse missingrow or1 unclear,to create them based onunderstand the column's question (found in row 1).
7. Add a column at the beginning of the spreadsheet called "Document name". In the first row,and create a name thatin includesrow 2

   

   18. Select and delete row 1

   

   19. Select any cells with numbers

   

   20. Click the project,Number Format combo box

   

   21. Click "survey",Number" andto endingconvert infrom 001.

text
8. 》example:to project-survey-001
   
numbers.
9. FillRepeat for all numbers.

   

   22. Save the seriesfile

   down

   

   the column until every entry has a document name.
10. Delete the [#] columns.
    
11. Qualtrics often saves numbers as text. Convert the format to "number."

12. Survey data is prepped when each row has a Document Name, each column has a descriptive name,name in the header, and number data is formatted correctly. 

Resources

None