Using data on healthcare processes

 

You work at Holy Mercy Hospital as the health information department  manager. The hospital’s quality manager comes to you with a question.  The Centers for Disease Control has just changed recommendations for  tetanus booster immunizations (Td) in adults. Instead of every 10 years  for adult booster immunization, the CDC now says every adult patient  admitted to a hospital for surgery should have had a Td booster in the  past 4 years. (NOTE: This policy change is fictitious, used only for the  purposes of this exercise.)

Your quality manager knows that you, as health information manager,  have data on hospital admissions and might have information in the  records on immunizations. She wants an informative report, not just the  raw data. You will develop this report on a historic sample of patients  to predict possible effects of this policy.

At first, you scratch your head. It could take a long time to count  back days from the hospital admissions. You figure out you need to  compare the hospital admission date with the tetanus immunization date.  You check your data. Fortunately these data are saved as date fields.  You should be able to compute the information.

Your task:

Adult patients are those over age 18. For the purposes of this  analysis, assume that all patients in the database were surgical  patients.

  1. Download the Patient Information Excel datasheet  for the sample of patients.
  2. Open the spreadsheet. 
  3. Add one column on the right called Days Td to Admit. Add another column to its right called, Years Td to Admit.
  4. Compute the Days Td to admit by subtracting Tetanus Date from Admission Date. Compute the Years Td to admit.
  5. Determine which patients and how many would not have complied with  the new policy because their boosters were not recent enough. What is  the rate of patients out of compliance, as a percentage of the total  sample? Remember to exclude children.
  6. Create a new worksheet in the Patient Information Excel datasheet  and prepare a table of patients who would be out of compliance,  including patient names, birthdates, admission dates, and number of  years Td to Admit for the quality manager. Indicate this information was  from a sample, not the entire hospital.







Calculate Your Essay Price
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 10% with the coupon code: best10