Data Collection Part 1: How to avoid a spreadsheet mess - Lessons learned from an ecologist

Key Info
Description - a brief synopsis, abstract or summary of what the learning resource is about: 

Most scientists have experienced the disappointment of opening an old data file and not fully understanding the contents. During data collection, we frequently optimize ease and efficiency of data entry, producing files that are not well formatted or described for longer term uses, perhaps assuming in the moment that the details of our experiments and observations would be impossible to forget. We can make the best of our sometimes embarrassing data management errors by using them as ‘teachable moments’, opening our dusty file drawers to explore the most common errors, and some quick fixes to improve day-to-day approaches to data.
 

Authoring Person(s) Name: 
Stephanie Hampton
License - link to legal statement specifying the copyright status of the learning resource: 
Creative Commons 0 - CC0 "No Rights Reserved" (Public Domain)
Access Cost: 
No fee
Citation - format of the preferred citation for the learning resource: 
Hampton, Stephanie, 2015, Data Collection Part 1: How to avoid a spreadsheet mess - Lessons learned from an ecologist: U.S. Geological Survey, https://my.usgs.gov/confluence/x/4gb2Hg.
Primary language(s) in which the learning resource was originally published or made available: 
English
More info about
Keywords - short phrases describing what the learning resource is about: 
Scientific reproducibility
Data collection
Data sharing
Data management
Subject Discipline - subject domain(s) toward which the learning resource is targeted: 
Physical Sciences and Mathematics: Earth Sciences
Physical Sciences and Mathematics: Environmental Sciences
Published / Broadcast: 
Wednesday, April 15, 2015
Created: 
Wednesday, April 15, 2015
Media Type - designation of the form in which the content of the learning resource is represented, e.g., moving image: 
Event - time-based happening that is portrayed or covered by the learning resource, e.g., a webinar.
Contributor Name: 
Name: 
Stephanie Hampton
Contact Organization(s): 
U.S. Geological Survey
Educational Info
Intended time to complete - approximate amount of time the average student will take to complete the learning resource: 
Up to 1 hour
Framework - A community-based organization plan or set of steps for education or training: 
USGS Science Support Framework
Framework Node: USGS Science Support Framework: 
Acquire