Archive for September, 2010

Effective Professional Development (Video)

Thursday, September 30th, 2010

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. :)

Quick and Easy IF Formulas for Grading Google Forms

Tuesday, September 28th, 2010

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. :)

iPad and Google Workshops in Orange County

Thursday, September 23rd, 2010

Registration for the following workshops is now available without conference registration! CUE is producing three workshops at the upcoming AECT Conference on October 26-30, 2010 at the Hyatt Regency Orange County in Anaheim, California.

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)

Read the workshop descriptions and register online at the AECT website. We hope to see you there!