PROCEDURE:
1. Describe how this set of sea-water temperature records have been obtained. This file provides examples of the records which have been submitted to The Institute of Ocean Sciences at Sidney, Vancouver Island.

daily duties video
The students from Lester Pearson College often stay at the island and take over the daily duties such as the water sampling for temperature and salinity. This video shows the process used in the manual determination of these factors.
IOS
When the records have been submitted, they are added to a database which is maintained by the Institute of Ocean Sciences. This link shows historic sets of raw data from IOS for the British Columbia Light Stations.
2. Go to this file to obtain the Race Rocks Mean Monthly Sea Temperature 1921-present,
a) open an excel workbook and save it as “Temperature records at Race Rocks. We will copy the data for the first ten years of the record and the last ten years of the record to an empty Excel file.

b) Highlight years 1921 to 1930 from the data, copy and paste to the open Excel file.

c) Cut out each year and paste it side by side so that you have the rows representing the months and the columns representing the years. Make a horizontal table of the data

d) highlight across the able, the temperatures for each month of the ten year group. Then click on the symbol in the menu line which produces an average. This average will appear to the right of the last years column.

e) Do the same with the last ten years set of data. You now have two sets of averages by month of the two decades.

f) Compare the monthly averages for the two decades. What do you find?

3. There are of course many ways of looking at this data. Try summing the total averages for each decade. Simply highlight the column of averages and click on the tool for SUM. What is your finding.
4. You could also do the same for all the decades.Once you have a chart made up of the monthly averages of all the decades, It is easy to have Excel draw a graph for you. Click on the Wizard symbol and choose the type of graph.

5. After manipulating the data, and looking at it in several ways, write a statement which expresses your understanding of the whether or not there has been a temperature change in the Strait of Juan de Fuca as measured by daily samples taken at Race Rocks. Be sure that you do not generalize beyond the evidence provided by your data. Also discuss the assumptions that you must recognize before drawing a conclusion from this data.

6. For Extension work: Run a statistical program to determine if the difference you find is significant.

7. For Extension work: Read the review below and if possible, read the book! Present a summary to your class.
The long-term Sea temperature record at Race Rocks has been pointed out as one of the pieces of evidence that has accumulated on global warming. Author Terry Glavin, in reviewing the book The Weather Makers by Tim Flannery ( Harper Collins Publishers, 2006) says :

” The Pacific Ocean itself is getting warmer. Measurements at the Race Rocks lighthouse near Victoria show an average rise in temperature of 1°C since 1921, which doesn’t sound like much until you remember that its only 10°C in the other direction that separates us from the deep freeze of the Ice Age. The ocean, absorbing increasing volumes of carbon dioxide, is becoming more acidic, too, inhibiting the production of plankton, the basis of all life in the sea.”

The rest of the article may be seen at http://www.straight.com/content.cfm?id=17132

8. Refer to the file: Sea Temperature as an abiotic factor .
castSeveral ideas are discussed in this file about how the sea water temperature affects marine organisms. Discuss how organisms adapt to changes in sea temperature.

9. Extension: Find out the monthly water temperature averages from your own area. Compare them with Race Rocks and discuss the geoclimatic factors which lead to the similarities and or the differences, and the implications for organisms living in the two ecosystems.