[Solution]Data Extraction

[pl_row]
[pl_col col=12]
[pl_text]
HIM 350 Module Five Worksheet
This worksheet consists of 12 questions, worth 5 points each.
1. In Module Three, you created a data dictionary of standardized terms and definitions for your institution based on the information in a patient medical record. Two weeks after being discharged, the patient scheduled a follow-up appointment with a specialist to assess how well his wounds have healed. The specialist provider would like a summary of the patient’s interaction at the hospital and would also like to know how the institution is defining certain data elements such as length of stay, inpatient days, and so on. Briefly describe two methods you could use to extract data from the data dictionary database to be sent to the specialist provider.
2. What formula did you use to derive length of stay? Did you include the time in the emergency room in your calculation? Why or why not? What is the patient’s length of stay according to your calculation?
3. If the number of inpatient service days at the hospital for the month of December is 5,387, what is the average daily census?
4. Why is it important that the specialist provider knows how the terms are defined and used at the institution?
5. How does the use of vocabulary standards support data integrity and quality in healthcare?
Use the resources below to identify the formulas needed to calculate the scenarios in questions 6–12. Also refer to the Sample Problem Document as a reference.
 Hospital Statistical Formulas for the RHIT Exam
 Calculation of Infection Rates
6. Calculate the average daily census from the following data:
Holly Hospital Inpatient Service Days for Year
Type of Service
Number of Patients
Adult
75,800
Newborn
6,100
Pediatric
11,800
What was the average daily census of adults and children for the year?
What was the average daily census of newborns for the year?
7. Using the following data, calculate the average length of stay:
Holly Hospital has 500 beds and 50 bassinets. You are preparing a report for the month of February (non-leap year).
Inpatient Service Days:
Adult and pediatric
12,000
Newborn
500
Discharges:
Adult and pediatric
1,300
Newborn
90
Discharge Days:
Adult and pediatric
9,000
Newborn
231
What is February’s average length of stay for adults and children?
What is February’s average length of stay for newborns?
8. Using the following data, calculate the consultation rate:
25,000 discharges
136,000 discharge days
3,500 consultations performed
9. Using the following data, calculate the cesarean-section rate:
600 deliveries
350 vaginal deliveries
250 cesarean deliveries
10. Using the data below, calculate the following rates:
February 2017
Discharges (including deaths)
Adults
1,100
Pediatrics
125
Newborn
85
Deaths
Adults
9
Pediatrics
1
Newborn
1
A. Gross Death Rate:
B. Newborn Death Rate:
11. Using the data below, calculate the fetal death rate:
February 2017
Early fetal deaths
22
Intermediate fetal deaths
7
Late
1
Live births
322
Newborn discharges
89
12. Using the data below, calculate the following rates:
February 2017
Deaths (adults and children)
12 (including 1 coroner’s case)
Discharges (adults and children)
1,125
Autopsies
3
A. Gross Autopsy Rate:
B. Net Autopsy Rate:


[/pl_text]
[/pl_col]
[/pl_row]

Your Homework Market Your Homework Market provides you with quality papers in all subjects at all levels of education from high school to college and university. We offer assistance to students who are faced with strict timelines in delivering their papers, while at the same time having to deal with other challenges of life such as work and family life. Our papers are plagiarism-free and are delivered within your budget, in the specified timeline.