Crunch Time

I’m on the bus on the way to campus, it is pouring with rain, the heat is too high on aboard the bus, and I am late. And a bit tired. I was up until 1:00am crunching numbers. The main stage of the judging for the science film competition ended last night and I went into the system to do the data analysis. I’d designed a spreadsheet on which each of the ten judges give a score for each film in eight different categories which I tried to make roughly orthogonal. I set it up so that they could go to an online form (having viewed the films on a private channel on YouTube) and enter the scores, an action which in turn populates the spreadsheet for me. (Google docs rocks!) They could also enter optional comments about each film that could be useful for any discussion that needs to be had. So what I was doing was slicing the database of scores to see if I could get a ranking of the films to take into a face to face meeting with some of my fellow local judges today. Then I wanted to find ways of laying it all out in a way that was easy to read for everyone and in the end this morning I printed out a giant version of the entire spreadsheet on several sheets of 11×17 and glued them together to make a big colour coded foldout for us all to sit around.

The films? I’m delighted with the turnout as it shows the kind of variety of film I’d hoped would be produced. There are eight films, with films that are illustrated explainers on the one hand (with with animation or live action or sometimes both), through drama and narrative, to reflective overviews of a topic on the other, sometimes venturing into art inspired by science ideas.

(Above is a graphic made by Laurie Moore In Dornsife communications from stills of the films.)

This variety makes for a hard task in coming up with the prize winners, since […] Click to continue reading this post