A TUTORIAL ON COMPUTER SPREADSHEETS AND THEIR APPLICATIONS IN ENGINEERING ANALYSIS/COMPUTATIONS
Abstract
Traditionally, scientists and engineers use computers for problem solving, mainly through programming in such languages as FORTRAN, BASIC, Pascal, or more recently, C. While this is the only approach for very complex and intensive computations, other tools with which one may quickly solve a variety of other problems (without much programming and debugging that is characteristic of the programming language approach) now exist. One of these, which has become very popular is the spreadsheet software. Given its versatility and the fact that it is simple to learn, and to use, it is clearly desirable that students, scientists and engineers become familiar with this powerful analytical and graphical tool. Thus this tutorial paper hopes to provide a brief but functional overview of spreadsheet software, with some illustrations of their applications in scientific an engineering computations. In particular, the paper answers the question what are spreadsheets? and discusses the categories of allowable data types, and how to.enter these into a spreadsheet software. Three examples which include detailed step-by-step procedure for setting up the computer spreadsheet solution are used for illustrations. The paper should be of interest to all science, technology and engineering students; as well as professional scientists, engineers and technologists.