University of Virginia
Physics Department

Sonar - Bathymetry

A Physical Science Activity

Student Activity

Materials

 

Procedure

  1. Open the sonar data file in Microsoft Excel. The sonar data file contains a spreadsheet with data, and a sample output graph for "Lake Katie." The data is arranged in a grid, with each cell corresponding to a place on the lake. Each number is the amount of time that it took the sound to bounce off the bottom of the lake and return in that spot.
  2. Use the data to make a graph of the bottom of Lake Katie. You should use the "Surface" Chart Type.