Survey results format
Is there a way to get student survey results in a data-analysis-friendly format? That is, each row of data contains answer for one student, and each column is for one survey question, like this:
User Class standing Gender Tattoos? Number of tattoos Politics Handedness GPA Major Beverage Random number States
1 Sophomore Female Yes 1 Liberal Right-handed 3.6 Business (Marketing) Tea 2 17
2 Junior Male No 0 Moderate Right-handed 3.4 Biology Neither 7 15
But the available report format looks like this:
Section # Q # Q Type Q Title Q Text Bonus? Difficulty Answer Answer Match # Responses
User 1
1 MC ' Class standing (Year) First-year UnChecked 0
1 MC ' Class standing (Year) Sophomore UnChecked 1
1 MC ' Class standing (Year) Junior UnChecked 0
1 MC ' Class standing (Year) Senior UnChecked 0
1 MC ' Class standing (Year) Graduate student UnChecked 0
1 MC ' Class standing (Year) Other UnChecked 0
2 WR ' Gender Female 1
3 MC ' Do you have any tattoos? Yes UnChecked 1
3 MC ' Do you have any tattoos? No UnChecked 0
4 SA ' How many tattoos do you have? 1
5 MC ' When it comes to politics, would you describe yourself as liberal, moderate, conservative, or other? Liberal UnChecked 1
5 MC ' When it comes to politics, would you describe yourself as liberal, moderate, conservative, or other? Moderate UnChecked 0
5 MC ' When it comes to politics, would you describe yourself as liberal, moderate, conservative, or other? Conservative UnChecked 0
5 MC ' When it comes to politics, would you describe yourself as liberal, moderate, conservative, or other? Other UnChecked 0
6 MC ' Do you consider yourself left-handed, right-handed, or other? Left-handed UnChecked 0
6 MC ' Do you consider yourself left-handed, right-handed, or other? Right-handed UnChecked 1
6 MC ' Do you consider yourself left-handed, right-handed, or other? Other UnChecked 0
7 WR ' What is your current GPA? Recall, you may skip any questions you want, and you don't have to provide accurate information! 3.6 1
8 WR ' What is your major? Business (Marketing) 1
9 MC ' Which do you prefer: Coffee or Tea? Coffee UnChecked 0
9 MC ' Which do you prefer: Coffee or Tea? Tea UnChecked 1
9 MC ' Which do you prefer: Coffee or Tea? Neither UnChecked 0
10 SA ' Pick a random number from 1 to 10 2
11 SA ' How many U.S. states have you been to? 17
User 2
1 MC ' Class standing (Year) First-year UnChecked 0
1 MC ' Class standing (Year) Sophomore UnChecked 0
1 MC ' Class standing (Year) Junior UnChecked 1
1 MC ' Class standing (Year) Senior UnChecked 0
1 MC ' Class standing (Year) Graduate student UnChecked 0
1 MC ' Class standing (Year) Other UnChecked 0
2 WR ' Gender Male 1
3 MC ' Do you have any tattoos? Yes UnChecked 0
3 MC ' Do you have any tattoos? No UnChecked 1
5 MC ' When it comes to politics, would you describe yourself as liberal, moderate, conservative, or other? Liberal UnChecked 0
5 MC ' When it comes to politics, would you describe yourself as liberal, moderate, conservative, or other? Moderate UnChecked 1
5 MC ' When it comes to politics, would you describe yourself as liberal, moderate, conservative, or other? Conservative UnChecked 0
5 MC ' When it comes to politics, would you describe yourself as liberal, moderate, conservative, or other? Other UnChecked 0
6 MC ' Do you consider yourself left-handed, right-handed, or other? Left-handed UnChecked 0
6 MC ' Do you consider yourself left-handed, right-handed, or other? Right-handed UnChecked 1
6 MC ' Do you consider yourself left-handed, right-handed, or other? Other UnChecked 0
7 WR ' What is your current GPA? Recall, you may skip any questions you want, and you don't have to provide accurate information! 3.4 1
8 WR ' What is your major? Biology 1
9 MC ' Which do you prefer: Coffee or Tea? Coffee UnChecked 0
9 MC ' Which do you prefer: Coffee or Tea? Tea UnChecked 0
9 MC ' Which do you prefer: Coffee or Tea? Neither UnChecked 1
10 SA ' Pick a random number from 1 to 10 7
11 SA ' How many U.S. states have you been to? 15
