Spreadsheet applications in engineering education: A review

International Journal of Engineering Education

Volumn 20, Issue 6, 2004, Pages 893-901

  Oke, S A ^a  

^a UNIVERSITY OF LAGOS   (Nigeria)

Author keywords

[No Author keywords available]

Indexed keywords

COMPUTATIONAL TOOLS; HIGH-LEVEL PROGRAMMING; MANUAL COMPUTATION; PROGRAM DEVELOPMENT;

COMPUTATIONAL METHODS; COMPUTER SIMULATION; LEARNING SYSTEMS; MATRIX ALGEBRA; OPTIMIZATION; PROGRAM DEBUGGING; SPREADSHEETS;

ENGINEERING EDUCATION;

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

References (68)

1. A. J. Boye, P. F. Williams and R. J. Soukup, Using spreadsheets to teach problem solving in a first year class, IEEE Transactions on Education, 36(1), Feb. 1993, pp. 68-71.
2. A Davies, Using a spreadsheet to investigate models of heat conduction and vibrating strings, Teaching Maths and Its Applications, 12, 1993, p. 179.
3. A. E. DiAntonio, Spreadsheet Applications, Prentice-Hall (1986).
4. A. El-Hajj and M. Hazim, On using spreadsheets for logic networks simulation, IEEE Trans. Educ., 41(4), Nov. 1998, pp. 311-319.
5. A. El-Hajj and K.Y. Kabalan, Time domain analysis of linear systems using spreadsheets, IEEE Trans. Educ., 38(4), Nov 1995, pp. 317-320.
6. A. El-Hajj and K. Y. Kabalan, A spreadsheet simulation of logic networks, IEEE Trans. Educ., 34(1), Feb. 1991, pp. 43-46.
7. A. El-Hajj, K. Y. Kabalan and H. Diab, A spreadsheet educational tool for microprocessor systems, Computer Applications in Engineering Education, 3(3), 1995, pp. 205-211.
8. A. Kharab and R. Kharab, Spreadsheet solution of hyperbolic partial differential equations (for EM field calculations), IEEE Trans. Educ., 40(1), Feb. 1997, pp. 103-110.
9. A. Kharab, Use of a spreadsheet program in a two-dimensional heat conduction problem, Computer Methods in Applied Mechanics and Engineering, 122, 1995, pp. 173-181.
10. A. N. Wiseman and PK Armstrong, Introducing discrete information theory using spreadsheets, Teaching Maths and Its Applications, 12, 1993, p. 130.
11. A. Yamani and A. Kharab, Use of a spreadsheet program in electromagnetic, IEEE Trans. Educ., 44(3), August 2001, pp. 292-297.
12. B. J. Stanton, M. J. Drozdowski and T. S. Duncan, Using spreadsheets in student exercises for signal and linear system analysis, IEEE Trans. Educ., 36(1), Feb. 1993, pp. 62-68.
13. C. C. Bissell and D. A. Chapman, Spreadsheets as a learning aid in engineering education, CAEE 93 Int. Conf. Computer-Aided Engineering Education, Bucharest, Romania, September 1993.
14. C. C. Bissell and D. A. Chapman, Modelling applications of spreadsheets, IEE Review, July/ August 1989, pp. 267-271.
15. C. C. Bissell, Technology for maths for technology: the role of spreadsheets, Technology and the Teaching of Mathematics Conf., Birmingham, UK, September 1993.
16. C. C. Bissell, Spreadsheets in Engineering Education: Mathematics, Modelling and Simulation, Report No. SAG/1994/RR37/CCB, The Faculty of Technology, The Open University, Milton Keynes, UK (1994).
17. C. C. Bissell, Spreadsheets in the teaching of information engineering, Engineering Science and Education J., April 1994, pp. 89-96.
18. C. L. Croskey, Spreadsheet illustration of engineering economics, IEEE Trans. Educ., 31(4), Nov 1988, pp. 270-275.
19. C. R. Thomas, Three methods of performing conditional looping in a spreadsheet, Int. J. Eng. Educ., 8(4), 1988, pp. 271-277.
20. C. Rives and D. J. Lacks, Teaching process control with a numerical approach based on spreadsheets, Chemical Engineering Education, 2002, pp. 242-248.
21. C. Y. Lam, Spreadsheet approach to partial differential equations, Part 1: Elliptic equation, Int. J. Eng. Educ., 8(4), 1988, pp. 278-287.
22. D. A. Chapman, Spreadsheet demonstration of disc'etc and fast Fourier transforms, Int. J. Electr. Eng. Educ., 30(3), 1993, pp. 211-215.
23. D. G. Hendry and T. R. G. Green, Creating, comprehending, and explaining spreadsheets: a cognitive interpretation of what discretionary users think of the spreadsheet model, Int. J. Human-Computer Studies, 40(6), June 1994, pp. 1033-1065.
24. D. J. Power, A brief history of spreadsheets. http://www.DSSResources.com
25. D. R. Green, Solving iteration problems using a spreadsheet, Teaching Maths and Its Applications, 12, 1993, p. 22.
26. D. R. Green, Numerical methods using a spreadsheet, Teaching Maths and Its Applications, 13, 1994, p. 68.
27. E. M. Rosen and L. R. Partin, A perspective: the use of the spreadsheet for chemical engineering computations, I&EC Chemistry Research, 39(6) June 2000, pp. 1612-1613.
28. F. R. Shapiro, The use of a spreadsheet for sinusoidal steady-state transmission line and optics problems, IEEE Trans. Educ., 36(2), May 1993, pp. 269-272.
29. E. G. John and R. I. Grosvenor, Failure distribution curve fitting using spreadsheet add-ins, Int. J. Electrical Eng. Educ., 38(2), April 2001, pp. 165-172.
30. F. S. T. Hsiao, Micros in mathematics education-uses of spreadsheets in CAL, Int. J. Math. Educ. Sci. Technol., 16, 1985. p. 705.
31. F. S. T. Hsiao, An evaluation of spreadsheet macros for CAI with applications to matrix multiplication, Collegiate Microcomputer, 5, 1987, p. 333.
32. F. S. T. Hsiao, A computational design of some matrix iterative methods using spreadsheets, J. Amer. Inst. Ind. Eng,. 19, 1987, p. 17.
33. F. S. T. Hsiao, Implementation of the Gauss-Jordan method of matrix inversion by spreadsheet macros, Int. J. Math. Educ. Sci. Technol., 19, 1988, p. 729.
34. F. S. T. Hsiao, The simplex method of linear programming on microcomputer spreadsheets, College Maths J., 20, 1989, p. 153.
35. H. Diab, Simulation of cache-based parallel processing, Int. J. Eng. Ed., 14(2), 1998, pp. 136-144.
36. I. H. Kral, Excel Spreadsheets for Engineers and Scientists, Prentice-Hall (1991).
37. J. A. Svoboda, Using spreadsheets in introductory EE courses, IEEE Trans. Education, 35(3), Aug 1992, pp. 226-229.
38. J. M. Hale and C. Grant, A course in the use of computer spreadsheets for mechanical engineering students, Int. J. Mechanical Engineering Education, 21(2), 1993, pp. 146-155.
39. J. Walkenbach, Microsoft Excel 2000 Power Programming with VBA, IDG Books Foster City, CA (1999).
40. J. C. Nash and T. K. Quon, Issues in teaching statistical thinking with spreadsheets, J. Statistics Education, 4(1), 1996.
41. J. Gianini, J. C. Nash and T. K. Quon, Statistical issues in spreadsheet software, 1994 Proc. Statistical Education Section, 1995, American Statistical Association, Arlington VA. Pp. 238-241.
42. M. L. Cuttle, C. P. L. Young and S. B. Heath, A practical introduction to creating courseware with Microsoft Excel, CTI CLUES, University of Aberdeen.
43. M. Hagler, Spreadsheet program in antenna design application, IEEE Trans., AP-30, 1986, pp. 585-587
44. K. Tai, Integrated design optimisation and analysis using a spreadsheet application, Int. J. Mechanical Engineering Education, 27(1), January 1999. http://www.me.umist.ac.uk/ijmee/27-1p3.htm
45. K. Rajalingham and D. Chadwick, Integrity control of spreadsheets: organisation & tools, Proc. 2nd IFIP TC-11 Working Group 11.5 Working Conference on Integrity and Internal Control in Information Systems, November 1998, Virginia, USA, Kluwer Academic Publishers, pp. 147-168.
46. K. Rajalingham, D. Chadwick, B. Knight and D. Edwards, An approach to improving the quality of spreadsheet models, Proc. 7th Int. Conf. Software Quality Management SQM'99, March 1999, Southampton, UK, British Computer Society, pp. 117-131.
47. K. Y. Kabalan, A. El-Hajj, H. Diab and S. Fakhreddine, Analog computer simulation using spreadsheets, Simulation, 68(2), 1997, 101-106.
48. K. Y. Kabalan, H. Diab, A. El-Hajj and H. Tabbara, Stability analysis and minimum phase testing of causal filters using spreadsheets, Int. J. Eng. Educ., 12(5), 1996, pp. 382-388.
49. L. Healy and R. Sutherland, Exploring Mathematics with Spreadsheets, J. Murray (1992).
50. L. R. Huelsman, Electrical engineering applications of microcomputer spreadsheets analysis programs, IEEE Trans., E-27, 1984, pp. 86-92,
51. M. A. Antar and E. M. Mokheimer, On the use of spreadsheet in heat conduction analysis, Int. J. Mechanical Engineering Education, 28(2), 2000. http://me.umist.ac.uk/ijmee/28-2.htm
52. M. A. Antar and E. M. Mokheimer, Spreadsheet modelling of transient three-dimensional heat conduction with various standard boundary conditions, Int. J. Mechanical Engineering Education, 30(1), 2002. http://www.me.umist.ac.uk/ijmee/30-lp3.htm
53. M. R. Schumack, Teaching heat transfer using automotive-related case studies with a spreadsheet analysis package; Int. J. Mechanical Engineering Education, 25(3), 1996, pp. 177-196.
54. N. D Rao, Typical applications of microcomputer spreadsheets to electrical engineering problems, IEEE Trans., E-27, 1984, pp. 237-242.
55. N. Kantaris and and P. R. M. Oliver, Excel 5 Explained, Bernard Babani Publishing, (1994).
56. P. H. Saul, The spreadsheet as a high-level mixed mode simulation tool, Electronic Engineering, 1991, pp. 549-555.
57. R. R. Panko and R. P. Halverson, Jr., Spreadsheets on trial: a framework for research on spreadsheet risks, Proc. 29th Hawaii International Conference on System Sciences, Jan. 1996, Maui, Hawaii.
58. R. R. Clements, Spreadsheets as a Tool for Teaching Elementary Numerical Analysis, University of Bristol, Department of Engineering Mathematics, Report EM/RRC/91/1, (1991)
59. R. R Clements, Teaching topics in numerical linear algebra using spreadsheets, Int. J. Math. Educ. Sci. Technol., 22, pp. 1003 (1991).
60. R. Jackson, Modelling population growth using a spreadsheet, Teaching Maths and its Applications, 12, 1993, p. 74.
61. R. Jackson and J. T. Callender, Estimators: a spreadsheet investigation of bias, Teaching Maths and Its Applications, 13, 1994, p. 78.
62. R. Jackson, A spreadsheet approach to complex transformations, Teaching Maths and Its Applications, 12, 1993, p. 174,
63. R. B. Doak, J. McCarter, M. Green, S. Duerdeen, D. Evans, R. Roedel and P. Williams, Animated spreadsheets as a teaching resource on the freshman level (2000). (Electronic article.)
64. T. F. Edgar, Chemical engineering education and the three C's: computing, communication, and collaboration, Annual Meeting, Los Angeles, CA, November 12-17, 2000.
65. T. T. Phan, Technical considerations for the evaluation of electronic spreadsheets for complying with 21 CFR Part II (2003). (Electronic article.)
66. Y. K. Wong, Application of a spreadsheet program to control system design, Int. J. Elect. Eng. Educ., 29, 1992, pp. 16-23,
67. S. J. Davis, Tools for spreadsheet auditing, Int. J. Human-Computer Studies, 45, 1996, pp. 429-442.
68. Y. Kuo and W. Kuo, Application of electronic spreadsheets to linear and integer programming, Int. J. Applied Engineering Education, 3(6), 1987, pp. 563-575.