A self-directed workshop for developing advanced data processing and analysis skills in chemistry using Microsoft Excel

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 access...

Full description

Bibliographic Details
Main Authors: Campbell, CD, Smallwood, ZM, Stewart, MI
Format: Journal article
Language:English
Published: American Chemical Society 2020
_version_ 1797075030792732672
author Campbell, CD
Smallwood, ZM
Stewart, MI
author_facet Campbell, CD
Smallwood, ZM
Stewart, MI
author_sort Campbell, CD
collection OXFORD
description 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.
first_indexed 2024-03-06T23:44:38Z
format Journal article
id oxford-uuid:7079a75c-d468-478b-a99d-3bbc3e773905
institution University of Oxford
language English
last_indexed 2024-03-06T23:44:38Z
publishDate 2020
publisher American Chemical Society
record_format dspace
spelling oxford-uuid:7079a75c-d468-478b-a99d-3bbc3e7739052022-03-26T19:37:28ZA self-directed workshop for developing advanced data processing and analysis skills in chemistry using Microsoft ExcelJournal articlehttp://purl.org/coar/resource_type/c_dcae04bcuuid:7079a75c-d468-478b-a99d-3bbc3e773905EnglishSymplectic ElementsAmerican Chemical Society2020Campbell, CDSmallwood, ZMStewart, MIData-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.
spellingShingle Campbell, CD
Smallwood, ZM
Stewart, MI
A self-directed workshop for developing advanced data processing and analysis skills in chemistry using Microsoft Excel
title A self-directed workshop for developing advanced data processing and analysis skills in chemistry using Microsoft Excel
title_full A self-directed workshop for developing advanced data processing and analysis skills in chemistry using Microsoft Excel
title_fullStr A self-directed workshop for developing advanced data processing and analysis skills in chemistry using Microsoft Excel
title_full_unstemmed A self-directed workshop for developing advanced data processing and analysis skills in chemistry using Microsoft Excel
title_short A self-directed workshop for developing advanced data processing and analysis skills in chemistry using Microsoft Excel
title_sort self directed workshop for developing advanced data processing and analysis skills in chemistry using microsoft excel
work_keys_str_mv AT campbellcd aselfdirectedworkshopfordevelopingadvanceddataprocessingandanalysisskillsinchemistryusingmicrosoftexcel
AT smallwoodzm aselfdirectedworkshopfordevelopingadvanceddataprocessingandanalysisskillsinchemistryusingmicrosoftexcel
AT stewartmi aselfdirectedworkshopfordevelopingadvanceddataprocessingandanalysisskillsinchemistryusingmicrosoftexcel
AT campbellcd selfdirectedworkshopfordevelopingadvanceddataprocessingandanalysisskillsinchemistryusingmicrosoftexcel
AT smallwoodzm selfdirectedworkshopfordevelopingadvanceddataprocessingandanalysisskillsinchemistryusingmicrosoftexcel
AT stewartmi selfdirectedworkshopfordevelopingadvanceddataprocessingandanalysisskillsinchemistryusingmicrosoftexcel