Paper Details

Name: Suman & Ravindra Kumar Vishwakarma
Country: India

Year: 2026
Volume: Volume-13, Issue-1 (January-June)
Page Number: 88-96
DOI: https://doi.org/10.5281/zenodo.18918686

ABSTRACT
The high growth rate of the large scale tests and the constant assessment programs in the learning institutions has placed a high demand on the need to have the right, fast, and inexpensive evaluation systems. Conventional Optical Mark Recognition (OMR) systems are costly, special hardware is necessary, and it is not flexible to small and medium educational institutions. This paper is an account of the design and implementation of an excel based
OMR application to improve efficiency, accessibility and reliability of Multiple Choice Question (MCQ) evaluation processes. The system proposed takes advantage of the computing power of the Microsoft Excel along with automated macros and formula-driven recognition algorithms to scan answer sheets and provide student responses with real-time scoring reports. The application removes the use of proprietary OMR machines and guarantees high accuracy, minimized processing time and low cost of operation. Major ones are automatic roll number recognition, dynamic answer key management, immediate generation of results and detailed performance analysis. As shown in experimental evaluation the system developed is able to save the evaluation time by over 70 percent of the time that it would have taken with manual correction methods without compromising the accuracy of the results, which is above 99 percent. The solution provides a scalable, easy to use option that can be used in schools, colleges, and training institutions to find an affordable digital assessment tool. This writing will add a viable and finely sustainable method to revamp the evaluation of examination using software infrastructure that is widely accessible.
Keywords—Excel-based OMR, MCQ evaluation, Optical Mark Recognition, Automated assessment, Digital examination system, Result processing automation, Educational technology, Low-cost OMR solution, Academic analytics, Spreadsheet-based evaluation system.