About the course
What if you could learn all the skills you need to start your career as a data analyst for social impact/humanitarian programs?
Now you can! This course introduces you to all the data analytics processes from data collection all the way to data analysis using the most popular tools: KoBo Toolbox, Excel and SPSS. The course is packed easy-to-follow video lessons, hands-on activities, and quizzes to cement the concepts in. To top it all, it's FREE!
What you are going to learn
The course is divided into 5 module:
- The introduction module introduces you to the concept of data analytics. You will learn the definition and what's involved in data analytics; the different types and processes in data analytics
- In module 2 you will learn how to develop mobile data collection tools using one of the most popular and free platform KoBo Toolbox. You will develop a form, deploy it on mobile devices, collect data, send the data to the server and download it to be used for analysis
- Then, you will pick off from the data you have collected to clean it in Excel readying it for analyses
- In module 4, you will learn Microsoft Excel's powerful data analytics features. In particular, you will learn how to use Excel tables to sort, filter and summarize data. Then, you will learn ow to use pivot tables and pivot chats to analyze and visualize data
- Finally in module 5, you will learn how to use SPSS for data analyses. You will start by importing data from Excel and editing variables. Then you will move on to summarize the data using frequencies and summary statistics. To finish it off, you will learn how to explore relationships between variables. Throughout the lessons, you will build charts that go together with the analyses mentioned.
Course curriculum
Module 1: Introduction
Available in
days
days
after you enroll
Module 2: Developing mobile data collection tools using Kobo Toolbox
Available in
days
days
after you enroll
- Introduction to mobile data collection (2:35)
- Getting started with KoBo Toolbox (5:30)
- Creating a project and adding questions (3:40)
- Grouping questions (5:16)
- Rosters and question referencing (5:54)
- Calculated fields (2:34)
- Validation logic (5:41)
- Skip logic (4:37)
- GPS (1:42)
- Deploying the form on mobile devices (4:31)
- Data entry and uploading (5:06)
- Accessing and downloading the data (2:40)
- Summary
- Quiz
- Course review
Module 3: Data cleaning using Excel
Available in
days
days
after you enroll
Module 4: Data visualization and analysis using Excel
Available in
days
days
after you enroll
Module 5: Data Analysis using SPSS
Available in
days
days
after you enroll
- Introduction to SPSS for data analysis (1:07)
- Importing data and editing variables (10:14)
- Univariate analysis for categorical variables (3:30)
- Univariate analysis for continuous variables (7:46)
- Exploring relationships between scale and categorical variables (4:01)
- Exploring relationships between 2 categorical variables (5:06)
- Exploring relationships between 2 continuous variables (3:56)
- Summary
- Quiz
- More learning resources
Capstone Project
Available in
days
days
after you enroll
Join the full course
Get this course, plus 7 other self-paced courses including all our weekly live sessions for a low monthly or yearly subscription