In a small group, create a three question quiz using a Google Form.
Solicit sample answers from other participants.
Create an IF formula for each question to "grade" the question.
(Each IF formula needs to be in a new column.)
Fill Down so that the IF formulas you've written can "grade" all the
responses at once!
Advanced:
Create a SUM formula to total up the total score for each person that
took the quiz. Then create another formula to calculate the percentage.
Finally, create a nested IF formula to convert the percentages to letter
grades!
Time Permitting: Share your quiz with the lead learner. Links to the
quizes will be added below.