Online Examination System Final Year Project Database

Online Examination System Final Year Project developed by VB & MS Access Database, These are the below database tables used in this project.

TABLE NAME: muserinfo

PURPOSE: This table is used to store user details                                  

FIELD NAME

DATA TYPE

Loginid

Text

Password

Text

Firstname

Text

          Lostname

Text

         Birthdate

Text

          Gender

Text

Occupation

Text

TABLE NAME: madmininfo

PURPOSE: This table is used to store administration details                                  

FIELD NAME

DATA TYPE

Adminid

Text

Adminpw

Text

TABLE NAME: mquestions

PURPOSE: This table is used to store questions details                                  

FIELD NAME

DATA TYPE

           Lang

Text

Questype

Text

           Quesno

Number

Question

Text

           Choice1

Text

           Choice2

Text

           Choice3

Text

           Choice4

Text

           Choice5

Text

          Answer

Text

TABLE NAME: msubinfo

PURPOSE: This table is used to store subject details                                  

FIELD NAME

DATA TYPE

Sub_code

Text

Sub_title

Text

Download Online Examination System Final Year Project Database

Useful Links:

Online Examination System Project in Java

Online Examination System Project in Asp.net

 A computerized model for conducting tests called Online Examination system is developed for Schools & Colleges to facilitate in conducting online tests.

This System helps the User to log into the application whenever he desires and evaluates the results immediately. This Final Year Engineering Project is developed in ASP.Net.

The application is very flexible and user friendly. There is no need to monitor while a person is taking the exam. All the instructions are displayed to the user before he takes the test.

online-exam-projectThe application is developed in Java and all the features of Java are used in it. It can be made global through Internet thus enabling the person even in the remotest part of the world in assessing his knowledge.

Software Requirements:

Visual Studio, HTML, Java Script, ASP.Net, SQL

Download Online Examination System Final Year Project in Asp.net

Online Exam Project in Java

The Online Exam Project is developed in Java, it is divided into two main parts.They are

  • Users
  • Administration

Users:

This module is mainly concentrated on handling the examination activities. The module begins by offering entry to already registered users or even fresh users can also register the moment they desire to attempt the Examination. This is achieved by the Login form and Sign Up.These are designed in a very interactive form.

After registering, a candidate will be supervised by the rules and regulations of the examination. i.e. the instructions to be followed for facing the examination be given, namely duration of exam, Number of questions, marks for each Question, Maximum marks,etc.,

The next moment, the candidate be allowed to select the choice of subject of examination. The candidate is given the question paper of the selected Subject. The paper should be answered by checking the check boxes or Radio Buttons depending upon the question.

The evaluation of the paper will be carried for the question that is answered in the meantime. The total marks obtained will be displayed and the percentage will be calculated for the total number of questions.

Administration:

The administration module consists of maintaining components of the examination. The components namely

  • Subject of Examination
  • Questions of Subject.

The Subject of examination can be accessed for alteration. i.e. Addition of a Subject, Updation of a subject, Deletion of a Subject and Listing of the Subject of Examination.

The Questions of examination can also be accessed and altered by performing the following operations.i.e

  • Addition of Questions
  • Updation of Questions
  • Deletion of Questions

In the Administration, the system is efficiently maintained by deleting the users who already completed the examination. This is carried out for a period to period.

The system is mainly coded by viewing the user from all angles so that no problems are arisen  in using the system

Online Examination System Project

The Online Examination System Project application is developed for Engineering Colleges. 1000projects is a 100% export oriented scheme for development and export of final Year Projects.

This is started to promote projects by helping Final Year students in terms of providing high-speed satellite links, giving all required government clearances at a single point.

There is always a rising need to conduct tests to assess a person’s knowledge in a subject. As the number of people taking the test is increasing it is becoming difficult to manually evaluate the results, hence the system was developed. 

This was specifically developed to make it available globally on the Internet.

The system developed is designed such that it enables all the interested people to take the test irrespective of the time. Whenever the User finds free times he can use the Online Exam and assess his depth of knowledge.

The application starts by accessing the User name and Password form the User and allows the User to select a subject in which he desires to take the exam. 

After selecting the subject in which he desires to take the exam. After selecting the subject the instructions regarding the Time limit, Total marks, Qualifying marks, and percentages are displayed.

Only if he accepts to the terms and regulations, Questions screen is displayed to the User and is also represented in Graphics in order to give a clear picture to the User.

The system is interactive and user-friendly. The system is developed using Java, AWT, Applets, Servlets, JDBC, HTML, & MS-Access.

Final Project Report on Power Billing System

Final Project Report on Power Billing System Modules Description:

Login

This module is considered only when there is a requirement of safety and security by the customer. Only after the login process, the rest of the application is made available to the user. 

In order to log in, the user has to first register by providing desired user-ID and password. Provided user-IDs and passwords by the users are maintained in a database. Oracle database is used to maintain a database.

Then the user logins into the application by giving user-ID and password provided during registration process. JDBC is used to connect the application with the database.

 User Login Sequence will be as follows:

  • User registration by providing user-ID and password(credentials)
  •  The user will be prompted to enter user credentials.
  •  If the user enters correct credentials then he gets access to the application.

 Consumer Management

To design front-end forms according to consumer specifications it was like Addition of new consumer, deletion, modification of consumer, processing bills, journals, debit respectively. This module deals with consumer information details.

 New Consumer Acquisition

The proposed software allows the end user to add the new consumer with his personal service (meter and Deposit) details. It generates a unique consumer Identification number based on the DISCOM, Circle, and division, Subdivision, Section and Distribution to which he belongs.

 Modification of Consumer

If any particulars have modified with consumer details, this sub-module is used to modify the consumer details.

Deletion of consumer

If any consumer disconnects the connection then we have to delete the consumer related information from the system. This module is used to delete the consumer. Deletion is made is based on some rules like the payment details will be nil.

Message is displayed as do you want to delete the record.  This deleting record is first entered into watch table. Then this record is deleted from Cons table, Bill, Meter part, deposit tab, calculator and PMTTAT tables.

Query Consumer

When ever we need to see the details of any particular consumer then this sub module will invoke the details and will display on the screen.

Meter Change

Every consumer is having meter for reading details. If meter will change then the meter details will be change in database. This sub module is used to update meter details.

Meter part Change

If any changes occurred in meter particulars then this sub module is used to update. The difference between Meter Change and Meter part Change is when ever Meter will change Meter Change sub module will use and Meter will not Change but Meter Characteristics will change then Meter part sub module will use.

Online Receipt

This sub module is user to online bill payment receipts. It will provide the entry fields to accept payments. It will show the consumer bill details and based on that we will know the bill details which were belongs to consumer whether consumer is having arrears or not. It is done on the spot when the consumer comes to pay bill. This is used by the persons, who know the RC (Revenue Collection) password.

Offline Receipt

This sub module is user to offline bill payment receipts. It is also same as online receipts, but it is used when consumers will pay the bill at general counters. It will show the consumer bill details and based on that we will know the bill details which were belongs to consumer whether consumer is having arrears or not. It is done after the consumer paid the bills offline. This is used by the persons, who know the RC (Revenue Collection) password.

Receipt Cancel

This sub module is allows the user to correct the mistakes done in using online receipt and offline receipt. It will provide the entry fields to cancel the payment receipts only. It will show the receipt details, which was done still by particular RC Counter. This is used by the persons, who know the RC (Revenue Collection) password.

Billing & Accounting

Journal Entry

Journal entry done when a consumer had any debit, credit amounts to pay .To that bill if any additional charges, electricity duty, interest on electricity duty levied on particular consumer no.

In this lccode should present in journal. If we enter consumer no corresponding name should be displayed and rest of the fields we should enter.

It should be updated to Journal.

Cancellation of Journal

If we want to cancel that particular person cancels any journal. It should check LC code, voucher number should match LC code, voucher date should match LC code, voucher no and then date field is selected. Then fields we are selected into corresponding text boxes. This journal is cancelled with field Jtcancelid+=y. Now the field is cancelled from journal.

Change RC Password

Every ERO is having RC Counters to receive online payments. Each RC Counter is hiving RC Code and RC Password. This sub module is allows the user to change his Password for security purpose.

Security requirementsUsers are provided with a login page which contains a user-ID field and a password field. Users are requested to register before using the application. Then, the registered user is asked to provide the password and log-in user-ID in order to access the tool. This ensures security by allowing only authorized users.

Power Billing System Project Report

            The Power Billing System Project Report basically deals with the billing system. Since it’s a web application the problems of single tier could be solved using this application. Customers can lodge a complaint or deal with new connections just by logging into the system.

             The application basically starts by asking the user to sign in by choosing the CIRCLE ID and ERO ID. Later username and password of the employee option is provided. Validating the username and password, the user is directed to the homepage were in he has various options like consumer management, revenue collection,  billing and accounting, generating the report. Regarding the modification, constraint is provided wherein the access is limited to the administrator. The statuses of the requests are updated at the earliest. The rectification information will be again updated for the knowledge of the employee. The employee can check the status of the requests before accessing the computer, which will speed up the disposal of the request. Thus, improving the overall efficiency of the organization.

Scope:

             This application is basically written as a solution to the drawbacks of existing system. This application can be used as a real world application and by any organization. It’s could be used as a general application with few minor modifications.

Purpose:

                        The purpose of this application is to develop “EBS”  (Electronic Billing System), which is a web application which provides a service to all the customers and employees of A.P.S.E.B to deal with the transactions online.

             The company is presently dealing with the transactions using Oracle.  The problem with D2K is that there exists heavy network traffic either in two tier or three tier architecture. Here the cost to develop the project will be less but the reliability will be degraded. Thus this application provides a solution to problems of single tier. Customers can lodge a complaint or deal with new connections just by logging into the system and do the transactions online.

Power Billing System Project ReportProblem & Existing technology:

             In the traditional system files were used to maintain the database which was done manually. This existing system consumes a lot of time. This time consuming evaluation coupled by the huge maintenance problem and may also lead to erroneous results. The various operations performed on these files like sorting, adding, modifying and deletion of the records are very tedious. Moreover these manually maintained files have the possibility of getting worn out. Thus, less durability is achieved.

 Thus the demerits of the existing system can be summarized as follows…

  • There is no consistency as the data may not be updated on time.
  •  Feasibility is reduced
  •  Less reliability
  •  Security is not provided and any one can access
  •  Prioritization of records is difficult.
  •  More erroneous
  •  Difficult to maintain
  •  As every thing is done manually its slow process
  •  No timely acknowledgement service

             Taking the demerits into consideration, an alternative system which uses Oracle as both front end and back end was used. In front end, retrieval of the data from the database is done through SQL queries i.e using D2K forms. This is not a web application and the data is not distributed as only a single system is used. As it is confined only to a particular system, scope is limited and there is a hindrance to the reliability if the system fails.

The demerits of this alternate system are…

  •        Only single system used.
  •        If the system crashes then the data is lost
  •        too overburdened
  •        not reliable
  •       slow processing
  •       less flexible
  •       not so user friendly

Proposed system

             The proposed system is developed based on the client server architecture,  a request-response paradigm and is implemented with the help of advanced java using the tomcat web container. The employees can maintain and do the transactions online.

             The application starts by asking for user name and password which provides authentication. This system provides high security where the unauthorized users cannot access the data.

 Later we have different options for the employee like

  •  Consumer Management
  •  Revenue Collection
  •  Billing and Accounting
  •  Reports
  • Meter Details
  • Ledger Process
  • Journal Details

The objectives of the proposed system are as follows:

  •   Easy to use, effective and efficient
  •   Accurate results.
  •   Easy maintenance.
  •    Fast access
  •    More feasibility
  •    More secure.
  •    Provides high consistency.
  •    More reliable

Employee Attendance Monitoring System Project

Finally, after the code is implemented the result is analyzed. According to this project “Employee Attendance Monitoring System,” the result can be analyzed in a very efficient way.

This is done supposing, when an employee logs into the website, he then gets a home page that is a login page which includes a welcome form, admin form, add form, and update form for updating details, delete the form, and finally the reports.

The welcome form gives the date, task, and hours of an employee. Admin form is only for the administrator who can update the employee details. Add form is used for updating or giving the login and password about the employees.

The updated form is used for updating the new details. Delete form is used to delete the employee and finally the report is used for giving the report of a particular employee giving the aspects like efficiency, his working hours, and the capacity to finish the work in time.

The output screens give a clear view of the result that has been analyzed.

The above-stated forms played and the update form can be used only by the administrator.

The implementation and results of the Employee Attendance Monitoring System project have been mentioned above in detail with the help of screenshots and database tables. Thus in the conclusion, we have proved that the project is implemented and all possible screens have been displayed. 

The web-based time tracking system is a web-based application that is used to give detailed working hours and helps the management in determining the efficiency of an employee.

Thus in the conclusion, the implementation and results phases give us the details about the preparation of the data sheets of an individual employee’s working hours. The resultant outputs are also displayed in the above screenshots.

Employee Tracking System Project in Java

Here in this Employee Tracking System Project in Java the employees when enter in to an organization he starts working on a project or starts doing his task then he gives his detailed time to time work he has done on that particular day to the administrator who in turn prepare the reports of a particular employee and then submits to the project manager, then he analyzes the capability of an employee and he will finally prepare the final reports which include the aspects of an employee are as follows:

1.  The reports will give the significant amount of time and effort invested by the employees time to time, by helping the management to know about their employee’s capability.

2. The employee can immediately know his capacity and the working hours weekly once or when the task allotted to him is finished.

3.  Achievement/target report employee wise.

4. Performance indicator for an employee.

5. Determining the efficiency and the task completed by the employee

   Finally I conclude that this project plays an important role in tracking the timings of the employee and how much time he is working and the entry time and exit time   when a employee cross the gate number of times. And maintain like a small database about the timings of the employee.

              Employee Tracking System Project in Java The developed employee reimbursement system project has been successful in automating all the functions of employees and various departments of 1000Projects Software Solutions. The proposed system has helped the department to reduce its time spent on various data maintenance tasks, reduced the time spent in report generation, and helped it in providing better and user friendly services to its employees.

  The produced System also provided various metrics to analyze the employee performances to the department. It helped the department to dynamically add questions to the database. It provided a mechanism through which the administrator can save the existing database to file about the performance of an employee.

              The management is now able to select best employees in a better and efficient way and judge the employees in a better way

Online Web Based Project Management and Tracking Project

Online Web Based Project Management and Tracking Project plays an important role in tracking the timings of the employee and how much time he is working and the entry time and exit time   when a employee cross the gate number of times. And maintain like a small database about the timings of the employee.

The developed Online Web Based Project management system  has been successful in automating all the functions of employees and various departments of  Spoorti Software Solutions the proposed system has helped the department to reduce its time spent on various data maintenance tasks, reduced the time spent in report generation, and helped it in providing better and user friendly services to its employees.

The System also provided various metrics to analyze the employee performances to the department. It helped the department to dynamically add questions to the database.

It provided a mechanism through which the administrator can save the existing database to file about the performance of an employee.

The management is now able to select best employees in a better and efficient way and judge the employees in a better way.

FUTURE ENHANCEMENT:

  • Development of application in public IT.
  • Addition of some more categories
  • Globalization of Site

Globalization of Site:

We may globalize the site.

Addition of some more categories:

Addition of some more new categories may take place.

Web Based Time Tracking System Project

              The web based time tracking system Final Year Project will automate the activities of the employees working in various departments of 1000 Projects  Soft Solutions private Limited. The project will implement a system, which will be plugged into the “1000Projects” network of the 1000 Projects Soft Solutions. The main tasks of the proposed system are:

  •     To register the employee targets and detailed working hours of particular employee.
  •     To register the employee job responsibilities.
  •     To register the work done by the individual employee.
  •     To verify the achievements made by the individual one.
  •     To verify the deviations made.
  •     To perform the rating of the employee in particular organization.

To generate reports for an individual employee:

   a) Comparative achievements and deviations report.

   b) Comparative performance grade wise report.

   c) Achievement/target report employee wise.

   d) Rejections and rework report.

   e) Responsibilities/ achievements report.

   f) Performance indicator report.

The inputs to the system are from varied quarters. The system has three types of users. They are the

  • The employee
  • The administrator
  • The project manager
  • The organization

The employee is the one who works in the organization he enters the office at starting time and he gives his work sheets to an administrator at the time of leaving and in that work sheet he should give accountability to every minute .

The Administrator maintains the employee information, operates the database, sets, and he can add, update, and delete the employee details. And he checks the work sheet given by the employee rechecks it and prepares reports and submits to the project manager.

The project manager verifies the reports and decides weather a particular employee is working properly on project and the time taken by the employee to finish the task then he can correct the employee when there are any corrections in completing the task.

The organization is the place where all the employees work and finally it determines the employee efficiency.  

Motivation                

Presently in the existing system, normally in a company, employees enter the office at different times. To administer the timings of the employees, we write the entry time and exit time of the employees in a register, which had some problems such as, a person can cross the door multiple times which cannot be monitored, and not only that, this existing system cannot absolutely tell the authorities the individual working hours and capability of an employee.                  

The proposed system will help the administrator or the manager to reduce its time spent on various data maintenance tasks, reduce time spent in report generation, and help it in providing better and user friendly services to its employees.

The important features of functionality of the proposed system are listed below

  • The proposed system will give the significant amount of time and effort invested by the employees time to time, by helping the management to know about their employee’s capability.
  • The System also provides various metrics to analyze the performances of the employees to the department.
  • It helps the management to dynamically add questions to the database.
    • It provides a mechanism through which the administrator can save the existing database to   file.
    • The employee can immediately know his capacity and the working hours weekly once or when the task allotted to him is finished.
    • The project leader or the management generates desired reports.
      • The system will be plugged into the network of spoorti software solutions. This means that the system will be available to the administrator for use at any time, anywhere in the company.                  

         The system will be developed in a modular fashion and will be well documented. This facilitates new modules and functionality to be added without much unwarranted effort and troubles.

Problem definition

 In the manual system the staff productivity and the performance they exhibit are maintained in the records. In the organizations with many departments, each department having many employees working, it is difficult if the data regarding the employee performance is maintained manually. There may be a lot of time delay in order to retrieve any information regarding the employee performance. If the data is maintained in the records the comparisons between the employees regarding their achievements may become difficult. The duplication of the data may be seen since the data is maintained in many books for each department. Since the data has to be maintained in the registers the organization has to maintain many records.

The reports have to be generated manually and the collection of the data for the reports is a difficult process. The enquiry for a certain data regarding a particular employee is difficult, as they have to refer to the books and judge.

              If the information is maintained using a computer the services may improve. The data can be dealt more effectively and efficiently. The time taken to retrieve any data regarding the employee performance is easy using the system. The evaluation of the employee is easy by his rating stored in the system. The comparisons of the employees at the same level in each department are easy. At any given time we can also get the pending activities. The organization can evaluate the department wise performance in a better way. Since the reports are generated periodically the expertise of each employee can be judged.                   

               For the development of an organization it sees that the employees are working properly and completing the tasks properly or not and how much time they are spending on a particular project to determine the efficiency of an employee.                  

               The 1000 Projects Software Solutions recognized the need to create a system, which is more efficient than the current one. It needed a system, which will help it in its commitment to select value added and efficient employees for the company. The company is also currently in the process of acquiring a more efficient employees. This project is also aimed at helping spoorti software solutions the rating by automating its activities, which is an important requirement towards this end.                  

 Keeping the above points in view the management decided to automate all its activities and select the best employees in a better way. It also helps in keeping tasks for the department, which could now rededicate itself to providing better services and value addition to the company.

Objective of a Project

                 1000 Projects  Software Solutions requires an efficient system, which will record the activities of employees automatically. The proposed system will help the administrator or the manager to reduce its time spent on various data maintenance tasks, reduce time spent in report generation, and help it in providing better and user friendly services to its employees.

The Objectives:

  1. To register the employee targets and detailed working hours of a particular employee.
  2. To register the employee job responsibilities.
  3. To register the work done by the individual employee.
  4. To verify the achievements made by the individual one.
  5. To verify the deviations made.
  6. To perform the rating of the employee in a particular organization.
  7. To generate reports for an individual employee:

          a) Comparative achievements and deviations report.

          b) Comparative performance grade wise report.

          c) Achievement/target report employee wise.

d)   Rejections and rework report.

          e) Responsibilities/ achievements report.

f) Performance indicator report.

Limitations of a Project

                        This Computer Science Mini Project has no limitations because, this project is developed in a java platform (jsp Technology) and it is platform independent. The major limitation of the project is now it is running inside the company and employees can access this application in side the work area of the company. We need to make this Application in the Web so that employees can access the forms from anywhere through Internet.