Course Overview:
This course equips participants with practical skills to design, collect, and analyze field survey data using mobile data collection tools (ODK and Kobo Collect) and Excel. Participants will gain hands-on experience in creating surveys, managing data in the field, and generating insights for decision-making.
Target Audience
Course Delivery
Pre-requisites
Learning Objectives:
By the end of the course, participants will:
Learning Objectives:
By the end of the course, participants will:
Course Structure
Day 1: Introduction to Mobile Data Collection
Overview of Mobile Data Collection Tools
o Introduction to ODK and Kobo Collect.
o Comparison of paper-based and mobile-based data collection.
o Benefits and ethical considerations of mobile data collection.
Exercise:
o Compare sample paper and mobile survey formats.
Day 2: Setting Up and Designing Surveys
Setting Up ODK/Kobo Collect
o Installing and configuring ODK/Kobo Collect on Android devices.
o Setting up synchronization with the server.
o Overview of web interfaces: ODK Aggregate/Kobo Toolbox.
Designing Survey Forms
o Principles of survey design: question types, logic, skips, and validations.
o Building survey forms using ODK Build/Kobo Toolbox.
o Exporting survey forms to XML or XLSX formats.
Exercise:
o Install the app and configure a sample survey form.
o Design a basic survey form and validate it.
Day 3: Deploying Surveys and Data Collection
Deploying and Testing Surveys
o Uploading survey forms to ODK Aggregate or Kobo Toolbox.
o Synchronizing devices and conducting field tests.
o Managing survey data during collection.
Conducting Field Surveys
o Best practices for ensuring data accuracy and quality.
o Troubleshooting common issues during data collection.
o Collecting GPS and multimedia data.
Exercise:
o Upload a survey form, sync it, and conduct a test survey.
o Use GPS features to collect and geotag survey responses.
Day 4: Monitoring Data and Data Cleaning
Monitoring and Managing Data
o Checking synchronization and submission statuses.
o Offline data collection and batch synchronization.
Data Cleaning and Organization
o Importing survey data into Excel.
o Cleaning raw data: handling duplicates and missing values.
Exercise:
o Monitor a simulated field data collection process.
o Clean and organize a sample dataset.
Day 5: Data Analysis and Visualization
Basic Data Analysis and Visualization
o Using Excel functions and formulas for analysis.
o Creating pivot tables, charts, and graphs.
Advanced Excel Techniques
o Applying VLOOKUP, INDEX-MATCH, and statistical formulas.
o Handling large datasets efficiently.
Exercise:
o Summarize survey results using pivot tables and charts.
o Perform advanced analysis on a sample dataset.
Day 6: Reporting and Final Project
Final Report Creation
o Structuring survey results for stakeholders.
o Customizing reports with charts and graphs.
Exercise:
o Create and present a summary report based on the analyzed data.
o Final project: Apply all skills learned to a real or simulated dataset.
Inquiries About the Course