Workshop Title: Data Organization in Spreadsheets #

Data Organization in Spreadsheets

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. This lesson was designed for those interested in working with data in spreadsheets.

Lessons

1. Introduction
2. Formatting data exercise
3. Formatting problems
4. Dates as data
5. Quality control
6. Exporting data
7. Data format caveats

Data

Data file for the lesson is: phm-collection-messy.xls

Notes

Data Carpentry’s teaching is hands-on, so participants are encouraged to use their own computers to follow along with each lesson.

Thanks

These lessons were updated based on the Data Carpentry spreadsheet lessons used by HASTAC in 2015. Contributors included: Christie Bahlai, Aleksandra Pawlik, Tracy Teal, Jennifer Bryan, Alexander Duryee, Jeffrey Hollister, Daisie Huang, Owen Jones, Clare Sloggett, Harriet Dashnow and Ben Marwick