This problem set introduces some of the more advanced uses of Excel to not only calculate how the chemistry of a magma changes with crystallization but also to see how the liquidus assemblage can drastically change the evolution of the remaining magma. Once they have their calculations complete, students plot the results and answer questions on the geochemical trends observed through the crystallization sequence. This problem set reinforces quantitative problem solving skills using a spreadsheet and has the students think about mineralogical controls on magma evolution. This exercise is modified from one that Clark Johnson assigned at University of Wisconsin. I find this exercise to be more instructive for some of the tricks and tools in Excel, but there are some interesting questions that can derive from it. This assignment is often the first time the light goes on that you can end up with different composition magmas depending on what minerals are crystallizing, and that depends on the pressure of crystallization. There are many more questions that could be asked, such as where does this model fall short? What could be added or considered to make this a more realistic simulation of fractionation (more trace elements or REE).


    Education Levels:

    • Grade 1
    • Grade 2
    • Grade 3
    • Grade 4
    • Grade 5
    • Grade 6
    • Grade 7
    • Grade 8
    • Grade 9
    • Grade 10
    • Grade 11
    • Grade 12


    Elements,NSDL_SetSpec_380601,Chemistry,Geology,Geochemical Analysis,Undergraduate (Upper Division),Undergraduate (Lower Division),Igneous Processes,Higher Education,Geochemistry,Vocational/Professional Development Education,oai:nsdl.org:2200/20100502200823175T,Geoscience,NSDL



    Access Privileges:

    Public - Available to anyone

    License Deed:

    Creative Commons Attribution Non-Commercial Share Alike


    This resource has not yet been aligned.
    Curriki Rating
    'NR' - This resource has not been rated
    'NR' - This resource has not been rated

    This resource has not yet been reviewed.

    Not Rated Yet.

    Non-profit Tax ID # 203478467