iSchool Capstone

2023

Project Logo

NewImpact: Streamlining Access to Data for Tri-Sector Innovation

NewImpact is a non-profit that provides resources for tri-sector innovation. Given the amount of organizations in existence it can be difficult for innovators to know where to start looking for information fitting their needs. To address this, we partnered with our sponsor to improve and redesign a wiki tool that serves as a free online directory of datasets, organizations and resources. Our platform allows users to search and filter for relevant information, explore geo-mapped resources, and export and share their findings. We hope this tool will provide opportunities for people to explore and solve real world problems!
Project Logo

NOVA - An AI Powered NIST CSF Education And Management Tool

Small to medium-sized companies face a significant challenge, as they are disproportionately targeted for cybersecurity threats and data breaches. To address this issue, we have developed Nova, an easy-to-use, effective, and affordable chatbot. The impact of Nova is twofold: it empowers clients to navigate and implement the NIST framework, address their cybersecurity needs, and educate themselves through tailored guidance.
Project Logo

Open Data Portal Metric Performance Dashboard

Open Data Portal Metric Performance Dashboard aims to enhance the transparency and accessibility of Washington State's open data program, data.wa.gov, through the design and implementation of a performance indicator dashboard. This project involves building robust data pipelines for automatic data updates, defining and calculating precise metrics, and visualizing these metrics using Tyler's built-in tool. Furthermore, a GitHub repository will be established for efficient code maintenance and dashboard documentation. The outcome will be a comprehensive, user-friendly platform showcasing the performance and value of Data.Wa's public data assets.
Project Logo

Pallet Shelter: Collecting Data To Enhance Village Models Aimed At Addressing Homelessness

Pallet Shelter addresses unsheltered homelessness by constructing transitional shelter villages. To gather data on their impact, we developed a solution for collecting anonymized information from village residents. This measures the effectiveness of non-congregate village models in addressing residents' health, well-being, and homelessness journey. Google Forms surveys capture resident and service partner experiences, while a staff dashboard enables data analysis. Our solution provides insights into non-congregate villages' effectiveness by gathering data from residents and staff, enhancing our understanding. A project proposal was created to ensure Pallet is on the right track to obtaining constant data they want to enhance our solution.
Project Logo

Project Anemone

Starfish Space worked with our team to redesign their data platform. Starfish Space engineers and analysts interact with hundreds of files with many different data visualizations every day without a modern, easy-to-use platform to organize and navigate their data. Anemone is an updated data visualization platform enabling Starfish Space employees to read and analyze satellite mission data faster to support future satellite missions with more efficiency and customizability.
Project Logo

Real-time Speech Emotion Detection

This project focuses on the development of conversational analytics and AI solutions for Seasalt.ai, aimed at analyzing real-world speech data for insights. Multiple Machine Learning models were implemented, with Convolutional Neural Networks (CNN) demonstrating the highest accuracy improvement of approximately 67%. The CNN model effectively identifies emotions from audio data clips, enhancing conversational analytics within Seasalt.ai's product SeaMeet. Extensive experiments and evaluations have been conducted to validate the effectiveness of the CNN-based approach, showcasing its potential for real-time applications such as affective computing, virtual assistants, and emotion-aware human-computer interaction.
Project Logo

See-weed: Detecting Storefront Advertising of Age-restricted Retailers

The youth across King County are rampantly being exposed to age-restricted products like Marijuana, Tobacco, Vapes etc. To address the issue, we partnered with King County and built a computer vision model that analyzes the storefront images of age-restricted retailers and categorizes them into different groups based on advertisement aggressiveness or intensity. The advertisement intensity groups are classified as ‘High’, ‘Medium’, and ‘Low’. The results will help recommend suitable actions to create a safer advertising space. This will also enable various regulatory bodies to create awareness among the youth and bring necessary policy reforms to prevent unhealthy advertising.
Project Logo

US Election Dashboards

Our goal was to consolidate metrics across several US election-related projects into centralized dashboards for the Lafayette Group’s Election Security & Resilience team. They maintain several important datasheets related to their engagements, products, and other aspects of election administration in the US. It was a challenge for them to find information quickly, create static visualizations manually, and make informed decisions with stakeholders. To address this, our team built interactive, user-friendly PowerBI dashboards that drastically reduce their task times (from 30 minutes to 30 seconds!), enabling them to easily derive insights for data-driven decisions, and helping them communicate effectively with stakeholders.
Project Logo

UW Global Impact Tracker for Office of Global Affairs

While the UW Office of Global Affairs (OGA) relies on the Global Publications Dashboard to showcase UW faculty’s scholarship and worldwide collaborations, its user retention has decreased since the data source became outdated in 2019. Some users couldn’t find the desired information, such as statistics regarding the department’s global presence and international co-authorship. Additionally, some faculties’ work has not been acknowledged. To address this issue, we retrieved 2 million rows of up-to-date data, improved the name-matching process, added indexing to increase database performance, and developed a networking tool to empower UW faculties to enhance global engagement and facilitate research collaboration.
Project Logo

YODHA: Breaking Barriers by Improving Access to Assistive Technology

“Yodha, the accessibility bot”, addresses the problem of inequitable access to information about assistive technology (AT) schemes and devices for people with disabilities in Low and Middle income countries, particularly in India. Yodha bridges the information gap for over 63 million people with disabilities by providing personalized, reliable, information about government schemes and available ATs in a conversational manner in local languages and on multiple platforms. Yodha helps PwDs by reducing the financial burden and time required to acquire necessary devices, increasing PwDs independence and quality of life, ultimately contributing to creating a more inclusive society.