ERIC Number: EJ1159639
Record Type: Journal
Publication Date: 2017-Aug
Abstractor: As Provided
Teaching Simulation and Computer-Aided Separation Optimization in Liquid Chromatography by Means of Illustrative Microsoft Excel Spreadsheets
Fasoula, S.; Nikitas, P.; Pappa-Louisi, A.
Journal of Chemical Education, v94 n8 p1167-1173 Aug 2017
A series of Microsoft Excel spreadsheets were developed to simulate the process of separation optimization under isocratic and simple gradient conditions. The optimization procedure is performed in a stepwise fashion using simple macros for an automatic application of this approach. The proposed optimization approach involves modeling of the peak shapes in order for the simulation of predicted chromatograms to be possible. The performance of the selected optimization procedure was tested by means of experiments performed on a reversed-phase column that produced Gaussian peaks for all solutes, providing benefits for computational simplicity. The separation optimization by Microsoft Excel especially with simple and easily implemented macros is a challenging pedagogical tool for advanced analytical chemistry courses. An illustrative video given in the Supporting Information supports a novice Excel practitioner in following the proposed separation optimization procedure.
Descriptors: Simulation, Spreadsheets, Chemistry, Science Laboratories, Laboratory Experiments, Computer Assisted Instruction, Undergraduate Students, Science Experiments, Science Instruction, College Science
Division of Chemical Education, Inc and ACS Publications Division of the American Chemical Society. 1155 Sixteenth Street NW, Washington, DC 20036. Tel: 800-227-5558; Tel: 202-872-4600; e-mail: firstname.lastname@example.org; Web site: http://pubs.acs.org/jchemeduc
Publication Type: Journal Articles; Reports - Descriptive
Education Level: Higher Education
Authoring Institution: N/A
Grant or Contract Numbers: N/A