Field to Database
| Field to Database | |
|---|---|
 | |
| Quick Links for Field to Database | |
| Link to Agenda | |
| Workshop Presentation Biblio Entries | |
| Workshop Blog | |
General Information
This workshop's aim is to investigate current trends in collecting, and focus on best practices and skills development for supporting the collection of robust, fit-for-research-use data. This 4-day short course is designed to be hands-on and will mix lectures with field work and participant exercises and presentations.
Our curriculum includes:
- (synopsis here)
The concepts, skills, and tools we teach are domain-independent, but example problem cases and datasets will be taken from organismal and evolutionary biology, biodiversity science, ecology, and environmental science.
Skill Level: Some exposure to R is recommended. This workshop is not explicitly for beginners. But R experience is not mandatory. If you are new to R, we recommend an intro to R coursera course prior to the workshop.
Updates will be posted to this website as they become available.
Software Installation Requirements and additional information is available at the github web site for the project: <github links to datasets here>
Planning Team
François Michonneau (FLMNH - iDigBio), Katja Seltmann (TTD-TCN, MNH), Pam Soltis (FLMNH - iDigBio PI), Derek Masaki (USGS - BISON), Deb Paul (iDigBio), Shari Ellis (iDigBio), Kevin Love (iDigBio)
About
Instructors: François Michonneau (FLMNH - iDigBio), Katja Seltmann (TTD-TCN, AMNH), Derek Masaki (USGS)
Assistants: Dan Stoner (ACIS - iDigBio), Deborah Paul (FSU - iDigBio), Matt Collins (ACIS - iDigBio)
Who: The course is aimed at graduate students, postdocs, research staff, and other researchers.
Skill Level: Non-beginners with respect to R. Some exposure to R would is recommmended. This workshop is not explicitly for beginners. But R experience is not mandatory. If you are new to R, we recommend an intro to R coursera course prior to the workshop.
Where: iDigBio in Gainesville, FL
Requirements: Participants must bring a laptop with a few specific software packages installed. If you will be traveling from out of town, you will need to make your own travel arrangements.
Contact: Please email Deb Paul, dpaul@fsu.edu for questions and information not covered here.
Twitter: hashtags
Tuition for the course is free, but prior registration is required for attending. You can register [here.]
Workshop Evaluation
- link to pre-workshop survey (if we do one)
- Post Workshop Survey Results
Software Installation Details
Software needed for Data Carpentry Workshop at iDigBio
- link to software installation instructions
- You must RSVP that the required software is installed, prior to the workshop. Instructors are available to help - see your email for their contact information.
We use Adobe Connect extensively in this workshop. Please perform the systems test using the link below. Also, you will also need to install the Adobe Connect Add-In to participate in the workshop.
Agenda
- AdobeConnect #field2database Room (if we are going to use).
- Pre-workshop meeting and dinner at Piesano's, 6 PM Sunday March 8th, 2015. Piesano's is at NW 13th St. and 1250 W. University Ave. in Gainesville. All are welcome. Please do RSVP to Deb Paul, dpaul@fsu.edu
| Course Overview - Day 1, Monday March 9th | ||
|---|---|---|
| 8:30-9:00 | Registration. name tags, wired/wireless, adobeconnect, check-in. |
All, Deb Paul (iDigBio) |
| 9:00-9:20 | Welcome and Introduction to iDigBio | Deb Paul (iDigBio), Pam Soltis (iDigBio PI) |
| 9:20-10:00 | Why a Field-to-Database Biodiversity Informatics Workshop? | Katja Seltmann (AMNH), Pam Soltis (iDigBio PI) and Charlotte Germain-Aubrey (iDigBio Post Doc) |
| 10:00-10:15 | Break | |
| 10:15-11:30 | Invited Speaker Presentations From the Field (10 to 15 min each) |
Katja Seltman (Lead); Emilio Bruna; Justin Woods; Mike Webster; Andrew Short; Grant Godden; François Michonneau (or Gustav Paulay) |
| 11:30 - 12:00 | Transport to Natural Teaching Area | (vans) |
| 12:00 - 1:00 | Lunch (Brown Bag provided) | (organizers set up demo areas) |
| 1:00-4:00 | On Site Field Demos from Invited Experts | Katja Seltmann (Lead) |
| 4:00-5:00 | Return to 105 for Wrap-up and Homework: Create a 3 min presentation. | Katja Seltmann (Lead) |
| 6:00 | Dinner on your own. | Potential to have dinners together if desired. |
| Course Overview - Day 2, Tuesday March 10th | ||
| 8:30-9:00 | Check in, answer questions | All, Deb Paul |
| 9:00-11:00 | Discussion and Homework Presentations. (3 min. each participant) |
Katja Seltmann and Invited Experts (Lead) |
| 11:00-11:30 | General issues in field data collection to data synthesis. | Derek Masaki and Katja Seltmann (Lead) |
| 11:30-12:30 | Reproducible Research | Derek Masaki (Lead) |
| 12:30-1:30 | Lunch | (on your own, or provided) |
| 1:30-1:45 | Review of data set: identify issues, errors. | ? |
| 1:45-5:00 | Getting started with R | François Michonneau (Lead) |
| 5:00-5:30 | Review / Homework? / Preview of tomorrow | |
| Course Overview - Day 3, Wednesday March 11th | ||
| 8:30-9:00 | Check in, answer questions | All, Deb Paul |
| 9:00-10:00 | Data exploration using R. Import and display. | Derek Masaki (Lead) |
| 10:00-12:00 | From raw data to technically correct data. | Derek Masaki (Lead) |
| 12:00-1:00 | Lunch | on your own (or provided) |
| 1:00-2:00 | From technically correct data to consistent data. | Derek Masaki (Lead) |
| 2:00-3:00 | File output. Writing processed data to file. | ? |
| 3:00-4:30 | ||
| 5:00-5:00 | Review / Wrap-up / Preview of tomorrow | |
| Course Overview - Day 4, Thursday March 12th | ||
| 8:30-9:00 | Check in, answer questions | All, Deb Paul |
| 9:00-12:00 | Using R to access biodiversity APIs | Francois Michonneau, Matt Collins (Leads) |
| 12:00-1:00 | Lunch | on your own (or provided) |
| 1:00-2:30 | Publishing data on iDigBio | Joanna McCaffrey, Dan Stoner (Leads) |
| 2:30-4:00 | Publishing data on DataDryad | Todd Vision, DataDryad (Lead) |
| 4:00-5:00 | Review, Wrap-up, Survey, Next Steps. | 1 slide lightning talks by volunteer participants: One thing learned, one thing they realize they need to learn more about -- their plans for learning more, and how they plan to pay-it-forward (to share what they’ve learned with colleagues / fellow students -- through talks? / blog posts? / seminars?) |
| 5:00-5:00 | Review / Wrap-up / Preview of tomorrow | |
| Optional Evening Session -- on working with their own data? | ||
Future plans: Scaling it up: Demo using the iPlant Discovery Environment (DE)
Link to Workshop Report
Logistics
- Logistics & Hotel Information (for the out-of-towners)
- Where to find food
- Workshop Calendar Announcement
- Participant List
Adobe Connect Access
Adobe Connect will be used to provide access for a remote classroom at the American Museum of Natural History. Workshop participants will be encouraged to be logged in to the Adobe Connect room to facilitate sharing with this remote group: Already registered and accepted?
- Adobe Connect Room for Data Carpentry at iDigBio
- AMNH (remote) and iDigBio participants take notes together with this EtherPad
Presentation Documents and Links
Links to any presentations (like power points) here.
Workshop Recordings
Day 1
- 8:30am-10:00am
- 10:30am-12:00pm
- 12-12:30
- 1:00pm-5:00pm
Day2
- 8:30am-10:00am
- 10:30am-12:00pm
- 1:30pm-5:00pm
Related Workshop Resources and Links
- Data Carpentry Materials on GitHub
- Ten Simple Rules for the Care and Feeding of Scientific Data. Goodman et al
- Code and Data for the Social Sciences: A Practitioner's Guide. Matthew Gentzkow, Jesse M. Shapiro Chicago Booth and NBER March 10,2014
- Nine simple ways to make it easier to (re)use your data. White et al.
- You want to learn SQL independently? Try Head First SQL
- Head First Excel, O'Reilly
- Check out DataONE
- They've got a great Software Tools Catalog
- Put standard metatdata with your data. Wondering how to do that? Check out DataONE's Morpho Tool available under the tools menu at https://knb.ecoinformatics.org/.
- Why? Makes your data re-useable, and better still, makes your data discoverable. Get cited for your datasets in addition to your published papers!
- Using Open Refine? Want to compare your taxon names against a standard list? Try this reconciliation service.
- Read Gaurav ' Blog post first: http://gbif.blogspot.com/2013/07/validating-scientific-names-with.html
- Then, give it a try. The google plus Open Refine community will help you figure it out (it's not hard).
Links from You
- How about you? Got a favorite resource - a book?, a website? to share with your classmates?
- Data Science at the Command Line
- Free Training Resources for UF students, faculty, and staff UF provides free access to over 2600 online training courses through Lynda.com. Does your institution have similar free training opportunities?
Related Blog Posts and Photos
- Inaugural Data Carpentry Workshop by Tracy K. Teal
- Our First Data Carpentry Workshop by Karen Cranston
- Tales from the First Data Carpentry Workshop by Deb Paul, May 2014
- Data Carpentry, Please can we have some more?! by Deb Paul, 15 Oct 2014
- Data Carpentry Facebook Photo Album