Spreadsheet Activities with Conditional Progression and Automatically Generated Feedback and Grades
feedback, macros, spreadsheets, SSAC, VBA programming
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%.
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?
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.