To clarify explanation teacher must take Google Form quiz first so that correct answers are the second row in the spreadsheet. Then add a grading column for scoring for EACH answer column. In the grading column, check the answer by writing the formula if (D3=D2, 10, 0). If the student's answer in d3 = the teacher's answer in d2, then the student gets 10 points. Otherwise the student gets 0 points. (Change this as needed) Then a final column is added to total the points the student received.
Thanks, easy to follow. Any way to assign scoring feedback to each rperson/student as soon as they finish entering all answwers (Right/Wong and grade) with auto response? Or posting of right v wrong answers?
To clarify explanation teacher must take Google Form quiz first so that correct answers are the second row in the spreadsheet. Then add a grading column for scoring for EACH answer column. In the grading column, check the answer by writing the formula if (D3=D2, 10, 0). If the student's answer in d3 = the teacher's answer in d2, then the student gets 10 points. Otherwise the student gets 0 points. (Change this as needed) Then a final column is added to total the points the student received.
MsMseifman 6 months ago
Thanks, easy to follow. Any way to assign scoring feedback to each rperson/student as soon as they finish entering all answwers (Right/Wong and grade) with auto response? Or posting of right v wrong answers?
LoniHart 8 months ago
Th explanation is a bit confusing. Maybe do a "take 2" and be a bit more clear?
skarka 1 year ago
Not too bad but a fair bit of work to set up.
jawofthedog 1 year ago