Students who pursue a sponsored project work in groups to complete a consulting project for a small or large business or nonprofit organization. Students conduct research and analysis and work to implement findings in order to improve their sponsor’s information systems practices. Some of our recent sponsors include Larry H. Miller Auto Group, Utah Transit Authority (UTA), Workers Compensation Fund, TwitchTV, Extra Space Storage, and various departments at the University of Utah.
Ace Intermountain Recycling Sample Project
Project Summary: The objective was to automate a monthly Excel scorecard used by staff and executives at Ace Intermountain Recycling. The project team delivered a scorecard that was easily accessible via a web browser displaying the information and metrics that were originally calculated manually. The new scorecard can be accessed at any time, is continuously updated, and easy for management to maintain.
Sponsoring Company Background: Ace Intermountain Recycling Center (AIRC) operates transfer stations for recycled materials, green waste, and other garbage in the Salt Lake Valley and surrounding areas. The AIRC scorecard built by this project accumulates different metrics, allowing management to easily view revenue, costs, and other productivity trends.
Project Timeline: Sponsored capstone projects span two semesters. The first semester is used for project selection and planning. The project is executed in the next semester (about 30 weeks total).
Project Planning and Execution: The main technologies used were SQL, Microsoft Power BI, Python, and REST APIs. The first phase of the project execution was dedicated to creating data connections between the server and each data source; the next phase was cleaning and transforming the raw data into usable datasets with Power BI. SharePoint was utilized to present the dashboard with all its metrics in one central location.
“For anyone who’s skeptical about doing a project over a certification, I would strongly recommend the project. It offers so much experience, which is primarily what employers are looking for. I have certifications for other things, but I always get asked in interviews about the experience. Many times, I’m in an interview and they say, ‘Tell us about a challenge you experienced’ and this capstone project is always an option for one. There are so many times when, in answer to an interview question, I can think back to my capstone project.”
– Andy Adamson, project manager
“[The sponsored capstone project] benefitted my technical skills a lot. We never really worked with APIs throughout my other classes, and in this project we did work with a couple of APIs directly. We utilized Python in a real-world situation, and then we also utilized Microsoft’s Power BI platform quite extensively. I’ve been utilizing all three of those technologies in my current project at work. I gained real-world technical skills with real-world situations and it’s been benefitting my work projects.”
– Connor Bryner, team member
“You always learn new things and get put in environments that you are completely unfamiliar with. There’s just a lot of learning to be done in that kind of space and it looks good on the resume to have a real project you worked on and completed. … [I chose this project because] it seemed like a small company that I could really do a lot for, which I think also makes it fun. I felt like I could make a big difference; they would actually use what I did if I did it well.”
– Jared Kujawa, team member