Scaling Galileo's Solar System - Size of the Globes


In this module, students determine the sizes of the various planets in the solar system scaled such that the orbit of Saturn fits on campus. The students also compare the planet sizes, given the scale, to the grain sizes of different sediment types. Students recreate spreadsheets shown in the Powerpoint module on their own with formulas that answer various pieces of the overall question. This modules is the second in a series of four on the Galilean Solar System.

Learning Goals

  • Answer questions about the sizes of the planets and moons given a particular proportion scale.
  • Work with the Wentworth scale of particle sizes.
  • Learn specialized Excel commands for sorting and logic functions

Context for Use

This module was designed to be used in an undergraduate mathematical geology class where students are asked to look at geological questions mathematically and may spend more time on the math than on the geology.

Description and Teaching Materials

This module is one of several developed by Dr. Vacher. The module presentation can be found at

The Powerpoint file is considered to be the student version. There is also an instructor's version that has active spreadsheets in it. There are instructions for requesting this version on the website.

Teaching Notes and Tips

These modules were developed as essentially self-paced, take-home lab assignments. Students are supposed to work through the modules, slide by slide, building their own worksheets as they go along, taking note of instructions and prompts, hints, and queries.

Students must have access to computers equipped with a spreadsheet program such as Excel.


The easiest way to test student work on this module is to ask students to hand in a copy of their worksheets starting with a different set of input data. The module also ends with homework assignment questions.

References and Resources