Training Course on GIS Mapping and Statistical Analysis for WASH Programmes

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: 5 days

Course Objectives

1. Assess spatial data availability
2. Carry out basic data analysis using statistical software
3. Carry out water and sanitation modelling using GIS
4. Collect data using Mobile data gathering tools
5. Evaluate the spatial data requirements in Water Sanitation and Hygiene
6. Understand the importance of Spatial Data Infrastructure (SDI) in WASH programs
7. Use GIS and RS as a tool for monitoring WASH projects Activities
8. Use participatory GIS (PGIS) at community level
9. Scheme and implement GIS projects

Course Content

Module 1: Introduction and definition of concepts

1. Reviewing WASH concepts
2. Introduction to GIS concepts 
3. Components of GIS Systems
4. GIS functions and capabilities in the context of WASH
5. Principles of GIS
6. Spatial Data Infrastructure in WASH
7. GPS, GLONAS and GIS 
8. Facilitated Field exercises in collection of GPS Data  in WASH
9. GPS configuration and data capture using surveys
10. GPS downloads 
11. Integrating field GPS data in GIS databases
12. Introduction to Global Navigation Satellites and GPS 

Module 2: GIS Data Management

1. Attributes manipulation in GIS
2. Data Sources in GIS for WASH
3. Facilitated Practical exercises in spatial Databases (Geo-databases)
4. GIS database creation
5. GIS database management
6. Tabular data in GIS 
7. Working with GIS Data

Module 3: Development and presentation of maps

1. Basic analysis and Geo processing
2. Facilitated practical exercises in presentation using project’s data and map making 
3. GIS Mapping
4. Project activities/Mapping resources
5. Online Mapping – Fusion Tables and Google Maps
6. Styling and symbolization
7. Case studies: GIS application in water quality testing
   • identify and map critical areas of land use  
   • GIS to monitor water usage, water levels, and watch for trends 
8. The use of GIS and Remote Sensing in monitoring WASH projects

Module 4:

1. Case study: The use of GIS and Remote Sensing in monitoring WASH projects
2. Multi Criteria analysis and its applications 
3. Participatory GIS for WASH
4. Use of Mobile Phones for data Collection 

Module 5: Statistical data analysis for WASH

1. Any Order Tables
2. Basic Inferential Statistics Tests (Correlation, Chi Square, T-Test and ANOVA)
3. Basic Regression Analysis
4. Creating a list
5. Data Auditing
6. Data Entry and Management with Excel
7. Data Quality reporting
8. Data validation
9. Descriptive Statistics
10. Entering Data: Data Forms
11. Filtering Data
12. Finding Records Using Criteria
13. Frequency Tables
14. Graphing Qualitative Data
15. Graphing Quantitative Data
16. Introduction to excel
17. Introduction to Excel Pivot tables
18. Manipulating data using formulas
19. Outlining and Sorting data
20. Preparing data for analysis
21. Statistical Data Analysis with Excel
22. Tabulations and Graphics

Methodology

The instructor led trainings are delivered using a blended learning approach and comprises of presentations, guided sessions of practical exercise, web-based tutorials and group work. Our facilitators are seasoned industry experts with years of experience, working as professional and trainers in these fields.

Key Notes

i. The participant must be conversant with English.

ii. Upon completion of training the participant will be issued with an Authorized Training Certificate

iii. Course duration is flexible and the contents can be modified to fit any number of days.

iv. The course fee includes facilitation training materials, 2 coffee breaks, buffet lunch and a Certificate upon successful completion of Training.

v. One-year post-training support Consultation and Coaching provided after the course.

vi. Payment should be done at least a week before commence of the training, to DATASTAT CONSULTANCY LTD account, as indicated in the invoice so as to enable us prepare better for you.