12 November 2007

Gradebook Redux

We have a nasty storm moving in with high winds. I won't be surprised if the power is out later...so I'd better blog while the blogging's good. :)

We're past the quarter mark in the school year. Now that I've had a chance to try out the gradebook I drafted in August, it's time to share some of the growing pains I've had...and show off the new and improved version. The names have been removed to protect the innocent and I've deleted all but a sampling of student marks. Still, you can get the jist of it all

First of all, I moved all of the marks onto one Excel worksheet, instead of two (one for formative and one for summative). I boldfaced the summative items to help them stand out. This also makes it simple to print "progress reports" for kids who need to show their parents. I just hide the rows with other student info and then I can print out just the marks for the one student. Keep in mind when you're reading the data that it is not completely sequential. The marks are in order according to standard...but the standards aren't in chronological order. Also, instead of having a separate record of assessments, I have typed them directly into the worksheet with the marks. Voila! Three worksheets condensed into one---and very friendly to use. I also added a worksheet with the most recent testing data. This makes it easy to keep close at hand. Overall, only 20 - 25% of my students met the standards in 2006. Lots of work for me to do in order to improve upon that.

We'll see how things shake out at the semester. Obviously, there will be a lot more information to consider by then, but perhaps you can start to see how the data is emerging. Looking at the scores by standard really helped the conferences I had with kids about what should go on the report card. I would like to develop some sort of format that has the standards listed, along with the appropriate score. Perhaps there would be some way to merge the Excel data into a Word template...and then just print these out for kiddos (and parents). One hurdle at a time, eh?

Update 5/2012: Please visit my page on the Excel for Educators blog for current examples of using Excel for collecting and reporting classroom data.


Hugh O'Donnell said...

SG, I'm pretty stoked that you are working the kinks out on the gradebook end of things.

I'm thinking that instead of complex gradebook programs that have a gazillion options and settings (and, therefore, a gazillion ways to screw it up), straightforward spreadsheet and word processing is the future of grade/achievement reporting.

Like, less is better, maybe?

Hugh aka Repairman

The Science Goddess said...

I certainly think it could be.

We should get out on the road with this show. :)

Hugh O'Donnell said...

Well, if not the road, how about the wiki?

If you left the old gradebook up, and posted the new one with comments, there would be an evolutionary lesson there for others to follow.

Hugh aka Repairman