EduTrack: Comprehensive Student Management System

EduTrack: Comprehensive Student Management System

Project Documentation: Complete Feature Overview

EduTrack is a fully integrated, modular Student Management System designed to be the single, definitive platform for institutional administration. It provides seamless management across academics, health, logistics, and finance, ensuring data integrity and enabling data-driven oversight.

<---- Back to Portfolio Projects

I. System Access and Central Management

User Authentication

Ref: Login Screen

The critical security gateway. Ensures only authorized personnel access sensitive student data, protecting privacy and system integrity.

Executive KPIs

Ref: Student Main Dashboard

Provides immediate, high-level statistics for Total Students, Orphan Status, and Age Distribution—crucial for reporting and resource allocation.

Graphical Data Display

Ref: Student Main Dashboard

Visualizes demographics (e.g., Class Size, Orphan Status) to allow school leadership to quickly interpret trends and allocate resources strategically.

Core Navigation Links

Ref: Student Main Dashboard

Central hub providing one-click access to ID Cards, Health, Expense, Former Student, and Sponsor's Student modules. Export to Sheets

---

II. Academic & Progress Reporting Modules

This suite manages the student lifecycle from enrollment through performance assessment and record-keeping.

Detailed Enrollment Form

Ref: Admission Form

A comprehensive, bilingual form (Urdu/English) ensuring standardized data collection on Personal, Parental, and Academic History.

Student Allocation Links

Ref: Class & Section Dashboard

Direct links to the roster tables, enabling staff to quickly enter or view students assigned to a specific Class and Section (e.g., Class6th_A).

Class Teacher Assignment

Ref: Class & Section Dashboard

A dedicated function to formally link teachers to specific classes/sections, defining clear accountability for academic and pastoral duties.

Open Monthly Attendance Sheet

Ref: Student Attandance Record

Provides a detailed daily log for tracking Present, Absent, and Leave statuses, automatically calculating the monthly totals for intervention and reporting.

Student Report Card/DMC Generation

Ref: Student Progress Report

Triggers the batch generation of official Detailed Marks Certificates for all students, ensuring error-free academic documentation.

Open Class Exam Sheet

Ref: Student Progress Report

Direct link for authorized staff to access and input the raw scores from an examination into the system's grade book (e.g., Mid10th Sheet).

List of Best Students

Ref: Student Progress Report

Automatically runs the **Ranking Algorithm** to identify and list top performers based on exam records, supporting recognition programs.

Notice Board Management

Ref: Student Progress Report

Functionality to manage and publish announcements or academic results, centralizing school-wide communication.

Marks & Position Calculation

Ref: Student Report Card/DMC

Backend logic that automatically calculates Grade, Percentage, Total Marks, and Position in Class based on raw scores. Export to Sheets

---

III. Welfare, Health & Logistical Management

These modules cover student well-being, residential logistics, and dietary needs.

Chronic Conditions Aggregation

Ref: Student Health Dashboard

Provides an aggregated count of students with long-term medical issues, enabling proactive health management and specialized care.

Pending Vaccine Tracker

Ref: Student Health Dashboard

Tracks and flags students who are overdue or missing required vaccinations, supporting compliance and public health standards.

Health History / Log

Ref: Student Health Dashboard

Detailed transactional ledgers for recording past illnesses, injuries, treatments, and daily medical incidents.

Emergency Contact Access

Ref: Student Health Dashboard

Immediate access to essential Emergency Contact information and medical protocols for rapid response.

Hostel Room Allotment

Ref: Hostel Record System

Manages room capacity, student assignment, and ensures conflict-free (e.g., gender) distribution of residential space.

Hostel Mess Record

Ref: Hostel Record System

Tracks meal consumption, dietary restrictions, and provides data for catering planning and waste reduction. Export to Sheets

Hostel Disciplinary Log

Ref: Hostel Record System

A secure system for recording behavioral incidents, disciplinary actions taken, and follow-up status.

Hostel Visitor's Record

Ref: Hostel Record System

Critical security function that logs all non-staff campus visitors (Name, Entry/Exit Time, Host Student).

Food Inventory Cost Tracking

Ref: Food & Nutritions Record

Tracks the cost and usage of food supplies, providing financial control over the catering budget.

Nutrition Standards & Reports

Ref: Food & Nutritions Record

Allows staff to define and monitor dietary guidelines and generates automatic Weekly/Monthly Reports on compliance. Export to Sheets

---

IV. Financial & Archival Systems

These modules ensure financial accountability and permanent data retention.

Total Expense By All Categories

Ref: Expense Dashboard

Aggregates all expenditures into a single figure (PKR Total), serving as the primary financial KPI for the institution.

Student Expense By Category

Ref: Expense Dashboard

Tracks itemized costs (Uniform, Transport, Books) allocated to a specific Student ID, crucial for personalized billing and sponsorship reporting.

Total Expense By Category Filter

Ref: Expense Dashboard

Allows financial managers to filter and see the total institutional spend on a single item (e.g., Uniforms), guiding bulk purchasing decisions.

Yearly Archival Search

Ref: Former Student’s Record

Allows staff to easily search and retrieve historical records (DMC, transcripts) categorized by Passing/Leaving Year, providing permanent data integrity.

Sponsor Information Tracking

Ref: Sponsor Student Record

Dedicated module linking student performance and details with the Sponsor’s Contact Information, ensuring transparency and fulfilling donor reporting requirements.