Microsoft Excel Basic Tutorial
Initial Publication Date: July 2, 2010
Summary
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.
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
Teaching Notes and Tips
empty
Share your modifications and improvements to this activity through the Community Contribution Tool »
Assessment
Proficiency in Excel on later work.
References and Resources
empty