Week Report Assignment
Week Report Assignment
Permalink:
Read the following scenario:
Data has been collected to identify specific cases of people who are infected with a dangerous virus. Your organization has an interest in knowing where the population is most affected in an effort to move resources to areas that need them.
Create a bar chart using Microsoft Excel® and the data provided in the Cases by City document to identify the cities with the highest counts of cases.
Note: This information will be used for further analysis in future assignments.
Write a 350- to 525-word report or create a 5- to 7-slide presentation with substantial speaker notes of your analysis of the data. Include an answer to the following questions:
- What are the top five cities for infected cases?
- How many infected cases does each of those cities have?
- What is the prevalence rate per 100,000 people?
- What else can be deduced after evaluating the chart?
Include your bar chart in the report or presentation.
Include three peer-reviewed references.
Format your citations according to APA guidelines.
Save your assignment as TeamletterWeek3. Example, TeamAWeek3.
Click the Assignment Files tab to submit your MHA 507 WEEK 3 Report I assignment.
MHA 507 WEEK 4 Report II
Read the following scenario:
Now that we know where the outbreaks are located, your organization wants to know more about who it affects. The age of the patient will determine what kind of resources will be needed in those areas.
Create a side-by-side bar graph using Microsoft Excel® and the data provided in the Ages Impacted document to identify the age groups affected by the virus.
Note: This information will be used for further analysis in future assignments.
Write a 350- to 525-word report or Create a 5- to 7-slide presentation of your analysis of the data. Include an answer to the following questions:
- Which age groups are most affected?
- Which age groups are least affected?
- What is the prevalence rate per age demographic?
- What else can be deduced after evaluating the chart?
Include your side-by-side bar graph in the report.
Include three peer-reviewed references.
Format your citations according to APA guidelines.
Save your file as TeamLetterWeek4. For example, TeamAWeek4.
Click the Assignment Files tab to submit your assignment.
MHA 507 WEEK 5 Report III
Resources: 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 document to determine the areas of the country with the most risk.
Note: Watch the “How to Plot Data onto a Map in Microsoft Excel” video for more information about plotting data on a map in Excel. Note also that this information will be used for further analysis in Week 6.
Write a 350- to 525-word report or create a 5- to 7-slide presentation of your analysis of the data. Include an answer to the following questions:
- Which cities 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 symbols map in the report.
Include three peer-references that support your analysis.
Format your citations according to APA guidelines.
Save your assignment as TeamLetterWeek5. For example, TeamAWeek5.
Submit your Turnitin and Grammarly reports.
Click the Assignment Files tab to submit your assignment.
MHA 507 WEEK 6 Data Utilization
Compare the charts and graphs that your Learning Team created for the Reports I, II, and III assignments and come to a consensus of 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 350- to 525-word memo or Create a 7- to 9-slide presentation of how your selected health care facility or service can benefit from the information you gathered and analyzed in the Reports I, II and III assignments. Be sure to include any conflicts of interest, ethical considerations, or community health effects that may factor into the benefits identified.
Cite 3 peer-reviewed references.
Submit your Turnitin and Grammarly reports.
Click the Assignment Files tab to submit your assignment.
