Interactive Online Course: Collecting Data (Step 4 from Evaluating Sexual Violence Prevention Programs: Steps & Strategies for Preventionists)

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 ExcelEpi Info, and Surveymonkey can be found below.

Excel

Below is information that can assist you in setting up a database in Excel.

Quick Guide
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)
Examples
Tools & Templates
Google Excel Doc Training Training Power Point Slides
Participant Training Handout Example
Pros and Cons Guide
Accessing the System Usability Scale

Epi Info

Below is information that can assist you in setting up a database in Epi Info.

Quick Guide  Introducing...EPI INFO (TM)
In-Depth Guide EPI INFO (TM) Quick Start 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)
Examples
Tools & Templates

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.
In-Depth Guide
Multi-Media Learning How to Use SurveyMonkey
Examples
Tools & Templates

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.

Quick Guide CDC Evaluation Briefs: Analyzing Quantitative Data for EvaluationTips for Quantitative Data Analysis (UW Extension)
In-Depth Guide Analyzing Quantitative Data (UW Extension)
Multi-Media Learning
Examples
Tools & Templates

Qualitative

Below is information that can assist you in analyzing qualitative data, or data with text / words.

Quick Guide Quick Tips: 10 Steps to Make Sense of Answers to Open-Ended QuestionsCDC Evaluation Briefs: Analyzing Qualitative Data for EvaluationTips for Qualitative Data Analysis (UW Extension)
In-Depth Guide Analyzing Qualitative Data (UW Extension)
Multi-Media Learning
Examples Sample Data from Open Ended Questions (UW Extension)
Tools & Templates