Watch the following videos to see how we get seawater, collect individual samples, analyze nutrient data, and handle the data using spreadsheets.
The data for this assignment is coming from the Northern Gulf of Alaska Long Term Ecological Research site (NGA-LTER). This program visits several locations in the Northern Gulf of Alaska three times a year to determine seasonal and interannual variability in the region. The program is uplifted by the contribution of graduate students - who have helped produce the data sets used in this assignment.
Nutrients are often sampled from large bottles that are sent to various depths of the ocean on a Rosette. The sample collected can either be analyzed on board the ship, or frozen and analyzed at home in a lab. The video to the left is an example of a rosette being deployed.
Once the rosette has been recovered, a team of scientists will sample the bottles for many parameters (like oxygen, salinity, nutrients, and chlorophyll). Seawater is collected from a spigot at the bottom of the Niskin bottle.
Nutrient samples can be analyzed shipboard or frozen and sent back to a land-based lab. Nutrients are analyzed by a colorimetric method, which means that a sensor determines the color of the sample and then using a standard curve we can calculate the concentration of the sample from how much color there was.
There are many ways to work with data, for this assignment, we'll be using Google Sheets as a place to both sort and plot the data. For introductory course on google sheets, consider a YouTube series. In this assignment you will be asked to make scatter plots, column charts, and sort or filter the data. The video embedded to the left is a primer on making a column chart.
Surface seawater sampling for micronutrients in the Gulf of Alaska. (Photo contributed by the NGA-LTER)