Petrology > Teaching Activities > Calculating Compositional Variation and Common Substitutions for Igneous and Metamorphic Minerals

Calculating Compositional Variation and Common Substitutions for Igneous and Metamorphic Minerals

David Mogk
Department of Earth Sciences, Montana State University
Author Profile

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

Resources in this top level collection a) must have scored Exemplary or Very Good in all five review categories, and must also rate as “Exemplary” in at least three of the five categories. The five categories included in the peer review 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

This page first made public: Apr 29, 2008


This problem set uses Excel spreadsheets to calculate mineral formulae from analytical data (typically from the electron microprobe) using a variety of formulations that assume numerous variations of crystal chemical constraints. Ferric iron is recalculated based on charge balance and stoichiometry. End members and mole fractions are also calculated in many instances.

Used this activity? Share your experiences and modifications



This problem set can be used in introductory mineralogy courses, igneous or metamorphic petrology, or general geochemistry courses for geoscience majors.

Skills and concepts that students must have mastered

Students must have a basic understanding of stoichiometry and charge balance, and a basic understanding of Pauling's Rules of crystal chemistry, mineral structural formulae, and site occupancy is also helpful.

How the activity is situated in the course

This activity can be used as a stand-alone exercise to demonstrate how we derive mineral chemical formulae from compositional data, or it can be used as a first step in more advanced petrology courses to determine mole fraction of components or end members for further applications such as geothermobarometry.


Content/concepts goals for this activity

Higher order thinking skills goals for this activity

Higher order thinking skills include the ability to critically evaluate a) the quality of mineral composition data, and b) the applicability of various recalculation models.

Other skills goals for this activity

Additional skills include using spreadsheets to obtain quantitative results, and use of appropriate graphs to represent compositional variations in families of minerals.

Description of the activity/assignment

This exercise uses a number of Excel spreadsheets to calculate mineral formulae from compositional (microprobe) data. Numerous computational models are presented for most mineral groups (e.g. amphiboles, pyroxenes, micas), and students must critically evaluate which of these models is most applicable. Stoichiometry and charge balance are used to determine ferric/ferrous ratios–which is important for further applications such as geothermobarometry. Students are also asked directed questions about: compositional variation of the rock-forming mineral groups; representative complete, limited, and coupled solid solutions; site occupancy of major elements, as determined by the various computational models used; graphical representation of the calculated mineral formulae; and the composition and significance of certain varieties of these rock-forming minerals are addressed.

Determining whether students have met the goals

The problem consists of a series of short-answer questions on a worksheet, and accompanying X-Y and ternary plots. Short answers and graphical representation of data can readily be evaluated for accuracy, completeness (of descriptions), and thoroughness of responses.

More information about assessment tools and techniques.

Download teaching materials and tips

Other Materials

Supporting references/URLs

This exercise is part of the Teaching Phase Equilibria module.

See the module on Plotting Mineral Compositions and Chemographic Projections - from Teaching Phase Equilibria.

See more Teaching Activities »