CampusIQ: A Secure Multi-Portal Web Platform for Intelligent School Management

Abstract

CampusIQ is a web-based school management system developed as a single place for handling the academic and day-to-day administrative work of a school. The system was built using React and Vite on the frontend, Express.js for the REST backend, PostgreSQL for data storage, Prisma as the ORM, and JWT for authentication. A user\'s school context is taken from the authenticated request, which helps prevent records from one school being exposed to another. The completed system has four connected portals for Admin, Teacher, Student, and Parent users. These portals cover academic-year setup, master data, student and staff records, attendance, examinations, fees, timetable, assignments, and notifications. The project also includes three AI-assisted features. Parents can use the Academic Performance Predictor, teachers can use the AI Teacher Co-Pilot to prepare classroom material, and administrators can use the AI-assisted Complaint Management module to organize and review complaints. This paper explains the way these parts were put together, the security approach used in the project, and the features that were completed and deployed.

Introduction

CampusIQ is an integrated school management and learning-analytics platform designed to bring academic, administrative, communication, and AI-assisted activities into a single web application. Traditional school systems often maintain information across paper registers, spreadsheets, and separate applications, resulting in duplicate data entry and difficulty accessing up-to-date information. CampusIQ addresses this problem by connecting student, staff, attendance, examinations, fees, timetable, assignments, notifications, and complaint management through a shared backend and relational database.

The system follows a modular-monolith architecture using React 19/Vite for the frontend, Node.js and Express.js for REST APIs, PostgreSQL with Prisma for data management, and JWT/bcrypt for authentication. Four role-specific portals—Admin, Teacher, Student, and Parent—use the same backend while providing access according to each user's responsibilities. The tenant-aware database design ensures that schools remain logically separated, while role-based authorization restricts users to permitted functions and records.

CampusIQ integrates several important school workflows. Administrators can manage academic structures, students, staff, fees, examinations, attendance, timetables, complaints, and institutional dashboards. Teachers can manage classes, attendance, assignments, examinations, schedules, and notifications. Students can access their attendance, assignments, timetable, examinations, results, performance information, and complaints, while parents can monitor their children's academic activities and performance.

A major contribution of the project is the integration of AI-assisted educational services directly into the ERP workflow. The AI Academic Performance Predictor analyzes attendance, assignments, and assessment information to provide a performance score, trend, confidence indicator, and explanation. The AI Teacher Co-Pilot helps teachers prepare question papers, MCQs, quizzes, lesson plans, explanations, assignments, and other classroom materials. The AI-assisted Complaint Management system analyzes complaints for sentiment and priority while allowing administrators to monitor complaint status and resolution information. These AI functions are designed as decision-support tools, with teachers and administrators retaining final control.

Security and multi-tenancy are central to the architecture. CampusIQ uses JWT authentication, password hashing, role-based authorization, tenant-scoped database queries, input validation, security headers, rate limiting, and database constraints. Importantly, tenant information is derived from the authenticated user context rather than being trusted from browser input, helping prevent users from accessing another school's records. Database constraints also help prevent issues such as duplicate attendance records and timetable conflicts.

The project has been implemented and publicly deployed, demonstrating that the system is more than a conceptual design or interface prototype. The research contribution lies in combining school ERP, learning analytics, multi-tenant access control, and AI assistance within one platform. Instead of treating AI prediction or content generation as isolated demonstrations, CampusIQ connects these features with the school's operational data and everyday workflows.

However, the study identifies limitations in the current evaluation. Although the AI performance predictor is implemented, no formal accuracy value is reported because a sufficiently large and properly labelled production dataset is not yet available. Future evaluation should include functional and security testing, usability studies, API performance testing, and comprehensive AI metrics such as accuracy, precision, recall, F1-score, confusion matrix, and ROC-AUC.

Conclusion

CampusIQ has been completed and deployed as a web platform for handling academic and administrative school activities through connected role-based portals. React, Express.js, PostgreSQL, and Prisma provide the main full-stack foundation, while JWT authentication, role checks, validation, and tenant-scoped queries protect the application\'s important access points. The Admin, Teacher, Student, and Parent portals are live, and the Academic Performance Predictor, Teacher Co-Pilot, and AI-assisted Complaint Management features are connected to the deployed system. https://campus-iq-kabt.onrender.com/https://campus-iq-kabt.onrender.com/ From a research perspective, the project brings school information management, secure multi-tenant software, learning analytics, and AI-assisted tools into one application. The next useful step is to evaluate the features that have already been built using larger and better-structured production data. It is more important to understand how well the current features work in practice than to keep adding AI features simply to increase the size of the system. Keeping teachers and administrators involved in reviewing the outputs will remain important as CampusIQ is tested and extended.

References

[1] L. Breiman, “Random Forests,” Machine Learning, vol. 45, pp. 5–32, 2001, doi: 10.1023/A:1010933404324. [2] D. Ifenthaler and J. Y.-K. Yau, “Utilising learning analytics to support study success in higher education: A systematic review,” Educational Technology Research and Development, vol. 68, pp. 1961–1990, 2020, doi: 10.1007/s11423-020-09788-z. [3] N. Tomasevic, N. Gvozdenovic, and S. Vranes, “An overview and comparison of supervised data mining techniques for student exam performance prediction,” Computers & Education, vol. 143, 103676, 2020, doi: 10.1016/j.compedu.2019.103676. [4] Z. Ersozlu, S. Taheri, and I. Koch, “A review of machine learning methods used for educational data,” Education and Information Technologies, vol. 29, pp. 22125–22145, 2024, doi: 10.1007/s10639-024-12704-0. [5] S. Boujmiraz, H. Darhmaoui, and A. D. El Maliani, “Predicting student performance: A comprehensive review of machine learning, deep learning, and explainable AI approaches,” Computers and Education: Artificial Intelligence, vol. 10, 100548, 2026, doi: 10.1016/j.caeai.2026.100548. [6] “Role and Object Domain-Based Access Control Model for Graduate Education Information System,” Procedia Computer Science, vol. 176, pp. 1241–1250, 2020, doi: 10.1016/j.procs.2020.09.133. [7] “ITADP: An inter-tenant attack detection and prevention framework for multi-tenant SaaS,” Journal of Information Security and Applications, vol. 49, 102395, 2019, doi: 10.1016/j.jisa.2019.102395. [8] F. J. García-García, M. I. Gómez-Núñez, and C. Molla-Esparza, “Applications of learning analytics in the study of academic performance in higher education: A meta-review with an educational perspective,” Higher Education, 2026, doi: 10.1007/s10734-026-01709-y. [9] CampusIQ Project Team, “CampusIQ — Live Deployment,” Department of Computer Science and Engineering, G H Raisoni University, Amravati, accessed Sept. 2026. [Online]. Available: https://campus-iq-kabt.onrender.com/ [10] CampusIQ Project Team, “CampusIQ: A Multi-Agent AI Platform for Intelligent School Management,” Project Progress Seminar, Department of Computer Science and Engineering, G H Raisoni University, Amravati, Sept. 2026.

Copyright

Copyright © 2026 MR Kunal Kanchankar, Siddhant Shende, Pratiksha Khobragade, Kajal Shahu, Dipesh Kanathe, Aditi Bokde, Shrutik Katkar. This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.