Project

ABSTRACT This study was carried out to verify all the manual process involved in generating Students Examination Result and to seek a way of automating the system for effective operations. Since there is continuous moves towards technological advances that enhanced productivity of labor and free human beings of task more economically by machines. Computer and its appreciations have become vital tools in economic, industrial and social development of advanced countries of the world. This system is designed to efficiently handle processes like inputting scores, storing results, classifying the grade points automatically calculated, and interpreting data of students overall result. The usual manual process now reached a level where it is difficult for the available man power to cope with the magnitude of examination work, in the given time span, The in balance between the man power availability and the magnitude of the examination work result in the delay in the declaration of results. The most effective measure, which can improve the efficiency of the examination system, therefore the introduction of computerization especially with the use of Examination Result Processing Software in various activities related to the conduct of result reduces the span required for the declaration of results by 60 percent and reduces the process by almost 50 percent. 1. INTRODUCTION The effort expended in the process of registration of students and computation of their examination results is awesome. Quite worrisome is the fact that these processes are carried out every academic session, putting the operators in a continuous and ever demanding cycle. The computation of examination results and registration of students is obviously an object-centered activity, the student being the dominant object in this case. Hence, the need to evolve a computerized process that will effectively and efficiently capture all the important data associated with the registration and examination result processing within the University and the interactions among the objects. Students’ Examination Result is the summary of each of the semester or three, two years performance in a degree program for BACHELLOR DEGREE to be terminable. A students’ Result is also demanded by a student who has finished BSc. and wishes to transfer to another college or student who wishes to get a job .A Transcript is not given directly to a student. It is sent to the college that the student wishes to be transferred, or to the organization or establishment that requires the result. A students’ Result is prepared or formed by the scores entered on the designed score sheet by the individual subject lecturers on semester examinations. This genuine and noble desire necessitated the design and development of the Undergraduate Registration and Examination Processing System software. STUDENT RESULT GUIDE When a student attends an academic institution (s), a record is kept which traces his/her academic history. The students’ examination Result displays a record of all the credit and grades a student has acquired at each college attended. Below are frequently asked questions about students examination Results. How is a student's examination Result used? By all students: Student can use a student’s examination Result as a means of monitoring their credit classes and grades and to make sure the information is accurate. Students use an “Unofficial student’s examination Result “for this purpose. When a student is applying to another college or university, enrolling institution will require for an official students examination Result so that credits can be evaluated by the enrolling institution. An enrolling institution conducts a student's examination result evaluation to place a student at his or her appropriate academic level. How can I obtain a students examination Result? Student must request their students’ examination Result from the office of Record or from the office of the Registrar. Each college has its own student’s examination Result release procedures. Because students examination Result requests are covered by the family Educational Rights and privacy. Act ,students ( giving name, date of attendance ,and social security number), or provide proper documentation when appearing in person often college provide a “Request for official students examination Result “form .A small fee is usually charged .The difference between official and unofficial students examination Result is that ,official students examination Result must meet certain standards and be sent directly from one institution to another .In some cases, the college will accept an official students examination Result from the student if it hand delivered in a sealed envelop. Unofficial students’ examination Result can be sent directly to a requesting student. It could be marked as an unofficial student’s examination Result or issued to students but not all college issue these. Will all my credit be transferred? Each college has its own transfer credit acceptance policies. Credit transfer problems can result if: An institution does not have proper accreditation. Certain courses are taken (e.g. base skills or physical education courses) that are not approved for transfer. The amount of credit hours earned exceeds the maximum amount the institution will transfer. The enrolling institution has a difficult time evaluating a course. The course work is over 10years old. colleges often require appreciate catalogs or course descriptions STATEMENT OF PROBLEM There has been this problem of too much work for the Head of Department of Exams and Records owing to the increase of students in the institution, the Head of Department of the Exams and Records is faced with heaps of files .At times sorting out a particular students file takes time. This bitter complaint and the delay in the preparing of this students examination Result has been the major concern and therefore has intensified the need to design a generating software which will go a long way in tackling these problems and proffering solutions, at the same time to quicken the generating of student’s result. PURPOSE OF STUDY The purpose of this study is designing and implementation of Student Examination Result Processing System. OBJECTIVES OF STUDY The aim and objectives for students’ examination Result is to study and document all processes involved in the task of generating students examination Result and eliminate errors due to manual processing. It is also to enhance the speed of the results. Finally to keep accurate record of students examination Results in the college and prevent lost of result, which are vital to the exams and records. SCOPE/DELIMINATION The scope (or delimitation of study) falls under the process of degree of extension. Specifically in Periyar University , their grade begins with A followed by A+, A ,B+,B, and C . A stands for 4, while A+ =9.0, A = 8.0, B+= 7.0, B =6.0 and C =5.0 ie anything below 5.0 which is P (pass) is F (fail). PERIYAR UNIVERSITY GRADE POINT GRADE GRADE POINT A+ 9.0 A 8.0 B+ 7.0 B 6.0 C 5.0 1.1 ORGANIZATION PROFILE Government Arts College (MEN), Krishnagiri is a renowned educational institution with a long tradition and stupendous achievements. It provides a salubrious and inspiring atmosphere to every eager aspirant who wishes to pursue any course of History of The study to achieve upper mobility in the society with sound career at hand. Many an influential person found at Krishnagiri are mostly the alumnae of this college. It disseminates quality education with time-tested values to whoever comes to its fold like a citadel of an ever-shining monarch. Ever since its inception, the college has been fashioned and fortified to produce many a number of success personalities, impeccable scholars, radiant –tycoons and notable statesmen. In short, it is a boon to the under privileged and downtrodden of this locality .Situated at a strategic position on the Krishnagiri - Chennai highway, 6 km from the heart of Krishnagiri town, it serves tirelessly to the backward community like a beacon light. It was founded in 1964 with a main objective to uplift the people of Krishnagiri whose chief occupation was to till the field and reap the corns not knowing much about the fruits of education and social progress. Hon’ble Chief Minister of Tamil Nadu His Highness M.Bakthavachalam laid the foundation stone and it had its beginning with only four courses. In 1965, the degree courses; B.A Tamil, B.A History and B.Sc Maths were offered. With the munificent help of the donors such as; big shots, traders and the affluent people of this area, a new building was built for the college in 1970. In the academic year 1971-72, B.A English and B.Sc Zoology were started. In the very next academic year B.Sc Botany was introduced. In the academic year 1976-77, semester system was introduced. Two years after B.Sc Physics was introduced. With the introduction of P.G Botany and P.G Mathematics in 1980-81, the college was upgraded as senior grade Arts College. With the commencement of M.Phil (Botany), the college was recognized as the Research Institution by Madras University in the academic year 1984-85. In two years, the part time M.Phil (Botany) course was converted into a full time course. In the academic year 1990-91 B.Sc Chemistry was introduced. In the same academic year the college was affiliated to Perilya University as it came under the jurisdiction of the same. In the very next year B.Sc Chemistry was introduced. After ten years, B.Sc Computer Science was introduced. In the academic year 2003-2004, under self-financing programmers the following courses were started; B.B.A., B.Com., B.Litt (Tamil, B.Sc (Microbiology), B.Sc (Chemistry), M.Phil (Tamil) Full time/ Part time and PhD (Tamil) Full time/ Part time. these so-called self-financing courses were absorbed into the regular stream in the academic year 2005-06. In the first cycle, the college was accredited by the NAAC with the However,credit of C++ in Feb 2005. In the academic year 2007-08, shift system was introduced in the college by the State Government of Tamil Nadu. Accordingly, degree courses such as ; B.Sc Chemistry, B.Sc Computer Science, B.Com, B.B.A and B.litt (Tamil) were started. In the academic year 2003-04, Computer Literacy Programmer (CLP) was made compulsory to all non-computer major degree students. In the academic year 2008-09, Arignar Anna Centenary block was constructed. In the same academic year Language Lab for English Department and a new Laboratory for Chemistry Department were set up. The Choice Based Credit System was introduced in the very same year as well. In the academic year 2010-11 onwards, M.Phil (Full time), PhD (Full time) in Mathematics has been launched.To the sole benefit of the aspirants of the locality, M.A English Literature, M.A. Tamil Literature, M.A. History, M.Sc Chemistry and M.Sc Computer Science have been started since 2012-13. The introduction of B.A. Economics, M.Sc Physics, M.Sc Zoology, the Part time / Full time M.Phil in Zoology took place in the academic year 2013-14. The new courses that gained entry in the academic year 2014-15 were M.Phil programmer (Part time / Full time) in English and Physics. As such, the college offers 14 under graduate programmers and 9 Post Graduate programmers. Seven departments offer both part-time and full-time M.Phil and PhD programmers. The college strives to achieve the overall development of the students whoever obligingly keep pace with the ideological, philosophical, educational studies of the institution. It aims at the multi-faceted growth of the students. Besides achieving academic objectives, the institution indomitably Endeavour’s to shape the characters of the students which arc undisputably essential for the sustained growth of every individual. Gokhale stresses its great significance and valued it on par with other academic achievements. 1.2 SYSTEM SPECIFICATION 1.2.1 HARDWARE CONFIGURATION Processor : Intel Pentium IV 1.8 GHZ RAM : 512 MB or Greater. HDD : 10 GB VGA : Standard VGA Adapter 1.2.2 SOFTWARE CONFIGURATION Operating System : Windows Operating System 7 Developing Environment : Visual Studio 2010 Language : VB.Net Data Base : Microsoft Access 2007 2. SYSTEM STUDY Introduction System Analysis is a very critical activity while developing a application. This stage involves study of existing system and interacting with users, which determines user and their expectation of the proposed system. Cost of incorporating changes required by the user is very less at this stage, which steeply increases as development advances. 2.1 Existing System Many of the university publishing the results via web site. But the result is not known by the student. When user see the result through web site only. Many of the student studying in rural background, so they are not have technology enhancement in village. There is a need of a system to announce a college system. 2.1.1 Drawbacks Manual work is take long time Slow Process 2.2 Proposed System The proposed system helps the rural background student for announcing results. In this system announcing the result through the mail and mobile phone. In this implementation help the rural student to kwon their results. 2.2.2 Features Less Money Easy announcement of Result Time Consuming 3. SYSTEM DESIGN AND DEVELOPMENT Introduction System design is the creation of road map that shows system developers how to convert system requirements into a workable and operational system by exploring system and identifying the best design for the project. 3.1 Input Design Input design is one of the most expensive phases of the operation of computerized system and is often the major problem of a system. A large number of problems with the system can usually be traced back to fault input design and method. Needless to say, therefore that the input data is the life block of a system and has to be analyzed and designed with the most consideration. The decisions made during the input design To provide cost effective method of input. To achieve the highest possible level of accuracy. To ensure that input is understood by the user. 3.2 Output Design Output design generally refers to the results and information that are generated by the system. For many end-users, output is the main reason for developing the system and the basis on which they evaluate the usefulness of the application. 3.3. MODULE DESCRIPTION Login Student Information Mark sheet Verification System Result Announcement System Login The login module is used for authenticating user and administrator authentication. This module protected the system to unauthorized activities. Only authenticated users can enter the system and performing results announcement. Student Information The student module collect the information about student such as name register no, marks and then it will produce the marks statements according to given marks. Mark sheet Verification System The mark sheet verification system module performing the activities of checking the Marks Verification through Mobile Phone. Result Announcement System The result announcement system is key module for performing various activities of result announcement process such like sending Results via SMS and Email System. The Registered email and phone number is updated regularly and the result sending only on this contact. 3.4 DATABASE DESIGN Database is an integrated collection of data and provides a centralized access to the data and makes possible to treat data as a separate resource. Usually centralized data managing software is called a Relational Database Management System (RDBMS). The most significant different between RDBMS and other type of Data Management is the separation of data as seen by the program and data as store of on the direct access storage device. This is the difference between logical and physical data. Data dictionary The efficiency of an application developed using RDBMS mainly depend upon the database tables, the fields in each table and the way the tables are opened using the contents in them to retrieve the necessary information. Hence a careful selection of tables and their fields are imperative. The database tables used in this system are created keeping the above points in mind. 3.5 SYSTEM DEVELOPMENT .Net Framework An Overview The .NET Framework is a development and execution environment that allows different programming languages and libraries to work together seamlessly to create Windows-based applications that are easier to build, manage, deploy, and integrate with other networked systems. Built on Web service standards, .NET enables both new and existing personal and business applications to connect with software and services across platforms, applications, and programming languages. These connections give users access to key information, whenever and wherever you need it. Microsoft .NET–connected software makes the "real-time" enterprise real by enabling information to flow freely throughout the organization, accessible to business partners, and delivering value to customers. With .NET-connected software, users can increase the value of existing systems and seamlessly extend those systems to partners, suppliers, and customers. Connected .NET Framework empowers developers to build applications that require robust messaging systems or flexible workflows. Compelling With the .NET Framework, developers and designers can collaborate to create rich user experiences. Ubiquitous and Productive The .NET Framework, including improvements like LINQ, provides a single platform to quickly build mobile desktop and server-based applications. The most important question is What is .NET? and the simplest answer is : it is a Framework in which Windows applications may be developed and run. I agree that this answer does not tell much. In order to understand .NET we must go back in time and follow the development of Windows and the advent of Windows programming. Windows provide the programmers with various functions - called API. Starting from the very first time Windows enter the commercial market to the latest version of WindowsXP, APIs are the basic tool to let the Windows know what you want it to do. If you want to create a Dialog Box you must call a specific API provided to you by Windows. Making a button requires another API call. And the list goes on. As new GUIs appear on the scene, new APIs are introduced in Windows. But using these native APIs was a very challenging task. Making a simple Window that prints "Hello World" could take more than hundred lines. Compare this to 5 lines of "Hello World" program in DOS. Due to this difficulty, Windows programming was considered. Various vendors develop their own "Wrapper classes” that wrapped the Windows APIs in an Object-Oriented way. The Microsoft Foundation Classes (MFC) that is used in Visual C++ is an example of Wrapper classes. The MFC equivalent of Visual Basic is Vern; and for Visual J++ it is WFC. These Wrapper Classes, along with the Visual GUI tools made it very convenient to make windows programs. Microsoft realized that applications need a solid way to talk to each other. And this resulted in the introduction of Object Linking and Embedding (OLE). OLE was an extremely useful concept, but it had two major flaws : It was notoriously difficult to program, and it was very limited in its scope - i.e. it only did a few things like drag and drop, clipboard sharing, OLE client, OLE server etc. Microsoft addressed (or at least tried to address) both these problems. They upgraded OLE to COM. COM  was much more capable than OLE, and it introduced new concept like ActiveX controls which directly competed with Java Applets. As for the difficulty of programming OLE/COM; Microsoft expanded the MFC and VB run to take care of most of the dirty job. Although making an ActiveX application still was slightly tricky in Visual C++, but developing an ActiveX application in Visual Basic was extremely easy; and hence Visual Basic became the foremost ActiveX development media. The Internet revolution posed new problems and challenges. C/C++ which was the tool of champions was not suited/ready for Web Development. Microsoft tried expanding MFC, and included several network oriented classes - like Crockets, CASyncSocket, and several HTTP based classes. Using these classes a programmer could very develop a distributed application - although not without considerable effort. But these applications were always customized and targeted to the specific task. The developers had to take care of the gory network communication details themselves. By now object-oriented analysis and development had started becoming ubiquitous. Although technologies like Remote Procedure Call (RPC) was a great help to the programmers; but it was limited in its scope. With programmers following the Object-Oriented development RPC was not much help at all; since RPC did not allow passing objects as parameters. This major issue was addressed by introduction of industries agreed upon standards like CORBA, IIOP, RMI, DCOM etc. All these standards used customized protocol to transmit an object over the network, and they required a tight coupling between the server and the client - i.e. the client needed to be fully aware of how to talk to the server. Due to this tight client-server coupling all these protocols needed considerable deployment efforts in order for distributed applications to function properly. Sun did come up with another layer on top of RMI - the famous Enterprise Java Beans (EJB). The EJB container provided lot of services for free - all that a programmer had to do was to extend (inherit) from an appropriate EJB base class and there you have it - a fully functional distributed application. EJB made programmer's life extremely easy; but it did not eradicate the client-server coupling issue. While all this was happening - Microsoft was still not facing the writing on the wall MICROSOFT NEEDED SOMETHING RADICALLY NEW TO MATCH UP TO THE CHANGING TIMES AND CHANGING DEMANDS. Microsoft soon realized that upgrading their existing technologies would not work - what they needed was a complete change in their philosophy. OLE was upgraded to COM - and it was welcomed by all. COM was then upgraded to COM+. Microsoft addressed the distributed programming issue with the introduction of DCOM. Although COM/COM+/DCOM were all good technologies but these technologies required significant learning curve. Sun on the other hand was making things easier and hence a majority of developers were turning towards Java based technologies for distributed enterprise applications. Microsoft - after the cold treatment faced by DNA - got their gurus together and asked them to reflect back on DNA and to come up with a future vision. This group came up with so many new and great ideas which mad Microsoft realized that no amount of up gradation or extension in MFC/Vern/WFC, COM/COM+/DCOM, ASP, APIs etc. would even come closer to realizing this new vision. So they made a radical but correct decision - and this was the decision of coming up with something big, something new, and something that lets Microsoft make up for their lapses - this was called the .NET Framework. .NET Technology .NET is a library, one that is just as extensive as the Windows API. We can use it to call up all the same sorts of features that have traditionally been the role of the Windows operating systems; displaying windows and dialog boxes, verifying security credentials, calling on base operating systems services, creating threads and so on, as well as newer areas such as accessing databases or connecting to the internet or providing web services. ADVANTAGES Object Oriented Programming Good Design Language Independence Better support for dynamic web pages Efficient Data Access Code Sharing Improved Security SCOPE OF THE CONTROLS OF .NET Label Label is used to display that the user cannot change. Textbox It is used to assign a value to a text box or read a value that a user has entered into it. Multiline property is assigned the value Multiline, a text area is displayed Button control It renders the same form submit button as rendered by the normal HTML tag. Image button It is used to display an image. Radio button list It represents a group of mutually exclusive options. Each radio button can be either checked or unchecked. No more than one radio button in a group can be checked at the same time. List box control It enables a user to select only one option at a time, or create a multi select list box. Panel control Instead of setting the visible property for controls one by one, we can use the panel control to hide controls as a group. Data grid control It is used to display the records without using templates. We can simply bind a data source to the data grid, and it automatically displays the records. We can create columns to control how records are formatted or to display links for editing records. ADO.NET It contains several namespaces with dozens of classes devoted to database access. The System.Data.Sqlclient namespace includes the following three classes. SqlConnection SqlCommand SqlDataReader SqlConnection This sqlconnection need to create and open a database connection. We create the connection in different ways depending on the type of database that we want to access. SqlCommand It is used to create a database command that represents the SQL select statement to execute. SqlDataReader It represents a forward-only stream of database records. This means that the data reader represents only a single record at a time. To fetch next record in the stream we must call the read () method. To display all the records returned from a query, we must call the read () method repeatedly until we reach the end of the stream. DataSet A dataset can contain one or more Data Tables that represent database tables. Relationships between the tables can be defined using Data Relation classes. Data Adapter It represents the bridge between a Dataset and the data source it represents. We use a Data Adapter to populate a Dataset from an existing database table. We can also use a Data Adapter to update and existing database table with changes made to a Dataset. Open Open a specified database for the application. Microsoft SQL Server 2000 Microsoft SQL Server 2000 extends the performance, reliability, quality, and ease-of-use of Microsoft SQL Server version 7.0. Microsoft SQL Server 2000 includes several new features that make it an excellent database platform for large-scale online transactional processing (OLTP), data warehousing, and e-commerce applications. The OLAP Services feature available in SQL Server version 7.0 is now called SQL Server 2000 Analysis Services. The term OLAP Services has been replaced with the term Analysis Services. Analysis Services also includes a new data-mining component. Features of SQL Server 2000 Internet Integration The SQL Server 2000 database engine includes integrated XML support. It also has the scalability, availability, and security features required to operate as the data storage component of the largest Web sites. The SQL Server 2000 programming model is integrated with the Windows DNA architecture for developing Web applications, and SQL Server 2000 supports features such as English Query and the Microsoft Search Service to incorporate user-friendly queries and powerful search capabilities in Web applications. Scalability and Availability The same database engine can be used across platforms ranging from laptop computers running Microsoft Windows® 98 through large, multiprocessor servers running Microsoft Windows 2000 Data Center Edition. SQL Server 2000 Enterprise Edition supports features such as federated servers, indexed views, and large memory support that allow it to scale to the performance levels required by the largest Web sites. Enterprise-Level Database Features The SQL Server 2000 relational database engine supports the features required to support demanding data processing environments. The database engine protects data integrity while minimizing the overhead of managing thousands of users concurrently modifying the database. SQL Server 2000 distributed queries allow you to reference data from multiple sources as if it were a part of a SQL Server 2000 database, while at the same time, the distributed transaction support protects the integrity of any updates of the distributed data. Replication allows you to also maintain multiple copies of data, while ensuring that the separate copies remain synchronized. You can replicate a set of data to multiple, mobile, disconnected users, have them work autonomously, and then merge their modifications back to the publisher. Ease of installation, deployment, and use SQL Server 2000 includes a set of administrative and development tools that improve upon the process of installing, deploying, managing, and using SQL Server across several sites. SQL Server 2000 also supports a standards-based programming model integrated with the Windows DNA, making the use of SQL Server databases and data warehouses a seamless part of building powerful and scalable systems. These features allow you to rapidly deliver SQL Server applications that customers can implement with a minimum of installation and administrative overhead. Data warehousing SQL Server 2000 includes tools for extracting and analyzing summary data for online analytical processing. SQL Server also includes tools for visually designing databases and analyzing data using English-based questions. Database A database in Microsoft SQL Server 2000 consists of a collection of tables that contain data and other objects, such as views, indexes and stored procedures defined to support activities performed with the data. The data stored in a database is usually related to a particular subject or process, such as inventory information for a manufacturing warehouse. Views A database object that can be referenced the same way as a table in SQL statements. Views are defined using a SELECT statement and are analogous to an object that contains the result set of this statement. Index In a relational database, a database object that provides fast access to data in the rows of a table, based on key values. Indexes can also enforce uniqueness on the rows in a table. SQL Server supports clustered and no clustered indexes. The primary key of a table is automatically indexed. In full-text search, a full-text index stores information about significant words and their location within a given column Stored Procedure A precompiled collection of Transact-SQL statements stored under a name and processed as a unit. SQL Server supplies stored procedures for managing SQL Server and displaying information about databases and users. SQL Server-supplied stored procedures are called system-stored procedure. 4. TESTING AND IMPLEMENTATION The objective of a system finds its shape in terms of output. The analysis of the objective of a system leads to determination of outputs. Outputs of a system can take various forms. The most common are reports, screens displays printed form, graphical drawing etc. the outputs vary in terms of their contents, frequency, timing and format. The users of the output, its purpose and sequence of details to be printed are all considered. When designing output, the system analyst must accomplish things like, to determine what information to be present, to decide whether to display or print the information and select the output medium to distribute the output to intended recipients. External outputs are those, whose destination will be outside the organization and which require special attention as the project image of the organization. System Testing Testing is vital to the success of the system. System testing makes a logical assumption that if all the parts of the system are correct, the goal will be successfully achieved. Inadequate testing or non-testing leads to errors that may not appear until months later. This creates two problems. The time lag between the cause and appearance of the problem. The effect of system errors on files and records within the system. A small system error can conceivably exploded into much larger problem. Effective early in the process translates directly into long term cost savings from a reduced number of errors. Testing is the process of executing a program with the intent of finding any errors. A good test of course has the high probability of finding a yet undiscovered error. A successful testing is the one that uncovers a yet undiscovered error. Unit Testing A program represents the logical elements of a system. For a program to run satisfactorily, it must compile and test data correctly and tie in properly with other programs. Achieving an error free program is the responsibility of the programmer. These errors are shown through error message generated by the computer. Logic error the programmer must examine the output carefully. When a program is tested, the actual output is compared with the expected output. When there is a discrepancy the sequence of instructions must be traced to determine the problem the process the is facilitated by breaking the program down into self-contained portions, each of which can be checked at certain key points .The idea is to compare program values against desk-calculated values to isolate the Problems. Unit testing has been performed the module. The syntax and logical error have been corrected then and there. All this syntax have been rectified during compilation. The output has been tested with the manual input. All the data are stored correctly. Integration Testing Programs are invariably related to one another and interact in the total system. Each program is tested to see whether it conforms to related programs in the systems. Each portion of the system is tested against the entire module with both the test data and the live data before the entire system is tested as a whole. Integration testing is systematic techniques for conducting the program structure. While at the same time conducting tests to uncover errors associated with the interfacing. Validation testing This is a concern which overlaps with integration testing. Ensuring that the application fulfils its specification is a major criterion for the construction of an integration test. Validation testing also overlaps to a large extent with System Testing, where the application is tested with respect to its typical working environment. Consequently for many processes no clear division between validation and system testing can be made. Specific tests which can be performed in either or both stages include the following. Usability Testing The process of usability measurement was introduced in the previous chapter. Even if usability prototypes have been tested whilst the application was constructed, a validation test of the finished product will always be required. System implementation The purpose of System implementation can be summarized as follows: making the new system available to a prepared set of users (the deployment), and positioning on-going support and maintenance of the system within the Performing Organization (the transition). Prepare for System implementation, where all steps needed in advance of actually deploying the application are performed, including preparation of both the production environment and the Consumer communities. Deploy System, where the full deployment plan, initially developed during System Design and evolved throughout subsequent lifecycle phases, is executed and validated. Transition to Performing Organization, where responsibility for and ownership of the application transitioned from the Project Team to the unit in the Performing Organization that will provide system support and maintenance. 5. CONCLUSION The result alert system is developed successfully. The project is developed as per the requirements. Gmail client has been used for mail client for alerting results of the particular student. In feature this project is upgrade into SMS based result alert System. BIBILOGRAPHY Debugging ASP.NET (New Riders) - Jonathon Goodyear, Brian Peek, Brad Fox Designing Microsoft ASP.NET Applications (Microsoft Press) - Jonathon Goodyear, Microsoft ASP.NET Step by Step (Microsoft Press) - G. Andrew Duthrie Deploying and Managing Microsoft .NET Web Farms (Sams) - Barry Bloom Professional ASP.NET MVC 3 (Wrox) - Jon Galloway, Phil Haack, Brad Wilson, K. Scott Allen Beginning ASP.NET 4.5 in C# - Matthew MacDonald 7. APPENDICIES A).DATAFLOW DIAGRAM E-R DIAGRAM: LOGIN STUDENT INFORMATION TABLE DESIGN: LOGIN FIELD NAME TYPE SIZE Uname Text 25 Password Text 25 STUDENT FIELD NAME TYPE SIZE Rollno Text 25 Name Text 25 Dept Text 25 Course Text 25 Year Text 25 Sem Text 25 Pcode Text 25 M1 Text 25 M2 Text 25 M3 Text 25 M4 Text 25 M5 Text 25 M6 Text 25 Total Text 25 Avg Text 25 Result Text 25 B) SAMPLE CODING Imports System.Data.OleDb Public Class Form1 Dim con As New OleDbConnection Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim sql As String = "select * from login where uname='" + TextBox1.Text + "'" Dim sqlcom As New OleDbCommand(sql) sqlcom.Connection = con con.Open() Dim sqlread As OleDbDataReader = sqlcom.ExecuteReader() If sqlread.Read() Then ' Me.Hide() Form2.Show() Else MsgBox("User Name Password is Wrong!") TextBox1.Text = "" TextBox2.Text = "" TextBox1.Focus() End If con.Close() End Sub Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click TextBox1.Text = " " TextBox2.Text = " " End Sub Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\ms.accdb" con.Open() con.Close() End Sub End Class Public Class Form2 Private Sub StudentInformationToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles StudentToolStripMenuItem.Click form3.Show() End Sub Private Sub MarksheetVerificationsystemToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SubjectToolStripMenuItem.Click Form6.Show() End Sub Private Sub ResultAnnouncementSystemToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ToolStripMenuItem.Click Form7.Show() End Sub Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load End Sub End Class Imports System.Net.Mail Imports System.Data.OleDb Public Class Form3 Dim con As New OleDbConnection Private Sub Form3_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\ms.accdb" con.Open() con.Close() End Sub Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Dim cmd As New OleDbCommand con.Open() cmd.Connection = con cmd.CommandText = "insert into student(regno,name,dept,course,ayear,sem,pcode,m1,m2,m3,m4,m5,m6,total,avg1,res) values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + ComboBox1.Text + "','" + ComboBox2.Text + "','" + ComboBox3.Text + "','" + ComboBox4.Text + "','" + ComboBox5.Text + "','" + TextBox8.Text + "','" + TextBox9.Text + "','" + TextBox10.Text + "','" + TextBox11.Text + "','" + TextBox12.Text + "','" + TextBox13.Text + "','" + TextBox14.Text + "','" + TextBox15.Text + "','" + TextBox16.Text + "')" cmd.ExecuteNonQuery() con.Close() MsgBox("Record Updated Sucessfully...!") Dim sql As String = "select * from student" Dim dataadapter As New OleDbDataAdapter(sql, con) Dim ds As New DataSet dataadapter.Fill(ds, "student") DataGridView1.DataSource = ds DataGridView1.DataMember = "student" End Sub Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click TextBox1.Text = "" ComboBox1.Text = "" ComboBox2.Text = "" ComboBox3.Text = "" ComboBox4.Text = "" TextBox10.Text = "" TextBox11.Text = "" TextBox12.Text = "" TextBox13.Text = "" TextBox14.Text = "" TextBox15.Text = "" TextBox16.Text = "" TextBox2.Text = "" TextBox8.Text = "" TextBox9.Text = "" End Sub Private Sub Button7_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button7.Click TextBox14.Text = Val(TextBox8.Text) + Val(TextBox9.Text) + Val(TextBox10.Text) + Val(TextBox11.Text) + Val(TextBox12.Text) + Val(TextBox13.Text) If Val(TextBox8.Text) >= 50 And Val(TextBox9.Text) >= 50 And Val(TextBox10.Text) >= 50 And Val(TextBox11.Text) >= 50 And Val(TextBox12.Text) >= 50 And Val(TextBox13.Text) >= 50 Then TextBox16.Text = "PASS" Else TextBox16.Text = "FAIL" End If TextBox15.Text = Val(TextBox8.Text) + Val(TextBox9.Text) + Val(TextBox10.Text) + Val(TextBox11.Text) + Val(TextBox12.Text) + Val(TextBox13.Text) / 6 End Sub Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) TextBox8.Text = " " TextBox9.Text = " " TextBox10.Text = " " TextBox11.Text = " " TextBox12.Text = " " TextBox13.Text = "" End Sub Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click Dim SQL As String = "Select * from student where regno ='" + TextBox1.Text + "'" Using con1 As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\ms.accdb") Dim command As New OleDbCommand(SQL, con1) con1.Open() Dim reader As OleDbDataReader = command.ExecuteReader() While reader.Read() TextBox2.Text = reader(1).ToString() ComboBox1.Text = reader(2).ToString() ComboBox2.Text = reader(3).ToString() ComboBox3.Text = reader(4).ToString() ComboBox4.Text = reader(5).ToString() ComboBox5.Text = reader(6).ToString() TextBox8.Text = reader(7).ToString() TextBox9.Text = reader(8).ToString() TextBox10.Text = reader(9).ToString() TextBox11.Text = reader(10).ToString() TextBox12.Text = reader(11).ToString() TextBox13.Text = reader(12).ToString() TextBox14.Text = reader(13).ToString() TextBox15.Text = reader(14).ToString() TextBox16.Text = reader(15).ToString() End While reader.Close() End Using End Sub End Class Imports System.Net.Mail Public Class Form6 Public x As Integer Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click ' x = Rnd(1000) x = CInt(Math.Floor(1 + 10000 + 1) * Rnd()) + 1 'MessageBox.Show(x) TextBox5.Text = (x) Dim EmailMessage As New MailMessage() Try EmailMessage.From = New MailAddress("poornima22144@gmail.com") EmailMessage.To.Add(TextBox3.Text) EmailMessage.Subject = "testmail" EmailMessage.Body = (TextBox5.Text) Dim SMTP As New SmtpClient("smtp.gmail.com") SMTP.Port = 587 SMTP.EnableSsl = True SMTP.Credentials = New System.Net.NetworkCredential("poornima22144@gmail.com", "vijaykumar") SMTP.Send(EmailMessage) MsgBox("Mail Sent") Catch ex As Exception ' MsgBox(error_t.ToString) End Try End Sub Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click If TextBox4.Text = x Then MsgBox("Marks Validated") Else MsgBox("Not Validate") End If End Sub End Class Imports System.Data.OleDb Imports System.Net.Mail Public Class Form7 Dim con As New OleDbConnection Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim sql As String = "select * from student where regno='" + TextBox1.Text + "'" Dim dataadapter As New OleDbDataAdapter(sql, con) Dim ds As New DataSet dataadapter.Fill(ds, "student") DataGridView1.DataSource = ds DataGridView1.DataMember = "student" ' Try ' Dim Smtp_Server As New SmtpClient ' Dim e_mail As New MailMessage() 'Smtp_Server.UseDefaultCredentials = False 'Smtp_Server.Credentials = New Net.NetworkCredential("rasa.research@gmail.com", "9655155104") 'Smtp_Server.Port = 587 'Smtp_Server.EnableSsl = True 'Smtp_Server.Host = "smtp.gmail.com" 'e_mail = New MailMessage() 'e_mail.From = New MailAddress("rasa.research@gmail.com") 'e_mail.To.Add(TextBox2.Text) 'e_mail.Subject = "Email Sending" 'e_mail.IsBodyHtml = False 'e_mail.Body = "" 'Smtp_Server.Send(e_mail) 'MsgBox("Mail Sent") 'Catch error_t As Exception ' MsgBox(error_t.ToString) 'End Try Dim m1 As Integer Dim m2 As Integer Dim m3 As Integer Dim m4 As Integer Dim m5 As Integer Dim m6 As Integer Dim tot As Integer Dim res As String Using con1 As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\ms.accdb") Dim command As New OleDbCommand(sql, con1) con1.Open() Dim reader As OleDbDataReader = command.ExecuteReader() While reader.Read() m1 = reader(7).ToString() m2 = reader(8).ToString() m3 = reader(9).ToString() m4 = reader(10).ToString() m5 = reader(11).ToString() m6 = reader(12).ToString() tot = reader(13).ToString() res = reader(15) End While reader.Close() End Using 'MsgBox(m1) Dim k As String k = " Mark1:" + m1.ToString + " Mark2:" + m2.ToString + " Mark3:" + m3.ToString + " Mark4:" + m4.ToString + " Mark5:" + m5.ToString + " Mark6:" + m6.ToString + " Total:" + tot.ToString + " Result :" + res.ToString 'MsgBox(k) Dim EmailMessage As New MailMessage() Try EmailMessage.From = New MailAddress("poornima22144@gmail.com") EmailMessage.To.Add(TextBox2.Text) EmailMessage.Subject = "testmail" EmailMessage.Body = k Dim SMTP As New SmtpClient("smtp.gmail.com") SMTP.Port = 587 SMTP.EnableSsl = True SMTP.Credentials = New System.Net.NetworkCredential("poornima22144@gmail.com", "vijaykumar") SMTP.Send(EmailMessage) MsgBox("Mail Sent") Catch ex As Exception MsgBox(ex.Message) End Try End Sub Private Sub Form7_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\ms.accdb" con.Open() con.Close() End Sub End Class C) SAMPLE INPUT LOGIN RESULT ALERT SYSTEM STUDENT INFORMATION MARKSHEET VERIFICATION SYSTEM RESULT ANNOUNCEMENT D) SAMPLE OUTPUT LOGIN RESULT ALERT SYSTEM STUDENT INFORMATION MARKSHEET VERIFICATION SYSTEM RESULT ANNOUNCEMENT 38