Instructions

An informatician conducts data assessments of public health information. They are responsible for organizing, synthesizing, and interpreting data and transforming it into pertinent information that may be used to identify implications for public health program planning and development.

In this assignment, you will continue to use your pre-intervention asthma surveillance data set from the CDC in the Excel spreadsheet to analyze your database from a summary perspective. You will calculate various statistical means of the asthma data in your Excel spreadsheet using Pivot Table reports. You will then answer the following questions in a 3–4-page paper, and embed your pivot tables in your report to explain the summary results.

What statistical mean results do your Pivot Tables demonstrate about this grade school population of students?

Data Means Statistical Questions

• What was the most frequent number of missed days?
• What is the mean (average) number of missed days because of asthmatic conditions?
• Which school had the highest average of missed days? 
• Was the school with the highest average of missed days for males the same as the school with the highest average of missed days for females?
• Is the average number of missed days higher among those who answered yes to asthma than the overall average?
• What is the average age of the student population?

In a summary, explain how an informatician can use an outcome measurement of missed school days to monitor and evaluate population health; in this situation, asthma cases in elementary school children. Refer to the following article by Moonie, Sterling, Figgs, and Castro (2006):

Moonie, S. A., Sterling, D. A., Figgs, L., & Castro, M. (2006). Asthma status and severity affects missed school days. The Journal of School Health, 76(1), 18–24. Retrieved from

http://search.proquest.com.southuniversity.libproxy.edmc.edu/docview/215674744?accountid=87314

Submission Details:

• Give reasons and examples in support of your responses. Cite all sources using APA format.
• Submit a 3–4-page report in a Microsoft Word document to the Submissions Area  by the due date assigned.
• Name your document SU_PHE6203_W3_A2_LastName_FirstInitial.doc.

Attachments

Submissions

No submissions yet. Drag and drop to upload your assignment below.Upload SubmissionDrop files here, or click below!UploadRecordChoose ExistingYou can upload files up to a maximum of 40 MB.Reflect in ePortfolioPrevious Next 

• Activity Details

 

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

 

In Week 4, you will continue to assume the role of the public health informatician and use your pre-intervention asthma surveillance data set from the CDC to calculate risk/odds ratios and prevalence/incidence rates. Review the data set from a population perspective and calculate various population ratios and rates for the asthma data in your Excel spreadsheet. You will then answer the following questions in a short application paper of 3–4-pages, explaining your results. You may refer to the suggested readings for this week.

Ratios and Rate Questions

[Note: School populations: Asthma elementary student count in this study is 800 for this school year. School’s population (A + B + C + D) = 7,200 students for this school year.]

• Does one school have a higher number of students with asthma?
• Which school has the highest number of students with wheezing?
• How many students had both asthma and wheezing?
• If you have asthma, what are the odds that you also have wheezing?
• Is the odds ratio for bronchitis and RAD lower or higher than asthma and wheezing?
• How many children with wheezing were prescribed medication? From those results, what is the risk ratio?
• Is the risk ratio for being prescribed medication for asthma higher or lower than being prescribed medication for wheezing?
• Are the risk ratios for asthma and wheezing higher for children under the age of 10 than they are for the survey population as a whole?
• What is the student asthma prevalence for the school district, i.e., A, B, C, D based on total student population as shown above?
• What is the student asthma incident rate for the school district, i.e., A, B, C, D based on total student population as shown above?

In a summary, provide your interpretation of what your statistical ratio and rate calculations results demonstrate about this grade school population of students’ asthma risk and odds ratios, prevalence, and incidence rates. Explain how you may use this data in supporting the need and development of a public health asthma prevention program. You may use the prevalence resources in the links provided for your summary response.

Submission Details:

• Give reasons and examples in support of your responses. Cite all sources using APA format.
• Submit a 3–4-page paper in a Microsoft Word document to the Submissions Area by the due date assigned.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

•  Marietta, Ga
• From the first e-Activity, analyze the measures your state and local community have in place to prepare hospitals for two (2) different types of threats to public health. Question whether the design of these measures allows for the sufficient protection of the population in the face of an imminent threat. Justify your response.
• From the second e-Activity, examine two to three (2-3) changes to the preparedness policies of your chosen state and federal government agencies. Determine the significant social, political, or environmental factors that have influenced these changes. Provide support for your rationale.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

reate a Staffing Plan

Your staff is your most important asset and will make your grant intervention come to life. As such, your portrayal of how they will accomplish their work as part of your grant intervention is paramount to your success. Using the weekly readings, the South University online library resources, and the Internet, research how to write a staffing plan. Based on your research, address the following:

Create a staffing plan that shows the number of full- and part-time staff, including contractors and volunteers, who will implement your chosen public health intervention in response to your chosen FOA.

Deliver the staffing plan in an outline form, briefly describing each individual’s job title and responsibilities.

Include an organizational chart showing where these positions reside and to whom they will report.

Submission Details:

Develop a 3 – 5 page staffing plan.

Cite all sources on a separate page using APA standards.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"