Survey to Dedoose Project Creation
Creating fully populated projects from SurveyMonkey or other data collection service output is an increasingly popular feature in Dedoose. Here's an overview and instructions on how to prepare data from survey responses and open-ended questions stored in an Excel file.
Two main things to note:
- For any demographic and scale response data, the resulting Dedoose descriptor fields will be identical to what is specified in the column header and the valid values will be whatever data are located in the cells for each case
- For the qualitative/open-ended narrative data, the content of these cells in each column will be extracted, compiled into a single document for each participant and each response excerpted and tagged with the corresponding column header. So, the column headers for these data will become the automatically generated code system.
To make this process most efficient and the results most useful, here's what is required/recommended:
- For all columns containing closed-ended (descriptor) date, change all column header to appropriate labels that make intuitive sense for a descriptor field. For example, with a question like 'Please indicate your age group,' you'll want to change the column header to 'Age Group.' Then if the data are represented by numeric proxies, e.g., 1,2 and 3, with 1 = 10-25 years, 2 = 26-40 years, 3 = 41-50 years, you'll be happiest in Dedoose if you use the actual values by changing 1s to '10-25 years' the 2s to '26-40 years' and so on. This is fairly straightforward process with Excel's search-and-replace feature.
- For columns containing qualitative (narrative or open-ended) data you will want to change the header to whatever will be most informative as a code. For example, a header like 'Please describe your experiences with X,' might be shortened to 'X experiences.'
- For columns with continuous numeric data, you will be happiest if, wherever possible, you convert these data to a categorical form. For example, imagine you've collected data from a depression scale where scores can range from 0-100. From clinical practice or other guidelines, we may know that scoring between 0-50 is considered 'not depressed,' 51-70 = 'minimally depressed,' 71-85 = 'moderately depressed,' and 86+ = 'severely depressed.' Converting these data prior to import will allow you to explore your excerpting and tagging activity as a function of these groupings. Similarly, if you collect age information in a numeric form, it is in your interest to consider how you will be wanting to 'slice up' the qualitative excerpting and tagging activity by creating groups that will make sense given your analytic plans. Keeping in mind that many Dedoose charts and filtering capabilities are based on descriptor data, doing such a conversion puts you in control of the groupings. The Dedoose charting engine will create groupings automatically from continuous numeric data, but the algorithm is arbitrary, so can be a limited utility.
- Save this file to your local computer.
- Create a new project in Dedoose via your 'Projects' workspace.
- Click the 'Import Data' button in the upper left panel in your new project's home dashboard (the panel with the project summery data.)
- Select Import Spreadsheet
- Locate the Excel file with the project data and 'Submit'.
- Voilà, your project is now all set and ready for more nuanced coding and data analysis.
Importing Excerpts from Excel or other Quantitative Software
If you have already created excerpts in an Excel spreadsheet, we've got an importer that will move you smoothly into Dedoose.
Save the spreadsheet so that each row in the file has:
- The source document name in the first column.
- The username of the excerpt creator in the second column (or this can be left blank.)
- The excerpt text in the third column.
- And all assigned codes (separated by a comma) in the fourth column.
- Save a file in a folder on your computer that also contains all your source documents.
- Select all folders, right click, and click 'Send To' → 'Compressed Archive' to create a single zip file with all of the data compressed.
- Send the zip file to firstname.lastname@example.org along with your Dedoose username and a title for your new project and we'll take it from there.