Support Options

  • Knowledge Base

    Find information on common questions and issues.

  • Support Messages

    Check on the status of your correspondences with members of the QUBES team.

Contact Us

About you
About the problem

More In Depth Spreadsheet Management Adaptation of Data Management using NEON Small Mammal Data

By Raisa Hernández-Pacheco

California State University-Long Beach

This adaptation consists of three exercises that introduce students to 1) format spreadsheet data tables, 2) carry out spreadsheet quality control, and 3) count/sort/filter data of interest in order to conduct a pilot analysis on NEON small mammal...

Listed in Datasets | resource by group NEON Faculty Mentoring Network

Version 1.0.0 - published on 18 May 2018 doi:10.25334/Q44X4D - cite this

Licensed under CC Attribution 4.0 International according to these terms

Adapted from: Data Management using National Ecological Observatory Network's (NEON) Small Mammal Data with Accompanying Lesson on Mark Recapture Analysis v 2.0

Cover image.png


This module adaptation combines the Data Carpentry: Data Organization in Spreadsheets Ecology Lesson (Bahlai and Teal 2017) and the teaching module Data Management Using NEON Small Mammal Data (McNeil and Jones 2018) to address the challenge of managing data during research by incorporating already developed spreadsheet data management exercises to answer an extended question on NEON small mammal data. 

This activity is designed to be carried out in a 1.25 hr lecture style course, however, students will need access to computers during this activity. Although the activity can be easily extended, its adaptation to the original was intended for instructors with high need to teach data management skills in a short period of time. 

Specific module adaptations

Data Carpentry: Data Organization in Spreadsheets Ecology Lesson activity from Software Carpentry was added to McNeil and Jones (2018) in order to emphasize on proper data management when using large datasets. 

In this adapted activity, students will learn how to: 

  • format spreadsheets for effective data use.
  • carry out spreadsheet quality assurance and control.
  • conduct a pilot analysis by managing a large, open access dataset to answer a research question. 

This module adaptation was implemented in 2018 at the University of Richmond during an introductory biology course.

Contents ( Show bundle contents ) Bundle

Cite this work

Researchers should cite this work as follows:



Version 1.0: This version of the adaptation was prepared as part of the 2018 NEON FMN.  

NEON Faculty Mentoring Network

NEON Faculty Mentoring Network group image