Showing posts from December, 2020

Google Form Quizzes - Find Max Score - Apps Script

If you have ever created a quiz for mastery, you may have discovered you can have students take the quiz as many times as they want.  As an educator, you can use the number of retakes a evidence of growth or opportunities to provide overall performance gains while also providing short penalties to discourage frequent and rapid retakes.  For example, students can take the quiz as many times as they wish, but for each time they take the quiz, the score is reduced by 2.5%. If you have this information in a spreadsheet, you are golden. In this tutorial, we will create an App Script file to filter out Google Form scores to quickly upload the marks to our SIS or online Gradebook. Problem: If using multiple quizzes in a year where students can retake quizzes, reimplementing formulas to filter the data can be a pain.   Solution & Skills: We will create one Google Spreadsheet where future forms can be pointed.  We will use Apps Script to pull and format the scores, creating a new sheet with

Google Form Quizzes - Find Max Score - Formulas

Sometimes a little grade candy is just the motivation teachers need to get students to learn factual information.  Factual information can be easily assessed with a Google Form.  But what if you want to find the max score for each student?  We some finessing and two slick formulas, we can create our list.  Using  GradeTransferer  we can then upload our marks into our gradebook.  I'll be using Aspen.   If you try this, just make sure you have set your quiz to collect the email addresses of the users.  I also recommend having a dropdown with all the student names or two text fields where students can type in their first and last names. Problem: Google Classroom doesn't accept the importation of marks if a user has taken a Google Form quiz more than once.  So, we need a way to find just the highest mark to update our gradebook.  With your Google Form set to allow the users to take the quiz as many times as possible, lets get started. Form should not limit the number of responses.