Chat with us, powered by LiveChat You will review and analyze a pre-intervention elementary school asthma database from a community that has four elementary schools. Each week, you will write a short paper describing | EssayAbode

You will review and analyze a pre-intervention elementary school asthma database from a community that has four elementary schools. Each week, you will write a short paper describing


Week 1 Project

Over the next four weeks, you will review and analyze a pre-intervention elementary school asthma database from a community that has four elementary schools. Each week, you will write a short paper describing the role of an informatician in regard to data capture and use within the Public Health Information Management Systems (PHIS) and Public Health Information Network (PHIN). You will explore the data elements, database technologies, analytics, and processes used by an informatician including data capture, scrubbing, coding, warehousing, managing, and reporting of public health information.

In Week 5, you will complete a comprehensive term paper and PowerPoint presentation that demonstrates a public health needs assessment using your primary asthma source data. Your paper and presentation should show why an asthma prevention intervention program is needed in the selected community and summarize how you came to your conclusions. The objective of this five-week project is for you to demonstrate the processes used in public health informatics through its application.

You will begin your course project by explaining how data is collected, scrubbed, coded, and stored within the PHIS. You will then explain how data is organized in databases, using the asthma data provided below. You will describe the data elements in the spreadsheet and the processes of an informatician by answering the questions below.

Click here to download the asthma data for 2013.

Note: Use this Excel spreadsheet throughout the course to complete your weekly data analyses and prepare your written assignments as they relate to public health informatics. Your weekly assignments will provide data to support your final term paper to be submitted in Week 5.

Based on the data in the spreadsheet, prepare a 3–4-page paper addressing the following questions:

Introduction: How is information collected, organized, scrubbed, coded, and entered into the PHIS?

Asthma Database Analyses:

Describe the structural organization of your database.

What is the survey population description?

Define pre-intervention

Define a database record. How many records are in your database?

Define a database field. How many fields are in your database?

Define a database field data definition (DD). What is an example in this database of a DD?

Based on the data collected, what is the purpose and potential use of this asthma survey data?

Summary: From the perspective of an informatician, discuss the asthma database’s key structural components, its organization, and potential uses.

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.
  • Name your document SU_PHE6203_W1_A3_LastName_FirstInitial.doc

Week 2 Project

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:


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.

Submission Details:

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

Running Head: WEEK 1 1

WEEK 1 4

Analysis of Asthma Patients


March 25, 2020


Information processing is any method by which the retrieval or assistance in the retrieval of information is planned. Selection is accomplished by seeking and receiving the necessary data from persons or organizations via the correct vehicle. The data is given explicitly by the respondent (self-enumeration) or by the investigator. Set also involves the retrieval of institutional details. Data collection applies to any mechanism that transforms the information given to the respondent into an electronic format. The process is either automatic or requires the workers to plugging the gathered data (keys). Data coding is any method that assigns a numeric value to an answer. Programming is frequently automatic, but more complicated decisions typically need human input (coders). Survey operations also require a large level of optimization, which contributes to the accessibility of data, knowledge relevant to the survey phase. Instances of para data include an indication of whether or not a device is in the survey, a list of calls and meetings, a record of keystrokes (audit record), a system of compilation, managerial details (e.g. interview blog) and expense details. Data is not just a source of statistics, it is also the primary interaction that a polling organization has with the population who wants to be encouraged to participate. Data collection and encoding are the structured data for use as output by all future survey operations. Data processing, data analysis, and coding activities frequently entail a substantial portion of the research expenditure and require considerable humor. Plan the collection procedure to reduce the stress on the participant and the expense of processing, and to optimize timeliness and quality of the results. Data may be obtained by self-reporting, voice interviews or informal interviews through either a document or an online survey (e.g. automated data recording, the Web, computer-assisted interviewing).

What is PHIS?

Global Health Information Systems (PHIS) are the essential elements of public health services, offering details about how community programs obtain and manage public health treatment data. Such results help public health initiatives, such as the monitoring of illnesses or the implementation of public health systems for teen smokers. Countries also create PHIS via the state health department in order to collect data that will be used relevantly to assess the health condition of the country. In this report, the PHIS toolkit will be used in order to analyze the patients of asthma, and database records have been collected.

Asthma Database Analyses:

Create effective sample management protocols and controls for all data gathering activities (e.g. distribution and return of physical surveys, take-up of discrepancies or contradictions, follow-up of non-response). These protocols monitor the status of the collected units from the beginning of the end of the data collection so that data gathering administrators and interviewers can determine the quality of the data collection phase. Establish and sustain positive relationships with the participant in order to achieve a successful answer rate. These interventions could include advertising the forthcoming study, an introduction letter reminding respondents that they should be part of the sample, an informational brochure providing key statistics to retain their confidence in engaging in the study (in particular for quantitative surveys) or an easy-to-use protocol. While gathering data, ensure that the respondent or the correct individual inside the respondent household or organization is notified at the required time. Enable the respondent to include the data in a system and medium that is suitable for the person and his or her organization. This would help to raise response levels and enhance the accuracy of the knowledge received from the respondent (Ricjie, 2018).

Database record:

A database is essentially a collection of records contained in a chart, such as a consumer list. The database record is an entity that may hold one or even more values. The classes of documents are then placed in a database; the database determines the data that each document can contain. There are multiple tables in the index, each holding several documents. The database record contains a data field that contains the database record of the gender, the asthma condition, etc (L, 2018).

Data Structure:

Every row is considered a record in the database jargon. A database is often referred to as an item or person. In other terms, the database table consists of a list of documents. The documents in a database are items that you're involved in, such as books in a library collection or buyers in a sales chart. The area refers to the column in the row, indicating a data type for each document. The structure of the data is very simple and straightforward. It has been recorded over the number of participants who have been randomly selected and are randomly chosen for the results of asthma. The asthma patients selected were tested for the hypothesis set as the optimal data collection. The data structure has therefore been maintained and contained simply in rows and columns. In simple words, it is done so in order to make sure that the data that has been collected is formatted and presented in an understandable manner.

Database field:

The field is part of the database which includes a specific piece of data for the report topic. In the database table displayed in Figure 4, each report includes four fields: log ID. That number allocated to this customer service event for identifying purposes. The database field of the selected database under asthma analysis is a total of 850 fields that are allocated to about 850 participants of the research that has been taken place for the asthma patients' analysis.

What is pre-intervention?

Health insurance or primary treatment is established through diagnosing, first administering and eventually managing different illnesses, illnesses and other physical disorders of human beings. Healthcare is received by health practitioners in their related area of research. In fact, the evaluation (Test of multiple diseases) may be assumed to be pre-intervention, medication, and therapy (Opera).

Use of the Asthma study and data collection:

Previous reports have identified a rise in the prevalence of asthma in health employees, but as far as we know there are no reliable survey questionnaires used to research this organizational category. Create, test and optimize a modern asthma survey instrument for use in epidemiological studies of health staff to calculate different IgE antibodies to certain aeroallergens. The goal of this research is to create, test, quantify and optimize a new asthma questionnaire instrument for eventual use in the epidemiological of healthcare professionals (Leighty KA, 2019).


This study has been conducted in order to assure that the data has been collected with regards to the patients that have been chosen on a specifics of asthma. All the participants of the research are asthma patients and have been exposed to a specific condition for their test results to show some similarities or differences between the other patients. Thus, the PHIS conducted and is considered to be a globally identified method for the survey and data collection.

References L, M. (2018). Validating methods o medical tests. 90-150. Leighty KA. (2019). GPS assessment of the use of exhibit space and resources by doctors elephants. 217-220. MR, H. (2018). Recumbence behavior in zoo elephants: determination of patterns and frequency of recumbent rest and associated environmental and social factors. PLOS ONE, 211-215. Soulsby. (2018). Use of a tri-axial accelerometer, behavioral observation, and GPS to monitor the activity of female Asian elephants in a zoo. MSc, 113-117.

Related Tags

Academic APA Assignment Business Capstone College Conclusion Course Day Discussion Double Spaced Essay English Finance General Graduate History Information Justify Literature Management Market Masters Math Minimum MLA Nursing Organizational Outline Pages Paper Presentation Questions Questionnaire Reference Response Response School Subject Slides Sources Student Support Times New Roman Title Topics Word Write Writing