Database Assignment #2Inpatient Readmissions
All data in this assignment is fictitious. Medical record numbering identifies each individual patient from your study in HIT 1200.Remember, patients may have the same name, but they do not have the same medical record number.
For a quick study of the ACA section establishing the Hospital Readmissions Reduction Program for this assignment, read http://healthaffairs.org/blog/2014/07/24/examining…
Please note that for the purposes of this assignment, HF (heart failure) will be correlated to CHF (congestive heart failure, and PN (pneumonia) will be correlated to pneu or pneumonia.
Case Study
Willie Getwell Hospital has identified the CMS IPPS proposed legislation and in preparation for this legislation, they are tracking their 30-day readmission data.They have recently set in place an organization-wide education and discharge medication verification program for their patients.Please help the health information management director gather appropriate information to be shared with hospital leadership.She hopes the December numbers will continue to show an improvement.
You are provided an excel spreadsheet of information downloaded via a query from the hospital’s database.This is your sample data of November and December records.Apply the knowledge you gained from MIS 3100.For example, this assignment demonstrates how if the hospital were to change electronic health records, why information, such as data dictionaries, from one EHR would need to be identical to the other, or an interface would have to be developed.
Objective #1:
In the 1st and 2nd excel 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 3rd tab, 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 3rd tab, 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 4th tab 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
Submit the entire spreadsheet as a document in Assignment Files.
Save assignment with the name:lastname, firstname, DB2 Readmissions.
Anecdotal information regarding this assignment:The ICD-9 coding used in this assignment is to demonstrate that a health information professional may have to look at and understand historical data displayed from ICD-9 coding.The coding required to be identified from this assignment is not meant to be encompassing of all coding required to be tracked for the 30-day readmission criteria for these diagnoses for determination of IPPS.
Data Base Rubric | Max Points:120 | ||||||
0 | 3 | 5 | 10 | 20 | 30 | ||
Accuracy | 3-4 errors | 1-2 errors | No errors present | ||||
Complete: All instructions preformed | None of the elements present | 1 element present | 2 elements present | All elements present | |||
Presentation | A few presentation elements are used to good effect | Several presentation elements used to good effect. | Chart with title & legends clearly displays trend.Text summary set off effectively.Bolding, highlights, & color fill draws attention to significant elements.Percentages are rounded.Summary tab is printable on one page. | ||||
Comprehension | Demonstrates no comprehension | Demonstrates little comprehension | Comprehension is demonstrated | Synthesized information from another source with your analysis. | Synthesize information from more than one quality source with your analysis. Credit source in citation and reference. | ||
How to solve
Inpatient Readmissions Nursing Assignment Help
Objective #1:
To sort the November and December discharge data for AMI, CHF, and pneumonia and determine any readmissions within 30 days for the hospital for December discharges with specific ICD-9 codes.
– Copy the November and December discharge data side by side in a new worksheet tab for each ICD-9 code.
– Sort both November and December data by the column for the ICD code.
– Compare November against December to find duplicate readmissions for each ICD-9 code.
– Transfer the number of duplicate readmissions for December onto the 3rd tab, labeled “2010 IPPS 30-day Readmit Rates,” in the yellow highlighted column.
– Derive the percentage of readmissions by month and diagnosis in the provided format.
– Use Excel to compute the percentage.
– Use the formula “=Readmits for AMI / Total Discharges” in cell B12 to calculate the percentage for AMI.
– Repeat the formula for CHF and pneumonia.
– Pull the formula to the right to calculate the percentages for the remaining months.
Objective #2:
To apply the 2010 data to reporting graphics and present trending information clearly to hospital leadership.
– Select all relevant rows and columns in the 3rd tab, including the header rows.
– Go to the Insert tab in Excel and choose Charts.
– Try several different types of charts to see which one displays the trend most effectively.
– Apply titles and labels to the chosen chart.
Objective #3:
To analyze the data and determine if Willie Getwell Hospital’s efforts to improve their 30-day readmission rates were preliminarily effective.
– Summarize the analysis textually in a textbox.
– Insert a text box and compose a paragraph summarizing the analysis.
– Describe the trend for each of the ICD-9 codes.
– Evaluate if Getwell Hospital’s efforts have been effective.
– Research and include relevant findings that address the subject.
Objective #4:
To present the analysis in a hospital board-worthy presentation.
– Create a 4th tab within the spreadsheet and name it “Summary 2010 30-day Readm Trend.”
– Use color to tie coordinating elements together.
– Label the chart correctly.
– Include a list of references.
– Present the summary information, including the number of 30-day readmissions, trending chart, and textual summary in the fourth worksheet tab.
Remember to save the assignment as a document in Assignment Files with the name: lastname, firstname, DB2 Readmissions.
