Quantitative Skills > Teaching Resources > Activities > GLACPRO Model

Spreadsheet modeling of former glaciation in research mode

Bill Locke
Author Profile


GLACPRO is the fourth in a sequence of spreadsheet modeling exercises (SCARP, SCARP2, LONGPRO). It is a simple model that can be applied to answer a research question that may not yet have been addressed in print; it is thus a transition to senior- or graduate-level work.

Specifically, in the GLACPRO exercise student teams (1-3 members) use a numerical model to reconstruct a former glacial flowline from moraines to source. They must interact with teams studying adjacent flowlines to accurately place ice divides. They can calculate average thicknesses, volumes, ice loading, and sea level equivalent from the class model.

In the past, I have used this method to reconstruct the former ice cover of Yellowstone, the Bitterroot Mountains, the San Juans, Sierra Nevada, and numerous other glaciated regions.

Learning Goals

Context for Use

Description and Teaching Materials

Teaching Notes and Tips

Link to Word file of GLACPRO instructors notes, student pitfalls, and scoring/gradin rubric (Microsoft Word 68kB Jul8 05)


Assessment suggestions are included with instructors notes.

References and Resources

See more Activities »