Superior Audit Pulse: Institutional Compliance Suite

Superior Audit Pulse is a high-performance, institutional-grade academic repository scanner and continuous validation engine. Architected precisely for verifying stringent NCEAC (National Computing Education Accreditation Council) standards, the software automates the traditionally manual process of ensuring academic folder integrity, naming schemas, and assignment authenticities deeply nested across Google Drive.

By shedding obsolete DOM-scraping mechanisms and harnessing Google Drive's API v3 schema directly, this automation suite boasts exponential performance scaling, real-time monitoring, and deep forensic reporting mechanisms directly baked into your University's established workflows.

⚡ Core Operational Capabilities

🏛️ NCEAC Compliance Validation Engine

• Anchored Hierarchy Parsing: Utilizes a sophisticated "Semester-Anchor" algorithm mapping deeply nested Drive nodes to a standardized Teacher/Session/Dept/Semester/Section/Course schema regardless of entry point.
• Institutional Context Awareness: Automatically distinguishes between Lab/Practical (Task-based) and Theory/Course (Assignment/Quiz-based) repositories, varying the validation ruleset accordingly.
• Mandatory Category Enforcement:
  • Result Folders: Verifies three-file integrity (Marksheet, Gradesheet, CLO-Attainment).
  • Term Papers: Enforces the "Paper-Quintet" rule (Question, Solution, Best, Average, Worst) with strict flags for isolated question uploads.
  • Continuous Assessment Containers: Deep-scans "Task", "Assignment", and "Quiz" counters to ensure proper subfolder density (e.g., 14-16 for Labs) and multi-file evidence within each node.
• Unified Teacher Reports: Compiles high-level compliance summaries into a dedicated multi-dimensional sheet with institutional AutoFilters and completion percentages.

🔬 Automated Diagnostic Forensics (Duplicate Detection)

• Byte-Level Match Identifiers: Unveils sophisticated file sharing pipelines among distinct student entities by pinpointing exact-file-size duplicates across independent repository branches.
• Smart Semantic Exclusions: Strategically bypasses harmless overlaps. Files internally categorized as "Question", "Solution", "Guidelines", "Syllabus", and "Attendance" are safely pruned from the duplicate flagging stack, ensuring zero false-positive white noise.
• Pair-Lock Database Synchronization: Changing the "Duplicate Status" of a specific flagged assignment natively reaches into the database and updates its duplicate counterpart simultaneously across the UI.
• Dual-Window Verification: Streamlines the manual forensic approval step—auditors can immediately verify code similarity via single-click side-by-side Chrome tab deployments.

🏢 Seamless Institutional Security & Administration

• Real-time Admin Automation Hub (WhatsApp Support): With complete integration across WAHA and Whapi Webhooks, administrators manage the platform through direct WhatsApp commands (e.g. CONFIRM <id> or REJECT <id>). Subscription requests synchronize via websocket and push directly for review.
• Google Sheets NoSQL Core: Effortless centralized data modeling mapped instantly to Google Sheets. Manage Payment validation metadata, live Subscription Rosters, and Auditing Profiles from an intuitive tabular state.
• Granular Access Control Constraints: Automated lockouts and tier logic dynamically enforce subscription borders. Daily, Weekly, Monthly, and Annual access variants systematically restrict application usage based on true expiration metrics.

📑 Comprehensive Excel Repositories (.xlsx)

• Append-Only Forensic Storage: Integrates diagnostic metrics directly inside pre-existing institutional formats. Your audit_report.xlsx transforms incrementally with append operations that avoid destructive overwriting of historical benchmarks.
• NCEAC Teacher Validation Matrix: A dedicated validation sheet enabling granular filtering by Teacher, Course, or Status.
• Executive Insights Dashboard: Summarized macro-level insights auto-generated for High-Level Stakeholders, complete with KPI charting mapped atop compliance rates.
• Deep-Dive Violation Journals: Line-item breakdowns pinpointing precise exceptions mapping directly back to original faculty upload URLs.

🧠 System Logic & Architecture

NCEAC Validation Engine (nceac_validator.py)

Path Parsing Strategy:

1. Semester Anchor: Searches for the "Semester" keyword in the path array.
2. Relative Mapping:
   • Teacher = Anchor - 3
   • Session = Anchor - 2
   • Dept = Anchor - 1
   • Section = Anchor + 1
   • Course = Anchor + 2
3. Faculty Fallback: If Teacher is missing from the path, the engine performs a consensus check on Google Drive "Owner" metadata to identify the most frequent contributor as the responsible faculty.

Validation Constraints:

• Single File Folders: (Attendance, Course Description, Log, Module, Outline) - Precisely 1 file with keyword-aligned naming.
• Task/Assignment/Quiz containers:
  • Subfolder naming: Prefix {number} (e.g., "Task 1") - Space required.
  • Count Check: Task (14-16), Assignment (1-4), Quiz (1-4).
  • Node Integrity: Every subfolder must contains 5 specific forensic files.

Folder Scanning Engine (checker_bot.py)

Configuration:

• Max depth: Configurable via CLI (default: 10)
• Worker threads: Configurable (default: 4)
• Supports 3 scanning modes: multiple, single, selector

Duplicate Detection Algorithm:

1. Keyword Filtering:
   • Negative keywords (excluded): guideline, question paper, question, solution, key, log, module, description, form, attendance, paper, course
   • Positive keywords (required for suspicious): Best, Average, Worst, Solution
2. Eligible Files: Must be Verified status + contain positive keywords + NOT contain negative keywords
3. Grouping Key: (Author, File Size, Extension) - only files with same author AND same size AND same extension are compared
4. Exclusions: Files authored by "Rasikh Ali" are never flagged

🛠️ Technology Ecosystem & Stack

• Application Gateway: Python 3.10+, FastAPI framework, Uvicorn ASGI Server.
• Concurrency Engine: Asynchronous threading pool enabling extreme processing (Up to 32 Simultaneous Drive API request handlers).
• Telemetry Protocols: Native WebSockets pushing real-time bidirectional status metrics safely to the client UI.
• External Connectors:
  • Google Drive API v3 (Scanning Matrix)
  • Google Sheets API (User Registry & Automation Queue)
• Frontend Representation: Modern HTML5 interfaces styled with sleek, responsive CSS, dynamic data-renders managed by Vanilla JS, interactive metrics backed securely by Chart.js, and aesthetics powered via Lucide Icons and glassmorphic filtering.

📊 Excel Report Structure

The generated Excel report (reports/{report_id}.xlsx) contains:

1. Dashboard Sheet (Report)

   • Title header with brand colors (#6C1C74)
   • KPI Cards: Total Nodes, Empty Gaps, Potential Dups, Compliance %, Active Depts, Authors Detected
   • Departmental Compliance Heatmap with color-coded scores
   • Teacher Integrity Index sorted by score
   • Pie Chart: Critical Suspicion Distribution
   • Bar Chart: Top 10 Semester Load Analysis
   • Forensic Investigation Panel (suspicious files registry)

2. Teacher Validation Sheet (Teacher Reports)

   • Columns: Teacher, Course Info, Type, Filter, Folder, Status, Files, Missing, Naming Issues.
   • AutoFilter Enabled: Instantly filter any dimension.
   • Institutional color-coding (Green/Yellow/Orange/Red) based on compliance %.
   • Summary metrics for Complete vs. Incomplete courses.

3. Data Sheet (Audit Report)

   • Full file listing with forensic meta-data.
   • Conditional formatting: Yellow for "Potential Duplicate", Red for "Confirmed Duplicate"

👨‍💻 Development Credits

This solution is an official production of Cognivex.

• Corporate: Cognivex
• Lead Architect: Rasikh Ali
  • LinkedIn Profile
  • GitHub Portfolio

© 2026 Rasikh Ali