One of my professional goals from last year was to delve deeper into the realm of "data visualization" and think about applications to schools. There are any number of websites devoted to great visualizations of social and economic information (as well as plenty of "Infoporn"/eye candy), but I'm not seeing much in the way of transitions to practical applications for schools. And I think we could use them.
I'm still playing with some ideas for an upcoming presentation, but here is some of my thinking so far...
Consider the graphic to be a piece of a gradebook. I haven't labeled the assignments, just input some numbers representing where students scored (on a 4-point scale) for a given standard. I used boldfaced type for summative assessments---others are formative.
Fuchs and Fuchs (1986) conducted a meta-analysis of feedback types given to students and determined that graphic representations (putting information into pictures---not just words/numbers) increased student achievement by 26%. So, what can we do with the batch of numbers shown above? For one, we can apply some conditional formatting and make a "traffic signal" visual:
It's not bad. It certainly gives me a better idea about whether or not the class is "getting it," depending on the assignment. But we can also take things a step further, and eliminate the numbers altogether:
The graphs above come from a Sparklines add-in for Excel. It is a free, open-source (Thank you, Fabrice!) tool that provides you with multiple options for charts/graphs that are one cell in size. (Note: Microsquash just applied for a patent for their own version, but it is nowhere near what others have developed...and, let's face it, there is nothing proprietary about their ideas in this matter.) But back to the snapshot above, I had Excel generate a simple line graph for each student (with the red line representing "At Standard/Level 3") and the bar chart at the bottom summarizing the data for the entire class.
So far, so good. When I look at this with my teacher eyes, I see so much more of a story appearing about each student. It is no longer a sea of numbers. Now, these fancy-dancy charts won't help me know what to do next (e.g. If students are still below standard, what should the intervention be?), but it may be a better start for identifying issues.
I have a few other tricks up my sleeve that I'm working on and will share in the coming days. What would you like your gradebook to be able to do and show you?
Update 5/2012: Please visit my page on the Excel for Educators blog for the most recent versions of gradebooks and reporting tools.