1 / 23

RRFSS Web Site Result Posting Project

RRFSS Web Site Result Posting Project. Hong Ge, Epidemiologist Simcoe County District Health Unit 3 rd Annual RRFSS Workshop June 23, 2004. www.cehip.org/rrfss. Outline. Background Methodology Result Experience Plan. Background. Health unit specific core module results

arlene
Download Presentation

RRFSS Web Site Result Posting Project

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