Archive for the 'Spreadsheets in Education' Category

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

Link: Google Spreadsheets adds charts

Wednesday, April 18th, 2007

Google Spreadsheets adds charts (Via Lifehacker.) It seems Lucie’s wish has come true. :)

Google Spreadsheets is now a more viable alternative to Excel… in educational contexts as well.

Meanwhile, it seems we may also see presentations as a part of the “Google Office Suite” : Google Docs and Spreadsheets to add presentations!!! (Via Open Source Classroom.)

Use Excel to make a timeline

Wednesday, September 20th, 2006

Use Excel to make a timeline (Via Lifehacker.) It’s been a while since I added something to my “Spreadsheets in Education” category. This lifehacker tip can easily be used as the basis of, or part of, a school assignment. Consider its application in social studies classes…

web-projects

Wednesday, December 14th, 2005

web-projects

I’ve previously FURLed Dave Conlay’s Aristotle Experiment, which links to this Web Projects page. Check out the amazing work his students are doing through this wiki… including student made videos!

ocde-excel » The M and M Activity

Wednesday, December 14th, 2005

ocde-excel » The M and M Activity

Dave Conlay prepared a wiki for his Spreadsheets for Educators class at the OCDE tonight.

M&M_spreadsheet.xls

Tuesday, November 29th, 2005

M&M_spreadsheet.xls

The M&M lesson, thanks again to Christine Olmstead. (Note: Links direct to a zipped file.)

Spreadsheet Lesson Plans and Ideas

Tuesday, November 29th, 2005

Spreadsheet Lesson Plans and Ideas

Starting a new category for tonight’s Spreadsheet class at the LBUSD. Here is a great place for teachers to start.