GE110 -- Spreadsheet Excercise

Fall 2003

Sound Wave Theory

Sound Waveforms

A musical note is represented by a sine wave at a specific frequency. The table below gives the frequencies of different notes.

Note Frequency (Hz)
A 220
A# 233
B 247
C 262
C# 277
D 294
D# 311
E 330
F 349
F# 370
G 392
G# 415

Doubling the frequency gives you the same note one octave higher while halving the frequency gives you the same note one octave lower.

Procedure

Create a Microsoft Excel spreadsheet that consists of two worksheets. The first worksheet should contain only two columns of numbers. The first column should represent time and the second column should represent the voltage sent to the speakers. The second worksheet should allow the user to change the frequency and sampling rate of the sound produced. It should also contain a graph of the first 200 voltage numbers from the first worksheet. Your instructor will demonstrate how to generate these worksheets in class.

In order to listen to the sound generated by this data you will need to:

  1. Save the file (you pick the name, but use the CSV (Comma delimited) format:
    In Excel: File -> Save As, select "CSV (Comma delimited)" for the "Save as type", enter a filename, and click on the "Save" button.
  2. Convert the .csv file to a .wav file:
    Download the csv2wav.exe program and drag and drop your .csv file onto the csv2wav.exe icon. This should generate a .wav with the same file name (except for the different extention).
  3. Play the file (double click on the file icon)
Additional Exploration

Once finished with this you should modify the spreadsheet to:

Acknowledgment

This exercise was developed by Dr. Chris Taylor.

Last Updated: