Monterey Peninsula College
CHEM 1B
Dr. R. Rinehart
Use of ExcelTM Spreadsheets
One of the major goals of the CHEM 1B laboratory is for you to acquire proficiency in using the MS ExcelTM spreadsheet program for data analysis and presentation. To this end, in addition to the in-class presentations and handouts, the following links may prove useful.
| Graphical Analysis: Use of Excel
from the Chem 124 course at Cal Poly, SLO http://chemweb.calpoly.edu/chem/124/124Experiments/Graphing/XcelGraphingExp.html although they use PowerMacs there rather than PCs, the Excel basics should be largely platform-independent |
| Excel Tips by Bernard Liengme at
St Francis Xavier University, Antigonish, Nova Scotia http://people.stfx.ca/bliengme/ExcelTips.htm http://www.stfx.ca/people/bliengme/exceltips/ |
| Using Excel by Robert Zellmer at
Ohio State University http://www.chemistry.ohio-state.edu/~rzellmer/chem125/lab/exp17/exp17.htm excellent step-by-step illustrated intro |
|
Shockwave tutorials on Excel for
Windows users by Robert Belford, University of Arkansas at Little Rock |
| Graphing with Excel
Spreadsheets by James Golen at the University of Michigan-Dearborn http://www.umd.umich.edu/casl/natsci/slcweb/modules/allmodules.htm > [select module] Graphing with Excel Spreadsheets 1* http://www.umd.umich.edu/casl/natsci/slc/slconline/GRAPHEX/ Graphing with Excel Spreadsheets 2* http://www.umd.umich.edu/casl/natsci/slc/slconline/GRAPHEX2/ |
| Excel by John Walkenbach of JWalk
and Associates http://www.j-walk.com/ss/excel/index.htm http://www.j-walk.com/ss/excel/usertips/index.htm |
| General Chemistry help pages from Purdue University:
Some Common Operations in Microsoft Excel http://www.chem.purdue.edu/gchelp/tools/operate.html Constructing a Least-Squares Graph Using Microsoft Excel http://www.chem.purdue.edu/gchelp/tools/graphing.html Formatting a Graph in Microsoft Excel http://www.chem.purdue.edu/gchelp/tools/format.html |
| Using Excel for
Handling, Graphing, and Analyzing Scientific Data by Scott A. Sinex and Barbara A. Gage, Prince George's Community College, Largo, MD http://academic.pgcc.edu/psc/Excel_booklet.pdf Exploring Radioactive Decay in Excel: An Interactive Visual Thinking Tool by Scott A. Sinex http://academic.pgcc.edu/~ssinex/UCCEN_F05/UCCEN_F05.pdf lots of links to additional neat stuff!! |
| LSOFT Excel Developer's Listserv
Archives http://peach.ease.lsoft.com/archives/excel-l.html oh swell -- now they're requiring a subscription.... *&^%$#@! |
| MS Excel Spreadsheet Power-User Tips
from Beyond Technology, Inc. http://www.beyondtechnology.com/tips.shtml pull-down menu and Visual Basic for Applications info |
| Directions for
plotting in Excel by Todd A. Carlson at Grand Valley State University http://faculty.gvsu.edu/carlsont/232lab/xlsplot.htm |
| Additional Excel
references compiled by Dave Frohnapfel, Slippery Rock
University of Pennsylvania Some Online Tutorials in Using MS Excel for Chemistry: Microsoft Excel Tutorial (Covers Excel 2007) http://www.baycongroup.com/el0.htm CSU Stanislaus Excel Tutorial (has some additional notes for Mac Users) http://science.csustan.edu/tutorial/Excel/ Basic Excel tutorial http://www.usd.edu/trio/tut/excel/ Florida Gulf Coast University Excel tutorial http://www.fgcu.edu/support/office2000/excel/ Clemson University Physics Lab Excel tutorial http://phoenix.phys.clemson.edu/tutorials/excel/index.html |
| Instructions for Specific Experiments |
| EXCEL™
Workbook template for the Iodine Clock Reaction To download, right-click on the CORRECT link and choose "Save Target As..." -- save to desktop OR 'My Documents' and work on the saved copy -- DO NOT try to work on the web!!!! KINLAB07.xls KINLAB05.xls *********** Dr. Ron's Excellent Introduction to MS Excel™ general intro and specifics for the Iodine Clock Reaction: excel_pt1 additional menu bar items and tips on formatting for a better-looking document: excel_pt2 Be sure to include descriptive headers in which your name should appear! |
| EXCEL™
Workbook template for the Temperature Dependence of the
Oscillating Reaction To download, right-click on the CORRECT link and choose "Save Target As..." -- save to desktop OR 'My Documents' and work on the saved copy -- DO NOT try to work on the web!!!! Osctmp09.xls Osctmp08.xls Osctmp07.xls Osctmp06.xls Be sure to include descriptive headers in which your name should appear! You will also want to look over the following before the computer lab session Dr. Ron's Quick and Dirty Guide to Creating and Using Charts in Excel™ exclchrt |
| EXCEL™
Workbook template for the Spectrophotometric Keq
lab To download, right-click on the CORRECT link and choose "Save Target As..." -- save to desktop OR 'My Documents' and work on the saved copy -- DO NOT try to work on the web!!!! specKq07.xls specKq06.xls Be sure to include descriptive headers in which your name should appear! |
| EXCEL™ Workbook template
for the Ka determination lab To download, right-click on the link and choose "Save Target As..." -- save to desktop OR 'My Documents' and work on the saved copy -- DO NOT try to work on the web!!!! Ka_su09 At this point in the course, you are expected to know how to proceed on your own! Use full-size charts and format appropriately. Be sure to include descriptive headers in which your name should appear! |
| Here is an
EXCEL™ Workbook
containing raw data
for the titration curve lab To download, right-click on the link and choose "Save Target As..." -- save to desktop OR 'My Documents' and work on the saved copy -- DO NOT try to work on the web!!!! titradata07.xls At this point in the course, you are expected to know how to proceed on your own! Use full-size charts and format appropriately. Be sure to include descriptive headers in which your name should appear! |
© Ronald W. Rinehart, 2003-2009