Knowledge of database querying and data exploration and mining techniques to facilitate information retrieval

/in /by

·  W7A1 AUDITOR REVIEW FORM.xlsx (15.107 KB)

Assignment Objectives:

1. Meet CAHIIM Curriculum requirement for Associate Degree

a. Domain III. Informatics, Analytics and Data Use

b. Subdomain III.C. Analytics and Decision Support

c. Section 1. Explain analytics and decision support

d. Competencies Analytics and decision support o Data visualization, dashboard, data capture tools and technologies

2. Meet CAHIIM Curriculum requirement for Associate Degree

a. Domain VI. Leadership

b. Subdomain VI.F. Strategic and Organizational Management

c. Section 5. Utilize enterprise-wide information assets in support of organizational strategies and objectives

d. Competencies Data/information visualization and presentation

3. Meet CAHIIM Curriculum requirement for Bachelor Degree

a. Domain III. Informatics, Analytics and Data Use

b. Subdomain  III.C. Analytics and Decision Support

c. Section 5. Apply knowledge of database querying and data  exploration and mining techniques to facilitate information retrieval

d. Competencies: Data presentation standards and tools

4. Meet CAHIIM Curriculum requirement for Bachelor Degree

a. Domain III. Informatics, Analytics and Data Use

b. Subdomain III.D. Health Care Statistics

c. Section 2. Analyze statistical data for decision making

d. Competencies: Data reporting and presentations techniques

Assignment Purpose:

Presentation of audit findings

Assignment Description:

Information:

DRG 193: Simple Pneumonia with MCC (Wt. 1.4261)

            DRG 194: Simple Pneumonia with CC (Wt. 0.9695)

            DRG 195: Simple Pneumonia without CC/MCC (Wt. 0.7111)

            Hospital Base Rate = $1,234.56

Step One:  Review the attached audit findings for five coders

Step Two:  Determine the following

1. Overall accuracy rate for all coders

2. Each Coder’s overall accuracy rate

3. Overall DRG (all DRG’s) assignment accuracy rate

4. Each Coder’s DRG (all DRG’s) assignment accuracy rate

5. Overall accuracy of each DRG assignment (193, 194, and 195)

6. Each Coder’s overall accuracy for each DRG assignment (193, 194, and 195)

7. Pre-audit CMI

8. Post-audit CMI

Step Three:  You have been asked to present your audit findings to the CEO. Create a Power Point Presentation (10 slides) which will demonstrate your audit findings. Be sure to use graphs, charts, diagrams, etc. Use the notes section of the power point. Be prepared to answer any of the questions that the CEO may ask about the data. Show overall and individual results. Identify overall and individual strengths and weaknesses. This should be a voice-over presentation.

Step Four:  Submit your presentation for grading

Your Power Point should:

1. Be 10 slides in length

2. Contain Voice-Over

3. Cover each point (1-8) above

4. Be audience ready

5. Appropriate use of color, font and graphics

6. Appropriate use of Notes section with majority of information in the Notes and just highlights in the slides.