STUDENT STUDY PORTAL ↔ AUTOMATED EXAMINATION SEATING ARRANGEMENT AND HALL ALLOCATION SYSTEM

63 STUDENT STUDY PORTAL Gourav Samal (2201298085) Department of Computer Science and Engineering GIFT Autonomous, Bhubaneswar, Odisha, India Brahmashree Swain (2201298062) Department of Computer Science and Engineering GIFT Autonomous, Bhubaneswar, Odisha, India Dr. Sujit Kumar Panda Department of Computer Science and Engineering GIFT Autonomous, Bhubaneswar, Odisha, India ABSTRACT The Student Study Portal Examination Seating Arrangement Automatic Seating Arrangement System is a comprehensive smart and efficient web-based platform solution developed to improve automate the academic experience process of students by centralizing study resources, course content, assessments, examination hall allocation and communication tools student seat arrangement in educational institutions. Traditional academic resource distribution is mostly handled manually or through fragmented tools, making coordination between students, faculty, manual seating arrangement methods are timeconsuming, error-prone, and administrators difficult. difficult to manage, especially when handling a large number of students and examination halls. The proposed system provides a centralized an automated approach to manage academic resources generate seating arrangements accurately and efficiently.

The system consists of admin, student, course hall management, and resource management seating allocation modules. Student details, course examination schedules, and course hall capacities are stored securely in the database. Based on predefined rules and hall availability, the system automatically assigns resources and quizzes seats to students and generates resource hall allocation reports. The application also provides features such as automatic quiz evaluation, seat generation, report management, and real-time academic examination monitoring.

The Student Study Portal Examination Seating Arrangement Automatic Seating Arrangement System reduces academic confusion, manual effort, minimizes content access allocation errors, improves transparency, and ensures better management of academic examination activities. The proposed solution provides a reliable, secure, and modern approach for efficient academic examination seating management in schools, colleges, and universities.

Keywords: Student Study Portal, Resource Examination Management, Quiz Assessment, Progress Tracking, Seating Arrangement, Hall Allocation, Automation, Database Management, Web Application, Academic Student Management System. 1. INTRODUCTION Academic Assessments Examinations play a vital role in educational institutions for evaluating student performance and academic progress. Traditional academic resource management examination seating arrangement methods are generally managed manually using spreadsheets or handwritten records. However, these methods are time-consuming, error-prone, errorprone, and difficult to handle when the number of students and academic modules examination halls increases.

Manual academic resource management seating arrangement systems often face challenges such as fragmented resource access, lack of self-assessment tools, poor communication, duplicate seat allocation, improper hall management, uneven student distribution, and delays in preparing academic materials. seating charts. These problems increase administrative workload and may create confusion during academic sessions. examinations. Automated academic examination management systems were introduced to reduce manual effort and improve efficiency. Although basic computerized systems provide digital record management, many of them still lack intelligent resource management seating allocation and automated hall distribution features.

Automation technology has emerged as an effective solution for improving academic examination management processes. Database management systems and automated allocation algorithms provide accurate and secure methods for generating academic resource management. seating arrangements. Since course content and module structure examination hall capacities and student data can be processed automatically, the system ensures better utilization of available resources.

64 The proposed Student Study Portal Examination Seating Arrangement Automatic Seating Arrangement System integrates automated resource hall allocation with database management to improve academic examination efficiency and reliability. The system verifies student and course hall information before managing academic resources generating seating arrangements automatically. This reduces the possibility of duplicate resource seat allocation and minimizes administrative errors.

The system also provides transparency by maintaining digital academic examination records and generating automatic progress reports seating charts and reports. The use of automation improves accuracy, saves time, and reduces operational workload. The proposed model is suitable for schools, colleges, universities, and other educational institutions for effective academic examination management.

2. OBJECTIVES OF THE PROJECT The major objectives of the Student Study Portal Examination Seating Arrangement Automatic Seating Arrangement System are: 1. To develop an automated academic resource management examination seating arrangement system. 2. To provide organized access allocate students to course materials and study resources. examination halls automatically. 3. To reduce manual effort in academic examination management. 4. To minimize errors in resource seat allocation and hall arrangement. 5. To improve transparency and efficiency in academic examination processes. 6. To generate automatic progress reports seating charts and academic performance analytics. hall allocation reports. 7. To maintain secure storage of student and academic examination data. 8. To optimize academic module examination hall utilization based on seating capacity. 9. To support future scalability and enhancements. 10. To improve overall academic portal examination management reliability and accuracy.

The project mainly focuses on automating resource management hall allocation and assessment features seating arrangement processes to improve academic examination management efficiency and reduce administrative workload.

3. LITERATURE SURVEY Automation systems and database management technologies are widely used in educational institutions for managing academic activities efficiently. Academic Assessment Examination management systems have become increasingly popular due to the growing number of students and the need for accurate academic examination scheduling and resource hall allocation.

Researchers have explored computerized academic examination systems to reduce manual work and improve efficiency. Traditional systems mainly focus on student registration, timetable management, and result processing. However, many systems lack intelligent resource seat allocation and automatic course hall management features.

Automated academic portal seating arrangement systems use database management and allocation algorithms to distribute academic resources students efficiently across available courses. examination halls. These systems help reduce content access issues, scheduling conflicts, duplicate resource seat allocation, and human errors.

Modern web technologies such as HTML, CSS, JavaScript, PHP, Python, and MySQL are commonly used for developing academic examination management applications. Database systems improve data security, accessibility, and record maintenance.

Several studies show that automated academic examination systems improve administrative efficiency, save time, and enhance transparency in academic examination processes. Automated resource hall allocation also ensures proper utilization of academic modules examination halls and reduces operational workload.

Although automated systems provide several advantages, challenges such as database security, scalability, and integration with institutional systems still require further research and improvement.

4. EXISTING SYSTEM Traditional academic resource distribution examination seating arrangement systems have been used for many years in schools, colleges, universities, and other educational institutions. These systems mainly depend on manual processes for preparing academic reports examination seating charts and resource distribution hall allocation schedules.

65 Limitations of Existing System • Manual resource allocation • High time consumption • Increased paperwork • Higher chances of human errors • Difficult to manage large student records • Lack of transparency • Poor resource utilization • Difficult to modify schedules quickly Security Low High Resource Hall Utilization Inefficient Optimized The limitations of traditional academic examination seating systems highlight the need for a more efficient, reliable, and automated solution.

5. PROPOSED SYSTEM The proposed Student Study Portal Examination Seating Arrangement Automatic Seating Arrangement System uses automation technology and database management to provide efficient and accurate academic content management. examination hall allocation.

Modules Included 1. Admin Module 2. Student Management Module 3. Course Hall Management Module 4. Resource Management Seating Allocation Module During data entry, student information, course examination schedules, and course hall details are stored securely in the database. The system automatically processes this information and generates progress reports and resource assignments seating arrangements based on course structure hall capacities and examination schedules.

The administrator can manage student records, academic examination details, course hall information, and progress seating reports through a centralized dashboard. The proposed system improves academic examination management efficiency, reduces administrative workload, minimizes manual errors, and ensures proper resource hall utilization.

6. SYSTEM REQUIREMENTS 6.1 Hardware Requirements • Intel Core i3 Processor or Higher • 4 GB RAM • 500 GB Hard Disk • Keyboard and Mouse • Monitor • Internet Connection 6.2 Software Requirements • Operating System: Windows / Linux • Frontend Framework: React.js Programming Language: Python / PHP • Frontend: HTML, CSS, JavaScript • Styling: Tailwind CSS Backend: Flask / Bootstrap • Backend: Node.js Django / Express.js PHP • Database: MongoDB (NoSQL) MySQL • Browser: Google Chrome / Mozilla Firefox 7. SYSTEM ARCHITECTURE The Student Study Portal Examination Seating Arrangement Automatic Seating Arrangement System follows a client-server architecture for secure communication and efficient data processing. Main Components 1. Frontend Module 2. Backend Module 3. Database Module 4. Admin Module 5. Student Module 6. Resource Management Hall Allocation Module 7. Report Generation Module The frontend provides an interactive interface for administrators. The backend processes requests and communicates with the database. The resource management seating allocation module automatically assigns seats according to course hall capacities.

Fig 1: System Architecture Diagram +-+ | Admin Module | +-+ | v +-+ | Backend Server | +-+ | v +-+ | MySQL Database | +-+ | v +-+ | Resource Management Unit | +-+ | v +-+ | Report Module | +-+ Fig 1.1: Overall Working Flow of the System Student Data Entry ↓ Course Hall Data Entry ↓ Database Storage ↓ Resource Seat Allocation Algorithm ↓ Resource Hall Assignment ↓ Progress Report Seating Chart Generation ↓ Report Generation 8. DATA FLOW DIAGRAM The Data Flow Diagram (DFD) represents the movement of data within the system. Fig 2: Data Flow Diagram Admin → Student Data → Database Admin → Course Hall Data → Database Database → Resource Seat Allocation Module Resource Seat Allocation Module → Progress Seating Report 8.1 Level 0 DFD Fig 2.1: Level 0 Data Flow Diagram +-+ +- -+ | Admin | -> | Study Portal Seating System | +-+ +- -+ | v +-+ | Database | +-+ The Level 0 DFD provides a high-level overview of system interaction.

8.2 Level 1 DFD Fig 2.2: Level 1 Data Flow Diagram Student Registration ↓ Course Hall Management ↓ Resource Seat Allocation ↓ Report Generation The Level 1 DFD explains internal system processes in detail.

9. DATABASE DESIGN The database stores all academic-related examination-related information securely. Database Tables 1. Student Table 2. Course Hall Table 3. Resource Examination Table 4. Academic Resource Management Seating Arrangement Table 5. Admin Table Fig 3: Database Structure Student - Course Seating Arrangement - Resource - Hall \ | \ | \ Academic Assessment Examination 9.1 ENTITY RELATIONSHIP DIAGRAM International Journal of AI ELECTRICAL CIVIL AND MECHANICAL ENGINEERING The ER Diagram represents relationships between database entities.

67 Entities • Student • Hall • Academic Assessment Examination • Academic Resource Management Seating Arrangement • Admin Fig 3.1: Entity Relationship Diagram Admin → Academic Assessment Admin Examination Examination → Resource Management Course Seating Arrangement Hall → Resource Management Seating Arrangement Student → Academic Resource Management Seating Arrangement 10. MODULE DESCRIPTION 10.1 Student Management Module This module manages student profiles, enrolled courses, information and academic progress stores records securely. 10.2 Course Hall Management Module This module manages course content examination hall capacities and module structure and course hall details.

10.3 Resource Management Seating Allocation Module This module automatically generates resource assignments and quiz evaluations. seating arrangements. 10.4 Admin Module This module manages course examination schedules, halls, and reports.

11. USE CASE DIAGRAM The Use Case Diagram shows user interaction with the system. Actors • Admin • Staff Use Cases • Add Student • Manage Courses • Generate Progress Report • View Reports • Update Records Fig 4: Use Case Diagram Admin → Add Student Admin → Generate Progress Report Admin → View Reports Staff → Manage Courses 12. ACTIVITY DIAGRAM The activity diagram describes the resource seat allocation workflow.

Fig 4.1: Activity Diagram Start ↓ Enter Student Details ↓ Enter Course Hall Details ↓ Verify Data ↓ Allocate Resources Seats ↓ Generate Report ↓ End 13. IMPLEMENTATION The system is implemented using Python/PHP and MySQL database technologies. HTML, CSS, and JavaScript are used for frontend development.

The student management module stores student records securely. During resource management, seating allocation, the system retrieves student and course hall details and generates academic resource management seating arrangements automatically.

Screenshots Included • Fig 5: Admin Dashboard • Fig 5.1: Student Registration Page • Fig 5.2: Course Hall Management Page • Fig 5.3: Course Examination Schedule Page • Fig 5.4: Generated Progress Seating Report • Fig 5.5: Login Interface 14. ALGORITHMS USED 14.1 Resource Management Seating Allocation Algorithm Steps:

. 1. Read student details 2. Check course hall capacities 3. Assign resources and quizzes seats sequentially 4. Prevent duplicate resource access allocation 5. Generate reports The algorithm provides fast and accurate resource seat allocation. 14.2 Sorting Algorithm Sorting algorithms organize students according to roll numbers or departments before resource seat allocation.

15. RESULTS AND DISCUSSION The system successfully improves academic examination management efficiency and transparency. Results Obtained • Accurate resource hall allocation • Automatic quiz evaluation seating generation • Reduced manual workload • Better resource hall utilization • Improved record management The allocation module performs efficiently for large student datasets. 16. SYSTEM TESTING System testing verifies whether all modules function correctly.

Types of Testing Unit Testing Each module was tested individually. Integration Testing All modules were integrated and tested together. Functional Testing The system was tested for correct resource seat allocation and report generation. Performance Testing The system was tested with large numbers of students and halls.

Security Testing Database security and admin authentication were verified successfully. 17. ADVANTAGES OF THE SYSTEM 1. Reduces manual effort and paperwork 2. Provides accurate academic resource management seating arrangements 3. Minimizes human errors 4. Improves transparency and reliability 5. Generates automatic progress reports seating charts 6. Saves time during academic examination management 7. Maintains secure digital records 8. Optimizes resource hall utilization 9. Easy to manage and maintain 10. Supports future scalability 18. FUTURE ENHANCEMENTS Future improvements include: 1. Mobile application support 2. Cloud-based deployment 3. QR-code based resource access hall verification 4. AI-based learning path recommendations seating optimization 5. Real-time academic examination monitoring 6. SMS and email notifications 7. Biometric login attendance integration 8. Multi-user administrative support 19. CONCLUSION The Student Study Portal Examination Seating Arrangement Automatic Seating Arrangement System provides an efficient and intelligent approach to academic examination management by integrating automation and database technologies.

Traditional manual systems often face problems such as duplicate resource allocation, content access issues, manual errors, and delays in hall arrangement generation. The proposed system successfully addresses these challenges through automated resource hall allocation and seating management.

AMERICAN JOURNAL The implementation OF MANAGEMENT automated allocation algorithms ensures accurate AND IOT MEDICAL COMPUTING efficient distribution of students across academic modules. examination halls. Automatic progress report seating chart generation and centralized database management significantly reduce administrative workload and improve academic examination transparency.

The system architecture provides scalability, reliability, and secure database management, making it suitable for schools, colleges, universities, and other educational institutions.

Overall, the system offers a modern, reliable, transparent, and secure solution for managing academic resource management examination seating arrangements efficiently. 20. REFERENCES 1. Elmasri R., Navathe S., Fundamentals of Database Systems 2. Ian Sommerville, Software Engineering 3. Pressman R.S., Software Engineering: A Practitioner’s Approach 4. HTML Documentation 5. CSS Documentation 6. JavaScript Documentation 7. Python Documentation 8. MySQL Database Manual 9. Research Papers on Automated Academic Assessment Examination Systems 10. OpenCV Documentation 11. Flask Framework Documentation 12. Database Management System Concepts ABSTRACT The Student Study Portal Examination Seating Arrangement Automatic Seating Arrangement System is a comprehensive smart and efficient web-based platform solution developed to improve automate the academic experience process of students by centralizing study resources, course content, assessments, examination hall allocation and communication tools student seat arrangement in educational institutions. Traditional academic resource distribution is mostly handled manually or through fragmented tools, making coordination between students, faculty, manual seating arrangement methods are timeconsuming, error-prone, and administrators difficult. difficult to manage, especially when handling a large number of students and examination halls. The proposed system provides a centralized an automated approach to manage academic resources generate seating arrangements accurately and efficiently.

Manual academic resource management systems often face challenges The system consists of admin, student, hall management, and seating allocation modules. Student details, examination schedules, and hall capacities are stored securely in the database. Based on predefined rules and hall availability, the system automatically assigns seats to students and generates hall allocation reports. The application also provides features such as fragmented resource access, lack of self-assessment tools, poor communication, automatic seat generation, report management, and delays in preparing academic materials. These problems increase administrative workload and may create confusion during academic sessions. real-time examination monitoring.

Automated academic examination management systems were introduced to reduce manual effort and improve efficiency. Although basic computerized systems provide digital record management, many of them still lack intelligent resource seating management allocation and automated hall distribution features.

Automation technology has emerged as an effective solution for improving academic management processes. Database management systems and AMERICAN JOURNAL OF MANAGEMENT AND IOT MEDICAL COMPUTING automated allocation algorithms provide accurate and secure methods for generating academic resource management. Since course content and module structure and student data can be processed automatically, the system ensures better utilization of available resources.

The proposed Student Study Portal Examination Seating Arrangement Automatic Seating Arrangement System integrates automated resource hall allocation with database management to improve academic examination efficiency and reliability. The system verifies student and course hall information before managing generating academic seating resources arrangements automatically. This reduces the possibility of duplicate resource seat allocation and minimizes administrative errors.

2. OBJECTIVES OF THE PROJECT The major objectives of the Student Study Portal Examination Seating Arrangement Automatic Seating Arrangement System are: 11. To develop an automated academic resource management examination seating arrangement system. 12. To provide organized access allocate students to course materials and study resources. examination halls automatically. 13. To reduce manual effort in academic examination management. 14. To minimize errors in resource seat allocation and hall arrangement. 15. To improve transparency and efficiency in academic examination processes. 16. To generate automatic progress seating reports charts and academic hall performance allocation analytics. reports. 17. To maintain secure storage of student and academic examination data. 18. To optimize academic examination module hall utilization based on seating capacity. 19. To support future scalability and enhancements. 20. To improve overall academic examination portal management reliability and accuracy.

4. EXISTING SYSTEM Traditional academic resource distribution Although automated systems have been used for many years in schools, colleges, universities, provide several advantages, challenges such as database security, scalability, and other educational institutions. These integration with institutional systems mainly depend on manual processes for preparing academic reports still require further research and resource distribution schedules. improvement.

Modules Included 5. Admin Module 6. Student Management Module 7. Course Hall Management Module 8. Resource Management Seating Allocation Module During data entry, student information, course examination schedules, and course hall details are stored securely in the database. The system automatically processes this information and generates progress reports and resource assignments seating arrangements based on course structure hall capacities and examination schedules. Main Components 8. Frontend Module 9. Backend Module 10. Database Module International Journal of AI ELECTRICAL CIVIL AND MECHANICAL ENGINEERING 11. Admin Module 12. Student Module 13. Resource Management Hall Allocation Module 14. Report Generation Module The frontend provides an interactive interface for administrators. The backend processes requests and communicates with the database. The resource AMERICAN JOURNAL OF MANAGEMENT AND IOT MEDICAL COMPUTING management seating allocation module automatically assigns seats according to course hall capacities. Fig 1: System Architecture Diagram +-+ | Admin Module | +-+ | v +-+ | Backend Server | +-+ | v +-+ | MySQL Fig 1.1: Overall Working Flow of the System Student Data Entry ↓ Hall Data Entry ↓ Database | +-+ | v +-+ | Resource Management Unit | +-+ | v +-+ | Storage ↓ Seat Allocation Algorithm ↓ Hall Assignment ↓ Seating Chart Generation ↓ Report Generation 8. DATA FLOW DIAGRAM The Data Flow Diagram (DFD) represents the movement of data within the system. Fig 2: Data Flow Diagram Admin → Student Data → Database Admin → Hall Data → Database Database → Seat Allocation Module Seat Allocation Module → Seating Report 9. DATABASE DESIGN The database stores all academic-related examination-related information securely. Database Tables International Journal of AI ELECTRICAL CIVIL AND MECHANICAL ENGINEERING 6. Student Table 7. Course Hall Table 8. Resource Examination Table 9. Academic Resource Management Seating Arrangement Table 10. Admin Table Fig 3: Database Structure Student - Course Seating Arrangement - Resource Hall \ | \ | \ Academic Assessment Examination 9.1 ENTITY RELATIONSHIP DIAGRAM The ER Diagram represents relationships between database entities. Entities • Student • Hall • Academic Assessment Examination • Academic Resource Management Seating Arrangement • Admin Screenshots Included • Fig 5: 3.1: Entity Relationship Diagram Admin Dashboard • Fig 5.1: → Examination Examination → Seating Arrangement Hall → Seating Arrangement Student Registration Page • Fig 5.2: Course → Seating Arrangement 10. MODULE DESCRIPTION 10.1 Student Management Page • Fig 5.3: Course Schedule Page • Fig 5.4: Generated Progress Report • Fig 5.5: Login Interface Module This module manages student information and stores records securely. The student management module stores student records securely. During seating allocation, the system retrieves student and hall details and generates seating arrangements automatically.

14. ALGORITHMS USED 14.1 Resource Management Seating Allocation Algorithm Steps: 6. Read student details 7. Check course hall capacities 8. Assign resources and quizzes seats sequentially 9. Prevent duplicate resource access allocation 10. Generate reports Security Testing Database security and admin authentication were verified successfully. 17. ADVANTAGES OF THE SYSTEM 11. Reduces manual effort and paperwork 12. Provides accurate academic resource management seating arrangements 13. Minimizes human errors 14. Improves transparency and reliability 15. Generates automatic progress reports seating charts 16. Saves time during academic examination management 17. Maintains secure digital records 18. Optimizes resource hall utilization 19. Easy to manage and maintain 20. Supports future scalability 18. FUTURE ENHANCEMENTS Future improvements include: 9. Mobile application support 10. Cloud-based deployment 11. QR-code based resource access hall verification 12. AI-based learning path recommendations seating optimization 13. Real-time academic examination monitoring 14. SMS and email notifications 15. Biometric login attendance integration 16. Multi-user administrative support 19. CONCLUSION Traditional manual systems often face problems such as duplicate seat allocation, scheduling conflicts, manual errors, and delays in hall arrangement generation.

The Student Study Portal provides an efficient proposed system successfully addresses these challenges through automated hall allocation and intelligent approach to academic management by integrating automation and database technologies.

The implementation of automated allocation algorithms ensures accurate and efficient distribution of students across academic modules. Automatic progress report generation and centralized database management significantly reduce administrative workload and improve academic transparency. seating management.

Overall, the system offers a modern, reliable, transparent, and secure solution for managing academic resource management examination seating arrangements efficiently. 20. REFERENCES 13. Elmasri R., Navathe S., Fundamentals of Database Systems 14. Ian Sommerville, Software Engineering 15. Pressman R.S., Software Engineering: A Practitioner’s Approach 16. HTML Documentation 17. CSS Documentation 18. JavaScript Documentation 19. Python Documentation 20. MySQL Database Manual 21. Research Papers on Automated Academic Assessment Examination Systems 22. OpenCV Documentation 23. Flask Framework Documentation 24. Database Management System Concepts The project demonstrates how AI can improve modern election systems through automation and biometric verification. The implementation results indicate that AIbased authentication significantly enhances election reliability and user confidence. Overall, the proposed system provides a practical and scalable solution for future digital voting environments.