ABOUT

The Three Levels of DH in Our Project

Selecting the Sources

Processing the Data

To explore how the COVID-19 pandemic impacted the educational system in the US, we used the SEDA 2023 data. This data comes from the Educational Opportunity Project at Stanford University, a national database that contains rich data for insight into academic performance. The dataset includes aggregated test scores (math and English language arts) across various school districts in the US for the years 2016, 2017, 2018, 2019, 2022, and 2023. It also includes information on student subgroups such as race/ethnicity and socioeconomic status. To provide a broader context for academic and socioeconomic trends during the COVID-19 pandemic, we supplemented with data from other years, notably from 2020-2022 in order to track shifts over time. 

Before processing our data, we made sure to understand what each variable in the dataset represents by carefully reading the SEDA 2023 Technical Documentation PDF. The documentation also informed us on where the data came from and how they collected it. Since our project is focused on comparing the pre-pandemic academic performance with post-pandemic academic performance in two states, California and Ohio, we added a filter and reduced our dataset to only include the data of these two states. 

However, we identified gaps in our coverage of the data, where test scores, enrollment numbers, and assessment results were missing across multiple school districts. Our dataset would have been more informative if it had consistent records for all years, particularly in the post-pandemic context. Although the dataset is lacking in some areas, we decided to center our research on comparing pre-pandemic and post-pandemic educational outcome trends in California and Ohio, which enabled us to create clearer data visualizations and conduct a more focused analysis of the data available to us.

To create our data visualizations, we decided to use Tableau, R, and Python. Due to our familiarity with different languages, we were able to leverage our various skill sets in each language to develop insights. We made sure to understand the codebook, analyze the types of scores present, and distribution of values collected in SEDA 2023 for a holistic view of the data. We then embedded our data visualizations into our website and made it interactive. As a result, we were able to provide a multifaceted and complete picture about educational outcomes from the COVID-19 pandemic through our data and visualizations.

Presenting Our Narrative

To create our website, our team utilized a HumSpace domain provided by UCLA and designed the site using WordPress. We chose WordPress because of its wide range of themes and the ability for users to collaborate efficiently. During our lab discussions, we brainstormed design choices and selected a high-contrast theme to enhance accessibility, ensure easy navigation, and provide a visually pleasing experience. Due to WordPress’s open and public nature, our work can reach a broader audience and encourage engagement. 

After establishing the website’s structure, we outlined the content for each page and determined the most effective layout and organization. Then, our group delegated each section for the members of our project to complete. Our group’s contributions are outlined in our chosen roles. After each member completed their respective sections, we collaborated to refine the content and ensure a comprehensive, yet concise narrative. Additionally, WordPress’s design flexibility allowed us to integrate structured sections and interactive data visualizations, which helped us present our findings in a compelling way and craft a cohesive narrative for our users.


Meet the Equity Explorers! ✏️🚀

Acknowledgements 🌱

Julia Stoddard, for her continuous guidance and kindness throughout the development of our project. Thank you for being our TA and all your guidance to help us move forward in our final product!

Dr. Nicholas Sabo, for imparting valuable knowledge about the realm of digital humanities to us. We learned so much and appreciate you widening our perspective in viewing and interpreting sources through the lens of technology.