The Science Goddess just completed a 3-part series on how to create a standards-based gradebook using Excel. The posts include a sample gradebook you can download and play with. Plus, your learning will be supported by three screencasts of the Science Goddess explaining some tips and tricks. Highly recommended!
Part 3: Adding Sparklines