Spreadsheet Activities with Conditional Progression and Automatically Generated Feedback and Grades

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%.