Spreadsheet applications in electrical engineering: A review

International Journal of Engineering Education

Volumn 20, Issue 6, 2004, Pages 902-908

  Chehab, Ali ^a   El Hajj, Ali ^a   Al Husseini, Mohammed ^a   Artail, Hassan ^a  

^a AMERICAN UNIVERSITY OF BEIRUT   (Lebanon)

Author keywords

[No Author keywords available]

Indexed keywords

COMPUTER PLATFORMS; DIGITAL SYSTEMS; PULL-DOWN MENUS; VERTICAL LINES;

ELECTROMAGNETISM; FINANCE; FUNCTIONS; GRAPHICAL USER INTERFACES; NEURAL NETWORKS; SIGNAL PROCESSING; SPREADSHEETS;

ELECTRICAL ENGINEERING;

EID: 10044269915     PISSN: 0949149X     EISSN: None     Source Type: Journal    
DOI: None     Document Type: Review

References (95)

1. Eric Kohler, Dictionary for Accountants, 3rd ed., Prentice-Hall, 1963.
2. R. Mattessich, Budgeting models and system simulation, The Accounting Review, July 1961, pp. 384-397.
3. R. Mattessich, Accounting and Analytical Methods, R. D. Irwin Inc., Homewood, IL (1964) chapter 9.
4. R. Mattessich, Simulation of the Firm Through a Budget Computer Program, R. D. Irwin Inc., Homewood, IL (1964).
5. J. Power, A Brief History of Spreadsheets, version 3.3, available: http://dssresources.com/history/sshistory.html
6. C. Bissell and D. Chapman, Modeling applications of spreadsheets (in engineering), July 1989, IEE Review.
7. D. A. Umphress and J. A. Hamilton, Jr., Software process as a foundation for teaching, learning, and accrediting, Proc. 15th Conference on Software Engineering Education and Training CSEET'02, Feb. 2002.
8. J. R. Evans, Spreadsheets as a tool for teaching simulation, INFORMS Transactions on Education, 1(1), Sept. 2000, pp. 27-37.
9. S. Malasri and S. R. Syed-Mohammad-Ridzuan, Educational software development using spreadsheet program, Int. J. Appl. Engng Ed., 3(1), 1987, pp. 55-58.
10. R. B. Doak, J. McCarter, M. Green, S. Duerden, D. Evans, R. Roedel, and P. Williams, Animated spreadsheets as a teaching resource on the freshman level, Proc. Frontiers in Education Conference FIE '96: 26th Annual Conference (Nov. 1996).
11. A. J. Boye, P. F. Williams and R. J. Soukup, Using spreadsheets to teach problem solving in a first year class, IEEE Trans. Ed., Feb. 1993.
12. T. K. Jewell, Spreadsheets and equation solvers in engineering education, Int. J. Appl. Engng Ed., 3(3), 1987, pp. 315-333.
13. J. Tan-Atichat, Spreadsheets: a new nontraditional engineering tool, Int. J. Appl. Engng Ed., 3(6), 1987, pp. 551-558.
14. Banta, Using computer spreadsheets in engineering and education, Proc. Frontiers in Education Conference FIE '88, Oct. 1988.
15. R. J. Schalkoff, A note on the effective use of PC-based spreadsheets for course grading, IEEE Trans Ed. Feb. 1986.
16. J. R. Mountain and M. H. Pleck, Multi-section course management using 3D spreadsheet tools, Proc. Frontiers in Education Conference FIE 2000: 30th Annual Conference, Oct. 2000.
17. S. Malasri, Student advising using spreadsheet program, Int. J. Appl. Engng Ed., 3(6), 1987, pp. 559-562.
18. A. El-Hajj and K. Y. Kabalan, The use of spreadsheets to study the stability of linear control systems, Int. J. Appl. Engng Ed, 6(4), 1990, pp. 437-442.
19. A. El-Hajj and K. Y. Kabalan, Time domain analysis of linear systems using spreadsheets, IEEE Trans. Ed Nov. 1995.
20. W. Yiu-Kwong, Application of a spreadsheet program to control system design, Int. J. Electrical Engng Ed., 29(1), Jan, 1992, pp. 16-23.
21. B. J. Stanton, M. J. Drozdowski and T. S. Duncan, Using spreadsheets in student exercises for signal and linear system analysis, IEEE Trans. Ed., Feb. 1993.
22. D.Y. Wang, R. P. Johnson, L. S. B. Ng and W. J. Pearce, Ramping control using a spreadsheet, Proc. 1993 Particle Accelerator Conference, May 1993.
23. K. Y. Kabalan, H. B. Diab, A. El-Hajj and H. S. Tabarra, Stability analysis and minimum phase testing of causal systems using spreadsheets, Int. J. Eng'g Ed., 12(5), 1996.
24. K. Y. Kabalan, A. El-Hajj and W. Smari, Nonlinear and sampled data control systems analysis using spreadsheets, IEE Proc. Science, Measurement and Technology, Jan. 1996.
25. C. J. Fraser, Spreadsheet applications for control system modeling and analysis, Int. J. Eng'g Ed., 12(1), 1996.
26. A. El-Hajj, K. Y. Kabalan, and S. V. Khoury, A linear control system simulation toolbox using spreadsheets, IEEE Control Systems Magazine, Dec. 2000.
27. A. El-Hajj, S. Karaki, and K. Y. Kabalan, Graphical simulation of an analog computer using spreadsheets, Int. J. Eng'g Ed., 18(6), 2002.
28. A. Yamani and A, Kharab, Use of a spreadsheet program in electromagnetics, IEEE Trans Ed., Aug. 2001.
29. R. F. Schwartz, Spreadsheet electromagnetics, Proc. Frontiers in Education Conference FIE '88, Oct. 1988.
30. A. Kharab and R. Kharab, Spreadsheet solution of hyperbolic partial differential equations (for EM field calculations), IEEE Trans. Ed., Feb. 1997.
31. B. Knox and J. E. Lebaric, Spreadsheet solution of the wave equation, Proc. Int. Conf. Computation in Electromagnetics, 1991.
32. L. O. Hoeft, Using spreadsheet programs on personal computers for electromagnetic coupling calculations, IEEE Int. Symp. Electromagnetic Compatibility, Aug. 1996.
33. F. R. Shapiro, The use of a spreadsheet for sinusoidal steady-state transmission line and optics problems, IEEE Trans. Ed., May 1993.
34. M. Barron, Normalized site attenuation calculations using standard spreadsheet analysis, Proc. IEEE Int. Symp. Electromagnetic Compatibility, Aug. 1999.
35. M. Barron, Theoretical normalized site attenuation calculations by spreadsheet analysis, IEEE Int. Symp. Electromagnetic Compatibility, Aug. 2000.
36. M. Barron, 3-D surface plots of theoretical NSA calculations by spreadsheet analysis, IEEE Int. Symp. Electromagnetic Compatibility, Aug. 2001.
37. Hills, Use of a spreadsheet program in an antenna design application, IEEE Trans. Antennas Propagation, AP-14, 1986, pp. 237-242.
38. A. El-Hajj, K. Y. Kabalan and M. Al-Husseini, Antenna Array Design Using Spreadsheets, IEEE Trans. Ed., to be published.
39. J. W. Lamont, A. J. Mitchell and D. J. Slump, A spreadsheet model for residential magnetic field exposure, Proc. 22nd Annual North American Power Symposium, 1990.
40. Brunkhorst, RF cavity analysis with spreadsheet software, Proc. 17th IEEE/NPSS Symp. Fusion Engineering, Oct. 1997.
41. R. L. Spooner, Signal processing using spreadsheet software, Proc. OCEANS '88: A Partnership of Marine Interests, Nov. 1988.
42. G. S. Baicher and J. A. Sherrington, Learning about digital signal processing using spreadsheets and simulation software, Eng. Sc. Ed. J., Feb. 1996.
43. G. S. Baicher and J. A. Sherrington, A DSP laboratory based on a spreadsheet and TMS320C25 simulation software, IEE Colloquium: The Teaching of DSP in Universities, 2/1-2/6, London (1995).
44. Chapman, Spreadsheet Demonstrations of Discrete and Fast Fourier Transforms, Int. J. Electrical Engng Ed., 30, 1993, pp. 211-215, Manchester U.P., Great Britain.
45. L. Anneberg and E. Yaprak, Error detection and correction templates for digital courses, IEEE Trans. Ed., 42(2), May 1999, 114-117.
46. P. Lallo, Investigation of data transmission over an adaptive delta modulated voice channel by simulations using a spreadsheet program, Proc. MILCOM 97 (Nov. 1997).
47. P. W. Van der Walt, A spreadsheet intermodulation chart for narrowband and wideband systems, Proc. 1998 South African Symposium on Communications and Signal Processing, COMSIG '98.
48. J. J. Knab, Satellite loading tools using spreadsheets, Proc. 21st Century Military Communications Conf. MILCOM 2000.
49. R. Fiset and M. Farhat, A low-cost polarimetric response tool using spreadsheets, Proc. IEEE 2001 Int. Geoscience and Remote Sensing Symposium IGARSS '01.
50. The SETI League, SETI Spreadsheet Templates, available: http://www.setileague.org/software/spreadsh.htm
51. H. V. Estrada, The use of electronic spreadsheet programs in semiconductors and solid-state devices courses, Proc. IEEE Southeastcon '89; Energy and Information Technologies in the Southeast.
52. M. J. Hartmann, Spreadsheet program for DC load flow problems, Conf. Record of the 1992 IEEE Nuclear Science Symposium and Medical Imaging Conference (Oct. 1992).
53. T. Rogne, O. Mo, and M. Schlurscheid, Paralleling of semiconductors including temperature feedback, using spreadsheet or simulation tool, to calculate current and temperature differences, Proc. 5th European Conference on Power Electronics and Applications, 1993.
54. C. H. Phang, Y. T. Yeow, R. A. Barham, and P. J. Allen, Measurement of hybrid-/spl pi/ equivalent circuit parameters of bipolar junction transistors in undergraduate laboratories, IEEE Trans Ed., 40(3), Aug. 1997, pp. 213-218.
55. R. G. Forbes, Use of a spreadsheet for Fowler-Nordheim equation calculations, Proc. 11th Int. Vacuum Microelectronics Conf., July 1998.
56. G. Noebauer, Creating compact models using standard spread sheet software, Proc. 17th IEEE Symp. Semiconductor Thermal Measurement and Management, March 2001.
57. F. R. Shapiro, The numerical solution of Poisson's equation in a pn diode using a spreadsheet, IEEE Trans. Ed., Nov. 1995.
58. J. A. Svoboda, Using spreadsheets in introductory EE courses, IEEE Trans. Ed., Aug. 1992.
59. A. El-Hajj and K. Y. Kabalan, A spreadsheet simulation of logic networks, IEEE Trans. Ed., Feb. 1991.
60. A. El-Hajj and M. Hazim, On using spreadsheets for logic networks simulation, IEEE Trans. Ed., Nov. 1998.
61. P. H. Saul, The Spreadsheet as a High Level Mixed Mode Simulation Tool, Electronic Engineering, S49-S55, Sept. 1991.
62. A. El-Hajj, K. Y. Kabalan and M. Yehia, Simulation of a class of integrated circuits using spreadsheets, IEE Proc. Circuits, Devices and Systems, Oct. 1992.
63. E. M. Foster, A spreadsheet approach for early optimization of large bus switching performance, Proc. 1990 IEEE Southern Tier Technical Conference, April 1990.
64. A. El-Hajj, K. Y. Kabalan and A. Chehab, A Microprocessor simulation using spreadsheets, Int. Conf. Microelectronics, Cairo, Egypt, 21-23 December 1991, pp. 284-287.
65. A. El-Hajj, K. Y. Kabalan and H. Diab, A spreadsheet educational tool for microprocessor systems, J. Computer Applications in Engineering Education, 3(3), 1995, pp. 205-211.
66. H. Diab, Simulation of Cache-based Parallel Processing Systems using Spreadsheets, Int. J. Eng. Ed., 14(2), 1998.
67. A. El-Hajj, K. Y. Kabalan, M. Mneimneh and F. Karablieh, Microprocessor simulation and program assembling using spreadsheets, Simulation, 75(2), Aug. 2000, pp. 82-90.
68. D. C. Walter and M. M. McMillan, A spreadsheet method for studying neural networks, Proc. 1990 Symp. Applied Computing, April 1990.
69. R. Antonini, Spreadsheet simulation of artificial neural network, Proc. Int. Conf. Neural Networks IJCNN'91, Seattle.
70. J. L. Bemley, Neural networks for precollege students, Proc. Int. Conf. Neural Networks IJCNN'99, International Neural Network Society, Mount Royal, NJ.
71. N. D. Rao and N. Y. Haddad, Typical applications of new generation spreadsheets to power system problems, Proc. 33rd Midwest Symposium on Circuits and Systems, Aug. 1990.
72. L. A. Morley and T. Novak, Impedance-based power-system analysis using a spreadsheet, Conf. 1990 IEEE Industry Applications Society Annual Meeting.
73. F. B. Chaaban, R. Chedid and S. Karaki, Spreadsheet implementation in electric power engineering, Proc. Frontiers in Education Conf., FIE '94.
74. W. Xu, Y. Liu, D. Koval, and M. A. Lipsett, Using spreadsheet software as a platform for power system analysis, IEEE Computer Applications in Power, Jan. 1999.
75. Morishita, Y. Iwata, K. Yuki and H. Yoshida, Spreadsheet fluid dynamics for aeronautical course problems, Int. J. Eng. Ed., 17(3), 2001.
76. C. N. Reffold, Spreadsheet Modeling of Turbojet Performance, Int. J. Eng. Ed., 11(2), 1995.
77. R. Kumar and A. O. Al-Shantaf, Spreadsheet analysis of fluid mechanics problems, Proc. Frontiers in Education Conf. FIE '97.
78. J. C. Eid, Thermal modeling with PC spreadsheets, Proc. 4th IEEE Semiconductor Thermal and Temperature Measurement Symp. SEMI-THERM IV, Feb. 1988.
79. D. Arganbright, Mathematical Applications of Electronic Spreadsheets, McGraw-Hill (1985).
80. D. Piele, Introductory Statistics With Spreadsheets, Addison-Wesley (1990).
81. D. Arganbright, Practical Handbook of Spreadsheet Curves and Geometric Constructions, CRC Press (1995).
82. R. Smith, Applications of Spreadsheets in Calculus, Proc. 1st Asian Technology Conf. Mathematics, 1995.
83. R. Smith, Spreadsheets as a mathematical tool, J. Excellence in College Teaching, 3, 1992, pp. 131-149.
84. S. Abramovich and G. Brown, Teaching mathematics through spreadsheet-oriented problem solving, The Mathematics Educator, 6(2), 1995, pp. 34-40
85. S. Abramovich, Technology-Motivated Teaching of Advanced Topics in Discrete Mathematics, J. Computers in Mathematics and Science Education, 14(3), 1995, pp. 391-418.
86. E. Neuwirth, Visualizing correlation with spreadsheet, Teaching Statistics, Dec. 1990.
87. E. Neuwirth, Spreadsheet structures as a model for proving combinatorial identities, J. Computers in Mathematics and Science Education, 14(3), 1995, pp. 419-434.
88. S. Abramovich, Technology for deciding the convergence of series, Int. J. Mathematical Education in Science and Technology, 26(3), 1995, pp. 347-366.
89. E. G. John, Simplified curve fitting using spreadsheet add-ins, Int. J. Eng. Ed., 14(5), 1998.
90. K. Y. Kabalan, A. El-Hajj, S. Khouri, and F. Yousuf, Root computations of real-coefficient polynomials using spreadsheets, Int. J. Eng Ed., 18(1), 2002.
91. J. Billo, Excel for Chemists, John Wiley (1997).
92. K. F. Schoch, Spreadsheet applications in chemistry using Microsoft Excel, IEEE Electrical Insulation Magazine, Feb. 1998.
93. Y. Lwin, Chemical equilibrium by Gibbs Energy Minimization on spreadsheets, Int. J. Eng. Ed., 16(4), 2000.
94. C. Misner and P. Cooney, Spreadsheet Physics, Addison-Wesley (1991).
95. R. Feinberg and M. Knittel, Micrcomputer spreadsheet programs in the physics laboratory, Am. J. Physics, 53(7), July 1985.