Automated Assignment Management System: Integrating Email Inbox Parsing, Database Updates, and Notification

This paper presents the design and implementation of an automated assignment management system utilizing a bot interface. The system's primary objective is to streamline the process of collecting and tracking student assignments, ensuring timely updates to a central database, and facilitating communication between students and teachers. The bot employs email inbox parsing techniques to identify incoming assignment submissions, extracting relevant data such as student names, assignment details, and submission timestamps. Upon receiving a submission, the bot updates an Excel database with the pertinent information, maintaining an organized record of completed assignments. Furthermore, the system incorporates a notification feature to promptly alert students who have not yet submitted their assignments by the deadline. Leveraging email integration, the bot sends personalized notifications reminding students of impending deadlines and urging them to submit their work promptly. Additionally, the bot generates a list of incomplete assignments and forwards it to the respective teacher, providing a consolidated overview of students who require follow-up. By automating the assignment management process, this system reduces manual intervention, minimizes administrative burden, and enhances efficiency in monitoring student progress. The integration of email parsing, database updates, and notification functionalities ensures seamless communication and facilitates timely submission of assignments, contributing to improved academic outcomes and instructor student engagement