Personalizing vocabulary study through CALL
In this presentation, I show and tell about a system for personalizing vocabulary study for groups of students. The system leverages Google products (sheets, forms, and scripts), Excel VBA, and ChatGPT to create an automated, personalized way for students to study vocabulary. The system is set up so that students can study vocabulary that they choose, but it could also be used for instructor-chosen vocabulary. The system begins with students selecting vocabulary to study, ideally from actual written or aural texts. Students input their self-selected vocabulary into an individual Google Sheet or corresponding Google Form. Vocabulary from all students is automatically aggregated in a single Google Sheet available to the instructor. From this point, the instructor can manipulate student vocabulary lists via Excel VBA (or Google Apps Scripts) and ChatGPT in order to create personalized quizzes, reading texts, and example sentences. I will demonstrate how the system works in the presentation, and attendees will see examples of quizzes, reading texts, and model sentences that are created through the system. To conclude the session, I discuss other possible ways the system can be used to support vocabulary study and current limitations or challenges that using the system presents.