GIS and Statistical Analysis for WASH Programmes

 Introduction

GIS technology can be integrated in the implementing and monitoring of target based interventions in water sanitation and hygiene (WASH). The technology helps creating model of complex environment in a simpler and easier way that enhance understanding of the environment, paving way for proper and informed decisions. Free open source GIS software for both desktop and web application is opening up possibilities for capturing and processing geographical data, and then publishing maps via the internet.

DURATION

5 Days

 COURSE OUTLINE

Module 1: Introduction and definitions of key concepts

•        Review of WASH concepts

•        Introduction to GIS concepts

•        Introduction to GIS Software (QGIS)

1.        Principles of GIS
2.        Components of GIS Systems
3.        GIS Capabilities and Functions in the context of WASH
4.        Spatial Data Infrastructure in WASH

•        GPS, GLONAS and GIS

1.        Introduction to GPS and Global Navigation Satellites
2.        GPS configuration, Capturing data from surveys
3.        GPS download and related tasks
4.        Integrating field GPS data into the GIS database

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 project’s data

•        Basic analysis and Geo processing

•        Online Mapping – Google Maps and Fusion Tables

Module 4: GIS and Remote Sensing as a tool in monitoring WASH projects

•        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 (Correlation, Chi Square, T-Test and ANOVA)

•        Basic Regression Analysis

•        Tabulations and Graphics

•        Statistical Data Analysis with Excel

•        Data Quality reporting