NotesFAQContact Us
Collection
Advanced
Search Tips
Back to results
Peer reviewed Peer reviewed
Direct linkDirect link
ERIC Number: EJ1278150
Record Type: Journal
Publication Date: 2020-Sep
Pages: 5
Abstractor: As Provided
ISBN: N/A
ISSN: ISSN-0021-9584
EISSN: N/A
Available Date: N/A
Online Data Generation in Quantitative Analysis: Excel Spreadsheets and an Online HPLC Simulator Using a Jupyter Notebook on the Chem Compute Web Site
Journal of Chemical Education, v97 n9 p2950-2954 Sep 2020
Students used an Excel spreadsheet and a Jupyter notebook located at https://chemcompute.org/jupyterhub/ to generate data in lieu of face-to-face laboratory instruction during COVID-19. This communication discusses strengths and weaknesses of both exercises. First, students generated absorbance data using an Excel spreadsheet, but they were overwhelmingly put off by simulated noise in their absorbance values. Second, students simulated running an HPLC using a Jupyter notebook and designed a method to separate three components of Excedrin. Students reported that the simulation helped them to understand HPLC and suggested that the online activity be used as a supplement when face-to-face laboratory instruction resumes. The main weakness of the online activities was that students did not perform any sample preparation. Therefore, they did not experience the extractions and dilutions required to prepare the analytical sample and had a difficult time working backward to calculate starting amounts from simulated sample concentrations. Concerns that students would extract answers from the equations used in the spreadsheet and Jupyter notebook were not realized.
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: eic@jce.acs.org; Web site: http://pubs.acs.org/jchemeduc
Publication Type: Journal Articles; Reports - Descriptive
Education Level: N/A
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A
Grant or Contract Numbers: N/A
Author Affiliations: N/A