Quantitative Skills > Teaching Resources > Activities > SCARP2 Model

Mid-level spreadsheeting and complex modeling of real-world scarp evolution

Bill Locke
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 http://serc.carleton.edu/NAGTWorkshops/review.html.

This page first made public: Oct 23, 2009


SCARP2 is the second in a sequence of spreadsheet modeling exercises (SCARP, LONGPRO, and GLACPRO).

This exercise is a second or familiarization exercise in spreadsheeting, but is also a mathematical model for slope evolution. It uses the concept of "erosivity" (generally, the relative ratio of driving and resisting forces) and slope angle to reshape an initial topography. Finally, it asks the students themselves to come up with a real-world situation worth modeling.

Learning Goals

  1. To familiarize students with moderately complex Excel??? manipulations
  2. To reinforce good technical graphical techniques, and
  3. To introduce basic mathematical modeling of natural systems

Context for Use

Description and Teaching Materials

Teaching Notes and Tips


See Instructors Notes for assessment suggestions.

References and Resources

See more Activities »