ERIC Number: EJ1043290
Record Type: Journal
Publication Date: 2014-Oct
Abstractor: As Provided
Reference Count: 15
Spreadsheet-Based Program for Simulating Atomic Emission Spectra
Flannigan, David J.
Journal of Chemical Education, v91 n10 p1736-1738 Oct 2014
A simple Excel spreadsheet-based program for simulating atomic emission spectra from the properties of neutral atoms (e.g., energies and statistical weights of the electronic states, electronic partition functions, transition probabilities, etc.) is described. The contents of the spreadsheet (i.e., input parameters, formulas for calculating emission intensities, etc.) are in full view and are controllable by the student and instructor, and the result of changing temperature and line width on relative intensities can be observed in real time. Thorough descriptions of how to use the spreadsheet-based program, how to extract relevant quantum mechanical properties from the NIST Atomic Spectra Database, and how to create a new worksheet for an element of interest are also included. It is envisioned that the program will serve as a means for instructors to link atomic emission in the visible region of the electromagnetic spectrum, as in the flame test demonstration, to the theoretical concepts of statistical and quantum mechanics encountered in advanced physical and analytical chemistry courses.
Descriptors: Spreadsheets, Simulation, College Science, Chemistry, Nuclear Physics, Computer Uses in Education, Advanced Courses, Science Instruction
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; Postsecondary Education
Authoring Institution: N/A