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.

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

Google Suite Evaluation Tools
Epi Info

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

Quick 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.

Qualitative

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

Examples