Last month I spoke at the Google Apps EDU Certified Trainer Summit, and the video of my 15 minute session (well, 17 minutes… sorry, all) is now available. You can view the video below or on YouTube, and you can access the slides, notes, and resources from the session in a previous post.
Naturally, I’d love to hear your comments below.
Note: The first half of the talk is background on CUE, The Google Teacher Academy, and CUE’s Google Workshops for Educators. The “effective PD” content starts just after the 9:45 mark if you want to jump ahead. :)
I recently led a Google Docs session at Whittier Christian High School and was asked to provide a quick demo video illustrating the way I used formulas (and in particular the IF formula) to grade a quiz made using a Google Form. Apparently my explanation plays well face-to-face but considerably less well from memory. ;)
For this video I cut right to the chase and did my best to explain the IF formula for beginners… while keeping under a 5 minute time limit. I hope it’s helpful for you and your colleagues and I hope you’ll let me know what you think.
Incidentally, there was a minor error in one of my formulas at the end, but I fixed it live rather than record (yet another) take. I like to think it’s good time management, and good modeling of verifying and troubleshooting a spreadsheet formula. Oh, and I wouldn’t necessarily “reteach” if half my class failed a quiz and the other half got As… but that might be a good time for some targeted intervention. ;)
Also, here are the slides I used in the middle segment of the video… in case they might be helpful to you as well (the last slide includes a copy-and-paste-able “nested” IF formula for generating letter grades from percentage scores):
Up next in the screencast category: Using Transpose to share individual results of a teacher observation (by an admin) or student rubric (by a teacher or peer), complete with a demo template. :)
01-R4: Google Workshop: Search, Learn, and Share! Tuesday 10/26/10 – 9:00 AM – 4:00 PM in the TBA-4 Room Presented by: Lainie Rowell, Computer Using Educators Fee for convention registrants: $250.00
01-R7: Using the iPad Wifi for Learning (includes 16G iPad Wi-Fi version) Tuesday 10/26/10 – 9:00 AM – 12:00 PM in the TBA-3 Room Presented by: Ted Lai, Computer Using Educators Fee for convention registrants: $650.00
05-R2: Using the iPad 3G for Learning (includes Wi-Fi + 3G iPad) Tuesday 10/26/10 – 1:00 PM – 4:00 PM in the TBA-3 Room Presented by: Ted Lai, Computer Using Educators Fee for convention registrants: $790.00 (Note: 3G data plan sold separately)