An Easy-to-Use Spreadsheet for Batch Production of Math-Based Problems with Guided Feedback on Distractor Choices for General Chemistry

A series of spreadsheets, organized by traditional general chemistry topics, was made for batch production of questions that involve mathematical calculations for general chemistry courses. To use the files, the instructor only needs to change the starting data, and a unique question will be generated, including the correct answer and plausible distractors. Guided feedback accompanies the distractors for incorporation into an assignment the instructor may create on a Learning Management System or for any offline use.

Authors

Institutions

Publication Details

Journal
Journal of Chemical Education
Published
2025-02-07
DOI
https://doi.org/10.1021/acs.jchemed.3c00954
Primary Topic
Intelligent Tutoring Systems and Adaptive Learning
Type
article
Field-Weighted Citation Impact
0.00
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
article

An Easy-to-Use Spreadsheet for Batch Production of Math-Based Problems with Guided Feedback on Distractor Choices for General Chemistry

John G. D’Angelo, David A. Marsh
Journal of Chemical Education
Intelligent Tutoring Systems and Adaptive Learning
article

An Easy-to-Use Spreadsheet for Batch Production of Math-Based Problems with Guided Feedback on Distractor Choices for General Chemistry

John G. D’Angelo, David A. Marsh
article en

Abstract

A series of spreadsheets, organized by traditional general chemistry topics, was made for batch production of questions that involve mathematical calculations for general chemistry courses. To use the files, the instructor only needs to change the starting data, and a unique question will be generated, including the correct answer and plausible distractors. Guided feedback accompanies the distractors for incorporation into an assignment the instructor may create on a Learning Management System or for any offline use.

Journal of Chemical EducationVol. 102(3)
Alfred University (US)
Openalex Percentile: Top 99%
Intelligent Tutoring Systems and Adaptive Learning
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.