TVNHS Logo TVNHS
Complete TVNHS Digital Ecosystem

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.

Central Control Center

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.

School-to-Home Communication

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.

Human Resource & Faculty Services

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.

Health, Nutrition & Learner Wellness

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.

Specialized School Subsystems

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.

Campus Access & Gate Security

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.

Learner & Family Portals

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.

AI Chatbot, Messaging Engine & Security

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.

Real-Time Dispatch Matrix

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 — — — —