|NOAA Portsmouth Harbor Bathymetry|
- Collect depth data in rectangular grid patterns across the mystery boxes
- Draw and colorize isobaths (lines of equal depth) to delineate areas of similar depth
- Identify names of the ocean features found inside the mystery boxes
- Create 3D surface charts from the data to finally "see" what's inside the mystery boxes
To create the final 3D bathymetric chart, students enter their data into Microsoft Excel and use the surface chart option to visualize a realistic model of their original mystery box. Just as we cannot lift the ocean to see the features below, students may never open the mystery boxes to see what's inside—they are reliant upon their data and 3D models to "see" the ocean floor.
The process for creating a 3D surface chart in Microsoft Excel (2007 and 2010 versions) is outlined as follows:
- Type in all of the bathymetry data (including grid numbers) and select it
- Go to Insert tab on the ribbon
- Click "Other Charts" and select "3D Surface Chart"
- Move Chart to "New Sheet"
- Right-click the vertical (value) axis and choose "Format Axis"
- Change Maximum to "Fixed" and enter the maximum data value
- Change Minimum to 0 (sea level)
- Change Major Unit to "Fixed" and enter a value of 5.0 (the isobath interval)
- Check the "Values in Reverse Order" box
- Check the "Categories in Reverse Order" box
- Use the arrows and options to adjust the chart to a nice view
- Right-click that color and choose "Format Band"
- Experiment with either the Solid Fill or the Gradient Fill to create a nice blend of colors from deep to shallow