Anuk Centellas

Senior Project Advisor

Jordan Sandoval

Document Type

Project

Publication Date

Spring 2025

Keywords

Python, Streamlit, Github, language learning, data processing, data plots, affective factors, phonology, Likert scale, Qualtrics, jitter

Abstract

This web app provides a way for the Spanish Language Learning Research Group at WWU to easily format data files and generate plots from the data. The group’s overall goal is to improve the Spanish program at WWU, and one piece of this process was to collect data from Spanish students. The group collected data through a Qualtrics survey, and I designed an app to help them process that data and create plots from it. The app consists of three parts: the processor, the plotter, and the merger. In the processor, the user uploads an excel file that must be the raw data downloaded directly from Qualtrics. The app will then display a download button, which the user can click to download the clean version of the data. Once the user has this clean data, they can move to the plotter. Here, they can upload the clean data, which triggers the display of various options for different features of the plot. The user can make their selections, then click a button to show the plot on the screen, and then download it as an image if desired. The merger part of the app is used for concatenating two files together. Since the survey has been and will continue to be sent out multiple times, the group needs a way to have all of this data in one file. The user can upload two files to the merger, and the second one will be appended to the end of the first one. This is saved to a new file, so neither of the original files are changed. Optionally, the user can choose to sort the combined files by student, so that if the same student has taken the survey multiple times, their responses will all be grouped together. The choice to sort the new file is made after uploading the two original files and before downloading the combined file. Overall, this app is for the Spanish Language Learning Research Group to have an easy way to clean and organize data, as well as be able to generate plots to easily examine the data and present findings.

[Data is provided in supplementary files on this page.]

Department

Linguistics

Type

Text

Rights

Copying of this document in whole or in part is allowable only for scholarly purposes. It is understood, however, that any copying or publication of this document for commercial purposes, or for financial gain, shall not be allowed without the author’s written permission.

Language

English

Format

application/pdf

Additional Files
Centellas LLRG_APP_EXAMPLE_DATA_1.xlsx (12 kB)
Example Data 1
Centellas LLRG_APP_EXAMPLE_DATA_2.xlsx (12 kB)
Example Data 2
Download

Share

COinS