Competency Assignment 2a: Figures and Tables

1. Choose one of the following reportable/infectious diseases from the Reportable and Infectious Diseases page of
3. .

• If needed, tutorials to use FL Health CHARTS
• Note: Make sure you select a reportable disease that has data available for both sexes (some of the options in MyFloridaCharts don’t have this data available). My suggestion is to use HIV or one of the reportable diseases classified as a sexually transmitted disease. On the MyFloridaCharts webpage for these conditions, there is a drop down menu under the State or County that displays the data by sex.

1. Construct a graph depicting the incidence rates for the disease during each of the years 2014, 2015, 2016, 2017, and 2018 in Miami-Dade County, Florida, and the U.S. (You can locate data for the U.S. through CDC sources at cdc.gov, such as
3. and
5. )

• Write 4-5 sentences describing and comparing the trends in each of the three geographic areas. When writing your description, first use epidemiologic terms, then use lay terms.

1. Construct two pie charts showing the distribution of cases of the disease by age group in 2018. One should be for Florida and the other for Miami-Dade County. If there are fewer than 20 cases of the disease in Miami-Dade County during 2018, combine three years of data (2016-2018).

• Write 3-4 sentences describing and comparing the distribution of cases of disease in the two geographic areas. When writing your description, first use epidemiologic terms, then use lay terms.

1. Construct a table depicting the incidence rates of the disease by sex during each of the years 2014, 2015, 2016, 2017, and 2018 in Miami-Dade County and Florida.

• Write 4-5 sentences describing and comparing the incidence rates of the disease by sex between the two areas and the trends in each of the two areas. When writing your description, first use epidemiologic terms, then use lay terms.

Instructions for obtaining estimates for U.S. population 2014 to 2018

1. Go to this page:
3. Click on “Surveys/Programs” featured horizontally on top, then select All Surveys & Programs
4. Scroll down, select page 5, where you will find Population and Housing Unit Estimates”–click on that
5. Scroll down, and under Tables, click on “View All Tables”
6. Click on “2019”
7. In the 2019 page, you should see a table link labeled National Population Totals: 2010-2019
8. In the new page that opens up, scroll down until you see Annual Estimates of the Resident Population for the United States, Regions, States, and Puerto Rico: April 1, 2010 to July 1, 2019 (NST-EST2019-01). Click the link to download in Excel.

• Notes:
• Each student must create his/her own tables/figures and interpretations.
• Please use Excel or Power Point to create these tables/figures. For each figure/table, please give the exact web address where you retrieved the numerator and denominator for the data (if applicable).
• When constructing the graphs and charts, follow the guidelines provided in the lecture with respect to format, title, source, and other standard elements of the charts and graphs. Both the counts and rates will appear in the Florida Health Charts. You may use these, but it would be excellent practice to calculate at least a few rates by hand and check your answer with the rates listed in Florida Health Charts. In calculating the incidence rates, you can use the denominator population provided in Florida Health Charts.
• If there are no data available for the years 20142018, then select the most recent years for which data are available and use that data throughout the assignment.

PLEASE NO PLAGIARISM my professor uses AI detector. Please CITE

Please see grading rubric attached.