School System

This project is a web application for a school with over 500 students, aimed at enhancing administrative efficiency and improving the user experience for students, teachers, parents, and staff.

The application features a dashboard for administrators, user- friendly interfaces for parents, teachers, and collaborators, and includes various tools for efficient school management.The images presented here contain fake data, as the real data from the school can't be shown for privacy reasons.

Key Features

01. Profile Management

Centralizes the management of personal and contact information for students, teachers, parents, and staff.

• Admins can create, update, and delete profiles for students, parents, and staff members.
• Profiles include essential information such as names, addresses, contact details, and role-specific data.
• Ensures that all user data is up-to-date and easily accessible from a single platform.

02. Groups and Generations

Organizes students into specific groups and generations for quick tracking.

• Allows the creation of student groups based on grade level.
• Tracks academic generations, facilitating the administration of students over academic years.
• Makes the assignment of students to different groups and generations very simple.

03. Table Views with Filtering and Search

Provides tools for viewing and managing all the data of the application efficiently.

• Displays data in an organized table format, allowing users to view lists of students, teachers, classes, etc.
• Includes advanced filtering options and optimized search functionality.

04. Class Scheduling

Facilities the creation of class schedules, ensuring that all the students and teachers are aware of their schedules.

• Allows admins and coordinators to create classes with their date and time.
• Assignment of teachers and students to their corresponding classes.

05. Role-Based User Authentication and Authorization

Ensures data security and access control by assigning roles to users.

• Implements a role-based system where access to features and data is determined by user roles (admin, teacher, parent, etc).
• Facilitates the assignment and management of user roles and permissions.

06. Finance Tracking

Provides tools for managing the school's financial transactions.

• Enables tracking of financial transactions, including income (tuition fees, uniforms, etc) and expenses (salaries, utilities, etc).
• Special filtering options for viewing financial data and options for import and export.

Challenges Faced

01. Data Security and Privacy

We used the NextAuth.js library to handle the authentication and authorization. This ensured a secure system for managing the user sessions and roles.

02. Scalability

The application was designed to handle the growing needs of the school by utilizing Prisma ORM in combination with PostgreSQL. This setup allowed for efficient data management and quick retrieval of information. We also used TypeScript for type safety and making the codebase maintainable.

03. User Interface

We created an intuitive and user-friendly interface using Tailwind CSS. This made the creation of the different components and pages very easy and allowed for a consistent design throughout the application.