Navigation

Google Learning Network

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.

Http is an insecure protocol. Https is secure. Be sure to always use https when accessing Google Docs on a public network (or any network for additional security).

Method 1 - Simply type an "s" at the end of "http" when you connect to Google Docs to force a secure connection. You can then bookmark https://docs.google.com for future secure access.Method 2 - For users of Gmail, go to Settings, look for Browser Connection, and select "Always use https" - then always launch Docs from the link at the top of the Gmail page. This will force Docs to open using https as well.

Method 3 - For administrators of a Google Apps: Education Edition domain, you can require all users in the domain to use https by Enabling SSL for your domain.