Resources: Compare

#347, v2.1 Published:
#567, v1.0.0 Published:

Title

Old VersionNew Version
1Data Management using National Ecological Observatory Network's (NEON) Small Mammal Data with Accompanying Lesson on Mark Recapture Analysis 1More In Depth Spreadsheet Management Adaptation of Data Management using NEON Small Mammal Data

Authors

Old VersionNew Version
  1Megan A. Jones (National Ecological Observatory Network) 
1Jim McNeil (George Mason University; Smithsonian-Mason School of Conservation) 2Jim McNeil (George Mason University; Smithsonian-Mason School of Conservation) 
2Megan A. Jones (National Ecological Observatory Network) 2Raisa Hernández-Pacheco ()
3Megan A. Jones (National Ecological Observatory Network) 3Raisa Hernández-Pacheco ()

Description

Old VersionNew Version
1<p>This version of this teaching module was published in Teaching Issues and Experiments in Ecology:&nbsp;</p>  1<div>
   2<p>This module adaptation combines the&nbsp;<em>Data Carpentry: Data Organization in Spreadsheets Ecology Lesson&nbsp;</em>(Bahlai and Teal 2017) and the teaching module&nbsp;<em>Data Management Using NEON Small Mammal Data&nbsp;</em>(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.&nbsp;</p>
2  3  
3<p>Jim McNeil and Megan A. Jones. April 2018, posting date. Data Management using National Ecological Observatory Network&rsquo;s (NEON) Small Mammal Data with Accompanying Lesson on Mark Recapture Analysis.&nbsp;<cite>Teaching Issues and Experiments in Ecology</cite>, Vol. 13: Practice #9 [online].&nbsp;<a href="http://tiee.esa.org/vol/v13/issues/data_sets/mcneil/abstract.html">http://tiee.esa.org/vol/v13/issues/data_sets/mcneil/abstract.html</a></p>  3<p>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.&nbsp;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.&nbsp;</p>
4  5  
5<p>*** *** ***&nbsp;</p>  5<p><strong>Specific module adaptations</strong></p>
6  7  
7<p>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.</p>  7<p><em>Data Carpentry: Data Organization in Spreadsheets Ecology Lesson&nbsp;</em>activity from Software Carpentry was added to McNeil and Jones (2018) in order to emphasize on proper data management when using large datasets.&nbsp;</p>
8  9  
9<p>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&rsquo;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.</p>  10<p>In this adapted activity, students will learn how to:&nbsp;</p>
   11</div>
10  12  
11<p>In this activity, students will:</p>  11<div>
12    
13<ul>  14<ul>  
14   <li>discuss data management practices with the faculty. Presentation slides are provided to guide this discussion.</li>  14   <li>format spreadsheets for effective data use.</li>
15   <li>view field collection data sheets to understand how organized data sheets can be constructed.</li>  15   <li>carry out spreadsheet quality assurance and control.</li>
16   <li>design a spreadsheet data table for transcription of field collected data using good data management practices.</li>  16   <li>conduct a pilot analysis by managing a large, open access dataset to answer a research question.&nbsp;</li>
17   <li>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.</li>    
18   <li>use Microsoft Excel or Google Sheets to conduct a simple Lincoln-Peterson Mark-Recapture analysis to estimate plot level species population abundance.</li>    
19</ul>  18</ul>  
20  19  
21<p>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.</p>  21<p>This module adaptation was implemented in 2018 at the University of Richmond&nbsp;during an introductory biology course.</p>
22  22</div>
23<p>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.</p>    
24    
25<p><strong>The Data Sets</strong></p>    
26    
27<p>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.</p>    
28    
29<p>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).</p>    
30    
31<p>Data Citation: National Ecological Observatory Network. 2017. Data Product: NEON.DP1.10072.001. Provisional data downloaded from <a href="http://data.neonscience.org/">http://data.neonscience.org</a>. Battelle, Boulder, CO, USA</p>   

Attachments

1 file — ./Small Mammal Data Teaching Module/McNeilJones_TIEE_DataManagementSlides.pptx 1 file — ./Raisa/formatted_small_mammal_comm.xlsx
2 file — ./Small Mammal Data Teaching Module/McNeilJones_TIEE_NEONSmallMammalDataAbundanceWorkbook.xlsx 2 file — ./Raisa/NEON.Adaptation_DataManagementWithNEONSmallMammalData_Slides.pptx
3 file — ./Small Mammal Data Teaching Module/NEONTeachingModule_SmallMammalDataManagement_TeachingDataSubset.zip 3 file — ./Raisa/NEON.Adaptation_FacultyNotes_DataManagementWithNEONSmallMammalData.docx
4 file — ./Small Mammal Data Teaching Module/NEONTeachingModule_Student_DataManagementwWithNEONSmallMammalDataAndMarkRecapture.docx 4 file — ./Raisa/NEON_small_mammal_data.xlsx
5 file — ./Small Mammal Data Teaching Module/NEONTeachingModule_Teacher_DataManagementwWithNEONSmallMammalDataAndMarkRecapture.docx 5 file — ./Raisa/small_mammal_community.xls
6 file — ./Small Mammal Data Teaching Module/NEON_Fieldtech7.jpg 6 file — publication_580_642/Small Mammal Data Teaching Module/NEON_Fieldtech7.jpg
7 file — ./Raisa/Cover image.png