Starting Point-Teaching Entry Level Geoscience > Teaching with Data > Browse Examples > Microsoft Excel Basic Tutorial
Explore Teaching Examples | Provide Feedback

Microsoft Excel Basic Tutorial

Dave Hirsch, Western Washington University
Author Profile


This assignment walks students through the creation of an Excel spreadsheet, step by step. It includes numerical fills via copy, creation of fixed and relative formulas, formula fill via copy, and some summary functions.

Learning Goals

Students will become proficient with spreadsheet use.

Context for Use

Audience: Non-majors course and undergrad mineralogy/petrology
Necessary Knowledge: Basic computer skills.
Situated in Course: For non-majors course it is assigned prior to other work that requires calculations. For the majors courses, it is given as an optional assignment along with a geological assignment that uses Excel, to be used at the student's discretion if he/she is not conversant with Excel, or needs a refresher.

Teaching Materials

Excel Tutorial Assignment (Acrobat (PDF) 98kB Jun28 10)

Teaching Notes and Tips



Proficiency in Excel on later work.

References and Resources




Resource Type

Datasets and Tools:Datasets with Teaching Activities, Activities:Lab Activity, Problem Set

Special Interest

Data, models, or simulations:Data

Grade Level

College Lower (13-14):Introductory Level

See more Browse Examples »