With thousands of employees, documenting job performance and determining appropriate compensation for Cornell's staff is a complex task. At Cornell University's College of Engineering, currently ranked by U. S. News and World Report as one of the top ten graduate engineering programs in the nation, Programmer Analyst Senior Paul Davis develops solutions to meet that challenge. "I gather a lot of data for our faculty data summary," explains Paul, "for the dean and the department chairs to use in quantitatively measuring faculty effort each semester. This information is used in helping directors, chairs, and the dean in determining performance levels."
The information is also important in the classroom itself — where documenting the number of course hours taught helps in allocating the number of teaching assistants assigned to each class.
There was a time when this information shuttled from office to office and desk to desk in clumsy emailed spreadsheets — and not only was this an inefficient method of conveying information, it could also leave sensitive data open to unauthorized access. Clearly, there was room for major improvement.