Hello Logout
 

Projects

Development of a feature-rich, practical online application for the Training and Placement Dept. of the college.

 

Title of the project

 

Development of a feature-rich, practical online application for the Training and Placement Dept. of the college.

 

Abstract of the project

 

This project is aimed at developing an online application for the Training and Placement Dept. of the college. The system is an online application that can be accessed throughout the organisation and outside as well with proper login provided. This system can be used as an application for the TPO of the college to manage the student information with regards to placement. Students logging should be able to upload their information in the form of a CV. Visitors/Company representatives logging in may also access/search any information put up by Students.

 

Keywords

 

Generic Technology keywords

 

Databases, Network and middleware, Programming

 

Specific Technology keywords

 

MS-SQL server, HTML, Active Server Pages. Servlets, JSPs

 

Unix, Shell, C, Oracle

 

Project type keywords

 

Analysis, Design, Implementation, Testing, User Interface

 

Functional components of the project

 

Following is a list of functionalities of the system. More functionality 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.

 

  1. A person should be able to

 

  • Access/ Search CVs/information from the first page (only read access).

 

  • login to the system through the first page of the application

 

  • change the password after logging into the system

 

  • Upload his/her CV.

 

  • See/change his/her details.

 

  • Get help about the application on how to use the different features of the system.

 

  1. An admin login should be present who can read as well as remove any uploads. Preferably it should be given to the TPO.

 

Steps to start-off the project

 

There are couple of alternatives to implement such a system.

 

A. Microsoft platform: The system is developed using Active Server Pages as the

     front end and SQL Server as the back end.

 

B. Unix-based platform: HTML or even Shell scripting, C programming, any  

     Relational database (eg Postgress or Oracle or even flat files), and tools in

                 UNIX

 

The following steps will be helpful to start off the project.

 

  1. Study and be comfortable with technologies such as
    1. Active Server Pages/HTML and SQL server.
    2. UNIX commands, Shell programming, C Programming, Tools like AWK etc.

            Some links to these technologies are given in the ‘Guidelines and References’ 

            Section of this document

 

  1. Decide on categories of  CVs uploaded (i.e.,  for the different types of companies in IT, Computers, Electronics, Electrical, Mechanical, Civil, etc) and define it formally.

 

  1. Make a database for storing the CVs.

 

  1. Create the front-page of the system giving a brief description about the system and a login box

 

  1. Create the help-pages of the system in the form of Q&A. This will help you also when implementing the system

 

  1. You may create other sub-systems like automatic notification, screens for various events. Like some companies visiting the campus for placements. Statistics of the previous year’s placements. Current Placement secnario.
  2. A role of approver can also be introduced. When the student uploads his/her CV, the approver should approve the document and only then can it be uploaded. (Make appropriate assumptions).

 

  1. Templates could be provided to students who do not have a copy of their CV ready with them.

 

Requirements

 

Hardware requirements

 

Number

Description

Alternatives (If available)

1

PC with 2 GB hard-disk and 256 MB RAM

Not-Applicable

2

 

 

 

Software requirements

 

Number

Description

Alternatives (If available)

1

Windows 95/98/XP with MS-office

Not Applicable

2

MS-SQL server

MS-Access

3

Linux

Not Applicable

4

Oracle database system

POSTgres

 

Manpower requirements

 

2 to 3 students can complete this in 4 – 6 months if they work fulltime on it.

 

Milestones and Timelines

 

Number

Milestone Name

Milestone Description

 

 

Timeline

 

Week no. 

from the start

of the project

Remarks

 

 

1

Requirements Specification

Complete specification of the system (with appropriate assumptions) including the framing of policy etc constitutes this milestone (a detailed functionality of the system). A document detailing the same should be written and a presentation on that be made.

2-3

Attempt should be made to add some more relevant functionality other than those that are listed in this document.

2

Technology familiarization

Understanding of the technology needed to implement the project.

4-5

The presentation should be from the point of view of being able to apply it to the project, rather than from a theoretical perspective.

3

Database creation

A database to store the CVs of the students should be created. And, at least 100 entries of CVs from students of different disciplines should be created.

5-7

It is important to finalize on the database at this stage itself so that development and testing can proceed with the actual database itself.

 

A database admin needs to be identified at this stage.

4

High-level and Detailed  Design

Listing down all possible scenarios (like upload request, approval, rejection, modification, searching the CVs etc) and then coming up with flow-charts or pseudo code to handle the scenario.

7-9

The scenarios should map to the requirement specification (i.e., for each requirement that is specified, a corresponding scenario should be there).

5

Implementation of the front-end of the system

Implementation of the main screen giving the login, screen that follows the login giving various options, screens for each of the options (CV upload form, CV approval form, CV search form etc).

10-12

During this milestone period, it would be a good idea for the team (or one person from the team) to start working on a test-plan for the entire system. This test-plan can be updated as and when new scenarios come to mind.

6

Integrating the front-end with the database

The front-end developed in the earlier milestone will now be able to update the database. Other features like notification etc should be functional at this stage. In short, the system should be ready for integration testing.

12-13

 

7

Integration Testing

The system should be thoroughly tested by running all the test cases written for the system (from milestone 5).

14-15

Another 2 weeks should be there to handle any issues found during testing of the system. After that, the final demo can be arranged.

8

Final Review

Issues found during the previous milestone are fixed and the system is ready for the final review.

16-18

During the final review of the project, it should be checked that all the requirements specified during milestone number 1 are fulfilled (or appropriate reasons given for not fulfilling the same)

 

Guidelines and References

 

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnasp/html/asptutorial.asp (ASP tutorial)

 

http://www.functionx.com/sqlserver/ (SQL-server tutorial)

 

http://heather.cs.ucdavis.edu/~matloff/UnixAndC/Unix/CShellII.html (Shell script introduction)



Tags :
0
Your rating: None