Need spectrography and HR diagram drill sheets? Here you go!

In ongoing PD news, you can still register for the Ditch That Textbook Digital Summit; 9 videos, 9 days. The videos will be available until Dec. 31. Follow the fun at #ditchsummit on Twitter.

I'm still trying to put together my blogs for the fall PD I've been doing, but for now I wanted to share a few things I'm really excited that I figured out how to do.

Inspired by Robert Prior many years ago, I started coding a lot of Excel spreadsheets as randomized drill sheets on many topics. My goal for this year is to get most of them up as Google Sheets so I can publish them to the web and students can go straight to my website to print out an infinite number of sheets.

Anyway, I've also been working on adding new, richer sheets to my catalogue. In particular, I was very jazzed last year when I figured out how to get a spreadsheet to draw spectrographs (hint: error bars). And last night I spent far too long working on how to get a Hertzsprung-Russel diagram (yay for the Bubble chart, boo for the fact that the labels are arbitrarily hidden when you go to a larger font).

Behold, I give you my Spectrograph and HR diagram drills for the grade 9 space unit (and Earth and Space science, too).

I'm still working on the HR diagram answers; I have to figure out how best to get it to choose whether it's on the main sequence or not. Also, I think I need more white dwarf stars, because that area is looking pretty sparse.

However:

 If you'd like to see my other drill sheets, head on over to the drill sheet section of my course webpage. It's very much a work in progress. I have a lot more sheets than I've listed there.