This page provides the user with seven lessons explaining the use of spreadsheets for numerical modeling. Modern spreadsheets provide a rich environment for numerical calculation and the exploration of numerical models. Adding to the power of the environment, spreadsheets provide a great many built-in functions to perform commonly used computations in the financial, statistical, and other problem domains. Once calculations are performed, spreadsheets offer the opportunity to explore graphical interpretations of the results through a number of built-in chart and graph types. These pictorial interpretations often provide insights into the meaning of a calculation that would otherwise be difficult to perceive or that may even go unnoticed. The particular spreadsheet the user will learn about in these seven lessons is Microsoft Excel. Lessons include an overview of the Excel environment, using formulas for Excel calculations, using Excel's built-in functions, problem parameters and absolute addressing, charts and graphs in Excel, making decisions in Excel, and an Excel project.
This description of a site outside SERC has not been vetted by SERC staff and may be incomplete or incorrect. If you
have information we can use to flesh out or correct this record let us know.
Part of the Starting Point collection. The Starting Point collection includes resources addressing the needs of faculty and graduate students designing, developing, and delivering entry-level undergraduate courses in geoscience.
