In order to generate more information from historical weather and environmental records, the National Oceanographic and Atmospheric Administration (NOAA) created the Arctic Rediscovery Project. One initiative of the Arctic Rediscovery Project is the crowdsourcing transcribing website, Old Weather. Old Weather facilitates the digitization and transcription of historical images, logbooks, and documents by dedicated volunteers and students. As a part of their collection, NOAA has thousands of images featuring personnel from the Geodetic Survey, academic institutions, and crew from old research vessels. These images were digitized, but until now the public had no access to the collection. By constructing a searchable and browse-able database and designing a functioning website to display these images, our capstone project creates an access point for NOAA researchers, historians, relatives, and Old Weather volunteers.

Expeditors® is a global logistics company with over 13,000 employees in a worldwide network of over 250 locations across six continents. Much of Expeditors business is based on the usage of event code, which enable Expeditors and customers to track freight/shipments and related documents. Our team worked closely with Expeditors Global Data Strategy team to organize the confusion around event codes and identify opportunities to improve the business. Our capstone team conducted a sequence analysis on different shipment levels. By answering the question ‘Where is my freight,’ we created rules to identify the shipment errors from both business intelligence and logical perspectives. In order to organize the event code metadata, we categorized all the event code by logical grouping and product/service perspectives. Then we delved further into the integrity of the core events, and conducted data quality analysis. The whole analysis process enables Expeditors to make better decisions as a company on how they want to manage their processes and to provide better service to customers.

Today’s Extract, Load and Transform (ETL) tools focus on graphical design and representation of the process, leaving the required mapping and transformation identification to be done manually. This is extremely difficult when faced with multiple, varied data sources. EZ-ETL uses ontology-driven mechanisms to translate data from multiple sources into concepts specific to the customer knowledge domain. OKDoctor uses the EZ-ETL frame work to evaluate medical research in terms of validity and relevance, providing the Validity Potential Rating as a novel way to support practitioners of Evidence Based Medicine. These evaluation techniques are equally applicable to other industry verticals such as finance, national security & intelligence, and legal.

Teaching video editing is a time consuming task that requires much one on one time between a teacher and student. As class time and office hours are limited, there is a ceiling on how much instruction a student can receive during a course. Furthermore, with only a finished product to evaluate, it is difficult for teachers to suggest improvements to cutting room processes used by students. To increase visibility into students’ processes and allow for a more iterative feedback loop, an online collaborative workspace has been created. In this workspace, visibility into processes was added through real-time collaboration and revision history. Coupling these features with an ability to give and request targeted feedback at any point in the process allows students increased access to a teacher’s wealth of knowledge.

Alaska Airlines has a large pool of 3300 flight attendants. To improve the work efficiency and lower down the labor cost, there is an immense need for supervisors to measure the performance of flight attendants on the basis of Key Performance Indicators (KPIs). It is also very important for every flight attendant to be able to track his performance under different performance categories as well as view the average peer score for comparison. There should be an easy, efficient, and less time-consuming way to do this task as the major problem is that the data is scattered at different places. Our Project: It involves researching and refining the data available from different sources. It also involves designing a prototype of a user friendly flight attendant performance measurement dashboard which will be able to fetch relevant data from different places and show the processed information (performance scores) at a single platform.

Food Detective is a mobile application that empowers those with dietary restrictions to understand what is in their food. The main feature is a barcode scanner that matches a user’s dietary needs against the contents of a product. This will allow users quickly and easily answer one question: “Can I consume this product?” This is the single most important question for anyone living with a restriction. By enabling them to quickly get this answer, we increase their chances of eating within their guide lines and improving their quality of life. Our application is available on both Android and iOS, both applications implement the core scanning functionality, a sharing and saving system so that users can keep track of products they like, and alert their friends about potential products they may want to buy. Through this simple system, we hope to help those with special diets live a healthy and productive life.

Nearly 26 million Americans suffer from diabetes. Poorly controlled diabetes exacerbates serious health complications. To assure diabetic control, patients need to have meticulous monitoring of their blood sugars and limit their calorie and carbohydrate intake. Diabetic patients face daily challenges in planning meals, eating out, or navigating restaurant choices and menu offerings that best fit their strict dietary needs. To address this critical need, we are introducing a mobile application that utilizes smartphone features including a camera and GPS to identify restaurant menus that cater to specialized diets, and analyzes and recommends menus that meet user’s dietary goals. This application also enables users to quickly analyze and calculate pre-packaged food and recipes, as well as track their daily and weekly carbohydrate and calorie load. Based on conducting several user tests and receiving expert advices, our application enables users to easily find food options that fit their requirements.

The University of Washington (UW) Libraries, like many organizations, are facing a large number of retirements in the next 5-10 years. This could result in a massive loss of experience and institutional knowledge, which would be detrimental to UW as a whole. This is because the UW Libraries holds a central position in the success of the University as an academic research university. As the intellectual commons of the University, both physically and virtually, the Libraries address the information needs of the whole University community. By combining a literature review, interviews with staff, and case studies, I investigated current and future trends in academic libraries and higher education, identified necessary leadership competencies, and recommended best practices to help create an effective succession plan that will ensure a smooth transition to new leadership. 

Communications, including the sharing of and access to information, is crucial to any organization, especially non-profits that rely on a rotating mix of volunteers, have building space in multiple locations, and the inevitable shortage of paid staff. The Friends of the San Francisco Public Library, a member and donor-centric organization that fundraises and advocates for the library, have struggled greatly with these restraints. A plan to strengthen internal communications by creating digital platforms to access and share information was created. Virtual spaces were designed for all parties involved, enabling staff, volunteers and board members to become proactive and more self-sufficient. Two databases were built: one that eliminated a tedious daily data entry task, and another 26 that keeps track of all of the categories and subjects of donated books, which has tightened the organization’s successful book operations department.