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.
Below is information that can assist you in setting up a database in Excel.
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.)
Google Suite Evaluation Tools
Below is information that can assist you in setting up a database in Epi Info.
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)
Below is information that can assist you in setting up a database in Surveymonkey.
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.
General information on analysis of both textual and numeric data. Below is an example and templates on data analysis planning.
Below is information that can assist you in analyzing quantitative data, or data with numbers.
Below is information that can assist you in analyzing qualitative data, or data with text / words.