The Google Workshop for Educators Network (GWEN) is a community for any educator who has attended a Google Workshop for Educators (GWE) produced by Google's education partner,
Computer Using Educators (CUE). This is a CLOSED community.
The Google Teacher Newsletter is open to anyone interested in receiving updates about Google's education initiatives. This is an OPEN community.
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.