Resources: Compare
#347, v2.0
#959, v1.0
Title
Old Version | New Version | ||
---|---|---|---|
1 | Data Management | 1 | Data Management Adaptation: Correlating Forest Community Dynamics to Climate |
Authors
Old Version | New Version | ||
---|---|---|---|
1 | Megan A. Jones (National Ecological Observatory Network) | 1 | Sarah McCarthy-Neumann (Alma College) |
2 | Jim McNeil (George Mason University; Smithsonian-Mason School of Conservation) | 2 | Sarah Neumann () |
3 | Megan A. Jones (National Ecological Observatory Network) |
Description
Old Version | New Version | ||
---|---|---|---|
1 | <p>This version of this teaching module was published in Teaching Issues and Experiments in Ecology: </p> | 1 | <p>This lesson is an adaptation based on two other teaching modules:</p> |
2 | |||
3 | <p>Hernández-Pacheco, R. (2018). <a href="http://dx.doi.org/10.25334/Q44X4D" target="_blank">More In Depth Spreadsheet Management Adaptation of Data Management using NEON Small Mammal Data</a>. <a href="https://qubeshub.org/groups/neon2018">NEON Faculty Mentoring Network</a>, QUBES Educational Resources. <a href="http://dx.doi.org/10.25334/Q44X4D" target="_blank">doi:10.25334/Q44X4D</a></p> | ||
2 | 4 | ||
3 | <p>Jim McNeil and Megan A. Jones. April 2018, posting date. Data Management using National Ecological Observatory Network’s (NEON) Small Mammal Data with Accompanying Lesson on Mark Recapture Analysis. <cite>Teaching Issues and Experiments in Ecology</cite>, Vol. 13: Practice #9 [online]. <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> | 5 | <p>Jim McNeil and Megan A. Jones. April 2018, posting date. Data Management using National Ecological Observatory Network’s (NEON) Small Mammal Data with Accompanying Lesson on Mark Recapture Analysis. <cite>Teaching Issues and Experiments in Ecology</cite>, Vol. 13: Practice #9 [online]. <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> |
4 | 6 | ||
5 | <p>*** *** *** </p> | 7 | <p>*** *** *** </p> |
6 | 8 | ||
7 | <p> | 7 | <p>Building research questions and carrying out appropriate analysis to answer them is often the ultimate semester activity within introductory ecology courses. These research experiences present multiple challenges concerning 1) how to generate data and 2) how to manage the data for analysis. This adaptation uses NEON vegetation structure data in place of NEON small mammal data in the teaching module '<em>More in Depth Spreadsheet Management Adaptation of Data Management Using NEON Small Mammal Data' </em>(Raisa Hernández-Pacheco 2018) to address the second challenge.</p> |
8 | 10 | ||
9 | <p>This | 9 | <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. 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.</p> |
10 | 12 | ||
11 | <p>In this activity, students will:</p> | 13 | <p><strong>Specific module adaptations</strong></p> |
14 | |||
15 | <p>NEON terrestrial forest vegetation data replaced NEON small mammal data in order to broaden the use of the teaching module in plant oriented courses. Specifically, this adaptation consists of four exercises that introduce students to 1) format spreadsheet data tables, 2) carry out spreadsheet quality control, 3) count/sort/filter data of interest in order to conduct a pilot analysis on NEON forest aboveground biomass, and 4) correlate vegetation biomass across nine forest sites to a climate metric (e.g., latitude, mean annual temperature, or mean annual precipitation).</p> | ||
16 | |||
17 | <p>In this adapted activity, students will learn how to:</p> | ||
12 | 18 | ||
13 | <ul> | 19 | <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.</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> | 17 | <li>create a scatter plot figure correlating tree aboveground biomass to a climate metric across nine sites.</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> | 24 | </ul> |
20 | |||
21 | |||
22 | |||
23 | |||
24 | 25 | ||
25 | <p><strong>The Data Sets</strong></p> | 26 | <p><strong>The Data Sets</strong></p> |
26 | 27 | … | … |
28 | 29 | ||
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 | <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 | ||
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> | 32 | <ul> |
33 | <li><strong>NEON_TreeVegetation_variables.xlsx</strong> – Metadata file for NEON terrestrial vegetation data describing the variable names.</li> | ||
34 | <li><strong>NEON.Adaptation_FacultyNotes_DataManagementWithNEONTreeData.docx</strong> – This document provides instructor information on the workshop activity.</li> | ||
35 | <li><strong>NEON.Adaptation_DataManagementWithNEONTreeData_Slides.pptx</strong> – This presentation accompanies the workshop activity and provides visuals to support the steps of the activity.</li> | ||
36 | <li><strong>NEON_tree_data_student.xlsx</strong> –This workbook contains NEON terrestrial vegetation data consisting of both species identity and size (e.g., diameter at breast height) for all individuals at all NEON terrestrial sites.</li> | ||
37 | <li><strong>NEON_plot_area.xlsx</strong> - This workbook contains the area sampled at each of the sites which is needed to standardize the aboveground biomass data to cm per hectare.</li> | ||
38 | <li><strong>NEON_site_climate.xlsx</strong> - This workbook contains latitude, mean annual temperature and mean annual precipitation at each site.</li> | ||
39 | <li><strong>NEON_tree_data_instructor.xlsx</strong> –This workbook contains NEON terrestrial vegetation data consisting of both species identity and size (e.g., diameter at breast height) already filtered by individuals and sites (according to the activity instructions) with pivot table result summaries and scatter plot figures.</li> | ||
40 | </ul> |
Attachments
1 | file — ./Small Mammal Data Teaching Module/McNeilJones_TIEE_DataManagementSlides.pptx | 1 | file — ./Neumann/NEON.Adaptation_DataManagementWithNEONTreeData_Slides.pptx |
---|---|---|---|
2 | file — ./Small Mammal Data Teaching Module/McNeilJones_TIEE_NEONSmallMammalDataAbundanceWorkbook.xlsx | 2 | file — ./Neumann/NEON.Adaptation_FacultyNotes_DataManagementWithNEONTreeData.docx |
3 | file — ./Small Mammal Data Teaching Module/NEONTeachingModule_SmallMammalDataManagement_TeachingDataSubset.zip | 3 | file — ./Neumann/NEON_plot_area.xlsx |
4 | file — ./Small Mammal Data Teaching Module/NEONTeachingModule_Student_DataManagementwWithNEONSmallMammalDataAndMarkRecapture.docx | 4 | file — ./Neumann/NEON_site_climate.xlsx |
5 | file — ./Small Mammal Data Teaching Module/NEONTeachingModule_Teacher_DataManagementwWithNEONSmallMammalDataAndMarkRecapture.docx | 5 | file — ./Neumann/NEON_tree_data_instructor.xlsx |
6 | file — ./Small Mammal Data Teaching Module/NEON_Fieldtech7.jpg | 6 | file — ./Neumann/NEON_tree_data_student.xlsx |
7 | file — ./Neumann/NEON_TreeVegetation_variables.xlsx | ||
8 | file — ./Neumann/NEONTreeVegetation.jpg |