During or after the examination, it is possible to have the obtain complete results of the study.
The following types of result files can be requested:
- CSV / TXT
- SPSS
The files are live, which means that all results can be seen directly in the file.
Excel File (CSV-TXT)
This file is named "RES_XXXXXX.TXT". Below you can you can read how this file can be read into Microsoft Excel. This description assumes an English language version of Excel. The Dutch version works the same.
- Go to Excel and go to "Open" in the "File" menu.
- At "Files by type", select the type "Text files"
- Go to the location on your own computer where you want the "RES_XXXXX.TXT" file.
- Select this file and click "Open".
- You will then see the import wizard (see below) picture comes. The values must be entered as in the image below.
- Click on "Next" and you will be taken to the next screen. Here select "Semicolon" as the delimiter and the single quote (") as a text qualifier.
- If you click on "Next" in the previous screen the next step in the picture. This allows you to specify per column what kind of values this column contains.
- Are you using decimal columns? To make sure to be that these are loaded they must, at step 3, loaded as string data format.
- Press "Finish" and your results file has been imported.
- Save the file as Excel or CSV
SPSS files
The following types of files are available for importing into SPSS available: a data file, a label file and a .sav file. The names are: "DAT_XXXXXX.TXT", "LAB_XXXXXX.SPS", "SAV_XXXXXX.SAV" respectively. The .sav file has already been imported into SPSS with the correct question and answer labels. This instruction concerns the manual import the .txt data file into SPSS and append it of labels through the label file:
- Save both files.
- Start SPSS and choose Open in the File menu and then for Data (see image).
- Then go to the correct location on your computer and select "Text (* .txt)" under "Files of Type" (see the following image). Select the correct "DAT _ ????. TXT" file and click "Open".
- You will now enter the SPSS Text Import Wizard. Make sure that "No" is selected and click "Next"
- In the next screen, "Delimited" should be selected and "Yes" to "Are variable names included at the top of your file? "
- If you pressed "Next" in the previous screen then the following screen follows. This must be done below way. Then click on "Next"
- Then you will see the following screen. Select here as delimiter Semicolon "and as text qualifier" ~ ". This character is on most keyboards to the left of the 1.
- From the screen on the previous page, press "Next". In the next screen you can also directly click "Next" and then in the last screen you can press Click "Finish". Now the data is imported into SPSS.
- Do you have SPSS 24 or higher? Then there must be 1 more setting are being changed. In the penultimate screen (step 5) the percentage must be set from 95 to 100.
- Are you using decimal columns? To make sure to be that these are loaded they must, at step 5, loaded as string data format.
Add labels
Then to the various questions and answers from labels you should provide the label file created by Crowdtech to open and start. You can do this by going to "Open" at "File" and then go "Syntax". Then select the "LAB_XXXXXX.SPS" file on your computer and click "Open". You will then see a screen as below.
Simultaneously press CTRL and A. You can see that all text is made black. Then click on the triangle. Now all labels are applied.
When this has been completed, you can close this screen. The data file is now labeled. It is useful to then save your data file Save as "SPSS (* .sav)" file. Then you do the following time to reimport this data file and from labels to provide.