Question: analyze the entire data set for the final project, interpret the data set to complete the following tasks Describe the obvious trends in the data
- analyze the entire data set for the final project, interpret the data set to complete the following tasks
- Describe the obvious trends in the data set, and justify why HIM would consider them to be trends.
- Propose the assumptions HIM believe you can make at this time that will enable HIM to make appropriate recommendations in your final project.
- Evaluate the data and specify the components which helped HIM form their conclusions. Justify the response.
- Here are the two articles for review: https://bok.ahima.org/doc?oid=106428#.V_1hS_ArLIU





This chart depicts the demographic information of the patients who fell in the past two quarters. Patient Name Age Sex Race Confidential Reason for Visit Medical Encounter Type Location Admit Date Discharge Length of Stay Source of Data Record Date (LOS) in Days Number (MRN) PATIENT 1 80 MALE WHITE YES HEAD TRAUMA DUE TO CAR ACCIDENT MRN1 INPATIENT LOCATION A 1/27/2016 10:37 2/7/2016 0:00 11 Registration System PATIENT 2 85 FEMALE BLACK NO HIP REPLACEMENT SURGERY MRN2 SURGICAL LOCATION C 1/29/2016 10:53 2/9/2016 0:03 11 Registration System 5 PATIENT 3 55 MALE ASIAN NO ABSCESS, SACRUM MRN3 INPATIENT LOCATION A 1/4/2016 9:08 1/7/2016 0:03 3 Registration System 6 PATIENT 4 88 MALE WHITE NO PAIN MRN4 INPATIENT LOCATION B 2/1/2016 11:08 2/7/2016 0:20 6 Registration System 7 PATIENT 5 75 FEMALE WHITE YES ACUTE KIDNEY INJURY MRN EMERGENCY LOCATION A 2/2/2016 20:55 2/5/2016 0:26 2 Registration System 8 PATIENT 6 80 MALE WHITE YES PAIN MRN EMERGENCY LOCATION D 3/31/2016 12:57 4/5/2016 0:59 5 Registration System 9 PATIENT 7 87 FEMALE WHITE NO ACUTE KIDNEY INJURY MRN INPATIENT LOCATION D 3/31/2016 12:57 4/9/2016 1:00 9 Registration System 0 PATIENT 8 65 MALE BLACK NO CONGESTIVE HEART FAILURE MRN8 EMERGENCY LOCATION A 3/14/2016 11:41 3/17/2016 1:02 3 Registration System 1 PATIENT 9 55 MALE BLACK NO CONGESTIVE HEART FAILURE MRN9 SURGICAL LOCATION D 4/13/2016 9:40 4/20/2016 1:09 7 Registration System 2 PATIENT 10 75 FEMALE ASIAN NO SOB X 3 WEEKS MRN10 INPATIENT LOCATION B 4/12/2016 9:46 4/21/2016 1:09 9 Registration System 13 PATIENT 11 60 FEMALE BLACK NO DIZZINESS MRN11 EMERGENCY LOCATION B 4/1/2016 15:11 4/22/2016 1:09 20 Registration System 14 PATIENT 12 86 MALE HISPANIC NO ABSCESS, SACRUM MRN12 INPATIENT LOCATION C 4/5/2016 10:45 4/23/2016 1:09 18 Registration System 15 PATIENT 13 85 FEMALE BLACK YES ABSCESS, SACRUM MRN13 INPATIENT LOCATION C 5/14/2016 15:11 5/30/2016 1:09 15 Registration System 16 PATIENT 14 75 MALE WHITE NO PAIN MRN14 SURGICAL LOCATION D 5/14/2016 9:15 5/21/2016 1:09 7 Registration System 17 PATIENT 15 88 FEMALE WHITE YES ACUTE KIDNEY INJURY MRN15 INPATIENT LOCATION B 6/15/2016 10:43 6/21/2016 1:09 6 Registration System 18 PATIENT 16 75 MALE WHITE NO CONGESTIVE HEART FAILURE MRN16 INPATIENT LOCATION C 6/22/2016 12:52 6/23/2016 1:09 1 Registration System 9 PATIENT 17 65 FEMALE WHITE NO HIP REPLACEMENT SURGERY MRN17 SURGICAL LOCATION A 6/20/2016 7:43 6/24/2016 1:09 4 Registration SystemA B C D E F G H I J K L This chart depicts the number of patient falls that occurred in the hospital in the past four quarters. Patient Falls Qtr. 1 # of Patients July Aug. Sept. 0 Total 1 Qtr. 2 # of Patients UT A W Oct. 0 Nov. 0 Dec. 1 Total 1 Qtr. 3 # of Patients Jan. Feb. wNW Mar. Total 8 Qtr. 4 # of Patients LD Apr. May WNA June IN Total 9This chart depicts all the clinical documentation that was done during the course of the patient's stay. Patient Name Medical Allergies Admit Date Discharge Vital Signs Fall Risk # Days Before # Days Before Diagnosis (Other) Pain Pain CIWA Lung Sounds Edema Weight Record Date Documented: Date Assessment Clinician Clinician Score Controlled Score (Ibs.) Number and Time Documented: Documented Vital Documented Fall (MRN) Date and Time Signs Risk Assessment PATIENT 1 MRN1 Peanut 1/27/2016 10:37 2/7/2016 0:00 2/1/16 12:30 2/2/16 12:30 5.08 6.08 HYPOGLYCEMIA 10 Yes 5 Normal None 120 PATIENT 2 MRNZ No Known Allergy 1/29/2016 10:53 2/9/2016 0:03 2/2/16 6:30 2/4/16 6:30 3.82 5.82 HYPERTENSION 7 Yes 4 Norma Non 130 PATIENT 3 MRN3 No Known Allergy 1/4/2016 9:08 1/7/2016 0:03 1/6/16 10:20 1/5/16 10:20 2.05 1.05 OSTEOPOROSIS 8 Yes 0 Abnormal None 145 PATIENT 4 MRN4 No Known Allergy 2/1/2016 11:08 2/7/2016 0:20 2/2/2016 12:15 2/6/2016 12:15 1.05 5.05 OSTEOPOROSIS 6 Yes 1 Norma None 90 PATIENT 5 MRN No Known Allergy 2/2/2016 20:55 2/5/2016 0:26 2/5/2016 10:25 2/5/2016 11:25 2.56 2.60 HYPOGLYCEMIA 10 Yes 0 Norma None 122 PATIENT 6 MRN No Known Allergy 3/31/2016 12:57 4/5/2016 0:59 4/4/2016 8:17 4/3/2016 8:17 3.81 2.81 OSTEOPENIA 10 Yes 0 Norma None 130 PATIENT 7 MRN7 No Known Allergy 3/31/2016 12:57 4/9/2016 1:00 4/5/2016 6:18 4/7/2016 6:18 4.72 6.72 OSTEOPENIA 9 Yes 0 Norma None 136 PATIENT 8 MRN8 No Known Allergy 3/14/2016 11:41 3/17/2016 1:02 3/16/2016 10:11 3/17/2016 10:11 1.94 2.94 OSTEOPENIA 5 Yes 1 Norma None 144 PATIENT 9 MRNS No Known Allergy 4/13/2016 9:40 4/20/2016 1:09 4/17/2016 3:00 4/19/2016 3:00 3.72 5.72 OSTEOPENIA 7 Yes 5 Abnormal None 155 PATIENT 10 MRN10 Penicillin 4/12/2016 9:46 4/21/2016 1:09 4/18/2016 5:11 4/20/2016 5:11 5.81 7.81 DIABETES 8 Yes 5 Abnorma None 158 PATIENT 11 MRN11 No Known Allergy 4/1/2016 15:11 4/22/2016 1:09 4/9/2016 9:11 4/12/2016 9:11 7.75 0.75 DEMENTIA 9 Yes 4 Abnormal None 170 PATIENT 12 MRN12 No Known Allergy 4/5/2016 10:45 4/23/2016 1:09 4/20/2016 3:11 4/20/2016 8:11 14.68 14.89 DIABETES 10 Yes 3 Normal None 155 PATIENT 13 MRN13 No Known Allergy 5/14/2016 15:11 5/30/2016 1:09 5/21/2016 7:15 5/27/2016 7:15 6.67 12.67 HYPOGLYCEMIA 10 Yes 2 Abnormal None 160 PATIENT 14 MRN14 No Known Allergy 5/14/2016 9:15 5/21/2016 1:09 5/19/2016 11:11 5/18/2016 11:11 5.08 4.08 OSTEOPENIA 10 Yes 0 Normal None 144 PATIENT 15 MRN15 No Known Allergy 6/15/2016 10:43 6/21/2016 1:09 6/17/2016 9:11 6/19/2016 9:11 1.94 3.94 DEMENTIA 9 Yes 0 Normal None 135 B PATIENT 16 MRN1 No Known Allergy 6/22/2016 12:52 6/23/2016 1:09 6/23/2016 11:11 6/22/2016 13:11 0.93 0.01 DEMENTIA 5 Yes 0 Abnormal None 98 PATIENT 17 MRN17 No Known Allergy 6/20/2016 7:43 6/24/2016 1:09 6/23/2016 9:11 6/21/2016 9:11 3.06 1.06 DEMENTIA 7 Yes Normal None 100A B C D E F This chart depicts all the tests done on the patient, such as labs, radiology, and consults done on the patient. Patient Name Medical Record Radiology Labs Performed Consults Ordered Source of Number (MRN) Performed Data IN PATIENT 1 MRN1 EKGUS Abdomen CBC with Diff Cardiac RehabPT Consult Lab System 4 PATIENT 2 MRN2 EKGUS Abdomen CBC with Diff PT Consult Lab System PATIENT 3 MRN3 EKGUS Abdomen CBC without Diff OT Consult Lab System 6 PATIENT 4 MRN4 EKGUS Abdomen CBC with Diff Cardiac RehabPT Consult Lab System 7 PATIENT 5 MRN5 EKGUS Abdomen CBC without Diff PT Consult Lab System 8 PATIENT 6 MRN6 EKGUS Abdomen CBC without Diff PT Consult Lab System 9 PATIENT 7 MRN7 EKGUS Abdomen CBC with Diff PT Consult Lab System 0 PATIENT 8 MRN8 EKGUS Abdomen CBC with Diff OT Consult Lab System 1 PATIENT 9 MRN9 EKGUS Abdomen CBC with Diff PT Consult Lab System 2 PATIENT 10 MRN10 EKGUS Abdomen CBC with Diff Cardiac RehabOT Consult Lab System .3 PATIENT 11 MRN11 EKGUS Abdomen CBC with Diff Cardiac RehabOT Consult Lab System 4 PATIENT 12 MRN12 EKGUS Abdomen CBC with Diff OT Consult Lab System .5 PATIENT 13 MRN13 EKGUS Abdomen CBC with Diff OT Consult Lab System .6 PATIENT 14 MRN14 EKGUS Abdomen CBC without Diff PT Consult Lab System 7 PATIENT 15 MRN15 EKGUS Abdomen CBC without Diff PT Consult Lab System 8 PATIENT 16 MRN16 EKGUS Abdomen CBC without Diff OT Consult Lab System 9 PATIENT 17 MRN17 EKGUS Abdomen CBC without Diff Cardiac Rehab Lab SystemThis chart depicts all the medications that the patients took during the course of their stay. Patient Name Medical Record Medications Medication Review: Medication Reviewed By Source of Data Number (MRN) Date and Time Enoxaparin Sodium 40 Mg Syringe Creatinine 0.90 mg/dL 09/14/16 07:22 cefTRIAXONE LevETIRAcetam INR 3.7 09/13/16 05:30 PATIENT 1 MRN1 INR 3.9 09/14/16 05:22 2/1/16 12:30 Nurse Medication System PATIENT 2 MRN2 Enoxaparin 30 MG/ 0.3 ML SubQ Q12H 2/2/16 6:30 Nurse Medication System PATIENT 3 MRN3 Gabapentin Oral 300 MG / 6 ML PEG Tube TID 1/6/16 10:20 Clinical Pharmacist Medication System PATIENT 4 MRN4 dexaMETHasone 4 MG/ 1 TAB PO Q8H TIMED 2/2/2016 12:15 Nurse Medication System PATIENT 5 MRN5 dexaMETHasone 2 MG/ 0.5 TAB PO Q8H TIMED 2/5/2016 10:25 Nurse Medication System PATIENT 6 MRN6 Bisacodyl 10 MG/ 2 TAB PO Once 4/4/2016 8:17 Nurse Medication System PATIENT 7 MRN7 Acetaminophen 650 MG/ 2 TAB PO Q6H 4/5/2016 6:18 Nurse Medication System PATIENT 8 MRN8 Magnesium Citrate 150 ML PO Once 3/16/2016 10:11 Unknown Medication System 1 PATIENT 9 MRN9 Quetiapine 12.5 MG / 0.5 TAB PO BID PRN Agitation 4/17/2016 3:00 Nurse Medication System 2 PATIENT 10 MRN10 Gabapentin 300 MG / 1 CAP PO BID 4/18/2016 5:11 Clinical Pharmacist Medication System 3 PATIENT 11 MRN11 oxyCODone 5 MG/ 1 TAB PO Q4H PRN Pain Scale - Moder 4/9/2016 9:11 Unknown Medication System 4 PATIENT 12 RN 12 oxyCODone 10 MG/ 2 TAB PO Q4H PRN Pain Scale - Seve 4/20/2016 3:11 Nurse Medication System 5 PATIENT 13 MRN13 Aspirin 81 MG/ 1 CHTAB PO Daily 5/21/2016 7:15 Unknown Medication System 6 PATIENT 14 MRN14 Multiple Vitamin 1 TAB PO Daily 5/19/2016 11:11 Nurse Medication System 7 PATIENT 15 MRN15 Docusate Sodium 100 MG/ 1 CAP PO BID 6/17/2016 9:11 Nurse Medication System 8 PATIENT 16 MRN16 Polyethylene Glycol 3350 17 G/ 1 PKT PO Daily 6/23/2016 11:11 Unknown Medication System 9 PATIENT 17 MRN17 HyDROmorphone 0.5 MG/ 0.5 ML IV Once 6/23/2016 9:11 Clinical Pharmacist Medication System
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
