Data Carpentry's aim is to teach researchers basic concepts, skills, and tools for working with data so that they can get more done in less time, and with less pain. The lessons below were designed for those interested in working with Ecology data in Spreadsheets.
Content Contributors: Christie Bahlai, Aleksandra Pawlik, Jennifer Bryan, Alexander Duryee, Jeffrey Hollister, Daisie Huang, Owen Jones, Ben Marwick, Tracy Teal
Lesson Maintainers: Aleksandra Pawlik, Tracy Teal
Lesson status: Teaching
See Instructor notes on how to teach this lesson.
Data files for the lesson are available here: https://github.com/iDigBio/2015-09-23-TDWG-spreadsheet-ecology-lesson/raw/gh-pages/data/biology/surveydatatabs.xls
Data Carpentry's teaching is hands-on, so participants are encouraged to use their own computers to insure the proper setup of tools for an efficient workflow. These lessons assume no prior knowledge of the skills or tools, but working through this lesson requires working copies of the software described below. To most effectively use these materials, please make sure to install everything before working through this lesson.
Spreadsheets are useful for data entry and data organization, and some subsetting and sorting of the data as well as getting an overview of the data. To interact with spreadsheets, we can use LibreOffice, Microsoft Excel, Gnumeric, OpenOffice.org, or other programs. Commands may differ a bit between programs, but general ideas for thinking about spreadsheets is the same.
For this lesson, if you don't have a spreadsheet program already, you can use LibreOffice. It's a free, open source spreadsheet program.