By Topic

Using spreadsheets in introductory EE courses

Sign In

Cookies must be enabled to login.After enabling cookies , please use refresh or reload or ctrl+f5 on the browser for the login options.

Formats Non-Member Member
$33 $13
Learn how you can qualify for the best price for this item!
Become an IEEE Member or Subscribe to
IEEE Xplore for exclusive pricing!
close button

puzzle piece

IEEE membership options for an individual and IEEE Xplore subscriptions for an organization offer the most affordable access to essential journal articles, conference papers, standards, eBooks, and eLearning courses.

Learn more about:

IEEE membership

IEEE Xplore subscriptions

1 Author(s)
J. A. Svoboda ; Dept. of Electr. & Comput. Eng., Clarkson Univ., Potsdam, NY, USA

Ways in which spreadsheet programs can be used to introduce practical considerations in introductory electrical engineering courses are discussed. Examples are presented which show that spreadsheets can be used to predict and/or minimize the errors due to loading, the availability of only standard resistor values, and resistor tolerances. The circuits considered in these examples were selected to be as simple as possible. These examples could be used in the first semester of sophomore credits. They illustrate trade-offs, performance criteria, and nonunique solutions, and are intended to illustrate the power of spreadsheet programs. In the first example, a macro is used to implement a simple iterative optimization procedure. In the second example, minimization is done by exhaustive search using the table lookup capabilities of the spreadsheet. In the final example, the spreadsheet's random number generator is used to perform a Monte Carlo analysis

Published in:

IEEE Transactions on Education  (Volume:35 ,  Issue: 3 )