INTRODUCTION

The provision of water and sanitary facilities is only one aspect of the issues associated with water in developing nations. With population increase, major upland watershed damage, chronic cycles of flooding and drought that are becoming more frequent and severe due in part to climate change, and an unequal distribution of water resources, users throughout the region are experiencing severe water shortages.

Enhancing community capacity to manage and better utilize water resources, upgrading water delivery infrastructure in arid and semi-arid regions, enhancing water sanitation and hygiene practices, and conserving watersheds are all necessary.

COURSE OBJECTIVES

At the end of course participants should be able to:

• Use GIS and RS as a tool for monitoring WASH programs.
•  Assess the spatial data requirements in Water Sanitation and Hygiene. Activities
•  Determine the availability of spatial data;
•  Recognize the value of spatial data infrastructure (SDI) in WASH programs;
•  Employ participatory GIS (PGIS) at the local level;
•  Carry out water and sanitation modeling using GIS;
•  Gather data using mobile data gathering tools;
•  Carry out fundamental data analysis using statistical software;
•  Design and implement their own GIS projects that incorporate remote sensing data and GPS-based field information in a proper geospatial framework.

DURATION

5 Days

WHO SHOULD ATTEND

The course targets WASH specialists, M & E Experts, Public health, Program Manager, Students and Risk assessors, water engineers.

COURSE CONTENT

MODULE 1:

Introduction and definitions of key concepts

• Review of WASH concepts
• Introduction to GIS concepts

Introduction to GIS Software (QGIS)

• Principles of GIS
• Components of GIS Systems
• GIS Capabilities and Functions in the context of WASH
• Spatial Data Infrastructure in WASH

GPS, GLONASS, and GIS

• Introduction to GPS and Global Navigation Satellites
• GPS configuration, Capturing data from surveys
• GPS download and related tasks
• Integrating field GPS data into the GIS database
• Facilitated Field exercises in GPS Data Collection in WASH

MODULE 2:

GIS Data Management

• Data Sources in GIS for WASH
• Working with GIS Data
• Attributes manipulation in GIS
• Tabular data in GIS –import/add and editing tables in GIS
• GIS database creation
• GIS database management
• Facilitated Practical exercises in working with spatial Databases (Geo-databases)

MODULE 3:

Development and presentation of maps

• GIS Mapping
• Styling and symbolization
• Mapping resources/Project activities
• Facilitated practical exercises in map making and presentation using the project’s data
• Basic analysis and Geoprocessing
• Online Mapping – Google Maps and Fusion Tables

Case studies: GIS application in water quality testing

• Identify and map critical areas of land use and reveal trends that affect water quality
• GIS to monitor water levels, water usage, and watch for trends, case study Use of GIS for mapping river contamination.

MODULE 4:

• Participatory GIS for WASH
• Use of Mobile Phones for Data Collection in WASH
• Multi-Criteria analysis and its application in WASH
• Case study: GIS and Remote Sensing as a tool in monitoring WASH projects

MODULE 5:

Statistical data analysis for WASH

• Introduction to Excel
• Data Entry and Management with Excel
• Manipulating data using formulas
• Preparing data for analysis
• Creating a list
• Outlining and Sorting data
• Entering Data: Data Forms
• Finding Records Using Criteria
• Filtering Data
• Data Auditing
• Data validation
• Introduction to Excel Pivot tables
• Frequency Tables
• Two Way Tables
• Any Order Tables
• Graphing Qualitative Data
• Graphing Quantitative Data
• Descriptive Statistics
• Basic Inferential Statistics Tests
• Basic Regression Analysis
• Tabulations and Graphics
• Statistical Data Analysis with Excel
• Data Quality reporting

GENERAL NOTES

• Our seasoned instructors, who have years of experience as seasoned professionals in their respective fields of work, will be teaching this course. A combination of practical exercises, theory, group projects, and case studies are used to teach the course.
• The participants receive training manuals and supplementary reading materials.
• Participants who complete this course successfully will receive a certificate.
• We can also create a course specifically for your organization to match your needs. To learn more, get in touch with us at training@dealsontrainers.org.
• The training will take place at DEALSON TRAINERS IN NAIROBI, KENYA in Nairobi, Kenya.
• The training fee includes lunch, course materials, and lodging for the training session. Upon request, we may arrange for our participants' lodging and transportation to the airport.
• Payment must be made to our bank account before the training begins, and documentation of payment should be emailed to training@dealsontrainers.org