Team Cherry Balls worked alongside Arena Sports to modernize and migrate their data pipeline to a new system. Previously, their data services utilized a less-efficient platform that led to inaccurate reports and laborious report building. The new system utilizes Fivetran, a cloud based data movement service, and connects to Microsoft’s Power BI, allowing for more consistent synchronizations and easier access to data. With our new workflow, we can now provide easier and more accurate dashboards to help various stakeholders of the firm gauge their operational health.

Our project addresses the issue where many women, particularly young girls, lack sufficient information about their bodies and health, along with the necessary tools to maintain their well-being. Adding to this challenge, there is widespread negative stigma and harmful stereotypes surrounding female reproductive health, significantly impacting girls and women. The problem is particularly pronounced among women of marginalized identities whose cultures have a stigma around female reproductive health, and women with limited access to information. Our website, Blooming, will provide our target users with comprehensive knowledge about their bodies, health, and well-being.

This project addresses the need for discoverable and accessible archival materials about Black histories at Occidental College. In the last decade, Oxy students increasingly utilize archival study and the digital humanities to advance their research and progress student movements. The College’s archive is rich with materials, but access is limited due to slow processes towards digitization, lack of finding guides, and loss of digital exhibits. Using Collection Builder, this project builds a framework for a sustainable, publicly accessible digital archive that benefits its target audience and presents a replicable model for other affinity organizations and community archives.

Camano Island has a lot of incredible history and a lot of people who are interested in it but, until recently, had nowhere to connect the two. The Camano City Schoolhouse Archive solves an information need for historians and genealogists on the island, as well as local people who have historic materials they want to donate. We’ve been able to establish the archive, build procedures, and train volunteers so archival work can continue for decades. Now, our space is open for any researcher, and our digital collection is growing every week - which connects people with Camano’s varied history.

This capstone project wanted to determine characteristics of materials shared internationally by libraries’ interlibrary loan (ILL) departments, seeking to determine drivers behind such resource sharing and whether any interesting or useful patterns in the practice could be identified. By interviewing institutions who participate in international ILL, we found that the experience, and number of resources shared by the participants varied greatly and were the result of differing circumstances. It was determined that participants faced similar challenges the world over, but that the responsibility ILL teams feel to their users to provide the best access to resources is universal.

ConnectOne is an application that helps first-generation iSchool students overcome their lack of information by giving them all they need to know about their school environment. ConnectOne grants students access to necessary school information and upcoming events as well as providing them a place to organize their hectic college schedules. Our project yielded significant results, with students reporting that ConnectOne not only increases their confidence but also their academic success. By bridging the gap between information and accessibility, ConnectOne makes sure that first-generation students feel supported throughout their educational paths starting from day one.

Country Bookshelf, Montana’s largest independent bookstore, is located in the growing metropolis of Bozeman and for over 65 years has been a literary destination for locals and travelers alike. Country Bookshelf engages with its community in various ways, including book fairs with local schools. Before this project, Country Bookshelf had little in terms of concrete procedures and tools that could be referenced when hosting a book fair. The creation of a book fair handbook aims to build upon the successful book fair program that Country Bookshelf has been able to implement and guarantee continued opportunities for students, librarians, and booksellers.

The global issue of hunger affects 309 million people, including 45 million children under 5, raising awareness is paramount. Our project introduces a custom island within Fortnite, where players can engage in fishing, farming, and exploring, mirroring real-world challenges. Through immersive gameplay, players can learn and think about the complexities of hunger exacerbated by factors like shortage of resources and water scarcity. The game will be incorporated into the school curriculum to educate students about Zero Hunger and will also be accessible to the public. Our project fosters empathy, empowering individuals to take tangible actions in the real world.

Stroke can have severe impacts on individuals, including paralysis and speech impairments. To address this, many patients meet with various therapists and complete assigned exercises to improve their mobility and cognitive abilities. However, this is found to be inefficient and unmotivating for stroke patients. To address this, we’ve created inStroketor, a stroke rehabilitation website that provides an individualized and clear rehabilitation progress plan, the ability to walk through rehabilitation exercises step-by-step, and resources to connect with other stroke patients local to you. Through effortless progress monitoring, inStroketor empowers patients and improves their recovery journey in a fun, adoptable manner!

The Site Audit Tool revolutionizes the warehouse audit process for design engineers at Amazon's Last Mile team. Developed by Team Phoenix, this AWS-based web interface addresses the shortcomings of traditional spreadsheet audits by enhancing efficiency, improving the tracking of critical issues, and fostering better collaboration among auditors. As Amazon expands its network of delivery stations, engineers must ensure each site aligns with the 'Digital Twin' before launching. This tool digitizes the process, integrating features like real-time data synchronization, dynamic user interfaces, and robust backend support. It empowers engineers to swiftly identify and resolve discrepancies, ultimately boosting operational accuracy and efficiency.