Student Grade Management System in Python: Requirements, Design, and Implementation

1. Requirement Analysis The system should manage student records (ID, name, department, three course scores, average exam score, peer evaluation, teacher evaluation, and a weighted comprehensive score), support data persistence with a database, provide full CRUD operations, offer a console/desktop GUI, and handle Excel import/export via xlrd and xlwt .

2. Functional Design & Analysis

(1) Database Access Use the PyMySQL module to connect to a MySQL database. Install with pip install PyMySQL and import via import pymysql . Create a database school and tables student_score and teacher_login (e.g., with Navicat or SQL statements).

(2) Excel Import Install xlrd ( pip install xlrd ) and import via import xlrd . Open an Excel file, iterate over sheets and cells, and insert each row into the database.

(3) PyMySQL Utility Class Define PyMySQLUtils with methods:

def __init__(self) – open connection and create cursor.

def fetchall(self, sql) – execute query and return all rows.

def fetchone(self, sql) – execute query and return a single row.

def execute(self, sql) – perform INSERT/UPDATE/DELETE with commit/rollback.

def close(self) – close cursor and connection.

(4) GUI Development Use Tkinter for a desktop interface. Install with pip install tkinter (usually bundled). Import modules:

<code><span>from tkinter import *</span>
<span>from tkinter import ttk</span>
<span>import tkinter.font as tkFont</span>
<span>import tkinter.messagebox as messagebox</span></code>

Design the following windows:

StartMenu – main menu with buttons for teacher registration, login, and exit.

TeacherRegister – registration form with ID, password, and confirmation fields.

TeacherLogin – login form with ID and password.

TeacherMenu – management interface containing a ttk.Treeview table, entry fields, and buttons for add, modify, query, delete, clear, and export.

3. CRUD Operations

Insert – check for duplicate student ID, insert into database, update in‑memory list and UI table.

Update – verify existence, update database, modify in‑memory list and UI.

Select – retrieve a record by ID and populate the entry fields.

Delete – remove a record from database, list, and UI.

Clear – reset all entry widgets using StringVar.set('') .

4. Excel Export Install xlwt ( pip install xlwt ) and import via import xlwt . Create a new workbook, add a sheet, write database rows into the sheet, and save the file.

5. Summary & Experience The project demonstrates integrating Python’s database, Excel, and GUI libraries to build a functional student grade management application, emphasizing modular design, error handling, and user-friendly interaction.

6. Execution Results Screenshots show the start menu, teacher registration/login screens, the main management window, and examples of adding, modifying, querying, deleting, sorting, and exporting student records.

Original source: CSDN article