Online examination management system project abstract

1. Introduction

This Software Requirements Specification (SRS) document describes the requirements of Online Answer sheet Evaluation System. The document describes the issues related to the system and what actions are to be performed by the development team in order to come up with a better solution. The Main objective of the project is to enhance transparency, accountability, reliability and efficiency in the whole evaluation process.

1.1 Purpose

The purpose of this document is to provide a detailed description of the‘Online Examination System’. This SRS will allow for a complete understanding of the ‘Online Examination Management System’ to be constructed. The main purpose of ‘Online Examination Management System’ is to reduce the manual operation required to evaluate and maintain answer sheets of students.

This is a database project which covers every aspect involved in conducting examinations in a school, college or university. As concerned to scope of the product, answer sheet evaluation is an essential element for educational organizations. The product will avoid the burden of hard copy storage. It will also provide data security as we are using the secured databases for maintaining the documents. We can also conserve the time and human resources for doing the same task. The data can be maintained for longer period with no loss of data.

1.2 Scope

The software product to be produced “Online Examination Management System” which will allow online examination-evaluation and Offline examination-Online evaluation . The system is designed in favor of the universities which help them to save the answer papers and other information about the examination. It helps them from the manual work for which it is very difficult to distribute the answer sheets of the students to evaluators and the evaluators don’t need to go to the evaluation centers or to carry the papers to home. It reduces the errors in summation of the marks. The “Online Examination Management System” supposes to have the following features:

● The system is designed to handle the activities of the exam controller,Chief examiner evaluators, and the students.

● The system will have the ability to manage

-Examination registration by the student

-Online Examination and its Online evaluation by the evaluators

-Online Evaluation of offline exams

-Answer paper uploading

-Result publishing.

● The system will have the ability to send alerts to the teachers for the evaluation of answer papers.

● The system will allow the teachers to give subject preferences.

1.4 References

1. Software Engineering –A Practitioner’s Approach by Roger S Pressman

2. Open source web development with LAMP by James lee and Brent ware Addison Wesley/Person Education Inc.2003

3. http://homepages.dcc.ufmg.br/~rodolfo/es-1-03/IEEE-Std-830-1998.pdf

2. General Description

It describes the general factors that affect the product and its requirements. This section does not state specific requirements. Instead it provides a background for those requirements, which are defined in section 3, and makes them easier to understand.

2.1 Product Perspective

Examination and Answer sheet evaluation is an essential concern of every educational organization. The ‘Online Examination Management System’ allows the universities to manage online and offline examinations, answer sheet evaluations, get evaluators subject preferences, allot and inform evaluators to evaluate the answer papers of the students, publishing the results with much less time . The students of a university can be recognized from their registration number. ‘Online Examination Management System’ is a web based application.

2.2 Product Functions

The objective is to build a software system that is user friendly and accurately generates and stores data that assists examination and answer paper evaluation. The software system should be convenient for evaluators. The aim of proposed system is to develop a system with improved facilities. The proposed system allows the university to choose offline/online exams for particular courses. For the online examinations, students can login to the system using login ID and password at the time of examination. The answer scripts of each student will be stored in the database. In the case of offline exams, store scanned versions of answer sheets will be stored in the database. Information such as university register number, question paper, and the answer key are also stored on the database. The answer sheets are encrypted using md5 encryption technique to prevent unauthorized access. Therefore an intruder will see the encrypted answer sheets as a meaningless data. Also the register numbers of the answer sheets and answer scripts are encrypted so that the identity of the student is not revealed to the evaluator. It displays error messages if an answer has not been unevaluated or more marks are given in the mark sheet than prescribed. The evaluator checks the answer scripts or answer sheet by comparing it with the answer key. The system generates a mark sheet by tabulating the marks given by the evaluator in the answer scripts of the semester examination and the marks allotted to the student in the internal assessment. However, the marks of the internals are not visible to the evaluator as it may prejudice him while he evaluates the semester answer scripts. Chief examiner can do a random evaluation of answer sheets.The chief examiner finalizes the marks for each paper. He also can check who evaluated the paper and ask for explanation if required or assign another teacher for revaluation. Since the answer scripts are protected from downloading and editing the documents, nobody can tamper with them. It can help in announcing results much earlier as the manual effort is reduced. 

2.3 User Characteristics

The users of the system are:

· Administrator

The administrator is assumed to be have good data management skills and have access to all the data within the system. Administrator can add users.

· Faculty

Faculty can contribute to the question bank by selecting a question pattern.

· Exam Controller

Exam Controller will have access to all examination data fields, but will have limited access to user and privilege data information.

· Evaluators/Teachers

Evaluators will only be able to view answer scripts or sheets and assign marks for them. They are not able to edit or remove any information within the system.

· Students

Students who applied for the scrutiny are allowed to see the answer sheet and they can see the results of examination.

· Chief examiner

Chief examiner will have access to the answer sheets of particular subjects to verify the results.

2.4 User Documentation

The end users of ‘Online Examination Management System’ will be provide a user’s manual for the administrator, exam controllers, chief examiner and evaluators. To assist the user in understanding the product better and to assist them in better utilization of the product and its features, we will be providing an interactive user interface (in DOC format). We also will be giving details to the users where they can understand different features of the system

2.5 Assumptions and Dependencies

We are assuming that the users will not use our product to download copyright. Also, we expect that the users not only use the software to view resources, they will also be updating details and resources for being viewed by other users. We also assume that product users will not do malicious activities on the software.

Stored Procedures in MySQL with example

Stored procedures can is an efficient mechanism to provide code re usability.  MySQL Stored procedures can be used as an API which can be used from different programming languages. Below is an example of a MySQL stored procedure, which selects the values from a table named flowers by taking the id as argument.

DELIMITER //

CREATE PROCEDURE flower_list

(fid int)

BEGIN

  select id, name from flowers where id=fid;

END //

DELIMITER ;

Here we specify a double slash (//) as the delimiter while the procedure is being defined, so that the default delimiter (;) in the procedure definition, can be passed through the server.

The procedure can be executed from MySQL command prompt as well as from MySQL workbench by using the call function along with the argument value for id. This can also be called from triggers, other procedures and also from various application programmers. Recursive call from the same procedure is also possible. Below is an example call to this procedure.

call flower_list(101);

This will return the row from flowers table where id equals 1.

Parameters in MySQL stored procedure

There can be three types of parameters in MySQL stored procedures namely IN, OUT and INOUT.

The default parameter mode is IN. The IN parameter requires that the procedure call must pass an input parameter. The value of out parameter is passed back to the calling program and also its value can be changed inside the stored procedure. The INOUT parameter specifies that the calling program must pass the input parameter to the procedure, its value can be changed inside the procedure and pass the value back to the calling program.

Below is an example MySQL stored procedure with IN and OUT parameters.

DELIMITER //

CREATE PROCEDURE flower_list

(in fid int, out fname varchar(50))

BEGIN

  select name into fname from flowers where id=fid;

END //

DELIMITER ;

This MySQL stored procedure can be executed by invoking the call function with in and out parameter as shown below.

call flower_list(102, @fnames);

select @fnames;

Centralized Student Allotment Process Project Abstract

1. INTRODUCTION 

 

The CENTRALIZED STUDENT ALLOTMENT PROCESS (CSAP) is a Software Project with the main objective to create an automated admission processing system for all engineering programs at various colleges conducting those programs.. The following subsections of the Software Requirements Specifications (SRS) document provide an overview of the entire CENTRALIZED STUDENT ALLOTMENT PROCESS.

1.1 Purpose

 

The Software Requirements Specification (SRS) describes the functions and detailed description of the requirements for the CENTRALIZED STUDENT ALLOTMENT PROCESS (CSAP). This SRS will allow for a complete understanding of what is to be expected of the CSAP to be constructed. The clear understanding of the CSAP and it’s functionality will allow for the correct software to be developed for the end user and will be used for the development of the future stages of the project. This SRS will provide the foundation for the project. From this SRS, the CSAP can be designed, constructed, and finally tested.

The purpose of the SRS document is to describe the external behavior of the CSAP system. Requirements Specification defines and describes the operations, interfaces, performance and quality assurance requirements of the centralized allotment process system. The document also describes the non-functional requirements such as user interfaces and the design constraints. The SRS captures the complete requirements for the system.

1.2 Scope

 

As concerned to scopes of the project, it will automate the admission process and various operations involved in it. The system is designed for the allocation of seats for various engineering programs in various colleges, which help the students as well as the colleges to do the admission process easily within less time and human effort. The product will avoid the burden of the manual operation required to maintain all the records of Colleges and Students. It will also provide data security as we are using the secured database for maintaining documents. We can also conserve time and human resources for doing the same task. The data can be maintained for longer period with no loss of data. Its other factors are cost cutting, operational efficiency, consist view of data and integration with other institutions. Main challenges are effectively sync internal and external operations in such a manner that job can be finished within time limit and integration with different agencies on an agreed upon common data format.

The main reason for choosing this topic is to reduce the time and complexity of maintaining the records and also to easily perform the task of book keeping. It also helps in accurate maintenance admission details which can be referenced by students in later years.

Following are some of the scopes of the proposed system :

 

A single application will be sufficient for applying to different colleges/programs. · This system reduces considerable amount of paper work in the manual admission procedure. · Can be used to maintain admission details which can be referenced by students in later years. · It overcomes all the human biases in the admission process. The system provides security through password authentication and use of secured Database.

1.3 Definitions, Acronyms and Abbreviations

 

CSAP : CENTRALIZED STUDENT ALLOTMENT PROCESS
Administrator : Authority of the system who manage all the things
Registered candidate : The user who registered in the system for the admission process.
End users : Normal user who visit the system to understand about the procedures of CSAP
Colleges : Colleges which comes under the system of Centralized Allotment Process
Database : Collection of all the information monitored by this system.

1.4 References

 

· Software Engineering –A Practitioner’s Approach by Roger S Pressman
· Fundamentals of Database systems by Ramez Elmasri and Shamkant B.Navathe
· http://www.iitd.ernet.in/jee/
· IEEE SRS Format