.png){kind=icon}
.png){kind=icon}
Return
Using Self-Checking Spreadsheets to Reduce Instructor Grading Load and Encourage Skill Development
.png){kind=icon}
PRE
AI
DOI：10.1021/acs.jchemed.5c01156.png)
.png){kind=icon}
Original request for help.png){kind=icon}
Share.png){kind=icon}
Save
Abstract
En 中文
Spreadsheets are frequently used to organize, analyze, and communicate data in the laboratory and the business world. One challenge with using spreadsheets in the teaching laboratory is that they can be time-intensive to grade, and it can be hard to detect formula errors with real data. To reduce the instructor grading load and empower students to find their own data-entry-related mistakes, we developed self-checking spreadsheets. These spreadsheets, which have been implemented in multiple assignments in a second-semester general chemistry laboratory, show students whether their calculations are correct. They use a combination of IF logic and conditional formatting to display a green checkmark (correct) or a red X (incorrect). The implementation of these spreadsheets has reduced grading time and the instructor's role in searching for data-entry-related errors while improving the quality of student work. Students have commented that the self-check feature improves their confidence, reduces their stress, and improves their learning. This easy-to-implement and adaptable spreadsheet modification can be employed in many contexts.
Keywords:
First-Year Undergraduate/General
Laboratory Instruction
Computer-Based Learning
Laboratory Computing/Interfacing,UV-vis Spectroscopy
Kinetics
Journal
IF:
2.9
Papers:
1.2K
Citations:
2.3W