Randomized Online Question Paper Generation through SQL query and JEE
Vinayak Hegde1, Sharanya T D2, Likhitha S3

1Vinayak Hegde, Department of Computer Science, Amrita School of Arts and Sciences Mysuru, Amrita Vishwa Vidyapeetham Mysuru campus, Mysuru, (Karnataka), India.
2Sharanya T D, Department of Computer Science, Amrita School of Arts and Sciences Mysuru, Amrita Vishwa Vidyapeetham Mysuru campus, Mysuru, (Karnataka), India.
3Likhitha S, Department of Computer Science, Amrita School of Arts and Sciences Mysuru, Amrita Vishwa Vidyapeetham Mysuru campus, Mysuru, (Karnataka), India.
Manuscript received on 02 June 2019 | Revised Manuscript received on 10 June 2019 | Manuscript published on 30 June 2019 | PP: 1438-1442 | Volume-8 Issue-8, June 2019 | Retrieval Number: H7512068819/19©BEIESP
Open Access | Ethics and Policies | Cite | Mendeley | Indexing and Abstracting
© The Authors. Blue Eyes Intelligence Engineering and Sciences Publication (BEIESP). This is an open access article under the CC-BY-NC-ND license (http://creativecommons.org/licenses/by-nc-nd/4.0/)

Abstract: An examination plays a vital role in evaluating the competent level of the student in an educational sector. It determines the quality of the student. Preparing the question paper is a time-consuming process for every question paper setter. So preparation of question paper in aligning with the requirement of the university is a challenging task. In a conventional university setting the question, the paper has been manual. This method becomes ineffective if the question paper is set become bias, repetition, and lack of uniform distribution within the assigned syllabus of the university. This problem we addressed by developing the software on Online Question Paper setter using random algorithmic function using SQL query and Java Enterprise Edition. The system is designed with an admin module, Teacher module, and exam staff module. Inner processes are designed with question entry by different types of difficulty level and approval is done by the department head, using question selection module question paper generator can generate question paper for any defined requirement of question paper as per the template of the university examination procedure. Using the random function in SQL query and server-side programming JSP and Servlet the system generates the random questions in the defined subject and question paper is generated in .docx format or .PDF format. The software is designed with software engineering principles; it is user-friendly, robust in operation, secure in maintenance and good reliability. The application serves the purpose of the university examination question paper preparation, in turn; it reduces the workload of the faculty members of the institution.
Keyword: Randomization, Generate Question Paper, Question Pattern, Word Formate, JEE.
Scope of the Article: Next Generation Internet & Web Architectures.