InTeGrate Modules and Courses >Coastal Processes, Hazards and Society > Overview > Refreshers and Tutorials > Tutorial: Excel Spreadsheets
 Earth-focused Modules and Courses for the Undergraduate Classroom
showLearn More
These materials are part of a collection of classroom-tested modules and courses developed by InTeGrate. The materials engage students in understanding the earth system as it intertwines with key societal issues. The materials are free and ready to be adapted by undergraduate educators across a range of courses including: general education or majors courses in Earth-focused disciplines such as geoscience or environmental science, social science, engineering, and other sciences, as well as courses for interdisciplinary programs.
Explore the Collection »
How to Use »

New to InTeGrate?

Learn how to incorporate these teaching materials into your class.

  • Find out what's included with each module
  • Learn how it can be adapted to work in your classroom
  • See how your peers at hundreds of colleges and university across the country have used these materials to engage their students

How To Use InTeGrate Materials »
show Download
The instructor material for this module are available for offline viewing below. Downloadable versions of the student materials are available from this location on the student materials pages. Learn more about using the different versions of InTeGrate materials »

Download a PDF of all web pages for the instructor's materials

Download a zip file that includes all the web pages and downloadable files from the instructor's materials
Initial Publication Date: March 13, 2018

Tutorial: Excel Spreadsheets

In several places in this class you will be expected to make plots in Microsoft Excel. If you do not feel comfortable that you are able to do this, please watch the video below. A word of caution — this video shows a much older version of Excel, so don't expect your screen to look exactly like the one in the video.


Next, produce a single plot of month (1=Jan, 12=Dec) versus both 24-hour average temperature and average rainfall for State College:

State College Average 24-Hour Temperature (link is external)

State College Average Rainfall (link is external)

Make sure you can generate these plots (you'll be asked to do this kind of thing throughout the class), but you do not need to turn anything in.

Already used some of these materials in a course?
Let us know and join the discussion »

Considering using these materials with your students?
Get advice for using GETSI modules in your courses »
Get pointers and learn about how it's working for your peers in their classrooms »

These materials are part of a collection of classroom-tested modules and courses developed by InTeGrate. The materials engage students in understanding the earth system as it intertwines with key societal issues. The collection is freely available and ready to be adapted by undergraduate educators across a range of courses including: general education or majors courses in Earth-focused disciplines such as geoscience or environmental science, social science, engineering, and other sciences, as well as courses for interdisciplinary programs.
Explore the Collection »