Database Creation
How to set up a data collection and management system. Although there are many ways to set up a database, and many programs available for assistance, this website includes resources and information on three programs.
Specific information related to database creation using Excel, Epi Info, and Surveymonkey can be found below.
Excel
Below is information that can assist you in setting up a database in Excel.
In-Depth Guide
Using Excel for Analyzing Survey Questionnaires (UW Extension). This guide is based on an older version of Microsoft Excel. However, it is a great starter guide for folks who are new to excel. One differing recommendation from this guide is to use the top row to enter the field name of each value. (This will allow the excel spreadsheet to be used in additional programs such as google drives, EpiInfo, and other statistical programs.)
Multi-Media Learning
Demystifying Survey Data Collection - Slides (NJJEC Webinar 9-5-13)
Google Suite Evaluation Tools
Epi Info
Below is information that can assist you in setting up a database in Epi Info.
Quick Guide
In-Depth Guide
Multi-Media Learning
Creating a New Project (1 of 3: WCASA YouTube Videos)
Opening Forms (2 of 3: WCASA YouTube Videos)
Moving Files (3 of 3: WCASA YouTube Videos)
Surveymonkey
Below is information that can assist you in setting up a database in Surveymonkey.
Quick Guide
SurveyMonkey Website - Anyone can create a free account and administer surveys. Please see the plans and pricing on the website above for details. Depending on how many questions and responses you need per survey there may be a cost associated with the program.
Multi-Media Learning
Analyze Results
General information on analysis of both textual and numeric data. Below is an example and templates on data analysis planning.
Quantitative
Below is information that can assist you in analyzing quantitative data, or data with numbers.
In-Depth Guide
Qualitative
Below is information that can assist you in analyzing qualitative data, or data with text / words.
Quick Guide
In-Depth Guide
Examples
Sample Data from Open Ended Questions (UW Extension)