QUALTRICS 101 - 10/10 - DOWNLOADING YOUR DATA
This is a transcript of this video. Please consider this page as a work in progress. My intention is to update this with updated screenshots, to reflect the newer interface, and add some more relevant information. If you have suggestions, please let me know.
Video 10 – Downloading Data
Summary of Topics Covered:
• Closing your survey
• Downloading your data
• Reviewing and analyzing your data
Script:
Welcome to the tenth video! In this video, I’ll show you what to do after collecting your data: how to close your survey, how to download the data, and what the data looks like.
Let’s start with closing your survey. Here is my demo survey V2 that I’ve been working on throughout these videos. I’ll make this survey available to you along with some other helpful files to assist you in working with Qualtrics and these demos.
At the moment, this is an active survey. At some point, you might want to close the survey to prevent further responses. You can choose to allow participants who are halfway through to finish their responses over time, which will require you to redownload your data later. Alternatively, you can close all active survey sessions immediately. In this case, since no one is currently taking the survey, I’ll close all active survey sessions and hit pause data collection. The survey is now closed, and anyone attempting to access the link will receive an error message indicating the survey is closed.
Next, let’s look at the data. Go to the “Data & Analysis” tab. Here, you’ll see the responses indexed. Use the GC1 embedded data variable, set up in a previous video, to filter responses. Add a filter based on the GC value, equalling 1, to see how many participants completed the survey.
You’ll notice a variety of columns displayed, such as consent, gender, and ATSI status. Customize the columns to include relevant embedded data, such as the GC column, to see the completion status.
To download the data, go to “Export & Import”. You can export the data as a CSV file or, preferably, as an SPSS data file. Even if you don’t use SPSS for analysis, SPSS files include both numeric values and their corresponding labels, making it easier to understand your data. For example, gender values like 0 (female), 1 (male), and 99 (prefer not to say) are clearly labeled.
I’ll download the data as an SPSS file and show you what it looks like. In SPSS, you’ll find variables automatically included at the start, such as start and end dates, unique response IDs, latitude and longitude, and the source of the survey response (e.g., preview or anonymous link). Analyzing this data in SPSS provides clear labels for each value, simplifying the analysis process.
Here’s a quick analysis of the gender question. The labels are displayed alongside their values, making it easy to interpret the data. The dataset also includes additional variables like the start and end dates, unique response IDs, and the latitude and longitude of respondents. This information can be useful for tracking the time taken to complete the survey and the geographical location of respondents.
In this video, I’ve shown you how to close your survey, download your data, and review it in SPSS. This concludes the series of videos where I’ve demonstrated the basic Qualtrics interface, setting up a simple survey, recoding values, using matrix tables, display and skip logic, scoring scales, using piped text, and embedding data. I’ve also covered testing and collaborating on surveys, distributing them, and finally, closing and downloading the data.
If you’d like to see more, I’ll be posting additional videos on advanced topics, showcasing the innovative work we’ve been doing at the Experimental Gambling Research Laboratory. Look out for those future videos. If you enjoyed this series, feel free to like, subscribe, and share with your friends. If you have any specific requests, leave them in the comments below.
Until next time, I’m Dr. Alex Russell with the Experimental Gambling Research Laboratory at CQUniversity. I look forward to seeing you in future videos.