Training Course On GIS And Statistical Analysis For Wash Programmes

Water-related challenges in developing countries are not limited to water supply and sanitation services. Water shortages experienced by users across the region is plagued with chronic cycles of flooding and drought that are increasing in frequency and severity, in part exacerbated by climate change, and coupled with population growth, significant upland watershed destruction, and non-equitable distributed of water resources.

There is the need in improving access to water, increasing community capacity to manage and better use water resources, improving water supply infrastructure in arid and semi-arid areas, improving water sanitation and hygiene practices, as well as protecting watersheds.

COURSE OBJECTIVES

At the end of course participants should be able to:

• Evaluate the spatial data requirements in Water Sanitation and Hygiene
• Use GIS and RS as a tool for monitoring WASH projects Activities
• Assess spatial data availability
• Understand the importance of Spatial Data Infrastructure (SDI) in WASH programs
• Use participatory GIS (PGIS) at the community level
• Carry out water and sanitation modeling using GIS
• Collect data using Mobile data gathering tools
• Carry out basic data analysis using statistical software
• Design and implement their own GIS projects that integrate remote sensing data, 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

• This course is delivered by our seasoned trainers who have vast experience as expert professionals in the respective fields of practice. The course is taught through a mix of practical activities, theory, group works and case studies.
• Training manuals and additional reference materials are provided to the participants.
• Upon successful completion of this course, participants will be issued with a certificate.