Greysh's Blog Greysh

« Some photos from the... | Main | The complete results... »

Wednesday Nov 05, 2008

Test Management System

1 The Intention

I used MySql, Netbeans and Glassfish in developing Testing Management System. For more and more classmates do excises online in my university, I intent to build a Testing Management System.I have written a plug of moodle(http://www.moodle.org) two years ago.

You can find more details here:

http://moodle.org/mod/forum/discuss.php?d=85136

2 Solution Approach

A Test Management System consists of the Test-taking platform and Test-management platform.

3 Tools

3.1 MySQL Relational Database

MySQL is a relational database management system and probably the most used database on internet (has more than 11 million installations). It’s also very easy to install and administer, through command line or many gui interfaces.

1 The mysql database of tms named greysh_tms

2 Notices in Greysh_tms database designing

(1) The name of each table begin with “tms_”, followed by abbreviation which indicates the meaning of the table, such as “tms_admin” is the table of manager information.

(2) Domination

A tms_admin: the table of managers.

B tms_testee: the table of testees.

C tms_question: the table of questions.

D tms_paper: the table of papers.

E tms_grade: the table of grades of a specific paper.

F tms_grade_item: the table of showing detail information of a specific student and paper.

(3) Relationships

A A testee can has more than one papers, while a paper can also be taken by a number of testees.

B A paper contains several questions, while a specific question could also appears in more than one papers.

C The total record could contains several specific records, while a specific record should be contained by a total record.

3.2 Netbeans

Netbeans is a free, open-source Integrated Development Environment for software developers. You get all the tools you need to create professional desktop, enterprise, web, and mobile applications with the Java language, C/C++, and Ruby. NetBeans IDE is easy to install and use straight out of the box and runs on many platforms including Windows, Linux, Mac OS X and Solaris.

3.3 Glassfish

GlassFish is an open source application server which implements Java EE 5. The Java EE 5 platform includes the latest versions of technologies such as such as JavaServer Pages(JSP) 2.1, JavaServer Faces(JSF) 1.2, Servlet 2.5, Enterprise JavaBeans 3.0, Java API for Web Services(JAX-WS) 2.0, Java Architecture for XML Binding(JAXB) 2.0, Web Services Metadata for the Java Platform 1.0, and many other new technologies.

Deploy TMS to the GlassFish

4 Program

4.1 TMS overview

TMS(Test Management System) is a test-taking and test-management system with powerful functions and friendly user-centered interface. TMS consists of two main modules:

1 Foreground—test-taking platform.

2 Background—test-management platform.

4.2 A brief introduction of the functions of TMS

1 Test-taking platform

Testee logins the TMS by typing in his/her right accout and password and selecting a login type(Administrator/Testee) at the login page.

Each testee can have an over view of his/her test records after login and can scan the detail of each taken paper by simply click the paper name displayed. There is also a list of unfinished tests which testee can select one and make a start of.

The account/password of the admin is admin/admin.

The account/password of testee is testee/testee.

2. Test-management system

The management of the manager of the TMS consists of Testee Management, Question Management, Paper Management.

(1) Testee Management

A The manager registers the accounts and passwords of testees.

B The manager has the right to modify or delete the information of a testee.

C The manager has the right to check the records of the testees.

(2) Question Management

A The manager can scan all the questions stored in the TMS question database, and modify a specific question.

B The manager has the right to add questions to the TMS question database.

(3) Paper management