secondary project modified(2)

8/14/2019 Secondary Project Modified(2)

1/27


2/27

2

Contents

Acknowledgement...4

Abstract............5

Chapter1 : Introduction..............6Chapter 2 : Tools, Techniques and work environment72.1 Microsoft visual c# programming...8

2.2: ASP .NET ....8

2.3 ADO .NET.....9

2.4 Structured Query Language (SQL)....9

2.5 Stored procedure.......9

2.6 HTML....9

2.7 Microsoft Visual Studio 2005......10

2.8 Microsoft SQL server 2005.....10

Chapter 3 : project life cycle.....11

3.1 project description and requirement definition....11

3.2 implementation and unit testing.....12

3.3 system database ...........12

3.3.1: Auth table......13

3.3.2:Classes table...13

3.3.3: Exams table.......13

3.3.4: No questions table........13

3.3.5: Options table.....14

3.3.6: Questions table.....143.3.7: Result table...14

3.3.8: Start Exam table..........15

3.3.9: Student Answer table .....15

3.3.10: Student table..........15

3.3.11: Teacher table ....15

3.4: System operations .........16

3.4.1: Create Acount.........16

3.4.2: Login page...16

3.4.3: Teacher login.. ...18

3.4.3.1 : Class Management.............19

3.4.3.2: Student Mangement........20

3.4.3.3: Exam Management.21

3.4.3.4: Questions Management..22

3.4.3.5: Exam Result....22

3.4.3.6: Incomplete Exam24

Chapter 4:

Conclusion.......................30

References ...31


3/27

3

Figure 0.1: Final Result.5

Figure 3.3.1: System data base.12

Figure 3.4.1.1.16

Figure 3.4.2.A17

Figure 3.4.2.B18Figure 3.4.219

Figure 3.4.2.1.20

Figure 3.4.2.220

Figure 3.4.2.321

Figure 3.4.2.422

Figure 3.4.2.5.A23

Figure 3.4.2.5.B23

Figure 3.4.2.624Figure 3.4.3.1.A25

Figure 3.4.3.1.B25

Figure 3.4.3.2.A26

Figure 3.4.3.2.B26

Figure 3.4.3.2.C27


4/27

4

Acknowledgment

First we thank God and thanks any one provide any type of

help for us in front of them Eng. Safa'a Bataineh for her help andthe idea of the project then we thank Eng.Ahmad Al-omari for thehelp in programming and we thanks any doctor or student give anyhelp to us.


5/27

5

Abstract

Our project is about Online Exam System, built based on asp.net 2.0 with

C#. Online Exam System is applicable for any school or university.Thissystem can be used by Students, teachers, and administrator.

The students, teachers and administrators able to use this system ifthey have accounts, and then they can use this system by entering user nameand password in the main login page.

The administrator can add/delete/update teachers and specify thenumber of each question for each exam.

The teacher can add/delete/update student in each class and write theexam and activate the exam.

The student can solve the exam on the computer then he/she can seethe result and the ideal solution on the screen directly.

Online Exam System can calculate the summation of all exams gradesfor each student as shown in Figure 0.1: Final Result

Figure 0.1: Final Result


6/27

6

Introduction:

Online Exam System (OES) is a simple, elegant and powerful tool tohelp the student to take his exam and help the teacher to correct the exam.The traditional exam needs more time and effort from the teacher. (OES)more accurate than traditional exam because it is computer correction. (OES)can give many formats with different questions at the same time. It starts andends in limited time therefore it is fairer than old examand it is designed to

prevent the cheat during the exam.

To achieve goal we designed special techniques that would help student totake the exam in easy way.It helps the school to reduce the cost of the exam's tools.

Online Exam System will have the following functionality:

1- Creating account.3- Teachers put many question.

2- Students take Exam.4- Students get the result after end the exam.

In our work, we involve in software product, our responsibilities are todevelop this software Product from scratch using a standard programminglanguage like c#. This led us to apply software process using a set ofactivities (software specification, implementation, validation, evolution.).

Basically, we focused on waterfall (software life cycle) model on ourwork, so activities or phases were separated.

Chapter one


7/27

7

In this report we tried to cover and show all work in simple way aspossible as we can. In this introduction we will give a brief description ofeach part.

Firstly, tools, techniques and the work environment, we described all the

techniques which we used during the implementation of our project and weprovided example from our project to describe each of them.

Secondly, project life cycle, we described steps we follow duringdevelopment of our project, by showing different phases, setting out all

pages, their work and displaying the database details.

Thirdly, conclusion & further work shows our discussion, conclusion &further works behind this project.


8/27

8

.

Tools, Techniques and work environment

During our work on the project we used many tools and technique thatmakes it easy for us to complete the project successfully, we willdemonstrate them below.

2.1 Microsoft visual c# programming

C# is a new programming language created by Microsoft and introducedwith the release of Visual Studio .NET, it include an interactive developmentenvironment, visual studio designers for building windows and webapplication, a compiler, and a debugger.

2.2 ASP .NET

It is a part of Microsoft .NET platform, is e revolutionary programmingframework that enables the rapid development of enterprise-class Web

application .it provides the easiest and most scalable way to develop, and runweb application that can target any browser or device.

2.3 ADO .NET

Chapter two


9/27

9

ADO.NET is a large set of .NET classes for working with data thatenable us to retrieve and manipulate data , and update data sources , in verymany different ways.

2.4 Structured Query Language (SQL)

SQL is standard computer language for accessing and manipulatingdatabase.SQL statements are used to retrieve and update data in a database.

2.5 Stored procedure

A store procedure is a subroutine available to application accessing arelational database system, and stored in the database data dictionary.

2.6 HTML

It provides a means to describe the structure of textbased informationdocument- by denoting certain text as links, headings, paragraphs, lists andso on and to supplement that text with interactive forms, embeddedimages, and other object.

2.7 Microsoft Visual Studio 2005

Visual studio 2005 is tool-rich programming environment containing all thefunctionality. You'll need to create large or small c# projects.


10/27

10

2.8 Microsoft SQL server 2005

Microsoft SQL server 2005 is an environment used to create computerdatabase on Microsoft windows operating system .it can with small, mediumand large database.

Chapter three


11/27

11

Project Lifecycle

3.1 Project Description And Requirement DefinitionWe start our system development by specifying what the system should do,its essential and desirable properties . We met with some schools studentand Eng. Safa'a Bataineh provided us with requirements to develop thesystem the most important requirements are:1- Easy to use.2- User friendly.3- Browsing the question is simple.

5- Each student has one record.6- Each student has unique id and password.7- Each student must register in section.

These project is divided into two main parts :

1- Data base.

2- System operation.

*Administrator will be able to perform the following tasks :1- Specify the teacher for each class.2- Add\delete\update of teachers.3- Specify number of question for each exam.

3.2 Implementation And Unit TestingAccording to our system development we used the ASP.NET with c#

language application to implementation the system with .and we tested its

units individually with IE.


12/27

12

3.3 System Database :System data base design correspond to requirement specification , the

data base contains multiple tables with a relation between some of them asshown in the figure 3.3.1:

Figure 3.3.1: System data base

3.3.1: Auth Table.

This table contain information about the administrator .Auth tablecontains ID, UserName , Password and Name.


13/27

13

3.3.2: Classes Table.

This table contains information about the classes in the school. Classes

table contain ClassID , TeacherID (who study this class) , ClassName ,andBranch.

3.3.3:Exams Table

This table contains information about the exams that will be held inthis school. Exam table contain ExamID , ExamName , ClassID , Hours ,

Minuites and Active.This table is the most important table in this project, Hours and

Minuites indicate the times of the exam until finishesActive is very important flag in this table to gives that the exam is

ready to use by the students until prevent any student to enter the exam inirrelevant time.

3.3.4:NoQuestions Table

This table contains information about the number of questions foreach exam . NoQuestions table contain ID and numberofQuestions.

This table is created to give multiple format at the sametime.

3.3.5: Options Table

This table contains options for each questions in the exam . Optiontable contain OptionID , OptionTxt , QuestionID and Answer.

This table is created to give options for each questionuntil each student select the correct answer for each question.


14/27

14

3.3.6:Questions Table

This table contains number of questions for each exam. Questionstable contain QuestionID, QuestionTxt and Exams.

This table is used to store all the questions for all exams.

3.3.7:Result Table

This table contains the result for each student examines the exam.Result table contain ResultID , ElapsedTime , MarkResult , ExamID andStudentID.

This table is used to store the result for each student trythe exams.

3.3.8: StartExam Table

This table is used to display the students who take the exam but try tocheat in the exam by closing the browser and try to enter to the system othertime. In this table the teacher can know these students and the teacher able toallow him/her to restart the exam later. StartExam table containsStudentId ,UserName , StudentName , ClassID and Password.


15/27

15

3.3.910:StudentAnswers Table

This table is used to display the students answers who take the exam.This table might teacher and students to see the answer of the student.StudentAnswer table contains Id , StudentId and OptionId.

3.3.10:Students Table

This table is used to display the students who register in the class.Students table contains StudentId , UserName , StudentName , ClassID andPassWord.

3.3.11:Teachers Table

This table is used to display the teacher who teach in this school.Teachers table contains TeacherId , UserName , TeacherName andPassWord.

3.4: System Operation:

Finally we integrate program units and test it as a complete system toensue that the software requirements have been met.

before any thing the first item in the system is the master page that chosen

for the system this page is appear like this in each page with custom controlsthat used in that page content place holder used in the system this control


16/27

16

used for customize each form with this special controls and format and everything else is shared between the pages.

3.4.1: Create Account On The System:

TheAdministrator

firstly login into this system by entering user nameand password that were saved in Auth Table in the Data Base. Theadministrator has many properties () such as Add, delete and updateteacher and can upload teacher name from specific location by using ()

button and specify the number of the questions of each exam in the system.

Figure 3.4.1.1

3.4.2: Login Page

Thestudent and teacherlogin into this system by entering user nameand password. To select students or teachers entrance they must firstly selectteachers or students then they enter user name and password in the login form

as shown in Figure 3.4.2.A and Figure 3.4.2.B.


17/27

17

Figure 3.4.2.A

Figure 3.4.2.B


18/27

18

3.4.3: Teacher Login:After the teacher successfully login to his /her Account on the system

the following page is displayed as shown on Figure 3.4.2 then the teachercan select multiple choice in his/her page as you can see below:

Figure 3.4.2

3.4.3.1: Class Management:


19/27

19

In this page the teacher can add, delete and update the classes in

this system and gives the name for each class as shown in Figure 3.4.2.1.

Figure 3.4.2.1

3.4.3.2: Student Management:In this page the teacher can add, delete and update the students in

this system as shown in Figure 3.4.2.2.

Figure 3.4.2.2


20/27

20

3.4.3.3: Exam Management:In this page the teacher can add, delete and update the exam and

specify the time of each exam in this system as shown in Figure 3.4.2.3.

Figure 3.4.2.3


21/27

21

3.4.3.4: Questions Management:In this page the teacher can add, delete and update the questions in

each exam of any class that teacher has as shown in Figure 3.4.2.4.

Figure 3.4.2.4

3.4.3.5: Exam Result:

In this page the teacher can see the result of the students and numberof students who passed and failed in the exam and percentage in this exam asshown in Figure 3.4.2.5.A The teacher can see the result of the students by

pressing () button then the teacher can see the result as shown inFigure 3.4.2.5.B.


22/27

22

Figure 3.4.2.5.A

Figure 3.4.2.5.B


23/27

23

3.4.3.6: In Complete Exam:

This page is used to display the students who take the exam but try tocheat in the exam by closing the browser and try to enter to the system other

time. In this page the teacher can know these students and the teacher able toallow him/her to restart the exam later as shown in Figure 3.4.2.6.

Figure 3.4.2.6

3.4.4: Student Login:


24/27

24

Firstly, the student select student domain the enter the user name and

password as shown in Figure 3.4.3.1.A

Figure 3.4.3.1.A

After the student successfully login to his /her Account on the systemthe following page is displayed as shown on Figure 3.4.3.1.B then the

student can select multiple choice in his/her page as you can see below:

Figure 3.4.3.1.B


25/27

25

3.4.4.1: Questions Page:

Firstly, the student must select exam name from the list thenpressstart examas shown in Figure 3.4.3.2.A.

Figure 3.4.3.2.A

After this, the student can enter to the exam and try to solve this examas shown in Figure 3.4.3.2.B

Figure 3.4.3.2.B

When the student finishes the exam, the student can see the result and

elapsed time and the correct answers as shown in Figure 3.4.3.2.C


26/27

26

Figure 3.4.3.2.C

Chapter Four


27/27

Conclusion:Using Online Exam System will be reduce many problems that which appearusing traditional method

Online Exam System is a simple, elegant and powerful tool to helpthe student to take his exam and help the teacher to correct the exam. Thetraditional exam needs more time and effort from the teacher. (OES) moreaccurate than traditional exam because it is computer correction.

To achieve goal we designed special techniques that would helpstudent to take the exam in easy way and it helps the school to reduce thecost of the exam's tools.

Online Exam System has the following functionality:

1- Creating account.3- Teachers put many question.2- Students take Exam.4- Students get the result after end the exam.

secondary project modified(2)

Documents