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

Answers

  • Jennifer.W.973
    Jennifer.W.973 Posts: 355 🎆

    @David.R.97 Hi David, I created a video to show our instructors how to pivot survey results from Likert questions in Excel to get the data in a better format. You'll need to clean the data first to get rid of the UnChecked 0 rows and repeat the User number at the beginning of each row, then you can do a PivotTable. You should be able to use many of the steps in the video even though you are using different question types in your survey. https://jenniferlynnwagner.com/d2l-survey-reports.html

  • Hi @David.R.97 - As a first step - I'd suggest checking out the Survey Results Advanced Data set to see if this gets you on the right track: https://community.d2l.com/brightspace/kb/articles/4539-list-of-advanced-data-sets#survey-results

    This should get you started with the results regarding how the surveys are organized. The results you are looking for are certainly very specific to your organization and if you'd like D2L to assist in building something out for your organization we certainly have our Learning Analytics offering that can assist with that for you. Please contact your client sales executive and they can help you out with more information.

    We generally provide all the information to allow people to consolidate the information in a manner that best fits their organization's needs.

    I found this link via Google that might be of assistance.

    If you want to do something on your own, I'd suggest using a combination of the advanced data set with Pivot tables for small-scale use and that hopefully can get your data combined in a manner that might be a bit more consumable.

    Appreciate it's a bit of information overload, but designed to be that way for allowing the data folks dig deep into the information.

    Let me know if you have additional questions — Bruce