Exercise 63 Associate Productivity Excel Report Analysis CIOX e-SmartLog will be sunset from AHIMA VLab on June 1, 2020. Instructions: • Login to eSmartlog • Select Reports • Select Associate Productivity Report • Run an Associate productivity report for calendar year 2019 • Answer the following Questions: Question 1. Which associate entered the most requests in 2019?
A. UIC001 B. KFT001 C. NOC001 D. NEI001 Question 2. To sort the Associate Names alphabetically, click on which heading? A. Associate B. Associate Number C. Associate Name D. Number Question 3: Does the eSmartlog Associate Report total the number of ALL requests received in 2019? A. No B. Yes Question 4: Associate Productivity is based on: A. Requests completed B. Request pages processed C. Request turnaround time D. Requests entered in eSmartlog Question 5: To run additional analysis on the data in the Associate Productivity Report: A. Use eSmartlog Advanced Functions B. Open it into EXCEL C. Highlight the data column to be analyzed in the Associate Productivity Report D. Open the report into Tableau • At the bottom of the eSmartlog Associate Productivity Report for 2019, select the OPEN INTO EXCEL button. • Save the excel file so that you can find it later (your instructor may provide instructions to submit) • Answer the following Question: Question 6: The total number of requests entered in 2019 by all associates was:
A. 3684 B. 7118 C. 3719
Copyright ©2020 by the American Health Information Management Association. All rights reserved.
Powered by FlippingBook