Mansfield University CIS3306 Project

Design of a Server-Side Database-based Quiz Program Using JSP

and

Quiz Results Analysis Tool Using Perl and XML

by

John Phillips

bocaweb@hotmail.com

September 14, 2003

Summary

An online quiz program was created for use in the computer courses that I teach. This program allows a student to log in and select from the available quizzes. After completing the quiz, it is automatically graded and the results shown to the student. The student's start / stop time and answers are stored in a database table. An analysis program reviews the results contained in the database and produces an XML report for review by the instructor or for further processing by a grade book program. These programs demonstrate several topics covered in CIS3306 including Perl/CGI, JSP, and XML.

Project Deliverables

report - View the project report.

project demo #1 - View the quiz program in action.

project demo #2 - View the analysis program in action.

Diagrams and Code

er.jpg - The entity relationship diagram of the database

Quiz Program Code

p2form.html - code for the login page

p2.jsp - code to validate the user and present available quizzes

showquiz.jsp - code to display the quiz and to log its viewing

gradeit.jsp - code to grade a submitted quiz and log the results

Analysis Program Code

analyze.pl - code to produce an XML report of all results on a given quiz