Click on titles below to see the corresponding lecture and lab handouts.
For Summer 2004
FYI:
Using Excel - A primer for using
spreadsheets for
manipulating, graphing and analyzing data.
Using Excel - Appendix 1 - How to convert
delimited files into a spreadsheet; how to sort data.
Files containing information on various functions in Excel that will
be useful (Note that these files are password protected - I will provide the
password in class):
>> A list of useful functions
>> Excel help file information on selected statistical
functions (~5MB file)
>> Excel help file information on selected mathematical
functions
>> Excel help file information on other selected functions
>> Excel help file information about the Statistical Analysis
Toolpack (FYI)
From Previous Semesters
Sampling communities and estimating species diversity - for lab on Thursday 8 November. A 25-pt graded assignment will be associated with this lab.
Using Statistics - a series of handouts describing how to use SPSS for statistical analyses, and how to interpret output of analyses. You are to work through the statistical tests described in the handout on your own before next Tuesday (18 Sept 2001). SPSS is available on all of the computers on campus. A disk with the SPSS data files that you will need in order to complete the exercise will be available at the Biology Department Office (SCI-358G). I will also try to send all of you an e-mail to which I will attach the files - you should save them to a disk that you can then take with you to a computer on campus.
Detecting Ecological Patterns - For lab on R 30 Aug 2001
Field & Laboratory Notebook - Guidelines and
grading criteria.
Some other views about lab notebooks (You
should take a look at these pages, too.)