HR: 0830h
AN: ED41C-1182    [PDF]
TI: Using Spreadsheets and Internally Consistent Databases to Explore Thermodynamics
AU: Dasgupta, S
EM: sdg@cal3.vsnl.net.in
AF: Department of Geological Sciences, Jadavpur University, Kolkata, 700032 India
AU: * Chakraborty, S
EM: Sumit.Chakraborty@ruhr-uni-bochum.de
AF: Institut fuer Geologie, Mineralogie und Geophysik, Ruhr-Universitaet Bochum, Bochum, 44801 Germany
AB: Much common wisdom has been handed down to generations of petrology students in words - a non-exhaustive list may include (a) do not mix data from two different thermodynamic databases, (b) use of different heat capacity functions or extrapolation beyond the P-T range of fit can have disastrous results, (c) consideration of errors in thermodynamic calculations is crucial, (d) consideration of non-ideality, interaction parameters etc. are important in some cases, but not in others. Actual calculations to demonstrate these effects were either too laborious, tedious, time consuming or involved elaborate computer programming beyond the reaches of the average undergraduate. We have produced "Live" thermodynamic tables in the form of Excel$^{TM}$ spreadsheets based on standard internally consistent thermodynamic databases (e.g. Berman, Holland and Powell) that allow quick, easy and most importantly, transparent manipulation of thermodynamic data to calculate mineral stabilities and to explore the role of different parameters. We have intentionally avoided the use of advanced tools such as macros, and have set up columns of data that are easy to relate to thermodynamic relationships to enhance transparency. The approach consists of the following basic steps: (i) use a simple supporting spreadsheet to enter mineral compositions (in formula units) to obtain a balanced reaction by matrix inversion. (ii) enter the stoichiometry of this reaction in a designated space and a P and T to get the delta G of the reaction (iii) vary P and or T to locate equilibrium through a change of sign of delta G. These results can be collected to explore practically any problem of chemical equilibrium and mineral stability. Some of our favorites include (a) hierarchical addition of complexity to equilibrium calculations - start with a simple end member reaction ignoring heat capacity and volume derivatives, add the effects of these, followed by addition of compositional effects in the form of ideal solutions, add non-ideality next and finally, explore the role of varying parameters in simple models of non-ideality. (b) Arbitrarily change (i.e. simulate error) or mix data from different sources to see the consequences directly. More traditional exercises such as exploration of slopes of reaction in P-T space are trivial, and other thermodynamic tidbits such as "bigger the mineral formula, greater its thermodynamic weight" become apparent to undergraduates early on through such direct handling of data. The overall outcome is a far more quantitative appreciation of mineral stabilities and thermodynamic variables without actually doing any Math!
DE: 3640 Igneous petrology
DE: 3660 Metamorphic petrology
SC: Education and Human Resources [ED]
MN: 2003 Fall Meeting