Marks2CSV is an innovative tool designed to automate the process of converting student marks from answer sheet tables into well-structured CSV files. This utility is particularly useful for educators of SJCET, Palai who handle multiple student answer sheets and need to systematically record marks for further assessment and analysis.
Traditionally, marks from internal exams are recorded on the front of each student's answer sheet, with individual question scores noted. Educators are then tasked with the laborious job of transcribing these marks into a CSV file format that adheres to specific requirements for further mapping to Course Outcomes (COs). This manual process is not only time-consuming but also prone to errors.
Marks2CSV simplifies this process. For a class of 60 students, instead of manually typing each student's marks into a spreadsheet, educators can now ease this process by just providing pictures of front of answer sheet to the system and Marks2CSV will do the rest.
-
Receives the Captured Image: Begin by capturing an image of the entire answer sheet.
-
Crop and Warp Image: The image is then cropped and warped to focus only on the answer sheet section.
-
Extract Table Containing Marks: From the warped image, extract the table that contains the marks.
-
Crop Out Each Cell of the Table: Isolate each cell within the table for further processing.
-
Text Recognition: Each cropped cell is fed into the model for text recognition to detect the marks written inside.
-
Map the Predicted Marks: Convert the recognized marks of current answer sheet into the required CSV format.
-
Repeat for Other Students: This entire process is repeated for each student's answer sheet.
As Marks2CSV continues to evolve, we aim to expand its capabilities and accessibility. Key developments in the pipeline include:
-
Desktop Application: Package the system into a standalone desktop application, complete with an easy-to-install setup. This will provide educators with a robust, user-friendly interface directly on their PCs, streamlining the process further.
-
Integrated Webcam Stand: Develop a customized webcam stand setup that can be bundled with the desktop application. This stand will help educators consistently capture high-quality images of answer sheets without the need for manual adjustments, ensuring optimal results.
-
Mobile Application: Extend functionality to a mobile platform, allowing educators to capture, process, and convert marks into CSV files directly from their smartphones. This mobile app will offer convenience and portability, making it possible to handle grading tasks on the go.
These enhancements are aimed at making Marks2CSV not just a tool but a comprehensive solution for educational assessment management.
This project is a continuation of the work initiated by our seniors. We build upon the foundation laid in the previous version of the Marks2CSV tool.
- Original Project: View the initial project here.