Awislabs Engineering blog

Introduction

Managing a school’s data can be quite a task, especially when dealing with numerous teachers, students, and classrooms. However, recent advancements in our School Scheduling System have made this process much more manageable and efficient. One of the most exciting features we’ve introduced is the ability to import data directly from spreadsheets, making bulk data entry a breeze. Let’s dive into this and other significant progress we’ve made recently.

Importing Data from Spreadsheets

Imagine you have a list of teachers or classrooms in an Excel sheet or Google Sheets, and you need to add them to the system. Instead of manually entering each record, you can now simply copy and paste the data directly into our system. This feature not only saves time but also reduces the likelihood of errors.

How It Works

Here’s a quick overview of how this feature works:

1. Paste Your Data: Copy the relevant data from your spreadsheet and paste it into a provided text area in our system.

2. Preview the Data: Our system parses the data and provides a preview, ensuring you can verify everything before proceeding.

3. Save to Database: With a single click, the data is saved into the system, creating records for each entry.

Example

For instance, if you have a list of teachers with their names, email addresses, and phone numbers, you can paste the data in the following format:

John Doe	[email protected]	123-456-7890	JD
Jane Smith	[email protected]	098-765-4321	JS

After pasting this data, the system will display a preview, and upon confirmation, all entries will be added to the database.

Recent Progress

Dashboard Enhancements

We’ve significantly enhanced our dashboard to provide a more comprehensive view of the school’s data. Administrators can now see stats related to their specific schools, including the number of classrooms, teachers, subjects, and schedules. This improvement ensures that each user has access to relevant information, making management more efficient.

Role Management

Role management is crucial for maintaining an organized and secure system. We have integrated the Spatie/laravel-permission package to manage user roles effectively. The roles include:

• Superadmin: Full access to all functionalities, including the ability to manage multiple schools.

• School Admin: Can manage a specific school and assign roles to teachers and students within that school.

• Teacher: Limited access, primarily focused on managing their schedules and classes.

• Student: Basic access, mainly for viewing schedules and class-related information.

Assigning Schools to Users

Another critical feature is the ability to assign users to specific schools. This functionality ensures that administrators can manage their schools effectively without interfering with others. The system also assigns the admin role to the user who creates the school, ensuring they have the necessary permissions to manage it.

Improved Schedule Management

We’ve improved the schedule management system to make it more intuitive and flexible. The time slot management feature now includes different session types (morning and evening) and automatically handles recess periods. This update ensures that schedules are realistic and adhere to the school’s timetable.

Conclusion

These recent updates aim to make school management more efficient and user-friendly. By introducing features like data import from spreadsheets, enhanced dashboards, comprehensive role management, and improved scheduling, we’re ensuring that administrators, teachers, and students have a seamless experience.

Stay tuned for more exciting updates as we continue to enhance our School Scheduling System! If you have any feedback or suggestions, feel free to reach out. We’re always looking for ways to make the system even better.

Thank you for being a part of this journey. Together, we’re making school management smarter and more efficient!