Problem
The University Extension Office needed to centralize the management of extension courses, enrollments, students, and certificates, reducing manual work and making information easier to access for administrators and students.
Back to projects01 02 03
Academic and certification system
I co-led, as part of a four-person team, the development of a web system for the University Extension Office at UTN Facultad Regional Haedo. It was designed to digitize course management, student enrollment, and the issuance and validation of academic certificates.
Public validity lookup using a code.
Image 1 of 7My contribution
I contributed throughout the system analysis, design, and development, making technical and functional decisions with the rest of the team and helping organize and assign tasks. I was fully responsible for the digital certificate workflow, including data validation, PDF generation, QR code creation, and the student's subsequent download.
Solution
A web application was developed with administrator and student profiles, academic management tools, manual and bulk data loading, dynamic PDF certificate generation, and public validation through a code and QR.
Outcome
A complete workflow was delivered, connecting course and enrollment management with the generation, download, and public validation of digital certificates. The system was designed for implementation by the University Extension Office; its current operational status is unconfirmed.
Features
Features
Academic management
- Course, category, and enrollment CRUD operations.
- Dynamic search and filtering.
- Administrator, role, and restricted-access management.
- Manual and bulk student importing through CSV files.
- Data validation and automatic duplicate detection.
Digital certification
- Selection of students eligible for certification.
- Dynamic digital certificate generation in PDF format.
- Institutional signatures and resource management.
- QR code generation and public certificate validation.
- Individual and bulk certificate downloads.
Student experience
- Student dashboard with profile, enrollments, and certificates.
- Satisfaction survey before selected downloads.
- Institutional contact form.
Technical details
Architecture
- Client-server web application organized into three layers.
Frontend
- HTML5, CSS3, and JavaScript.
- Responsive design.
- Asynchronous interactions using AJAX and fetch().
Backend
- PHP.
- Session, profile, role, and business rule management.
Database
- MySQL.
- Normalized relational model.
- Referential integrity.
- Prepared queries using PDO.
Documents and files
- mPDF for certificate generation.
- php-qrcode for QR codes.
- ZipArchive for compressed files.
- Dropzone for drag-and-drop uploads.
Collaborative work
- Version control with Git.
- Shared task organization.
- Technical and functional decisions made as a team.