Build Complete School Management Software | Python PyQt5 SQL

Develop a complete school management software using Python, PyQt5, Qt Designer & Mysql | Step by step coding guide

Dear Student,

Welcome to Build School Management System | Python, PyQt5 & Qt Designer Course

I welcome you all to the course to get a good knowledge about PYTHON PYQT5 real time project development.

Students can complete a wonderful complete python software with all requirements from GUI Development, Database design, Table design, back end coding with python.

Students, I am sure this course will be a biggest milestone in your career if you complete this course filly without skipping any lesson.

Do you want to get in depth knowledge in Python GUI programming using Pyqt. This course teaches how to develop a complete school management system project using python pyqt. This project teaches how to create form designs using Qt Designer and how to integrate the user interface with python file.

This course teaches how to create a login form, student details form, attendance details form, mark details form, fees details form using Qt Designer.

How to create Labels, Images, Text fields (Line Edit), Multi line text fields (Text Edit), Combo boxes, Message boxes, Buttons, Tab widgets, Menu bars, Table widgets are explained using Qt Designer

How to create Mysql database, how to create tables in the database, how to insert data, update data, delete data and select data from user interface to mysql database through python code are explained in this course.

The students will learn how to develop the following modules using Qt Designer and write python code to connect with user interface and with mysql database.

Login module

How to create a login using Qt Designer and how to write python code to connect with user interface, the administrator will enter the username and password, if the username and password are correct, it will open the main form. If the details are not correct, it will show error message.

This login form displays the message using message box. This form uses lineEdit, QPushButton, QLabel controls from Qt Designer.

Student Module

In the student module, all student details like registration number, date of birth, age, section, address, phone number and email are entered in the form. All the entered details are stored in the database. After save the administrator can perform edit or delete, if the administrator want to edit the entered details or delete the details.

Mark details

In the mark module, all mark details like registration number, exam name, language mark, English mark, maths mark, science mark and social science marks are entered in the form. All the entered details are stored in the database. After save the administrator can perform edit or delete, if the administrator wants to edit the entered mark details or delete the mark details

Attendance details

In the attendance module, all attendance details like registration number, attendance date, morning attendance status, evening attendance status are entered in the form. All the entered details are stored in the database. After save the administrator can perform edit or delete, if the administrator wants to edit the entered attendance details or delete the attendance details

Attendance details

In the fees module, all fees details like receipt number, registration number, fees amount, fees date, reason for fees are entered in the form. All the entered details are stored in the database. After save the administrator can perform edit or delete, if the administrator wants to edit the entered fees details or delete the fees details

Receipt

The administrator can take print out of the receipt after entering the receipt details and edit fees details. The receipt are generated automatically when add fees or edit fees form is executed.

Reports

The system generates the student reports, mark reports, attendance reports and fees reports for the administrator.

Export to Excel

The administrator can view the reports in QTableWidget from mysql database table. In the reports page, we have a download button. When the admin click on the download button, the reports will be exported as EXCEL file in the project folder. This export process needs pandas library to be imported.