27 Oct Create coding productivity and accuracy logs.

Objective After completing this assignment, students will be able to create coding productivity and accuracy logs. Instructions 1. Create an Excel Spreadsheet template to be utilized for the forthcoming Evolve Online Internship coding cases. 2. 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. 3. 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. 4. Be sure to title your spreadsheet after you have created your Excel spreadsheet template. 5. Save this file as Lastname_HIM2940Template to your computer 6. Upload this Excel spreadsheet template into this assignment dropbox by the due date. Column Headings Dx. CPT Module Record Correct # Possible Accuracy Date Report # Coding Evaluation Evaluation Name Type Time #Codes Codes Rate Comments Comments X 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 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.