View Survey Data

1. Progress for the survey can be tracked in the Data Manager where the number of submissions and individual responses can be seen.

2. Login to your system’s DatStat Gateway Page with your username and password.
   

3. Click the Data Manager link in the top-right hand corner if you are not immediately taken to the Data Manager.

4. Under the Published Surveys tab, click the survey for which you entered data.
   

A Query allows you to “slice-and-dice” your data – to examine it in segments or groups based on criteria you set. A query gives you up to the minute results, and can be shared with others.

The Queries tab allows you to create, edit, and share data queries, which are essentially questions you ask of your data. A query is not a one-time snapshot – the query is run again every time you click it, on the most recent collected data. Follow the following steps to build a query:

1. To build a new query, click New
   

2. Give the Query a name and a description – putting a good description helps you remember later what the query does.
   

3. You can choose whether the query is shared or not. A shared query means that once it is created, any of your colleagues who have access to that survey can click on the query and see the results, just as you can.  The only reason not to share a query is if it is not applicable to anyone else, or you created it just for practice.

4. Select whether you want to examine live production data, or test data only, by checking the Test Data Only box. Checking the Use Test Data box is the only way to examine test data generated by Illume (covered later in this document).  Click Continue.

5. On the left side of the screen you will see all the items in your data dictionary, which includes the questions you asked in your survey, any hidden variables, calculated variables, and the 20 or so “DatStat Internal” variables, which are the meta-data variable captured automatically on every submission.
   
   

6. Checking the box next to a data dictionary item puts it in your selected variables list on the right.  As an alternative to checking an item, you can select all of the variables in the survey by clicking All, or all of the variables within a certain group by clicking the All at the start of that group. You can also choose to see only the open-text commentary questions by clicking Comment, or only the non-commentary questions by clicking Data.

For this query, you’re going to build a query that pulls all of the data for participants who answered AGE > 20. Start by clicking All for ‘All Variables’.

7. You can move the order in which the variables are presented by using the up and down arrows.
   <

8. Since this query is only searching for submissions for those where AGE > 20, a filter needs to be added. Click the Filters checkbox
   

9. The ‘Filters’ section will open. Now we’ll set up the filter to search for AGE > 20.
   

10. Click Save to save your query
    

11. Click Run Query
    

Summary Tab

Shows you the collected data in summary format.  For each variable you will see counts, percentages, and descriptive statistics. The descriptive statistics is the deepest level of statistical analysis provided by Illume – for inferential statistics, you must download into an analysis package such as SPSS.

Any variables with a blue graph icon means you can click on the icon to produce a graph.  You can alter various aspects of a graph, such as changing the chart type or color scheme.  Once you make a change, you must click Redraw to see the changes.

The chart is a fixed image that can be dragged and dropped into external applications such as PowerPoint, Word or Excel.  It is not an interactive chart – it is an image file.

Bar Graphs Tab

Visual representation of what is on the summary page.  It does not provide any new information than what is on the summary page.  The colors of the bars have no meaning – they are just used to distinguish each bar from the other.

Raw Data Tab

The raw data view displays one row of data for each participant, with each column being each of the variables you selected in your query.  You can sort by any variable by clicking on the column header.  A limited number of results will be shown per page  – you can select the results per page drop down to show more results per page.

By clicking on the row number in this grid you can view the results for a single participant.  The resulting display will show you, organized by collection, each question and the participant’s response to that question.

Download Tab

This data download is specifically for downloading the results of a query.  To download the results of the query, first select whether you want to download in Summary format (will show you the descriptive statistics) or in Raw data format.  Then select the desired file format from those shown in the drop down.

1. Clicking Include Value labels will provide you with both the raw data, and the associated scale labels. For example, a gender question might be coded as 1=male, 2=female.  If you do NOT click Include Value Labels, the data that will appear for a participant will be only the value, e.g. 1.  If you click Include Value labels, you will see the value 1 and its corresponding label male, and it will look like 1:Male

2. Clicking List Text Items is relevant for the Summary Data format. If this is checked, the open text responses provided by the respondents will be listed out in the downloaded file

Data Download Tab

The Data Download tab is a full “data dump” of all of the collected data in a survey (as opposed to Download described above, which was specifically for downloading the results of a defined query).

1. Select whether you want to download in Summary format (will show you the descriptive statistics) or in Raw data format.

2. Select the desired file format from those shown in the drop down.  The download will have the data dictionary fully loaded – all of the values and value labels will be included in the export.

3. Clicking “Include Value labels” will provide you with both the raw data, and the associated scale labels.  For example, a gender question might be coded as 1=male, 2=female.  If you do NOT click Include Value Labels, the data that will appear for a participant will be only the value, e.g. 1.  If you click Include Value labels, you will see the value 1 and its corresponding label male, and it will look like 1:Male

4. Clicking “List Text Items” is relevant for the Summary Data format.  If this is checked, the open text responses provided by the respondents will be displayed  in the downloaded file