PLEASE DO BOTH PARTS, MICROSOFT EXCEL WILL BE NEEDED
PLEASE USE THESE 2 LINKS TO HELP YOU SEARCH
https://www.healthdata.gov/browse?limitTo=datasets
https://wonder.cdc.gov/
While information can point to certain truths and reveal gaps in care that should be addressed, information is neutral until it is assigned a purpose. As you progress in your career, you will continually return to the Triple Aim, which ensures quality management in its clear focus to improve the patient experience, improve the health of populations, and improve the cost of care for patients. This week, you will consider the best application for information you have learned from your data analyses
PART 1 PLOTTING DATA INTO A MAP USING MICROSOFT EXCEL
Resource: How to Plot Data onto a Map in Microsoft Excel
Read the following scenario:
Now that you know where the outbreaks are located and which age groups are most affected, your organization wants to map out the areas that pose the highest exposure risk.
Create a symbols map using Microsoft Excel and the data provided in the High Risk Areas spreadsheet to determine the areas of the country with the most risk.
Review the “Plotting Data onto a Map in Microsoft Excel” document for instructions on completing this portion of the assignment.
Write a 350- to 525-word analysis of the data that answers the following questions:
Which cities (states) are high risk and low risk?
What areas of the country are high risk and low risk?
What else can be deduced after evaluating the chart?
Include your map with your analysis, not separately. Label as a “Figure” according to APA formatting.
PART 2 INFORMATION ANALYTICS
Compare the charts and graphs you created for the reports in previous assessments and determine conclusions based on the analysis of the data.
Select a health care facility or service (e.g., hospital, physician practice, long-term care facility, ambulance service, pharmacy, or skilled nursing facility).
Write a 700- to 1,050-word analysis, addressing the following:
Describe how your selected health care facility or service can benefit from the information you gathered and analyzed in the previous assessments.
Examine any conflicts of interest, ethical considerations, or community health effects that may factor into the benefits identified.
Identify any points that can be served by further research into either the facility, a service it provides, or the given data.
Reference data, graphs, and charts to support your claims.
Cite at least 2 scholarly references to support your assignment. Feel free to use supplemental readings from peer-reviewed journals as references. Do not use “.com” commercial, “.edu” education, “.org” or “.net” proprietary sources. You may use one .gov reference, such as the CDC or NIH.
Compile Part 1 and Part 2 into a report that could be submitted to the leadership in your organization.
Format your report according to APA guidelines.
