Feb 25, 2019
The webcam feature in many Google products (Docs, Slides, Drawings, etc.) makes a lot of cool learning activities possible.
How to activate it: Insert > Image > Camera
How to use it:
Ways it can be used in class:
Google Drawings comic strips -- Have students take pictures of themselves -- posing as themselves or as a character -- and add speech bubbles and thought bubbles.
Audra Arman-Richardson (Nevada) -- With Google+ shortly leaving us, what do you recommend as a replacement? We have 20+ schools throughout our state that share and communicate using this platform. We are not sure what to migrate to.
Mike Brilla (Pennsylvania) -- Google Classroom. Uses Doctopus and Goobric. Self-proclaimed “organizational train wreck”. Had trouble keeping track of the Sheets. Used Google Keep keeping track. Use Keep extension on Chrome. Uses the label “Things to grade.” Now everything is in one place. Links are there. Delete note when he’s done.
Danny Contopoulos (science teacher, New York) -- Bailee wants to know how to automatically send responses to different sheets.
In the google sheet that is accepting responses from the form, all Bailee would have to do is create two new tabs and on each tab use a filter formula
'Sheet 1’!A1:F100 is the response range
'Sheet 1'!B1:B100 is the column with the teacher’s name
"Teacher 1" is the teacher’s name (matched exactly)
Caroline Goodman (Tennessee)-- School developing new PE program where students/teachers attend classes at various times throughout the day. Google service flexible posting of class schedules so change daily, check in and out of classes, a record of who attended which classes.
Linda Hummer (Ohio) -- Personalized PD in their school district. 2 PD days -- 1 in fall with four different sessions running at the same time that staff could choose to go to, during sessions: 1 tool or several tools that do the same type of thing (formative assessment). Discuss and share what they’re doing, ask questions, work on creating things they’d like. 1 in spring -- changed to two sessions (they’re a K-12 building). Staff shared with one another, asked questions, enjoyed that type of PD, will continue using it.
Ryan Bradford -- I was listening to episode 74 last night and I think I have a solution for Bailee's question. The Query formula can be used to auto separate the data into different sheets based on certain criteria (e,g, school name, resource type, etc). If you create a Google Form with an identifying question like school name and send all of your responses to the default response sheet, you can then create two separate sheets that each use a query formula to pull on specific data based on the school name. I included some screenshots below of how I use this at my school to quickly separate supply requests by type.