Using the two resources provided in the Module Overview, identify the percentage of listed cancer diagnoses from Digital Family Histories in Table 1 in 2013 and the new diagnosis of the same type of cancer reported by the CDC in 2016. Utilize MS Excel and MS PowerPoint to create a bar graph using the data from the two resources. Ensure the graph is labeled to see the different data points and types of cancer in addition to the title of the graph.
How to solve
GC Cancer Prevalence Graphical Presentation
To complete this assignment, follow these steps:
1. Open the two resources provided in the Module Overview. These resources contain the necessary information for identifying the percentage of listed cancer diagnoses from Digital Family Histories in 2013 and the new diagnosis of the same type of cancer reported by the CDC in 2016.
2. Review the data in both resources and extract the relevant information regarding the percentage of cancer diagnoses in 2013 and 2016.
3. Open MS Excel and input the data from both resources into a spreadsheet. Label the columns appropriately, such as “Type of Cancer,” “Percentage of Diagnoses (2013),” and “Percentage of Diagnoses (2016).”
4. Analyze the data and calculate the difference in the percentage of cancer diagnoses between 2013 and 2016 for each type of cancer.
5. Create a bar graph in MS Excel using the data you have inputted. Ensure that the graph is clearly labeled with the different data points and types of cancer. Include a title for the graph as well.
6. Save the MS Excel file containing the data and graph.
7. Open MS PowerPoint and create a new slide.
8. Copy and paste the bar graph from the MS Excel file into the PowerPoint slide.
9. Ensure that the graph is appropriately aligned and sized on the PowerPoint slide.
10. Add a title to the slide that describes the content of the graph, such as “Comparison of Cancer Diagnoses in 2013 and 2016.”
11. Save the PowerPoint presentation.
12. Submit both the MS Excel file and the PowerPoint presentation as your answer to this assignment.
Introduction:
In this assignment, you will use the provided resources to identify the percentage of listed cancer diagnoses from Digital Family Histories in 2013 and compare them to the new diagnoses reported by the CDC in 2016. You will create a bar graph using MS Excel and present it in MS PowerPoint, ensuring the graph is clearly labeled with the different data points and types of cancer. The goal is to visually represent the change in cancer diagnoses between the two years. Follow the steps outlined above to complete this assignment and submit the MS Excel file and PowerPoint presentation as your answer.
