Spreadsheet Resources on the Internet
(Note: All links on this page open in a new window)
These tutorials focus on the use of Excel for physics students. But they are very well done and are of use to students using Excel in any science course.
Lynda.com provides software training (narrated movies you watch on your computer) for a wide range of software products including Microsoft Excel. These are commercial products that must be purchased, but if you need to learn a software product quickly, this is one way you might do it.
Data Sets
As a digital student you have access via the Internet to a wealth of data. You can use data you find on the net to learn about statistical and data analysis techniques. And you can even find data sets that can be used to conduct your own analysis based on your own hypotheses. We've listed a few of the best sources of data here:
Nine interesting data sets along with a detailed description of the analysis done by the original investigator. If you are having trouble understanding a statistical concept or technique, find the case study on this site that demonstrates that technique and follow along.
A large and well-known collection of data set along with descriptions of what the data represents (the stories).
Dozens of links to web sites with data sets you can use.
Hundreds of data sets, mostly from the social sciences
Books:
If you are using Excel for data analysis, or math modeling, these books might also prove to be worthwhile.
How to use Excel in analytical chemistry and in general scientific data analysis Robert de Levie - This book is available online in the Empire State College Library.
R. de Levie, Advanced Excel for scientific data analysis, Oxford University Press, New York (2004) 625 pages
Erich Neuwirth, Deane Arganbright, The Active Modeler: Mathematical Modeling with Microsoft Excel, Thompson, Brooks Cole (2004)
|
