June 15, 2019
June 15, 2019
October 19, 2019
Computers in Education
Microsoft Excel is commonly used to perform engineering calculations and present data. Manual grading is time consuming for the instructor and provides delayed feedback for the students. An automated grading program has been developed for Microsoft Excel spreadsheets which can grade both cell formulae and styles, matching the students work to a grading template. Students are provided feedback in comments in the cells where they have made a mistake. In addition, the program can also grade Excel graphs, evaluating graph data as well as type of graph (line, XY scatter, …) as well as line and marker styles for each element. Students submit their work via email, and receive an immediate response from the program, allowing the students to make corrections on their work. The effectiveness of the students learning while using the grading system is evaluated by comparing students’ scores on the exam covering the Excel material before and after the grading system was implemented. Also, the grades on comparable assignments is evaluated. In addition, student’s opinions about the program have been surveyed. Automated grading has been found to be beneficial to both students and instructors.
Hekman, K. (2019, June), Automated Grading of Microsoft Excel Spreadsheets Paper presented at 2019 ASEE Annual Conference & Exposition , Tampa, Florida. 10.18260/1-2--32135
ASEE holds the copyright on this document. It may be read by the public free of charge. Authors may archive their work on personal websites or in institutional repositories with the following citation: © 2019 American Society for Engineering Education. Other scholars may excerpt or quote from these materials with the same citation. When excerpting or quoting from Conference Proceedings, authors should, in addition to noting the ASEE copyright, list all the original authors and their institutions and name the host city of the conference. - Last updated April 1, 2015