Cleaning Biodiversity Data: Excel
Author(s): Debra Linton1, Molly Phillips2
1. Central Michigan University 2. iDigBio, Florida Museum of Natural History, University of Florida
2765 total view(s), 981 download(s)
Summary:
Access and clean an open source polar bear dataset using Excel.
Contents:
BLUE Clean_X Module 2_25_20.docx(DOCX | 684 KB)
Ursus arctos Raw Data.xlsx(XLSX | 118 KB)- License terms
Description
Students will clean an open sources polar bear dataset using best practices to accurately and clearly designate each step taken to collect, clean, and analyze open access biodiversity data. This exercise uses Excel.
Upon completion of this module, each student should be able to:
- Access biodiversity data from open sources.
- Use descriptive, retrievable, and consistent file names to manage datasets.
- Identify common problems with digital datasets
- Rectify common problems with digital datasets
- Apply disciplinary knowledge for smart data cleaning
- Explain the importance of reproducible data and cleaning steps
- Document data cleaning steps to provide reproducibility.
Notes
This resource was developed in part at the 2019 QUBES & BioQUEST Summer Institute Evolution of Data in the Classroom: From Data to Data Science
Cite this work
Researchers should cite this work as follows:
- Linton, D., Phillips, M. (2020). Cleaning Biodiversity Data: Excel. Biodiversity Literacy in Undergraduate Education, QUBES Educational Resources. doi:10.25334/BASF-A951