MemDB Online Survey System

Mathematics Test

Description

It is not an easy job for a teacher to implement an online test for the students. However, answering the question from Internet is a good self-study method for the students. Therefore, teachers always spend a lot of time on designing database and writing CGI. With the help of MemDB Online Survey System, teacher only needs to write HTML files in order to complete this complicated job.

This demonstration use MemDB Online Survey System to design a multiple choice test and let the students answer the questions through the Internet. Teacher can retrieve the overall statistics results and individual result. You can follow the steps below to learn how to make such system, and then design your own multiple choice questions.

Step 1: Download and Insert the system

You can download the MemDB Online Survey System, unzip MemSurveyE.zip to a new folder, e.g., C:\memdb, and then execute MemSurvey.exe, a new database file MemSurvey.mem will be created. This file store all results.

After executing the system, the default starting and ending HTML file will be start.htm and end.htm. You can press the button beside it and modify the starting HTML file to question.htm, and ending HTML file to answer.htm, input the web server port number, e.g., 8001, and then press [Start Server] button to start the web server and wait the students to submit ther result..

Step 2: Input the answer and submit the result

After you have started the web server, you an input the IP address in your browser, e.g. Internet Explore or Netscape. For example, the IP of your web server is 202.168.10 and the Port is 8001, you can enter http://202.168.10.1:8001. After answer all questions, you can press [Submit]. If there is any missing data, the system will alarm you and move the cursor to the unanswered question (this function is implemented by javascript); otherwise, you result will send to the web server and can you view it from the application.

Step 3: Submit more results and view the result

You can either press [Back] button or use other computers to submit more results, then return to the application and press [Update] button. All the result and statistics are shown, e.g., the Mark and the selected count of each question.. You can press [View] button and use [|<] , [<] , [>] and [>|] four buttons to view each result. You can also export the result to an Excel or CSV file.

Step 4: Understand the starting HTML file "question.htm"

You can use any HTML editor to view the file "question.htm", e.g. FrontPage or Dreamweaver.

This demonstration uses Javascript to calculate the time and the number of correct answer. Though you do not need to understand how to use javascript, but understanding javascript can help you design other question easily. Firstly, you can see the following HTML code:

The above statement indicates that when the HTML file "question.htm" has been loaded, the following javascript function init() will be called:

var startTime
var answer=new Array;
function init()
{
   // answer of each question, please specify
   answer['QUESTION01']='C';
   answer['QUESTION02']='D';
   answer['QUESTION03']='A';
   answer['QUESTION04']='C';
   answer['QUESTION05']='E';
   // starting time
   startTime=new Date();
}

You can use the function init() to specify the correct answer of each question. For example, if you want to add another question, say QUESTION6,and the answer is 'B', you can append "answer['QUESTION06']='B';" below the line "answer['QUESTION05]='E'; ". This function also set the starting time startTime.

After you pressing the [Submit] button, the system will call function validateForm() because of the following HTML code:

validateForm() function check the number of correct answer and calculate the total time.

Step 5: Add a new question

After understanding "question.htm", you can add a new question in question.htm. You can apply "Copy and Paste" method. For example, you can copy the QUESTION05 HTML code and press it just after QUESTION05, then rename the name of QUESTION05 to QUESTION06, then specify the answer of QUESTION06 (described in Step 4).

Step 6: Understand the ending HTML file answer.htm

Assume you have added QUESTION06 successfully, if you want to show the answer after you have submitted, you are required to modify the the ending HTML file answer.htm. You can use HTML editor to open answer.htm and examine the HTML content. You can understand the answer is used in syntax <#OBJECT_NAME>. For example, <#Z_Student> Î <#QUESTION01>, those Object Name are the form object name in question.htm. This system will replace the value of to the <#OBJECT_NAME>. For example, in the starting HTML file question.htm, you select Answer 'C' to question QUESTION01. When the system displays answer.htm, the Answer 'C' will replace the tag <#QUESTION01>.

Step 7: Add the answer of QUESTION06

After you have added the QUESTION06 in question.htm, you can add the answer in answer.htm. You can copy the HTML code of QUESTION05 in answer.htm and paste it just after QUESTION05, then change <#QUESTION05> to <#QUESTION06>.

Step 8: Restart the data

After you have finished the start.htm and end.htm, you can press [Reload File] button. You do not need to restart the server in order to use the updated file. If you want to restart the data, you can press [Clear] button to clear all records.

Back to MemDB Online Survey System