GMU Wk 7 Control Charts Rate of Prophylactic Antibiotic Overuse Project


I need a math/science tutor who can help me in my assignment. Please see the attached files for the instructions. If you have questions, just kindly approach me here. Thank you very much.

2 attachmentsSlide 1 of 2attachment_1attachment_1attachment_2attachment_2

Unformatted Attachment Preview

This exercise allows you to examine how quality of hospital care is evaluated through data obtained
from electronic health records. This exercise is discussed in several health administration courses,
including courses on quality improvement, informatics, or statistics. In practice, the need to analyze
these types of data arises in improvement teams, where managers, clinicians and sometimes
patients work together to systematically improve healthcare processes.
Part 1: In this assignment, you are asked to examine if prophylactic antibiotics are discontinued
within 24 hours after end of surgery. Instead of providing you with the data, we ask that you
download the data on the web so that you learn more about the source of the data and peculiar
organization of the data. Hospital Compare provides information on many quality indicators. In this
assignment, you are asked to focus on failure to stop use of antibiotics post-surgery. The Hospital
Compare web site provides the following rationale for why this measure of quality is helpful: “A goal
of prophylaxis with antibiotics is to provide benefit to the patient with as little risk as possible. It is
important to maintain therapeutic serum and tissue levels throughout the operation. Intra-operative
re-dosing may be needed for long operations. However, administration of antibiotics for more than a
few hours after the incision is closed offers no additional benefit to the surgical patient. Prolonged
administration does increase the risk of clostridium difficile infection and the development of
antimicrobial resistant pathogens.” To complete this assignment, complete the following tasks:
1. Download Hospital Compare data for the years starting from 2015 till now. Merge the file
“HQI_HOSP_TimelyEffectiveCare” across all databases for different years.
2. Select measure ID “SCIP_INF_3”; this measure refers to prophylactic antibiotic use. Select
to work with data from “Southeast Alabama Medical Center”; this is provider ID “010001”.
3. Calculate rate of overuse of antibiotics. In these data, the field “Score” refers to the number
of patients with overuse of antibiotics. The field “Sample” refers to all selected surgical
patients with no evidence of prior infection. The ratio of Score to Sample provides the rate of
overuse of antibiotics.
4. Construct a control chart showing rate of overuse of prophylactic antibiotic over time in
Southeast Alabama Medical Center. Download the needed data using the following
databases (if new data is available, please use them)

You can find the solution here here – Alternative Formats .
The student peer video shows that data across the years us merged using SQL. You can do the
same merger without using SQL. Open the CSV files (you can ignore access files for old years.)
Filter the data by the measure you are interested in Copy the sheet with the relevant filtered data
from each CSV file into a single sheet within the new Excel file. In a sheet titles “ALL” inside the
Excel file, use cell reference to bring the data in different sheets to the “ALL” sheet. Do your analysis
on this sheet.
Part 2: Nursing home and hospital administrators implement many initiatives to reduce falls. This
problem shows how these initiatives can be measured and evaluated. Prepare a risk-adjusted
control chart for data
on falls in a nursing home

Please use the following peer video as a reference for this assignment. You can find the
solution here here – Alternative Formats .
Part 3: The following data were obtained on post surgical infection rates. Are we having more
infections than expected from the patients’ conditions?

You can find the solution here here – Alternative Formats .
Part 4: Download Hospital Compare data. In these files the denominator indicates the number of
patients. Whether the hospital had above average payments are reported in different fields:
[Compared to National], [Category], and [Payment Category]
Select data that meet the following conditions:
1. Select the “PAYM_30_AMI” measure
2. Select hospitals that in the denominator do not have “Not Available”.
Construct a control chart showing probability of change over time.
To assist, we have download some of the necessary files. You can add to these additional more
recent files from the Hospital Compare site. Since the data on AMI payments does not change in the
files, you can save time and read only the following files into a new database:
HOSArchive_20150122Compared to National2010 2013
HQI_HOSP_PaymentAndValueOfCareHOSArchive_20161110Payment Category
2011 2014
2012 2015
Include other data for more recent years after 2016

You can find the solution here here – Alternative Formats and here here – Alternative
Formats .
Some of you do not have Microsoft Access. Early files in Hospital Compare used Microsoft Access
and later files used CSV (a file format that opens with Excel.) To remedy this situation, I am
replacing Microsoft Access files with Excel Files. If you have to look at only AMI quality measures
you need to use the filter feature within Excel.
Use these files:

Purchase answer to see full

antibiotic use

Data Evaluation

prophylactic antibiotic

control chart

Rate of overuse

User generated content is uploaded by users for the purposes of learning and should be used following Studypool’s honor code & terms of service.

Reviews, comments, and love from our customers and community:

This page is having a slideshow that uses Javascript. Your browser either doesn't support Javascript or you have it turned off. To see this page as it is meant to appear please use a Javascript enabled browser.

Peter M.
Peter M.
So far so good! It's safe and legit. My paper was finished on time...very excited!
Sean O.N.
Sean O.N.
Experience was easy, prompt and timely. Awesome first experience with a site like this. Worked out well.Thank you.
Angela M.J.
Angela M.J.
Good easy. I like the bidding because you can choose the writer and read reviews from other students
Lee Y.
Lee Y.
My writer had to change some ideas that she misunderstood. She was really nice and kind.
Kelvin J.
Kelvin J.
I have used other writing websites and this by far as been way better thus far! =)
Antony B.
Antony B.
I received an, "A". Definitely will reach out to her again and I highly recommend her. Thank you very much.
Khadija P.
Khadija P.
I have been searching for a custom book report help services for a while, and finally, I found the best of the best.
Regina Smith
Regina Smith
So amazed at how quickly they did my work!! very happy♥.