Table of Content
| Project Briefing | 3 |
|---|---|
| Customer Requirements | 4 |
| Functional Requirements That Are Meet: | 5 |
| Comparison Between Past and Present | 6 |
| Hardware/ Software Requirements | 7 |
| Data Flow Diagram | 8 |
| Application Flowchart | 9 |
| Sql Queries | 10 |
| Application Features | 12 |
PROJECT BRIEFING
Attendance Management System is software developed for daily student attendance in schools, colleges and institutes.
It facilitates to access the attendance information of a particular student in a particular class.
The information is sorted by the operators, which will be provided by the teacher for a particular class.
This system will also help in evaluating attendance eligibility criteria of a student.
PURPOSE
The purpose of developing attendance management system is to computerized the tradition way of taking attendance.
Another purpose for developing this software is to generate the custom report at the end of the session or in the between of the session.
Another reason for developing this project is to enhance our learning skill and applying the application in the required area.
CUSTOMER REQUIREMENTS
The proposed system should be user friendly, the retrieval and storing of data should be fast and data should be maintained efficiently. Moreover the graphical user interface should be provided in the proposed system, which provides user to deal with the system very easily. The proposed system requires very less paper work. All the data is feted into the computer immediately and reports can be generated through computers. Moreover work become very easy because there is no need to keep data on papers.
-
First Frame will be of Class Batch Code Registration in which the user can add new batch code, teacher name and subject, Batch days ( TTS , MWF ) and batch timings (9 to 11,11 to 1, 3 to 5, 5 to 7 , 7 to 9) etc.
-
Second Frame will be of Students Registration where user can add the information about the student Example Details of a Student are as follows
-
Enrollment No.
-
Student Name
-
Student Batch Code
Make the required database table for both Batch Code Registration and Student Registration Frame in the systematic order with following the table normalization rules.
- After all registrations a Attendance frame will be created where teacher will select the Present student from the student names list in a particular batch code after this , enrollment no would be automatically displayed of that particular student. On clicking Mark Attendance Button, the attendance should be marked.
Note: Record of time and date of attendance marking is necessary of every student.
Make the required database table for Attendance frame in the systematic order with following the table normalization rules.
- Reports can be easily generated in the proposed system so teacher can generate the report as per the requirement (monthly) or in the middle of the session. So teacher can give the notice to the students so he/she become regular. Required Reports are as follows
-
Monthly Students Wise Present and Absent Report
-
Export the above Report in Excel Sheet.
FUNCTIONAL REQUIREMENTS THAT ARE MEET
-
There is a login panel for both user and admin.
-
Stored Procedures are used for login in order to keep the security measures high. And saving from SQL Injection.
-
User can only mark the attendance for batches assigned him/her.
-
The reports can be generated either for individual student or for whole class
-
The admin is responsible for all deleting and updating.
-
Admin has rights for add/removing/updating teacher/student/batch
-
Every student and teacher is having a unique Enrollment no.
-
Admin can generate report for all batches and students.
-
Jar file is also created to run the project
WORKING OF PRESENT SYSTEM
In the present system all work is done on paper. The whole session attendance is stored in register and at the end of the session the reports are generated. We are not interested in generating report in the middle of the session or as per the requirement because it takes more time in calculation. At the end of session the students who don’t have 75% attendance get a notice.
DISADVANTAGES OF PRESENT WORKING SYSTEM
-
Not User Friendly: The existing system is not user friendly because the retrieval of data is very slow and data is not maintained efficiently.
-
Difficulty in report generating: We require more calculations to generate the report so it is generated at the end of the session. And the student not get a single chance to improve their attendance
-
Manual control: All calculations to generate report is done manually so there is greater chance of errors.
-
Lots of paperwork: Existing system requires lot of paper work. Loss of even a single register/record led to difficult situation because all the papers are needed to generate the reports.
-
Time consuming: Every work is done manually so we cannot generate report in the middle of the session or as per the requirement because it is very time consuming.
ADVANTAGES OF THE PROPOSED SYSTEM
-
User Friendly: The proposed system is user friendly because the retrieval and storing of data is fast and data is maintained efficiently. Moreover the graphical user interface is provided in the proposed system, which provides user to deal with the system very easily.
-
Reports are easily generated: reports can be easily generated in the proposed system so user can generate the report as per the requirement (monthly) or in the middle of the session. User can give the notice to the students so he/she become regular.
-
Very less paper work: The proposed system requires very less paper work. All the data is feted into the computer immediately and reports can be generated through computers. Moreover work becomes very easy because there is no need to keep data on papers.
-
Computer operator control: Computer operator control will be there so no chance of errors. Moreover storing and retrieving of information is easy. So work can be done speedily and in time.
HARDWARE/ SOFTWARE REQUIREMENTS
Hardware
-
Windows 10
-
Java Virtual Machine
Software
Combination of the following Software’s are to be used:
-
Net Beans 8
-
Java Development Kit (JDK)1.7
-
SQL Server 2008
-
ODBC
DATA FLOW DIAGRAM
APPLICATION FLOWCHART
SQL QUERIES
APPLICATION FEATURES
Main frame
User Login and Admin login
User (teacher) login Panel
Admin login
If the username and Password is correct it will show welcome message but if username or password is incorrect then it will show error message
User main frame after login
Here only signed in user batches will appear
The student and class buttons are disabled. They will enable when user will select the batch code and press the next button
After selecting batch and clicking next button student and class button will be visible
For individual attendance teacher can select Student and for whole class attendance can be marked
Student Attendance
User can select Student name from combo box student id, student batch, teacher name, student days and timings are filled automatically
Class Attendance Frame
Semester Name will be filled automatically through batch code
User will select the date and by clicking on table button the batch student will appear
And by checking the box present will be marked and by through uncheck absent will be marked
Table Button will fetch the data and mark button will mark the student attendance and will show message
User cannot mark attendance for future dates if he/she do so then a popup message will appear
And Mark attendance button will become disable to user until and unless user chooser current date or pervious date
To mark absent student attendance user can use Mark Absent Student Attendance Button
Through this frame user can mark absentees attendance only
It will only ask for date on which user can mark absentees’ attendance
As soon as user select the date book and session will be fill out
And the in the same way user will fetch the data and mark attendance for absentees’
User can go back through this arrow button
Reports can be generated either through excel or pdf
This is whole batch report
For custom report user can use search enter and combo to select
Teacher can change pass and other information through setting
Save button will show this message if all the information is entered correctly
Else it will show error
This arrow takes back to the batch selection frame
Through exit button teacher will close the windows and Sign Out
Admin Frame
.
Teacher Button will open Teacher’s Frame
From here new teacher can be added and details can also be seen.
Validation is applied
Add button will add new teacher
Remove button will remove the teacher
Update button will update the teacher information
Clear button will clear the text fields
View all button will show all the teacher in the table
Student Button will open student Frame
From here new student can be added and details can also be seen.
Validation is applied
As admin select the Batch for student, student timing, days, semester, and book will fill out automatically
Add button will add new student
Remove button will remove the student
Update button will update the student information
Clear button will clear the text fields
View all button will show all the student in the table
Batch Button will open batch’s frame
From here new batch can be added and details can also be seen.
Validation is applied
Add button will add new batch
Remove button will remove the batch
Update button will update the batch information
Clear button will clear the text fields
View all batch will show all the teacher in the table
By Clicking on DashBorad Button main window appear
Reporting can be done in four different
-
Firstly admin can get the all batches report
-
Secondly Student and batch report
-
Thirdly all batches with custom date
-
And lastly selected batch with custom date
Ways through three different means
-
Excel file
-
PDF file
-
Print Command
Admin panel will be close by this