Capstone Projects

Productivity Tracking

Program: Health Information Management Technology Bachelor's
Host Company: Ciox Health
Location: Wisconsin (remote)

My capstone project’s main goal was to create a way for management to easily keep track of and record employee productivity. The project began with me creating an interactive excel spreadsheet that could keep track of everyone’s productivity. I have created two spreadsheets, one for weekly recordings, and one for daily. Each team member has their own page of the spreadsheet, headed with their name, associate number, username (for the program that we use to create and send out orders), and productivity goal. I created the spreadsheet so that the UPH, or units per hour, field of the spreadsheet would turn green for good productivity output or red for bad productivity output so that it can be easily seen whether the employee has made their goal or needs improvement.