1 / 23

Enhancing Data Analysis and Reporting in Health Units: Insights from the 3rd Annual RRFSS Workshop

The 3rd Annual RRFSS Workshop, held on June 23, 2004, focused on improving efficiency in data analysis and reporting among participating health units. Key objectives included fostering collaboration and promoting RRFSS results within government agencies. The methodology detailed the processes of data analysis using SPSS, data sharing agreements, and result posting. Notable findings from 2001 and 2002 highlighted the evolution of core module results across various health units. Challenges in data analysis were discussed, alongside experiences from RRFSS representatives, paving the way for future improvements.

libby-perkins
Télécharger la présentation

Enhancing Data Analysis and Reporting in Health Units: Insights from the 3rd Annual RRFSS Workshop

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. RRFSS Web Site Result Posting Project Hong Ge, Epidemiologist Simcoe County District Health Unit 3rd Annual RRFSS Workshop June 23, 2004

  2. www.cehip.org/rrfss

  3. Outline • Background • Methodology • Result • Experience • Plan

  4. Background • Health unit specific core module results • 1999 Durham pilot result • 2001 results • 6 health units • 17 core modules • 2002 results • 18 health units • 15 core modules

  5. Background (cont’d) • Objectives • To increase the efficiency at the health unit level for data analysis and reporting • To heighten collaboration and consultation among RRFSS participating health units • To promote RRFSS and the use of RRFSS results among government agencies and other community organizations

  6. Background (cont’d) • Process • When health units receive complete RRFSS data from previous year • Health units sign Data Sharing Agreement • Core module data analysis • Result posting • Ongoing project

  7. Methodology • Process of data analysis and result posting • Data analysis: SPSS • Export results to EXCEL for formatting • Transform to htm pages • Post the htm pages on the website

  8. Methodology (cont’d) SPSS data Macros.SPS Data analysis (SPSS) Analysis.SPS

  9. Methodology (cont’d) SPSS data Data analysis (SPSS) Core module result (SPSS data format)

  10. Methodology (cont’d) SPSS data Data analysis (SPSS) Core module result (SPSS data format) Export to EXCEL

  11. Methodology (cont’d) SPSS data Data analysis (SPSS) Core module result (SPSS data format) Export to EXCEL Tables and graphs in EXCEL

  12. Methodology (cont’d) SPSS data Data analysis (SPSS) Core module result (SPSS data format) Export to EXCEL Tables and graphs in EXCEL Export to HTM pages and post the pages

  13. Methodology (cont’d) SPSS data Data analysis (SPSS) Core module result (SPSS data format) Discussed in the next 3 slides Export to EXCEL Tables and graphs in EXCEL Export to HTM pages and post the pages

  14. Methodology • Data analysis is using SPSS • Two SPSS syntax files • SPSS macros define: • Proportion, weighted or un-weighted • 95% confidence intervals • Results by age group and gender

  15. Methodology (cont’d) • SPSS macros define releasing criteria: • Denominator less than 30 not to be released • Numerator less than 5 not to be released • Coefficients of variation (CV)

  16. Methodology (cont’d) Example: flu shot • Use the macros • Dummy variable • Non grouping • Grouping • Results Yes dm1 !w invar=dm1 vblbl='Yes'. !wgp grpvb=rgender grp=1 invar=dm2 grpc='Male' vblbl=‘Yes' .

  17. Methodology (cont’d) • References • RRFSS Data Dictionarieswww.cehip.org/rrfss • RRFSS Data Analysis General Principles and Guidelines

  18. Results • RRFSS core module results posted on the website • Health unit specific results • 2001: 24 indicators • 2002: 36 indicators • Technical information for sharing • SPSS syntax files

  19. Experiences • Data analysis: team work from RRFSS representatives • CEHIP hosts RRFSS website • 2002 student project funded by CEHIP • 2003 student project from Hamilton

  20. Challenges • Methodology • Data dictionaries • Errors in data analysis • Data analysis guideline • Don’t know • Refusal • 2004 revision • Web site data analysis guideline: Not Stated

  21. Challenges (cont’d) • Staff • Volunteers from RRFSS representatives • Time • Skill • Promotion

  22. Plan • 2003 core module result • 19 Health units agreed on Data Sharing Agreement • Data analysis: 2 RRFSS representatives • Posting: CEHIP and 1 student • Seek helps from other organizations • Potential interactive web pages • Future: 2004 ……

  23. Questions

More Related