Cutting Edge > Courses > Petrology > Teaching Activities > Learning Thermodynamics and Using Spreadsheets

Learning Thermodynamics and Using Spreadsheets

Sumit Chakraborty and Somnath Dasgupta
,
Institut fuer Geologie, Mineralogie and Geophysik and Jadavpur University, Kolkata, India
Author Profile

This activity was selected for the On the Cutting Edge Reviewed Teaching Collection

This activity has received positive reviews in a peer review process involving five review categories. The five categories included in the process are

  • Scientific Accuracy
  • Alignment of Learning Goals, Activities, and Assessments
  • Pedagogic Effectiveness
  • Robustness (usability and dependability of all components)
  • Completeness of the ActivitySheet web page

For more information about the peer review process itself, please see http://serc.carleton.edu/NAGTWorkshops/review.html.


This page first made public: Jul 18, 2008

Summary

These files contain a set of three Excel files to balance mineral reactions, to explore variation of thermodynamic properties as a function of P, T and composition and to explore stability of different mineral reactions using the popular thermodynamic databases of Berman and Holland and Powell. A set of instructions as well as some suggested exercises are included as Word files.

Used this activity? Share your experiences and modifications

Context

Audience

This activity is designed for a sophomore or junior level required course in petrology.

Skills and concepts that students must have mastered

How the activity is situated in the course

Goals

Content/concepts goals for this activity

This exercise uses Excel files to aid students in their ability to balance mineral reactions, to explore variation of thermodynamic properties as a function of P, T and composition and to explore stability of different mineral reactions using the popular thermodynamic databases of Berman and Holland and Powell.

Higher order thinking skills goals for this activity

This activity involves data analysis.

Other skills goals for this activity

This activity should aid in students' ability to use Excel.

Description of the activity/assignment

These files contain a set of three Excel files to balance mineral reactions, to explore variation of thermodynamic properties as a function of P, T and composition and to explore stability of different mineral reactions using the popular thermodynamic databases of Berman and Holland and Powell. A set of instructions as well as some suggested exercises are included as Word files. This allows students with little knowledge of thermodynamics to explore stability quantitatively (e.g. to see what metastable and stable mean); students learning thermodynamics can see the workings of the databases from the "inside" and explore various properties including thermodynamic mixing behavior and non-ideality using simple models. The material can be used to accompany students from fairly introductory courses to advanced thermodynamics courses.

Determining whether students have met the goals

The goals of this activity are met if students answer the questions in the problem set accurately and thoroughly.

More information about assessment tools and techniques.

Download teaching materials and tips

Other Materials

See more Teaching Activities »