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

Creative Commons License
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

Download

Share

COinS