These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Tuesday, December 13, 2011

Employee Performance Tracker

Executive Summary

My sister is a supervisor in a call center for a security company. Employees in her department are evaluated and coached weekly as an initiative to improve customer service. The evaluations are based on showing up to work each day, clocking in and out at proper times, number of calls put on hold, number of calls answered, graded reports for randomly selected calls, etc. Each Supervisor has a team of 20 employees. My sister’s biggest concern is that she can easily keep track of each employee’s improvement week to week so that she can be well aware of areas of concern and achievement for each person. Right now, my sister manually copies and pastes information for data downloaded from AVAYA, KRONOS, and CMS Applications into one summary worksheet.

I offered to build her a program that will take care of updating the master sheet each week once the necessary data is downloaded. The program analyzes different worksheets individually then summarizes specific data in the master sheet. Not only will updating the master sheet take only seconds compared to hours, the user can easily see where the areas of improvement and achievement are based on color coded cells corresponding to previously set standards.

No comments:

Post a Comment

Blog Archive