GIS and Statistical Analysis for WASH Programmes

INTRODUCTION

Integration of GIS technologies in WASH programs boosts the implementation of target-based interventions because it aids in the construction of a model of the complex environment in a straightforward way that you can understand. 

The continuation of developments in free open source GIS software for web and desktop applications has opened doors for many possibilities in the practice of capturing and processing of geographical information, as well as publishing maps on the internet. 

With this program, Public health practitioners, Program Manager, Environmentalist, Monitoring and Evaluation Experts, Civil Engineers, risk assessors, quantitative health geographers, epidemiologists, exposure scientists, and students can gain front-line skills on project planning and design, advocacy and accountability, and monitoring and evaluation.

DURATION

6 Days

COURSE OBJECTIVES

• Assess spatial data availability

• Carry out basic data analysis using statistical software

• Carry out water and sanitation modeling using GIS

• Collect data using Mobile data gathering tools

• Evaluate the spatial data requirements in Water Sanitation and Hygiene

• Understand the importance of Spatial Data Infrastructure (SDI) in WASH programs

• Use GIS and RS as a tool for monitoring WASH projects Activities

• Use participatory GIS (PGIS) at community level

• Scheme and implement GIS projects

 COURSE CONTENT

Module 1:

Introduction and definition of concepts

• Reviewing WASH concepts

• Introduction to GIS concepts 

• Components of GIS Systems

• GIS functions and capabilities in the context of WASH

• Principles of GIS

• Spatial Data Infrastructure in WASH

• GPS, GLONAS and GIS 

• Facilitated Field exercises in collection of GPS Data  in WASH

• GPS configuration and data capture using surveys

• GPS downloads 

• Integrating field GPS data in GIS databases

• Introduction to Global Navigation Satellites and GPS 

Module 2:

GIS Data Management

• Attributes manipulation in GIS

• Data Sources in GIS for WASH

• Facilitated Practical exercises in spatial Databases (Geo-databases)

• GIS database creation

• GIS database management

• Tabular data in GIS 

• Working with GIS Data

Module 3:

Development and presentation of maps

o Basic analysis and Geo processing

o Facilitated practical exercises in presentation using project’s data and map making 

o GIS Mapping

o Project activities/Mapping resources

o Online Mapping – Fusion Tables and Google Maps

o Styling and symbolization

• Case studies: GIS application in water quality testing

1. identify and map critical areas of land use  

2. GIS to monitor water usage, water levels, and watch for trends 

The use of GIS and Remote Sensing in monitoring WASH projects

Module 4:

• Case study: The use of GIS and Remote Sensing in monitoring WASH projects

• Multi Criteria analysis and its applications 

• Participatory GIS for WASH

• Use of Mobile Phones for data Collection 

Module 5:

Statistical data analysis for WASH

• Any Order Tables

• Basic Inferential Statistics Tests (Correlation, Chi Square, T-Test and ANOVA)

• Basic Regression Analysis

• Creating a list

• Data Auditing

• Data Entry and Management with Excel

• Data Quality reporting

• Data validation

• Descriptive Statistics

• Entering Data: Data Forms

• Filtering Data

• Finding Records Using Criteria

• Frequency Tables

• Graphing Qualitative Data

• Graphing Quantitative Data

• Introduction to excel

• Introduction to Excel Pivot tables

• Manipulating data using formulas

• Outlining and Sorting data

• Preparing data for analysis

• Statistical Data Analysis with Excel

• Tabulations and Graphics

• Two Way Tables