Developing test database and online examination system with ASP (4)

4. 2. 2. Paper structure

Test papers generally include objective questions (judgment, single topic or multiple-choice) and subjective questions (fill in the blanks, short words or long text questions), that is, a set of papers including a number of big questions, each big problem contains a number of small questions. However, the system's Test paper currently only involves the objective part. Therefore, the number of major questions is tentatively 3, the sum of the number of small questions, and, in this table, only the corresponding test papers stored in the exam questions number, the content of the questions in the call to the corresponding subjects in the query obtained.

4. 2. 3, the user, message information structure

A, Superuser: there is and only one, the system administrator, in this system. He has the supreme power which the general user does not have, namely has the deletion user, the message, the question and the examination paper and so on information power. It does not need to be registered and does not have any relevant information in the database, but the administrator can change the user name and password by themselves. Ensure the system is compromised in case of data leaks.

B, the general User: mainly refers to the school teachers and students and enterprises and institutions of the education sector. In addition, all users may comment on our system or troubleshoot each other.

4. 2. 4, the candidate answers the score table structure
The actual test date may postpone the test for some reason and be different from the test date in the quiz sheet. Therefore, this table should be related to the user, Test paper and question database, and the relationship is more complicated.

4. 3. Detailed design of function module

Below, according to the input test-out volume-test and other processes on each module for detailed discussion, the specific situation see system source program and demo. Considering the confidentiality and security of the data, all users who enter the system must register first and pass the verification before entering. Otherwise, go to the "SORRY" page.

4. 3. 1. Input module

Licensed users can add various types to the library and meet the requirements according to their own teaching purposes and requirements (will give a hint and warning to the non conformance, and not save!) Questions and test papers as well as their own opinions and difficult issues. Once added successfully, only administrators can delete it.

① Question Entry

First, the user selects the account to which the question belongs. If the account is not in the Drop-down menu, click on the new account on the right, that is, to enter the page, as long as you enter the new account details name (generally a semester completed for the standard) and table name (preferably by the first letter of Hanyu Pinyin), the system can be set up according to the field automatically set up a new subject question table. Return and refresh the page to see the new account name. Also, other areas of the system that need to select accounts are automatically updated.

Next, each question has the type, the difficulty coefficient, chooses from the book and the chapter, the question content and the answers and the standard answer and so on column. User one by one is finished (the default is "Do not fill" for the answer item that is not required for the question), the preview effect can be seen after "submit". If the input is illegal, or the question number and content are already in the questions, the system gives the appropriate prompt or warning to be corrected.

② Test Paper entry

This module consists of two parts, that is to identify the basic information of the Test paper input and Manual section of the volume. The basic information has the examination paper number, the title, the numbers, the difficulty, the subject name, the examination nature and the date and so on, but the question of the volume will be realized by the manual group volume module behind. The system still gives a prompt or warning for data that the user has entered that does not conform to the system requirements.

③ User Message

Users who use this system may have many good suggestions and opinions about our work, or some difficult problems need to be discussed together, you can put forward here.