Project III - Excel - ECE 211 Fall 2009 Circuit Analysis I...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
ECE 211 Fall 2009 Circuit Analysis I Project 3 (due Mon, Nov 9, at the beginning of lecture) Objectives To learn the basics of Excel and to compute values to compare to Virtual Lab results. Required Output For each problem, you should submit two printouts of your Excel worksheet, in different ways: with values of input and output variables clearly labeled. with formulas shown, rather than values. This is done with <CTRL-backquote> where <backquote> (`) is above the <TAB> key. Note that this is actually a toggle command. P5. Consider the following circuit: Assume first that Rb = 10kΩ, Rload = 300kΩ, and Vin = 1.5V. (a) What value of Ra will result in Vout = 12V? (b) What power is absorbed by the op-amp to operate this circuit? (c) What current is flowing into the output pin of the op-amp? Assume now that the desired value of Vout is 27V. (Rb and Vin remain the same.) (d) How do your answers to parts (a), (b), and (c) change? Assume finally that the original load is changed to Rload = 600kΩ. (Use Vout = 12V.) (e) How do your answers to parts (a), (b), and (c) change? To answer these questions, you should set up an Excel spreadsheet or worksheet . This is so that you can avoid repeating all of the calculations in parts (d) and (e) when the values of Vout and Rload change. Each box in the worksheet is called a cell , which is identified by the column (A, B, C…) and row (1, 2, 3…). So, for instance, B3 refers to the contents or value of the cell located at the 3rd row of the 2nd column of your worksheet. On the next page, the value of B3 is 200. Formulas are written in terms of cell identifiers.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/20/2010 for the course ENGINEERIN 242 211 taught by Professor Tessier during the Spring '10 term at UMass (Amherst).

Page1 / 5

Project III - Excel - ECE 211 Fall 2009 Circuit Analysis I...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online