Before you analyse a quantitative dataset you need to
SIOC224 3.2 Lab 2: Download + import your data + make a codebook
Step 1 - How to download your data from Qualtrics
Type in your User ID and Password
Click the Sign In button
After Signing In, scroll down
Click on the name of the survey you want to work on
- Click the “Data & Analysis”" tab
- Click the “Export & Import” icon, and then select “Export Data”
- A dialogue box will open and you will need to make some choices.
My recommendation is to choose:
- Download as SPSS file
- UNSELECT “Compress data as .zip file”
Click the Download button
Save dataset on your computer with some relevant name such as “Survey Data.sav”
Step 2 - Creating a codebook
A codebook tells you what the numbers in your dataset actually mean.
For example, if you have a “1” in the Gender variable, does it mean Male? Female? Other? or something else? In professional studies, elaborate codebooks are created.
However, for your data, you just need something to double check the meaning of the numbers in your dataset. So I’m going to teach you a simple method to create a basic codebook.
- On Qualtrics, go to the “Survey” tab, and then select the “Tools” button, and then “Import/Export” and “Export Survey to Word”
- A dialogue box will open up.
I recommend using the default options, except:
- SELECT “Show Survey Flow”
- Click ‘Export’ and save our file with a sensible name like “Survey Codebook.docx”
If you open this Word document, you will see how next to each choice for a survey there is a number. For example, in the image below, you can see that “Under 18” is coded as “1”.
Step 3 - Importing into SPSS
To get your datafile into iLab the easiest thing to do is to either (1) download from Qualtrics (but you can only do this the first time), or (2) email to yourself (by logging into your email inside iLab) or (3) using a USB drive.
Go into iLab, and then open SPSS (see Lab 1).
Close the first dialogue box that opens
Go to File > Open > Data
- In the dialogue box that opens navigate and select your dataset.