22 Oct LOGIN INFO

https://coursewareobjects.elsevier.com/objects/buck/internship2021/application/help/Orientation.pdf

1. Make an Excel Spreadsheet template to be utilized for the forthcoming Evolve Online Internship coding cases.

Reference the table below for the necessary Excel spreadsheet column headings and the cells showing an “X” that MUST have the associated cell reference formula.

There will be 20 cases for each of the assigned modules. Therefore, your table should have enough rows to accommodate 20 cases and the other required elements.

Be sure to title your spreadsheet after you have created your Excel spreadsheet template.

Save this file as Lastname_HIM2940Template to your computer

Upload this Excel spreadsheet template into this assignment dropbox by the due date.

NOTES

There will be 20 cases for each of the assigned modules. Therefore, your table should have enough rows to accommodate 20 cases and the other required elements.

It will be easiest for the formula if you first total each of these columns then for the next row have for each the average: CODING TIME min.    CORRECT # OF CODES # OF POSSIBLE CODES

Insert a formula to calculate the overall Accuracy Rate for each row based upon Correct Codes/# Possible Codes.

For each of the forthcoming coding modules, you will be evaluating your coding against that of the “Staff” coding with the comments being as succinct and descriptive as possible. This will become a mechanism to help you learn from your mistakes so make your comments understandable. For examples of acceptable and unacceptable comments see below.

ession DX. CPT Module Record Coding Correct # Possible Accuracy Date Report # Evaluation Evaluation Name Type Time #Codes Codes Rate Comments Comments X ants X Totals X X X X Average X X X X The above cells showing an "X" MUST have the associated cell reference formula. Note 1. There will be 20 cases for each of the assigned modules. Therefore, your table should have enough rows to ordings accommodate 20 cases and the other required elements. 2. It will be easiest for the formula if you first total each of these columns then for the next row have for each the average: CODING TIME min. CORRECT # OF CODES # OF POSSIBLE CODES 3. Insert a formula to calculate the overall Accuracy Rate for each row based upon Correct Codes/# Possible Codes. 4. For each of the forthcoming coding modules, you will be evaluating your coding against that of the "Staff" coding with the comments being as succinct and descriptive as possible. This will become a mechanism to help you learn from your mistakes so make your comments understandable. For examples of acceptable and unacceptable comments see below. ACCEPTABLE Dx Comments UNACCEPTABLE DX Comments did not assign code for chronic pain wrong code Correct codes: R10.11, R11.0, R79.89, 110. Failed to code hypertension, liver function test results yielded R94.5 did not code correctly instead, opted for R10.9 instead of R10.11 ACCEPTABLE CPT Comments UNACCEPTABLE CPT Comments 99221-57 correct code, failed to consider modifiers wrong code and inaccurate time assigned a lower level of ROS leading to lower E/M some of my codes were correct, missed a few code