Title of the Paper in Full Goes Here
Student Name Here
Program Name or Degree Name, Walden University
Course Number, Section, and Title
(Example: NURS 0000 Section 01, Title of Course)
Instructor Name
Month, Day, Year
(enter the date submitted to instructor)
Week 5: Quantitative Analysis Assignment
Summary Data Analysis Form
This is the form you need to use to describe the findings (or results) of your quantitative analyses of the patient safety data set. The data set is found in the Week 5 Learning Resources. For each finding, you are given specific instructions on how to use the Excel program to analyze the data that will give you the results you need for this Assignment. When you have completed the analyses and described your findings on this form, you then need to submit it using the Week 5 platform for assignments.
Analysis 1:
What is the mean age of patients in the patient safety data set?
_____ years
Instructions:
a) Open up your patient safety data set using the Microsoft Excel program.
b) At the top of your screen, click on “Formulas.”
c) Highlight Column B, starting at line 2 and ending at line 52.
d) Click on “Autosum,” and then click on “Average.”
e) You will find the mean age of patients in the data set on line 52 for Column B.
Analysis 2:
What percentage of patients were reported to have fallen during their hospitalization?
_____ %
Instructions:
a) Open up your patient safety data set using the Microsoft Excel program.
b) At the top of your screen, click on “Formulas.”
c) Highlight Column G, starting at line 2 and ending at line 52.
d) Click on “Sum.”
e) The number of patients in the data set who had reported falls during their hospitalization is now given on line 52 for Column G.
f) To calculate the percentage of patients who fell during their hospitalization, divide the number of falls by the total number of patients in the data set (n = 50).
Analysis 3:
What percentage of patients reported catheter-associated urinary tract infections (CAUTIs) during their hospitalization?
_____ %
Instructions:
a) Open up your patient safety data set using the Microsoft Excel program.
b) At the top of your screen, click on “Formulas.”
c) Highlight Column H, starting at line 2 and ending at line 52.
d) Click on “Sum.”
e) The number of patients in the data set who reported CAUTIs during their hospitalization is now given on line 52 for Column H.
f) To calculate the percentage of patients with CAUTIs during their hospitalization, divide the number of CAUTIs by the total number of patients in the data set (n = 50).
Analysis 4:
What percentage of patients reported medication errors during their hospitalization?
_____ %
Instructions:
a) Open up your patient safety data set using the Microsoft Excel program.
b) At the top of your screen, click on “Formulas.”
c) Highlight Column I, starting at line 2 and ending at line 52.
d) Click on “Sum.”
e) The number of patients in the data set who reported medication errors during their hospitalization is now given on line 52 for Column I.
f) To calculate the percentage of patients with reported medication errors during their hospitalization, divide the number of errors by the total number of patients in the data set (n = 50).
Analysis 5:
What percentage of patients reported methicillin-resistant Staphylococcus aureus (MRSA) infections when first admitted to the medical unit?
_____ %
Instructions:
a) Open up your patient safety data set using the Microsoft Excel program.
b) At the top of your screen, click on “Formulas.”
c) Highlight Column J, starting at line 2 and ending at line 52.
d) Click on “Sum.”
e) The number of patients in the data set who reported MRSA infections at the beginning of their hospitalization is now given on line 52 for Column J.
f) To calculate the percentage of patients with MRSA, divide the number of errors by the total number of patients in the data set (n = 50).
Data Analysis
Summarize the findings from your analyses about these patient safety events that occurred in one month on the two medical units at this major urban hospital. What additional information would you need to help develop a plan to decrease the occurrence of these events? The summary should consist of a minimum of 350 words and should be two to three paragraphs. Citations should be used to support statements. After the summary, a reference section should be included.
References
List your own references in alphabetical order and in APA format. References should be published within the last five years. In your paper, be sure every reference entry matches a citation, and every citation refers to an item in the reference list.
Week 5 Qualitative Data Analysis
Narrative Text on Challenges of Staying in the Hospital
001 Hospital food is the worst! I had a really hard time getting it down. I had a lot of pain the whole time I was in the hospital, and I often had to wait a long time for medications to help with the pain.
002 It felt like I was always waiting: waiting to get testing done, waiting for medicine. Waiting is hard.
003 The hospital smell really bothered me. Because of it, I also had a hard time keeping food down and sleeping.
004 Staying in the hospital is hard, because you aren’t around your own stuff. I wanted my bed and my TV. I really hated waiting for the doctor to come in and talk with me about my condition.
005 While I was staying in the hospital, some of my belongings went missing. I think that they were stolen. I ended up with pneumonia, and the staff did not communicate what was going on with my condition.
006 I didn’t feel like the staff really cared about making me feel better. They seemed to want to get out of my room as quickly as possible.
007 I didn’t like being woken up in the night to get vitals or medicine. One time, I was given the wrong medication in the night as well.
008 The nurses were very loud went a little “stir crazy,” too, just sitting around all day.
009 The hardest part for me was being away from my husband and kids sleeping was really difficult there.
010 I’m not very good at waiting. The sitting around drove me a little crazy. I also had a really hard time being away from my dogs.
Week 5 Qualitative Analysis Assignment
Coding Scheme: Challenges of Staying in the Hospital
Comforts
01 = Too loud (e.g., nurses, roommate, “beeping”)
02 = Food tasted bad
03 = Could not keep food down (e.g., due to sickness, medication)
04 = Problems sleeping (e.g., due to noise, being uncomfortable)
05 = Did not like being awakened (e.g., for vital checks, medication times)
06 = Pain from injury/illness
Waiting
07 = Does not like “sitting around”
08 = Waiting time for medication
09 = Waiting time for testing
10 = Waiting time for doctor visits
Being Away From Home
11 = Miss family
12 = Miss animals
13 = Wants personal belongings
Staff Issues
14 = Poor communication (e.g., from doctors, nurses)
15 = Medication errors
16 = Staff did not listen to concerns
17 = Feeling that “no one cares”
Other Non-Staff Issues
18 = “Hospital smell”
19 = Hospital-acquired infection (e.g., MRSA, CAUDI)
20 = Theft of personal property
98 = Other: Patient’s written response is not a challenge or doesn’t fit coding scheme.
99 = Unable to decipher meaning of patient response
Week 5 Qualitative Data Analysis
Code Sheet: Challenges of Staying in the Hospital
ID # CODE 1 CODE 2 CODE 3
001
002
003
004
005
006
007
008
009
010
After you complete the code sheet, summarize the major themes or most common challenges described by the 10 patients during their hospital stays. This should be written in paragraph format.
