In Week 1, you analyzed a pre-intervention elementary school asthma

 

In Week 1, you analyzed a pre-intervention elementary school asthma database from the perspective of a public health informatician. This week, you will review the data set in more detail and discuss the tools informaticians use. For the asthma data summary, you will use your Excel Spreadsheet and Pivot Table reports. You will then answer the following questions in the form of a 3–4-page summary statement that includes the data as well as an interpretation of the findings. The Pivot Tables need to be embedded in your report to explain the summary results.

What summary results do your pivot tables demonstrate about this grade school population of students? Use the following questions to prepare your paper.

Data Frequency Questions:

Introduction:

Begin with an explanation of the tools of informatics, including spreadsheets, relational database technologies, and integrated statistical packages. Why are these tools and technologies so important when managing large databases of public health informatics?

Database Analyses

  • Are there more males or females in the survey population?
  • Which condition has the highest frequency?
  • Which month had the highest number of students with breathing difficulties?
  • Which school had the highest frequency of students with bronchitis?
  • Which gender has the highest frequency of asthma?
  • How many students answered yes to Reactive Airway Disease (RAD)?
  • What is the percentage of students with RAD that have been prescribed medication?
  • Which zip code has the highest number of students living in it?
  • Of that zip code, which condition had the highest frequency?
  • How many students answered yes to all four conditions: asthma, RAD, bronchitis, and wheezing?
  • Based on all four conditions and zip code, are the conditions evenly distributed among the survey population?
  • Does one school have more students in the affected zip codes and with all four conditions than the others do?
  • Summary:
  • Explain your data analyses results and describe what data quality assurances you applied to ensure your results are accurate.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

What is the significance of an individual’s quality of life

  What is the significance of an individual’s quality of life from the health care delivery perspective? What is the intermediary role of insurance in the delivery of health care? What is managed care? Why do employers  purchase insurance plans to provide health benefits to their employees? What are two

As you become oriented to your new field placement, speak

 As you become oriented to your new field placement, speak with field instructors and others in your setting about the population(s) served by the agency/institution. This includes individual and community characteristics and representative presenting concerns. Choose one of the more common presenting issues and spend time researching the types of

topic foreign language( English) Couldn’t get a research question and

topic foreign language( English)  Couldn’t get a research question and thesis statement.  English would be fine  APA style citations  Minimum 2500 words double spaced in 12-point font, Calibri/ Arial  Sources must be reputable and reliable  Scholarly journals  Academic books  Minimum 12 sources maximum 20 sources   All sources can also

Competencies Analyze the evolution of social media standards and practices

 Competencies Analyze the evolution of social media standards and practices and how it relates to the potential need for regulation of social media, along with ethical concerns. Evaluate psychological theories and their insights into the widely varying opinions and attitudes that are expressed through social media. Compare and contrast new

Review the humanistic-existential psychotherapy videos in this week’s Learning Resources.

Review the humanistic-existential psychotherapy videos in this week’s Learning Resources. Reflect on humanistic-existential psychotherapeutic approaches. Then, select another psychotherapeutic approach to compare with humanistic-existential psychotherapy. The approach you choose may be one you previously explored in the course or one you are familiar with and especially interested in.  Briefly describe

What is the distinction between healthcare as a private benefit

 What is the distinction between healthcare as a private benefit and healthcare as a private choice? How does this distinction impact political decisions about healthcare by politicians and voters? What is the difference between distributive and commutative justice? How do desert and need factor in ethical decisions about health care?

Steven Smith was employed by the Avon School District as

Steven Smith was employed by the Avon School District as a high school English Language Arts teacher. He posted three photos of his students’ writing on Facebook, highlighting their grammar gaffes and misspellings. He also commented on the mistakes. Smith’s posts weren’t shared publicly on the social media site, but

Review the rubric to make sure you understand the criteria

  Review the rubric to make sure you understand the criteria for earning your grade. Review the initial product development and market demand report from your peer as submitted to the 2.3 Discussion (Attached word doc). You will need to do appropriate research on the industry and category so that you

In her chapter from What Terrorists Want, Louise Richardson speaks

In her chapter from What Terrorists Want, Louise Richardson speaks of her experience growing up as a sympathizer of the Irish Republican Army. Because of her experience growing up during a time of conflict in Northern Ireland, she writes that “when I hear of a terrorist atrocity, I do not think of

Instructions You have recently started working for a local department

 Instructions You have recently started working for a local department store in the Operations Department. Upon settling into your new position, you come to realize that they have outdated business practices. As a department, you and your peers begin to discuss changes that your store could make to help the

Hate groups are often able to promote their ideology of

  Hate groups are often able to promote their ideology of hate under the protection of freedom of speech (1stAmendment). Some have argued that we should restrict hate speech, while others have argued for its continued protection under the First Amendment. Post by Day 3 of Week 5 Do you

The Ohio Connection Janey worked as an executive assistant to

The Ohio Connection Janey worked as an executive assistant to a product manager at her company: Ohio Connection. Overall, she loved her job; she was happy to work with a company that provided great benefits, and she and found enjoyment in her day-to-day work. She had the same product manager

You are the marketing manager for a new brand of

 You are the marketing manager for a new brand of sports drink “Refresh”. The all-natural ingredients in the drink are grown and harvested on small farms in the United States. The bottles and packaging are made from recycled materials. You are preparing for the launch of the product in the

Overview: This course project introduces an opportunity to explore all

   Overview: This course project introduces an opportunity to explore all the project stages (from inception to closing) facilitated by the well-known Project Management Group Processes (initiation, planning, execution, monitoring and control, and closure) as outlined in the PMBOK® Guide.  Two Project Options:1. Data Center Transformation – to complete a

The AD-AS Model and the Effects of Monetary Policy

 In a speech, titled Recent Economic Developments, Monetary Policy Considerations and Longer-Term Prospects (https://www.federalreserve.gov/newsevents/speech/powell20160628a.htm.), in June 2016, Jerome Powell, a member of the Federal Reserve’s Board of Governors, then, stated that the fraction of the U.S. population aged 25 to 54 who were working or actively looking for work “is

Study daily 001 Directions Locate a model from a different

   Study daily 001 Directions Locate a model from a different discipline (other than nursing) that you could apply to nurse. Models can be found in leadership, business, education, and technology explain why you have chosen the model apply the model to your advanced practice role – NP Write the