Resource Image

MS Excel Refresher - Lizards, iguanas, and snakes! Oh my! | Data Nuggets

Author(s): Kristen Kaczynski

California State University - Chico

629 total view(s), 346 download(s)

0 comment(s) (Post a comment)

Summary:
This resource, a MS Excel refresher, extends the level for this Data Nugget. Students are given an Excel workbook with the data and asked to graph and calculate diversity using Excel functions (rather than drawing graphs by hand as in the original…

more

This resource, a MS Excel refresher, extends the level for this Data Nugget. Students are given an Excel workbook with the data and asked to graph and calculate diversity using Excel functions (rather than drawing graphs by hand as in the original data nugget). The data set used is the same. I use this activity in an upper division Environmental Science course for majors that focuses on Restoration Ecology. The simplicity of the data set and the comparisons of reptile diversity among urban, non-urban and urban rehabilitated lend for a great example for doing calculations in spreadsheets.

Licensed under CC Attribution-ShareAlike 4.0 International according to these terms

Version 1.0 - published on 13 Jan 2023 doi:10.25334/NZWH-HQ21 - cite this

Description

You'll find an excel workbook with the original data from the Data Nugget, as well as an updated pdf lab with questions that expands on the original data nugget activity. The activity could easily be adapted for Google Sheets. It is one of the first activities in the semester as students need a refresher in using MS excel. This is used during a 3 hour lab period.

Cite this work

Researchers should cite this work as follows: