Presenting Survey Results

Downloading Survey Results

Once your email recipients have completed the survey, you’ll likely want to put it together into a package for easy viewing. It is best if the package is in pdf format, includes the response rate, and only includes comments pertaining to the course under review.

Export your survey results to a PDF

To export your survey results to PDF, click My Surveys.

Locate the survey that you would like to export and find its graph icon (representing the Analyze Results button). Click this.

When the new webpage appears, you’ll notice that you are back in the workflow that you initiated when you began the survey, only now, you are much further along (under the ANALYZE RESULTS step).

Next, find the green button that says SAVE AS and click Export file.

You’ll see three options: All summary data, All responses data, and All individual responses. Select All summary data.

A new window will appear, the default download file format is PDF – check that is the format highlighted. Check that box that says Open-ended responses, then click EXPORT.

After a few seconds, you should see a pop-up that says Your export is complete, accompanied by a Download button. Click this button.

Once you do so, you can locate the download on your computer (screenshot shows Firefox download process), and voila, you have a pdf of your results!

Capture the Number of Invitations and Responses

Not everyone who received your survey may have filled it out. To see the response rates, first click the COLLECT RESPONSES tab.

Identify the collector that represents the email invitation you sent out, and click it.

You’ll see a page with two donut charts, like the one below.

You cannot export this information in the same way that you exported the survey responses. Instead, use the Snipping Tool to capture a screen shot

Paste screenshot in a new Word document. Next, click File, then SAVE AS.

The new window will give you an opportunity to type what you would like your document to be called. Save it as PDF.

Redact your results

For privacy reasons, an instructor should not read student feedback pertaining to other instructors. If a student references another instructor in the end of course survey, you’ll need to make two copies (one un-redacted copy), and redact the comments pertaining to the other instructor(s)

The best way to do so is to via Adobe Pro. You can apply to obtain Adobe Pro though the IT-services department.

Once you have obtained the software, you may find the following link useful: https://helpx.adobe.com/ca/acrobat/using/removing-sensitive-content-pdfs.html

Do a Cross-Survey Analysis

Sometimes, you’ll want to compare how a course evaluation is changing over time. To do this, you’ll need to export the survey results from both surveys as a csv file, then bring the information together in Excel, where you can make a visualization.

Ensure that you are in the ANALYZE RESULTS tab.

Click Save As, then select Export file, then select All Summary Data.

In the resulting window, click CSV, then click EXPORT.

You’ll be asked to confirm your choice to download. Save the File, then open in Excel.

Repeat the download process with all the surveys you would like to include in your cross-analysis.

Next, you’ll want to do some copy-pasting so that the data you would like to bring together is in the same Excel file. If possible, try to organize your data so that one column is filled with years, and each row represents data pertaining to that year.

Visualizing your data begins with highlighting the relevant data. Click the upper-left cell of your dataset, press and hold the shift button, the click the lower-right cell of your dataset.

Click Insert.

Click the chart icon and then click a chart type of your choosing. Column charts are usually the best for showing data clearly.

Once you do this, the bare-bones version of your chart will appear.

You’ll notice that Excel automatically decided what should count as the vertical and horizontal axis. But sometimes, Excel does not do this correctly, especially when one of the axes is supposed to represent time. If your bare-bones chart was not created correctly, and you need to change the bottom axis, right-click the middle of your chart. You’ll see a pop-up with the option to Select Data. Click this.

A new window will appear with two boxes. Move to the box on the right and click the Edit button.

Ignore the Axis Labels window that pops up.

.. and click the cells that should be used to inform your bottom axis. (Click the first cell, press and hold the shift button, then click the last cell. Release the shift button).

Click OK in the Axis Labels window, which should now be filled with a reference to the cells you clicked.

Once you do this, the horizontal axis should be based on date. Your chart still won’t look quite right however, because Excel thinks that the date (which informs your axis) is also one of your series. You’ll need to tell it otherwise.

Go to Select Data Source window and move to the box on the right. Click the column that represents date, then click Remove.

Click OK and view your brand-new chart.