Trauma Registry Audit

Case Study #2 (Trauma Registry Audit)

As cancer registrar, the cancer committee chairman at your hospital in Napoleon, Ohio, has requested that you create an presentation comparing cancer statistics in the state of Ohio. She wants comparisons among the counties represented by Columbus, Cleveland, Cincinnati, Toledo, and Marietta, along with your own county for 2015. You will use the Ohio Annual Cancer Report for 2018 from Ohio Department of Health website to gather this data .

Ohio Annual Cancer Report 2018  

1. Determine the top three cancer sites by county based on number of cases. Create an table that illustrates this data. (Note: You will first need to identify the counties that each city resides in – see below):

Cleveland (Cuyahoga)

Columbus (Franklin)

Cincinnati (Hamilton)

Napoleon (Henry)

Toledo (Lucas)

Marietta (Washington)

2. Create an bar graph to compare the number of your county’s (Napoleon – Henry) top 2 cancer site cases to the other counties for the same site(s).

3. Use information from the CDC website on cancer statistics to create an graph that compares the percentage of Ohio cancer deaths to total US cancer deaths in 2015 for prostate, lung, colon, and female breast cancers. (Note: You will need to pull the data from the CDC website for the appropriate year (2015) and cancer sites to create an stacked bar graph to illustrate the percentage of Ohio cases to the national cases – see link below).

https://www.cdc.gov/cancer/dcpc/data/index.htm