ERIC Number: EJ1273349
Record Type: Journal
Publication Date: 2020-Sep
Pages: 8
Abstractor: As Provided
ISBN: N/A
ISSN: ISSN-0021-9584
EISSN: N/A
A Self-Directed Workshop for Developing Advanced Data Processing and Analysis Skills in Chemistry Using Microsoft Excel
Campbell, Craig D.; Smallwood, Zoe M.; Stewart, Malcolm I.
Journal of Chemical Education, v97 n9 p2635-2642 Sep 2020
Data-handling, processing, and analysis skills are an integral part of a chemist's skill set and, more generally, are highly sought by employers. We report a self-directed workshop to develop and advance these key skills using the popular spreadsheet program Microsoft Excel. Making use of its accessible user interface, various contextualized problems relevant to chemistry are introduced, linking theory to practical applications and providing insight and understanding of processes that operate behind-the-scenes in many specialized data processing packages. The workshop has been delivered as a remote exercise for both our first and second year undergraduate cohorts (216 students completed). Students reported a positive impact from the workshop, including the development of a wide range of important skills, the utility for future practical work, and the effectiveness of communication remotely to address their issues.
Descriptors: Chemistry, Science Instruction, Spreadsheets, Teaching Methods, Computer Software, Data Analysis, Workshops, Undergraduate Students, Student Attitudes, Independent Study, Skill Development
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 - Research
Education Level: Higher Education; Postsecondary Education
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A
Grant or Contract Numbers: N/A