These descriptions are directly from students who turned in their descriptions. It is up to you to decide how useful they are to you. In my previous post, I suggested using the Famosa Slough web site to help make conclusions about those sites.
US Famosa Slough Sites
US San Diego Bay Sites
Friday, November 16, 2007
Using Excel for water quality analysis
Using Excel for water quality data:
1) First make sure that you have downloaded the water quality data in an Excel file so that you can manipulate the data.
2) Highlight the entire sheet by clicking on the upper left hand corner.
3) Go to “Data” menu then “sort” and choose the Mexico Sample # column or US sample area.
4) Separate the samples areas by inserting lines between them. Highlight the row just below the last row of one sample area, right click and go to insert. Ctrl “Y” will insert another row.
5) BEFORE you find the averages, you must look at the data and get MY approval to ignore any outliers.
6) Remove the approved outliers from the data set by clearing those cells.
7) To find averages, go to an empty cell below the measure, go to “Insert” menu and then “Insert function” select AVERAGE. This will place the function in that cell. You then need to highlight the cell that you want to take the average of. Once you have the first function inserted for that row, just right click that cell, copy it and paste all the way down the row.
8) Repeat step 5 for each of the sample areas.
9) Print out the data tables (US and Mexico) with all of your calculations and turn it in with your group’s analysis.
10) View the observed comments on each area to help you distinguish between the sites in the US. The Famosa Slough web site has a map with their official water testing sites. We stayed pretty close to those so you can use those pictures and descriptions to help you in your analysis.
1) First make sure that you have downloaded the water quality data in an Excel file so that you can manipulate the data.
2) Highlight the entire sheet by clicking on the upper left hand corner.
3) Go to “Data” menu then “sort” and choose the Mexico Sample # column or US sample area.
4) Separate the samples areas by inserting lines between them. Highlight the row just below the last row of one sample area, right click and go to insert. Ctrl “Y” will insert another row.
5) BEFORE you find the averages, you must look at the data and get MY approval to ignore any outliers.
6) Remove the approved outliers from the data set by clearing those cells.
7) To find averages, go to an empty cell below the measure, go to “Insert” menu and then “Insert function” select AVERAGE. This will place the function in that cell. You then need to highlight the cell that you want to take the average of. Once you have the first function inserted for that row, just right click that cell, copy it and paste all the way down the row.
8) Repeat step 5 for each of the sample areas.
9) Print out the data tables (US and Mexico) with all of your calculations and turn it in with your group’s analysis.
10) View the observed comments on each area to help you distinguish between the sites in the US. The Famosa Slough web site has a map with their official water testing sites. We stayed pretty close to those so you can use those pictures and descriptions to help you in your analysis.
Wednesday, November 14, 2007
Water Quality Analysis Data
Following the link below for the Excel file with the water quality data. Please NOTE: There are two tabs in the Excel file. One labeled Mexico and the other labeled US. For ease of use, I separated the Mexico data onto a different sheet in Excel. I also made the header rows freeze and print on each page. If you have any questions on how to manipulate the Excel file for your analysis, don't hesitate to ask.
Water Quality Data
Water Quality Data
Tuesday, November 13, 2007
Water Quality Analysis
Due Tuesday: You must submit your data for the Mexican water samples and the US water samples in an Excel file. This must be done on an individual basis. I will compile the data and make it available to you on Wednesday.
Due Monday morning (11/25/07): Your complete water analysis (informal, formal and overall discussion) is due by 9 am. One analysis per Beyond the Border group is expected. Even though you are turning in a group analysis, each member of the group is responsible for the information and will need to be able to present it as part of their POL.
Link to PDF of Guidelines for Water Quality Analysis
Due Monday morning (11/25/07): Your complete water analysis (informal, formal and overall discussion) is due by 9 am. One analysis per Beyond the Border group is expected. Even though you are turning in a group analysis, each member of the group is responsible for the information and will need to be able to present it as part of their POL.
Link to PDF of Guidelines for Water Quality Analysis
Math Before Thanksgiving
CPM Math: Your packet that includes pages 334, 335, 340 & 341 with the extra practice on triangle similarities is due at the end of the day on Friday. When you are done, you can do the take home quiz on triangle similarities.
Exeter group: Page 11 of Exeter is due at the end of the day on Friday- neat but not in ink. When you are done with Exeter, you can do the take home quiz on triangle similarities.
Exeter group: Page 11 of Exeter is due at the end of the day on Friday- neat but not in ink. When you are done with Exeter, you can do the take home quiz on triangle similarities.
Subscribe to:
Comments (Atom)