Automated Rubric Generation and Analysis for Assurance of Learning Tasks

The AACSB now requires that assurance of learning (AOL) tasks in business schools must include course embedded assessments that directly measure student performance within the context of classes in the business core and/or major disciplines. The generally accepted format for presenting and documenting these assessments are rubrics. These rubrics include lists of learning objectives and ratings to assign for selected students on certain projects and/or examinations. Rubric data is then collated and reported for the purpose of identifying performance trends, ultimately leading to course and program improvements. This can be a very labor-intensive process, and information technology may be useful to reduce manual and time consuming operations. This paper presents an Excel macro that assists in automating the process of generating rubrics, scoring student performance, and summarizing assessment results.