SSAC Geology of National Parks Modules

This material is based upon work supported by the National Science Foundation under Grant Number NSF DUE-0836566. Any opinions, findings, and conclusions or recommendations expressed in this material are those of the author(s) and do not necessarily reflect the views of the National Science Foundation.

Following are short descriptions of the available modules. To access any of them, select from the list and you will connect to cover material including learning goals, context of use, and other information. Within the cover material (under "Teaching Materials") there is a link by which you can download the student version of the module. You can also request an instructor's version by clicking on the "Instructor Module Request Form" link under Teaching Materials.

To find content, use the search box for a full text search of title, author, and text of the cover pages of the modules. Refined results can be seen in the boxes on the right side of the page. There are 26 modules currently in the collection.

Help

Show all pages

Current Search Limits

Excel Skills

showing only Other Manipulations and Functions Show all Excel Skills
Refine the Results

Excel Skills Show all Excel Skills

Results 1 - 3 of 3 matches

Mapping Coastal Vulnerability to Sea-Level Rise at Point Reyes National Seashore part of Pedagogy in Action:Partners::Examples
Module by: Len Vacher, University of South Florida Cover Page by: Len Vacher and Denise Davis, University of South Florida
Spreadsheets Across the Curriculum/Geology of National Parks module. Students work with a color-coded conditional-formatted spreadsheet map to work through a USGS report applying a coastal vulnerability index.

Quantitative Concepts: Basic arithmetic; Number sense, :Average; weighted average, Rates, Number operations:Number operations: addition, subtraction, multiplication, division
Excel Skills: Other Manipulations and Functions:Data/Sort, Statistical Functions:One array:AVERAGE, Other Manipulations and Functions, Basic Arithmetic, Statistical Functions
Subject: Earth & Space Science:Atmospheric & Climate Science:Climate Change, Earth & Space Science:Oceanography, Atmospheric & Climate Science, Environmental Science:Global Change & Climate, Environmental Science, Earth & Space Science

Spreadsheet Warm Up for SSAC Geology of National Parks Modules, 2: Elementary Spreadsheet Manipulations and Graphing Tasks part of Pedagogy in Action:Partners::Examples
Module by: Dorien McGee, Meghan Lindsay, Len Vacher, University of South Florida Cover Page by: Len Vacher and Denise Davis, University of South Florida
Spreadsheets Across the Curriculum/Geology of National Parks module. The second of two tutorials. Focuses on modifying spreadsheets (e.g., copy/paste, insert, sort) and creating and modifying graphs.

Quantitative Concepts: Measurement; Data presentation and analysis; Probability:Visual display of data :Bar graphs; column graphs; stacked bar graphs, Pie charts, Line graphs, Measurement; Data presentation and analysis; Probability:Visual display of data , Visual display of data :XY scatter plots
Excel Skills: Graphs and Charts:Pie Chart, Line Graph, Bar Graph, XY Scatterplot, Other Manipulations and Functions:Data/Sort

Nitrate Levels in the Rock Creek Park Watershed, Washington DC, 2: Variability part of Pedagogy in Action:Partners::Examples
Module by: Mark C. Rains and Len Vacher, University of South Florida Marian Norris, National Parks Service, Center for Urban Ecology Cover Page by: Len Vacher and Denise Davis, University of South Florida
Spreadsheets Across the Curriculum module/Geology of National Parks course. Students calculate standard deviation and z-values to examine a possible outlier in a positively skewed data set.

Quantitative Concepts: Measurement; Data presentation and analysis; Probability:Descriptive statistics; trend lines , Basic arithmetic; Number sense, :Comparisons; percent difference, change, increase, Number operations:Number operations: addition, subtraction, multiplication, division, Basic arithmetic; Number sense:Average; weighted average, Measurement; Data presentation and analysis; Probability:Visual display of data :XY scatter plots, Measurement; Data presentation and analysis; Probability:Visual display of data , Descriptive statistics; trend lines :Median; mode, Quartiles; percentiles, Standard deviation; variance; range, Mean, Measurement; Data presentation and analysis; Probability
Excel Skills: Other Manipulations and Functions, Graphs and Charts, Statistical Functions:One array:MEDIAN, MAX, MIN, etc, VAR, VARP, etc, MODE, Statistical Functions:One array, Graphs and Charts:XY Scatterplot, Statistical Functions:One array:STDEV, STDEVP, etc, AVERAGE, Basic Arithmetic:Percent (format), Simple Formulas, Basic Arithmetic, Statistical Functions:One array:COUNT, COUNTA, Statistical Functions
Subject: Environmental Science:Ecosystem Monitoring, Resource Use & Consequences, Resource Use & Consequences:Water Quality & Quantity, Environmental Science, Earth & Space Science

Home | About the Center | Campus Visits | Events | Projects | Publications

washcenterevergreen.edu
(360) 867-5611