Science 8: Today we made some changes to our database using the functions found within Excel.  This is not due on Thursday, rather, I would like you to spend 30 minutes studying for Science 8 or your other favourite final exam.

Use the functions of Excel to use your information in different ways. 

The instructions below will as you to create several tabs within your Excel spreadsheet, and label them in a specific way.

1.      In the first tab, keep an original copy of your database.  Label it “1 Original”

2.     Cut and paste the entire spreadsheet into a second tab.  For this second tab, edit it the sheet down to a list with 2 columns only:  Volcano Name and Country.  Sort this list alphabetically by Volcano Name.  Call it “2 Volcano & Country”.

3.     For the third tab, create a list with 2 columns only:  Volcano Name and Height.   Order the list from highest to lowest.   Use the equation function to find the sum total height of all the volcanoes.   Use the equation function to find the average height.  Call this tab “3 Height of Volcanos”

4.     For the fourth tab, sort the volcanos by Continent.  Call this tab “4 Volcano by Continent”

5.     For the fifth column, edit the sheet down to just Volcano and Years Since Last Eruption.  Create new column called Year of Last Eruption.  Use the equation editor to calculate the year of last eruption.  Cut and paste this formula for the 14 other volcanoes.  Sort this list and order it from most recent to most distant eruption.

6.     Save your Database, and share it with gglae@sd19.bc.ca

Earth Science 11:  Activity 14B was collected, and we did a rocks & minerals review that was collected too.  Today learned about spectroscopy, which helps astronomers determine the elements present in stars and speed of galaxies.  We finished with a year end review of Atmospheric Science.

Science 10: