Assignment: How to Plot Data onto a Map in Microsoft Excel PDF

Assignment: How to Plot Data onto a Map in Microsoft Excel PDF

Assignment Content
Resource: How to Plot Data onto a Map in Microsoft Excel PDF

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.

Review the “Plotting Data onto a Map in Microsoft® Excel® PDF document for instructions on completing this portion of the assignment.

Assignment: How to Plot Data onto a Map in Microsoft Excel PDF

Write a 350- to 525-word report of your analysis of the data.

Include an answer to 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 within the report, not separately. Label as a Figure according to APA formatting. Also, include title and reference pages.

Cite at least 2 scholarly references to support your assignment. Feel free to use supplemental readings as references, if from peer-reviewed journals. DO NOT use “.com” commercial, “.edu” education, “.org” or “.net” proprietary sources. Okay to use one .gov reference, such as CDC or NIH

Assignment: How to Plot Data onto a Map in Microsoft Excel PDF

Format your citations according to APA guidelines.

Since the location of the highest widespread virus outbreaks have been recognized, it is important to know now what age group is mostly affected by the virus. Documenting these given age groups shall assist to determine the kinds of resources which shall be necessary at these locations to correctly treat these patients.

Age Groups Most Affected

Following the World Health Organization (2019) show that children, pregnant women and adults are particularly the ones who are vulnerable and take a relatively biggest share of the diseases load. The analysis of the given information, show that the progression of the age group most affected starting with the highest are under 18,61 and over 31-60 and finally 19-30 that correspond to the research of the World Health Organization on most vulnerable groups of individuals.

Age Groups Least Affected

The age groups least affected are the 19-30 years old in addition to those under 31- 60 years old. Generally, this kind of group comprises of the young adults as well as individuals in their middle ages. The reason why this group is probably least affected is due to the fact that this age brackets the body immune system is possibly more strong in preventing and fighting infections thus making the individual much healthier (Lesourd & Meaume, 1994).

Assignment: How to Plot Data onto a Map in Microsoft Excel PDF

Bar Graph Showing Ages Affected

Chart Evaluation

The bar graph above illustrates that the least age groups affected are ones between 19 to 30 years old. According to Morse (2001) explain that the observed age outlines can impact after intolerance diagnosing, identifying as well as cases recording, changes in exposure as well as variances invulnerability to the virus. Therefore by determining if change with age is contingent on exposure or vulnerability requires an evaluation of exposures in individual with and without the illness. Individual influences results to virus occurrences that can be recognized in nearly all incidents.

Prevalence Rates

The prevalence rate for this disease changes among the diverse age groups in every city. According to United States Census Bureau (2017) explanation the current population of the United States of America is 325,365,189 as of December 18, 2017. Therefore to determine the prevalence rate per 100,000 for this disease equals, the number of infection in the particular age group divided by the United States population, then multiplied by 100,000.

The following chart shows the prevalence rate for each age group in each of the top five cities affected by this disease.

City

<18 Prevalence Rate

19-30 Prevalence Rate

31-60 Prevalence Rate

61+ Prevalence Rate

Jacksonville

0.02858

0.00584

0.01875

0.04579

Miami

0.05225

0.00553

0.00922

0.02490

Phoenix

0.04457

0.00615

0.00984

0.02828

Austin

0.04641

0.00369

0.01199

0.02428

Houston

0.03012

0.00492

0.01598

0.03258

Conclusion

Finally, the study of age groups that are mainly affected and vulnerable as well as the previous data on the locations of outbreaks shall provide us clue and knowledge to come up with a treatment for the disease. Also, it is relevant to determine what age groups are highest affected and the prevalence rates in these particular groups in order that further effective resources and techniques may be determined, eventually resulting to a disease-free community.

ADDITIONAL INSTRUCTIONS FOR THE CLASS

Discussion Questions (DQ)

• Initial responses to the DQ should address all components of the questions asked, include a minimum of one scholarly source, and be at least 250 words.
• Successful responses are substantive (i.e., add something new to the discussion, engage others in the discussion, well-developed idea) and include at least one scholarly source.
• One or two sentence responses, simple statements of agreement or “good post,” and responses that are off-topic will not count as substantive. Substantive responses should be at least 150 words.
• I encourage you to incorporate the readings from the week (as applicable) into your responses.

Weekly Participation

• Your initial responses to the mandatory DQ do not count toward participation and are graded separately.
• In addition to the DQ responses, you must post at least one reply to peers (or me) on three separate days, for a total of three replies.
• Participation posts do not require a scholarly source/citation (unless you cite someone else’s work).
• Part of your weekly participation includes viewing the weekly announcement and attesting to watching it in the comments. These announcements are made to ensure you understand everything that is due during the week.

APA Format and Writing Quality

• Familiarize yourself with APA format and practice using it correctly. It is used for most writing assignments for your degree. Visit the Writing Center in the Student Success Center, under the Resources tab in LoudCloud for APA paper templates, citation examples, tips, etc. Points will be deducted for poor use of APA format or absence of APA format (if required).
• Cite all sources of information! When in doubt, cite the source. Paraphrasing also requires a citation.
• I highly recommend using the APA Publication Manual, 6th edition.

Use of Direct Quotes

• I discourage overutilization of direct quotes in DQs and assignments at the Masters’ level and deduct points accordingly.
• As Masters’ level students, it is important that you be able to critically analyze and interpret information from journal articles and other resources. Simply restating someone else’s words does not demonstrate an understanding of the content or critical analysis of the content.
• It is best to paraphrase content and cite your source.

LopesWrite Policy

• For assignments that need to be submitted to LopesWrite, please be sure you have received your report and Similarity Index (SI) percentage BEFORE you do a “final submit” to me.
• Once you have received your report, please review it. This report will show you grammatical, punctuation, and spelling errors that can easily be fixed. Take the extra few minutes to review instead of getting counted off for these mistakes.
• Review your similarities. Did you forget to cite something? Did you not paraphrase well enough? Is your paper made up of someone else’s thoughts more than your own?
• Visit the Writing Center in the Student Success Center, under the Resources tab in LoudCloud for tips on improving your paper and SI score.

Late Policy

• The university’s policy on late assignments is 10% penalty PER DAY LATE. This also applies to late DQ replies.
• Please communicate with me if you anticipate having to submit an assignment late. I am happy to be flexible, with advance notice. We may be able to work out an extension based on extenuating circumstances.
• If you do not communicate with me before submitting an assignment late, the GCU late policy will be in effect.
• I do not accept assignments that are two or more weeks late unless we have worked out an extension.
• As per policy, no assignments are accepted after the last day of class. Any assignment submitted after midnight on the last day of class will not be accepted for grading.

Communication

• Communication is so very important. There are multiple ways to communicate with me: 
  • Questions to Instructor Forum: This is a great place to ask course content or assignment questions. If you have a question, there is a good chance one of your peers does as well. This is a public forum for the class.
  • Individual Forum: This is a private forum to ask me questions or send me messages. This will be checked at least once every 24 hours.