EduTrack - Project Documentation

EduTrack - Project Documentation (Professional Design)

Project Documentation: EduTrack - Integrated Educational Organization Management System

This document provides a comprehensive, feature-by-feature description of the EduTrack system, cross-referenced with visual examples from the application interface.

<---- Back to Portfolio Projects

1. Introduction and System Access

1.1. Login Screen (Access Control)

Purpose: To enforce secure access and authentication for all users (Admin, Staff, etc.).

Features:

**User/Admin Field**: Text input designated for the username or designated access level (e.g., Admin).
**Password Field**: Masked text input for secure password entry.
**Visual Identity**: The organization's emblem and "EduTrack" branding confirm the application identity.
**LOGIN Button**: Initiates the authentication process, granting access to the main Launchpad upon successful credentials verification.

2. The Central Launchpad and Core Modules

The **Launchpad** serves as the primary navigation map, grouping all functions into six major administrative domains, providing granular access to sub-features.

2.1. Core Module Structure and Functionality

Module	Sub-Features & Functionality
Student Records	New Enroll Admission: Form-based module for capturing new student data. Add Fee's Pay: Direct link to the financial transaction module. Female/Male Student: Dedicated sub-modules for managing gender-specific student records. Run Smoothly Transport: Accesses the transportation management dashboard. TimeTable: Schedules and manages class and examination timetables.
Employee Record	Male/Female Employee: Separate database and form access for managing gender-specific staff profiles. Staff Payroll: Module for salary processing and payment records. Agreement: Repository for staff contracts and formal employment agreements. Security Guard's / ID Cards: Accesses specialized modules for security staff management and ID generation. Daily Att: Direct link to the Employee Attendance module.
Legal Documents	Legal Document's: Repository for general contracts and legal papers. UN CRC Article: Specific documentation section related to the United Nations Convention on the Rights of the Child (for compliance). Child Protection Act: Dedicated module for storing and referencing institutional child protection policies and records. SOPs & Instructions: Links to the SOP Dashboard for operational and procedural documentation.
Financial Record	Financial Record: General ledger and financial reporting module. Doner Record: Dedicated module for managing philanthropic contributions. Inventory: Asset and stock management system.
General Record	Visitor's Record: Log for non-staff entry and exit. Student Diary/Class Activity/Staff Activity Log: Tracking daily student, class, and staff notes/events. Daily Expense & Income: Entry for daily miscellaneous financial transactions. General Notes: Organizational memo and communication repository.
Lab Records	Library Management: Module for tracking books, circulation, and library inventory.

EduTrack - Project Video

A complete walkthrough of the **EduTrack Management System**.

Watch how this integrated solution manages student records, employee payroll, financial reporting, and compliance documentation. It’s designed to streamline complex organizational workflows efficiently.

3. Specialized Academic and Welfare Management

3.1. Student Dashboard (Academic & Welfare Hub)

Purpose: Provide an overview of the student body, academic status, and quick links to welfare services.

Key Performance Indicators (KPIs):

**Total Student (1115)**: Total current enrollment.
**Orphan (950) / Non-Orphan (165)**: Segmentation of the student population by guardianship status.
**Age Wise Segmentation**: Breakdown counters for demographic analysis: Age 5+ (405), Age 10+ (445), Age 20+ (265).

Student Records Panel:

**New Admission**: Initiation of enrollment process.
**Exam Record**: Access to student grading and performance data.
**Student ID Card**: Automatically generated ID Card For Each Student
**Student Form**: Automatically generated details Admission form For Each Student

Graphical Display Student Data:

**Orphan Status Pie Chart**: Visual representation of the Orphan/Non-Orphan distribution.
**Age Wise Bar Chart**: Displays the frequency distribution of students across defined age ranges.

3.2. Student Transport Dashboard

Purpose: Dedicated logistical system for managing student vehicle travel, entry, and exit.

Features (Urdu/Local Language Focused):

**طالبہ آمد انٹری فارم** (Student Arrival Entry Form): Used to log the entry of students into the premises.
**طالبہ روانگی انٹری فارم** (Student Departure Entry Form): Used to log the exit of students from the premises.
**طالب علم آمد ریکارڈز** (Student Arrival Records): Historical logs of student arrivals.
**طالب علم روادگی ریکارڈز** (Student Departure Records): Historical logs of student departures.
**Student Search Field**: Allows searching records by unique ID, Name, or Father's Name (والد کا نام).

4. Financial and Resource Management

4.1. Dashboard Fee's Record (Financials)

Purpose: Track fee collection, manage dues, and monitor monthly financial health.

Total Collected Fees (KPIs):

**Today Received PKR**: Daily fee collection total.
**This Year Recieved PKR**: Annual cumulative fee collection.
**Paid/Unpaid Students**: Counts of students settled and outstanding for a selected month (e.g., Unpaid Students: 331).
**Total Outstanding / Due Fees**: Tracks the cumulative amount of uncollected fees.
**Fees Collection Monthly Wise**: Detailed table showing collection totals for all 12 months.

4.2. Donor Dashboard (Fundraising & Expense Tracking)

Purpose: Manage all philanthropic contributions, track expenditure, and provide an overview of donor relations.

Key Financial KPIs:

**Total Donation in PKR (12.3408 M)**: Grand total of all received funds.
**Total Donor (19)**: Count of unique contributing entities.
**Total Expense in PKR (4.8861 M)**: Cumulative expenditure from the donor fund.
**Leftover Money in PKR (6.5827 M)**: Current available fund balance.

Visualizations & Record:

**Top Donors Visualizations**: Bar and graph charts visually rank top contributors.
**Top Donor List**: Detailed, searchable table including Donor ID, Name, Contact, Donate Date, and Amount.

4.3. Dashboard Inventory Menu (Asset Management)

Purpose: Comprehensive management of organizational assets, materials, and supplies.

Modules and Functionality:

**Total Record**: Master record of all inventory, tracking items from acquisition to disposal.
**New Entry Record**: Used for registering newly purchased or acquired stock/assets.
**Issue Record**: Manages the assignment of materials to staff/departments for accountability.
**Keep Maintance**: Logs scheduled and performed repair/maintenance history.
**Low Stock**: An alert system to identify and flag items below a minimum re-order quantity.
**Audti Report**: Provides access to detailed reports for financial and physical inventory audits.

5. Human Resources and Security

5.1. Employee Record Form

Purpose: Detailed data entry and view for individual staff members.

Search and Access:

**Search Employee By ID** for immediate record retrieval.
**ALL TIME EMPLOYEE RECORD** button provides access to the full staff roster.

Information Sections:

**Personal Information**: Name, Date of Birth, Gender, Nationality, Contact details.
**Job Information**: Department, Designation, Employment Type, Date of Joining, Salary, Performance Rate.
**Emergency Contact Information**: Dedicated section for critical contact details.
**ID Attachment**: Upload image copies of the National Identity Card (Front and Back).

5.2. Employee ID Cards

Purpose: Dedicated module for generating professional, scannable employee identification cards.

Generated Fields:

Includes **Photo Placeholder, Holder's Signature, Employee Name, Father Name, Date of Join, Work Place, Designation**.
**Date of Issue/Expire**, and a **QR Code** for quick digital verification.
**Search**: Includes a Find Record feature to pull data for ID generation by Employee ID (e.g., Emp-003).

5.3. Employee Attendance Sheet

Purpose: Monthly tracking and calculation of employee presence, absence, and leave.

Features:

**Navigation**: Links to switch between monthly attendance sheets (e.g., "Open January sheet").
**Data Grid**: A matrix showing Employee ID and Name against 31 daily columns.
**Visual Coding**: Red-highlighted columns indicate non-working days (weekends/holidays).

Summary Metrics (Automated calculations for):

**Total Present (P)**: Count of present days.
**Total Absent (A)**: Count of absent days.
**Leave (L)**: Count of days taken as leave.

5.4. Dashboard Security Guard

Purpose: Specialized HR and deployment module for security personnel.

Gender-Segregated Features:

**Male/Female DB**: Access to the database of male and female security staff.
**Male/Female Form**: Data entry forms for personal and job details.
**Male/Female ID Card**: Generation of ID cards specific to security roles.
**Male/Female Shifting**: Management of staff patrol schedules and duty rotations.
**Male/Female Attandance**: Daily attendance logging for security staff.

5.5. Visitor's Record System

Purpose: Log and monitor all non-staff personnel entering the premises, crucial for site security.

Data Entry Fields:

**Visitor ID** / **Time In/Time Out**: Critical security data points for duration tracking.
**Full Name** / **Host Name**: Who visited and who they were meeting.
**Purpose of Visit**: Detailed description of the visit.
**ID Type / ID Number**: Collection of official identification details for security auditing.

Search & Metrics:

**Search By Date**: Filter and retrieve logs for a specific day.
**Sidebar Metrics**: Real-time summary of visitor traffic (Total Visitor's, Private Visitor's, Goverment Visitor's).

6. Compliance, Daily Operations, and Documentation

6.1. Dashboard SOPs (Standard Operating Procedures)

Purpose: Central repository for all institutional policies, ensuring organizational consistency and legal compliance.

Policy Categories:

**SOPs For All Faculty**: General professional code of conduct.
**SOPs Complient**: Compliance documentation and audit trails.
**No Hitting, Only Caring**: High-priority policy on student welfare and non-violence.
**SOPs Male/Female Staff**: Gender-specific duty and conduct guidelines.
**SOPs For Hostel Warden / Record Keeper**: Role-specific procedures.

Disciplinary / Certification Modules:

**Disciplinary Record** (logging actions) and **Compliant Application For Students** (grievance process).

6.2. Certificate Dashboard (Official Documentation)

Purpose: Streamlined generation of official certificates and formal letters.

Document Types:

**Student Clearance Certificate**: Confirms a student has no outstanding obligations.
**Madrasa Leaving / School Leaving**: Formal certificate of completion of studies.
**Attandance**: Official document verifying attendance record for a specific period.
**Teacher Experience**: Formal letter validating employment tenure and experience.

6.3. Dashboard YKD Dairy (Daily Operations Log)

Purpose: Centralized recording of daily non-core activities and minor operational data.

Modules:

**Staff Activity Log**: Tracking daily tasks and staff actions.
**Student Dairy / Class Activity**: Log for student notes, homework, and classroom events.
**Visitor & Meeting Log**: Integrated with the Visitor's Record system, focuses on internal meeting schedules.
**Daily Task**: General task management and scheduling.
**Event & Activity**: Logging and planning of organizational events and functions.
**Daily Expense & Income**: Entry and tracking of daily miscellaneous financial transactions.

7. Project Construction & Technology Stack

7.1. Technology Stack and Development Method

Purpose: To clearly define the core technologies used in the project's construction, highlighting the advanced use of familiar enterprise tools.

This project was developed as a robust, enterprise-grade solution, utilizing the powerful combination of **Advanced Microsoft Excel** and **Visual Basic for Applications (VBA)**. This choice emphasizes a highly functional, low-cost deployment model accessible to organizations already relying on the Microsoft Office Suite.

Key Development Components:

System Core & Back-End

**Back-End Logic & Automation (VBA)**: Custom-engineered for dynamic dashboard updates, automated report generation, and ID card printing.
**Data Management (Advanced Excel)**: Leveraged for robust record storage, complex calculation matrices, and maintaining data integrity through validation rules.

Interface & Professional Design

**Graphical Interface Design (Adobe Photoshop)**: Meticulously used to finalize all GUIs, custom forms, and dynamic visual displays (Dashboards, Launchpad).
**Outcome**: Ensuring a professional, user-friendly, and visually cohesive user experience across all modules.

This methodology demonstrates the capacity to build complex, integrated management systems using powerful, readily available tools.