Skip to: Otterbein Home | Chemistry Home | DHJ Home
Course Materials
Excel Files for Analytical Chemistry
- distributions.xls - plots two normal distributions and confidence intervals for any means, standard deviations, values of n, etc.
- ttest1.xls - several examples of using the t-test.
- driving.xls - shows calculation of slope, standard errors, and confidence intervals (by "by hand" and using the built-in Excel regression analysis)
- regress1.xls - shows examples of calculating best fit lines and correlation coefficients for linear data.
- ppt_titrate.xls - adapted from Harris, this spreadsheet calculates a precipitation titration curve for AgI and AgBr (class example). It also demonstrates the the use of Excel for endpoint determination.
- activity.xls - three example worksheets showing the effect of ionic strength on pH and solubility.
- polyprotic.xls - three worksheets with many graphs - includes calculation of the pH of weak acids, fractional composition and buffers.
- ab_titration.xls - calculation and comparison of weak acid-strong base titrations (from Harris) and an example Gran Plot.
Visualization of Crystalline Structures Using MAGE
This work has been published in the online journal The Chemical Educator (Vol. 2, No. 3). The supporting files may be downloaded individually or as packages using the links below.
Individual tutorial modules
- unitcell.kin - A tutorial on different types of unit cells and the importance of lattice-point sharing. Several pseudo-animations show the construction of larger lattices from several unit cells
- clospack.kin - Contains spacefill and ball & stick images of both hexagonal and cubic closepacked arrays, emphasizing AB and ABC layers
- holes.kin - Contains pseudo-animations illustrating filling of tetrahedral, octahedral, and cubic holes
Individual example modules
- tetfill.kin - structures based on filling of tetrahedral holes
- octfill.kin - structures based on filling of octahedral holes
- cubic.kin - structures based on cubic lattices and filling of cubic holes
- silicate.kin - common structural themes found in silicate structures (SiO4 tetrahedra sharing vertices)
- complex.kin - larger and more complex structures such as spinel, alumina, etc.
- bravais.kin - the 14 Bravais lattices illustrated as ball & stick models
MAGE modules packages and documenation
- magefile.zip - all the individual modules listed above in ".zip" format
- magehtml.zip - an example HTML page w/supporting files in ".zip" format
- magefile.sea.hqx - all the individual modules listed above as a binhexed self-extracting file
- magehtml.sea.hqx - an example HTML page w/supporting files as a binhexed self-extracting file
- magetut.doc - a quick MAGE tutorial in Word 6.0/95 format