Document Type
Article
Publication Date
2012
Keywords
feedback, macros, spreadsheets, SSAC, VBA programming
Abstract
Spreadsheet activities following the Spreadsheets Across the Curriculum (SSAC) model have been modified using VBA programming to automatically generate feedback, calculate grades, and ensure that students complete them in a linear fashion. Feedback is based not only on the value of cells, but also on the formulas used to compute the values. These changes greatly ease the burden of grading on instructors, and help students more quickly master tasks and concepts by providing immediate and directed feedback to their answers. Students performed significantly better on the new spreadsheet activities compared to traditional SSAC versions, with 87% achieving perfect scores of 100%.
Rights Information
This work is licensed under a Creative Commons Attribution-Noncommercial-No Derivative Works 4.0 License.
Was this content written or created while at USF?
Yes
Citation / Publisher Attribution
Spreadsheets in Education, v. 6, issue 1, art. 4
Scholar Commons Citation
Juster, Thomas C., "Spreadsheet Activities with Conditional Progression and Automatically Generated Feedback and Grades" (2012). School of Geosciences Faculty and Staff Publications. 963.
https://digitalcommons.usf.edu/geo_facpub/963