EduTrack System Features
Explore the complete school automation ecosystem built for Tropical Village National High School (DepEd ID: 301223)—uniting Smart QR Gate Attendance, DepEd SF2 & Form 48 DTR Automation, Live Parent-Teacher Messenger Desk, Digital Excuse Letters, School Clinic & Guidance Portals, Operations Trackers, SDO Governance, and a 24/7 Gemini AI Assistant.
Administrator, Principal & Registrar Module
Live Auto-Sync Dashboard & Drilldowns
Real-time 15-second background sync displaying Students, Staff, and Visitors currently inside the campus, historical Date Switcher, and interactive drilldown modals with Section/Role filters, CSV Export, and Bulk Time-Out.
Smart Class Suspension & Holiday Engine
Declare single or multi-day class suspensions with weekend skipping, granular targeting (All, Students Only, Staff Only, AM/PM Shift, or specific Grade Levels), preservation of real gate scans, early dismissal auto-time-out, and 1-click Cancel/Lift Advisory.
Automated DepEd SF2 Excel Generator
One-click export of official DepEd School Form 2 (Automated SF2 .xlsx) pre-filled with Male/Female learner attendance grids, daily presence/tardiness markers, and monthly summary computations.
Batch Import & Smart Enrollment
Enroll thousands of learners or faculty members from DepEd Masterlist CSV/XLSX spreadsheets (batch_enroll.php) with automatic name parsing, LRN validation, and section assignment.
Visual Class & Shift Scheduler
Configure section shifts (AM, PM, Whole Day), subject periods, class advisers, and teacher loads (visual_scheduler.php) driving automated gate late-cutoff detection.
Student Directory & QR ID Generator
Centralized student directory (student_directory.php) with guardian contacts, section transfers, individual attendance reports, and bulk printable QR ID card generation (qr_generator.php).
Early Warning System (EWS) Alerts
Automatically detects learners with 3+ consecutive unexcused absences or frequent tardiness (action_alerts.php), enabling advisers and registrars to dispatch immediate parent notices.
Weekend & Special Events Monitor
Dedicated Saturday & Sunday attendance tracker (weekend_events.php) for teachers on weekend duty, student practices/trainings, and weekend visitors—strictly separated from Mon–Fri SF2 records.
SDO Compliance & Directives Hub
Division oversight portal (sdo_compliance.php) enabling school leadership to submit SDO deliverables (SMEA, AIP, WinS, SF8, DTR endorsements) and acknowledge Division Memorandums.
Live Parent-Teacher Desk, Excuse Letters & Appointments
Live Messenger-to-Portal Handover
Parents chatting on the school Facebook Page can request to talk to their child's Class Adviser. Messages route directly to parent_inquiries.php without requiring teachers to hold Facebook Page admin access.
Real-Time Chat Polling & Audio Chime
3.5-second live AJAX polling pops new parent messages into the conversation thread with a Web Audio notification chime and live unread badges (#sidebarParentInqBadge) across all portal pages.
Adviser Privacy & Section Isolation
4-tier hierarchical adviser resolution routes inquiries strictly to the student's assigned Class Adviser, while Principals and Registrars retain global oversight across all sections.
Digital Student Excuse Letters
Students (student_excuse_letters.php) and parents can submit excuse letters with medical certificates or supporting photos for adviser review (excuse_letters.php).
Automatic Excused Attendance Sync
Once an excuse letter is approved by the Class Adviser or Registrar, the student is automatically reflected as Excused on the Live Dashboard and attendance sheets instead of Absent.
Principal Appointment Calendar
Interactive appointment booking system (appointments.php) where faculty and stakeholders can book available consultation slots with the Principal's Office.
Personnel DTR (Form 48), Leaves (Form 6), OB & MOV Portfolio
Personnel DTR & Civil Service Form 48
Tracks faculty and non-teaching gate time-in/out (staff_attendance.php & teacher_my_attendance.php) with configurable shift hours, tardy/undertime calculation, and printable CS Form 48 DTRs.
Faculty Leaves (DepEd / CS Form 6)
Online Civil Service Form 6 leave application (faculty_leaves.php) featuring Department Head endorsement, Principal approval, class reliever assignment (schedule_relievers), and Form 6 Excel export.
Official Business (OB) Pass Workflow
Digital filing and two-tier approval for off-campus seminars, division activities, and official travel (official_business.php), automatically crediting approved teachers as Present (OB) on the dashboard.
Department Head Attendance Monitor
Dedicated supervisory dashboard (department_attendance.php & departments_management.php) allowing Department Heads to monitor daily attendance and tardiness of teachers in their department.
DepEd MOV E-Portfolio & Review
Digital Means of Verification (MOV) repository (teacher_mov.php) where faculty upload quarterly RPMS/PPST artifacts for Department Head and Principal verification, complete with a 30-day recovery trash bin.
Teacher Evaluation (E-SAT & PPST)
Comprehensive faculty appraisal portal (TeachersEvaluation/index.php) aligned with the Philippine Professional Standards for Teachers (PPST), supporting both student feedback windows and supervisory observations.
School Clinic, DepEd SF8, Deworming & Guidance Office
School Clinic & Teacher Referrals
Digital clinic consultation log (clinic.php & clinic_pass_slip.php) with teacher-to-clinic referrals, urgency tagging, vital signs, treatment records, printable pass slips, and Send-Home admin approvals.
DepEd SF8 Health & BMI Analyzer
Compliant with DepEd Order No. 33, s. 2013 (clinic_sf8.php)—automatically computes BMI-for-Age and Height-for-Age (HFA), flags SBFP feeding program beneficiaries, and exports official DepEd SF8 Excel reports.
National Mass Deworming Tracker
Round 1 & Round 2 deworming management (clinic_deworming.php) enforcing strict parental consent guardrails, individual/class consent slip uploads, AEFD monitoring, and DepEd Accomplishment Report printing.
Medicine & Supplies Inventory
Tracks clinic medicine stocks (clinic_inventory.php), minimum threshold alerts, expiration dates, stock replenishments, and automatic dispensing deductions.
Guidance Case Management
Confidential counseling and behavioral intervention ledger (guidance_office.php) with privacy-preserving Case Codes, Student Aliases, parent background records, and follow-up tracking.
Mood Tracker & HEEADSSS Screener
Student emotional check-ins (mood_tracker/index.php) and standardized DOH/DepEd Rapid HEEADSSS Adolescent Psychosocial Screening (heeadsss.php) with automatic high-risk guidance alerts.
Campus Offices & Operations Tracking Hub
DocuTrack System
End-to-end Document Tracking System (DocTracker/) for routing incoming/outgoing memorandums, endorsements, and official school records.
LR Tracker & Library
DepEd Learning Resource module/textbook distribution (LrTracker/) plus Library book cataloging, LRN borrowing, and overdue fine tracking (library.php).
Property & Supply Tracker
Supplies and Equipment Inventory (EduTracker/) monitoring asset custodianship, quantities, and condition status (Serviceable, For Repair, Unserviceable).
ICT Equipment Tracker
Hardware and laboratory asset registry (ict_inventory.php & ICTTracking/) with built-in HTML5 QR/Barcode camera scanning and borrowing logs.
QATAME M&E Portal
Quality Assurance, Technical Assistance, Monitoring and Evaluation (QATAME/) for school seminars, INSET trainings, and targeted teacher evaluation broadcasts.
WinS 3-Star Monitoring
DepEd WASH in Schools (WINS/) national Three-Star hygiene, sanitation, water, and deworming compliance indicator tracking system.
Canteen Financial Hub
School Canteen Management (CanteenTracker/) tracking daily sales, cash remittances, stock inventory, and DepEd Order No. 8, s. 2007 fund allocations.
School Offices RBAC
Role-Based Access Control (school_offices.php) assigning Office Heads and coordinators so teachers only see the specialized office portals assigned to them.
Security Personnel, Gate Scanner & Smart Visitor Pass
Ultra-Fast QR Scanner & Webcam Audit
High-speed contactless check-in/out (guard_scanner.php) via 2D hardware barcode scanners or webcam, capturing a real-time photo snapshot on every scan to prevent proxy scanning.
Voice Greeting & Anti-Passback Cooldown
Web Speech API voice synthesis greets learners by name while enforcing configurable anti-passback cooldown timers so ID cards cannot be passed back to friends.
Offline Scan Caching & Auto-Sync
Continues scanning uninterrupted during sudden internet drops by caching attendance logs in local browser storage and syncing automatically once back online.
Manual LRN Lookup & Guard Accountability
Allows duty guards to search learners by LRN or Name if a physical ID card is forgotten, stamping every attendance and visitor log with the active duty guard's name.
Smart Visitor Pass & Printable QR Slip
Digital guest registration (visitor_slip.php) capturing visitor name, destination office, purpose, and webcam photo, printing a QR Visitor Badge for instant exit checkout.
Centralized Visitor History & Admin Time-Out
Real-time visitor monitoring (visitor_logs.php) tracking guests currently inside the campus with 1-click individual or bulk Time-Out directly from the Admin Dashboard.
TVNHS Student Web Portal & Parent Android Mobile App
Student Attendance & Timetable Portal
Learners log into dashboard.php and student_schedule.php to inspect their daily time-in/out logs, monthly attendance rates, assigned class adviser, and shift/subject timetable.
Student Excuse, Wellness & Evaluation Access
From their sidebar, students can submit digital Excuse Letters (student_excuse_letters.php), log daily Mood Check-ins, complete the HEEADSSS Screener, and evaluate teachers when open.
Native Android Parent APK (edutrack.apk)
Downloadable Android mobile application powered by parent_api.php giving parents and guardians real-time smartphone access to their child's attendance and school updates.
Live Gate Snapshot Verification
Parents can view the actual gate camera photo snapshot captured the exact moment their child scanned in or out at the TVNHS main gate.
Multi-Child Sibling Switcher
Parents with multiple children enrolled at TVNHS can link and switch between all their children's profiles from a single mobile app account.
Instant Push Advisories & News Feed
Displays official TVNHS announcements, class suspension advisories, and emergency alerts directly on the Student Portal and Parent Mobile App home feed.
24/7 Gemini AI Messenger Assistant, Gammu SMS & Security
24/7 Google Gemini AI Chatbot (webhook.php)
Integrated with TVNHS's official Facebook Page—understands Tagalog and English inquiries, answers school FAQs, checks live student gate attendance ("Pumasok na ba ang anak ko?"), and drafts AI Excuse Letters.
Dual-Mode Meta Graph API Delivery
Delivers instant Messenger scan cards and suspension broadcasts using parallel curl_multi dispatch with automatic 24-hour RESPONSE and CONFIRMED_EVENT_UPDATE tag fallback.
Asynchronous Queue & Gammu GSM Bridge
Non-blocking priority queues (notification_queue.php & process_queue.php) with live worker heartbeat monitor, SMTP Rotation Mailer Pool, and local USB GSM modem SMS dispatch (gammu_bridge.php).
Google OAuth 2.0 SSO & 2FA OTP
One-click Google Sign-In (google_auth.php), Two-Factor OTP verification (verify_otp.php), teacher registration approval workflow (approve_teachers.php), and CSRF token protection.
Automated Photo Retention & Storage Cleanup
Smart storage maintenance (cleanup_old_photos.php) that purges expired gate scan snapshots while strictly protecting student profile avatars, excuse attachments, and clinic documents.
RA 10173 Data Privacy Compliance
Built in compliance with the Philippine Data Privacy Act of 2012, featuring dedicated Privacy Policy (privacy.php), Terms of Service (terms.php), and User Data Deletion (data_deletion.php) portals.
Multi-Channel Notification Matrix
Automated alerts across SMS, Email, Facebook Messenger, and the Student/Parent Portals keep families, advisers, and school administrators connected in real time.
| System Event | Database Ledger | SMS Text Alert | Student / Parent App | Messenger AI | Email Notification |
|---|---|---|---|---|---|
| Student Time-In (QR Gate Scan / Manual In) | |||||
| Student Time-Out (Campus Exit / Bulk Dismissal) | |||||
| Tardy / Late Arrival (Shift Cutoff Exceeded) | |||||
| 3+ Consecutive Absences Early Warning Alert | |||||
| Class Suspension / Holiday Advisory Broadcast | |||||
| Parent Inquiry Reply & Excuse Letter Decision | — | — | |||
| Visitor Pass Entry & QR Checkout Log | — | — | — | — |