Team designed and set up a knowledge base and database of past legal advice into MicroSoft SharePoint, with appropriate indexing, organization and taxonomy. This way, Department of Licensing staff can more readily find, understand and follow legal advice, so the agency can become more protective of privacy and spend less time searching for records.

Misinformation has always been present, but social media has significantly increased its scope, spread, and reach in our world today. Working with the University of Washington's Center for an Informed Public (CIP), this project places the SIFT fact-checking strategy in the hands of Android mobile device users. The ReSIFT mobile application assists users in fact-checking articles and expedites the fact-checking process. ReSIFT reduces the amount of time needed to fact-check and educates users on information verification best practices to create a community of information skeptics and critical thinkers.

Smartsheet Inc. offers a resource planning solution, Resource Management by Smartsheet, and aims to provide intelligent recommendations for staffing work across their customer organizations. Our team, Avatar, focused on defining the best staffing suggestion tool for our sponsor with features that include criteria-based recommendation, staffing needs prediction, experience tracking, and overallocation notification. Our design leverages resourcing data to optimize the utilization of human capital, better predict resource demand for future projects, and reduce dependency on human intervention.

Every year thousands of students leave college looking for a job but don't have a sufficient resume to make them stand out. Additionally, tailoring their resumes to specific industries is a long, tedious process that gets boring and we found that students are more interested in improving their resumes if made into a faster and more fun process. ResumeQuest aims to address this issue by being a fun professional platform that accurately recommends top terms in job applications and industries which helps improve the quality of resumes so the user can be more confident when applying to their first jobs.

Cybersecurity is a fast-paced, ever changing field, with new threats around every corner. As a newcomer, learning complex topics such as network traffic analysis, forensic skills, and more presents a steep learning curve that pushes away prospective students. Combining data visualization with Capture The Flag style challenges, SecViz aims to reintroduce the fun in learning the fundamentals, and break through the barriers of entry for cybersecurity students. Students will gain the confidence and investigative thought patterns required to thrive in the world of cybersecurity, mastering the core skills that will remain relevant no matter how the field changes.

Shelp allows users to view information about shelters in one place. Users who are seeking shelters, are able to view shelter information, post and see comments about shelters. We scraped hundreds of shelter data from google maps and allowed shelter organizations to update shelter information on our site once they verify their identity. For shelter administrators, they are able to claim their shelters in our application and modify shelter information. We believe our solution can help shelter users get informed when finding a shelter and for shelter owners to get the most up-to-date information to build community.

Skillet Analytics is a new way for Skillet Restaurant Group to analyze business KPIs and track progress among the restaurants. Small businesses lack access to technology to utilize data-driven decision-making. Our team sought to make the powerful tool of data available to Skillet so that they can measure and improve restaurant performance. This project introduces live connection between a database server and KPI dashboard to make retrieving and accessing data seamlessly for employees who work in operations and beyond. The project is implemented using data analysis, database creation, and population and data visualization.

Microsoft Azure is cloud-native and runs across multiple regions, making tracking its metadata complex and challenging. The current dashboard involves ad-hoc SQL data queries which is inefficient and inaccessible to non-technical users. Additionally, the dashboard doesn’t provide useful visualizations for analysis. To address these issues, we developed the Software Deployment Tracker which is designed for all team members, from project managers to engineers. Our solution empowers the Microsoft Azure team to effectively monitor global deployments by querying and visualizing deployment data instantly without writing any code.

Spotty (Spot a Potty) is a mobile-first web application to help people on the go find public restrooms that fit their needs. Lack of bathroom access is a serious humanitarian and public health issue; good bathrooms are difficult to find, particularly for people who have to be on the move frequently. Spotty addresses this by allowing users to find nearby locations as well as view features and reviews in advance, helping them save time and have better peace of mind.

Saint Mary Catholic Church in Corvallis, Oregon, was founded in 1861. Its parish archive opened in 1981. Unfortunately, the archives are tucked in a locked room in the parish hall, preventing newcomers from learning the history of the parish. A website was created to solve this information problem: attached to the main parish website, this site allows parishioners, community members, and those interested in church history to connect with these artifacts. This online resource serves as a door-opener: delivering a portrait of the 160-year history of the parish.