ERIC Number: EJ1195672
Record Type: Journal
Publication Date: 2018-Oct
Pages: 5
Abstractor: As Provided
ISBN: N/A
ISSN: ISSN-0021-9584
EISSN: N/A
Color Space Mathematical Modeling Using Microsoft Excel
Delgado-González, M. J.; Carmona-Jiménez, Y.; Rodríguez-Dodero, M. C.; García-Moreno, M. V.
Journal of Chemical Education, v95 n10 p1885-1889 Oct 2018
Colorimetry allows every color to be defined as a combination of three values, known as "color coordinates." Color coordinates allow researchers to universalize and standardize their color measurements, and nowadays, determining the color coordinates of samples is a routine method applied by organic and analytical chemists, students, and specialists like enologists. Although the colorimetry method requires a simple experimental procedure, many students, researchers and teachers might find the mathematical treatment of the data too difficult. In this paper, we introduce two workbooks using Microsoft Excel with Microsoft Visual Basic that simplify the use of colorimetry: one of these workbooks is specifically oriented to students and teachers, and it includes explanations and information about each color model. The second workbook is aimed at researchers, and it allows them to introduce and analyze numerous samples at the same time. Finally, another workbook has been included that contains various sample spectra that teachers can use to improve student comprehension of color coordinates.
Descriptors: Mathematical Models, Spreadsheets, Color, Chemistry, Instructional Materials, Science Instruction, Measurement, Scientific Research, Researchers
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