DB#2 Core Measures Discharges Database Assignment

| August 30, 2017

Objective #1:
In the 1stand 2ndexcel worksheet tabs, sort the November and December discharge data pertaining to AMI, CHF, and pneumonia to determine any readmissions within 30 days for the hospital for December discharges for these specific diagnoses identified by ICD-9 coding: AMI 410.0-410.9, CHF 428, pneumonia 486 on primary diagnosis. Recommend copying the November and then the December discharge data side by side in a blank worksheet tab FOR EACH ICD-9 code. Sort both November and December by the column for the ICD code. Compare November against December to find the duplicate readmissions FOR EACH ICD-9 code.

Transfer your calculations (the number of duplicate readmissions) determined for December 30-day readmissions onto the 3rd tab, 2010 IPPS 30-day Readmit Rates for each ICD-9 code in the yellow highlighted column.. In the 3rdtab, derive the percentage of readmits by month and diagnosis in the format provided. Have Excel compute the percentage for you. In cell B12 enter the formula to divide Readmits for AMI by Total Discharges. Pull the formula to the right through to act on the remaining months. Do the same for CHF and Pneu.

Objective #2:
Apply the 2010 data to reporting graphics (using a excel-generated chart) to demonstrate trending. Apply titles and labels. What chart describes the trend most clearly? Presentation should clarify the trend clearly to the hospital leadership. Highlight all of these rows and columns in the 3rdtab, including the header rows. Choose the Insert tab from the Ribbon at the top of Excel. Choose Charts. Try several charts. Which chart displays the trend most effectively?

Objective #3:
Were Willie Getwell Hospital’s efforts to improve their 30-day readmission rates preliminarily effective according to the information gathered from this assignment? Summarize your analysis textually in a textbox. Insert a text box. Compose a paragraph summarizing your analysis. Describe the trend for each of the ICD-9 codes. Have Getwell Hospital’s efforts been effective? Describe research that you have found that addresses this subject.

Objective #4:

Present your analysis in a hospital board-worthy presentation. Create a 4thtab within the spreadsheet. Name the fourth worksheet tab Summary 2010 30-day Readm Trend. Note that presentation is a factor in the rubric criteria. Use color to tie coordinating elements together. Label your chart. Include a list of your references.

In a fourth worksheet tab, present your summary information:

1. The numbers determined for 30 day readmissions

2. Trending chart

3. Textual summary

Get a 30 % discount on an order above $ 100
Use the following coupon code:
Order your essay today and save 30% with the discount code: RESEARCHOrder Now
Positive SSL