Seattle nonprofit Scarecrow Video is world’s largest publicly available audiovisual archive, with over 145,000 titles spanning 125+ years. Many of these titles are only available on VHS, a medium that is highly susceptible to physical degradation. With funding from 4Culture and in collaboration with Moving Image Preservation of Puget Sound, my project resulted in the digital reformatting of 40 rare VHS tapes, with special focus on works by historically marginalized peoples and pieces spotlighting cultural heritage in Seattle. The digital preservation of these works will aid in their indefinite accessibility to researchers and film fans around the world.

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.

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.

By 2025, global cloud computing energy consumption is projected to reach 14% of the world's total electricity demand, equivalent to the carbon footprint of the aviation industry. This alarming statistic emphasizes the urgent need for immediate action toward sustainable and equitable tech practices. Our website, made possible by the support of the UW Tech Policy Lab, aims to empower individuals to make informed decisions about their tech usage. We provide comprehensive resources to explore the social and environmental effects of cloud-based technologies and foster greater awareness of their implications. Together, we can make a positive difference in our digital era.

Project Completed for University of Washington Housing and Food Services, Communications and Marketing Department. The Goal of this project was to find a solution to the issue of disorganized and decentralized information, which was causing significant delays and inconsistencies. This was accomplished through the Identification of a storage system which would better fit ConMar's needs as well as the creation of a taxonomy with which to organize the information stored.

The Instructional Materials Center (IMC) is a collection of resources designed to assist pre-service educators as they develop into effective teachers who generate positive change for schools. As a result of competing priorities through a global pandemic, the IMC has been underused from a lack of awareness of its existence. This project shares the creation of a marketing plan through stakeholder interviews and research of traditional marketing strategies critically applied to academic settings. The plan will guide staff of the IMC in communicating the value of the center through authentic storytelling while prioritizing success of organizational goals, sustainability, and longevity.

As a group, we (Erin Shapland and Zach Wagman) worked with Washington Center for the Book to design a zine workshop. We sought to address a lack of knowledge about zine history among the general public. We also wanted to teach members of the public the basic skills involved in creating zines for oneself, with the hope of fostering a sense of freedom and artistic whimsy in our attendees! We recorded a workshop for all ages that can (and likely will) be used for programs in the future, which will ideally inspire more people to create and learn about zines.

Through a carefully designed blend of hardware/software engineering and ethical hacking, Weapon of Mass Disconnection (WMD) is able to deliver an engaging and fruitful learning experience on cybersecurity and systems programming, two fields that bear utmost importance in today's connected and digital information world. WMD is built with an audience of diverse age and interest in mind and tailors to individual learners and classrooms alike. WMD furthers cybersecurity outreach and offers approachable embedded engineering education to create knowledge that will increase cybersecurity awareness and inspire many for their careers and passion in electrical, computer engineering or information sciences.

My project consisted of a deep dive into the legacy VHS collection at Scarecrow Video, assessing items on the basis of rights ownership & management and physical rarity. Over the course of my project I narrowed my focus to look at queer porn and erotica, as I felt they were a particularly vulnerable part of an already vulnerable collection consisting of an ephemeral and obsolete analog medium. My goal was to provide Scarecrow information which would help them maintain their collection in the future.

“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.