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.
Over the course of today's session, there may be a number of tools you want to
learn more about, or ideas that you will want to explore with others
later. Your personal doc will be your space for notes, links, and
anything else you decide to put there.
Log into your Google Account.
Select Documents.
Click on New -> Document
Immediately
type in a few words at the top which can serve as the title. When the
system does its first save, what is there will be the default name of
the doc.
Use this document to jot down a few notes on what you are learning, with any ideas on how you could try with your students.
EXTRA: If
you would like to make this a conversation, invite someone to share
your document with you, deciding how to build it together (as is, each
of you using different colored text - whatever you wish to try). Not sure how? No worries, we will get to this in Activity 2.
Google Docs
Google Workshop for Educators - Google Docs Overview for Educators
Activity 2: Accessing/Editing a Shared Document Demo Document
Click here to access and edit a shared Google Document.
Then enter your name, email address and your district name, what you
teach and change the color of the text to something not used
previously. We'll use this to organize ourselves.
Discussion:
observe a) simultaneous edits b) lag in updates c) active editors
listed at bottom d) revisions e) simplicity of editing interface.
Opinions? Implications?
Activity 3: Who are we? Demo Spreadsheet with a Form
Solicit sample answers from other participants, family members or others.
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!
EXTRA:
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.