Teacher Student Timetable Scheduling System
An Effective Timetable is a dire need of any university. It is usually managed by the coordinator of the respective department. Generally, a timetable is shown on the noticeboard which can be viewed by students/teachers to get information about their respective schedules. This requires a need to fil
2025-06-28 16:29:41 - Adil Khan
Teacher Student Timetable Scheduling System
Project Area of Specialization Software EngineeringProject SummaryAn Effective Timetable is a dire need of any university. It is usually managed by the coordinator of the respective department. Generally, a timetable is shown on the noticeboard which can be viewed by students/teachers to get information about their respective schedules. This requires a need to filter out the extra information from the timetable. In addition, extracting information regarding faculty member’s availability and their counseling hours, availability of rooms/slots will be a hectic task when done by the existing process.
The system will allow the users to get updates regarding changes in the timetable. It will help the teachers to find a list of rooms that are not scheduled for a class/makeupslot in a particular time constraint, counseling hours of a faculty member, and it will allow a faculty member to schedule makeupslots. These types of problems will be solved in this project.
The system consists of five components, a desktop application, a mobile application, a RESTful WEB API, a relational database, and a firebase account. The desktop application is developed using C# Dot Net Framework. The mobile application is developed using Android Java API Framework, The WEB API is developed using C# Dot Net Core. MS SQL Server database is used. User Authentication, User Management, and Cloud Messaging have been used from firebase services.
The desktop application will allow the coordinator to manage the timetable, makeupslots, and other resources (i.e. classes, rooms, and timeslots, etc.). The mobile application will allow the teacher and students to view their weekly timetable, faculty profiles, and upcoming makeupslots. The teachers can also update their counseling hours and schedule makeupslots using the mobile application.
The system is tested as a black box at the unit and integration level. The system has two main applications a desktop application, and a mobile application. The tests regarding the main features of the system have been performed on the desktop application as well as for mobile application using the black-box strategy. The system is also tested as a whole after the integration of all five components of the system. The system is working efficiently as all the test cases have been passed successfully.
Project ObjectivesThe project objectives are as follows:
- To help the coordinator to create a conflict-free timetable.
- To help the coordinator to generate the timetable within seconds.
- To help the teacher to view the mutually free slots with a class, and available rooms on a particular day while scheduling makeupslots.
- To help the teachers and students to view their up to date timetable on their mobile phones.
- To help the teachers and students to view their upcoming makeupslots.
- To help the teachers and students to view the counseling hours, office details of each of the faculty members.
The system is developed using “Personal Scrum” or “Agile methodology” in which an individual works alone to develop a system.
Scrum is a simple framework for effective team collaboration on complex projects. It is a way for teams to work together to develop a product. But it is not limited to teams only; it works well for individuals also. Personal scrum is an agile methodology that adapts and applies scrum practices to one-person projects. It promotes personal productivity through observation, adaptation, progressive elaboration, prioritizing and sizing work, and time-boxing.
Benefits of the ProjectThe System will provide benefits to the coordinator, teachers, and students. Some of the benefits have been described as below following
- Conflict-Free Timetable
- Automatic Generation of Timetable
- Teacher Specific Timetable
- Student Specific Timetable (including the timetable entries of a repeating subject)
- Responsive & User-Friendly Mobile Application
- Availability of free rooms in a particular time constraint
The system consists of five components, a desktop application, a mobile application, a RESTful WEB API, a relational database, and a firebase account. The desktop application is developed using C# Dot Net Framework. The mobile application is developed using Android Java API Framework, The WEB API is developed using C# Dot Net Core. MS SQL Server database is used. User Authentication, User Management, and Cloud Messaging have been used from firebase services.
The desktop application will allow the coordinator to manage the timetable, makeupslots, and other resources (i.e. classes, rooms, and timeslots, etc.). The mobile application will allow the teacher and students to view their weekly timetable, faculty profiles, and upcoming makeupslots. The teachers can also update their counseling hours and schedule makeupslots using the mobile application.
The final deliverable will include the following deliverables.
- Desktop Application (WinForm Application)
- Mobile Application (Android API 22 or greater)
- WEB API (.Net Core V3.1)
- MS SQL Server Database (Remote)
A PC is required to run the desktop application (which will be operated by the coordinator). The coordinator will manage the records on a remote database, so teachers and students will fetch the records on their smartphones from that remote database using Web API.
Final Deliverable of the Project Software SystemCore Industry EducationOther IndustriesCore Technology OthersOther Technologies Cloud InfrastructureSustainable Development Goals Quality EducationRequired Resources| Item Name | Type | No. of Units | Per Unit Cost (in Rs) | Total (in Rs) |
|---|---|---|---|---|
| Total in (Rs) | 26500 | |||
| Laptop RAM DDR3 8GB Chips (Used) | Equipment | 2 | 4250 | 8500 |
| WD 240GB SSD HDD GREEN | Equipment | 1 | 6000 | 6000 |
| UNIVERSAL 2.5 | Equipment | 1 | 1000 | 1000 |
| Azure App Service (One Month) | Equipment | 1 | 10000 | 10000 |
| Azure SQL Database (One Month) | Equipment | 1 | 1000 | 1000 |