Design and Implementation of Students' Project Management and Allocation System (a Case Study of Department of Computer Science Adeyemi College of Education Ondo, Ondo State)

In the final year of many university programs, students face a rite of passage that is as critical as it is chaotic: the selection of a research project. This is not merely a homework assignment but a substantial piece of original work that defines their transition from student to professional. In many institutions, this process relies on a manual, paper-based system where students and supervisors meet in person to negotiate topics, often leading to confusion, duplicated efforts, and a scramble for limited resources. The core challenge lies in matching a student's interest with a supervisor's expertise while ensuring that no two students end up working on the exact same subject, a situation that dilutes the value of the research and strains the department's record-keeping. To solve this, researchers have turned to the principles of database management, a method of organizing information so that it can be stored, retrieved, and checked for errors with speed and precision. By moving these interactions from physical notebooks to a digital platform, institutions can create a clear, centralized record of every topic and every student, ensuring that the path to graduation is defined by the quality of the work rather than the efficiency of the paperwork.

At the Department of Computer Science at Adeyemi College of Education in Ondo, Nigeria, this traditional, manual approach was the standard for years. Students were expected to find their own topics or wait for lecturers to assign them, a process that often resulted in duplicate topics and a lack of organized history regarding past projects. Recognizing these inefficiencies, a researcher named Adeola Abdulramon set out to design and build a digital solution: a web-based system specifically for managing and allocating student projects. The goal was not just to digitize the paperwork, but to create a tool that actively prevents errors. In this new system, when a student attempts to register a project topic, the software immediately checks a central database to see if that specific topic has already been claimed. If the topic exists, the system blocks the entry and alerts the user, effectively stopping the duplication before it happens. This automated check replaces the slow, error-prone method of manually scanning through stacks of paper records to see if a topic is available.

The system was built using a set of standard web technologies that work together to create a secure and interactive environment. The researchers used a database program called MySQL to store all the information, acting as the digital filing cabinet where every student's name, matriculation number, and chosen topic are kept safe. To allow users to interact with this database, they created a visual interface using HTML and CSS, which are the languages that determine how a webpage looks and feels. Behind the scenes, a scripting language called PHP acts as the bridge, translating the clicks and inputs from the user into commands the database can understand. This setup allows for three distinct types of users to log in with different levels of access. The administrator, usually a department head, can register new students and supervisors, manage the entire list of topics, and oversee the system's security. Supervisors can log in to offer their available project topics and review the work of the students assigned to them. Finally, the students can log in to view the list of available topics, select one, and upload their project documents, such as their abstracts or final theses, directly to the system.

During the development of this system, the researcher observed that the existing manual process was vulnerable to human error and lacked a unified way to track the history of past projects. The new design addresses these issues by providing a single, organized platform where the entire lifecycle of a project can be monitored. The system includes features that allow for the verification of topics, ensuring that a student does not accidentally choose a subject that has already been treated by a peer. It also maintains a record of previous years' projects, allowing current students to download abstracts and formats from past work, which serves as a valuable resource for understanding expectations. The interface was designed to be straightforward, with separate login pages for students, supervisors, and administrators, ensuring that each person sees only the tools relevant to their role. For instance, a student cannot see the administrative controls, and an administrator cannot accidentally alter a student's personal project details without going through the proper channels.

The implementation of this system involved a careful testing phase to ensure it functioned correctly before being put into use. The researcher ran the new digital system alongside the old manual process to compare results, a method that provides a safety net in case the new system encounters unexpected issues. The testing confirmed that the system could successfully store student information, prevent duplicate topic entries, and allow for the smooth uploading of project documents. The findings from the study highlighted that while the new system requires a basic level of technical infrastructure, such as a computer with an internet connection and a web browser, the benefits far outweigh the initial setup costs. The system successfully reduced the time wasted on data processing and eliminated the confusion caused by overlapping project topics. It also created a permanent, searchable archive of student work, which was previously difficult to maintain in a paper-based environment.

Despite its success as a prototype, the researcher noted that the system is not without its limitations, primarily due to the constraints of time and funding during the development phase. The study suggests that for the system to reach its full potential, the institution would need to provide adequate funds and infrastructural facilities to support a wider rollout. Furthermore, the researcher recommends that students be encouraged to work in teams to develop such software applications, as this would help them build the necessary database and programming skills. By linking this project allocation system with other student information systems, such as those for grades or attendance, the college could create a fully integrated digital ecosystem. The work concludes that while the transition to a digital system requires effort and adaptation, it is a necessary step to modernize the educational process. The system proves that with the right tools, the complex task of managing hundreds of student projects can be made accurate, efficient, and accessible, allowing students to focus on what matters most: their research.