Ecology Curriculum

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

This workshop uses a tabular ecology dataset from the Portal Project Teaching Database and teaches data cleaning, management, analysis, and visualization. There are no pre-requisites, and the materials assume no prior knowledge about the tools. We use a single dataset throughout the workshop to model the data management and analysis workflow that a researcher would use.

  • Data Organization in Spreadsheets
  • Data Cleaning with OpenRefine
  • Data Management with SQL
  • Data Analysis and Visualization in R
  • Data Analysis and Visualization in Python

The Ecology workshop can be taught using R or Python as the base language.
Portal Project Teaching Dataset: the Portal Project Teaching Database is a simplified version of the Portal Project Database designed for teaching. It provides a real-world example of life-history, population, and ecological data, with sufficient complexity to teach many aspects of data analysis and management, but with many complexities removed to allow students to focus on the core ideas and skills being taught.

Authoring Person(s) Name: 
Tracy Teal
Authoring Organization(s) Name: 
Data Carpentry
License - link to legal statement specifying the copyright status of the learning resource: 
Creative Commons Attribution 2.0 Generic - CC BY 2.0
Access Cost: 
No fee
Primary language(s) in which the learning resource was originally published or made available: 
More info about
Keywords - short phrases describing what the learning resource is about: 
Data cleaning
Data management
Data visualization tools
Interoperable data - FAIR Data Principle
Organizing data
Re-usable data - FAIR Data Principle
Tabular data
Workshop curriculum
Subject Discipline - subject domain(s) toward which the learning resource is targeted: 
Physical Sciences and Mathematics: Environmental Sciences
Published / Broadcast: 
Saturday, April 1, 2017
Publisher - organization credited with publishing or broadcasting the learning resource: 
Data Carpentry
Version - revision or edition number or date associated with a learning resource: 
Version 2017.04.0
Media Type - designation of the form in which the content of the learning resource is represented, e.g., moving image: 
Collection - a group or set of items that comprise a single learning resource, e.g., a PDF version of a slide presentation, an audio file of the presentation and a textual representation of the oral transcription of the presentation.
Educational Info
Purpose - primary educational reason for which the learning resource was created: 
Instruction - detailed information about aspects or processes related to data management or data skills.
Learning Resource Type - category of the learning resource from the point of view of a professional educator: 
Educator Curriculum Guide - document that defines what concepts should be taught and/or how a concept should be taught effectively.
Target Audience - intended audience for which the learning resource was created: 
Intended time to complete - approximate amount of time the average student will take to complete the learning resource: 
More than 1 Day (but less than 1 week)
Framework - A community-based organization plan or set of steps for education or training: 
FAIR Data Principles