Illinois Department of Public Health
Illinois Project for Local Assessment of Needs
IPLAN Process
Step 3 Tools: Analysis of Health Priorities and Health Data
Community Obesity Prevention Initiative (Connecticut's Online Clearinghouse for Continuing Education and Training Opportunities in Public Health)
Link:
http://www.cthaned.org/HEALRT/SM_J.ppt
Description:
This Power Point presentation template is for beginning a campaign to collect data on obesity within a community. This project creates an opportunity for us to evaluate resources and attitudes impacting health behaviors among residents and employees and generate a community response to America’s obesity epidemic.
Healthy Delaware 2010 Stakeholder Interview Guide (Public Health Foundation)
Link:
http://www.phf.org/pmqi/HPtools/state/Ident-B.pdf
Description:
This Power Point template outlines a project to create an opportunity to evaluate resources and attitudes impacting health behaviors among residents and employees and generate a community response to America’s obesity epidemic.
Healthy Delaware 2010: Chamber of Commerce Member Questionnaire (Public Health Foundation)
Link:
http://www.phf.org/pmqi/HPtools/state/Ident-D.pdf
Description:
This is a questionnaire to help a steering committee create a plan to engage private and public sectors in health efforts. The purpose of this questionnaire is to collect information from stakeholders before planning begins. This information will help the steering committee focus its efforts, create a plan that people will use, and engage both the private and public sectors in important health efforts. As the plan is developed, there will be other opportunities for public input and involvement.
Example Community Health Survey Mendocino County Community Health Survey 2001 (Mendocino County)
Link:
http://www.co.mendocino.ca.us/ph/pdf/CHSresultsAll.pdf
Description:
This survey is one component of the Community Themes and Strengths Assessment as defined by the National Association of County and City Health Officials (NACCHO) in its community-wide strategic planning tool called MAPP, Mobilizing for Action Through Planning and Partnerships. The purpose of this survey is to identify community health problems and issues in Mendocino County.
Guide to Collecting Data (Minnesota Department of Health Community Health Check)
Link:
http://www.health.state.mn.us/divs/hpcd/chp/hpkit/text/hcheck_main.htm
Description:
Website with links to Tip Sheets, Worksheets and Checklists on collecting and analyzing data.
Survey Design Part 1: Sampling UNC 422a (University of North Carolina)
Link:
Description:
This three hour course offered by the Center for Public Health Preparedness at the University of North Carolina (UNC) at Chapel Hill provides an overview of Sampling. Each part includes an audio tutorial. A certificate of completion is provided by UNC.
Cancer Control PLANET On-line Training (Train.org)
Link:
Description:
This online course focuses on designing, implementing and evaluating evidence-based cancer control programs. Cancer Control PLANET is an Internet portal, or gateway. But more than that, it is also a lens to help planners, program staff, and researchers focus on critical information that can help in designing, implementing, and evaluating evidence-based cancer control programs. Cancer Control PLANET is aimed at helping public health planners and practitioners find practice tools, based on research, that best integrate science with service.
Public Health Data: Our Silent Partner (National Center for Health Statistics)
Link:
http://www.cdc.gov/nchs/products/training/phd-osp.htm
Description:
This course, based on a video tape and workbook, was developed to improve the ability of public health professionals to understand and use data in their jobs. The video tape portrays three situational case studies that call for the use of public health data.
Cause Analysis Tools: Scatter Diagram (American Society for Quality)
Link:
http://www.asq.org/learn-about-quality/cause-analysis-tools/overview/scatter.html
Description:
This webpage refreshes researchers on how and when to use a scatter plot, along with illustrated examples of what one should look like.
Check Sheet--Weekly : (American Society for Quality)
Link:
http://www.asq.org/learn-about-quality/data-collection-analysis-tools/overview/data-analysis.xls
Description:
The Check Sheet- Weekly worksheet allows users to enter data that can be printed by individuals for use in data collection. The following charts will automatically be generated: Histogram: shows the number of defects over time; Bar Chart: shows the number/count of defects; Pareto Chart: displays the 80/20 rule for defects.
Basic Definitions Pennsylvania Department of Health: Health Statistics- Technical Assistance Tools of the Trade (Penn Department of Health)
Link:
http://www.health.state.pa.us/hpa/stats/techassist/tools.htm
Description:
This websites provides four main categories of reports with technical assistance on health stats: Statistical Measurements, Data Analysis, Charts and Graphs, and Data Collection/Processing.
Deciding on Methods Pennsylvania Department of Health: Health Statistics- Technical Assistance Tools of the Trade (Penn Department of Health)
Link:
http://www.health.state.pa.us/hpa/stats/techassist/flow1a.htm
Description:
This page provides a table illustrating good practice in calculating reliable rates and standardized ratios.
Deciding When To Compare Pennsylvania Department of Health: Health Statistics- Technical Assistance Tools of the Trade (Penn Department of Health)
Link:
http://www.health.state.pa.us/hpa/stats/techassist/flow1b.htm
Description:
This page provides a table illustrating the validity of the comparison of certain rates and percentages.
Community Risks and Protective Factors 424 PH (Illinois Public Health Preparedness Center)
Link:
Description:
This course was created by the Illinois Public Health Preparedness Center and is part of the Community Health Assessment (PH 420) course series. These courses can be taken separately and in any sequence desired. The overall PH 420 series covers the public health function of assessment. Content includes measurement of selected determinants of community health status and use of health services, identifying community assets, selecting appropriate qualitative or quantitative tools, maximizing community participation, ethical issues in use of power and authority, capacity-building and consultation in the community and moving from aggregate or state level data to a smaller, defined population.
Preparedness Center Training Catalog (North Carolina Center for Public Health Preparedness)
Link:
http://nccphp.sph.unc.edu/training/training_list/?mode=view_cat_detail&cat_id=228
Description:
This website provides a list of statistical trainings available including Advanced Data Analysis, and Data Analysis Basics.
California Distance Learning Health Network's Presenting Health Data Parts 1 & 2
Link:
http://cdlhn.com/default_p.cfm?sku=PRE_030818_520&type=phc&CFID=2001037&CFTOKEN=71941852
Description:
This webcast is dedicated to effective ways to present health data including primary types of data displays, the appropriate uses for various types of charts and graphs, the importance of scale for the X & Y axis, and common mistakes in axes construction.
Public Health Information and Data Tutorial: Using Data, Tools for Building Reports and Tables (Partners in Information Access for the Public Health Workforce)
Link:
http://phpartners.org/tutorial/03-hs/3-sources/3.3.7.html
Description:
This website provides links to many resources to help users build reports and tables.
Public Health Informaiton and Data Tutorial: Resources to Help You Learn More (Partners in Information Access for the Public Health Workforce)
Link:
http://phpartners.org/tutorial/03-hs/3-sources/3.3.8.html
Description:
This website provides a list of links including training on Behavioral Risk Factor Surveillance System, and many glossaries of public health terms.
Understanding Public Health Data (United Kingdom National Health Service)
Link:
http://www.avon.nhs.uk/phnet/PHinfo/understanding.htm
Description:
This website provides information on the following topics: measuring disease and rates.
Age- Adjusted Rate (State of Missouri Department of Health and Senior Services)
Link:
http://www.dhss.mo.gov/CDP_MICA/AARate.html
Description:
This webpage provides a comprehensive explanation of age-adjusted rates, how they are calculated and where they are most appropriately used.
Why and How Do We Calculate Age-Adjusted Rates? (University of Albany School of Public Health)
Link:
http://www.albany.edu/sph/data/age_adjustment.pdf
Description:
This three page document addresses age-adjusted rates through examples, graphs and tables.
SEER Stat Tutorials: Calculating Age-adjusted Rates (National Cancer Institute)
Link:
http://seer.cancer.gov/seerstat/tutorials/aarates/definition.html
Description:
This webpage provides users definitions, equations and a link to a tutorial on the steps of calculating the age-adjusted rate.
Appendix: Using Health Data from Your Community to Your Advantage (Diabetes Prevention and Management)
Link:
http://www.asaging.org/cdc/module7/phase5/phase5_14.cfm
Description:
This page explains age-adjusted rate, provides examples of when to use this rate and how to use the rate in a grant proposal.
Understanding Confidence Intervals (University of Albany School of Public Health)
Link:
http://www.albany.edu/sph/data/confidence_intervals.pdf
Description:
This five page document provides a comprehensive explanation of confidence intervals along with graphics explaining its statistical foundation.
The Strenghts and Limitations of Meta-analysis based on Aggregate Data (National Institute of Health)
Link:
http://www.pubmedcentral.nih.gov/articlerender.fcgi?artid=1097735
Description:
This document provides an explanation of the usefulness of the summarization of research while assessing cancer data.
Community Health Assessment Glossary (State of Florida Department of Health)
Link:
Description:
This three page document provides a list of public health terms and definitions.
Related tools:
Public Health Information and Data: A Training Manual (National Network of Libraries of Medicine)
Link:
http://phpartners.org/pdf/phmanual.pdf
Description:
Public Health Information and Data: A Training Manual is a 122 page document that supports instruction provided to members of the public health workforce on issues related to information access and management. This manual is intended primarily for librarians and others who may be responsible for developing training events. Published in May 2004.
Quick Health Data online (The Office on Women's Health, US Department of Health and Human Services)
Link:
http://www.healthstatus2010.com/owh
Description:
This database provides online access to county level health data for women. The system provides state and county-level data for all 50 states, the District of Columbia, and US territories and possessions. Data are available by gender, race and ethnicity and come from a variety of national and state sources. The system is organized into eleven main categories, including demographics, mortality, natality, reproductive health, violence, prevention, disease and mental health. Within each main category, there are numerous subcategories.
Health Data Tools and Statistics (Partners in Information Access for the Public Health Workforce)
Link:
http://phpartners.org/health_stats.html
Description:
This website is comprised of an extensive list of websites dedicated to health data across the country focusing on Health Information Technology and Standards; Health Statistics, National Public Health Data Sets; State and Local Public Health Data Sets; Public Health Infrastructure Data; Search for Other Tools; and Tools for Data Collection and Planning.
Target Setting Worksheet (Public Health Foundation)
Link:
http://www.phf.org/pmqi/HPtools/state/DE_target_setting_worksheet.pdf
Description:
This worksheet helps in setting quantitative targets using the State of Delaware as an example.
American Fact Finder (United States Census)
Link:
http://factfinder.census.gov/home/saff/main.html?_lang=en
Description:
The US Census Bureau's data website includes information on population, housing, economic, and geographic data.