Using the attached assignment Rubric for the specific grading criteria, complete the following
Davenport Hospital has noticed a marked increase in patients traveling far distances for cancer treatment, and it is impacting patient satisfaction results. The administrator of the facility is considering adding a satellite clinical or ambulatory care facility that serves the cancer patient population in a manner that is consistent with organizational strategies and objectives. You are charged with utilizing enterprise-wide information assets to determine if there is data to potentially support this endeavor After reviewing the data that is available in the attached excel document, answer the following in a word document that adheres to APA formatting as appropriate. 1. Make a recommendation for organizational action based on your fiding to your administrator. This recommendation should include at a minimum a directional suggestion (If you suggest a satellite clinic, would it be to the north, south, etx and why) as well as an interpretation of the data provided to support your recommendation This should be 2-4 paragraphs in lengthSection should be labeled Recommendation Based on DataExample: Recommendation: I would not recommend adding a satellite clinic as the data suggest that no patient travels more than 25 miles to be seen. In addition, all of the patients are utilizing the hospital lab, pharmacy, and other testing options. 2. Discuss any trend(s) that you notice in the data. Do quality, safety or effectiveness of healthcare appear to be impacted based on the trend(s) that you have identified? 3. Then discuss how data exploration, data mining, and database querying were used to facilitate this activity. HINT215 Decision Making Assignment Rubric
CATEGORY
Quality of
Information
105-90
89-74
73-58
57-0
Information clearly
Information relates to the Information minimally
Information has little or
addresses all the areas of main topic. It addresses
relates to the main topic. It nothing to do with the main
the assignment. It includes some of the questions of addresses a few areas of topic.
several pieces of
the assignment. It includes the assignment. No details
supporting information for some supporting
and/or supporting
those answers.
information.
information provided.
CATEGORY
Mechanics
15-13
12-9
No grammatical, spelling or Almost no grammatical,
punctuation errors.
spelling or punctuation
errors
8-5
4-0
A few grammatical spelling, Many grammatical,
or punctuation errors.
spelling, or punctuation
errors.
Organization
Information is very
organized with
well-constructed
paragraphs and
subheadings. Follows
format directions.
All sources (information
and graphics) are
accurately documented in
the desired format.
Information is organized
with well-constructed
paragraphs.
Information is organized,
but paragraphs are not
well-constructed.
The information appears to
be disorganized.
All sources (information
and graphics) are
accurately documented,
but a few are not in the
desired format.
All sources (information
and graphics) are
accurately documented,
but many are not in the
desired format.
Some sources are not
accurately documented.
Sources/ APA
Site
Lung
Larynx
Colon
Stomach
Rectum
Uterus
Bladder
Prostate
Cervix
Breast
Others
Total
Number
77
11
55
16
23
27
27
23
38
55
195
547
Males
67
5
47
8
17
0
13
23
0
2
98
265
Females
10
6
8
8
6
27
14
0
38
53
97
239
Age
Distribution
11-25
26-40
41-60
61-75
76+
Number
55
59
208
141
84
Travel Distance
0-25 Miles
26-50 Miles
51-75 Miles
76-100 Miles
101-125 Miles
126-150 Miles
151+ Miles
Total
Cases
52
157
17
174
106
28
13
547
North of
Hospital
40
135
10
139
86
28
13
451
South of
Hospital
2
5
1
3
1
0
0
12
East of
Hospital
7
12
5
25
13
0
0
62
West of
Hospital
3
5
1
7
6
0
0
22
Travel Distance
0-25 Miles
26-50 Miles
51-75 Miles
76-100 Miles
101-125 Miles
126-150 Miles
151+ Miles
Total
Cases
52
157
17
174
106
28
13
547
Hospital Lab*
52
135
0
0
0
0
0
187
Outside Lab*
0
17
17
174
106
28
13
355
*Lab use for intermittent lab draws; data does not include labs while present for
inpatient or outpatient procedures or check ups.
Travel Distance
0-25 Miles
26-50 Miles
51-75 Miles
76-100 Miles
101-125 Miles
126-150 Miles
151+ Miles
Total
Cases
52
157
17
174
106
28
13
547
Hospital Pharmacy*
15
18
0
0
0
0
0
33
Outside Pharmacy*
37
134
17
174
106
28
13
509
*Prescriptions filled for monthly prescriptions. Does not include those needed for inpatient or
outpatient visits.
Travel Distance
0-25 Miles
26-50 Miles
51-75 Miles
76-100 Miles
101-125 Miles
126-150 Miles
151+ Miles
Total
Cases
52
157
17
174
106
28
13
547
Hospital*
15
18
0
0
0
0
0
33
Outside Facility*
37
134
17
174
106
28
13
509
*Tests such as MRI, CT Scan outside of inpatient or outpatient procedures at the facility.
Distance
Travel Distance
0-25 Miles
26-50 Miles
51-75 Miles
76-100 Miles
101-125 Miles
126-150 Miles
151+ Miles
Total
Cases
52
157
17
174
106
28
13
547
Highly
Satisfied
Somewhat
Satisfied
No
Unsatisfied Answer
45
100
5
12
16
1
0
179
0
35
10
98
35
2
0
180
0
2
1
40
50
9
9
111
7
20
1
24
5
16
4
77
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
