iSchool Capstone

2019

Project Logo

Performance Dashboards in Power BI

Fluke Global Materials Team developed an Azure data warehouse for improved data analysis, retention, addressing the lack of standardization between sites and data collection. The factories produce printed one-off reports and use handwritten forms to record data which are discarded at the end of the month. Our project is to create dashboards to ensure employees have access to the right information. Users can interact with visualizations, dig deeper into data using Data Analysis Expressions (DAX) and make informed business decisions from the insights.
Project Logo

Persistent Disease Self Management Program: An online application to help people manage their chronic medical condition

Thousands of Seattle residents live with at least one chronic medical condition. We’ve developed an online application to help users learn more about managing their chronic condition. Currently, the Aging and Disability Services Office provides users with a static page to help them manage their condition. With our application, users complete a quick survey regarding their condition, and our application provides users lifestyle information on what they are doing well or need to improve regarding their condition. Users can print a history of their responses to take to a doctor for more informed care to increase their Quality of Life.
Project Logo

Phone Application Behavior in Network Traffic

Network traffic classification has grown tremendously in the past few decades primarily due to affordable data storage and explosively growing computing prowess bringing machine learning to the forefront in handling optimization and capacity control. In this project, we aim to classify network traffic into different categories of mobile apps to analyze customer usage and optimize network traffic. Through iterative cycles of development, we have generated network traffic, analyzed, engineered and modeled it to obtain a final product that our client can scale and implement on real-world traffic.
Project Logo

Plentifull

Local companies have a difficult time finding a bulk amount of workers for one-time jobs. This lack of ability to distribute job information and match it to multiple qualified workers is an information distribution problem. By simplifying entry into our database, standardizing job types, and using a custom-built algorithm to match jobs with workers, we are able to provide large quantities of workers to those who need it. We now have a fully designed software that fits our client & contractors’ needs. We also have a prototype, business plan, and development team that will continue the creation of our software.
Project Logo

Preservation of the Warren G. Magnuson Audio/Visual Collection

Warren G. Magnuson served as United States Congressman for Washington state from 1937-1981. An alum of the University of Washington, Magnuson gifted his collection of audio/visual materials in 1981 to Special Collections. This project required inventorying, assessing, and creating access to the original audio/visual collection, which consists of 171 films and 324 audio items. Initial preservation actions in the 1980s created hard copy finding aids, masters and user copies totaling in 1,274 physical items. Our work created access to all through a digital finding aid and detailed research to assist in grant drafting for future digitization efforts.
Project Logo

Preserving Historic Media at the Seattle Art Museum

SAM’s Historic Media Collection is home to a rich body of archival material documenting key moments in the history of the museum, Seattle, King County, and the Pacific Northwest. The preservation of this collection is urgent as a majority of the content exists solely in unstable media formats. This capstone was a case study for a potential large-scale preservation initiative for this collection. 60 items about the Seattle Asian Art Museum, held in a variety of formats, were digitized to current preservation and access standards. Collection policies pertaining to rights management, collection scope, and workflow were also developed.
Project Logo

Prisons and Policing Public Records Management

Increasingly, public access to civil lawsuits against law enforcement agencies has been restricted from federal to local levels. Through the use of public record requests, the Human Rights Defense Center has collected over 8000 civil cases from seven different states. Their goal: to create a publicly accessible and empirically analyzable database of civil lawsuits against law enforcement agencies all across the country. Our team has built the underlying structure for this larger project, developing a Descriptive Metadata Schema, Controlled Vocabulary and Claim Type, Controlled Vocabulary and Dictionary for Document Type, and Standard Operating Procedures for court record ingest and documentation.
Project Logo

Privacy Pal: Empowering Digital Youth Through Microlearning

Today’s technical landscape is constantly changing; in many ways this increased innovation is beneficial. However, continuous innovation also means practices and technological norms are changing at a fast pace. The majority of today’s youth are growing up with technology firmly integrated into their lives. We see it as our duty to educate kids on these potentially dangerous norms and practices they are at exposed to on a daily basis. PrivacyPal serves as a modernized education tool to meet these goals: protecting and empowering kids to create an informed and healthy relationship with technology.
Project Logo

Produce Music

In the age of the solo bedroom producer, the art of music production has moved away from collaboration, towards competition. We believe that cultivating a community centered around growth can enable musicians to break through creative blocks while creating meaningful connections. Produce Music is a community platform by musicians for musicians, with the perfect tools for giving feedback, collaborating, and learning. The grand vision of Produce is to unite people through the power of music production, helping people intertwine their creative journeys while each developing their own, unique way to express their vision and emotions. Let's start creating together again.
Project Logo

Project Alive

In the age of ubiquitous information, museums are challenged with providing a unique and dynamic visitor experience. The Pacific Science Center, one of world’s leading science museums, is faced with a similar dilemma for its “Dinosaurs: Journey Through Time” exhibit. Project Alive employs Magic Leap One's spatial computing to simulate a mixed reality experience of the Mesozoic Era (252-66 million years ago) that is both immersive, and informative. Based on extensive user interviews and surveys, Project Alive incorporates elements of surprise and visual ecstasy within an interactive storyline that would truly bring the dinosaurs back to life.