Dynamic E-Certificate Designing with Automatic Mailing System using Python and SQLite3

Abstract

In the scenario where things are getting online, including education, the number of online courses and even online degrees is increasing day-by-day. After the COVID-19 outbreak, most of the seminars, workshops, and trainings have switched over to the virtual platform, and the organizations are providing the virtual certificates, or e-certificates, which save a lot of effort for both the learner and the organization. Most organizations face the issue of designing different certificates for different requirements and events, which can sometimes be harder to design on demand. Currently, the system available is capable of inserting the name of the candidate into the pre-designed certificate. Also, certificates need to be designed first on some designing software, and then a script is used to insert names at the desired location. The aim of the project is to reduce the institute’s overhead of designing certificates for various different events. Our project aims to solve the issue by providing a number of choices for the institute to generate certificates as per their needs. The built-in material for different kinds of certificates, which include certificates of participation, certificates of appreciation, certificates of attendance, etc., eases the institute’s overhead for designing multiple certificates. The dynamic approach enables the certificate to be designed dynamically whenever needed. Furthermore, the certificates will be mailed to the respective candidates, providing feedback on every mail sent by the system. It involves very little human effort and is reliable due to the feature of automatic mailing and keeping a backup of original certificates.

Keywords: Automated E-Mailing, E-Certificate, Python, SQLite3.

View PDF