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...
Main Authors: | , , |
---|---|
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 |