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:GenderQ1
1-11FAAAA
2-11MBBBB
3-11FCCCC
4-11MDDDD
1-22FEEEE
2-22MFFFF
3-22FGGGG
4-22MHHHH

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:GenderQ1
11FAAAA
21MBBBB
31FCCCC
41MDDDD

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

!ID:Wave:GenderQ1Q2
1-22FEEEERRR
2-22MFFFFSSS
3-22FGGGGTTT
4-22MHHHHUUU

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