Data Management using NEON Small Mammal Data
Teaching Module Overview
Undergraduate STEM students are graduating into professions that require them to manage and work with data at many points of a data management life cycle. Within ecology, students are presented not only with many opportunities to collect data themselves, but increasingly to access and use public data collected by others. This activity introduces the basic concept of data management from the field through to data analysis. The accompanying presentation materials mention the importance of considering long-term data storage and data analysis using public data.
This data set is a subset of small mammal trapping data from the National Ecological Observatory Network (NEON). The accompanying lesson introduces students to proper data management practices including how data moves from collection to analysis. Students perform basic spreadsheet tasks to complete a Lincoln-Peterson mark-recapture calculation to estimate population size for a species of small mammal. Pairs of students will work on different sections of the datasets allowing for comparison between seasons or, if instructors download additional data, between sites and years. Data from six months at NEON’s Smithsonian Conservation Biology Institute (SCBI) field site are included in the materials download. Data from other years or locations can be downloaded directly from the NEON data portal to tailor the activity to a specific location or ecological topic.
In this activity, students will:
- discuss data management practices with the faculty. Presentation slides are provided to guide this discussion.
- view field collection data sheets to understand how organized data sheets can be constructed.
- design a spreadsheet data table for transcription of field collected data using good data management practices.
- view NEON small mammal trapping data to a) see a standardized spreadsheet data table and b) see what data are collected during NEON small mammal trapping.
- use Microsoft Excel or Google Sheets to conduct a simple Lincoln-Peterson Mark-Recapture analysis to estimate plot level species population abundance.
Please note that this lesson was developed while the NEON project was still in construction. There may be future changes to the format of collected and downloaded data. If using data directly from the NEON Data Portal instead of using the data sets accompanying this lesson, we recommend testing out the data each year prior to implementing this lesson in the classroom.
This module was originally taught starting with a field component where students accompanied NEON technicians during the small mammal trapping. As this is not a possibility for most courses, the initial part of the lesson has been modified to include optional videos that instructors can use to show how small mammal trapping is conducted. Instructors are also encouraged to bring small mammal traps and small mammal specimens into the classroom where available.
Estimated Duration: 50 minutes
Themes: Data Management, Organismal Data
Audience: Undergraduate courses
Class size: Any (adapt the Q&A/Discussion questions to small group discussions or instructor-led introductions as needed)
- Internet access: if presenting, live from the website or accessing videos.
- Computer & projector: if presenting, live from the website or accessing videos.
- Optional: audio capabilities for videos
- Computer with a spreadsheet program (Excel, Google Sheets)
- Internet access for downloading data sets (or have them pre-downloaded)
- Optional: small mammal specimen/small mammal trapping equipment
- Handout with instructions & questions
This lesson introduces the basic concept of data management from the field through to data analysis while teaching students about a core ecological field data practice of small mammal trapping.
After the lesson, students will be able to:
- Explain a basic process of data management from collection through analysis and archiving.
- Calculate population size estimates using the Lincoln-Peterson Method
Data Skills Objectives
After the lesson, students will be able to:
- Create a well layed out spreadsheet
- Describe data management practices for
All Teaching Module components are available for download under the Detailed Lesson Plan tab in the sidebar menu.
The Data Sets
The National Ecological Observatory Network is a program sponsored by the National Science Foundation and operated under cooperative agreement by Battelle Memorial Institute. This material is based in part upon work supported by the National Science Foundation through the NEON Program. The associated datasets are posted for educational purposes only. Data for research purposes should be obtained directly from the National Ecological Observatory Network.
Data Citation: National Ecological Observatory Network. 2017. Data Product: NEON.DP1.10072.001. Provisional data downloaded from http://data.neonscience.org. Battelle, Boulder, CO, USA
The materials for this lesson are presented as both a single webpage with the primary content and as downloadable materials that can be used in the classroom.
Use of NEON Teaching Modules
All lessons developed for the National Ecological Observatory Network data are open-access (CC-BY) and designed as a resource for the greater community. General feedback on the lesson is welcomed in the comments section on each page. If you develop additional materials related to or supporting this lesson, and are willing to share them, we provide the opportunity for you
to share them with other instructors. Please contact NEON Data Skills or, if familiar with GitHub, submit an issue or pull request with new materials in the NEON Data Skills repo (tutorials are on master branch). All materials will be reviewed by staff prior to inclusion in or linking from the NEON Data Skills materials.
This activity is designed to be taught in a classroom with computers (either a computer lab or student's personal computers). The teaching materials can be followed along in a digital version in the lesson page (linked before) or can be presented entirely offline once the data are downloaded.
Activity Data Sets
The following datasets are posted for educational purposes only. Data for research purposes should be obtained directly from the National Ecological Observatory Network (www.neonscience.org).
Data Citation: National Ecological Observatory Network. 2017. Data Product: NEON.DP1.10072.001. Provisional data downloaded from. Battelle, Boulder, CO, USA
- NEON.D02.SCBI.DP1.10072.001.mam_pertrapnight.072014to052015.csv – Small mammal trapping data from NEON’s Smithsonian Conservation Biology Institute (SCBI) field site for July 2014 to May 2015 (seven months total as no trapping was conducted November to March). This .csv contains combined months from the combined small mammal trapping data from September and October 2014. This data are a combined table based on the individual site-month tables available from the NEON Data Portal. This file should be used with a group of student to implement their skills and allow different partners to estimate abundance for different plots and seasons to allow for larger patterns to be examined in the classroom.
- NEON.D02.SCBI.DP1.10072.001_variables.csv – Metadata file for NEON small mammal data (DP1.10072.001) describing the variable names.
- NEON.DP1.10072.001_readme.txt – Metadata file for the NEON small mammal data (DP1.1072.001) providing more information on the data product.
- NEON.D02.SCBI.DP1.10072.001.20140917-20140924.xml – Example XML file for the September 2014 data that is provided with this lesson.
- Abbreviated NEON Small Mammal Trapping Protocols.pdf – This document is adapted from NEON Document NEON.DOC.000481 in May 2017. It describes the layout of NEON small mammal sampling grids and is only intended for use with the educational teaching module outlined in this article.
- NEONSmallMammal_SCBI_BlankDataSheet.pdf – This document shows how a NEON field data sheet is formatted and is provided to show a potential format for recording this type of data. This document is limited to D02 data sheets, all NEON Small Mammal trapping data sheet can be found in document NEON.DOC.001585 Datasheets for TOS Protocol and Procedure: Small Mammal Sampling.
Download a .zip file (759 KB) with all the teaching data files below.
Activity Workbooks & Materials
The following materials are provided to complete the teaching module.
- NEONTeachingModule_Teacher_DataManagementWithNEONSmallMammalDataAndMarkRecapture.doc – The document provides instructors with additional information for presenting the materials.
- NEONTeachingModule_Student_DataManagementWithNEONSmallMammalDataAndMarkRecapture.doc – This document can be used as a student handout (instructors much make a few changes to decide on preferred instructions) to guide the work through the data activity.
- NEONSmallMammalDataAbundanceWorkbook.xlsx – This workbook contains only the September and October data from the NEON.D02.SCBI.DP1.10072.001.mam_pertrapnight.072014to052015.csv file. Each worksheet lays out one step needed to conduct that Lincoln-Peterson species population abundance analysis.
- NEONTeachingModule_DataManagement_Slides.ppt – This presentation accompanies the student activity and provides visuals to support the steps of the activity.