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, April 15, 2014

Employee Essentials Training

I work for the Human Resources department at the City of Provo. All full-time and part-time regular employees with the City are required to complete 10 online "Employee Essentials" courses once every three years. These include courses like Workplace Safety, Sexual Harassment, Diversity Awareness etc…When I was first hired, part of my job was to download the record of all courses completed weekly and check to make sure people who were taking the courses were spending the appropriate time on them and not just clicking through to the end and passing the quiz. Once I weeded out the "cheaters"  I would upload the record to our HRIS. At that point, we really didn't have any good way of checking training completion for employees except to look up each employee's record individually.

My project was to automate this process. I now have procedures to run a check on all courses to see if anyone was "cheating", save the file to the correct directory, create rejection email notifications for employees who completed the courses too quickly, and create a report that shows which employees in the city are not current on their training and which courses each one still needs to take. Thanks VBA!

Demo Project File
(Some of my Macros deal with my Outlook account and directories on the City's network, so those won't work without the correct connections. Others will)


Marshall Merrill

No comments:

Post a Comment

Blog Archive