iSchool Capstone

2019

Project Logo

Gates Foundation: Grand Challenges Data Warehouse

The Grand Challenges Program is a global initiative to solve health and development problems for those most in need. It has been responsible for over 2800 grants in over 100 countries. One of the program’s largest funders, the Bill and Melinda Gates Foundation, has been dispersing grants and collecting data throughout the years, but this data currently exists across many disparate sources, in various formats residing on different platforms. This data warehouse was created to synthesize all the data into a single stream that can be easily queried and analyzed to identify true success metrics.
Project Logo

GBD Collaborator Portal: Resources and information for members of IHME network

IHME administrators have been manually managing a network of over 3,400+ collaborators across the globe. Our newly designed portal integrated with Salesforce will provide IHME collaborators with the capability to view and edit personal information at their convenience. This will significantly reduce the current workload for the IHME network admins, allowing them to allocate resources for more important tasks, as well as, all the network to scale as more collaborators join. Also provided are interactive visualizations of the collaborators’ data to provide a deeper insight of the collaborators’ distribution throughout the world.
Project Logo

Getting the DAM Assets Together

The Seattle Art Museum (SAM) recently implemented their first digital asset management (DAM) solution. They originally sought to implement a system that would improve the administration of their digital media across all departments. Our work realized the limitations of the purchased software as well as the DAM’s unidentified scope and purpose which would not support the various use cases across the institution’s departments. This presented an opportunity to take the lessons learned and evolve them into a cohesive assessment. We further developed our recommendations into an iterative model that integrates SAM’s needs and organizational culture for their future DAM success.
Project Logo

Gimme Air-Shelter: Wildfire Relief and the Public Library

The West Coast has seen an increase in poor air quality due to wildfires. Witnessing first-hand the impact that smoke had on the Spokane community, I partnered with the Spokane Public Library to identify what the library could do to prepare for these events in the future. The result of this research and exploration is an ideas and resources guide that public libraries can use to help propel the conversation on how to help communities during episodes of poor air quality.
Project Logo

Glimpse

Social media is addictive. Social media has the power to connect people all over the world. However, Studies have shown that social media impacts people’s lives negatively. Our project focused on creating a new social media platform that’s purpose is to prove that social media can be effective, meaningful, and impact mental health positively. Our platform on the idea of only being to use it for one minute a day, believing that by cutting down the viewing time, we can decrease addiction while also motivating users to post interesting content.
Project Logo

Health Equity of Home Care Aides: Investigating Chronic Disease Prevalence

Home Care Aides are the future of long-term care in the USA, allowing older adults and people with disabilities to live in the community and age in place. Unfortunately, a significant portion of the HCA workforce suffers from high rates of chronic diseases. Our team has partnered with SEIU 775 Benefits Group to understand and communicate the prevalence of chronic diseases in the HCA workforce through statistical analysis and evaluation. By utilizing medical insurance claims data, our team has generated an interactive report that provides information on a vulnerable group of healthcare providers in order to support a healthy workforce.
Project Logo

Historical Connections: Processing Historical Visual Materials for a Modern Audience at UW Special Collections

My aim for my Capstone was to make some of the previously unavailable historical visual materials housed in UW's Special Collections accessible for researchers by providing organized, digitized, and searchable collections. To do this, I identified photograph subject matter, researched historical context and significance, inventoried collections, determined appropriate organizational schemes, created indexes, digitizing prints and negatives, preserved materials by moving them to appropriate archival housing, created finding aids using the XMetaL Author program, and linked XML entries to corresponding digital scans. By the project's end I had completed two collections, and determined organizational systems and background information for two more.
Project Logo

How Can a Dollar Generate Data?

We reimagined how a dollar can generate data. The Food Access Partnership on Vashon Island distributes cash to the community to minimize costs of locally grown food, but the paper currency they create and distribute suffers from low redemption rates. Improving this system, our solution provides real time data for partnering nonprofits and farmers while preserving the familiar paper “Farm Buck.” Now, our stakeholders can track Farm Bucks through the system and encourage users to redeem them at farmer’s markets and farm stands. Placing data in the hands of organizers, we’re helping Vashon Islanders address food equity in their community.
Project Logo

IAC Homelessness Data Model

The City of Seattle Human Services Department (HSD) contracts with community organizations to provide housing & health services to people experiencing homelessness. Previously, HSD staff pieced together program & contract data from many sources. This is a time-consuming and frustrating process, but this information is critical for informing policy and highly visible through media outreach. To meet their needs, we produced a data warehouse and reporting system that captures institutional knowledge, automates data ingest, and makes data analysis more streamlined and trustworthy. We hope to help HSD tell a more complete story about Seattle’s service to its most vulnerable populations.
Project Logo

Inclusive Information Mapping for the Great Outdoors

As Washington Trails Association’s (WTA) hiking guides and user-submitted trip reports are mostly created by those who have been a part of the outdoor community for a long time, there is often a natural and unconscious bias imbedded within the information resource. This project helped WTA gain insights on how they can effectively design a content standard for their user-generated Trip Reports so that in turn, the system can be more inclusive, empowering, collaborative, and accessible. Some proposed solutions were to incorporate enhanced search capabilities of trip reports, trip reporter identifiers, and a revised trip reporting framework for quick reporting.