Resources » Articles/Knowledge Sharing » General
online on-request courses coordination system (ORS)
Title of the project
Development of a feature-rich, practical online on-request courses coordination system (ORS)
Abstract of the project
This project is aimed at developing an online on-request courses coordination system that is of importance to an IT organization which has a training department of its own. The online on-request courses coordination system (ORS) is an Intranet based application that can be accessed throughout the organization or a specified group/Dept. This system can be used to automate the workflow of the requests that come from various departments for project specific trainings and their approvals. The training department has to cater to the training of the fresh recruits. It has a regular calendar and schedule to train the Freshers. In addition to this it has to handle the project specific training requests coming from various departments. For this the department has appointed one person as the on-request coordinator, who will be able to service the requests with help of ORS. The whole process starting from logging the request by a dept to servicing the request is automated. There are features like logging the request, to check the existing training calendar and checking the availability of respective faculties for the course, allocating the faculty for the course, if an internal faculty is not free during that period getting faculties from outside, report generators etc in this system.
Generic Technology keywords
Databases, Network and middleware, Programming
Specific Technology keywords
MS-SQL server, Visual basic 6.0
Project type keywords
Analysis, Design, Implementation, Testing, User Interface
Functional components of the project
Following is a list of functionalities of the system. More functionalities that you find appropriate can be added to this list. And, in places where the description of functionality is not adequate, you can make appropriate assumptions and proceed.
An IT organization has a training department of its own. The main job of the training department is to train the fresh recruits. It has a regular calendar and schedule to train the Freshers. In addition to this it has to handle the project specific training requests coming from various departments in the organization. To handle the on-request courses the department has appointed one person as the on-request coordinator, who takes care of servicing the requests. He/she has to collect the requests from various departments. Then he/she will check in the existing fresher training calendar whether a similar course is scheduled there in the given dates. If not he/she has to schedule it looking at the availability of faculties. If none of the internal faculties are free at that time, then he/she has to take the approval of the concerned department to get a faculty from outside.
1.A person from any department should be able to
login to the system through the first page of the application using the guest login
Enter the details of the course required in the form available. This form also captures the details like, name of the course, number of days, number participants, and background of the participants, dates on which the course needs to be conducted, mail id and name of the requestor. In addition, this form also takes a confirmation from the department whether it is ready to go for external faculties if none of the internal faculties are free. If a department accepts this then it has bear the cost to be paid to the external faculty.
If any fresher level course with the same course contents is scheduled during the same time he/she will be shown with details of those courses
He/She can opt to send his team for this course or if his/her request is very specific then he/she can submit his/her request.
Withdraw his/her course request (which has not been serviced yet)
Cancel his/her course request (which has been already been planned).
Get help about the system on how to use the different features of the system
2.As soon as a course request /withdrawal /cancellation is made by the person, an automatic email should be sent to the on-request coordinator giving details about the course request
3.The on-request coordinator has to log on to ORS using the admin id and check the list of courses which are to be serviced. Then he/she has to check the availability of faculties who can handle the specific course during the requested period. If a faculty is free during the period then he/she can be allocated to the course and a mail is sent to the faculty as well as the requestor regarding the course schedule. The status of the course is now set to “planned”. Once course is delivered to the required dept then the status is set to “serviced”
4.If none of the faculties are free during the period and if the department is willing, then the on-request coordinator can go ahead and arrange for external faculty.
5.A list of all the external faculties(Vendors) is available in the database, along with their contact details, courses offered previously , the feedback got etc., the on-request coordinator can refer to this list and schedule the course after getting in touch with the vendor.
Steps to start-off the project
The system is developed using Visual Basic as the front end and SQL Server as the back end.
The following steps will be helpful to start off the project.
1.Study and be comfortable with technologies such as
a.Visual Basic and SQL server.
Some links to these technologies are given in the ‘Guidelines and References’
Section of this document
2.Make a database of course, faculties and the courses they can handle. Also maintain the latest schedule for fresher training in the database. In addition the details of the vendors also needs to be maintained in the database
3.Have two logins to the system, the admin and guest. The admin login is used only by the on-request coordinator. Guest login is used by all the people in the organization to log the requests to ORS
4.Create the front-page of the ORS giving a brief description about the system and a login box
5.Create the help-pages of the system in the form of Q&A. This will help you also when implementing the system
6.Create other sub-systems like automatic notification, screens for various functions (like logging the request, to check the existing training calendar and checking the 0.availability of respective faculties for the course, allocating the faculty for the course, if an internal faculty is not free during that period getting faculties from outside, report generators etc)
Did you like this resource? Share it with your friends and show your love!
No responses found. Be the first to respond...
Return to Article Index
Active MembersTodayLast 7 Daysmore...