OpenQP

• Click here to Verify the uploaded Courses

• Click here to Generate Question papers

• Click Here to Upload Questions from the Excel File to the Database.

Introduction

OpenQP generates Question Papers by selecting questions (based on some pre-defined algorithm)from a question bank. The questions are stored as text (with embedded LaTex commands for equations, images etc.) in a postgres RDBMS system, that can be accessed from remote computers. Some of the features of the system are:

• Capable of handling large number of courses.

• Renders mathematical equations properly (uses LaTex).

• Support for multiple languages. English, Hindi, Sanskrit, Malayalam, Tamil, Kannada, Arabic and Urdu are currently implemented.

• GUI programs are available for

  • Creating/Deleteing Courses.
  • Adding/Editing Questions
  • Generating Question Paper

Adding Questions to the Question Bank

There are two methods available for populating a course with questions.

• Bulk uploading: Fill the course from a single Excel (.xlsx) file. The existing contents of the course must be deleted before uploading new set of questions. The program required is uploadXLSX.

• Add/Modify one by one: Choose any existing question for editing or add a new question. The program required is cuqbc.

The system uses LaTex to typeset the questions. So it is necessary to make sure that the entered text does not contain any special characters that are interpreted as LaTex commands. for example characters like &, %, _ etc. If they are part of your text, enter them as \&, \% and _. Make sure that you View the questions in the PDF format, so that LaTex compatibility is ensured. Equations, Tables, Lists etc. are entered in LaTex format, but most of the questions, it is just plain text.

1. Bulk Uploading of Questions from a spreadsheet (.xlsx) file.

A screenshot of the GUI is shown below. The sequence of operations are:

• Select the typesetting language
• Open the .xlsx file
• View questions in PDF format (for checking any LaTex errors)
• Connect to a remote Course (name is same as the filename, without .xlsx the extension). You need to provide the password. Upload, Clear and Display options work only after successfully connecting to the course.
• Upload the Questions to the remote course (course should be empty, otherwise make it empty using the Clear Remote Course button)
• You may list the contents of the Remote Course, either in the order they are entered or sorted by the Module number and Question type.

• Download the MSWindows Executable uploadXLSX.exe
• Download the Python Source Code uploadXLSX.py
• Sample file Y2024AC_TES2CJ101.xlsx
• Youtube Video

The Excel file must be prepared carefully, the points to note are:

• The coursecode is same as that of the filename, without the .xlsx extension. For example Y2024AC_TES2CJ101
• There must be exactly 9 columns in the spreadsheet. Do not type anything beyond that.
• The sheet name should be Sheet1 (the default value, do not change it)
• The first row should be exactly like the one shown below.
• The Bloom’s Levels should be specified as Remember, Understand, Apply, Analyze, Evaluate or Create.
• The course outcome fields should be CO1, CO2, CO3, CO4, CO5, CO6 or CO7.
• At present, it is not compulsory to fill the column named atext.
• If you include figures by using the \includegraphics command, the corresponding image file should be in the same directory.

2. Edit/Add individual questions

A screenshot of the GUI is shown below. The steps to be followed are:

• Connect to the Database. This will bring a list of courses available.
• Type some characters of your coursecode to filter the list, for example ‘phy’ will restrict the list to the physics courses.
• Select a course from the pull down menu.
• Select a Module and question Type (A,B or C)
• Select an existing Question or create a new one
• Enter the Author information
• Select the Bloom’s level and Course Outcome from pulldown menus.
• Enter the question text ( copy & paste from otherr documents or by typing)
• Add any Hints about the answer, to help in evaluating the answer papers(optional).
• Press View Question to view as PDF. This ensures the LaTex compatibility.
• Update the question (write it to the remote database)
• After entering several questions, press List CurrentModule to generate a PDF rendering of the currently selected Module.

If you include figures by using the ‘\includegraphics’ command, the image file should be in the same directory.

• Question Bank Editor Download the MSWindows Executable
• cuqbc.py. Question Bank Client program.

Creating a New Course

• Qadmin.py. Creates new courses or delete existing ones. Connecting to the Database lists all the existing courses. Subject and Semester filters may be selected to restrict the number of courses displayed.

A new course may be created by adding the details like Course code, course name, subject etc. It is easier to add a new course by selecting an existing course to fill all the input fields. Create a new one after modifying the required fields. Course Code entered by the used is stored in the database after prefixing the Syllabus Year and Institution information.

There is another Editor that imports the entire Course, make changes and export it back. Exporting wipes out the old contents. Used only for populating new Course with dummy questions. Qeditor.py.

Generating Question Papers

A GUI program is available for generating the question papers.

• qpgen.py.

The following details, to appear on the generated question paper are added:

• Year
• Month
• Header
• QP code

Installation, postgres RDBMS

• The postgres RDBMS should be configured for remote login, using TCP/IP protocol. The two files mentioned below need to be edited to enable TCP/IP connectivity.

A database and a user to own it are areated. Two users named ‘dummy’ and ‘reader’ are are created. These steps are carried out by the ‘psql’ client program, after logging into the server machine.

After completing these steps the program

• initQbank.py is ran to initialize the database. This could be done from anywhere.

• Complete Installation Instructions given in the file install.txt

Program Design

The backbone of the system is a Postgres RDBMS. A table named coursedetails stores the information about all the available courses. Each record of this table represents a course. Each Course has a Table to store the questions and related information. Name of the table is same as the course code. There is a corresponding ‘user’for every course, having access rights to it.