Development of Atmosphere-Aurface Exchangeable Pollutants (ASEPs) Database(s)
Dr. Judith Perlinger, jperl@mtu.edu
Post Date: 09/22/2014
Capstone/Internship Possible: Yes/Yes
Description:
Atmosphere-surface exchangeable pollutants (ASEPs) such as polycyclic aromatic hydrocarbons (PAHs) and polychlorinated biphenyls (PCBs) have adverse effects on humans and ecosystems. Once emitted, these compounds are transported and deposited on natural surfaces such as water, soil, and vegetation from where frequent re-emission and deposition occur. The goal of this project is to assemble literature air-surface exchange flux measurements in a standardized database format. The student will work closely with a doctoral student at Michigan Technological University to design database(s) for air-surface exchange flux of PCBs and PAHs using Microsoft Access. Database development involves review of published field measurements, data interpretation and tabulation, and data management. The student will apply basic statistical techniques to analyze flux measurement data and interpret results. The student will learn how to create tables, queries, forms, and reports using Access, and thereby gain valuable experience with relational database management system. The student will also gain understanding of ASEP atmosphere-surface exchange processes.
Back to Project Description List