Survey assessment trouble with multiple dropdowns in csv

Meg_J631

We have created a survey quiz - using classic quizzes- and have a multitude of multiple dropdown questions. We are looking to analyze the variables in the dropdown menu.

Here is one of our questions:

Please indicate how much you agree with the following statements about your alcohol use:
"I feel it is important to..."

Set limits on my own drinking	[set]
Stick to the limits that I set for myself.	[stick]
Resist pressure to drink.	[resist]

Dropdowns: Strongly agree, Agree, Neither agree nor disagree, Disagree, Strongly disagree

For this question we would like to know what percent of students "Strongly Agree" that it is important to set limits on my own drinking. 

The problem is the csv file reports the responses to all 3 variables in one cell. 

EXAMPLE:

	Please indicate how much you agree with the following statements about your alcohol use: "I feel it is important to..." Set limits on my own drinking [set], Stick to the limits that I set for myself [stick], Resist pressure to drink [resist].
Jane Doe	Strongly agree, disagree, agree
John Smith	Strongly disagree, disagree, disagree

Is there any way to separate out multiple drop down responses in the CSV - we have over 1500 response so doing it by hand seems tedious.

Additionally, before we reached 1,000 survey responses Canvas was showing us responses by variable so it seems odd that it wouldn't also export that way.

Chris

Hi @Meg_J631,

Are you opening the CSV file in Excel?  if so, there is a handy function in there called "Text to Columns," which I think will do exactly what you want.  Highlight the column with the three answers, then go to the data menu, and click the "Text to Columns" button there.  A guide should then pop up.  You'll choose delimited on the first screen, then select Comma as the delimiter on the next screen and click Finish.  That should separate the data into three columns for you!

Hope this helps!

-Chris