Katherine Kirkby, Daniel A Antiporta, Anne Schlotheuber, Ahmad Reza Hosseinpoor
{"title":"使健康不平等分析便于使用:世卫组织使用 Microsoft Excel 的工具和资源。","authors":"Katherine Kirkby, Daniel A Antiporta, Anne Schlotheuber, Ahmad Reza Hosseinpoor","doi":"10.1186/s12939-024-02229-w","DOIUrl":null,"url":null,"abstract":"<p><p>Addressing health inequity is a central component of the Sustainable Development Goals and a priority of the World Health Organization (WHO). WHO supports countries in strengthening their health information systems in order to better collect, analyze and report health inequality data. Improving information and research about health inequality is crucial to identify and address the inequalities that lead to poorer health outcomes. Building analytical capacities of individuals, particularly in low-resource areas, empowers them to build a stronger evidence-base, leading to more informed policy and programme decision-making. However, health inequality analysis requires a unique set of skills and knowledge. This paper describes three resources developed by WHO to support the analysis of inequality data by non-statistical users using Microsoft Excel, a widely used and accessible software programme. The resources include a practical eLearning course, which trains learners in the preparation and reporting of disaggregated data using Excel, an Excel workbook that takes users step-by-step through the calculation of 21 summary measures of health inequality, and a workbook that automatically calculates these measures with the user's disaggregated dataset. The utility of the resources is demonstrated through an empirical example.</p>","PeriodicalId":13745,"journal":{"name":"International Journal for Equity in Health","volume":null,"pages":null},"PeriodicalIF":4.5000,"publicationDate":"2024-10-09","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"https://www.ncbi.nlm.nih.gov/pmc/articles/PMC11465631/pdf/","citationCount":"0","resultStr":"{\"title\":\"Making health inequality analysis accessible: WHO tools and resources using Microsoft Excel.\",\"authors\":\"Katherine Kirkby, Daniel A Antiporta, Anne Schlotheuber, Ahmad Reza Hosseinpoor\",\"doi\":\"10.1186/s12939-024-02229-w\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"<p><p>Addressing health inequity is a central component of the Sustainable Development Goals and a priority of the World Health Organization (WHO). WHO supports countries in strengthening their health information systems in order to better collect, analyze and report health inequality data. Improving information and research about health inequality is crucial to identify and address the inequalities that lead to poorer health outcomes. Building analytical capacities of individuals, particularly in low-resource areas, empowers them to build a stronger evidence-base, leading to more informed policy and programme decision-making. However, health inequality analysis requires a unique set of skills and knowledge. This paper describes three resources developed by WHO to support the analysis of inequality data by non-statistical users using Microsoft Excel, a widely used and accessible software programme. The resources include a practical eLearning course, which trains learners in the preparation and reporting of disaggregated data using Excel, an Excel workbook that takes users step-by-step through the calculation of 21 summary measures of health inequality, and a workbook that automatically calculates these measures with the user's disaggregated dataset. The utility of the resources is demonstrated through an empirical example.</p>\",\"PeriodicalId\":13745,\"journal\":{\"name\":\"International Journal for Equity in Health\",\"volume\":null,\"pages\":null},\"PeriodicalIF\":4.5000,\"publicationDate\":\"2024-10-09\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"https://www.ncbi.nlm.nih.gov/pmc/articles/PMC11465631/pdf/\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"International Journal for Equity in Health\",\"FirstCategoryId\":\"3\",\"ListUrlMain\":\"https://doi.org/10.1186/s12939-024-02229-w\",\"RegionNum\":2,\"RegionCategory\":\"医学\",\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"Q1\",\"JCRName\":\"PUBLIC, ENVIRONMENTAL & OCCUPATIONAL HEALTH\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"International Journal for Equity in Health","FirstCategoryId":"3","ListUrlMain":"https://doi.org/10.1186/s12939-024-02229-w","RegionNum":2,"RegionCategory":"医学","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"Q1","JCRName":"PUBLIC, ENVIRONMENTAL & OCCUPATIONAL HEALTH","Score":null,"Total":0}
引用次数: 0
摘要
解决卫生不平等问题是可持续发展目标的核心内容,也是世界卫生组织(世卫组织)的优先事项。世卫组织支持各国加强卫生信息系统,以便更好地收集、分析和报告卫生不平等数据。改进有关卫生不平等的信息和研究对于确定和解决导致较差卫生结果的不平等问题至关重要。培养个人的分析能力,特别是在资源匮乏地区,可以增强他们的能力,建立更强大的证据基础,从而做出更明智的政策和计划决策。然而,健康不平等分析需要一套独特的技能和知识。本文介绍了世卫组织开发的三种资源,以支持非统计用户使用 Microsoft Excel(一种广泛使用且易于获取的软件程序)分析不平等数据。这些资源包括一个实用的电子学习课程,培训学习者如何使用Excel准备和报告分类数据;一个Excel工作手册,指导用户逐步计算21个卫生不平等汇总指标;以及一个工作手册,利用用户的分类数据集自动计算这些指标。这些资源的实用性将通过一个经验范例来展示。
Making health inequality analysis accessible: WHO tools and resources using Microsoft Excel.
Addressing health inequity is a central component of the Sustainable Development Goals and a priority of the World Health Organization (WHO). WHO supports countries in strengthening their health information systems in order to better collect, analyze and report health inequality data. Improving information and research about health inequality is crucial to identify and address the inequalities that lead to poorer health outcomes. Building analytical capacities of individuals, particularly in low-resource areas, empowers them to build a stronger evidence-base, leading to more informed policy and programme decision-making. However, health inequality analysis requires a unique set of skills and knowledge. This paper describes three resources developed by WHO to support the analysis of inequality data by non-statistical users using Microsoft Excel, a widely used and accessible software programme. The resources include a practical eLearning course, which trains learners in the preparation and reporting of disaggregated data using Excel, an Excel workbook that takes users step-by-step through the calculation of 21 summary measures of health inequality, and a workbook that automatically calculates these measures with the user's disaggregated dataset. The utility of the resources is demonstrated through an empirical example.
期刊介绍:
International Journal for Equity in Health is an Open Access, peer-reviewed, online journal presenting evidence relevant to the search for, and attainment of, equity in health across and within countries. International Journal for Equity in Health aims to improve the understanding of issues that influence the health of populations. This includes the discussion of political, policy-related, economic, social and health services-related influences, particularly with regard to systematic differences in distributions of one or more aspects of health in population groups defined demographically, geographically, or socially.