Better and Timely Data Collection, Analysis and Visualization using ODK, SPSS, Stata, R And QGIS Course

Introduction

Evidenced based policies for sustainable development and better lives call for better data. Improving the capacity of people involved in data collection, analysis and report writing in ensuring quality data is of significance. Following the changing data environment from use of paper in capturing data to use of digital innovation, there is need to train actors involved in data collection to help them adapt to the upcoming innovations and technologies. Some of the data that are collected through the new technologies include geospatial data, mobile phone, administrative data and citizen-generated data among others. This 10 days course will equip participants with knowledge on research design, designing data collection tools in mobile data collection enabled software, GIS and remote sensing, exporting data to various data collection software, data analysis and interpretation.

Who should attend

• Policy makers
• Researchers
• NGO and civil society staffs
• Educators
• Post graduate students
• Private sector representatives
• Media staffs
• Civil Society Organizations

Requirements

Participants should be reasonably proficient in English. Applicants must live up to Livecode admission criteria

Duration

10 Days

Course objectives

The training will enable participants to;

• Understand various data collection techniques and data processing methods
• Design data collection tools in google phone/ ODK/CTO/ CSpro (participants’ choice)
• Learn how to use mobile phones in  data collection(Open data Kit/CTO/CSpro)
• Learn how to integrate socio economic data with GPS coordinates
• Learn how to draw maps using ArcGIS among other software
• Learn how to analyze and visualize data with the aid of GIS techniques

The participants will also get opportunity to interact with practical monitoring and evaluation cases from our consultants with over 10 years’ experience.

Course content

Module 1: Statistical Concepts

• Types of data
• Data Structures and types of variables
• Overviews of software used to digitize paper data collection tools (ODK/CTO/)
• Comparative analysis of various software used to digitize paper data collection tools (ODK/CTO)

Module 2: Mobile Data gathering

• Benefits of Mobile Applications
• Data and types of Data
• Introduction to  common mobile based data collection platforms

Module 3: Managing devices

• Challenges of Data Collection
• Data aggregation, storage and dissemination
• Questionnaire Design 

Module 4: Getting started in ODK/CTO

• Types of questions
• Data types for each question
• Types of questionnaire or Form logic
• Extended data types geoid, image and multimedia

Survey Authoring and Preparation of mobile phone for data collection

• Survey Authoring
• ODK Collect applications: Installing, Configuring the device (Mobile Phones) and uploading the form into the mobile devices

Module 5: Designing forms and advanced survey authoring

• Introduction to XLS forms syntax
• New data types
• Notes and dates
• Multiple choice Questions
• Multiple Language Support
• Hints and Metadata

 Advanced survey Authoring

• Conditional Survey Branching
• Required questions
• Constraining responses
• Skip: Asking Relevant questions
• The specify other
• Grouping questions
• Skipping many questions at once (Skipping a section)
• Repeating a set of questions
• Special formatting
• Making dynamic calculations

Hosting survey data (Online)

• ODK Aggregate
• Uploading the questionnaire to the server

Module 6: Introduction to concepts of GIS and remote sensing

• Spatial data collection techniques
• Using GPS
• Using GPS utility software for managing and downloading and managing data
• Working with data from different sources

Module7: Attributes manipulation in GIS

• GIS software
• GIS system installation and setup
• GIS Data sources and types
• Using Mobile Phones for GIS data collection(ODK and KoBoToolbox
• Importing GPS data to Quantum GIS

Module 8: Visualizing data

• Understand map layers in GIS
• Composing a GIS layout from GIS layers
• Difference between a map and a layout
• Navigate maps

Module 9: Bringing tabular/spreadsheet data into a GIS (Excel, SPSS, Access )

• Connecting visual map features and tabular data
• Selecting subsets of map features from geo processing
• Finding map features
• Use data sorting records and labeling features to produce information
• Key elements of a map
• Composing a map

Module 10: Data interpretation and report writing

• Different research outputs
• Writing different research outputs from analysed data (case studies, success stories, policy briefs, evidence briefs, journal articles e.t.c)

Tailor-made courses 

This training course can also be tailored for your organization. This way, your organization will benefit by: 

• Using your own datasets and tools during the training.
• Being able to choose areas of interest you wish the trainer to put more emphasis on.
• Taking the course in-house or at a venue of choice.
• Cutting on the cost of transport and accommodation.

REQUIREMENTS

Participants should be reasonably proficient in English.

METHODOLOGY

The instructor led trainings are delivered using a blended learning approach and comprises of presentations, guided sessions of practical exercise, web based tutorials and group work. Our facilitators are seasoned industry experts with years of experience, working as professional and trainers in these fields.

All facilitation and course materials will be offered in English. The participants should be reasonably proficient in English.

All facilitation and course materials will be offered in English. Participants should be reasonably proficient in English.

Accreditation

Upon successful completion of this training, participants will be issued with a certificate of participation.

 Training venue

The training is residential and will be held at the Livecode Technologies Training Centre in Westlands, Nairobi, Kenya. The course fee covers the course tuition, training materials, two break refreshments, lunch, and study visits.

All participants will additionally cater for their, travel expenses, visa application, insurance, and other personal expenses.

 Accommodation

Accommodation is arranged upon request. For reservations contact the Training Officer.

Email: This email address is being protected from spambots. You need JavaScript enabled to view it.

Mobile Number: +254 725 771 853

Training fee

The course fee is KES 140,000.00 or USD 2,000.00 exclusive of VAT. The course fees covers the course tuition, training materials, two (2) break refreshments, lunch and study visits. Participants will cater for their travel and accommodation costs.

Payment

Payment should be transferred to Livecode Technologies account through Kenya Commercial bank on or before the course starting date.

Send proof of payment to This email address is being protected from spambots. You need JavaScript enabled to view it.

Tailor- Made

This scheduled course can also be tailored for your organization. To find out how our tailor-made training can help your organization, contact our team through This email address is being protected from spambots. You need JavaScript enabled to view it.

Please Note: The program content shown here is for guidance purposes only. Our continuous course improvement process may lead to changes in topics and course structure.