Presentation Personalized Vocabulary Quizzes with Google Sheets more

Learners should be able to study the vocabulary that they personally want or need to learn, but assessing students’ individual vocabulary can be difficult. This presentation demonstrates how the use of Apps Script with Google Sheets creates a system in which students can maintain their own personal vocabulary lists, and teachers can generate individualized vocabulary quizzes for students within minutes. The system involves students recording their individual vocabulary items in a personal Google Sheet. Items are then aggregated in a teacher's sheet, after which the teacher can click one button and generate 15-item quizzes and corresponding answer sheets. The quizzes take students three minutes to complete, and classmates can check each other’s quizzes using the answer sheets. The system will be fully demonstrated during the presentation, and there will be time at the end to discuss how session attendees might adapt the system to their own teaching contexts.