Data Analysis & Management using Advanced Excel, SPSS & STATA Training
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 organization’s, 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, Liberia,The Gambia, Tanzania, Pakistan, 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
- 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
Who Should Attend?
- The course is recommended for the following;
- Departmental heads
- Data manager
- Research students
- Project or Departmental managers
- Project officers
- Staffs involved in making informed decision
- Anyone involved in development project
- Anyone who aspires to be a good manager
- Researchers & M&E officers.
Embrace use of data in informed decision making.
Main 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
-
Understand 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 summarise 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
How to Register: Kindly apply through the following link or drop us mail at info@aspm.co.ke or through. Online Application