Addressing Scientific Questions with Spreadsheets
Part I

Introduction

    -  What is a spreadsheet?  What is it good for?
    -  What are some of the spreadsheets available for Macintosh and Windows 95 machines?
    -  How are spreadsheets used in science?
 

Basic Operation of Microsoft Excel to Understand Geologic Problems

    -  Example of Microsoft Excel for analyzing physical processes- The Spanish Peaks and pressurized magma chambers.
    -  Transformation of data:  Coordinate System Rotations and Translations.
 

Basic Spreadsheet Commands:

    -  Entering Numeric Values.
    -  Entering String Values.
    -  Entering Equations
    -  Naming Variables
    -  Referring to other cells
        -  Absolute vs. Relative References
 

Visualizing Data-- Plots in Excel

    -  Creating Bar Charts
    -  Creating X-Y Charts
    -  Creating contour and surface charts
    -  Changing the axis units
    -  Creating a title
    -  Creating a legend
    -  Creating axis labels
 

Parsing Text Files in Excel

    -  What does parsing do?
    -  Removing headers from files
    -  Specifying how to import the data
 

Formatting Numbers in Excel

    -  Specifying number format
    -  Specifying number of significant digits in problem
 
 


Pages maintained by
Prof. Ramón Arrowsmith

Pages last modified on Tues Sept 23 1997.