GIS and Data Analysis for WASH (Water Sanitation and Hygiene) Programmes Course

Introduction

Geographic Information System (GIS) will allow you to bring all types of data inform of layers, overlay them to perform analysis and eventually publish a map from that. Giving a spatial dimension to data and performing spatial analysis in a GIS environment enhances the interpretation which eventually speeds up implementation of programs. Integrating GIS and Remote Sensing as a decision-making tool has seen many organizations gain competitive advantage and remain relevant globally. Once the data is collected, participants will be equipped with analyses skills using Microsoft Excel program where techniques on handling both qualitative and quantitative data will be illustrated. It’s a known fact that information is processed from facts and figures.

10 days

Course Outline

Introduction and definitions of key concepts

·         Review of WASH concepts

·         Introduction to GIS concepts

·         Introduction to GIS Software (QGIS) include outline of the introduction QGIS

GIS Principles

·         Principles of GIS

·         Components of GIS Systems

·         GIS Capabilities and Functions in the context of WASH

·         Spatial Data Infrastructure in WASH

GPS configuration and GPS Data Collection

·         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

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)

Development and presentation of maps

·         GIS Mapping

·         Styling and symbolization

·         Mapping resources/Project activities

Online Mapping

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

·         Basic analysis and Geo processing

·         Online Mapping – Google Maps and Fusion Tables

Case study: 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

Mobile Phones for data Collection Technology

·         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

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

Qualitative and Quantitative Data Analysis

·         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