The UCSF-SFDPH DeID OMOP database integrates EHR data from UCSF Health and SFDPH. UCSF Health primarily serves insured patients, while SFDPH provides accessible healthcare regardless of insurance or immigration status. This integration enhances research in population health and health equity by offering a unified patient database with broad demographic and socioeconomic representation. Our team developed detailed methodologies and transparent data mapping processes, including a global patient identifier and extension tables for health system data differentiation.

In this session, we will share our experience migrating our Learning Management System from on-premises to AWS. We will walk through designing a scalable and secure cloud infrastructure using CloudFormation, automating deployments with AWS CodePipeline, orchestrating containers with ECS Fargate, and managing databases with Amazon RDS. The migration process involved moving code via GitHub, files with AWS DataSync, and the database through DBMS export/import.

This session will go over the strengths/weaknesses of three popular form-building platforms: MachForm, Qualtrics, and DocuSign's Powerform. The session will explain and demonstrate the platforms, common use-case scenarios for each, and why some should be used over others (for inherent reasons, as well as user/security-requirement reasons).

Join us as we showcase our solution for creating a user-friendly interface to track operational tasks. The Campus Application and Data Security team is dedicated to providing services that ensure consistency, data integrity, and compliance with our Service Level Agreements. To achieve this, we have utilized Smartsheets to inventory all tasks in a centralized location. This approach enables us to generate metrics and monitor resource capacity.

Our Instructional Design and Technology team was tasked with tracking learning objective achievement in Extension courses to support WASC accreditation. Canvas offers an "Outcomes" feature, but WASC also requires instructors to reflect on how their course design supports student success. While staff could help instructors brainstorm improvements, a more scalable method was needed.

Spark is a pioneering homegrown web app that embraces an innovative approach to student success technology – one that empowers students with personalized behavioral analytics to make informed decisions about attaining their personal goals while improving access to campus services through data-driven targeting. This session will argue for the necessity of this approach in serving today's students at scale and fulfilling the promise of a university degree.

Making a video doesn't have to be hard! Proper planning and an understanding of which tools to use will help to make the creation process much easier. This session will illustrate the planning process of making a video as well as creating a script, providing software suggestions and providing access to example videos.

Join us for an engaging session featuring representatives from multiple University of California campuses and CampusGroups, the all-in-one campus experience platform. We'll showcase how UC campuses are using key features—like centralized event calendars, group management, attendance tracking, and campus-wide communication tools—to boost student engagement and streamline operations. This session will offer practical insights for maximizing value.

ChatGSPP is an AI-powered chatbot developed by the Goldman School of Public Policy that intelligently navigates information about our faculty, staff, programs, and research initiatives. This interactive demo will showcase how we've implemented a conversational interface that analyzes user queries, retrieves appropriate content from our existing web resources, and delivers responses with proper source attribution.

Join us for an engaging session featuring representatives from multiple University of California campuses and CampusGroups, the all-in-one campus experience platform. We'll showcase how UC campuses are using key features—like centralized event calendars, group management, attendance tracking, and campus-wide communication tools—to boost student engagement and streamline operations. This session will offer practical insights for maximizing value.