assignment 1
ANALYSIS OF QUANTITATIVE DATA
In order to provide meaningful results, research processes must be carefully selected and appropriate for the data being analyzed. Statistical programs such as SPSS are frequently utilized by researchers to conduct the analysis of large data sets. These data are organized to provide meaningful interpretation and often include descriptive statistics. Qualitative analysis is completed using content analysis, looking for patterns and themes that emerge from the data. Individual experiences described in interviews and focus groups are considered data and are often provided as examples to support the results in the study publication. Whether you will engage in either quantitative or qualitative research, it is likely that you will encounter both types of studies in the literature. As a nursing professional, being able to analyze and interpret both types of research designs will be important to affect nursing practice that promotes positive health outcomes in
quality of care and patient safety.
For Assignment 1, you will conduct descriptive statistical analyses using quantitative data. For Assignment 2, you will conduct content coding to analyze qualitative data. Please review the Instructions: Quantitative Analysis Assignment and Instructions: Content Coding of Challenges of Staying in the Hospital in this week’s resources to review how to complete both parts of this Assignment. Note: Assignments 1 and 2 will not be accepted unless the required templates are used.
ASSIGNMENT 1: QUANTITATIVE ANALYSES
· Follow the step-by-step instructions provided in the Instructions: Quantitative Analysis Assignment document in this week’s resources on using the Excel program to conduct descriptive analyses of quantitative data.
· The Quantitative Data Excel Assignment spreadsheet that you will need is in the resources for this week.
· For this Assignment, you will need to describe the findings from your analyses and summarize what they tell you about these patients and the extent of the adverse events they experienced during their hospitalization. What additional information would you need to help develop a plan to decrease the occurrence of these events? Use the Summary Data Analysis Form in this week’s resources to complete your analysis.
RESOURCES: please see attached other uploaded documents.
Rubric
NURS_3150_Week_5_Assignment_1_Rubric
| NURS_3150_Week_5_Assignment_1_Rubric | ||||
|
Criteria |
Ratings |
Pts |
||
|
This criterion is linked to a Learning OutcomeCompletes accurate analysis of: mean age, percentage of patients fallen, percentage of patients reported catheter-associated urinary tract infections, percentage of patients reported medication errors, percentage of patients reported methicillin-resistant Staphylococcus aureus (MRSA) infections when first admitted. 5 points for each analysis. |
25 to >20.0 pts Excellent Provides 5 accurate analyses. 20 to >15.0 pts Proficient Provides 4 accurate analyses. 15 to >10.0 pts Basic Provides 3 accurate analyses. 10 to >0 pts Needs Improvement Provides 2 or less accurate analyses. |
25 pts |
||
|
This criterion is linked to a Learning OutcomeSummarizes findings of the analyses of patient safety events. Discusses possible additional information needed to decrease the occurrence of adverse patient safety events. |
45 to >40.0 pts Excellent Student provided a fully developed summary of patient safety events and included possible additional information needed to decrease the occurrence of patient safety events. 40 to >35.0 pts Proficient Student provided a developed summary of patient safety events and included some possible additional information needed to decrease the occurrence of patient safety events. 35 to >31.0 pts Basic Student provided a minimally developed summary of patient safety events with limited possible additional information needed to decrease the occurrence of patient safety events. 31 to >0 pts Needs Improvement Student provided an under- developed summary of patient safety events with very limited or no discussion of possible additional information needed to decrease the occurrence of patient safety events. |
45 pts |
||
|
This criterion is linked to a Learning OutcomeProfessional Writing: Clarity, Flow, and Organization |
10 to >8.0 pts Excellent Content is free from spelling, punctuation, and grammar/syntax errors. Writing demonstrates very well-formed sentence and paragraph structure. Content presented is completely clear, logical, and well-organized. 8 to >7.0 pts Proficient Content contains minor spelling, punctuation, and/or grammar/syntax errors. Writing demonstrates appropriate sentence and paragraph structure. Content presented is mostly clear, logical, and well-organized. 7 to >6.0 pts Basic Content contains moderate spelling, punctuation, and/or grammar/syntax errors. Writing demonstrates adequate sentence and paragraph structure and may require some editing. Content presented is adequately clear, logical, and/or organized, but could benefit from additional editing/revision. 6 to >0 pts Needs Improvement Content contains significant spelling, punctuation, and/or grammar/syntax errors. Writing does not demonstrate adequate sentence and paragraph structure and requires additional editing/proofreading. Key sections of presented content lack clarity, logical flow, and/or organization. |
10 pts |
||
|
This criterion is linked to a Learning OutcomeProfessional Writing: Context, Audience, Purpose, and Tone |
10 to >8.0 pts Excellent Content clearly demonstrates awareness of context, audience, and purpose. Tone is highly professional, scholarly, and free from bias, and style is appropriate for the professional setting/workplace context. 8 to >7.0 pts Proficient Content demonstrates satisfactory awareness of context, audience, and purpose. Tone is adequately professional, scholarly, and/or free from bias, and style is consistent with the professional setting/workplace context. 7 to >6.0 pts Basic Content demonstrates basic awareness of context, audience, and purpose. Tone is somewhat professional, scholarly, and/or free from bias, and style is mostly consistent with the professional setting/workplace context. 6 to >0 pts Needs Improvement Content minimally or does not demonstrate awareness of context, audience, and/or purpose. Writing is not reflective of professional/scholarly tone and/or is not free of bias. Style is inconsistent with the professional setting/workplace context and reflects the need for additional editing. |
|||
|
This criterion is linked to a Learning OutcomeAPA Attribution and Formatting: cover page, title of paper on second page, level headings, Times New Roman 12 font, 1″ margins, and page numbers. APA References: Uses in-text citations appropriately and format correctly. Paraphrases to avoid plagiarizing the source. |
10 to >8.0 pts Excellent Demonstrates fully developed APA formatting with no errors using the template provided. 8 to >7.0 pts Proficient Demonstrates developed APA formatting with few formatting errors using the template provided. 7 to >6.0 pts Basic Demonstrates minimally developed APA formatting with several formatting errors using the template provided. 6 to >0 pts Needs Improvement Demonstrates limited APA formatting with multiple formatting errors or fails to use the template provided. |
|||
|
Total Points: 100 |
Previous
Next
2
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.
>Sheet 1 1 1 1 1 2 1 1 1 2 2 2 1 2 1 2 2 2 1 1 2 1 2 1 1 1 1 2 2 64 1 1 1 2 19 1 1 52 1 1 49 79 23 1 2 24 1 1 31 80 Week 5: Quantitative Analysis Assignment
Instructions: Quantitative Analysis Assignment
For the Week 5 quantitative analysis assignment, you will need to conduct basic descriptive analyses about the frequency of patient safety incidents during one month on two medical units in a major urban teaching hospital. To complete this assignment, you will need the following three documents: (a) Excel Spreadsheet: Quantitative Patient Safety Data, (b) Codebook: Quantitative Patient Safety Data, and (c) Summary Data Analysis Form. Below is a description of each of these documents: (a) Each column is a different To clarify this, look at the date set for this assignment. You will see that the patient in row 2 has an ID number 00 1 (Column A) and is 22 years old (Column B). The patient in row 44 has an ID number 43 is 75 years old. (b) As an example, look at the variable called FALLS. Next to this variable is its description which is defined as whether or not a patient had an accidental fall during the hospitalization. The response categories for the variable FALLS is either “0” which means the patient did not fall or “1” which means the patient did fall. To further clarify this, take a look at Column G on your Excel spreadsheet which is labelled as FALLS. The term “falls” can mean many different things, such as a person accidentally falling at home or a waterfall (e.g., Snoqualmie Falls). The codebook for a quantitative data set gives the specific definition of a variable. In this assignment, the variable FALLS means a patient fall that is reported during a hospitalization. Now look at the numbers in the column underneath FALLS. You will only see the numbers “0” or “1”. In the codebook, these are the response categories for the variable FALLS with 0 = no fall and 1 = fall occurred. Now that you know about the rows and columns of a rectangular data set, you are ready to conduct some basic analyses that summarize (or aggregate) information about the 50 patients in the patient safety data. (c) 1 Week 5: Quantitative Analysis Assignment
Code Book: Quantitative Patient Safety Data
Column
Variable
Description
Response Categories
A ID Unique patient identification number
B AGE Age of patient in years
C GENDER Sex of patient 1 = female; 2 = male
D EDUC Educational level of patient Education in years E UNIT Inpatient hospital unit 1 = medical unit 1 F DX Primary diagnosis of patient when 1 = congestive heart failure G FALLS Reported fall during hospitalization 0 = no fall H CAUTI Reported catheter-associated 0 = no CAUTI I RXERR Reported medication error during 0 = no medication error J MRSA Reported methicillin-resistant 0 = no MRSA Turnitin Report Formatting Title Page Citation Outline
2
1
ID
AGE
GENDER
EDUC
UNIT
DX
FALL
CAUTI
RXERR
MRSA
1
22
1
4
2
0
0
0
2
5
7
1
6
5
0
0
0
0
3
4
8
13
5
0
0
1
0
4
6
9
12
3
1
0
0
0
5
34
15
4
0
0
1
0
6
76
12
2
2
1
0
0
0
7
63
15
2
1
0
1
0
0
8
52
16
2
0
0
0
1
9
55
12
1
1
0
1
1
0
10
58
11
5
1
0
0
0
11
66
12
2
4
0
0
1
0
12
64
16
1
4
0
1
0
0
13
79
10
2
2
1
0
0
0
14
73
8
2
3
0
0
1
0
15
55
2
12
2
1
1
0
0
0
16
63
2
13
1
2
0
1
0
0
17
68
16
1
4
1
1
0
0
18
80
12
1
2
1
0
0
0
19
59
12
1
5
0
0
1
0
20
25
13
2
2
0
0
0
1
21
35
16
2
4
0
0
1
0
22
78
11
1
2
1
1
0
0
23
67
17
2
3
1
0
0
0
24
1
14
1
3
0
0
0
1
25
58
2
12
2
5
1
0
0
0
26
71
10
2
1
1
0
0
0
27
51
17
2
5
0
0
1
0
28
40
12
2
3
0
0
0
1
29
49
17
1
5
0
1
0
0
30
2
12
2
4
0
0
1
0
31
45
13
2
4
1
0
0
0
32
93
8
1
2
1
0
0
0
33
1
13
2
1
0
0
1
0
34
46
16
2
4
0
0
0
1
35
18
2
12
2
4
0
0
1
0
36
90
8
1
2
1
0
0
0
37
2
16
1
4
0
0
0
1
38
2
12
1
1
1
0
0
0
39
2
14
2
2
0
0
1
0
40
87
11
1
2
0
1
0
0
41
50
16
2
3
0
0
1
0
42
2
16
2
4
0
0
1
0
43
75
8
1
2
1
0
0
0
44
53
16
2
1
0
0
0
1
45
29
1
16
2
4
0
0
1
0
46
66
1
13
1
1
1
1
0
0
47
2
12
2
4
0
1
0
0
48
1
12
1
2
1
0
0
0
49
33
1
12
2
2
1
0
0
0
50
19
2
13
1
2
0
1
0
0
54.8
Sheet2
Sheet3
Excel Spreadsheet: Quantitative Patient Safety Data: The quantitative data for this assignment has been entered into an Excel spreadsheet which can be accessed using the Excel software that is part of the Microsoft Office suite of applications. This type of spreadsheet is called a rectangular file because it is arranged in columns and rows.
variable in the data set. For example, Column A (ID) is the identification number variable for patients, and Column B (AGE) is the variable on patient age in years. Each row has
data (or information) for each individual patient for each of the variables in the columns.
Codebook: Quantitative Patient Safety Data: A codebook is used in quantitative research to define the variables (or columns) in a data set and the response categories for each of these variable. Looking at the codebook for this assignment, you will see that the second column in the codebook is the name of variables in the data set. Usually the variable names are abbreviated (e.g., DX stands for primary diagnosis upon admission). Next to each variable name is its description and its response categories.
Summary Data Analysis Form: This form provides guidelines on how to conduct the required quantitative analyses for this assignment and how to report your findings. When you complete your analyses, you need to submit this completed form using the Week 5 platform for submitting assignments.
Name
completed
2 = medical unit 2
admitted to medical unit
2 = pneumonia
3 = chronic obstructive
pulmonary disease
4 = diabetes
5 = R/O myocardial
infarction
6 = other
1 = fell
urinary tract infection
1 = CAUTI
hospitalization
1 = medication error
Staphylococcus aureus (MRSA)
infection
1 = MRSA infectionOrder an Essay Now & Get These Features For Free:
