This title should really read “Practical data management takes its show ACROSS the road” because that’s what I’m actually doing. Next week, I’ll be a co-instructor for the second Data Carpentry bootcamp at MSU’s BEACON Center, which is right across the street from me. Who said agricultural ecologists don’t get to travel?
My part of this session will focus on spreadsheet best practices for spreadsheet users, data validation in spreadsheets, and a bit of higher-order data cleaning using applications like OpenRefine.
I’ve been burying myself in lesson planning for the past few days, and I think I have a workable plan. However, I wanted to crowd-source some commentary on my Spreadsheet lesson plan. The goal of this lesson is to get scientists who are just starting out to design their spreadsheets in ways that will give them (and their future data managers) minimal headaches down the road. Here it is, as a Google doc that you can comment on, but not edit*:
So, interested parties- I would like you to tell me if there’s anything major I’ve overlooked, any particular spreadsheet quirks you’d like to see covered, etc. You might notice that some of the copy looks very familiar- turns out some of the stuff I’ve already written for this blog came in quite handy.
I’m pretty excited for my first time as a Data Carpentry instructor! I’ll let you know how it goes.
*lest anyone vandalize it with references to body parts or comments about my or my progenitor’s characters.