Cohenour, C., & Hilterbran, A. (2016, June), Automated Grading of Excel Workbooks Using Matlab  Paper presented at 2016 ASEE Annual Conference & Exposition, New Orleans, Louisiana. 10.18260/p.26352

\bibitem{asee_peer_26352}
  Cohenour, C., \& Hilterbran, A. (2016, June), \emph{Automated Grading of Excel Workbooks Using Matlab}
  Paper presented at 2016 ASEE Annual Conference \& Exposition, New Orleans, Louisiana.
  10.18260/p.26352

Curtis Cohenour Ph.D., P. E. and Audra Hilterbran.  "Automated Grading of Excel Workbooks Using Matlab".  2016 ASEE Annual Conference & Exposition, New Orleans, Louisiana, 2016, June.  ASEE Conferences, 2016.  https://peer.asee.org/26352 Internet.  12 Mar, 2025

\bibitem{asee_peer_26352}
  Curtis Cohenour Ph.D., P. E. and Audra Hilterbran.
  "Automated Grading of Excel Workbooks Using Matlab".
  \emph{2016 ASEE Annual Conference \& Exposition, New Orleans, Louisiana, 2016, June}.
  ASEE Conferences, 2016.
  https://peer.asee.org/26352 Internet.  12 Mar, 2025

@INPROCEEDINGS{asee_peer_26352
author = "Curtis Cohenour Ph.D., P. E. and Audra Hilterbran"
title = "Automated Grading of Excel Workbooks Using Matlab"
booktitle = "2016 ASEE Annual Conference \& Exposition"
year = "2016"
month = "June"
address = "New Orleans, Louisiana"
publisher = "ASEE Conferences"
note = {https://peer.asee.org/26352}
number = {10.18260/p.26352}
}

TY  - CPAPER
AB  - This evidence based practice paper describes a means to grade Excel Workbooks using ActiveX Com controls in Matlab®.  The automated Excel grader frees the instructor or teaching assistant for instructional efforts with a greater impact on student outcomes.  The Benchmark Series Excel 2013 text is used.  The text provides a starting workbook, and step by step instruction for the student to modify the workbook using the features of Microsoft Excel.   This text works well with application oriented students.  A single chapter of the Benchmark text requires 2.5 minutes just too manually open and close all of the files for one student.  Grading 70 students, allowing 15 minutes per student would require 17.5 hours.  The Matlab® grader can perform detailed grading of the same files with just a few minutes of set up time.  
The automated grader compares each cell of the student’s workbook submission with the master workbook to compute the number of correct answers.  The number of possible correct answers is determined by comparing the master workbook with the starting workbook.  This process is repeated for multiple sheets in multiple workbooks to compute the student’s grade.  In addition printouts in PDF format can be checked for inclusion in the grade.  The student receives an email with his or her grade and a detailed list of errors with the cell location of the error.
Without automated grading the bulk of the assessment would be based on periodic exams that may allow a student to get so far behind that he or she cannot recover.  With automated grading the student receives immediate and detailed feedback on each chapter.  
This paper addresses numerous issues with the development of the grader, the impact on student outcomes, and additional work to be done.

AU  - Curtis Cohenour Ph.D., P. E.
AU  - Audra Hilterbran
CY  - New Orleans, Louisiana
DA  - 2016/06/26
PB  - ASEE Conferences
TI  - Automated Grading of Excel Workbooks Using Matlab
UR  - https://peer.asee.org/26352
DO  - 10.18260/p.26352
ER  -