Questions-Bank System to Enhance E-Learning in School Education

The assessment process in an educational system is an important and essential part of its success to assure the correct way of knowledge transmission and to ensure that students are working correctly and succeed to acquire the needed knowledge. This paper describes the analysis, design, and implementation of the Questions-Bank system, that allows the students of primary, preparatory, and secondary schools to take web-based quizzes and exams, to download course reviews, and previous exams. "QuestionsBank", means that each question has a weight and area of knowledge deals with it. The system facilitates generation of automatic, balanced, and different exam sheets, that containing different types of questions, covering the entire curriculum, and displaying gradually from easiness to difficulty. The exam sheet produced by the system, takes into account the different levels of the students from excellent, good, to fair, and avoids any mistakes of language and nonclear terminologies. The system allows the schools to create a Questions-Bank database, that stores the previous exams, the model answers, the reviews, and useful exercises for each course. Our system is used successfully in distance learning as well as in self-training. We have tested the system with different type of courses taught in Qatari schools, ranged from primary to secondary levels. The feedbacks of both teachers and students were highly promising.


INTRODUCTION
Introducing Internet at schools has encouraged the development of new tools and systems within the scope of education and training.As a result, a new era of learning and training approaches has emerged, where new educational models have been developed, students could learn independently at any time or location, simply by connecting to the Net along with the appropriate systems and tools.Teachers, at the same time, could teach through "on-line" setting and could schedule lessons and exams without the classical physical constraints.This electronic learning approach, also known as e-learning, has opened new horizons in teaching for both teachers and students [1][2][3][4].
The assessment process in an educational system is an important and primordial part of its success to assure the correct way of knowledge transmission and to ensure that students are working correctly and succeed to acquire the needed knowledge.Many assessment methods can be used: conducting some experiments, realizing different mini-projects, making quizzes and exams.The evaluation mechanism help students to discover whether they have gained the required knowledge as expected, and provide appropriate and timely feedback to teachers to adjust their lectures, exercises and exams [5][6][7].
In this, paper we introduce the web-based "Questions-Bank" system, which can be used with any school courses and may save hours in exams and quizzes preparation and correction, as well as may save resources like, photocopying and distributing the exams papers, locations of these exams, teachers and assistants, etc.The proposed system has the following functionalities and features: Knowledge evaluation: Students can evaluate their understanding levels, and teachers can track the activities of their students and can guide them to reach the pre-determined objectives of the courses Exams generation: Teachers can store many types of questions like multiple choices, true/false, and fill in the blanks.The system uses an intelligent algorithm to generate balanced exam sheet, that containing different types of questions, covering the entire curriculum, and displaying gradually from easiness to difficulty.
Exam grading: quizzes and exams can be marked automatically by the system.Thus, students can get instantly their marks in a given quiz immediately after submitting their responses and see also the corrected answers.

Communication:
The system has a communication tool that allows students and teachers to interact together and discuss their activities.
Course management: The system is highly flexible and doesn't necessitate any programming skills from its potential users.Thus, teachers can add, delete and update their course materials at any moment through the web.
Questions-Bank database : The system allows the schools to create a Questions-Bank database that stores the previous exams, the model answers, the reviews, and useful exercises for each course.
The paper is organized as follows: in section two we give a brief overview about the Questions-Bank system while in section three we present the system analysis and design.In section four we describe the system implementation and in section five we evaluate the system.The paper is finally concluded by our future works, in section six.

II. SYSTEM OVERVIEW
The system interface (Arabic/English) is entirely webbased, and doesn't necessitate any technical skills from the potential users.The system is divided into three applications, called administrator, teacher, and student application.As shown in Figure 1, the system is appropriate for on-campus teaching, with access to the Internet, or off-campus teaching using the local network.The administrator application: This application provides the school administrator with simple tools to manage the information of the Questions-Bank system.The following are some features provided by the administrator application: -Activate/Inactivate the system.
-Import and Export the Questions-Bank database -Send automatic email immediately containing the new password whenever the user changes his/her password.-Administer the basic information of the system: -Levels data, -Subjects (or courses) data, -Classes data, -Teachers data, and -Students' data.The teacher application: This application provides the teachers with various tools to construct the system services.The following are some features provided by the teacher application: -Change account password -Manage (add, update, delete and display) all the system services (reviews, exam questions, quizzes, previous exams, and model answers) The student application: This application provides the students with interactive tools to use the services of the system.The following are some features provided by the student application: -Change account password -Download assignments, revision documents, previous exams, and other files that are uploaded by the teachers.
-Take web-based quizzes, exams, assignments, interactive tutorials, and reviews.

III. SYSTEM ANALYSIS AND DESIGN
A. Adopted Software Development Process Software development process represents the structure imposed on the development of a software product, which includes software life cycle and software process.There are several models for such processes, each describing an approach to a variety of tasks or activities that takes place during the process.The process involves translating user needs into software requirements, transforming the software requirements into design, implementing the design in code, testing the code, and sometimes installing and checking out the software for operational activities.Note that, these activities may overlap or be performed iteratively [8].

B. Life Cycle Model
Numerous models have been proposed to handle the problems of defining activities and associating them together.Our adopted software development process is the V-model, as shown in Figure 2, which can be presumed to be the extension of the Waterfall model [9].Instead of moving down in a linear way, the process steps are bent upwards after the implementation phase, to form the typical V shape.In the development of the Questions-Bank system, the V-model was followed by: 1. Specifying the system requirements using different gathering approaches.2. The requirements were analyzed and classified into functional and nonfunctional requirements, and use cases and domain model were constructed.3. The system design was started by determining the database tables, appropriate interfaces, class diagram: to show a static view of used classes, and interaction diagrams: to show the collaborations among the objects of the system to complete an action.4. The implementation phase was launched by implementing the functionalities of the system.
Each of the previously mentioned phases is associated to a certain phase of testing to verify and to validate that the work is accurately executed, if problems are found iJET -Volume 4, Issue 3, September 2009 during the verification or validation phases, then a reexecution of left side of the V is performed to make fixes and improvements.

C. Methods and Techniques to Analyze the Problem
Scenarios: A scenario is an informal description of actions done by a specific user in order to make a use of the system.It can be considered as an instance of a use case.It is expressed as a story of how a user can access the system.Use-cases: A use-case describes the interaction between the users of the system and the system itself through a sequence of simple steps that show how the system responds to a request from a certain user.
It is mainly used to capture the functional requirements of the system.Use cases must be written in a language that is understandable by clients.They must describe the events from the point of view of the users.
Initial UML Interaction Diagrams: An interaction diagram demonstrates a certain aspect of a system by modeling its behavior.It is used to visualize the collaboration among several objects to complete a certain task.

D. System Analysis
The analysis phase is the chief phase in which the system requirements are identified in more details.The goal of this phase in the system development is to refine the system goals into defined functions and operation of the intended application.System requirements are documented in a complementary set of artifacts: flow charts, use case diagrams, system sequence diagrams and so on.Each artifact provides a different perspective of the system under design and contains distinct requirements.The combination of these perspectives establishes the tasks that are to be accomplished by the system.

1) Available Information Gathering Technique:
It's difficult to build a solution if we don't know the requirements.The "elicitation" step is where the requirements are first gathered from the client.Many techniques are available for gathering requirements.Each has a value in certain circumstances, and in many cases, we need multiple techniques to gain a complete picture from a diverse set of clients and stakeholders.Here is a look at some of the approaches that could be taken.
Interviews: The most common technique for gathering requirements is to sit down with the clients and ask them what they need.Our discussion would help us plan out ahead of time, based on the type of requirements that we are looking for.
-Gather facts, opinions and speculations.
-Ask about specific details.
-Ask for other sources of information.
-Ask about the stakeholders' vision for the future.
-Ask if they have alternative ideas.
-Ask them to draw diagrams.Prototyping: Prototyping is a relatively modern technique for gathering requirements.In this approach, we gather preliminary requirements that we use to build an initial version of the solution.We show this to the client, who then gives us additional requirements.We change the application and cycle around with the client again.This repetitive process continues until the product meets the critical mass of business needs or for an agreed number of iterations.
Use Case: Use cases are basically stories that describe how discrete processes work.The stories include people (users) and describe how the solution works from a user perspective.Use cases may be easier for the users to articulate, although the use cases may need to be distilled later into the more specific detailed requirements.At this stage, client requirements are gathered.This is done on the basis of information provided by the client in the form of documents.Requirements could be classified in two types: Functional and Non-Functional requirements.
2) System Specification Functional requirements: Describe the interactions between the system and its environment independent of its implementation.The environment includes the end user and any other external system with which the system interacts.
The Questions-Bank system should allow different types of users to interact with the system according to given privileges.There are three main users, as shown in Figure 3: school administrator, teacher, and student.It provides various services for each one: -Renew data (Import the data from the Excel file to the SQL server database, delete data from specific table) -Send an email immediately containing the new password whenever the user changes his/her password.-Manage (add, update, delete and display) the basic information of the system: -Levels data, -Subjects (or courses) data, -Classes data, -Teachers data, and -Students' data.
b. Questions-Bank system allows the teacher to: -Login (as teacher).
-Change account password -Manage (add, update, delete and display) all the system services: -Reviews, -Exam questions -Quizzes, and -Previous Exams (with their model answers) c.Questions-Bank system allows the student to: -Login (as student).
-Change account password -Get new password instead of the lost one.
-Download assignments, revision documents, previous exams, and other files that are uploaded by the teachers.-Take web-based quizzes, exams, assignments, and interactive tutorials.
Non-functional requirements: Describe aspects of the system that are not directly related to the functional behavior of the system.Non-functional requirements include a broad variety of the requirements such as implementation requirements, interface requirements, operation requirements and others.
-Usability: The system must provide a coherent user interface that is consistent with the organization interface.The system must be obvious, allowing the user to navigate the system easily.-Reliability: The system must perform and maintain its functions in routine circumstances -Supportability: The system must be easily modified or extended by more functions.-Performance: Performance requirements are concerned with quantifiable attributes of the system, such as response time, throughput availability and accuracy.-Security: The system must prevent unauthorized users to access the system.Authorized users must be provided with user ids and passwords.In order to achieve high level of security, the password must be encrypted.

3) Hardware and Software Resource
We have used some software during our system development such as: Windows XP professional, Windows Server O/S, Microsoft office Excel, Microsoft Word, SQL Server database system, MS Visual Studio.Net, and Photo Shop.

4) System Models
Scenario: A scenario is a specific sequence of actions and interactions.It is one particular story of using a system, or one path through the use case.In our system, we have developed a simple scenario that illustrated the basic actions in the system.UML use case: UML use-cases, as shown in Figure 4, were used in the analysis, in which the functional requirements are extracted and described along with a scenario of the flow of events.Universal Modeling Language (UML) is an industry standard language for specifying, constructing, visualizing, documenting artifacts of a software system.

E. System Design
The design goal of our system is to resolve some of the issues, specifically; it is to be made easily accessible and customizable.Students will not be afraid to use our system.The system will be designed as a web application requiring only a web browser administer and use.Hence, no additional software needs to be downloaded.

1) Design Methodology and Patterns
A methodology is a collection of methods for solving a class of problems.It specifies which method should be used and the manner in which it is utilized.Software development methodologies decompose the process into activities.They provide methods for several activities as shown in Figure 5.
Design pattern is a general re-usable solution to a commonly occurring problem in software design.A design pattern is not a finished design that can be transformed directly into code.It is a description or a template iJET -Volume 4, Issue 3, September 2009 for solving a problem that is common among different situations.It typically shows relationships and interactions between classes or objects. 2

) Database design
Database is an important component in our system.Microsoft SQL Server database is the database management system used for the system.The implementation of the database has been developed and modified many times to be applicable with the system requirement.The DBMS stores the subjects in each school level, the reviews, the previous examinations, the exams questions, the quizzes, the student grades, and the basic information of the administrator, teacher, and student.We have chosen the entity-relationship model to represent the database design [10].Figure 6, shows the basic entity-relationship diagram, and Figure 7, represents the corresponding rela-tional database schema, that contains the main tables used for creating the Questions-Bank database.

3) Application Logic Design
Application logic design will deal with three main parts of the application design: First part: the architectural design of the system which is concerned with the tiers of the system.Second part: the upper level design is further introduced as an identification of the distinct subsystems and their functionalities.
Third part: the detailed design is discussed with the class diagram and sequence diagrams.

4) System Architecture
The web-based "Questions-Bank" system consists of three components as shown in Figure 1: The client, the server, and the database management system (DBMS).The client side application is developed by web-based programming languages such as XHTML, ASP.NET, Macromedia Flash and Java script.The server application is developed by Microsoft Visual Studio (ASP.NET, C#.NET, and VB.NET) and acted as a gateway between the database and the clients.The school information, user's information, course materials, questions, quizzes, exams, model answers, reviews, and tutorial are stored and managed using Microsoft SQL Server database.The database and the server applications will run on Microsoft Windows Server.

5) Quiz Generation Algorithm
The DBMS of the "Questions-Bank" system includes an innovative and intelligent algorithm for managing the difficulty of the quiz questions [2].The algorithm uses the difficulty attribute set by the user as input parameter.The teachers set the difficulty levels of their questions at creation phase using a numbering system.The value assigned to a specific question identifies how difficult (or easy) it would be for a student to reply correctly to the question.Our algorithm can generate automatically different quizzes with different levels of difficulties.Obviously, teachers are not always as accurate as would be desirable in estimating the difficulty of a question (as they don't know the exact level of the students using the system) our algorithm can update the difficulty and the easiness of the questions based on the responses given by the students.The algorithm has the ability to detect the difficulty/easiness of a question based on students reply and adjust the difficulty value accordingly.As a result, some of the feedbacks of the students in a given course are used to adjust the level of the questions.The following are the methods of our algorithm: iJET -Volume 4, Issue 3, September 2009 -Get_Difficulty(): This method determines the difficulty of a specific question.-Calc_Margn(): This method calculates the lower and the upper bounds of error percentage in the students' responses.-Calc_Error(): This method calculates the percentage of wrong responses to a question, as a ratio between errors and a constant value named Max_Num_Access.The involved variables are reset after each difficulty evaluation.-Mark_Ques(): This method activates a Boolean field in the register of a question if the difficulty level reaches the thresholds.
Four difficulty degrees have been considered rangy from level one to level four.If a question has a value higher than four, it could be too difficult or it could be ambiguous.Similarly, if a question has a value of 0, the question could be too easy, or too obvious, and nearly all the students can answer it correctly.The questions that are out of bounds are marked, so they cannot be used for any quiz, and the teachers must update them.Table 1 shows the upper and lower bounds for determining the difficulty of the questions.IV.SYSTEM IMPLEMENTATION The web-based "Questions-Bank" system takes the advantage of the latest development technologies in its implementation.It is an ASP.NET web application to be used on the Internet and was written using Microsoft's Visual Studio .NET development environment in the C# programming language.Code that executes on the server to process event handlers for events such as button clicks is written in C#.Microsoft's SQL Server 2008 is used for database operations, including the storage and retrieval of login information.Successfully logging into the system, users are taken to an action page that dynamically presents options to them based on their privileges.

A. Database implementation
The database is designed to have the following main tables: Level, Subject, ReviewFile, Quiz, ExamFiles, Questions, StudentScore, Student, Teacher, and Administrator.
During the development of the system, data for the testing of different functionalities was needed to be imported into the database tables.The tables in the database are filled using two different ways .The first way is to fill the tables by importing the data from an MS Excel sheet that contains the basic data from the school's database.The second way is done during the run time of the system.

B. System requirements implementation
To prove the functionality of the "Questions-Bank" system, we have implemented several web-based applications as components of the system.The Questions-Bank system is divided into three sub-systems, as shown in Figure 8: the administrator, the teacher, and the student sub-system.i.The administrator sub-system: This sub-system provides the school administrator with web-based services to manage the information of the Questions-Bank system.The following are some services provided by the administrator sub-system: a. Login: Before users are granted access to the "Questions-Bank" system, they must successfully login to the system.The user's accounts are associated with different levels of privileges.Username and password is the most common authentication method, used to access the system, as shown in Figure 9. Login information is verified by comparing the entered username and password with the stored ones in the database.The authentication program on the Web server opens a database connection and retrieves the user record.
If the user input data matches a database record, the user is granted to access the system services.Otherwise, an "invalid login" message is displayed, and the login page is displayed again.b.System management: The administrator subsystem provides the school administrator with web-based services to add (update, or delete) the basic data needed for the other two sub-systems, such as: levels data, subjects data in each level, school data, classes data, teachers data, and students data, as shown in Figure 10.c.Change password: The "Questions-Bank" system provides the user to change his/her account password: -The user login into the system from the user login page.-The user clicks on the link "Change Password", and then he/she will be directed to the suitable page.-The user enters his/her old password, new password and re-enters the new password again, then he presses the "Change" button.-A validation is applied on the input data to ensure that they are filled with required information.-The user's old password is deleted and the new one is inserted using an update query.
14 http://www.i-jet.orgii The teacher sub-system: This sub-system provides the teacher with web-based tools to manage the information of the Questions-Bank system.In addition to the login, and change password, the following services are available in the teacher sub-system: a. Reviews administration: Teacher can use this service to upload (add) the MS Word, PP presentation, video, etc. files that contain the reviews for each subject.Also teacher can delete specific review(s) from the database and can display the stored reviews, as shown in Figures (11).
The teacher can store the following data for each review: level name, subject name, review title, review date, review file, and the review answer file (if exist).

b. Previous exams administration:
Teacher can use this services to upload (add) the previous exams and their model answers for each subject, as shown in Figure 12.Also teacher can delete specific exam(s) from the database and can display the stored exams.
The teacher can store the following data for each previous exam: level name, subject name, exam type (midterm, final), exam title, exam date, exam file, and the exam answer file (if exist).

c. Exam administration:
Teachers can use this online tool to add, update, and delete questions and answers for their exams and quizzes.The questions are inserted into the database dynamically, so new questions can be added during the configuration of a exam or quiz, as shown in Figure 13.The teacher can store the following data for each exam/quiz: level name, subject name, chapter number, lesson number, quiz title, quiz type    and the teacher name (as input) from the available list of values, the system search for the required query, and displays all the stored exams from the database.c.On-Line Quiz: After a student login into the system from the student login page, he/she can select the quiz, where the questions will be selected randomly by our algorithm from the database.Our system covers many types of questions as mentioned before, such as: multiple choices, True/False, and fill in the blank.The quiz will be over either whenever the student finishes it and select the "Finish" button, or whenever a pre-allocated time will be over.The system will calculate the number of correct answers and display the result.Finally, the student score will be saved in the corresponding database for possible tracking, as shown in Figures 17  and 18.
The quiz is displayed based on question-byquestion methodology.A navigator is included so the student can go backward and forward over the questions in single steps.When the last question is reached, the student can go back to the previous one, and if the first question is reached, the student can go forward to the next questions.When the student finishes the quiz, a record will be created in the StudentScore table, and stored in the database.Teachers can consult this table to track the activities of their students.
V. SYSTEM EVALUATION To obtain some feedback about the "Questions-Bank" system, we have prepared a questionnaire and distribute it to the potential students registered in the system.Sixty students have been randomly selected to use as a testing pool.A group of 30 students have used the hard paper quiz (and review) and another similar group has used our web-based system.Table 2 shows that both groups obtained approximately similar results.Students had to obtain a grade of 60% to pass the quiz.After taking the quiz, all the students had to fill in a questionnaire with general and specific questions related to the method of testing.The most significant questions reflecting student opinion are set out in Table 3, with the relevant group responses.
The results of question 2 indicate that, independently of the method used, a vast majority of students want to know their grade as soon as possible as well as the correct answers.The results of question 5 indicate that, a large percentage of students who did not use the computer- based system felt that their marks would have been worse if a computer had been used.Similarly, question 4 shows that a percentage of student using computers felt that they might have done better using traditional methods.
Finally, the majority of the students trust more a computer-based evaluation system than classical methods.Some students did comment on the absence of printed copies of their answers and the fact that they could not compare their answers with the correct results after the quiz.

When do you prefer to be told your quiz score?
At the end 80 95 Later 20 5

How would you describe the process of entering answers in the computer?
Easy -75 Acceptable -22 Difficult -3 Very difficult -- VI.CONCLUSION AND FUTURE WORKS This paper describes the analysis, design, and implementation of the Questions-Bank system, that allows the students to take web-based quizzes and exams, to download course reviews, and previous exams.The system facilitates generation of automatic, balanced, and different exam sheets, that containing different types of questions, covering the entire curriculum, and displaying gradually from easiness to difficulty.The system allows the schools to create a Questions-Bank database that stores the exams questions, the previous exams, the model answers, the reviews, and useful exercises for each course.

How do you feel your result would have been, if the quiz had been on paper as the traditional way?
Today, Mobile learning (M-learning) can use a collection of tools that tutors and developers can combine to deliver their teaching resources, such as: SMS (text messaging) for skills test and for collecting feedback.Java-based quizzes.
Learning modules use on PDAs.Collection of pictures video using camera-phone.
We intend to improve our research work, that introduced in [11], by implementing the prototype "Mobile Questions-Bank" system (MQB), that provides the students to take wireless quizzes, wireless reviews, and wireless exams, as shown in Figures 19.
In order to develop the MQB system, three mobile technologies will be evaluated to use:

SMS (Short Messaging Service):
The questions could be sent to students via SMS messages, after which the students could reply with the answers via SMS messages.This approach is susceptible to delays because delivery times of SMS messages may vary greatly.When responding to a stream of questions, there is possibility of the SMS messages being duplicated or delivered out of sequence, causing errors in scoring.

WAP (Wireless Application Protocol):
The questions could be displayed in the student's mobile phone as a very simple Internet web page based on the WAP format.The student could then select the response using the mobile phones navigation keys.The questions and answers would be transmitted using GPRS (General Packet Radio Service) or 3G (3 rd .Generation) mobile data networks.However WAP generally offers an unfriendly user interface that may be confusing to students.When the mobile data transmission breaks due to network issues, it is not possible to recover from the error and show the student a helpful message.J2ME (Java 2 Micro Edition) and XML (eXtensible Markup Language): The student could download and install a small J2ME application that would interact with the server over the GPRS and 3G mobile data networks, fetching XML questions file and transmitting responses as XML answer file to the server.Unlike WAP, J2ME applications have full control over the mobile phone screen to ensure that the application looks and operates the same on any mobile phone.J2ME applications also have full control over the data transmission and can retransmit the data in case of error The system environment will be divided into two major blocks.The first one is the client side application, which developed by J2ME/JAVA with parser to read and write XML files.The second block is the server application, which developed by ASP.NET, C#.net, and XML database.Using this architecture will offer a great promise to combat the following defects related to the use of mobile devices: -Screen size limitation: J2ME applications have full control over the mobile phone screen to ensure that the application looks and operates the same on any mobile phone.
-Narrow network bandwidth: The student can connect to the network to browse and download the XML questions file, this file contains the quiz itself, so that, the student can disconnection with the server, and can connected back when he/she want to send the XML answers file.

-Small memory capacity and low computing power:
In order to combat this defect, we will develop the J2ME program and the transmitted XML file suitable to support wide ranges from mobile phones.

Figure 2 .
Figure 2. The V-model -software development process Static Class Diagram: An initial class diagram (also called the domain model) consists of class and object diagrams.It is a static model that furnishes a visual representation of the real-world concepts that are visible to the user not of software components.Elements of a domain model are classes and the relationships between them.It is widely used as a source of inspiration for designing software objects.

Figure 3 .
Figure 3.The three main users of the system a.Questions-Bank system allows the school administrator to: -Login (as administrator).-Chang account password -Get new password instead of the lost one.-Activate/Inactivate the system.

Figure 4 .
Figure 4. UML use case diagram

(
multiple choices, true or false, fill in the blank), question text, question image file, choice1, choice2, choice3, choice4, correct answer, question weight, question score, and question explanation.

TABLE II .
QUIZ RESULTS OF THE TWO GROUPS OF STUDENTS

TABLE III .
RESULTS OF THE QUESTIONNAIRES OF BOTH GROUPS