This course is a companion course to Stats in Excel 1: Tidy Datasets and Descriptive Statistics. If you are not already familiar with setting up datasets for conducting statistical analysis or descriptive statistics, we recommend you take Stats in Excel 1. This course also requires that you are familiar with some of the advanced features of Excel like setting up pivot tables and using functions. If you do not know how to do these things there are lots of how-to videos and instructions on the internet; just google what do you want to learn about.
Bundle price: We offer a discount of $100 off Stats in Excel 2 if you purchase both Stats in Excel 1 and 2 together. If you have previously purchased Stats in Excel 1, you are also eligible for the discount. Contact einstitute_mgr@evaluationcanada.ca to take advantage of this offer.
This self-paced course provides step-by-step instructions and best practices for performing common inferential statistical analyses using Microsoft Excel. You will learn some of the most common analyses used in evaluations including how to find associations between variables, testing for a linear relationship between variables, and comparing groups.
Course Objectives:
By the end of this course you will be able to:
Estimated time to complete: 10 hours
Prerequisites: Prior knowledge of evaluation and of descriptive statistics
Evaluation Competencies addressed: [ ] reflective; [x] technical; [ ] situational; [ ] management; [ ] interpersonal
Note: For all self-paced courses on the e-Institute, you will be granted access once payment is received in full. You then have three months to complete the course starting from the date access is granted.
300
This self-paced course covers all aspects of qualitative data analysis including creating an analytic framework, creating a codebook, coding data, selecting software to analyze qualitative data, increasing the trustworthiness of the analysis, and presenting qualitative data in reports.
Interventions are becoming increasingly complex as designers adopt holistic approaches to solving social problems. This course covers how to know whether a systems approach is right for the intervention you are evaluating, define the complex intervention for evaluation purposes, and evaluate its interdependencies and emergent properties.