Surveys with Waves of Data Collection

February 10, 2014

Author:  Ricardo B. Contreras

Let’s suppose that you have collected your data in different waves or points in time.  Then, you have two choices: enter all of the information, from each wave, into a single spreadsheet and then import the data into ATLAS.ti; or enter into ATLAS.ti the data from each wave of data collection at a time, using an individual spreadsheet each time.

Scenario 1:  All information in a single spreadsheet

Each survey participants should be identified using a unique ID.  Thus the spreadsheet will look as follows:

The spreadsheet will look as follows:

!ID :Wave :Gender Q1
1-1 1 F AAAA
2-1 1 M BBBB
3-1 1 F CCCC
4-1 1 M DDDD
1-2 2 F EEEE
2-2 2 M FFFF
3-2 2 F GGGG
4-2 2 M HHHH

Once imported into ATLAS.ti, the primary documents will look as follows inside of the PD Manager:

1

Figure 1. Spreadsheet with identifiers for each wave of data collection

The PD Family Manager will show a PD family for each wave of data collection, as follows:

2

Scenario 2. Individual spreadsheets for each wave of data collection

You can also import the data from each wave of survey data collection as an individual spreadsheet.  For instance, wave one of data collection would be imported from spreadsheet A and wave two from spreadsheet B.  Although it makes sense that the structure of the spreadsheet remains the same from wave one of data collection to wave two, it is perfectly possible to add questions as more data are collected.

In this scenario, the spreadsheet for wave one of data collection will look like this:

!ID :Wave :Gender Q1
1 1 F AAAA
2 1 M BBBB
3 1 F CCCC
4 1 M DDDD

And the spreadsheet for wave two of data collection will look like this (with added question):

!ID :Wave :Gender Q1 Q2
1-2 2 F EEEE RRR
2-2 2 M FFFF SSS
3-2 2 F GGGG TTT
4-2 2 M HHHH UUU

Once the survey data from both waves of data collection have been imported into ATLAS.ti, the survey responses will show in the Primary Document Manager as follows:

3

The Primary Document Family Manager will show the PDs from each wave of data collection in the same way as shown in the figure above.

Share this Article

Tags