Home Ecourses on Health Inequality analysis using Excel: Disaggregated data  | OpenWHO

Inequality analysis using Excel: Disaggregated data  | OpenWHO

by Superuser
603 views

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.

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.

inequality-monitoring-disaggregation-excel_Nirdesh baral.jpeg
Sample Certificate

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

You may also like

Website logo

Renowned as the #1 website for health updates, news, and vacancies, our platform employs advanced technological frameworks to curate and disseminate a comprehensive array of information. Nepal Health Magazine stands as the premier online platform, spearheaded by a dynamic team of youth-driven professionals, dedicated to delivering precise and current insights into health and wellness. Leveraging cutting-edge algorithms and data analytics, we ensure the utmost accuracy and relevance in delivering the latest news, research findings, and expert perspectives across diverse health domains. Committed to excellence, we continually strive to maintain our position as the authoritative source of health-related knowledge, catering to the discerning needs of our audience.

 
 
 
 

Latest Posts

Editors' Picks

Crafted with ❤ by Nirdesh Baral

Nepal Health Magazine