Hospital Data Analysis and Reporting Project

Hospital Data Analysis and Reporting Project

Management affiliation

Course Project: Hospital Data Analysis and Reporting

Objective

The purpose of this Course Project is to apply the knowledge gained in analyzing various performance indicators of a hospital, analyzing trends, determining compliance or poor performance areas, and providing recommendations for improvement or solutions.

Guidelines

For this Course Project, you are asked to analyze a number of status reports for General Hospital, determine compliance with indicators provided to you, and provide suggestions or make recommendations for improvement where needed.

Data on the following indicators are provided in a Microsoft Excel document.

Release of Information Reports (ROI)

Record Completion: Physician Orders (PO)

Record Completion: History and Physical (H & P)

Record Completion: Discharge Summary (DC Summary)

Report Completion: Operative Report (OP Report)

Incident Reports (IR)

Standards

Rubric (grading rubric)

Part 1: Data Calculations, Standards, and Compliance Notes

Turn the General Hospital status data given for the month of January into meaningful information by performing the following.

Point Values	General Criteria	Specific Data Calculation, Standards, and Compliance Rate Components
40 points 5 points for each type of calculation listed in the last column	Calculations necessary to find completion timeliness for the following on the next column	Release of information for all 20 requests (how many days it took to release the information requested) Physician orders (how many days it took every physician to sign each of his or her orders) History and physical dictation (how many days it took to dictate the H & P for each admission—subtract date of admission from the date of dictation) History and physical transcription (how many days it took to transcribe the H & P—subtract date of dictation from the date of transcription) Discharge summary dictation (how many days it took to dictate the DC for each admission—subtract date of discharge from the date of dictation) Discharge summary signature (how many days it took to sign the DC—subtract date of discharge from the date signed) Operative report dictation (how many days it took to dictate the OP report for each admission—subtract date of surgery from the date of dictation) 1. Operative report signature (how many days it took to sign the OP report—subtract date of surgery from the date signed)
15 points	Standards* for the following on the next column *Standards can be added in each worksheet applicable to the item being analyzed.	Completing ROI requests in the cases when records are on-site or off-site Signing orders Dictating a history and physical Signing a discharge summary 1. Dictating an operative report
30 points 5 points for each of the items listed in the last column	Compliance rates based on the standards identified for the following on the next column	ROI requests Physician orders Dictation of History and Physical Signing of Discharge Summary 1. Dictation of Operative Report
85 points total		Meets all of the components listed above

Part 2: Report

Write a two-page report formatted as a memo detailing area of noncompliance and at least three recommendations for improvement. The content of the report should be based on your prior calculations, highlights, and compliance notes from the prior analysis and other insight from analyzing the incident report, core measure, and meaningful use data. For full credit, the memo should include the following.

Point Value	Memo Components
10 points	Short introductory paragraph identifying the purpose and scope of the report
15 points	A paragraph highlighting areas that the hospital is in compliance with, including release of information, record documentation and completion, and incident reports. Paragraph should start with a summary sentence and then provide more details (including data) on each area the hospital is performing well.
25 points	A paragraph that addresses noncompliance, which should include the items below A summary of the areas of noncompliance. Any trends identified regarding a specific type of document (such as H & P or orders, certain physicians, core measures, etc.) Emphasis on two to three noncompliant items that are most serious or important in your opinion · Clear details on all noncompliant items by using tables, graphs, or bullet points
25 points	A paragraph that explains at least three recommendations for improvement, which need to apply knowledge gained about performance improvement activities, tools, techniques, and information systems or other technology, as well as processes and working with people. Recommendations for improvement should be specific to issues identified in the prior paragraph.
5 points	Grammar and formatting. Memo format is required.
5 points	Content of the memo is well organized. Information in the paragraphs is well connected and supported with data. For example, if you identify an area of non-compliance, it will be expected to provide a recommendation for improvement for that particular issue.
85 points	Meets all of the components listed above

Grading Rubric

Category	Points	%	Description
Deliverable: Part 1			Part 1: Data Calculations, Standards, and Compliance Notes
Completion Timeliness Calculated for the Hospital	40		Calculations necessary to find completion timeliness for each of the items listed above
Compliance Standards Identified	15		Standards for each item as listed above identified
Compliance Rates Calculated for the Hospital	30		Compliance rates calculated based on the standards identified for each item listed
Total points	85	50%
Deliverable: Part 2			Part 2: Report
Introduction	10		Short introductory paragraph identifying the purpose and scope of the report
Areas of Compliance	15		Paragraph highlighting areas of compliance as described above
Areas of Noncompliance	25		Paragraph addressing areas of noncompliance as described above
Recommendations	25		Minimum of three recommendations for improvement with justification
Grammar and Formatting	5		Memo format is to be followed and writing should be free of grammar errors
Organization and Cohesiveness	5		Content is well organized, connected, and supported by data.
Total points for Week 7	85	50%
Total	170	100	A quality project will meet or exceed all of the above requirements.

Tools and Resources

Access to Microsoft Word and Excel

Professional memo template to use for your report

All project-related documents available in Doc Sharing formatted as Word, Excel, or PDF files

Access to the Internet

Medicare Conditions of Participation requirements pertaining to documentation and clinical quality

Meaningful Use Requirements for Hospitals, Stage 1

HIPAA requirements in relation to release of information (ROI). A good resource to check out is http://www.hhs.gov/ocr/privacy/hipaa/understanding/special/healthit/eaccess.pdf

The Joint Commission requirements pertaining to documentation, core measures, and national patient safety goals

Best Practices

Remember that the goal is to practice good data management skills—understanding, calculations, comparisons, analysis, and evaluation.

Read detailed instructions for each item (more than once) until you gain clarity, and ask the instructor early if you have any questions.

Familiarize yourself with the various formats of data and use of formulas in Excel.

Practice good critical thinking skills.

Take clear and consistent notes as you are doing your calculations.

Use all the resources provided to you and do extra research to gain clarity on the compliance standards for all areas of review.

Practice good writing skills—clear and concise statements, well-organized details to support your findings, and justifications for your recommendations.

Submitting Course Project Deliverables

Submit your assignment to Dropbox for it section.

PLACE THE ORDER WITH US TODAY AND GET A PERFECT SCORE!!!