Assignments: 1. Test composite Create sine waves using an Excel spreadsheet (call sheet Simple Sine) using the formula y(t) = A* sin(2 ift + p) where A-amplitude, f = frequency, t = time, p = period To do so, you need to divide a second into time intervals of 0.01 seconds and calculate the values of y(t) for t = 0, 0.1, 0.2, 0.3, ..., 0.97, 0.98, 0.99, 1. a. Draw a sine wave for A = 1, f = 1, p = 0 b. Draw a sine wave for A = 1/3, f = 3, p = 0 c. Draw the composite of the waves in a. and b. Should look like this 1.6 Chart Title -0.6 Seiesl - -Series2 - Series3 2. Amplitude Modulation Simple amplitude modulation with sine waves. Create a new sheet with a name like Amplitude a. Create a carrier signal with amplitude 1, phase 0, and frequency 20 b. Create data signal at amplitude 3, phase 0, frequency 1 c. Draw the modulated wave (careful about sign) 3. Frequency interference Simple frequency interference. Create a new sheet with the same time with a name like Frequency a. Create a sine wave with amplitude 1, frequency 10, phase 0 b. Create a sine wave with amplitude 1, frequency 11, phase 0 c. Create the composite of a and b d. Describe what happens to c. 4. Generate digital signal a. Draw the sine wave for A = 1, f = 1, p = 0. b. Draw the sine wave for A = 1/3, f= 3, p = 0. c. Draw the sine wave for A = 1/5, f = 5, p = 0. d. Draw the sine wave for A = 1/7, f = 7, p = 0. e. Draw the sine wave for A = 1/9, f = 9, p = 0. 1. Draw the composite of the waves created in a -e What does the signal in flook like? To generate a better digital signal, what should you do? 5. Phase interference Simple phase interference. Create a new sheet with a name like Phase. You'll be be making 3 charts a. Create a sine wave with amplitude 1, frequency 5, phase 0 (chart 1) b. Create a sine wave with amplitude 1, frequency 5, phase PIO/4 (chart 1) C. Create a composite of a. and b. (chart 1) d. Describe what happens in c. e. Create a sine wave with amplitude 1, frequency 5, phase PIO/1.5 (chart 2, include sine wave from a. in this chart) f. Create a composite of a. and e. (chart 2) g. Describe what happens in f. h. Create a sine wave with amplitude 1, frequency 5, phase PIO (chart 3, include sine wave from a. in this chart) i. Create a composite of a. and h. (chart 3) j. Describe what happens in i. NOTE: If you get something that looks like this, you've mixed up your x and y axis. Frequency Interference - - Series Series Series Series Series2 Series ies12 Series17 Series22 -Series27 Series3 Series Series13 Series18 Series23 -Series28 les14 Series Series 10 Series15 Series20 Series25 Series30 - - Series16 Series21 Series26 in - Series19 Series24 Series29 - - You need to switch your x and y axis. Assignments: 1. Test composite Create sine waves using an Excel spreadsheet (call sheet Simple Sine) using the formula y(t) = A* sin(2 ift + p) where A-amplitude, f = frequency, t = time, p = period To do so, you need to divide a second into time intervals of 0.01 seconds and calculate the values of y(t) for t = 0, 0.1, 0.2, 0.3, ..., 0.97, 0.98, 0.99, 1. a. Draw a sine wave for A = 1, f = 1, p = 0 b. Draw a sine wave for A = 1/3, f = 3, p = 0 c. Draw the composite of the waves in a. and b. Should look like this 1.6 Chart Title -0.6 Seiesl - -Series2 - Series3 2. Amplitude Modulation Simple amplitude modulation with sine waves. Create a new sheet with a name like Amplitude a. Create a carrier signal with amplitude 1, phase 0, and frequency 20 b. Create data signal at amplitude 3, phase 0, frequency 1 c. Draw the modulated wave (careful about sign) 3. Frequency interference Simple frequency interference. Create a new sheet with the same time with a name like Frequency a. Create a sine wave with amplitude 1, frequency 10, phase 0 b. Create a sine wave with amplitude 1, frequency 11, phase 0 c. Create the composite of a and b d. Describe what happens to c. 4. Generate digital signal a. Draw the sine wave for A = 1, f = 1, p = 0. b. Draw the sine wave for A = 1/3, f= 3, p = 0. c. Draw the sine wave for A = 1/5, f = 5, p = 0. d. Draw the sine wave for A = 1/7, f = 7, p = 0. e. Draw the sine wave for A = 1/9, f = 9, p = 0. 1. Draw the composite of the waves created in a -e What does the signal in flook like? To generate a better digital signal, what should you do? 5. Phase interference Simple phase interference. Create a new sheet with a name like Phase. You'll be be making 3 charts a. Create a sine wave with amplitude 1, frequency 5, phase 0 (chart 1) b. Create a sine wave with amplitude 1, frequency 5, phase PIO/4 (chart 1) C. Create a composite of a. and b. (chart 1) d. Describe what happens in c. e. Create a sine wave with amplitude 1, frequency 5, phase PIO/1.5 (chart 2, include sine wave from a. in this chart) f. Create a composite of a. and e. (chart 2) g. Describe what happens in f. h. Create a sine wave with amplitude 1, frequency 5, phase PIO (chart 3, include sine wave from a. in this chart) i. Create a composite of a. and h. (chart 3) j. Describe what happens in i. NOTE: If you get something that looks like this, you've mixed up your x and y axis. Frequency Interference - - Series Series Series Series Series2 Series ies12 Series17 Series22 -Series27 Series3 Series Series13 Series18 Series23 -Series28 les14 Series Series 10 Series15 Series20 Series25 Series30 - - Series16 Series21 Series26 in - Series19 Series24 Series29 - - You need to switch your x and y axis