Part Four: Secondary Data Collection and Analysis (45 points/ 150 total points)
For this part of the Community Assessment, you will gather online data about your community, and compare this information to the state and national data. You will need to collect data that is specific to your community and potential health issues. Be very thorough in your data collection. The end product of this assignment will be to determine a potential health problem within your community from the data. Critically think about what information you need to make recommendations about the health status of your community and collect data that will support those recommendations. Suggested websites to begin looking for data are the U.S. Census Bureau, National Center for Health Statistics, the Behavioral Risk Factor Surveillance System, your state health department, and the University of Wisconsin Population Health Institute. There are also many more websites that may prove to helpful listed under the "Web Links" tab on the left side of the Blackboard shell.
Data Table:
You must collect at least 15 unique data sets (one set is the community/county vs. state vs. nation), but you may collect more if you wish. You will enter the data you collect into a table that you create and provide direct links to the location/table where you gathered the information. Below is an example of a data table:
Description of the data set, including year
City/County (must state which in box below)
State NationalPopulation, 2015
(United States Census Bureau, 2015) 28, 758
(include the specific url to the data) 9,562,685
(include the specific url to the data) 320,956,485
(include the specific url to the data)
Median Household Income, 2010-2014
(United States Census Bureau, 2015) $42,598
(include the specific url to the data) $51,386
(include the specific url to the data) $55,843
(include the specific url to the data)
The following is a list of possible data to collect (yes, it is ok to include the data from Part One of this assignment, as you will compare your community data to the state and nation). Include data which is relevant to issues and assets discovered through your windshield survey and key informant interviews.
• Population
• Median Age
• Mortality Rate
• Infant Mortality Rate
• Leading cause of death
• Age distribution
• Birth Rate
• Cause Specific death rate
• Crime rate
• Educational attainment
• Gender
• Household Income
• Infant mortality
• Leading Health Indicators for identified community (may use county or state health indicators)
• Marital status
• Mortality Rate
• Occupation
• Per Capita income
• Population-size and distribution
• Poverty rate
• Race/ Ethnicity
• Single family households
• Single parent households
• Unemployment rate
• Hospitalizations by diagnoses
• Sexually transmitted diseases
• Teenage pregnancy
These are examples; you may collect other data points as long as you are able to compare city/county data to the state and the nation. If you are unable to find city data for a specific item, you may use county data (be sure to indicate this on your data table). Data must be comparable within each data set.
You will upload your data table into the respective Community Assessment Part 4 Assignment Link.
Analysis:
In addition and in narrative form:
• Analyze the data and provide a narrative summary of your findings.
• Discuss whether your data findings are reflective of community health concerns and challenges, assets, both.
• Describe whether the identified secondary data support earlier assessment findings from your windshield survey, key informant interviews, and other community data previously assessed.
• From the data collected and analyzed, identify an issue relevant to the health and well-being community.
• Provide rationale and support (can be a Professional organization website, such as AHA, ADA, etc.) indicating that community/population-focused interventions would/should be useful in preventing disease/promoting health within this community/population.
• Identify a goal within the Health People 2030 document which is relevant to your chosen health issue and describe the interventions outlined within the HP2030 to improve the outcomes of this health issue.
Sample Solution