Google Docs and Data Analysis

Conditional Formatting.

Take advantage of a lesser known Google Docs Spreadsheet function – “Change colors with rules…” to view data “horizontally” and “vertically.”  For this particular rubric, I highlighted the students’ scores and set the numbers 0, 1, 2, 3, and 4 to Red, Orange, Light Orange, Yellow, and Green respectively. See below.


View a sample conditionally formatted rubric.

The Result?

At just a quick “horizontal” glance, it is easy to see among the field of green (which means 4 or full credit) that students struggled with the design requirement more than any other.  Reteaching should focus in this area.

A quick “vertical” glance reveals a lot of red and orange for student 15. Additional support, and possible intervention, should be provided to this student.

Give this a try, and comment below to let me know how this worked for you.

Video Slideshow Maker 
If you have never visited, do yourself a favor and check it out.  It’s a great resource for simple video slide show creation.  Everything happens on-line.  All you need to do is upload your pictures and video clips, choose a song (of which they supply an extensive library), and add some titles.

Above is a compilation video slide show of Macromedia Fireworks digital photo montages designed by my sophomore level computer class.

One Republic is a classroom-friendly version of This resource provides a variety of videos for teachers to either reiterate concepts or enrich the content area of their choice. Below, I have embedded a hilarious, entertaining Declaration of Independence-themed parody of One Republic’s – Too Late To Apologize. Enjoy!