Institute OF Engineering & Technology Department of Computer Applications MINI PROJECT WORK 7,December,2016 This is to certify that the project entitled STUDENTS ATTENDANCE MANAGEMENT SYSTEM Is the bonafide record of mini project work done by Richa Panwar (1405214044) Pooja (1405214036) Namrata Srivastava(1405214032) of Master of Computer Applications during the year 2016-2017, Project Guide Head of the Department ‘Mr, Jayram Singh Mir, Manish Gaur Asst.Prot(Ss) Assoc, Prof& Head Submitted for the Mini Project Viva-Voce examination held on. Internal Examiner External ExaminerDECLARATION | affirm that the mini project work tited “STUDENT ATTENDANCE MANAGEMENT SYSTEM” being submitted in partial fulfillment for the award of Master of Computer Applications i the onginal work camed out by me. It has pot formed the part of any other project work submitted for award of any degree or diploma, cither in this or any other University.ABSTRACT Student attendance management system deab with the maintenance of the student's attendance details. It is generates the attendance of the student on basis of Presence in class. It & maintained on the daily basis of their attendance. the staffs will be provided with the separate username & password to make the student's status, The swili handling the particular subjects responsible to make the attendance for all students. Only if the student present on that particular period, the attendance will be caloulited, The students attendance reports based on weekly and consolidate will be generatedACKNOWLEDG T ‘The satisfaction that accompanies that the successfil completion of any task would be incomplete without the mention of people whose ceaseless cooperation made it possible, whose constant guidance and encouragement crown all efforts with success We are grateful to our project guide Mr. Jayram Singh for the guidance, inspiration and constructive suggcstions that helpful us in the preparation of this project. We also thank our colleagues who have helped in successful compktion of the project. Pooja (1405215036) Namrata Srivastava (1405214032) Richa Panwar (1405214036)Purpose System implementation is the important stage of project when the theoretical des ign is tuned into practical system, The main stages in the implementation are as follows: ‘Planning Training 7 System testing and ) Changeover Planning Planning is the first tusk in the system implementation, At the tims of implenwatation of any sysiem peopk from diferent departments and system analysis involve, They are confirmed to practical problem of controlling various activities of people outskle their own data processing departments, ‘The line managers controlled through an implementation coordinating committee. ‘The committee considers ideas, problems and complaints of user department, it must also consider: The implication of system environment Self selection and allocation for implementation tasks Consultation with unions and resources: available Standby facilities and channels of communication Student Attendance management system will implement student details staff handle subjects dewik, separate login dewils time table dewik, [twill used to entered subject wise attendance .This apphcation chborate attendance table generate weekly, consolidate report provide to the End user. Mostly this application will calculate date wise attendance .To select starting date to end date generate reports at the time of activities.ACKNOWLEDGEMENT. ABSTRACT. INTRODUCTION... OBJECTIVES... SYSTEM ANALYSI INTRODUCTION sisssssssssssencersserenseserareneresareenssesseestenrseerenesets EXISTING SYSTEM... PROPOSED SYSTEM: FEASIBILITY STUDY Eeonomically Feasibility... Technical feasibility: Operational Feasibil SYSTEM SPECIFICATION HARDWARE REQUIREMENTS (Minimum Requirement)... SOFTWARE REQUIREMENTS (minimum Requirement) .. Software Description Netbeans [JE 8,2... Best Support for Latest Java Technologies... Fast & Smart Code Editing... Eusy & Efficient Project Management O-level-DFD 0.10 I-leve LDFD.. 2-kve-DFD.. OUTPUT DESIGN oi sssissississsssssssecseesseniseniennies Data Tables... PRoIeCT ne“Attendance Mattagement System” is software developed for maintaining the attendance of the student on the daily basis in the collage, Here the staffs, who are handling the subjects, will be responsible to mark the attendance of the students, Each staff will be given with a separate usemame and password based on the subject they handle, An accurate report based on the studem attendance i generated here. This system will also help in evaluating attendance eligibility criteria of a student, Report of the sticent's attendance on weekly and monthly basis is generatedMinimum RAM:-1GB Hard Disk:+128 GB Processor:-Intel Pentium 4( 1.50 GHZ) orabove SOFTWARE REQUIREMENTS k Operating system ;Windows 7 Froat_Design:Netbeans IDE 8.2 Front-End Language : CORE JAVA Back-End : MysqlEconomically Feasibility: Development of this application is highly economically feasible. The only thing be done is making an environment with an effective supervision, Its costeffective in the sense that has eliminated the paper work completely. The system is ako time effective because the calcultions are automnted which are made at the end of the month or us per the user requirement. ‘Technical feasibility: ‘The technical requirement for the system is economic and it does not use any other additional Hardware and software. Technical evaluation must abo assess whether the existing systems can be upgraded 1 use the mew technology and whether the organization has the expertise to use it. Install all upgrades framework into the .Net package supported widows based application. this application depends on Microsoft office and intranet service database, Enfer their attendanwe and generate report to excel sheet. Qperntional_ Feasibility: ‘The system working is quite easy to we and kam due to as simple but attractive interface. User requires no special training for operating the system Technical performance include issues such as determining whether the system can provide the right information for the Department personnel student detits, and whether the system can be orginiacd s that it abvays delivers this information at the right plice and on time using intranet services, Acceptance revolves around the Current system and its personalEXISTING SYSTEM : Existing system is a manual eniry for the students. Here the atiendance will be carried out in the hand written registers, It will be a tedious job to maintain the record for the user, The human effort is more here, The retriewal of the information is not as cusy as the records are maintained in the hand written registers, This application requires corrvet feed on input into the respective field, Suppose the wrong inputs are enlered, the application resist to work, so the user find il difficult to use. PROPOSED SYSTEM; To overcome the drawbacks of the existing system, the proposed system has been evahed, This project aims to reduce the paper work and saving time to generate accurate results from the student's attendance, The system provides with the best user interface, The efficient reports can be generated by wsing this proposed system. Advantages of Proposed System “ Itis trouble-free to uve, tis a relitively fist approach to enter attendance © Ishighly relisble, approximate resull from user © Best user Interface Efficient reports ERASIBILITY STUDY: Feasibility analysis begins once the goals are defined. It starts by generating broad possible solutions, which are possible to give an indication of what the new system should look lime, ‘This is where creativity and imagination are used, Analysts must think up new ways of doing things: generate new ideas, ‘There is no need to go into the detailed system operation yet. ‘The sokition should provide enough information 10 make reasonable « Wes about project cost und give users an indication of how the new system will fit into the onginization. It 8 important not to exert considerable eflvrt al this stage only to find out that the project is not worthwhile or that there i a need significantly change the original goal. Feasibility of a new: system means ensuring that the new system, which we are going to implement, is efficient and affordable, ‘There are various types of feasibility to be determined, ‘They are,INTRO! ION Analysis can be defined as breaking up ofany whok so as to find out their nature, fiction etc, It defines design as to make preliminary sketches of to sketch a pattem or outline for plan, To plan and cary out especially by anistic arrangement or in a skillful wall System analysis and design can be characterized as a sct of techniques and processes, a community of interests, a culture and an intellectual orientation, ‘The various tasks in the system analysis inchde the following, Understanding application, Planning, Scheduling. Developing candidate sohition, Performing trade studies. Performing cost benefit analysis Recommending alemative soktions, Selling of the system. supervising, instaling and mining the system, ‘This system manages to the analysis of the report creation and develops manual entry of the student attendance. First design the students entry form , staff’ allocation and time table allocation forms. This project will helps the attendance system for the department cakculite percentage and reports for cligibility criteria of examination The application attendance entry system will provide flexible report for all students.Software Description Netbeans IDE 8.2 Best Support for Latest Java Technologies NetBeans IDE is the official IDE for Java 8, With is editors, code analyzers, and converters, you can quickly and smoothly upgrade your applications to use new Java 8 language constructs, such as lambdas, fictional operations, and method! references. Batch analyzers ard converters are provided to search through multiple applications at the same tine, matching pattems for conversion to new Java 8 kinguage constructs With its constantly improving Java Editor, mony rich futures and an extensive range of took, templates and samples, NetBeans IDE sets the standard for developing with cutting ecge teemologies aut of the box. Fast & Smurt Code Buiting An IDE is much more than a text editor, The NetBeans Editor indents lines, matches words and brackets, and highlights source code syntactically and semantically, It kets you easily refactor code, with a range of handy and pewerlil took, while it also provides code templates, coding tips, and code generators, The editor supports muny linguayes from Java, C/C++, XML and HTML, to PHP, Groovy, Javadoc, JavaScript and JSP, Because the editor & extensible, you can phig in support fir many other languages. Fasy & Elficient. Project Management Keeping a ckar overview of large applications, with thousands of folders ard files, and millions of lines of code, & a daunting task. NetBeans IDE provides difitremt views of your data, ftom mulliple project windows to helpfil too’ for setting up your applications and managing them efficiently, leting you drill down into your data quickly and easily, while giving you versioning tools via Subversion, Mercurial, and Git integration out of the box. When new developers join your project, they can understand the structure of your application because your code is well-organized. MySql MySQL. is a database management system,A database & a structured collection of data. It may be anything ftom a simple shopping list to a picture gallery or the vast amounts of information in a corporate network, To add, access, and Process data stored in a computer database, you need a database management system such as MySQL. Since computers are very good at handling large amounts of data, database management phys a central role in computing, as stand-alone utilities, or as parts of other applications. MySQL is arelitional database mamagement system. ‘A relational database stores data in separate tables rather than putting all the data in one big storeroom This adds speed and flexibility. The tables are linked by defined relations making it possible to combine data from several tables on request. The SQL part of MySQL stands for “Structured Query Language” - the most common standardized language used to access databases, MySQL & Open Source Software. ‘Open Source means that it is possible for anyone to use and modify. Anybody can download MySQL fiom the Intemet and use it without paying anything Anybody so inclined can study the source code and change it to fit their needs. MySQL uses the GPL (GNU General Public lLivense) to define what you may and may not do with the software in different situations. If you feel uncomfortable with the GPL or need t embed MySQL ino a commercial application you can buy a commercially licensed version ftom us, Why use MySQL? MySQL is very fast, reliable, and easy to use, If that is what you are looking for, you should give it atry. MySQL ako. has a very practical set of features develaped in very close cooperation with our uscrs. You can find a performance comparkon of MySQL to some other database managers on our benchmurk page. See section 5.1.4 The MySQL Benchmark Suite, MySQL was originally developed to handle wery large databases much faster than existing solitions and has been successfully used in highly demanding production environments for several years, Though under constant development, MySQL today offers a nich and very usefid set of functions, The connectivity, speed, and security make MySQL highly suited for accessing databases on the Intemet. The technical features of MySQL For advanced technical information, sce section 6 MySQL Language Reference. MySQL is a clent/server system that consists ofa multi-threaded SQL server that supports different. backends, several different client programs and libraries, administrative took, and several programming interfaces. We abo provide MySQL as a multi-threaded lbrary which you can link into your appleation to get a smaller, faster, easier to manage product, MySQL has a lot of contributed software available.Data Tables LOGIN = Password User_type pooi Administrator 102 ‘Namrata User ATTENDANCE_TABLE: Stu jd | Stu_pame | Stu_course | Stu_sem | Stu subjea | Day Month 201 pooja MCA 5 java 1 december 202 namrata | MCA 3 ava T december [203 [rica aca Ts java a december | ‘Ths system developed will reduce the manual work and avoid redundant data, By maintaining the attendance manually, then efficient Teports cannot be generated, ‘The system can generate efficient weekly,comoalidate report based on the attendance, As the attendances are maintained in registers it hax been a tough task for admin and staff 10 maintain for long time, Instead the software -can keep long and retrieve the information when needed. PROJECT OVERVIEW Attendance Management. System basically has two rnin modules. for proper functioning Admin modike is has. for crea new of freully and student details. a iit! = ¥ User has a rights of making daily attendance, generating report. Autendance report can be taken by given deus of student details, date, cliss. MODULE DESCRIPTIONIGN Input design is part of overall system design that requires special attention designing input data is to make the data entered easy and free from errars, The input forms are designed using the controls available in .NET framework. Validation is made for each and every data that is entered. Help information is provided for the users during when the customer feels difficult. Input design is the process of converting the user originated inputs to a computer based format. A system user interacting through a workstation must be able to tell the system whether to accept the input to produce reports. The collection of input data is considered to be most expensive part of the system design. Since the input has to be planned In such a manner so as to get relevant information, extreme care is taken to ‘obtain pertinent information This project first will entered to the Input of allacation forms It will be created an student details form and subject entry form, time table form .it will helps to calculate subject wise attendance system. next one if u want any verification on your data’s also available in details show forms, Attendance to entered single subject wise or all subject wise attendance system available in this project.OUTPUT DESIG Output design this application “Student Attendance management system” 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. The output is designed in such a way that it is attractive, convenient and informative. Forms are designed with various features, which make the console output more pleasing. ‘As the outputs are the most important sources of information to the users, better design should improve the system's relationships with us and also will help in decision making. Form design elaborates the way output Is presented and the layout available for capturing information. ‘One of the most important factors of the system is the output it produces. This system refers to the results and information generated. Basicallythe output from a computer system is used to communicate the result of processing to the user. Attendance management system to show the report subject wise attendance maintaining by staffs. Taken as a whole report obtain on a administrator privileges only. this forms will show weekly report and consolidate report generated date, batch, and class wise to our end user. we want to change our report to convert Excel format .if you want change any modification.Introduction Once source code has been generated, software must be tested to uncover (and correct) as many errors as possible before delivery to customer. Our goal ik to design a series of test cases that have a high likelihood of finding errors, To uncover the errors software techniques are used, These techniques provide systematic guidance for designing fest that (1) Exercise the intemal logic of sofware components, and (2) Exercise the input and output domains of the program to uncover errors: In program function, behavior and performance. Steps: Software i tested fiom two different. perspectives (1) Intemal program logic is exercised using —White box! test case design Techniques. (2) Software requirements are exercised using —block box! test case Design techniques, In both cases, the intent is to find the maximum: number of errors with the Minimum amount of effort and time, Testing Methodologies: Astralegy for sofware testing must accommodate low-level tests that are necessary to verify tut asmall source code segment has been correctly implemented as well as high- level tests that validate major system functions against customer requirements. A strategy must provide guidance for the practitioner and a set of milestones for the manager, Because the steps of the test strategy occur at atime when deadline pressure begins to rise, progress must be measurable and problems must surfice as carly as possible, Following testing techniques are well known and the same strategy is adopted during this project testingUnit testing: Unit testing focuses verification effort on the smallest unit of software design-the software component or module. The unit test is white-box oriented. The unit testing implemented in every module of student attendance management System. by giving correct manual input to the system the datas are stored in database and retrieved. If you want required moduk to access input or get the output from the End uscr. any crrot will accrued the time will provide handler to show what type of error will accrucd . System testing: System testing is actually a series of different tests whose primary purpose is to fully exercise the computer-based system Below we have described the two types of testing which have been taken for this project, it is to check all modules worked on input basis .if you want change any values or inputs will change all information. so specified input & must. Performance Testing Performance testing is designed to test the run-time performance of software within the context of an integrated system Performance testing occurs throughout alll steps in the testing process. Even at the unit level, the performance of an individual module may be assessed as White-box tests are conducted, ‘This project reduce attendance table, codes, t will generate report fist.no have extra time or waiting of results .cntered correct data will show result few millisecond. just used ‘only low memory of our system Automatically do not getting access at another software, Get user permission and access to other applications.‘The system shouk! bedesigned in such a way that only authorized people should be allowed to access some particular modules, The records should be modified. by only administrators and no one else, The user should abvays be in control of the application and not the vice versa, ‘The wer ierfiice shoukl be consistent so that the user can handle the application with ease and speed. The application should be visually, conceptually clear. ADMINISTRATOR MODULE: Student Details: In this module deals with the allocation of roll no and personal dewils for new batch. It will generate of personal detwik of student and academic details of the students with the photos, Teacher Detaily: Tt helps to allot the subject and the subject code to the particular staffs, ~ It provides the facility to have a user name and password to the stafis . Attendance deta | Wy will be makes 10 the attendance database all saxlens. Entered attendance to stored in the database subject ,period wise ino the particular date, Qo It will help s to the get report of weekly and consolidate of the attendance.Report details: Report can be ken by daily,weckly and consolidate: ll hour details of attendance starting date 10 end due and fephs te vane - Comoldate report get all student attendance detalk starting date to ending date status help for the elgbility ertcria of the student to atend the examination. TEACHER MODULE; | Attendance details: Reece: the staff to mark attendance to the students for their subject. This will authenticate the siaff before making the entry. | Report details: 1, weekly report get particulr hour details ofanendance from starting date to ending date and dlisphiy the status. 2. consolidate report get all student attendance detaik from starting date to ending date siatus belp for the clgibility criteria of the student to attend the examinationCONCLUSION AND FUTURE ENHANCEMENT “one! usio: To conclude, Project Data Grid works tke a component which can access all the databases and picks up different functions. Ttovercomes the many limitations incorporated in the attendance. Easy implementation Environment Generate report Flesibly Scope for future development ‘The project has a very’ vast scope in fiture, The project can be implemented on intranet in fiture, Project can be updated in near future as and when requirement for the same arises, as i is very flexible in terms of expansion With the proposed soffware of database Space Manager ready ‘and filly fimctional the clint is now able to manage and hence nun the entire work ina much better, accunite and error free manner. The following are the future scope for the project Discontinue of particukar student eliminate potential attendance, Bar code Reader based attendance system Individual Attendance system With photo using Student login,SYSTEM MAINTENANCE Software maintenance is far more than finding mistakes, Provision must be made for environment changes, which may affect either the computer, or other parts of the computer based systems. Such activity i normally called maintenance. It includes both the improvement of the system functions and the corrections of fivutts, which arise during: the operation of a new system, It may involve the continuing involvement of a kage proportion of computer department recourses, ‘The main task may be to adapt existing systems in a changing environment. Back up for the entire database files are taken and stored in storage devices like flash drives, pen drives andl disks so that itis possible to restore the system at the earliest, If there is breakdown or collapse, then the system gives provision to restore database files, Storing dat in a separate secondary device leads to an effective and efficient maintains of the system, The nominwted person has sufficient knowledge of the organization's computer passed based system to be able to judge the relevance of each proposed change,