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

Course Title: Data collection, Analysis and Visualization Using ODK, Stata and Quantum GIS in Monitoring and Evaluation

06/02/2023 to 17/02/2023: https://bit.ly/3h4Tsl2              

15/05/2023 to 26/05/2023: https://bit.ly/3WkAlU6

04/09/2023 to 15/09/2023: https://bit.ly/3Dv0O8Y

04/12/2023 to 15/12/2023: https://bit.ly/3zwQdZS

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
• 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

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
• 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
• Grouping questions
• Skipping many questions at once (Skipping a section)
• Special formatting
• Making dynamic calculations

Module 5

Hosting survey data: Cloud Hosting

• Google Apps Engine
• ODK Aggregate
• 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
• Types of research designs

Module 7

Introduction to Data management and analysis using Stata

• Overview of Stata Software
• Import, Export, load and save datasets
• Appending, merging and reorganizing datasets
• Identify duplicate observations
• Statistical Inference
• Simple linear Regression and Multiple linear Regression
• Comparing Means Using t-tests
• 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

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

Module 8

Introduction to GIS

• Working with Spatial data (GPS Coordinates)
• Introduction to Fusion Table
• Exporting GPS Coordinates (Google maps) to Fusion tables
• Exporting data to Fusion tables using QGIS
• 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

Module 10

Report writing for surveys, data dissemination, demand and use

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