Skip to Main Content

Escape from Spreadsheet Hell

The website for the workshop! TL;DR we’ll teach you how to create spreadsheets optimized for reuse by you and others. Your future self will thank you.

Recommended readings

We can't cover everything in an hour so if you want to learn more the following are a great place to start.

DataOne Education Module 4: Data Entry and Manipulation. DataONE.
(The whole series is very good)

Wickham, H. (2014). Tidy Data. Journal of Statistical Software, 59(10), 1 - 23. doi: http://dx.doi.org/10.18637/jss.v059.i10
(How to optimize data processing in R and other computer languages)

Hart EM, Barmby P, LeBauer D, Michonneau F, Mount S, et al. (2016) Ten Simple Rules for Digital Data Storage. PLOS Computational Biology 12(10): e1005097.

White et al. (2013). Nine Simple Ways to make it easier to (re)use your data. Ideas in Ecology and Evolution 6(2): 1–10, 2013

Gardener, Mark. (2015). Managing Data Using Excel: organizing, summarizing and visualizing scientific data.

Library ebook.

Escape Coordinators

Megan O'Donnell
mno@iastate.edu
Data Services Librarian
ENT, EEOB, NREM, and Environment.

Kris Stacy-Bates
kksb@iastate.edu
Science and Technology Librarian
ABE, CCEE, Math, and Stats