Dynamic Web-Based Student Management (thesis abstract)
For a post-graduate project in university, I developed a prototype web-based student information exchange system using Linux, Perl, it's associated modules, Ajax and SQLite. At my university, there was a bit of inefficiency in the exchange of student information which I set out to prove could be alleviated with a tailored minimalist web application written in Perl. This was achieved using the Catalyst framework and it's AutoCRUD plugin, written by Oliver Gorwits, for performing CRUD (create, read, update, delete) functions on most modern databases. I'd also like to thank Mr. Gorwits and Dr. Damian Conway for taking time to review the thesis.
The following is an abstract of the final thesis. Following posts will describe the steps followed in developing the prototype as well as code snippets.
Sufficient information is crucial for accurate decision making in any organisation . This can be seen in a University situation where many students are enrolled and correct decisions need to made on their progress conditions. These decisions need to be made swiftly to meet the tight schedule of a University academic year. The University Of Papua New Guinea registers thousands of students each year. Each of these students are required to consult a designated course advisor in order to sign up for courses. Much of the data required for this is transferred around on paper before it is entered into a student database by data entry clerks. This poses a few potential issues; there is a lot of time wasted in queues, excessive man-hours lost in course advising and human error in decision making as well as in data entry to name a few. These processes can be aided by implementing an electronic student information system to enhance the transfer of data, maintain data integrity and reduce human error, hence improving efficiency. Delivering this via web technology ensures that the system is accessible to the vast array of computers, devices and their operating software available today without the the need for a specific client software . Open source technologies were utilised in implementation for their flexibility and economy. A prototype was created using an SQLite database and the Perl based Catalyst web framework. Upon completion, fast retrieval and update of required data was achieved via only a web browser. Hypothetically, this will improve the current process, reducing error as well as saving time and money which can be better utilised.