A production-ready Excel VBA application designed to manage student grades, automate calculations, and streamline academic record tracking with a clean and interactive UI.
⚡ Built with Excel VBA, this project demonstrates real-world concepts such as data validation, dynamic UI, modular architecture, and persistent storage.
This system enables users to:
- Select courses dynamically
- Input exam grades (midterm & final)
- Automatically calculate weighted averages
- Store data in structured worksheets
- Export records to external
.txtfiles
The project follows a modular and scalable VBA architecture, simulating a lightweight desktop application inside Excel.
- 🎯 Dynamic course selection via ComboBox
- 🧮 Automated grade calculation (40% midterm / 60% final)
- ✅ Strong input validation (numeric & range checks)
- 💾 Persistent data storage in Excel sheets
- 📤 Export to external text file
- 🔍 Course search functionality
- 🧹 Safe data reset with confirmation
- 🎛️ Interactive UI with UserForms
UserForm (UI Layer)
↓
Validation & Logic Layer (Procedures)
↓
Data Layer (Excel Worksheets)
↓
External Output (Text File Export)
- Loose coupling between UI and logic
- Reusable procedures (e.g., ExceleKaydet, OrtalamaHesapla)
- Event-driven programming model
- Data integrity ensured via validation layer
- Microsoft Excel
- VBA (Visual Basic for Applications)
- UserForms (UI Layer)
- Worksheet-based Data Storage
- File I/O (Text Export)
- Clone the repository:
git clone https://github.com/your-username/gradeflow-student-management-system.git-
Open the
.xlsmfile in Microsoft Excel -
Enable macros:
- Go to File → Options → Trust Center
- Enable Macro Execution
- Run the application from the Main Dashboard
This project uses Excel worksheets as a database layer:
- Dersler (Courses)
- Stores course codes & names
- Notlar (Grades)
- Stores student grade records
Courses Sheet → UserForm → Validation → Grades Sheet → Text Export
-
✔️ Input validation (empty / numeric / range checks)
-
✔️ Controlled data entry via UserForm
-
✔️ Confirmation prompts for destructive actions
-
✔️ Prevents invalid or inconsistent data writes
Average = (Midterm \* 0.4) + (Final \* 0.6)
- Automatically finds next available row
- Ensures relational consistency (Course ↔ Code)
- Generates notlar.txt
- Structured and readable output format
- Case-insensitive search
- Highlights matched results in sheet
- 🔐 User authentication system
- 🌐 Migration to web-based backend (ASP.NET / API)
- 📊 Advanced reporting (charts & analytics)
- 🧩 Multi-user support
- 🗃️ Database integration (SQL Server)
This project is licensed under the MIT License.
This project demonstrates how Excel can evolve into a full application layer, combining:
- UI (UserForms)
- Business Logic (VBA)
- Data Persistence (Worksheets)
A strong showcase of problem-solving, architecture design, and automation skills for backend-focused developers.