|GE100 -- Lab 1: Excel Spreadsheets|
This webpage outlines how to generate simple sounds on a computer.
Prior to lab you should read through this assignment and download the following two files to your computer:
In groups of two you will:
Doubling the frequency gives you the same note one octave higher while halving the frequency gives you the same note one octave lower.
I have created a sample spreadsheet that can be used for generating sound data. The first column of the sine sheet contains a series of increasing, uniformly spaced numbers. They represent time information. The second column contains numbers that represent a sinusoid. (Select B1 through B45, click on the "chart wizard" icon (looks like a bar graph), select line for the "Chart type" and click on the "Finish" button. A plot of the selected data should appear... and it should look like the dark blue sine wave in the figure below.)
In order to listen to the sound generated by this data you will need to:
You may create other sounds by changing the numbers in the second column. The easiest way to do this is to:
You can now follow the steps above to listen to this sound.
You should generate square (use the sqr worksheet), triangle (use the tri worksheet), and sawtooth (use the saw worksheet) square (use the sqr worksheet), waves (see the figure above) instead of the sine wave. Warning: I have not explained how to generate the other waveforms... you may have to think about it. Experiment with different frequencies. Compare the sounds from the various waveforms (all at the same frequency).
Your lab report should be an independent document. That means that someone should be able to understand what you did and why without seeing anything other than your report. Your report should include:
As with any report you submit, correct spelling and grammar are required. In addition, your report should be submitted electronically following the Electronic submission guidelines. (You may wish to consult the sample report before submitting your report.) Be sure to keep copies of all your files, in case something gets lost. It may be wise to keep a diskette backup as well.
|© 2002 Dr. Christopher C. Taylor||Office: CC-27C||Phone: 277-7339||Last Updated: Tue Sep 10 15:49:06 2002|
|I am responsible for all content posted on these pages; MSOE is welcome to share these opinions but may not want to.|