Viewing and Exporting Survey Results | HelioCampus Assessment Management Knowledge Base

Exporting Aggregate Results

Standard options (1) can be used to export all aggregate results to CSV, Excel, or PDF, or to print. Additional, more customizable exports can also be utilized:

Without Text Responses (2): Exports aggregate results to PDF format or print and excludes all responses to any text/memo question types included on the survey form. The export will only contain aggregate results for all multiple-choice question types.
Open-Ended Responses (3): Exports aggregate results to PDF format or print and excludes all responses to any multiple-choice question types. This export option generates a document containing aggregate results for all text/memo question types.

Exporting Individual Results

CSV and Excel Exports
Questions With Responses	Exports a CSV or Excel file containing all of the questions and the responses. Each question that was answered will appear in its own row; if a question was not answered, it will be excluded from the export.
All Questions	Exports a CSV or Excel file containing all of the questions and responses, including rows for questions to which the users did not respond. Each question, regardless of whether or not it was answered, will appear in its own row.
Questions with Responses – Question Columns	Exports a CSV or Excel file containing one row per respondent. If a question was not answered, it will be excluded from the export.
All Questions – Question Columns	Exports a CSV or Excel file containing one row per respondent. Each question, regardless of whether or not it was answered, will appear in its own column.
PDF Exports
This Response	Exports a PDF of the responses by each individual respondent. The Browse Results drop-down can be used to toggle to a different respondent for export.
All Responses As Zip	Generates a zip folder containing one PDF file per respondent.
Print	Opens the printer dialogue box to print the survey responses from the currently viewed individual result.

Exporting Multiple-Choice Question Types

Multiple-choice questions generate an output containing the value, option, total, average, median, mode, standard deviation, and variance. For multiple-choice question types with comments enabled, comments will appear as they were input by the respondent – one comment per line – as well as a word cloud.

Value	The numeric value associated with the answer options. When a question is constructed, the values are built from lowest to highest, but they can be displayed from highest to lowest, which would be configured via the Survey Form Designer.
Option	The answer options from which a survey participant could make a selection.
Total	The total number of responses for each answer option.
Average	The average score – the sum of the responses divided by the total number of responses.
Median	The median score – the value at the midpoint of the frequency distribution of responses.
Mode	The value that was most commonly selected by survey participants.
Std Dev.	Measures the amount of variation in the response set. A low standard deviation indicates that the values tend to be close to the mean, while a high standard deviation indicates that the values are spread out over a wider range.
Variance	Variance is a statistical measurement used to determine how far each number is from the mean and from every other number in the set.

Exporting Text/Memo Question Types

Text memo question types will produce an output with one bullet point per individual response up to 500 responses. Additionally, a word cloud will be generated, although word clouds do not contain numbers.

Product Tip

Wordcloud ignore words can be configured by navigating to Institution Homepage > Course Settings > Word Cloud Ignore Words. Learn more about Institution Survey Results and Form Settings.

1	Below each question, each response appears in a bulleted list.
2	A word cloud is generated – words used more frequently appear larger. Each word is clickable (1) and will highlight all the responses where that word was used (2).