Comparative Analytical Review of Cancer Deaths
1. Student will demonstrate the ability to data mine data from large amounts of data.
2. Student will utilize critical thinking in the collection and data analysis.
3. Student will demonstrate the ability to use data visualization to present data.
4. Student will demonstrate ability to compile a meaningful summary of findings.
Student will be responsible to locate and secure a local mentor that can be used as a consultant and serve in the role of the CFO for this project.
This PPE activity meets the 16 hours site supervised requirement.
Data analytics is a critical tool used in healthcare organizations to monitor and determine trends in clinical and financial data. It is an important function in the HIM Department.
A local community group is concerned with what appears to be an increase in brain cancer cases and deaths in their community. They have contacted the Community Hospital and asked that a presentation be made to their community regarding cancer incidence in the local community with special attention to brain cancer. The Chief of Medicine (COM) and the Administrator are preparing a presentation to the community and have asked you to assist them. As the data analyst for the HIM Department, they want you to conduct research using the Centers for Disease Control and Prevention’s (CDC) cancer website – United States Cancer Statistics (USCS) Site for them. They want you to prepare written summary of your findings along with a power point presentation. They will review your findings and incorporate them into their community presentation. Be prepared to present your data.
Go to www.cdc.gov/cancer
Locate Data & Statistics on the Cancer home page
Part 1: Learning About Cancer Statistics
You’re new to the Centers for Disease Control and Prevention’s (CDC) cancer website and need to explore the data on the site and how it’s organized. You decide that you need to understand the nature and sources for the data in the event that the Chief of Medicine (COM) and Administrator ask you questions to validate the data.
1. Select US Cancer Statistics (USCS)
2. Scroll down to About US Cancer Statistics and click on Learn More about the Data Sources used by CDC to publish the cancer incidence and death rates
3. Prepare a written summary explaining what data sources CDC uses to create the official statistics used by researchers, agencies and the public to learn about cancer in the USA.
Prepare a written summary of your findings. Be specific and detailed on the partnered organizations. Send this summary to your mentor for review and feedback.
Part 2: Data Comparison
Now that you have an understanding of the data and its sources on the CDC Cancer website, you’ve decide to do some comparative review. Since your administrators are going to make a presentation to the general public, you realize that a picture is worth a thousand words so you decide to review and evaluate the type of visualization tools available to you that you’ll be able to incorporate into your reports.
1. Return to the cancer home page, return to Data & Statistics
2. Select Data Visualization Tools
3. Carefully study this page and answer the following questions:
a. Was is the latest year which incidence data is available? _2016__
b. How many new cancers were reported in the latest year available? 1,658,716 case___
c. How many of those cases died? _598,031_____
4. Set your data parameters
a. Locate Overview make sure it’s set to United States yes
b. Locate New Cases or Deaths make sure it’s set to Rate of New Cancers 436 new case & 156 death
c. Sex should be Male and Female yes
d. Cancer type should be All types of Cancer Cases yes
e. Set year to just 2016 yes
5. Locate the icons , click through the buttons and pay attention to how the data changes formats. Which format did you find most helpful? Why? Chart, because it’s more explanatory.
6. Scroll down and review the data. Use the map of the USA, what does it tell you? Every state has his own percentage of cases and deaths.
7. What does the different colors on the map indicate? Rate per 100.000 people.
8. Scroll down to the graphs of the Top 10 Cancers by Rates of New Cancer Cases and the Top 10 Cancers by Rates of Cancer Deaths.
a. What are the top 2 cancers in the United States from each graph? Female breast/ Prostate and Lung and bronchus/ Prostate
b. What are their rates? 130.3/109.4 and 38.1/20.5
9. Go back to the data parameters and change the Overview from USA to your home state.
a. What is your home state? Wisconsin
b. What are the top 2 cancers from the graphs for your home state? Lung/ trachea and Lymphoid and blood
c. What are their rates? 5.2
d. What is the population of your state? 5.773 million
e. How do they compare to the overall USA? ______________________
f. Are there any states that fall below the USA rate? Was your state below the USA rate? How did you find this information? _______________________________
With the data you’ve discovered in your review in Part 2, prepare a summary of findings and be sure to include your home state in your report. The purpose of this summary is to provide a validation of cancer data and to demonstrate your understanding of how to display the data both in the written form but also visually, include tables and charts to demonstrate the comparison of your data. You’ll also want to show how you extrapolate your conclusions from the data collected. Send this to your mentor for review and feedback.
Part 3: Zooming into your data
10. Return to the tab area,
a. Set the area to United States
b. Change Cancer Type to Brain and other Nervous System
c. Leave all other settings as they are
d. In 2016, how many new brain cancers were reported in the United States? 22,376
e. How many people died of brain cancer? 16,834
11. Return to the tab area, change the area from United States to your home state:
a. Use your mouse and float over your home state,
b. How many new brain cancers were reported? 6 new brain cancer case were reported
12. Return to the tab area, leaving your state in the Area box, change from Overview to State/County. Which County are you in? Dane County
a. Using the visualization images, charts and tables, prepare a summary explaining the incidences of brain cancer in your state. What conclusions can you draw from this data?
Looking at the visual chart and table explaining the incidences of brain cancer in Wisconsin, I can see that 120 cases of white males and 94 cases of white females were found in both categories in 2016.
13. Go to the state map, hover your mouse over the different counties in your state, what does this tell you?
This tells me that just a portion of the white population is affected.
Hover over your county, what does it tell you about the incidence of brain cancer in your county? In Dane County, Wisconsin from 2012-2016, 8.4 age-adjusted per 100,000 people. 214 new brain cancer were reported.
Prepare a written summary of your state and county findings on brain cancer. The purpose of this summary is to provide the brain cancer data that was requested of you by your Administrators and to demonstrate your understanding of how to display the data both in the written form but also visually, include tables and charts to demonstrate the comparison of your data. You’ll also want to show how you extrapolate your conclusions from the data collected. Send this to your mentor for review and feedback. Send this to your mentor for review and feedback.
Part 4: Summation
1. Using the information you’ve gotten from this activity and the feedback from your mentor, prepare a power point presentation, no longer than 10 minutes but no less than 8 minutes, demonstrating the incidence of brain cancer in your state/county as compared to the USA. Include any conclusions that you were able to draw from the data you analyzed and prepare data visualization in the power point as well, remember a picture is worth a thought words and these will help your administrators presenting to the community. Also be sure to properly cite your work using APA formatting.
a. Here is a link to help you with your presentation: https://www.ncsl.org/legislators-staff/legislative-staff/legislative-staff-coordinating-committee/tips-for-making-effective-powerpoint-presentations.aspx
2. Set up a video conference session with your mentor and present your power point. If there is any issue, contact your instructor for assistance.
3. After the presentation, you and the mentor evaluate the Activity and submit with the rest of your deliverables in the course.
Part 5: Deliverables
Once you’ve completed all of the section of this activity and you’ve made your video conference with your mentor, complete your evaluation, secure your evaluation from your mentor and submit along with the project deliverables. Submit all documents to the Instructor for grade.
Part 1: Learning About Cancer Statistics Summary
Part 2: Data Comparison Summary
Part 3: Zooming into your Data Summary
Part 4: Summation PowerPoint – After your presentation, ask your mentor for feedback that you might utilize in your reflection paper.
Part 5: Professional & Personal Performance Reflection Paper
Part 6: Student Evaluation, Mentor’s Evaluation and Time sheet.
All deliverables are to be sent to the Program Coordinator/Instructor at the end of the Activity period/course, no later than the 5th week of the course.
Post a review and evaluation of this Activity in your discussion. What did you learn? What did you like about the Activity? What did you dislike about the Activity? Here are a few more questions you could consider.
a. Did you use skills that you learned in the program?
b. Do you think what you learned in this activity will be useful in your future work?
c. What would you change in this activity?
d. Did you think the remote method used was helpful?