Excel Investigation Resources

Is Pluto a Planet?

• Is Pluto a Planet? (Microsoft Word 116kB Jul12 06)

  A sample DataTools Investigtion using Excel to investigate the characteristics of the now eight planets, plus Pluto, and various Kuiper Belt Objects. Students develop an arguement for or against the classification of Pluto as a planet. Right-click on a PC or control-click on a MAC to download the investigation from the link above.
  

• Kuiper Belt Objects and Planets Spreadsheet (Excel 49kB Jul12 06)

  The dataset for "Is Pluto a Planet?" Right-click on a PC or control-click on a MAC to download the Excel spreadsheet from the link above.
  

• Definitions of Terms (Microsoft Word 34kB Jul12 06)

  The metadata for Is "Pluto a Planet?" Right-click on a PC or control-click on a MAC to download the Word file from the link above.
  

• Planetary Fact Sheets at NASA

  The link above (http://nssdc.gsfc.nasa.gov/planetary/planetfact.html) has great data about our solar system's planets and moons.
  

• About Apparent Visual Magnitude (Microsoft Word 44kB Jul12 06)

This Word file provides background information. Right-click on a PC or control-click on a MAC to download the file from the link above.

Sunrise_Sunset Excel sheet (Excel 40kB Jul12 06)

This Excel spreadsheet holds the times for sunrise and sunset for Boston. It also shows the graph. Right-click on a PC or control-click on a MAC to download the Excel spreadsheet from the link above.

Putting Hurricanes on the Calendar

This EarthLabs lesson uses the HURDAT database: NOAA's official record of tropical storms and hurricanes. Users import the data into Excel and write COUNTIF formulas to identify the dates of hurricane season.