Survey session data can be queried and viewed in aggregate form. This feature provides a report that summarizes survey responses in aggregate. The report displays the summarized responses in chronological order (the order they appear in the survey) followed by the calculated variables (ie: BAC, AUDIT Score, etc.).
The output from Survey responses and Calculated variables come in the two forms: String and Numeric. Please see below for definitions of these two data types and a description of the different ways that each are displayed in the aggregate report.
These are survey responses that consists of a word or letters. Examples of this are Likert scales such as 'Strongly Agree', 'Agree', and so on.
In the aggregate report, string values will be displayed in frequency tables. Frequency tables provide the 'frequency' or number of responses for a particular response option and the percentage of students that selected that response choice. Please see the frequency table screenshot and explanations below.
|A. Variable Name||The name that was applied to the survey item. |
|B. Variable Label||The label or content of the question.|
|C. Response Choices||Includes the select one or select many options|
|D. Frequency||Number of responses for each response choice|
|E. Percent||Percent among ALL survey submissions. This will include students that did not respond to this question.|
|F. Valid Percent||Percent among ONLY those that responded to this question.|
|G. Totals||Totals of each column|
These are survey responses or calculated variables that appear in numeric form. Examples of this are responses to the survey question 'Number of Drinks' or the calculated variable of their 'Typical BAC.
In the aggregate report, these numerical values will be displayed in a table that provides descriptive statistics such as the minimum and maximum scores, mean and median. The screenshot below displays an example of a table provided for numeric values.
Producing an Aggregate Report
To access this feature, go to the Manage Surveys page by clicking Surveys in the Main navigation menu and click on the desired survey. Then follow the steps below which are indicated in the screenshot beneath them.
Click on the AGGREGATIONS tab along the top of the Survey detail page. The right arrow (outlined in yellow in box 1 below) may need to be clicked to scroll over to the correct tab.
Apply date range filters to limit the data based on when the sessions were started or completed (the completion date is used more frequently). Enter dates by clicking the mini-calendars (outlined in yellow) or by typing a date in. Leave these blank to include ALL survey sessions.
Apply filters to limit the data to only cases with specific Referral Sources or Referral Types by selecting options in the drop down menu for each. Leave these blank to include ALL survey sessions.
Data from survey sessions that have been started but not completed can be included by selecting the 'Include Incomplete Data' checkbox (don't use the Complete date range filter if this is checked). Leave this unchecked to only include data from completed survey sessions.
Click the QUERY button to create the report.
Saving Your Report
The report you've produced by following the steps above can be saved as a PDF using the instructions listed in our other solution article linked here.
See video below for a full run through of this feature.