#3033

Workshop

Cancelled Create auto-grading quizzes with Google Sheets+Forms

Sat, Jun 18, 10:00-11:15 Asia/Tokyo

Location: Zoom G

In this practice-oriented short workshop, participants will learn to use Google Sheets and Google Forms along with built-in functions to create auto-grading quizzes for their students. This system allows students to review and practice key sentences, vocabulary, idioms, and/or target phrases from their class lessons. Up to 50 students can simultaneously access a Google worksheet and learn from each other’s work. When the task, either assigned for homework or done in class (no computer room necessary) is complete, the instructor can set up quiz pools from the students’ work and quickly generate auto-grading assessments using built-in functions in combination with Google Forms or any other LMS they may be using at their institution. Step-by-step instructions are given with handouts and video pre-recording for those who cannot make it live or just want to review after the event. A unique auto-grading quiz is created for each student from the work of the entire class encouraging students to learn from each other. The teacher only need spend 10 to 15 minutes checking and running the content through a few Google Sheet functions. The result is an effective assessment tool that grades itself. No previous knowledge of scripts or functions in Google Sheets is necessary but some familiarity with spreadsheets is helpful. Step-by-step instructions are given from beginning to end. Participants will walk away with a powerful teaching and assessment skill. In addition, student feedback on how they prefer the instant feedback and multiple attempts that this system provides along with their positive comments on getting to see other students' work in real time.