Excel grader and access grader

ABSTRACT

Excel Grader is an automated grader for use by instructors in Microsoft Excel and Microsoft Office application courses. Excel Grader performs static analysis on Microsoft Excel workbooks. The program compares a student workbook with the instructor's correct version of the workbook. The student workbook is marked and a grade report is embedded. Excel Grader includes reports and a tool for plagiarism detection. Access Grader is a companion product that grades Microsoft Access assignments. Access Grader embeds an "ERRORS" table in the student database. Access Grader grades database table and queries. Access Grader has similar reports and user interface as Excel Grader. The graders have been tested in thirty-nine Microsoft Office applications classes (with about 800 students) over two semesters. Thousands of assignments have been graded. According to a survey of instructors using the programs, the graders were extremely accurate and saved hours of grading time. Students that were surveyed felt the grading was fair and accurate.

REFERENCES

• 1: Dolinsky, Jens-Uwe and Pawletta, Thorsten, Interpreter for symbolic manipulation of mathematical expressions, Internet WWW page, at URL <http://www.mb.hs-wismar.de/~pawel/Uwe/casE.html> (version current at September 12, 2001).
• 2: Foxley, E., Higgins, C. A., Tsintsifas, A and Symeonidis, P, The Ceilidh CourseMaster System, An Introduction, 4th Java in the Curriculum Conference, South Bank University, UK, 24th Jan 2000.
• 3: George E. Forsythe , Niklaus Wirth, Automatic grading programs, Communications of the ACM, v.8 n.5, p.275-278, May 1965 [doi>10.1145/364914.364937]
• 4: Thomas G. Hill , Dawn Wilkins, Meager and madbags: automated graders for microsoft excel and access assignments, 2003
• 5: Joy, Mike, and Luck, Michael, The BOSS System for On-line Submission and Assessment. Monitor: Journal of the CTI Centre for Computing 10 pp. 27--29, 1998
• 6: McQuain, William, Curator Introduction. Internet WWW pages and documentation at http://ei.cs.vt.edu/~eags/Curator.html (version current at September 8, 2000).
• 7: Pierce, Matt, MDB Diff. Internet WWW page, at URL <http://jupiter.drw.net/matpie/PBSystems/products/retired/MDBDiff.html> (version current at October 7, 2000).
• 8: Cashman Shelly , Gary B. Shelly , Misty E. Vermaat , Thomas J. Cashman, Office 2000: Introduction to Concepts and Techniques, Course Technology Press, 2000
• 9: Gary B. Shelly , Thomas J. Cashman , Steven Forsythe, Microsoft Windows XP Introductory Concepts and Techniques, Course Technology Press, 2001
• 10: Thomson Learning/Course Technology. Course Technology - SAM. Internet WWW page, at URL <http://www.course.com/assessment/sam/default.cfm> (version current at November 29, 2002).
• 11: urs von Matt, Kassandra: the automatic grading system, ACM SIGCUE Outlook, v.22 n.1, p.26-40, January 1994 [doi>10.1145/182107.182101]

INDEX TERMS

Keywords:
automatic grading, microsoft excel access automated grader