coding_audit_worksheet.docx

Coding Audit

The former Coding Manager completed the recent audit but she was not able to complete any of the reports prior to her departure. She has left you with the following audit information on a piece of scratch paper:

Coder 1 88.6% Coder 2 96% Coder 3 98.9% Coder 4 92% Coder 5 89.9% Coder 6 94.6% Coder 7 81% Coder 8 91%

You don't know the organization's coding accuracy policy by heart yet so you set out to locate it in the policy and procedure manual. You found and downloaded a Coding Quality Policy document.

A. Based on the information contained in the Coding Quality Policy document, what other past information should you collect so that you can be certain that you are complying with the policy?

A. Using Microsoft Excel, enter the audit summary information that was provided for you (in Part 1 above) into a spreadsheet along with the information that you found in the files (below).

CODER

QUARTER 1

QUARTER 2

QUARTER 3

1

82%

86%

94%

2

96.8%

98%

95.2%

3

92%

97%

96.9%

4

92%

94%

94%

5

87%

91%

89%

6

94.9%

95.2%

94.9%

7

NA

NA

NA

8

97.2%

94%

96%

B. Once you have entered the information into Excel, create a bar chart showing the 4 quarter history of audit results for each of the coders. Copy the bar chart and paste it into the space below.

Continuing from above...

C:\Documents and Settings\christopher.brown\Desktop\My_Courses\Icon_Tags\icons\sb_important.jpg

Do not do this until you have completed Parts 1 and 2 above.

You have collected information from each of the coders' files and prepared a table to remind you of their employment status.

CODER

LENGTH OF EMPLOYMENT

NOTES

1

1 year

 

2

7 years

 

3

4 years

 

4

11 years

 

5

1 year

2ND Probation

6

2 years

 

7

42 days

Address weak areas

8

2 years

Sudden drop

A. Using the Coding Quality Policy provided with this assignment, make the following decisions based on the data that you have:

1. Which coders are concerns and why? List each one that you are concerned with and be specific on what part of the policy is in question.

2. Which coder(s) do you need to create an education plan for?

3. Do any coders need to be placed on probation?

4. Do any coders need to be considered for termination?

5. Are any coders in their probationary period in jeopardy of not meeting the probationary expectations?