Nairobi Training. Data Analysis & Management using Advanced Excel, SPSS & STATA. August 16th-20th, 2021

About ASPM
The Africa School of Project Management (ASPM) was established in the year 2000 in Kenya as a membership based professional management organisation. The school was formed to address capacity building needs among development partners, donor organisations, Government agencies, International and private sector firms in Africa.
The school has been pivotal in capacity building in South Sudan, South Africa, Botswana, Eritrea, Ethiopia, Kenya, Uganda, Congo, Somalia, Tanzania, Burundi and Rwanda. The school has trained over 12,000 staffs who are involved in different projects and also conducted surveys, evaluations and research in different projects and businesses in Africa.

Course Objectives
Upon successful completion of this course participants should be able to:
Discuss the relevance of reliable data collection process in Research and informed decision making
Use relevant computer packages for data management and extrapolation
To introduce the concepts of monitoring and evaluation and the value of implanting it in programs/projects
To focus participant’s attention on monitoring and evaluation study designs
M&E Data Management and Analysis
Appreciate GIS software, data capture methods, analysis, data importation and mapping indicators using GIS Techniques)
Get hands on skills on SPSS & STATA
Conduct project Evaluations

Main Training Modules
Introduction to SPSS & STATA Statistics
 Explain how IBM SPSS Statistics is used for basic analysis
 Explain the basic steps in data analysis
 Understand the primary windows in IBM SPSS Statistics
strong textUnderstand the different components of dialog boxes

Reading data
 Import data from different types of file formats
 Describe choices on the File menu for reading data
 Read Microsoft Excel files
 Read files from a Microsoft Access database
 Read delimited text files

Defining Variable Properties
 Describe and define variable properties in the Variable View window
 Use the Define Variable Properties dialog box
 Save variable properties with data in an IBM SPSS Statistics data file
 Use the Variables utility to view variable properties interactively
 Use the Display Data Dictionary facility and the Codebook procedure to view variable properties

Working with the Data Editor
 Use features in the Data Editor
 Insert, delete, and move variables and cases
 Use the Split Screen view
 Copy information from one dataset to another
 Use the Copy Data Properties feature

Modifying data values: Recode
 Use Visual Binning to reclassify values of an ordinal or scale variable
 Use Recode Into a Different Variable to reclassify values of a nominal variable
 Use Automatic Recode to create a numeric variable from a string variable

Modifying data values: Compute
 Describe the features of Compute Variable
 Create new variables with numeric expressions
 Create new variables with conditional numeric expressions

Summarizing individual variables
 Define levels of measurement
 Use the Frequencies procedure to produce tables and charts appropriate for nominal variables
 Use the Frequencies procedure to produce tables and charts appropriate for ordinal variables
 Use the Frequencies and Descriptive procedure to produce tables and charts for scale variables

Describing relationships between variables
 Select the appropriate procedure to summarize the relationship between two variables
 Use the Crosstabs procedure to summarize the relationship between categorical variables
 Use the Means procedure to summarize the relationship between a scale and a categorical variable

Selecting cases for analyses
 Select cases in a data file using various methods
 Describe and use the features of the Select Cases dialog box
 Describe and use the features of the Split File dialog box

Creating and editing charts
 Present results with charts
 Use the Chart Builder to create various types of graphs
 Format and edit graphs in the Chart Editor

Working in the Viewer
 Navigate through the Viewer
 Perform Automated Output Modification
 Customize a pivot table
 Create and apply a template for a pivot table
 Export output to other applications

Syntax basics
 Use basic syntax to automate analyses
 Use the Syntax Editor environment
 Create syntax
 Run syntax
 Edit syntax

Introduction to Geographic Information System (GIS)
 Introduction to GIS Software (Quantum GIS)
 Mobile GPS Field Work
 Mapping M&E Indicators with Quantum GIS

Way forward After the Training
Participants will develop a work plan through the help of facilitators that stipulates application of skills acquired in improving their organizations. ASPM will monitor implementation progress after the training.

How to Register
Kindly, drop us mail at [email protected] or apply online through the online application on the website Online Application - Africa School of Project Management