UVU Athletics: Compliance Spreadsheet

The Utah Valley University athletic department strives to remain in compliance with university and NCAA standards. This includes large amounts of academic information that must be carefully tracked and managed. The department has asked that I create a spreadsheet (available on the UVU athletics network) that will help to accomplish the following:

• Reduce the amount of duplicated work by automatically pulling updated rosters from UVU’s database
• Produce student-athlete/team summary reports that are simple to understand
• Reduce the amount of information that must be entered by hand (to save time and reduce user error)

The above objectives are met by the Excel workbook that does the following:

• Uses VBA to sort and display information by team
• Uses VBA and user forms to run reports, create summary boxes, and easily edit information
• Uses formulas and conditional formatting to give accurate information regarding eligibility
• Pulls the roster data directly from the UVU athletics website (www.wolverinegreen.com) onto the spreadsheet for the most up to date information

Files:

• Click for full project write up or follow this URL
• http://files.gove.net/shares/files/11w/jenkins5/Anthony_Jenkins_-_UVU_Final_Project.pdf
• The spreadsheet file contains sensitive academic information of UVU student-athletes and will not be made public (as requested by UVU). A copy will be provided to the instructor.