Optimizing a Windows-Based Computer Data Acquisition and Reduction System for the General Chemistry Laboratory

优化普通化学实验室基于Windows的计算机数据采集和还原系统

• 批准号: 9652855
• 负责人: Edward Vitz
• 金额: $ 15.7万
• 依托单位: Kutztown University
• 依托单位国家: 美国
• 项目类别: Standard Grant
• 财政年份: 1997
• 资助国家: 美国
• 起止时间: 1997-01-01 至 1999-12-31
• 项目状态: 已结题
• 来源: https://www.nsf.gov/awardsearch/showAward?AWD_ID=9652855&HistoricalAwards=false
• 关键词: Optimizing; Windows; Based; Computer; Data

The product of this project will be a Windows-based data acquisition and reduction system for general chemistry laboratories that is based on inexpensive, generic hardware and standard software. The DOS-based LIMSport system which it will succeed has been used for years in our laboratories with success, and has been disseminated nationwide by means of seven, week-long NSF/UFE Summer workshops. Most universities are now converting to Windows-based software. This necessitates a revision of LIMSport, but it also offers an opportunity for substantial improvement. Our system is unique in that it adds data acquisition capability to the most popular spreadsheets (Excel and Lotus), so that students learn standard, transferable methods of data analysis in the laboratory, and teachers can use the system as an authoring language to create their own experiments involving direct data acquisition. We will prepare spreadsheet templates for a number of typical general chemistry experiments which illustrate ways of using the powerful graphical and numerical methods built into modern spreadsheets to reveal trends in real-time data as they are collected. An extensive evaluation plan has been developed to determine which computer methods are most effective in promoting student learning in the laboratory. A laboratory manual will be written for the new Windows/Excel version of LIMSport which incorporates the results of our work as well as features suggested by the large body of research on educational chemistry laboratories. The manual will provide background information for about 30 experiments which are suitable for General Chemistry, using the capability of LIMSport to utilize small quantities of relatively innocuous chemicals.

该项目的产品将是基于通用化学实验室的基于Windows的数据采集和还原系统，该系统基于廉价，通用硬件和标准软件。它将成功的基于DOS的LIMSPORT系统在我们的实验室中成功使用了多年，并且已通过七个为期一周的NSF/UFE夏季研讨会在全国范围内传播。大多数大学现在都转换为基于Windows的软件。这需要对Limsport进行修订，但它也为改进的机会提供了机会。我们的系统是独一无二的，因为它为最受欢迎的电子表格（Excel和Lotus）添加了数据采集能力，因此学生在实验室中学习标准的，可转移的数据分析方法，教师可以将系统用作创作语言来创建自己的实验，以涉及直接数据获取。我们将为许多典型的通用化学实验准备电子表格模板，这些模板说明了使用在现代电子表格中内置的强大图形和数值方法来揭示收集到实时数据的趋势的方法。已经制定了广泛的评估计划，以确定哪些计算机方法最有效地促进实验室的学生学习。将为Limsport的新Windows/Excel版本编写一本实验室手册，其中包含了我们工作的结果以及有关教育化学实验室的大量研究所建议的功能。该手册将使用Limsport的能力利用少量相对无害的化学物质的能力，为大约30个实验提供背景信息。