INTRODUCTION

 GENERAL : Office correspondence and auto questionnaire software’s are developed as per the requirements of the mechanical department.

OFFICE CORRESPONDENCE

Mechanical department deals with different type of letters. The letters which are received by the mechanical department are incoming letters and the letters which are sending through the department are the outgoing letters.

The different types of letters received and send by the mechanical department are as follows:

  • Local letters
  • Head quarters letters
  • Others


office correspondence

LOCAL LETTERS

The letters received from and send to other departments of Vijayawada division are termed as local letters.

INCOMING LOCAL LETTERS

The letters received from other departments of Vijayawada division are termed as incoming local letters.

OUTGOING LOCAL LETTERS

The letters send to other departments of Vijayawada division are termed as outgoing local letters.

HEAD QUARTER LETTERS

Secundrabad division is head quarters of the Vijayawada division. So the letters received from and send to secundrebad division are termed as head quarters letters.

INCOMING HEAD QUARTER LETTERS

The letters received from secundrebad division are termed as incoming head quarter Letter.

OUTGOING HEAD QUARTER LETTERS

The letters send to secundrebad division are termed as outgoing head quarters Letters.

OTHERS

The letters received from and send to the divisions other than Vijayawada and secundrebad are termed as other letters.

INCOMING OTHER LETTERS

The letters received from the divisions other than Vijayawada and secunderabad are termed as incoming other letters.

OUTGOING OTHER LETTERS

The letters send to the divisions other than Vijayawada and secundrebad are termed as outgoing other letters.

If the reply for the above letters is to be given immediately then those letters are marked as demi official letters.

So different types of demi official letters can be

  • Incoming Local demi official letter
  • Outgoing Local demi official letter
  • Incoming Head quarters demi official letters
  • Outgoing Head quarters demi official letters
  • Incoming Other demi official letters
  • Outgoing Other demi official letters

All the incoming letters are received by the chief office superintendent and are marked to different sections of the mechanical department with the authorized signature of the senior divisional mechanical engineer. Then the respective task is performed by section accordingly to the letter which is received by it and sends the reply to chief  office superintendent. Then the chief office superintendent with authorized signature of the senior divisional mechanical engineer sends the letter as outgoing letter.

Mechanical department consists of seven sections.

  • Contract/tenders
  • Carriage & wagon staff
  • General/pass
  • Rolling stock
  • Stores
  • Budget
  • Power

AUTO QUESTIONNAIRE

The test to avail the promotion is conducted for the employees of the vijayawda division. The question bank offered to the employees for preparation comprises of the following type of questions.

  • Long answers
  • Short answers
  • Fill in the blanks
  • Multiple choices
  • Expansions

auto questionnaire

STATEMENT OF THE PROBLEM 

OFFICE CORRESPONDENCE

To maintain the details of different types of letters, to show the status of the letter and also to generate the reports. 

AUTO QUESTIONNAIRE

To maintain the questions and to generate the questions randomly when appropriate type of question is selected.

EXISTING SYSTEM

OFFICE CORRESPONDENCE

In the existing system the details of the letter is being maintained manually by entering different types of letters in different books. To know the present status of the letter, it is very difficult in the existing system because one has to verify all the entries in that particular book. So it is time consuming. 

AUTO QUESTIONNAIRE

In the existing system question paper is set manually by selecting the type of questions from the printed question bank. It is very difficult and time consuming to set question paper manually because when selecting a question one has to verify whether it was previously given or not.  One has to tally the maximum marks for which paper was given and marks allotted for each question and he should also consider the choices for each type of question.

PROPOSED SYSTEM 

OFFICE CORRESPONDENCE

The proposed System is a web-based application. It maintains details of all the letters within the mechanical department. The present system shows the pending letters and reports. 

AUTO QUESTIONNAIRE

In the proposed system the question paper is set automatically by selecting random questions when appropriate number of question type is selected.

OBJECTIVES OF STUDY 

OFFICE CORRESPONDENCE

  • Automating the manual work.
  • To generate status of the letter
  • reminder  provision for pending letters

AUTO QUESTIONNAIRE

  • To generate the question paper quickly from the available database.         

REQUIREMENT ANALYSIS   

FUNCTIONAL REQUIREMENTS

OFFICE CORRESPONDENCE

  • The user can add the details of all the letters into the database and view the pending letters.
  • The authorized user can edit the details of the letters and delete the letters from the database.

AUTO QUESTIONNAIRE

  • The authorized person can add, delete and update the questions in the database.

SYSTEM DESIGN SPECIFICATION 

SOFTWARE REQUIREMENTS

Operating system                   :           Windows XP professional

Programming Language      :           JAVA

Web Technology                   :           J2EE (JDBC, Servlets, JSP, HTML)

Browser                                  :           Internet Explorer

Web application server         :           Apache Tomcat

Model Design                         :           Rational rose

IDE                                         :           Net Beans 6.7.1

Data Base                               :           Oracle 10g, MS Access. 

HARDWARE REQUIREMENTS

Processor                                :           Intel p4

RAM                                      :           256MB RAM

Hard disk                               :           20GB or more

Required Software’s:

  • Oracle 9i
  • Java
  • Netbeans 6.7.1
  • Mozilla Firefox

Instructions to Deploy:

1. Install the required software’s
2. Open Netbeans and open the project from source code
3. Configure database connections from DBConn package of Source Packages under the root PPO & Technical
4. Right click on CreateTab.java under Test Packages under the root PPO & Technical and click on run
5. Right click on root and click on run

Note: In case of reference problems right click on root and click on resolve reference problems, and select the library files.