

















Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
Automated Question Paper Generator of news paper online
Typology: Essays (university)
1 / 25
This page cannot be seen from the preview
Don't miss anything!
By MARSH VISHAL LOBO 4AL16CS VISHAL NAYAK 4AL16CS Under the Guidance of Mrs. Vidya Assistant Professor
CERTIFICATE This is to certify that the Mini Project entitled “AUTOMATED QUESTION PAPER GENERATOR” has been successfully completed by MARSH VISHAL LOBO 4AL16CS VISHAL NAYAK 4AL16CS the bonafide students of Department of Computer Science & Engineering, Alva’s Institute of Engineering and Technology in DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING of the VISVESVARAYA TECHNOLOGICAL UNIVERSITY, BELAGAVI during the year 2018– 2019. It is certified that all corrections/suggestions indicated for Internal Assessment have been incorporated in the report deposited in the departmental library. The Mini project report has been approved as it satisfies the academic requirements in respect of Mini Project work prescribed for the Bachelor of Engineering Degree. **Mrs. Vidya Dr. Manjunath Kotari Mini Project Guide HOD CSE External Viva Name of the Examiners Signature with Date
2.**
The satisfaction and euphoria that accompany a successful completion of any task would be incomplete without the mention of people who made it possible, success is the epitome of hard work and perseverance, but steadfast of all is encouraging guidance. So, with gratitude we acknowledge all those whose guidance and encouragement served as beacon of light and crowned the effort with success. The selection of this mini project work as well as the timely completion is mainly due to the interest and persuasion of our mini project coordinator Mrs. Vidya, Assistant Professor, Department of Computer Science & Engineering. We will remember his contribution for ever. We sincerely thank, Dr. Manjunath Kotari , Professor and Head, Department of Computer Science & Engineering who has been the constant driving force behind the completion of the project. We thank our beloved Principal Dr.Peter Fernandes, for his constant help and support throughout. We are indebted to Management of Alva’s Institute of Engineering and Technology, Mijar, Moodbidri for providing an environment which helped us in completing our mini project. Also, we thank all the teaching and non-teaching staff of Department of Computer Science & Engineering for the help rendered. MARSH VISHAL LOBO 4AL16CS VISHAL NAYAK 4AL16CS ii
ABSTRACT Information and intelligence are two vital columns on which development of humankind rise and knowledge has significant impact on operating of society. Student assessment is a crucial part of teaching and is done through the process of examinations and preparation of exam question papers has consistently been a matter of interest. Present-day technologies assist the teacher to stock the questions in a computer databases but does not provide efficient solution to create variety sets of questions from every now and then without the possibility of replication and duplication from the previous exam while the question bank keeps growing. In the proposed system we introduce an automated way which would permit the operation of setting an exam paper to be further well organized and productive and it would also aid in developing a database of questions which could be further classified for blending of exam question paper, currently there is no systematic procedure to fortify quality of exam question paper. The proposed system would have a modern evolutionary path that is able to manage multi- constraints issue along with creating question papers for examinations in autonomous institutes from a very vast question bank database. The Automated Question Paper Generator System would use a randomization algorithm which has been implemented specially for autonomous institutes. This system would also ensure the secure delivery of the question paper to the exam centre as an actual question paper would only be generated at the time when it is to be utilized. The endeavour needed for generating question paper is diminished after the implementation of this system and because of this system there is no obligation for humans to ponder and employ time which can be utilized on some additional important duty instead of designing question paper. iii
Fig 2.1 Schema Diagram 4 Fig 2.2 ER Diagram 5 Fig 4.1.1 Snapshot of Login Portal 11 Fig 4.1.2 Snapshot of Uploading Portal 12 Fig 4.1.3 Snapshot of Selecting Portal 13 Fig 4.1.4 Snapshot of Generating Portal 14 Fig 4.1.5 Snapshot of Sample Question Paper (1) 15 Fig 4.1.6 Snapshot of Sample Question Paper (2) 16 iv
With the onset of computer based technology there have been evolutionary changes in many areas of our professional environments. Most strangely e-education and e-learning is highly influenced. There is a shift from manual to automated systems for different aspects of education system. At every stage/level of education some admission procedure is present. The fundamental to this admission procedure is a test paper. However the main problem is, a low quality of papers generated because of some human factors such as instability and relatively narrow scope of topics. Teachers need to invest a lot of time and energy in composing examination papers. Also, the concern remains is how the current technologies would also help the instructors automatically generate the different sets of questions from time to time without being concern about repetition and duplication from the past exam while the exam bank keeps growing. Making assignment sheets, daily practice tests, weekly tests, test series, online tests, etc. is a repetitive and time consuming task which involves both teacher as well as computer operator. Using this software the same action can be accomplished in minutes and even in absence of operators. Not only this, for formation of a question paper it is also possible to restrict the search to questions which have not been used at all or have been used less than specified number of times. This makes it greatly advantageous as the headache of manually avoiding repetition at the time of feeding is totally eradicated. These automated systems provide cost saving and time-efficient solutions.
Examination process is an important activity for educational institutions to assess student performance. Thus the nature of the exam questions would determine the quality of the students produced by the institutions. Preparing the exam questions is very challenging, tedious and time consuming for the instructors. There’s also the possibility of replication and duplication from the previous exam which should be avoided to improve the overall quality of a question paper.
Question Paper Generator Dept. of CSE,AIET Mijar Page 3
Some advantages of the proposed system go hand-in-hand with simply being online; others are competitive advantages provided by the proposed system taking advantage of the random nature. The most prominent benefits provided by AUTOMATED QUESTION PAPER GENERATOR SYSTEM include:
In this the chapter the Schema and E-R diagram of the project has been shown with description.
The Figure 2.1 is a Schema Diagram represents the AUTOMATED QUESTION PAPER GENERATOR in which faculty should initially need to sign in and upload the minimum number of questions in the beginning to get the system going. FIGURE 2.1: Schema Diagram
In this chapter the implementation details of the project has been specified.
40 GB hard disk space. 2 GB RAM. Hi-Speed Network Connectivity.
Windows(x64) Operating System. Brackets IDE. MySQL Server. Apache Server. Xampp.
The languages used for implementation are as follows: Front end:- PHP,HTML Back end:- MySQL
PHP is a server-side scripting language designed primarily for web development but also used as a general-purpose programming language. Originally created by Rasmus Lerdorf in 1994, the PHP reference implementation is now produced by The PHP Development Team. PHP originally stood for Personal Home Page, but it now stands for the recursive acronym. PHP code may be embedded into HTML or HTML5 mark up, or it can be used in combination with various web template systems, web content management systems and web frameworks. PHP code is usually processed by a PHP interpreter implemented as a module in the web server or as a Common Gateway Interface (CGI) executable. The web server software combines the results of the interpreted and executed PHP code, which may be any type of data, including images, with the generated web page. PHP code may
Question Paper Generator Dept. of CSE,AIET Mijar Page 7 also be executed with a command-line interface (CLI) and can be used to implement standalone graphical. HTML:- Hypertext Mark-up Language (HTML) is the standard mark-up language for creating web pages and web applications. With Cascading Style Sheets (CSS) and JavaScript it forms a triad of cornerstone technologies for the World Wide Web. Web browsers receive HTML documents from a web server or from local storage and render them into multimedia web pages.
MySQL is an open-source relational database management system(RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius daughter, and "SQL", the abbreviation for Structured Query Language. The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation. For proprietary use, several paid editions are available, and offer additional functionality.
XAMPP is a free and open source cross-platform web server solution stack package developed by Apache Friends, consisting mainly of the Apache HTTPServer, MariaDB database, and interpreters for scripts written in the PHP and Perl programming languages. XAMPP stands for Cross-Platform (X), Apache (A), MariaDB (M), PHP (P) and Perl (P). It is a simple, lightweight Apache distribution that makes it extremely easy for developers to create a local web server for testing and deployment purposes. Everything needed to set up a web server – server application (Apache), database (MariaDB), and scripting language (PHP) – is included in an extractable file. XAMPP is also cross-platform, which
Question Paper Generator Dept. of CSE,AIET Mijar Page 9
o CREATE TABLE SEMESTER
( Sem_id
bigint(11) NOT NULL, Branch_name
varchar(60) DEFAULT NULL, Sem_value
varchar(3) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SUBJECT o CREATE TABLE SUBJECT
( Subject_id
int(11) NOT NULL, Sem_id
int(11) DEFAULT NULL, Sem_value
int(11) DEFAULT NULL, Subject_name
varchar(100) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; QUESTIONS o CREATE TABLE QUESTIONS
( Qid
int(11) NOT NULL, Sem_id
int(11) DEFAULT NULL, Subject_name
varchar(100) DEFAULT NULL, Branch_id
int(11) DEFAULT NULL, Questions
varchar(500) DEFAULT NULL, module
int(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; QUESTIONS_LOG o CREATE TABLE QUESTIONS_LOG
( Qid
int(11) NOT NULL, Date_added
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
Question Paper Generator Dept. of CSE,AIET Mijar Page 10 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TRIGGER mytrigger
AFTER INSERT ON QUESTIONS
FOR EACH ROW INSERT INTO QUESTIONS_LOG VALUE(NEW.Qid,NOW()) $$ DELIMITER;
CREATE DEFINER=root
@localhost
PROCEDURE proc
(IN sem
INT, IN sub
VARCHAR(30), IN br_code
INT, IN qus
VARCHAR(100), IN mod
INT) NO SQL BEGIN INSERT INTO QUESTIONS (Sem_id,Subject_name,Branch_id,Questions,Module) VALUES (sem,sub,br_code,qus,mod); END$$ DELIMITER; 3.3.1 OUTPUT TESTING During various phases of development of the project a number of technical difficulties were faced by us. In the initial stages the system design was not up to the mark which was a great set back. Thereon we improved our database design to create the current version of the system. We also faced various errors while programming the database connection using MySqli in PHP. After various iterations we solved the numerous errors.
Question Paper Generator Dept. of CSE,AIET,Mijar Page 12 FIGURE 4.1.2 UPLOADING PORTAL In Figure 4.1.2 we have depicted the snapshot of the uploading portal that provides the input questions to the questions database.
Question Paper Generator Dept. of CSE,AIET,Mijar Page 13 FIGURE 4.1.3 SELECTING PORTAL In Figure 4.1.3 we have depicted the snapshot of selecting portal that takes the College, Branch, Semester and Subject as input from user and queries the questions database.