Voice Data Literacy Training Program

About Course

This course is designed to equip learners with basic data skills that allow them to collect and analyse data, and prepare data for dissemination.

About Course

This course is designed to equip learners with basic data skills that allow them to collect and analyse data, and prepare data for dissemination.

Conduct high-quality rapid research and use the results directly for policy analysis or decision-making
Managing data effectively
Extracting and collecting data from various sources
Using Microsoft Excel and Google Sheets to manipulate, visualise and analyse data
Preparing professional and effective policy briefs
Communicating research findings to the target audience effectively

Course Curriculum

Course Introduction

Module Introduction
Learning Objectives
Course Requirements
Course Schedule
Deliverables and Capstone Project

Introduction to research methods

Extracting data
For this topic, you'll need Microsoft Excel

Qualitative Data analysis

Quantitative Data analysis

Quantitative Analysis Intro
Introduction to Excel
Intro to functions
Intro to Pivoting tables
When to use Pivot tables
Create pivot table
Customising the pivot table
Bonus Pivot table features & Special Excel tables
Bonus Excel camera
AVERAGE, MIN, MAX, MODE, MEDIAN, COUNT
Summary statistics & Special Excel tables
Wrap-up and bonus feature
Quantitative Analysis Assignment
Pivot tables & Summary stats assignment

Data visualisation:

Reporting findings

Research Ethics

Data Protection

Student Ratings & Reviews

No Review Yet

Course Curriculum

Course Introduction

Module Introduction
Learning Objectives
Course Requirements
Course Schedule
Deliverables and Capstone Project

Introduction to research methods

Extracting data
For this topic, you'll need Microsoft Excel

Data Collection Intro
Data from PDFs & images
Other sources of data
Survey tools
Create a google form and survey design
Pre-existing datasets
Outro and extracting data from a google form
Data extraction assignment
Data collection Assignment

Qualitative Data analysis

Quantitative Data analysis

Quantitative Analysis Intro
Introduction to Excel
Intro to functions
Intro to Pivoting tables
When to use Pivot tables
Create pivot table
Customising the pivot table
Bonus Pivot table features & Special Excel tables
Bonus Excel camera
AVERAGE, MIN, MAX, MODE, MEDIAN, COUNT
Summary statistics & Special Excel tables
Wrap-up and bonus feature
Quantitative Analysis Assignment
Pivot tables & Summary stats assignment

Data visualisation:

Reporting findings

Research Ethics

Research Ethics Overview
Research Ethics Quiz
Intro to Research Ethics
Beneficence
Ethical Approval
Informed Consent
Just Selection
Respect
Vulnerability

Data Protection

Categories Data Skills

Free

Free access this course

Level

All Levels
Last Updated

July 10, 2023
Certificate

Certificate of completion

Course Instructor

Shem Opolot

Course Instructor

Voice Data Literacy Training Program

About Course

About Course

What You will learn

Course Curriculum

Course Introduction

Module Introduction

Learning Objectives

Course Requirements

Course Schedule

Deliverables and Capstone Project

Introduction to research methods

Introduction to research methods

Context Introduction

Understanding the context

Channels of communication

Research question & 3-minute story Assignment

Question Time

Extracting data For this topic, you'll need Microsoft Excel

Data Collection Intro

Data from PDFs & images

Other sources of data

Survey tools

Create a google form and survey design

Pre-existing datasets

Outro and extracting data from a google form

Data extraction assignment

Data collection Assignment

Qualitative Data analysis

Interview Types Assignment

Thematic & content analysis

Quantitative Data analysis

Quantitative Analysis Intro

Introduction to Excel

Intro to functions

Intro to Pivoting tables

When to use Pivot tables

Create pivot table

Customising the pivot table

Bonus Pivot table features & Special Excel tables

Bonus Excel camera

AVERAGE, MIN, MAX, MODE, MEDIAN, COUNT

Summary statistics & Special Excel tables

Wrap-up and bonus feature

Quantitative Analysis Assignment

Pivot tables & Summary stats assignment

Data visualisation:

Intro to Data Visualisation

Bar or column chart

Common visualisations

Line graph

Pie chart in Excel

Choosing the right visual

Conclusion

Reporting findings

Introduction to Reporting findings

How to write well

Formats for a research paper

Format for policy brief

Research Ethics

Research Ethics Overview

Research Ethics Quiz

Intro to Research Ethics

Beneficence

Ethical Approval

Informed Consent

Just Selection

Respect

Vulnerability

Data Protection

Data Protection Module

Data Protection Quiz

Student Ratings & Reviews

Course Curriculum

Course Introduction

Module Introduction

Learning Objectives

Course Requirements

Course Schedule

Deliverables and Capstone Project

Extracting data
For this topic, you'll need Microsoft Excel

Extracting data
For this topic, you'll need Microsoft Excel