Inequality analysis using Excel: Disaggregated data | OpenWHO :Disaggregated data – data that are broken down by population subgroups – are essential for monitoring inequalities in health. They offer important insights into the health experience of subgroups that are masked by national (or overall) averages. In this practical course, students will learn the main steps and considerations for preparing and reporting disaggregated data using Microsoft Excel, including how to prepare datasets for the analysis of health inequalities using the WHO Health Equity Assessment Toolkit (HEAT Plus) software application.
Disaggregated data refer to data that are broken down by population subgroups, defined by demographic, socioeconomic or geographic criteria. These subgroups serve as the basis of comparison for health inequality analysis. Disaggregated data offer important insights into the health experience of subgroups that are often masked by national (or overall) averages. These data can come from a range of sources, including household surveys and administrative data. Statistical software programmes are useful to facilitate the preparation, analysis and reporting of disaggregated data.
The aim of this course is to provide learners with a practical guide to the preparation of disaggregated datasets using Microsoft Excel. These datasets can then be analysed using the WHO Health Equity Assessment Toolkit (HEAT Plus) software application. The course introduces learners to a set of formulas and processes in Excel for disaggregated data preparation and reporting, demonstrated through examples using sample datasets. The target audience is monitoring and evaluation officers, data analysts and other technical officers with an interest in data analysis. The course may also be of interest to students and researchers.
Course duration: Approximately 2 hours
Certificates: A Certificate of Achievement will be available to participants who score at least 80% of the total points available in the final assessment. Participants who receive a Certificate of Achievement can also download an Open Badge for this course. Click here to learn how.
Table of Contents
What you’ll learn
- Understand the use of disaggregated data in health inequality monitoring
- Use key Excel formulas to prepare disaggregated datasets
- Produce estimates of health indicators disaggregated by a variety of inequality dimensions
- Produce graphs in Excel that visualise disaggregated data using good reporting practices
- Prepare datasets for use in the WHO Health Equity Assessment Toolkit (HEAT Plus)
Course contents of Inequality analysis using Excel: Disaggregated data | OpenWHO
- Introduction:This introduction module gives a brief overview of disaggregated data and their use in health inequality monitoring, introduces Microsoft Excel and sets the scene for the skills learners can expect to gain from the course.
- Module 1: Preparing disaggregated datasets – part 1:Module 1 covers basic steps for preparing disaggregated datasets in Excel. By the end of the module, you will be able to calculate disaggregated estimates for population subgroups; join information from different datasets; and manage errors in formulas.
- Module 2: Preparing disaggregated datasets – part 2 :Module 2 covers more advanced steps for preparing disaggregated datasets in Excel. By the end of this module, you will be able to aggregate data to categorise population subgroups; use relative and absolute cell references in formulas; and combine datasets, including merging data based on multiple conditions.
- Module 3: Creating graphs :Module 3 covers an overview of presenting disaggregated data in graphs in Excel. By the end of this module, you will be able to visualise disaggregated data in bar graphs and Equiplots (horizontal circle graphs), applying good visualisation practices.
- Module 4: Formatting disaggregated data for use in HEAT Plus:Module 4 covers the steps to format a dataset with disaggregated data for its use and exploration with the Health Equity Assessment Toolkit (HEAT Plus) software. By the end of this module, you will be able to identify the key columns necessary for HEAT Plus and construct them, if missing; combine disaggregated data with data from other tables; and perform relevant quality checks.
- Final Assessment
Certification for Course
Record of Achievement certification is to be earned at least 80% of the maximum number of points from all graded assignments.
- Webinar on World Hand Hygiene | Register today
- World’s First 5-in-1 vaccine against meningitis | Men5CV
- World Health Worker Week 2024 | Know theme
- World Autism Awareness Day 2024 | Know theme
- Staff Nurse | OCH | latest jobs vacancy 2024
- World Hepatitis Summit 2024 | WHO
- Staff Nurse | TLMN | ngo jobs 2024
- World Health Day 2024 | Know theme
- Measuring access to assistive technology in Nepal | Country Report
- Migration Health Nurse | IOM | ingo jobs
- Nursing Officer | Kopila Valley | nursing jobs 2024
- Benefits and risks of using artificial intelligence for pharmaceutical development and delivery | WHO
bachelor jobs bph jobs covid19 health health for all health guidelines new health jobs healthjobs healthjobs in nepal health jobs vacancy health public health update ingo jobs jobs after passing bachelor jobs for bph jobs in nepal jobs in ngo ngo jobs ngo jobs vacancy ngo jobs vacancy for bph ngo job vacancy 2021 nurse jobs nurse jobs 2021 nurse vacancy nursing insurance nursing job nursing jobs nursing jobs 2021 nursing jobs in nepal nursing law nursing officer Nursing Vacancy Public health Public health concern public health important days Public health in Nepal publichealth jobs public health updated Staff Nurse Staff Nurse and HA Vacancy | Nepal Army 2021 staff nurse vacancy staff nurse vacancy in ngo 2021 nepal staff nurse vacancy kathmandu who guidelines WHO official
Hey ! I am Nepal Health Magazine Bot , yet powerful enough to approve, disapprove , delete, ban anything and anyone.
