Data collection Analysis and Visualization Using ODK Stata and Quantum GIS in Monitoring and Evaluation

Course Date Onsite fees: Location Register
17/02/2025 To 28/02/2025 2,200 USD, 198,000 Ksh Nairobi
14/04/2025 To 25/04/2025 2,200 USD, 198,000 Ksh Nairobi
11/08/2025 To 22/08/2025 2,200 USD, 198,000 Ksh Nairobi
20/10/2025 To 31/10/2025 2,200 USD, 198,000 Ksh Nairobi

INTRODUCTION

A logical framework is an important part of monitoring and evaluating the progress and success of the project. The Logical framework provides various components of a project such as goal, objectives, activities, results and indicators. Indicators are linked to data anticipated to be collected during monitoring and evaluation of projects. Indicators provide a standard against which to measure impact brought about by project activities. Open Data Kit (ODK) helps to collect accurate and timely data for decision making. Whereas, Stata support data analysis, Quantum GIS helps in visualization of spatial data collected using ODK.

 

DURATION

10 days

 

COURSE OBJECTIVES

By the end of the training, the participants will be able to;

  • Learn how to develop a logical framework
  • Understand and appropriately use statistical terms and concepts
  • Use mobile data gathering tools such as Open Data Kit (ODK)
  • Learn how to conduct data analysis using stata
  • Use GIS software to visualize data on  maps
  • Write reports from survey data

 

WHO SHOULD ATTEND?

This short course is ideal for government staff with monitoring and evaluation responsibilities, project teams, NGOs staff, consultants, project managers, M&E specialists and researchers.

 

COURSE CONTENT

Module 1

Introduction

  • Data types- Qualitative and quantitative data
  • Research designs in qualitative data and quantitative data collection and analysis
  • Developing a logical framework
  • Components of a logical framework
  • Mobile data collection in Monitoring and Evaluation
  • Introduction to common mobile based data collection platforms
  • Data aggregation, storage, and dissemination

 

Module 2

Survey Planning, Implementation and Completion

  • Types of surveys
  • The survey process
  • Survey design
  • Methods of survey sampling
  • Determining the Sample size
  • Planning a survey
  • Conducting the survey
  • After the survey

 

Software for Data Processing, management and GIS mapping

  • Data collections methods (Web, SMS, Mobile, Email, Social Media)
  • Use of ODK 2 for Mobile Data Collection
  • Importing ODK data into SPSS and Excel
  • Exercise: ODK exercise.

 

Module 3

Mobile Phone-Based Data Collection

  • Overview of available mobile phone based data collection platforms.
  • Types of questions and their data types.
  • Questionnaire/Form logic
  • Extended data types geoid, image, and multimedia
  • Survey Authoring
  • Design forms using a web interfaces using:
  • Hands-on Exercise
  • ODK Build
  • KoboToolBox
  • Preparing mobile devices for data collection
  • Installing application: ODK Collect
  • Configuring the device (Mobile Phones)
  • Uploading the form into the mobile devices

 

Module 4

Advanced survey Authoring: XLSForms

  • Introduction to XLSforms syntax
  • New data types
  • Notes and dates
  • Multiple choice Questions
  • Multiple Language Support
  • Hints and Metadata
  • Conditional Survey Branching
  • Required questions
  • Constraining responses
  • Skip: Asking Relevant Questions
  • The specify other
  • Grouping questions
  • Skipping many questions at once (Skipping a section)
  • Repeating a set of questions
  • Special formatting
  • Making dynamic calculations

 

Module 5

Hosting survey data: Cloud Hosting

  • Google Apps Engine
  • ODK Aggregate
  • KoboToolbox
  • Formhub
  • Hosting Survey Data: Local Server Hosting
  • Configuring ODK Aggregate on a local server
  • Downloading data
  • Manual download (ODK Briefcase)
  • Using the online server interface

 

Module 6

Downloading Data and Introduction to Research Process

  • Downloading data from server and exporting to Stata
  • Overview of the research process
  • Introduction to statistical concepts
  • Descriptive Statistics
  • Inferential statistics
  • Types of research designs

 

Module 7

Introduction to Data management and analysis using Stata

  • Overview of Stata Software
  • Import, Export, load and save datasets
  • Sorting and ordering
  • Appending, merging and reorganizing datasets
  • Identify duplicate observations
  • Statistical Inference
  • Correlation  
  • Simple linear Regression and Multiple linear Regression
  • Comparing Means Using t-tests 

o   One Sample t-tests

o   Paired Sample t-tests

o   Independent Samples t-tests

 

Comparing Means Using One-Way ANOVA 

  • One-Way Anova
  • General Linear Model to Calculate One-Way ANOVAs
  • Exercises

 

Chi-Square 

  • Goodness of Fit Chi Square All Categories Equal
  • Goodness of Fit Chi Square Categories Unequal
  • Chi-Square for Contingency Tables
  • Exercises

 

Nonparametric Statistics 

  • Mann-Whitney Test
  • Wilcoxon’s Matched Pairs Signed-Ranks Test
  • Kruskal-Wallis One-Way ANOVA
  • Friedman’s Rank Test for k Related Samples
  • Exercises

 

Module 8

Introduction to GIS

  • Working with Spatial data (GPS Coordinates)
  • Spatial Mapping
  • Introduction to Fusion Table
  • Exporting GPS Coordinates (Google maps) to Fusion tables
  • Exporting data to Fusion tables using QGIS
  • Converting data to shape files
  • Integrating Mobile Data Collection tools into projects

 

Module 9

GIS mapping of survey data using QGIS

  • Introduction to GIS for Researchers and data scientists
  • Importing survey data into a GIS
  • Mapping of survey data using QGIS
  • Exercise: QGIS mapping exercise.

 

Module 10

Report writing for surveys, data dissemination, demand and use

  • Writing a report from survey data
  • Communication and dissemination strategy
  • Context of Decision Making
  • Improving data use in decision making
  • Culture Change and Change Management

 

 

***************************

 

TRAINING CUSTOMIZATION

This training can also be customized for your institution upon request. You can also have it delivered your preferred location. For further inquiries, please contact us through:

  • Phone: +254 732 776 700 or 254759285295
  • Email: training@fineresultsresearch.org

 

REQUIREMENTS

Participants should be reasonably proficient in English.  During the trainings, participants should come with their own laptops.

 

TRAINING FEE

The course fee covers the course tuition, training materials, two break refreshments, lunch, and study visits.

 

ACCOMMODATION

Accommodation is arranged upon request. For reservations contact us through phone: +254 732 776 700 or 254759285295 or Email: training@fineresultsresearch.org

 

PAYMENT

Payment should be transferred to FineResults Research Limited bank before commencement of training. Send proof of payment through the email: training@fineresultsresearch.org

 

CANCELLATION POLICY 

  • All requests for cancellations must be received in writing.
  • Changes will become effective on the date of written confirmation being received.
Call us on +254 732 776 700/ +254 759 285 295
Book your Training (Training Calender)
Follow us