Foscore Development Center, Transnational Plaza, Mama Ngina Street 5th Floor, Nairobi Kenya

Sep 12th 2022

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

By: Foscore Development Center

Attendees

About

GIS and Data Analysis for WASH (Water Sanitation and Hygiene) Programmes Course on 12th to 23rd September 2022

Course calendar

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.

Duration

10 days

Course Objectives

  • Use GIS and Remote Sense as a tool for monitoring WASH projects Activities

  • Assess spatial data availability

  • Use participatory GIS (PGIS) at community level

  • Understand the importance of Spatial Data Infrastructure (SDI) in WASH programs

  • Evaluate the spatial data requirements in Water Sanitation and Hygiene

  • Design and implement their own GIS projects that integrate remote sensing data, GPS-based field information in a proper geospatial framework

  • Carry out water and sanitation modeling using GIS

  • Collect data using Mobile data gathering technology

  • Carry out basic data analysis using statistical software

 

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