Active

Co-Curricular Transcript — Digital Student Achievement and Activity Platform

A live student development platform that transforms extracurricular, social, cultural and volunteering activities into adviser-approved, QR-verifiable digital transcript records.

Start: 2025-06-16

My role

Software Architect & Senior Software Engineer

Key technologies

C#ASP.NET Core MVCRazor PagesEntity Framework CoreMicrosoft SQL ServerRedisInstitutional Identity IntegrationREST API IntegrationServer-Side PDF GenerationQR and GUID-Based VerificationreCAPTCHARole-Based Access ControlEmail Notification Services

Overview

Sosyal Transkript is a live digital student development platform designed to make university students’ extracurricular achievements visible, structured and independently verifiable. The platform enables students to record the social, cultural, volunteering, sports, club, community and personal-development activities they participate in throughout their university education. Submitted activities are reviewed through a structured adviser approval workflow before being added to the student’s official Social Transcript. Rather than representing student development solely through academic grades, the system provides a broader and more comprehensive record of participation, responsibility, social contribution and personal development. Students can submit new activity records, provide supporting information and monitor the current status of their applications. Academic advisers can review each submission, evaluate the supporting records and approve, reject or return applications when corrections are required. Administrative users can manage activity categories, institutional rules, reporting processes and system-wide records. Approved activities are automatically included in a professionally generated Social Transcript document. The document is produced in PDF format and contains structured activity information together with a unique QR code and verification identifier. Each transcript can be independently verified through a public verification page. When the QR code is scanned, the verification service confirms that the document was generated by the institutional platform and displays the corresponding validated record. This provides a reliable mechanism for employers, graduate programmes and other external stakeholders to confirm the authenticity of the document. The system includes role-based access control, institutional identity integration, automated email notifications, secure public verification, CAPTCHA protection, reporting capabilities and server-side PDF generation. I worked on the analysis, software architecture and development of the platform, including the student application workflow, adviser approval processes, administrative interfaces, database design, institutional integrations, PDF transcript generation, QR verification infrastructure, security controls and production deployment. Sosyal Transkript creates a trusted digital record of the experiences and contributions that are often not visible in a traditional academic transcript. It allows students to present their broader university journey through an official, accessible and verifiable document.

Method

The project began by analysing the types of extracurricular activities that contribute to student development, the institutional approval responsibilities and the information required for a verifiable transcript record. A role-based workflow was designed for students, academic advisers and administrative users. Students submit activity records through structured forms, while advisers evaluate each application and determine whether it should be approved, rejected or returned for correction. Only activities that complete the required approval process are included in the Social Transcript. This prevents unverified submissions from appearing in the official document and ensures that every transcript record has passed an institutional review stage. The platform was developed using ASP.NET Core MVC, Entity Framework Core and Microsoft SQL Server. Institutional identity and user data services were integrated into the application, while Redis caching was used to improve the efficiency of selected system operations. The PDF generation component creates a structured A4 transcript containing student information, approved activity records, institutional elements, document identifiers and a QR code. The transcript layout is generated dynamically on the server according to the student’s current approved records. Each document is associated with a unique verification identifier. The QR code directs external users to a public verification page where the authenticity and validity of the transcript can be confirmed. CAPTCHA protection and controlled data presentation are used to reduce automated misuse and prevent unnecessary exposure of personal information. Automated email notifications inform users about important application and approval events. Administrative reporting interfaces provide visibility into activity submissions, approval statuses and system usage. The platform was deployed to the institutional production environment and is continuously monitored at the application, server and database levels.

My role

Key technologies

Overview

Research problem

Method