For the topic of chemistry as a major, the concept of computational chemistry has been implemented in my class for many years. During the first several years, the algebraic computation program, e.g., REDUCE had been employed, which proved to be effective from this point of view. The demerit of using REDUCE, however, can be pointed out as a fact that the introduction of REDUCE programming technique which has no relation to the main theme of the class, cannot be avoided. This difficulty can be overcome by using the ordinary spreadsheet software like Microsoft Excel. The spreadsheet software is now recognized as one of the most common literacy training subjects for all freshmen. In this report, using tools in Excel, two examples of supplemental methodologies related with the Eigen Value Problem and the Deconvolution Technique in Spectroscopy are discussed, both of which are very useful concepts of practical applicability for the students of chemistry major.
View full abstract