elearning doc table of content

8/6/2019 eLearning Doc Table of Content

1/105

1. INTRODUCTION

1.1 About the project

E-learning is another form of distance learning where education and training courses are

delivered using computer technology. Typically, this means that courses are deliveredeither via the Internet, or on computer networks (linked computers). With the increased

availability of PCs and Internet access, e-learning is becoming more and more popular.

E-Learning is a web application uses JSP. The database is Microsoft Access 2007. This online

application enables the end users to register online, select the subject, read the tutorial

and appear for the exam online. The results of the exams are also declared just after taking

the test. The minimum pass percentage is 50%. A person is given three attempts to pass a

paper. In subjects containing more than one exam, the candidate should take tests in a

particular sequence and also he can attempt the next test only if he has completed the

previous papers. The correct answers for the questions are displayed after the exam. The

date of the registration, date of exam, number of attempts, test results etc. are stored in

the database.

1.2 Purpose of the project

Education through the internet, network and a computer is e-Learning. This helps in

network enabled transfer of skills and knowledge. e-Learning refers to use of electronic

applications and processes to learn. This is a web based application which can be hosted in

the website of any training institute. The students will be able to register online, read the

course material and write online exam. Certificates also will be issued online.

The objectives of this project are

to provide distance learning

to make it convenient for people who have other commitments

cost reduction

reduced paper work

computer evaluated tests

1.3 Understanding of existing system

Show educators and trainers how to adapt teaching methods and materials to make use ofthe Internet. Including a framework showing how to apply Internet technology

progressively as skills and confidence grow, the project demonstrates the route from

adapting materials to developing a virtual course.

Nowadays, when people are not having time to visit an institute. Therefore, the software is

designed to provide the education through Internet. The project e-Learning helps the

common world in any field they are to get the knowledge what they want even sitting at


2/105

their places. This helps them to spare time in their busy schedule and save their time

during transportation.

1.4 Tools/Environment Used

HARDWARE REQUIREMENTS

Processor: Pentium III/IV (Preferably P-IV)

RAM: 256 MB

SOFTWARE REQUIREMENTS

Web Server: Apache Tomcat Server

0perating System: Windows ME/2000/XP/UNIX

Language: JSP (JAVA Server Pages), HTML

Database: MS Access 2007

2. SOFTWARE DESCRIPTION

2.1 Apache Tomcat Server

Apache Tomcat (or Jakarta Tomcat or simply Tomcat) is an open source servlet container

developed by the Apache Software Foundation (ASF). Tomcat implements the Java Servlet

and the JavaServer Pages (JSP) specifications from Sun Microsystems, and provides a "pure

Java" HTTP web server environment for Java code to run.

Tomcat should not be confused with the Apache web server, which is a C implementation

of an HTTP web server; these two web servers are not bundled together. Apache Tomcatincludes tools for configuration and management, but can also be configured by editing

XML configuration files.

Tomcat Server has 3 main parts.

1. Catalina2. Coyote3. Jasper

Catalina is the Tomcat Servlet container.It implements the Sun Microsystems

specifications for the Java Server Pages and servlets.

Coyote is the HTTP connector of the Tomcat server.Which gets the request from TCP

specified port and forward them to Tomcat server to process and also gets the response

from server and send them to client,this is Coyotes basic job in Tomcat Server.

Jasper is a Java Server Page engine of the Tomcat Server.Actually it is now called Jasper 2

because there is a new specification on Java Server Pages side by Sun.Jasper parses JSP files
http://en.wikipedia.org/wiki/Open_sourcehttp://en.wikipedia.org/wiki/Java_Servlet#Servlet_containershttp://en.wikipedia.org/wiki/Apache_Software_Foundationhttp://en.wikipedia.org/wiki/Java_Servlethttp://en.wikipedia.org/wiki/JavaServer_Pageshttp://en.wikipedia.org/wiki/Sun_Microsystemshttp://en.wikipedia.org/wiki/Java_%28programming_language%29http://en.wikipedia.org/wiki/Hypertext_Transfer_Protocolhttp://en.wikipedia.org/wiki/Web_serverhttp://en.wikipedia.org/wiki/Java_%28programming_language%29http://en.wikipedia.org/wiki/Apache_HTTP_Serverhttp://en.wikipedia.org/wiki/C_%28programming_language%29http://en.wikipedia.org/wiki/XMLhttp://en.wikipedia.org/wiki/XMLhttp://en.wikipedia.org/wiki/C_%28programming_language%29http://en.wikipedia.org/wiki/Apache_HTTP_Serverhttp://en.wikipedia.org/wiki/Java_%28programming_language%29http://en.wikipedia.org/wiki/Web_serverhttp://en.wikipedia.org/wiki/Hypertext_Transfer_Protocolhttp://en.wikipedia.org/wiki/Java_%28programming_language%29http://en.wikipedia.org/wiki/Sun_Microsystemshttp://en.wikipedia.org/wiki/JavaServer_Pageshttp://en.wikipedia.org/wiki/Java_Servlethttp://en.wikipedia.org/wiki/Apache_Software_Foundationhttp://en.wikipedia.org/wiki/Java_Servlet#Servlet_containershttp://en.wikipedia.org/wiki/Open_source


3/105

and send them to Catalina to compile them as servlets and jasper can detect pages if it is

JSP page or not.

2.2 Operating System Windows XP

Windows XP is a computer operating system which was released by Microsoft in 2001. Since that

time Windows XP became the predominant operating system run on Windows based PCs, and

remains an extremely popular platform despite the release of its supposed successor to Windows

Vista. Windows XP has several notable advantages over other operating systems.

2.2.1 Universality

Windows operating systems are used on PCs all around the world, and Windows XP is the

most common platform. By being familiar with Windows XP, a user will be equipped to use

computers while traveling, and potentially be able to receive help with a Windows XP

based portable device. The Windows XP platform is also extremely popular in business, and

strong PC skills are becoming an increasingly important part of productivity.

2.2.2 Support

One of the best parts of Windows XP is that due to its widespread use and popularity, there

is a wealth of support information available. Not only does Microsoft itself host detailed

support information, but many other websites are full of message boards frequented by

tech gurus who are experts with Windows XP and are often willing to help novices

troubleshoot any problem they might have.

2.2.3 Software

Another important advantage of Windows XP is the huge amount of useful software

available on the platform. Microsoft Office products are particularly useful, as they are

used extensively in academics and business. Windows XP is also very strong when it comes

to running game software. Almost all computer games are designed to work with Windows

XP, while many will not run on Macintosh or other platforms. The number of shareware

and freeware programs available for XP is huge compared to non-Windows operating

systems.

2.2.4 Memory Use

One of the main gripes of PC users with Windows Vista is that Vista tends to favor

flashiness over function. Vista has a slick-looking user interface and graphical effects that

make the operating system look cool, but ultimately slow down performance. The random

access memory use of Windows XP while idling can be less than half that of Windows Vista,

and for many programs recommends that Vista users have more RAM installed due to this

memory hungry interface. For this reason, many Vista users actually "downgrade" to

Windows XP.
http://www.ehow.com/about_5057057_benefits-windows-xp.htmlhttp://www.ehow.com/about_5057057_benefits-windows-xp.htmlhttp://www.ehow.com/about_5057057_benefits-windows-xp.htmlhttp://www.ehow.com/about_5057057_benefits-windows-xp.html


4/105

2.2.5 Driver Availability

An important advantage that Windows XP has over many other operating systems is the

widespread availability of hardware driver support. Hardware devices, such as video cards

and sound cards, need software called "drivers" to tell the operating system how to use

them. Since Windows XP is so widespread, drivers for Windows XP are readily available for

download online for almost any new hardware device. In addition, driver updates arereleased constantly for Windows XP, while updates may not be released as regularly under

other platforms.

2.2.6 WLAN features

The most valuable enhancement in Windows XP is the way that it intuitively handles

802.11b wireless LAN connectivity. In the current market, WLANs involve a patchwork of

vendors, equipment, drivers, software, and security mechanisms. This can often lead to

confusion and difficulty in setting up and administering WLANs, or even worse, to security

lapses that can compromise networks.

However, Windows XP is very WLAN savvy, streamlining WLAN configuration and security

and making it much easier for users to roam between WLANs. Windows XP includes the

Wireless Zero Configuration service, and Microsoft has partnered with 802.11b NIC

vendors so that their NIC drivers are automatically part of this service.

Thus, upon loading XP, the operating system automatically recognizes most wireless NICs.

Then the system automatically goes out and looks for available WLAN networks and lists

the networks it finds. Of course, new wireless configuration tabs in the networking applet

will allow an administrator to set a list of preferred WLANs, and the NIC will automaticallyconnect to those in the order specified. Obviously, this has excellent implications for

roaming wireless LAN users.

Windows XP also steps up WLAN security by simplifying WEP configuration and integrating

and documenting RADIUS support on WLANs as a way of keeping wireless attackers at bay.

All in all, these features represent an outstanding improvement that could help propel

WLAN implementations. This is the one area where Windows XP Professional provides a

major advantage over Windows 2000 Professional. Nearly everyone using a laptop running

Windows to connect to a WLAN in a corporate environment will want to upgrade their

machine to Windows XP Professional as long as the laptop has enough processing power

and RAM.

2.2.7 System Restore and Device Driver Rollback

The System Restore is another unique Windows XP feature that will benefit Windows 2000
http://www.microsoft.com/technet/treeview/default.asp?url=/TechNet/prodtechnol/winxppro/reskit/prdc_mcc_kqmu.asphttp://news.zdnet.com/ht%3C/span%3Etp:/techupdate.cnet.com/enterprise/0-9500-721-235517.htmlhttp://www.microsoft.com/WINDOWSXP/pro/using/howto/gethelp/systemrestore.asphttp://www.microsoft.com/WINDOWSXP/pro/using/howto/gethelp/systemrestore.asphttp://news.zdnet.com/ht%3C/span%3Etp:/techupdate.cnet.com/enterprise/0-9500-721-235517.htmlhttp://www.microsoft.com/technet/treeview/default.asp?url=/TechNet/prodtechnol/winxppro/reskit/prdc_mcc_kqmu.asp


5/105

Pro desktops. Windows Me first introduced System Restore, which allows you to take the

OS back to an earlier state. I was a bit skeptical when I first heard of this feature, but when

I actually used it for the first time in Windows Me (after a downloaded piece of rogue

software brought down a machine that I was managing), I was amazed at how well it

worked. In fact, my jaw dropped and I had a look of "you've got to be kidding me" on my

face when I realized how easy it was go back to an earlier version of the system software

that was working smoothly.

Smaller organizations that do not have the resources to thoroughly test new programs on a

test network sandbox before installing them on desktop machines will benefit from

increased productivity that can be gained with this feature. Although the feature is

included in Windows Me, Windows XP Professional is a much more stable OS. If you want

this feature in a business environment, definitely upgrade to Windows XP Pro rather than

to Windows Me.

Similar to System Restore, Device Driver Rollback is a new feature that is unique to

Windows XP and allows you to go back to an earlier version of a device driver if you are

having problems with a newly installed driver (which, unfortunately, is a common

occurrence). This feature is nicely integrated into the Properties sheet of each device and,

like System Restore, provides a quick and easy way to compensate for the kinds of

software conflicts that have caused administrators a lot of headaches in the past.

2.2.8 Remote Desktop and Remote Assistance

Remote Desktop is a highly touted new feature that allows you to connect to your

Windows XP Professional computer from another Windows machine. This can be especially

useful if you want to connect to your office computer from your home computer in orderto access the same applications and systems you access from work. Of course, you would

first have to connect to the corporate LAN using a dial-up or VPN connection.

Essentially, Remote Desktop is a built-in version of remote access software such as

pcAnywhere or LapLink, although it does not contain many of the advanced features of

these programs. Nevertheless, Remote Desktop is fast, efficient, and easy to use. The

technology is based on Windows Terminal Services, and any Windows client running the

Terminal Services client software can access the Windows XP Pro machine once you set it

up to utilize the Remote Desktop feature and set up the appropriate access permissions.

Remote Assistance is a related feature that allows an end user running Windows XP

Professional to get advanced technical support. A user simply goes to Start | Help |

Support | Remote Assistance and can then use e-mail or Windows Messenger to contact a

technician. They can even browse using Windows Messenger to see a list of technicians

who are online. Once connected with a technician, who can now see the user's desktop,

the user can have a chat (or a voice call if both computers have microphones and
http://www.microsoft.com/WindowsXP/home/using/howto/gethelp/driverrollback.asphttp://www.microsoft.com/WINDOWSXP/pro/using/howto/gomobile/remotedesktop/enableremote.asphttp://www.microsoft.com/WINDOWSXP/pro/techinfo/administration/adminra/default.asphttp://www.microsoft.com/WINDOWSXP/pro/techinfo/administration/adminra/default.asphttp://www.microsoft.com/WINDOWSXP/pro/using/howto/gomobile/remotedesktop/enableremote.asphttp://www.microsoft.com/WindowsXP/home/using/howto/gethelp/driverrollback.asp


6/105

speakers), can send a file, or can release control of the computer so that the technician can

work on it remotely.

Many large organizations already have advanced help desk software that can perform

many of these same functions (and more). However, small and medium-size businesses

that do not yet have this kind of functionality or are considering implementing it may find it

much easier and less expensive to simply upgrade their desktop clients to Windows XPProfessional and take advantage of Remote Assistance than it would be to implement an

elaborate piece of help desk software.

2.2.9 Client firewall

Windows XP now comes with its own Internet Connection Firewall built into the

networking functionality of all network interfaces. It is accessed from the Properties applet

of any network interface by simply clicking the Advanced tab, activating the firewall, and

customizing the settings.

Client machine firewalls are definitely the next frontier in securing corporate networks.

These firewalls are especially important for laptop and remote users who connect over the

Internet since attackers can get an easy ride into a corporate network by hijacking one of

these potentially easy targets.

The built-in firewall in Windows XP is easy to configure while providing some advanced

filtering and logging capabilities. It is more than adequate for most organizations, although

it does not contain some of the more robust features of a product such as ZoneAlarm Pro.

While the desktop firewall alone does not provide justification for upgrading to WindowsXP Pro, organizations that are currently considering a desktop firewall rollout may consider

upgrading to Windows XP if they can also directly benefit from some of the other features

listed above.

2.3 Microsoft Access Database

Microsoft Access is a relational database management system from Microsoft that combines the

relational Microsoft Jet Database Engine with a graphical user interface and software development

tools. It is a member of the Microsoft Office suite of applications, included in the Professional and

higher editions or sold separately. The current versions are Microsoft Office Access 2007 for

Windows. In late 2009, Microsoft released the beta version of Microsoft Access 2010.

Microsoft Access is used to create simple database solutions. Access tables support a

variety of standard field types, indices, and referential integrity. Access also includes a

query interface, forms to display and enter data, and reports for printing. The underlying

Jet database, which contains these objects, is multiuser-aware and handles record-locking

and referential integrity including cascading updates and deletes.
http://www.microsoft.com/WINDOWSXP/home/using/howto/homenet/icf.asphttp://techupdate.cnet.com/enterprise/0-6133457-720-20109490.htmlhttp://www.answers.com/topic/relational-database-management-system-2http://www.answers.com/topic/microsofthttp://www.answers.com/topic/microsoft-jet-database-enginehttp://www.answers.com/topic/guihttp://www.answers.com/topic/microsoft-officehttp://www.answers.com/topic/databasehttp://www.answers.com/topic/index-databasehttp://www.answers.com/topic/referential-integrityhttp://www.answers.com/topic/queryhttp://www.answers.com/topic/guihttp://www.answers.com/topic/microsoft-jet-database-enginehttp://www.answers.com/topic/lock-databasehttp://www.answers.com/topic/event-cascadehttp://www.answers.com/topic/updatehttp://www.answers.com/topic/delete-sqlhttp://www.answers.com/topic/delete-sqlhttp://www.answers.com/topic/updatehttp://www.answers.com/topic/event-cascadehttp://www.answers.com/topic/lock-databasehttp://www.answers.com/topic/microsoft-jet-database-enginehttp://www.answers.com/topic/guihttp://www.answers.com/topic/queryhttp://www.answers.com/topic/referential-integrityhttp://www.answers.com/topic/index-databasehttp://www.answers.com/topic/databasehttp://www.answers.com/topic/microsoft-officehttp://www.answers.com/topic/guihttp://www.answers.com/topic/microsoft-jet-database-enginehttp://www.answers.com/topic/microsofthttp://www.answers.com/topic/relational-database-management-system-2http://techupdate.cnet.com/enterprise/0-6133457-720-20109490.htmlhttp://www.microsoft.com/WINDOWSXP/home/using/howto/homenet/icf.asp


7/105

Simple tasks can be automated through macros with point-and-click options. Microsoft

Access is very popular among non-programmers who can create visually pleasing and

relatively advanced solutions on their own. It is also easy to place a database on a network

and have multiple users share and update data without overwri ting each others work.

Data is locked at the record level which is significantly different from Excel which locks the

entire spreadsheet.

2.3.1 Features

Users can create tables, queries, forms and reports, and connect them together with

macros. Advanced users can use VBA to write rich solutions with advanced data

manipulation and user control.

The original concept of Access was for end users to be able to access data from any

source. Other uses include: the import and export of data to many formats including Excel,

Outlook, ASCII, dBase, Paradox, FoxPro, SQL Server, Oracle, ODBC, etc. It also has the ability

to link to data in its existing location and use it for viewing, querying, editing, andreporting. This allows the existing data to change and the Access platform to always use

the latest data. It can perform heterogeneous joins between data sets stored across

different platforms. Access is often used by people downloading data from enterprise level

databases for manipulation, analysis, and reporting locally.

There is also the Jet Database format (MDB or ACCDB in Access 2007) which can contain

the application and data in one file. This makes it very convenient to distribute the entire

application to another user, who can run it in disconnected environments.

One of the benefits of Access from a programmer's perspective is its relative compatibility

with SQL (structured query language) queries can be viewed graphically or edited as SQLstatements, and SQL statements can be used directly in Macros and VBA Modules to

manipulate Access tables. Users can mix and use both VBA and "Macros" for programming

forms and logic and offers object-oriented possibilities. VBA can also be included in

queries.

Microsoft Access offers parameterized queries. These queries and Access tables can be

referenced from other programs like VB6 and .NET through DAO or ADO. From Microsoft

Access, VBA can reference parameterized stored procedures via ADO.

The desktop editions ofMicrosoft SQL Server can be used with Access as an alternative to

the Jet Database Engine. This support started with MSDE (Microsoft SQL Server Desktop

Engine), a scaled down version of Microsoft SQL Server 2000, and continues with the SQL

Server Express versions of SQL Server 2005 and 2008.

Microsoft Access is a file server-based database. Unlike client-server relational database

management systems (RDBMS), Microsoft Access does not implement database triggers,
http://www.answers.com/topic/point-and-clickhttp://www.answers.com/topic/lock-databasehttp://www.answers.com/topic/rowhttp://www.answers.com/topic/microsoft-excel-2003http://www.answers.com/topic/lock-computer-sciencehttp://www.answers.com/topic/macro-computer-sciencehttp://www.answers.com/topic/visual-basic-for-applicationshttp://www.answers.com/topic/misuse-of-statisticshttp://www.answers.com/topic/misuse-of-statisticshttp://www.answers.com/topic/microsoft-excel-2003http://www.answers.com/topic/microsoft-outlook-2004http://www.answers.com/topic/asciihttp://www.answers.com/topic/dbasehttp://www.answers.com/topic/paradox-databasehttp://www.answers.com/topic/foxpro-1http://www.answers.com/topic/microsoft-sql-serverhttp://www.answers.com/topic/oracle-databasehttp://www.answers.com/topic/open-database-connectivityhttp://www.answers.com/topic/heterogeneity-1http://www.answers.com/topic/joinhttp://www.answers.com/topic/enterprise-softwarehttp://www.answers.com/topic/enterprise-softwarehttp://www.answers.com/topic/microsoft-jet-database-enginehttp://www.answers.com/topic/sqlhttp://www.answers.com/topic/query-languagehttp://www.answers.com/topic/guihttp://www.answers.com/topic/modular-programminghttp://www.answers.com/topic/object-oriented-programminghttp://www.answers.com/topic/parameter-computer-sciencehttp://www.answers.com/topic/visual-basichttp://www.answers.com/topic/net-frameworkhttp://www.answers.com/topic/data-access-objectshttp://www.answers.com/topic/activex-data-objectshttp://www.answers.com/topic/desktop-environmenthttp://www.answers.com/topic/microsoft-sql-serverhttp://www.answers.com/topic/microsoft-jet-database-enginehttp://www.answers.com/topic/msdehttp://www.answers.com/topic/sql-server-expresshttp://www.answers.com/topic/sql-server-expresshttp://www.answers.com/topic/file-serverhttp://www.answers.com/topic/client-serverhttp://www.answers.com/topic/relational-database-management-system-2http://www.answers.com/topic/relational-database-management-system-2http://www.answers.com/topic/triggerhttp://www.answers.com/topic/triggerhttp://www.answers.com/topic/relational-database-management-system-2http://www.answers.com/topic/relational-database-management-system-2http://www.answers.com/topic/client-serverhttp://www.answers.com/topic/file-serverhttp://www.answers.com/topic/sql-server-expresshttp://www.answers.com/topic/sql-server-expresshttp://www.answers.com/topic/msdehttp://www.answers.com/topic/microsoft-jet-database-enginehttp://www.answers.com/topic/microsoft-sql-serverhttp://www.answers.com/topic/desktop-environmenthttp://www.answers.com/topic/activex-data-objectshttp://www.answers.com/topic/data-access-objectshttp://www.answers.com/topic/net-frameworkhttp://www.answers.com/topic/visual-basichttp://www.answers.com/topic/parameter-computer-sciencehttp://www.answers.com/topic/object-oriented-programminghttp://www.answers.com/topic/modular-programminghttp://www.answers.com/topic/guihttp://www.answers.com/topic/query-languagehttp://www.answers.com/topic/sqlhttp://www.answers.com/topic/microsoft-jet-database-enginehttp://www.answers.com/topic/enterprise-softwarehttp://www.answers.com/topic/enterprise-softwarehttp://www.answers.com/topic/joinhttp://www.answers.com/topic/heterogeneity-1http://www.answers.com/topic/open-database-connectivityhttp://www.answers.com/topic/oracle-databasehttp://www.answers.com/topic/microsoft-sql-serverhttp://www.answers.com/topic/foxpro-1http://www.answers.com/topic/paradox-databasehttp://www.answers.com/topic/dbasehttp://www.answers.com/topic/asciihttp://www.answers.com/topic/microsoft-outlook-2004http://www.answers.com/topic/microsoft-excel-2003http://www.answers.com/topic/misuse-of-statisticshttp://www.answers.com/topic/misuse-of-statisticshttp://www.answers.com/topic/visual-basic-for-applicationshttp://www.answers.com/topic/macro-computer-sciencehttp://www.answers.com/topic/lock-computer-sciencehttp://www.answers.com/topic/microsoft-excel-2003http://www.answers.com/topic/rowhttp://www.answers.com/topic/lock-databasehttp://www.answers.com/topic/point-and-click


8/105

stored procedures, or transaction logging. Access 2010 (not released) does have table level

triggers and stored procedures built into the ACE data engine.

3. SYSTEM DEVELOPMENT LIFE CYCLE
http://www.answers.com/topic/stored-procedurehttp://www.answers.com/topic/transaction-loghttp://www.answers.com/topic/transaction-loghttp://www.answers.com/topic/stored-procedure


9/105

The methodology used for developing this system is PROTOTYPING MODEL. This model isused here because detailed input, output requirements are not present in the beginning,

and thus it is felt that a prototyping model will be more suitable for development. In this

model, we will create a quick design and then invite user to test the developed system and

refine requirements if any. Thus, the process for development will be iterative.

Often, a customer defines a set of general objectives for software but does not identify

detailed input, processing or output requirements. In other cases, the developer may be

unsure of the efficiency of an algorithm, the adaptability of an operating system, or the

form that human/machine interaction should take.

In these, and many other situations, a prototyping model offers the best approach.

It generally has the following steps: Requirement Gathering Quick Design Build Prototype Customer Evaluation Review/Modify Requirements


10/105

Coding Testing

4. REQUIREMENT ANALYSIS PHASE

4.1 Feasibility study

This part or aspect of systems analysis that concentrates on finding out whether an

intended course of action violates any constraints is referred to as FEASIBILITY analysis .All

the projects are feasible given unlimited resources and infinite time! Unfortunately, the

development of a computer based system or product is more likely beleaguered by

scarcity of evaluate the feasibility of a project at the earliest possible time of project

inception.

4.1.1 Technical Feasibility-:

Technical feasibility centers on the existing computer system (hardware,software,etc.) and

on the extent it can support the proposed addition . Financial considerations have to be

taken into account for technical enhancements. In short the study of function,

performance, and constraints that may affect the ability to achieve an acceptable system. If

the budget is a serious constraint, then the project is judge not feasible .This project is

considered technically feasible for development.

4.1.2 Economical Feasibility-:

Economic analysis is the most frequently used method for evaluation the effectiveness of a

candidate system. More commonly known as cost/benefit analysis, the procedure is to

determine the benefits and savings that are expected from candidate system and compare

them with costs. If benefits outweigh costs then the decision.

4.1.3 Operational Feasibility-:

Operational Feasibility is reviewed in the early stages of project planning. Proposed project

is beneficial only if it can be turned into information systems that will meet theorganizations operational requirement. In the operational feasibility it is checked if the

system will work, when it is developed and deployed which are major barriers to the

development a consideration about the working of the system after installation in the

organization.

The software, which is developed, has an interactive, user-friendly interface, so operational

difficulties are almost eliminated. It will improve the performance after implementation as


11/105

the information can be delivered to the destination with utmost security. Hence the project

is considered operationally feasible.

5. ER-DIAGRAM

5.1 ER-Diagram

5.2 Class Diagram


12/105

5.3 Table Structure


13/105

tblResults

Field Name Data Type

course_id Number

trainee_id Text

Marks Number

qn1 Number

qn2 Number

qn2 Number

ans1 Number

ans2 Number

ans3 Number

paper_id Number

Attempt_id Number

Result Number

tblCategory


Course_category_id Number

Course_category Text

tblCourses


Course_id NumberCourse_category_id Number

Course_name Text

Course_description Text

No_of_papers Number


14/105

tblPapers


Paper_id Numbe

Paper_no Number

Paper_name Text

Course_id Number

Paper_description Text

tblDocuments


Document_id Number

Paper_id Number

Paper_no Number

Document_name Text

Document_filename Text

Document_description Text

tblQuestions


Paper_id Number

Question_id Number

Question Text

Choice1 Text

Choice2 Text

Choice3 Text

Choice4 Text

Ans Number


15/105


16/105

Paper1_completed_date Date



Paper_id1 Number

Paper_id2 Number

Paper_id3 Number

Is_paper1_completed Number



Paper1_appeared_on Date



Is_paper1_tutorial_viewed Number



No_of_papers Number

6. CODING

dbConnectiion.jsp/********************/

Header.jsp/*************/


17/105

e-Learning :: The world's largest e-learning site

Topmenu.jsp

HomeAbout UsTutorialsQuizzesDownloads

UsefullLink

TestimonialsContact Us

Registration

Bookmark

Footer.jsp/***************/

Home |About Us |Tutorials |Quizzes |

Downloads |Usefull

Link |Testimonials |Contact Us

&copy eLearning - 2011. All Rights

Reserved.Designed by Lopzang Dorji


18/105

Index.jsp/***********/

Why e-Learning?

Advantages ....

E-learning is a way of educating peopleelectronically. The essential elements of learning remain the same nomatter what the method of education. Elearning, just like its traditional

classroom counterpart, is a means of guiding a student from the basicsthrough to more advanced concepts in a particular subject. It is a step-by-step guide through a course, if you will. In a traditional setting, itis up to the teacher to lead students through the material. Unfortunately,having a class being led through, the course can only go as fast as itsslowest member. While e-learning is also a guided tour through a subject,it is primarily student-driven, rather than instructor led. The advantageof that is the course will go at each individual students pace, thereby

facilitating more actual learning.

readmore

Testimonials03This eLearning website is very usefull

and informative. It helped me a lot and even we get each and every stephow to proced with it...

So i would like recommend you all to visit this site and start learning.

....T. PheriryDetails


19/105

Js_function.js/***************//* Signup validation */function fnValidateSignup(){

if(document.signup.trainee_name.value==""){alert("Enter your name.");

document.signup.trainee_name.focus();return false;

}if(document.signup.email.value==""){

alert("Enter your Email Id.");document.signup.email.focus();return false;

}if(document.signup.user_name.value==""){

alert("Enter username.");document.signup.user_name.focus();return false;

}

if(document.signup.pass_word.value==""){alert("Enter Password");document.signup.pass_word.focus();return false;

}if(document.signup.retype_pass.value==""){

alert("Retype Password");document.signup.retype_pass.focus();return false;

}if(document.signup.pass_word.value!=document.signup.retype_pass.valu

e){alert("Password did not match");return false;

}}

/* Login Validation */function fnValidateLogin(){

if(document.login.user_name.value==""){alert("Enter your user name.");return false;

}if(document.login.pass_word.value==""){

alert("Enter your Password.");return false;

}}

/* Page BookMark option */function bookmark(url, sitename){

ns="Netscape and FireFox users, use CTRL+D to bookmark this site."if ((navigator.appName=='Microsoft Internet Explorer') &&

(parseInt(navigator.appVersion)>=4)){


20/105

window.external.AddFavorite(url, sitename);}

else if (navigator.appName=='Netscape'){

alert(ns);}

}

Style.css/************/@charset "utf-8";/* CSS Document */body{

margin:0px;padding:0px;background-image:url(images/bg.jpg);background-repeat:repeat-x;background-color:#bbcd72;

}h1,h2,h3,h4,h5,h6,span{

margin:0px;

padding:0px;}#main{

width:904px;float:none;margin:0 auto;padding:0px;}

#contentbg{width:904px;float: left;margin:0px;padding:0px;background-image:url(images/contenttxtbg.jpg);background-repeat: repeat-y;

}#contenttxtblank{

width:866px;float: left;margin:0px;padding:0 0 40px 38px;background-image:url(images/contentbg.jpg);background-repeat:no-repeat;

}#contenttxtblank_1{

width:866px;float: left;margin:0px;

padding:0 0 40px 38px;background-image:url(images/contentbg_login.jpg);background-repeat:no-repeat;


width:866px;float: left;margin:0px;padding:0 0 40px 38px;background-image:url(images/contentbg_aboutus.jpg);


21/105

background-repeat:no-repeat;}#contenttxtblank_3{

width:866px;float: left;margin:0px;padding:0 0 40px 38px;background-image:url(images/contentbg_tutr.jpg);


width:866px;float: left;margin:0px;padding:0 0 40px 38px;background-image:url(images/contentbg_quiz.jpg);background-repeat:no-repeat;


width:866px;float: left;

margin:0px;padding:0 0 40px 38px;background-image:url(images/contentbg_dl.jpg);background-repeat:no-repeat;


width:866px;float: left;margin:0px;padding:0 0 40px 38px;background-image:url(images/contentbg_lk.jpg);background-repeat:no-repeat;


width:866px;float: left;margin:0px;padding:0 0 40px 38px;background-image:url(images/contentbg_tm.jpg);background-repeat:no-repeat;


width:866px;float: left;margin:0px;padding:0 0 40px 38px;background-image:url(images/contentbg_ca.jpg);


width:866px;float: left;margin:0px;padding:0 0 40px 38px;background-image:url(images/html.jpg);background-repeat:no-repeat;



22/105

width:866px;float: left;margin:0px;padding:0 0 40px 38px;background-image:url(images/usrf_bg.jpg);background-repeat:no-repeat;

}#menu{

width:828px;height:30px;float: left;margin:0px;padding:0px;

}#menu ul{

width:778px;height:30px;float: left;margin:0px;padding:0 0 0 50px;display:block;

}#menu ul li{height:30px;float: left;margin:0px;padding:0px;display:block;

}#menu ul li.menusap{


background-image:url(images/menusap.jpg);background-repeat:no-repeat;

}#menu ul li.menusap1{

width:2px;height:27px;float: left;margin:0px;padding:0px;background-image:url(images/usr_sep.jpg);background-repeat:no-repeat;

}#menu ul li a.menu{

height:22px;float: left;margin:0px;padding:5px 11px 0 11px;font-family: "Trebuchet MS";font-size:11px;font-weight:bold;color:#c5c5c5;text-align:center;text-decoration:none;text-transform:uppercase;


23/105

}#menu ul li a.menu1{

height:22px;float: left;margin:0px;padding:5px 11px 0 11px;font-family: "Trebuchet MS";font-size:11px;

font-weight:bold;color:#ffffff;text-align:center;text-decoration:none;text-transform:uppercase;

}#menu ul li a.menu:hover{

height:22px;float: left;margin:0px;padding:5px 11px 0 11px;font-family: "Trebuchet MS";font-size:11px;

font-weight:bold;color:#99eaf5;text-align:center;text-decoration:none;text-transform:uppercase;background-image:url(images/menuover.jpg);background-repeat:no-repeat;background-position:center bottom;

}#menu ul li a.menu1:hover{

height:22px;float: left;margin:0px;padding:5px 11px 0 11px;

font-family: "Trebuchet MS";font-size:11px;font-weight:bold;color:#99eaf5;text-align:center;text-decoration:none;text-transform:uppercase;background-image:url(images/usr_arrow.jpg);background-repeat:no-repeat;background-position:center bottom;

}

#contentleft{

width:597px;float:left;margin:0px;padding:0px;

}#topbuttonsblank{

width:597px;height:29px;float:left;margin:7px 0 0 0;padding:0px;


24/105

}#register{

width:130px;height:29px;float:left;margin:0px;padding:0px;font-family:Arial;

font-size:12px;font-weight:bold;color:#464646;text-align:center;text-decoration:none;text-transform:uppercase;

}.register{

width:117px;height:23px;float:left;margin:0px;padding:6px 0 0 13px;

font-family:Arial;font-size:12px;font-weight:bold;color:#464646;text-decoration:none;text-transform:uppercase;background-image:url(images/register.jpg);background-repeat:no-repeat;

}.register:hover{

width:117px;height:23px;float:left;margin:0px;

padding:6px 0 0 13px;font-family:Arial;font-size:12px;font-weight:bold;color:#464646;text-align:center;text-decoration:none;text-transform:uppercase;background-image: url(images/registerover.jpg);background-repeat:no-repeat;

}#bookmark{

width:130px;

height:29px;float:left;margin:0 0 0 4px;padding:0px;font-family:Arial;font-size:12px;font-weight:bold;color:#464646;text-align:center;text-decoration:none;text-transform:uppercase;


25/105

}.bookmark{


font-family:Arial;font-size:12px;font-weight:bold;color:#464646;text-decoration:none;text-transform:uppercase;background-image: url(images/bookmark.jpg);background-repeat:no-repeat;

}.bookmark:hover{

width:117px;height:23px;

float:left;margin:0px;padding:6px 0 0 13px;font-family:Arial;font-size:12px;font-weight:bold;color:#464646;text-align:center;text-decoration:none;text-transform:uppercase;background-image: url(images/bookmarkover.jpg);background-repeat :no-repeat;

}#callus

{width:264px;height:25px;float:left;margin:229px 0 0 0;padding:20px 0 0 0;font-family:Arial;font-size:20px;color:#393939;background-image:url(images/callus.jpg);background-repeat:no-repeat;

}#callus1

{ width:264px;height:25px;float:left;margin:60px 0 0 0;padding:20px 0 0 0;font-family:Arial;font-size:20px;color:#393939;background-image:url(images/callus.jpg);background-repeat:no-repeat;


26/105

}#callus h3{

width:264px;height:25px;float:left;margin:0px;padding:0px;

font-family:Arial;font-size:20px;color:#393939;

}.callus{

font-family:Arial;font-size:24px;color:#c6891e;padding:0 0 0 34px;

}#leftheading_usr{

width:890px;height:35px;float:left;margin:1px 0 0 0;padding:6px 0 0 58px;background-image: url(images/usr_head.jpg);background-repeat:no-repeat;

}#leftheading_usr span{

font-family:Arial, Helvetica, sans-serif;font-size:17px;font-weight:bold;

}

#leftheading_usr a{

color:#0000FF;font-size:13px;text-decoration:none;

}#leftheading_usr a:hover{

color:#3399FF;font-size:13px;text-decoration:underline;

}#leftheading

{ width:471px;height:35px;float:left;margin:20px 0 0 0;padding:4px 0 0 58px;font-family:Arial;font-size:30px;color:#13819a;background-image: url(images/leftheading.jpg);background-repeat:no-repeat;


27/105

}#leftheading h2{

width:471px;float:left;margin:0px;padding:0px;font-family:Arial;

font-size:22px;font-weight:normal;color:#13819a;

}#lefttxtblank{

width:509px;float:left;margin:0px;padding:5px 0 0 20px;

}#lefttxtblank1{

width:830px;float:left;margin:0px;padding:5px 0 0 20px;

}#leftredtxt{

width:509px;float:left;margin:0px;padding:0px;font-family:Arial;font-size:18px;color:#cf7d09;

}#lefttxt{

width:509px;float:left;margin:0px;padding:31px 0 0 0;font-family:Arial;font-size:12px;color:#4a513d;line-height:20px;

}.leftboldtxt

{ font-family:Arial;font-size:12px;font-weight:bold;color:#4a513d;

}.lefttxt{

font-family:Arial;font-size:12px;color:#4a513d;


28/105

background-color:#cee181;}.lefttxt02{

font-family:Arial;font-size:12px;color:#4a513d;background-color:#cee181;

padding:0 27px 0 3px;}#buttonbg{

width:501px;height:25px;float:left;margin:10px 0 0 0;padding:0px;background-image:url(images/hline.jpg);background-repeat:repeat-x;background-position:center;

}

.more{width:82px;height:20px;float: right;margin:0px;padding:5px 0 0 0;font-family:"Trebuchet MS";font-size:10px;font-weight:bold;color:#414141;text-align:center;text-decoration:none;text-transform:uppercase;

background-image: url(images/morebutton.jpg);background-repeat: no-repeat;

}.more:hover{

width:82px;height:20px;float: right;margin:0px;padding:5px 0 0 0;font-family:"Trebuchet MS";font-size:10px;font-weight:bold;

color:#414141;text-align:center;text-decoration:none;text-transform:uppercase;background-image: url(images/morebutton.jpg);background-repeat: no-repeat;

}

#contentright{

width:229px;


29/105

float:left;margin:0px;padding:95px 0 0 0;

}#contentright1{

width:229px;float:left;

margin:0px;padding:5px 0 0 0;

}#search{

width:229px;height:78px;float:left;margin:0px;padding:0px;background-image:url(images/search.jpg);background-repeat:no-repeat;

}

#usr_profile{width:229px;height:58px;float:left;margin:0px;padding:0px;

}#searchblank{


padding:22px 0 0 50px;}#searchinput{


}.searchinput{

width:97px;

height:18px;float:left;margin:0px;padding:4px 0 0 6px;font-family: Arial;font-size:10px;color:#070808;

}#searchbutton{

width:51px;


30/105

height:21px;float:left;margin:1px 0 0 10px;padding:0px;

}.search{

width:51px;

height:18px;float:left;margin:0px;padding:3px 0 0 0;font-family: Arial;font-size:10px;color:#070808;text-align:center;text-decoration:none;background-image:url(images/searchbutton.jpg);background-repeat:no-repeat;

}.search:hover

{ width:51px;height:18px;float:left;margin:0px;padding:3px 0 0 0;font-family: Arial;font-size:10px;color:#070808;text-align:center;text-decoration:none;background-image:url(images/searchbutton.jpg);background-repeat:no-repeat;

}

#advancesearch{


}.advancesearch{

width:97px;height:18px;float:left;

margin:0px;padding:4px 0 0 6px;font-family: Arial;font-size:11px;font-weight:bold;color:#ce932b;text-decoration:none;

}.advancesearch:hover{

width:97px;


31/105

height:18px;float:left;margin:0px;padding:4px 0 0 6px;font-family: Arial;font-size:11px;font-weight:bold;color:#ce932b;

text-decoration:underline;}

#rightnav{

width:230px;height:54px;float:left;margin:11px 0 0 0;padding:0px;

}#rightnav ul{

width:230px;height:54px;float:left;margin:0px;padding:0px;display:block;

}#rightnav ul li{

width:45px;height:54px;float:left;margin:0 1px 0 0;padding:0px;

display:block;}#rightnav ul li a.login{

width:45px;height:54px;float:left;margin:0px;padding:0px;background-image:url(images/login.jpg);background-repeat:no-repeat;

}#rightnav ul li a.login

{ width:45px;height:54px;float:left;margin:0px;padding:0px;background-image:url(images/login.jpg);background-repeat:no-repeat;

}#rightnav ul li a.check{


32/105

width:45px;height:54px;float:left;margin:0px;padding:0px;background-image: url(images/check.jpg);background-repeat:no-repeat;

}

#rightnav ul li a.check:hover{

width:45px;height:54px;float:left;margin:0px;padding:0px;background-image: url(images/check.jpg);background-repeat:no-repeat;

}#rightnav ul li a.chat{

width:45px;

height:54px;float:left;margin:0px;padding:0px;background-image: url(images/chat.jpg);background-repeat:no-repeat;

}#rightnav ul li a.chat:hover{


background-image: url(images/chat.jpg);background-repeat:no-repeat;

}#rightnav ul li a.idea{

width:45px;height:54px;float:left;margin:0px;padding:0px;background-image: url(images/idea.jpg);background-repeat:no-repeat;

}

#rightnav ul li a.idea:hover{width:45px;height:54px;float:left;margin:0px;padding:0px;background-image: url(images/idea.jpg);background-repeat:no-repeat;

}#rightnav ul li a.privecy


33/105

{width:45px;height:54px;float:left;margin:0px;padding:0px;background-image: url(images/privecy.jpg);background-repeat:no-repeat;

}#rightnav ul li a.privecy:hover{

width:45px;height:54px;float:left;margin:0px;padding:0px;background-image: url(images/privecy.jpg);background-repeat:no-repeat;

}

#morelinksheading

{ width:229px;height:41px;float:left;margin:25px 0 0 0;padding:0px;background-image: url(images/morelinksheading.jpg);background-repeat:no-repeat;

}#morelinksheading h5{

width:177px;height:31px;float:left;

margin:0px;padding:10px 0 0 52px;font-family:Arial;font-size:18px;font-weight:normal;color:2a2a2a;

}#morelinks{

width:211px;float:left;margin:0px;padding:23px 0 34px 18px;

background-color:#c7da79;}.date{

width:47px;height:15px;float:left;margin:0px;padding:2px 0 0 17px;font-family:Arial;font-size:11px;


34/105

font-weight:bold;color:#FFF;background-image:url(images/datebg.jpg);background-repeat:no-repeat;

}.linkblank{

width:200px;

height:12px;float:left;margin:8px 0 12px 0;padding:0 0 0 11px;font-family:Arial;font-size:11px;color:#FFF;background-image: url(images/arrow.jpg);background-repeat:no-repeat;background-position:left 5px;

}.linkblank02{

width:200px;height:12px;float:left;margin:11px 0 8px 0;padding:0 0 0 11px;font-family:Arial;font-size:11px;color:#FFF;background-image: url(images/arrow.jpg);background-repeat:no-repeat;background-position:left 5px;

}.linkblank03{

width:200px;height:12px;float:left;margin:0 0 8px 0;padding:0 0 0 11px;font-family:Arial;font-size:11px;color:#FFF;background-image: url(images/arrow.jpg);background-repeat:no-repeat;background-position:left 5px;

}.linkblank04

{ width:200px;height:12px;float:left;margin:0 0 14px 0;padding:0 0 0 11px;font-family:Arial;font-size:11px;color:#FFF;background-image: url(images/arrow.jpg);background-repeat:no-repeat;


35/105

background-position:left 5px;}.link{


padding:0px;font-family:Arial;font-size:11px;color:#FFF;text-decoration: underline;

}.link:hover{


font-family:Arial;font-size:11px;color:#FFF;text-decoration: none;

}#morelinksbot{

width:229px;height:8px;float:left;margin:0px;padding:0px;overflow:hidden;background-image: url(images/morelinksbot.jpg);

background-repeat:no-repeat;}#testimonialbg{

width:825px;height:202px;float:left;margin:36px 0 0 0;padding:0px;background-image:url(images/testmonialbg.jpg);background-repeat:no-repeat;

}#blank_bg

{ width:825px;height:50px;float:left;margin:36px 0 0 0;padding:0px;background-image:url(images/blank_bg.jpg);background-repeat:no-repeat;

}


36/105

#testimonialtxtblank{


}

#testimonialheading{

width:742px;height:40px;float:left;margin:0px;padding:0 0 0 64px;font-family:Arial;font-size:30px;color:#33b0cd;

background-repeat:no-repeat;}

#testimonialheading h2{width:806px;height:40px;float:left;margin:0px;padding:0px;font-family:Arial;font-size:30px;color:#33b0cd;

}#testimonialdate{

width:56px;

height:38px;float:left;margin:11px 0 0 0;padding:26px 0 0 0;font-family:Arial;font-size:28px;font-weight:bold;color:#829241;text-align:center;background-image: url(images/testimonial-date.jpg);background-repeat:no-repeat;

}#testimonialtxt

{ width:417px;float:left;margin:11px 0 0 0;padding:0 0 0 17px;font-family:Arial;font-size:14px;font-style:italic;color:#a9a9a9;line-height:20px;

}


37/105

#testimonialname{

width:417px;float:left;margin:11px 0 0 0;padding:0 0 0 73px;font-family:Arial;font-size:14px;

font-weight:bold;color:#FFF;text-align:right;

}#testimonialbutton{

width:116px;height:38px;float:left;margin:0 0 0 135px;padding:0px;

}.testimonialbutton

{ width:116px;height:32px;float:left;margin:0px;padding:6px 0 0 0;font-family:Arial;font-size:20px;font-weight:bold;color:#2e2e2e;text-align:center;text-decoration:none;background-image:url(images/detailsbutton.jpg);background-repeat:no-repeat;

}.testimonialbutton:hover{

width:116px;height:32px;float:left;margin:0px;padding:6px 0 0 0;font-family:Arial;font-size:20px;font-weight:bold;color:#2e2e2e;text-align:center;

text-decoration:none;background-image: url(images/detailsbuttonover.jpg);background-repeat:no-repeat;

}#footerbg{



38/105

background-image:url(images/footerbg.jpg);background-repeat:no-repeat;

}#footerlinks{

width:904px;height:13px;float: left;

margin:19px 0 0 0;padding:0px;font-family:"Trebuchet MS";font-size:10px;color:#FFF;text-align:center;text-decoration:none;text-transform:uppercase;

}.footerlinks{

font-family:"Trebuchet MS";font-size:10px;

color:#FFF;text-align:center;text-decoration:none;text-transform:uppercase;padding:0 5px 0 5px;

}.footerlinks:hover{

font-family:"Trebuchet MS";font-size:10px;color:#FFF;text-align:center;text-decoration: underline;text-transform:uppercase;

padding:0 5px 0 5px;}#copyrights{

width:904px;height:13px;float: left;margin:5px 0 0 0;padding:0px;font-family: Arial;font-size:10px;color:#2d2d2d;text-align:center;

}#validation{

width:534px;float: left;margin:5px 0 0 0;padding:0 0 0 370px;

}.xhtml{

width:70px;


39/105

height:20px;float: left;margin:0px;padding:5px 0 0 12px;font-family:"Trebuchet MS";font-size:10px;font-weight:bold;color:#414141;

text-decoration:none;text-transform:uppercase;background-image: url(images/xhtml.jpg);background-repeat: no-repeat;

}.xhtml:hover{

width:70px;height:20px;float: left;margin:0px;padding:5px 0 0 12px;font-family:"Trebuchet MS";

font-size:10px;font-weight:bold;color:#414141;text-decoration:none;text-transform:uppercase;background-image: url(images/xhtml.jpg);background-repeat: no-repeat;

}.css{

width:62px;height:20px;float: left;margin:0 0 0 3px;

padding:5px 0 0 20px;font-family:"Trebuchet MS";font-size:10px;font-weight:bold;color:#414141;text-decoration:none;text-transform:uppercase;background-image: url(images/css.jpg);background-repeat: no-repeat;

}.css:hover{

width:62px;

height:20px;float: left;margin:0 0 0 3px;padding:5px 0 0 20px;font-family:"Trebuchet MS";font-size:10px;font-weight:bold;color:#414141;text-decoration:none;text-transform:uppercase;background-image: url(images/css.jpg);


40/105

background-repeat: no-repeat;}#designedby{

width:904px;height:13px;float: left;margin:5px 0 0 0;padding:0px;

font-family: Arial;font-size:12px;font-weight:bold;color:#9b5b01;text-align:center;

}.designedby{

font-family: Arial;font-size:12px;font-weight:bold;color:#faf56d;text-align:center;text-decoration:none;

}.designedby:hover{font-family: Arial;font-size:12px;font-weight:bold;color:#faf56d;text-align:center;text-decoration:none;

}#tuts_list{

font-family:Verdana, Arial, Helvetica, sans-serif;font-weight:bold;font-size:12px;

}

#tuts_list a{color:#0000CC;text-decoration:none;

}#tuts_list a:hover{

text-decoration:underline;}.infoLabel{

font-family:Verdana, Arial, Helvetica, Sans-serif;font-size:12px;font-weight:bold;

}.infoLabel_1{

font-family:Arial, Helvetica, Sans-serif;font-weight:bold;font-size:15px;color:#000099;

}#successMsg{

font-family:Verdana,Arial,Helvetica;font-weight:bold;font-size:12px;color:#CC3300 ;padding-bottom: 5px;


41/105

padding-left: 5px;}

Content_right.jsp/********************/

SearchAdvance Search

More Newslinks

12.02.11news

headlines.......16.02.11news

headlines.......news



headlines.......16.02.11news

headlines.......s

newsheadlines.......

16.02.11news

headlines.......


42/105

Signup.jsp/**************/

Sign Up Now

Enter Your Personal Details

YourName*:

EmailID*:

City:


43/105

Country:

Designation:

Enter Your Login Details

UserName*:

Password*:

RetypePassword*:


44/105

Signup_insert.jsp/********************/

Login.jsp/*************/

Login Now


45/105

Enter Your User Name & Password

User Name*:

Password*:

Forgot Password?

New User: Signup


46/105

usrLoginVerification.jsp/**************************/

Login Now

Enter Your User Name & Password

User Name*:


47/105

Password*:

Forgot Password?

New User: Signup

user_home_page.jsp/***********************/


48/105

C.

Code

Course

Name Course

Category

Your

Status

function fnMenuBg1(elementId){

document.getElementById(elementId).style.backgroundColor="#dfdfdf";}function fnMenuBg2(elementId){

document.getElementById(elementId).style.backgroundColor="";}


49/105


50/105

if(is_successfully_completed==1){back_color="bgcolor=#FFFFCC";}else{if(is_registered==1){

back_color="bgcolor=#f0f0ff";}else{back_color="";}}%>

0){%>Successfully completedon

Enrolled on
(not yet

completed) Not yet enrolled

select


51/105

catch(Exception e){%>Error ocuured in while :

View_profile.jsp/***********************/


52/105

Your Profile Details

User

Name:

FullName:

Designation:

Email:

City:

Country:

Change_password.jsp

/**************************/


53/105

Old

Password:

NewPassword:

RetypeNew Password:


54/105

Statementst=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);objRs=st.executeQuery(statement);if(objRs.next()){objRs.updateString("pass_word",new_pass);objRs.updateRow();

response.sendRedirect("login.jsp?result=Password ChangedSuccessfully.Please Login Again.");}else{response.sendRedirect("change_password.jsp?result=Incorrect Password.TryAgain!");}}catch(Exception e){out.print("error occured " + e);}

%>

View_tutorials.jps/**********************/


55/105

else{response.sendRedirect("login.asp?result=Session Timed out");}session.setAttribute("trainee_id",objRs.getString("trainee_id"));

}catch(Exception e)

{%>error occured :

YourName:

CourseName:


56/105

error occured in paper1 :


57/105

if(is_previous_paper_completed==0){attempt_message="Not yet Eligible as you have not

completed previous modules";}else{

switch(no_of_attempts){case 0:attempt_id=1;attempt_message="Not completed, You have a total

of 3 attempts";break;case 1:attempt_id=2;attempt_message="Not completed,1 attempt exhausted

,you have 2 more attempts.";break;case 2:

attempt_id=3;attempt_message="Not completed,2 attemptsexhausted,you have 1 more attempt.";

break;case 3:attempt_message="All the attempts are exhausted

and so you cannot complete the e ";break;default:attempt_message="Not completed, and you are

eligible for the exam ";

}}

}

%>Module. :

Appear for the exam


58/105

Appear

for the examAppear

for the examAppearfor the exam

0){%>Marks obtained

:%


59/105

%>Appeared On :No. of Attempts :Pass precentage

:50%


60/105

Course_step.jsp/***********************/

function fnMenuBg1(elementId){document.getElementById(elementId).style.backgroundColor="#dfdfdf";}function fnMenuBg2(elementId){document.getElementById(elementId).style.backgroundColor="";}function fnClick(getElement,course_id){if(getElement=="enroll")

{location.href="enroll.jsp?course_id=" + course_id;}

if(getElement=="evaluate"){location.href="course_registration_form.jsp?course_id=" + course_id;}if(getElement=="exam"){location.href="view_tutorials.jsp?course_id=" + course_id;}if(getElement=="result"){location.href="course_registration_form.jsp?course_id=" + course_id;}if(getElement=="certificate"){location.href="view_certificate.jsp?course_id=" + course_id;}if(getElement=="choose"){location.href="course_list1_model2.jsp";}

}


61/105

course_id=Integer.parseInt(request.getParameter("course_id"));session.setAttribute("course_id",Integer.toString(course_id));

}ResultSet objRs=null;ResultSet oRsTraineeStatus=null;try{

statement="select * from tblelearning_users u,tblCoursesc,tblCategory cat where c.course_category_id=cat.course_category_id and

c.course_id=" + course_id + " and u.user_name='" +session.getAttribute("user_name") + "'";

Statement stat=conn.createStatement();objRs=stat.executeQuery(statement);

}catch(Exception e){%>error occured :


62/105

course_description=objRs.getString("course_description");}}catch(Exception e){out.print("Error occured in objRs : "

+ e);}

%>

error occured in parameters :


63/105

out.print("exception occured inTrainee Status " + e);

}

%>

Your Name:

Course Name:Course Category:

Total no. of Modules:Course Description:step1.


64/105

face:verdana;font-weight:bold" type="button" value="Enroll for thiscourse" name="enroll">

step

2.

step3.


65/105

Enroll.jsp/*******************/


66/105

objRsInsert.updateInt("paper2_no_of_attempts",0);objRsInsert.updateInt("paper3_no_of_attempts",0);objRsInsert.updateInt("is_paper1_completed",0);objRsInsert.updateInt("is_paper2_completed",0);objRsInsert.updateInt("is_paper3_completed",0);objRsInsert.updateInt("paper1_marks",0);objRsInsert.updateInt("paper2_marks",0);objRsInsert.updateInt("paper3_marks",0);

objRsInsert.updateDate("doe",date);objRsInsert.updateInt("no_of_papers",no_of_papers);objRsInsert.insertRow();response.sendRedirect("course_step.jsp?result=Enrolledsuccessfully.&course_id=" + course_id);

}catch(Exception e){out.print("error occured : " + e);}%>

Exam_questions.jsp/**********************/


67/105

course_name=objRs.getString("course_name");trainee_name=objRs.getString("first_name");paper_name=objRs.getString("paper_name");no_of_papers=objRs.getInt("no_of_papers");paper_no=objRs.getInt("paper_no");}}catch(Exception e)

{out.print("error occured 1 :" + e);}int i=0;if(request.getParameter("question_no")==null){i=1;}else{i=Integer.parseInt(request.getParameter("question_no"))+1;}try

{statement="select * from tblresults where paper_id=" + paper_id + " andcourse_id=" + course_id + " and trainee_id='" + trainee_id + "'";Statement ss=conn.createStatement();objRsQNo=ss.executeQuery(statement);if(objRsQNo.next()){if(i

YourName:


68/105


69/105

%>

Exam_question_insert.jsp/****************************/


70/105

{statement="select * from tblresults where attempt_id=" + attempt_id + "and course_id=" + course_id + " and paper_id=" + paper_id + " andtrainee_id='" + trainee_id + "'";Statementst=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);objRs=st.executeQuery(statement);

objRs.next();if(request.getParameter("choice" + i)!=null){objRs.updateInt("ans" + i,Integer.parseInt(request.getParameter("choice" +i)));}else{objRs.updateInt("ans" + i,0);}objRs.updateRow();

}

catch(Exception e){out.print("error occured 11 : " + e);}out.print(number_of_questions);if(i

View_tutorials2.jsp/**********************/


71/105

{course_id=Integer.parseInt(request.getParameter("course_id"));paper_no=Integer.parseInt(request.getParameter("paper_no"));attempt_id=Integer.parseInt(request.getParameter("attempt_id"));

}try{

statement="select * from tblelearning_users u,tblTrainee_historyt,tblCourses c,tblPaper p where c.course_id=t.course_id andt.user_name=u.user_name and c.course_id=p.course_id and c.course_id=" +course_id + " and u.user_name='" + user_name + "'";Statement st=conn.createStatement();objRs=st.executeQuery(statement);if(objRs.next()){paper_name=objRs.getString("paper_name");course_name=objRs.getString("course_name");trainee_name=objRs.getString("first_name");}}

catch(Exception e){out.print("Error occured : " + e);}

if(attempt_id==1){attempt="first";}else{if(attempt_id==2){attempt="second";

}else{attempt="third";}}number_of_questions=10;session.setAttribute("number_of_questions","" + number_of_questions);%>

Your Name:Course Name:


72/105

1.You have chosen to attempt the

module

of .2.Click on 'Begin Test' button to

start the test.3.It is considered as your attempt.

4.Click on the 'Next' button to move

to the next question.5.Click the 'Review' button to

review your answers after completing.


73/105

6.All questions carry equal

marks.7.Each test contains questions.

End_of_tutorials.jsp/*************************/


74/105

if(request.getParameter("course_id")!=null){course_id=Integer.parseInt(request.getParameter("course_id"));session.setAttribute("course_id",""+course_id);trainee_id=(String)session.getAttribute("trainee_id");paper_no=Integer.parseInt(request.getParameter("paper_no"));session.setAttribute("paper_no",""+paper_no);attempt_id=Integer.parseInt(request.getParameter("attempt_id"));

session.setAttribute("attempt_id",""+attempt_id);paper_id=Integer.parseInt(request.getParameter("paper_id"));session.setAttribute("paper_id",""+paper_id);}try{statement="select * from tblTrainee_history where course_id=" + course_id+ " and trainee_id='" + trainee_id + "'";Statement st=conn.createStatement();objRs=st.executeQuery(statement);;

}catch(Exception e)

{out.print("errror occured 1 : " + e);}number_of_questions=Integer.parseInt((String)session.getAttribute("number_of_questions"));try{statement="select count(*) as total_qns from tblQuestions where paper_id="+ paper_id;Statement ss=conn.createStatement();oRsTotQns=ss.executeQuery(statement);if(oRsTotQns.next()){total_qns=oRsTotQns.getInt("total_qns");

}

}catch(Exception e){out.print("errror occured 3 : " + e);}/**if(total_qns < number_of_questions){response.sendRedirect("view_tutorials.jsp?result=This Course contains lessthan " + number_of_questions + " questions. Hence Test is not permitted.Please select some other course");}**/

int last_qn=total_qns-1;int i=0;ResultSet oRsID=null;int qn_array[]=new int[total_qns];try{statement="select question_id from tblQuestions where paper_id=" +paper_id;Statement stt=conn.createStatement();oRsID=stt.executeQuery(statement);while(oRsID.next())


75/105

{qn_array[i]=oRsID.getInt("question_id");i=i+1;}

}catch(Exception e){

out.print("errror occured 4 : " + e);}

/*randomizefor j=last_qn to number_of_questions step -1random_no=int(rnd* last_qn)qn_array(random_no)=qn_array(last_qn)redim preserve qn_array(last_qn)last_qn=last_qn-1nextredim preserve qn_array(ubound(qn_array)-1)

for i=0 to ubound(qn_array)for j=0 to (ubound(qn_array)-i-1)if qn_array(j)>qn_array(j+1) thentemp=qn_array(j)qn_array(j)=qn_array(j+1)qn_array(j+1)=tempend ifnextnextresponse.write("sorted list")*/try{String qn_qns_str="";

String qn_qns_val="";String qn_ans_str="";String qn_ans_val="";for(int k=0;k0){out.println("successfully");

}else{out.print("failure");


76/105

}

}catch(Exception e){out.print("error occured 55 : " + e);}

try{response.sendRedirect("exam_question.jsp");}catch(Exception e){out.println("error occured :" + e);}

%>

View_result.jsp/*******************/


77/105

response.sendRedirect("login.jsp?result=Session Timed out");}session.setAttribute("trainee_id",objRs.getString("trainee_id"));

}catch(Exception e){%>error occured :


78/105

error occured in paper :


79/105

break;case 1:attempt_id=2;attempt_message="Not completed,1 attempt

exhausted ,you have 2 more attempts.";break;case 2:attempt_id=3;

attempt_message="Not completed,2 attemptsexhausted,you have 1 more attempt.";

break;case 3:attempt_message="All the attempts are

exhausted and so you cannot complete the e ";break;default:attempt_message="Not completed, and you are

eligible for the exam ";

} } } %>

Module. :

0){%>Marks

obtained :%Appeared On :No. of Attempts :


80/105

Pass

precentage :50%

Result_calculation.jsp/****************************/


81/105

ResultSet objRs=null;ResultSet objRs1=null;ResultSet objRsQNo=null;ResultSet objRsUpdate=null;ResultSet objRsUpdate1=null;String trainee_name="",course_name="",paper_name="",course_category="";int no_of_papers=0,paper_no=0;try

{statement="select * from tblelearning_users u,tblTrainee_historyt,tblCourses c ,tblPaper p,tblCategory cat wherec.course_category_id=cat.course_category_id and p.course_id=c.course_idand c.course_id=t.course_id and t.user_name=u.user_name and c.course_id="+ course_id + " and u.user_name='" + user_name + "' and p.paper_id=" +paper_id;Statement st=conn.createStatement();objRs1=st.executeQuery(statement);if(objRs1.next()){trainee_name=objRs1.getString("first_name");course_name=objRs1.getString("course_name");

paper_name=objRs1.getString("paper_name");course_category=objRs1.getString("course_category");no_of_papers=objRs1.getInt("no_of_papers");paper_no=objRs1.getInt("paper_no");}}catch(Exception e){out.print("error occured ");}try{statement="select * from tblresults where attempt_id=" + attempt_id + "and course_id=" + course_id + " and paper_id=" + paper_id + " and

trainee_id='" + trainee_id + "'";Statement ss=conn.createStatement();objRsQNo=ss.executeQuery(statement);objRsQNo.next();}catch(Exception e){out.print("error occured 22 :"+e);}%>function fnMenuBg1(elementId){

document.getElementById(elementId).style.backgroundColor="#dfdfdf";}function fnMenuBg2(elementId){document.getElementById(elementId).style.backgroundColor="";}function fnConfirm(){return confirm("Are you sure you want to FINISH the exam?");}function fnClick()


82/105

{location.href="course_tutorial1.jsp?course_id=";

}

Your Name:

Course Name:

Module Name:Module No.:/

Attempt No.:/3


83/105


84/105

markNot

attempted

1mark

0mark


85/105

{%> 1mark0

mark


86/105

{%>1mark0mark

TOTALMARKS :

/


87/105

out.println("eror occured 66 : " + e);}try{statement="select * from tblTrainee_history where course_id="

+ course_id + " and trainee_id='" + trainee_id + "'";Statement stt=conn.createStatement();objRsUpdate1=stt.executeQuery(statement);

objRsUpdate1.next();objRsUpdate1.updateInt("paper_id" + paper_no,paper_id);objRsUpdate1.updateInt("paper" + paper_no +

"_no_of_attempts",attempt_id);objRsUpdate1.updateInt("paper" + paper_no + "_marks",total);objRsUpdate1.updateInt("is_attended_exam",1);java.util.Date now=new java.util.Date();java.sql.Date date = new

java.sql.Date(now.getYear(),now.getMonth(),now.getDate());objRsUpdate1.updateDate("paper" + paper_no +

"_appeared_on",date);objRsUpdate1.updateInt("total_marks",number_of_questions);if(total>(number_of_questions /2))

{objRsUpdate1.updateInt("is_paper" + paper_no +"_completed",1);

objRsUpdate1.updateDate("paper" + paper_no +"_completed_date",date);

out.print("STATUS:PASS
");if(paper_no==no_of_papers){objRsUpdate1.updateInt("is_successfully_completed",1);objRsUpdate1.updateDate("course_completed_date",date);}}else{

out.print("STATUS:FAIL
");}objRsUpdate1.updateRow();}catch(Exception e){out.println("error occured 77 : " + e);}%>ATTEMPT NO.:


88/105

session.removeAttribute("paper_no");session.removeAttribute("paper_id");session.removeAttribute("attempt_id");%>

Logout.jsp/**************/

7. TESTING

7.1 TestPlan:-This document describes the plan for testing E-Learning Software. All themajor testing strategies are specified here; additional testing may be scheduled later, if

necessary.

7.1.1 Test Units

I7n this project we will perform two levels of testing: Unit testing & System testing.

Because the System is moderate in Size, it is felt that there is no need for elaborateintegration testing. The basic units to be tested are:

# Modules to Tables

# Tables to Reports

# Other Units

In addition, some other units may be chosen for testing. The testing for these different

units will be done independently.

7.1.2 Features To Be Tested

All the functional features specified in the requirement document will be tested. No testing

will be done for the performance, as the response time requirement is quite weak.

7.1.3 Approach To Testing

For Unit Testing, Structural Testing based on the branch coverage criterion will be used.

The goal is to achieve branch coverage of more than 95%. System testing will be largely

functional in nature. The focus is on Invalid and Valid cases, Boundary Value and Special

Cases.


89/105

7.1.4 Test Deliverables

The following documents are required (besides this Test Plan):

Unit test report of each Unit.

Test case Specification for System Testing

Test Report for System Testing

Error Report

The test case specification for System Testing has to be submitted for review before System

Testing Commences.

7.1.5 Schedule

The entire testing- Unit & System will be finished within the month of December. Test case

Specifications for the System Testing will be produced while Unit Testing is going on. This

Schedule is consistent with the over all schedule of the project. The schedule for the

testing is shown in the Project Planning section.

7.2 Test Case Specification for System Testing

Here we specify all the test cases that are used for System Testing. First, the different

conditions that need to be tested, along with the test cases for testing those condition and

the expected output are given. Then the data files used for testing are given. The Test cases

are specified with respect to these data files. The Test cases have been selected using

functional approach. The goal is to test the different functional requirements, as specified

in the requirement document. Test cases have been selected for both Valid as well as

Invalid Input.


90/105

8. SCREEN SHOOTS

Index/Home page


91/105

User Registration page


92/105


93/105

User Home Page


94/105

User Profile Details


95/105


96/105


97/105

User Course Enroll Page

Online Exam


98/105

Select Module


99/105

Guide Line for Quiz


100/105

Quiz Questions


101/105

9. CONCULSION


102/105

We have successfully designed and developed a project on E Learning. Working on the

project was good experience. This project is designed for Online Education. This project is

designed in JSP(Java Server Pages) which runs on Apache Tomcat Web Server.

Keeping in view these facts we have developed successfully. Developing the project has

helped us some experience on website development.

10. LIMITATIONS

Some of the Liminations of this project are

The questions have to be written to the database directly There is no facility for multiple choice questions There is no facility for subjective answers There is no chat facility which allows the student to interact with the lecturer

directly

11. FURTHER ENHANCEMENT

Further enhancements to this project will be to create a module for entering the questions

to the database. As of now, the questions are directly written into tables by the

administrator . Creating a computerized module for it may help entry without mistakes.

Another enhancement would be to allow multiple choice questions and subjective

questions.This would allow many varieties of questions to be added. The tutorials can be

made available in flash format and other animated formats.

12. REFERENCES

JAVAServer Pages - By: SAMS ,Techmedia. Javascript - By: Ivan Bayross HTML Complete - By: Sybex Authors


103/105

System Analysis & Design - By: Ilias M Awad Software Engineering A Practitioners Approach - By: Roger S Pressman W3Schoolswww.w3shools.com JSP Tutorials - www.visualbuilder.com/jusp/tutorial/
http://www.w3shools.com/http://www.w3shools.com/http://www.w3shools.com/


104/105

Table of Contents

1. INTRODUCTION ................................................................................................................................. 1

1.1 About the project ........................................................................................................................ 1

1.2 Purpose of the project ................................................................................................................ 1

1.4 Tools/Environment Used ............................................................................................................ 2

2. SOFTWARE DESCRIPTION .................................................................................................................. 2

2.1 Apache Tomcat Server ................................................................................................................ 2

2.2 Operating System Windows XP ................................................................................................ 3

2.2.1 Universality .......................................................................................................................... 3

2.2.2 Support................................................................................................................................. 3

2.2.3 Software ............................................................................................................................... 3

2.2.4 Memory Use ......................................................................................................................... 3

2.2.5 Driver Availability ................................................................................................................. 4

2.2.6 WLAN features ..................................................................................................................... 4

2.2.7 System Restore and Device Driver Rollback ........................................................................ 4

2.2.8 Remote Desktop and Remote Assistance ............................................................................ 5

2.2.9 Client firewall ....................................................................................................................... 6

2.3 Microsoft Access Database ......................................................................................................... 6

2.3.1 Features ............................................................................................................................... 7

3. SYSTEM DEVELOPMENT LIFE CYCLE .................................................................................................. 8

4. REQUIREMENT ANALYSIS PHASE .................................................................................................... 10

4.1 Feasibility study ........................................................................................................................ 10

4.1.1 Technical Feasibility-: ......................................................................................................... 10

4.1.2 Economical Feasibility-: ...................................................................................................... 10

4.1.3 Operational Feasibility-: ..................................................................................................... 10

5. ER-DIAGRAM ................................................................................................................................... 11

5.1 ER-Diagram ............................................................................................................................... 11

5.2 Class Diagram ............................................................................................................................ 11

5.3 Table Structure .......................................................................................................................... 12

6. CODING ........................................................................................................................................... 16

7. TESTING ........................................................................................................................................... 88

7.2 Test Case Specification for System Testing ............................................................................... 89

8. SCREEN SHOOTS .............................................................................................................................. 90


105/105

9. CONCULSION ................................................................................................................................. 108

10. LIMITATIONS ............................................................................................................................... 102

11. FURTHER ENHANCEMENT ........................................................................................................... 102

12. REFERENCES ................................................................................................................................ 109