A
Project Report
On
“STUDENT ATTENDANCE MANAGEMENT SYSTEM”
Submitted in Partial Fulfillment of the Requirements for the
Award of the Degree of
Bachelor of Science (IT)
in
Submitted by
SHIVAM SINGH (20221010130001O)
VAISHNAVI SINGH (202210101300022)
HARSH VISHWAKARMA(202210101300024)
Under the Guidance of
DR. NITYA NANDA DIWEDI
Assistant Professor
Department of Computer Science & Information Systems
Shri Ramswaroop Memorial University
Lucknow – Deva Road, Barabanki (UP)
DECLARATION
I hereby declare that the project report entitled ”Student attendance management system
Website” submitted by us to Shri Ramswaroop Memorial University, Lucknow – Deva
Road, Barabanki (UP) is the partial requirement for the award of the degree of the
Bachelor of Science in Information. Technology is a record of bonafide project work
carried out by us under the guidance of “DR. NITYA NANDA DIWEDI”. I further
declare that the work reported in this project has not been submitted and will not be
submitted either in part or in full for the award of any other degree in this institute.
Place: Shri Ramswaroop Memorial University
Date:
Signature of students
SHIVAM SINGH
Signature of students
VAISHNAVI SINGH
Signature of students
HARSH VISHWAKARMA
ABSTRACT
The student attendance management report is being developed to
revolutionize the way students mark attendance and the way they attended
class experience tailored specifically for college and school attire. The project
is designed with a focus on accessibility, ensuring that students and parents
can easily browse, select, and purchase the required uniforms from a
comprehensive and organized catalogue. The frontend of the platform, built
using HTML, CSS, and JavaScript, will prioritize user experience, offering a
visually appealing design that is intuitive to navigate. This combination of
technologies ensures that the platform is not only attractive but also highly
responsive, adapting to various devices and screen sizes for a consistent user
experience. The backend of the platform will be developed using robust
technologies such as Python or Java, integrated with a database management
system like SQL or MongoDB to efficiently handle and store product
information, user data, and order histories. This architecture will allow for
secure and reliable transactions, ensuring that sensitive customer information
is protected at all times. Additionally, the platform will feature user account
management, where student can view their attendance history, track current
orders, and save preferences for future purchases. This level of functionality is
essential in creating a trustworthy and efficient shopping environment.
Furthermore, the platform will be designed to support scalability,
accommodating future growth in both product offerings and user base. As
educational institutions increasingly move towards digital solutions, this e-
commerce platform will serve as a crucial tool for schools and colleges,
simplifying the process of uniform distribution. By offering a centralized
online marketplace, the platform aims to reduce the logistical challenges
associated with uniform procurement, ensuring that students have easy access
to the required attire, delivered directly to their homes. This project is poised
to make a significant impact in the educational sector by modernizing the
uniform purchasing process, making it more convenient and efficient for all
stakeholders involved
SHRI RAMSWAROOP MEMORIAL UNIVERSITY
Department of Computer Science & Information
Systems
Certificate
This is to certify that this Major Project report of BSC (IT). Final Year,
entitled “student attendance management report”, Submitted by Shivam Singh
(202210101300010), Vaishnavi
Singh(202210101300022and Harsh Vishwakarma (202210101300024),
is a record of bonafide work carried out by them, in the partial
fullfillment with Degree of Bachelor of Information Technology, Shri
Ramswaroop Memorial University, Lucknow – Deva Road, Barabanki
(UP). This work is done during the Academic Year 2024 – 2025under
my supervision and guidance.
Date:
Guided & Approved By
Under the Supervision Project In-charge
Dr. Nitya Nanda Diwedi Mr. Ashok Masih
(Assistant Professor) (Assistant
Professor)
Head of Department
Dr. Bineet Kumar Gupta
(Professor & Head)
Acknowledgement
The satisfaction that accompanies that the successful 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 owe a great many thanks to great many
people, who assisted and helped me during and till the end of the project.
We would like to express our gratitude towards Dr. Bineet Kumar Gupta,
Head of Department - Computer Science & Information Systems, Shri
Ramswaroop Memorial University, Lucknow – Deva Road, Barabanki
(UP), for his guidelines and scholarly encouragement
We are in debted to Dr.Nitya Nanda Diwedi– Assistant Professor,
Computer
Information Systems of Shri Ramswaroop University, Lucknow –
Deva Road, Barabanki (UP) for their valuable comments and
suggestions that have helped us to make it a success
The valuable and fruitful discussion with them was of immense help
without which it would have been difficult to present this project in
live.
We gratefully acknowledge and express our gratitude to all faculty members
and friends who supported us in preparing this project report.
Finally, this acknowledgement is incomplete without extending our deepest
– felt thanks and gratitude towards our parents whose moral support has
been the source of nourishment for us at each stage of our life.
SHIVAM SINGH(202210101300010)
VAISHNAVI SINGH(202210101300022)
HARSH VISHWAKARMA(202210101300024)
TABLE OF CONTENTS
1. Introduction 01-04
1.1 About the System 02
1.2 Existing System 03
1.3 Proposed System and advantages 04
1.4 Objective 04
1.5 Scope of the system 04
2. System Analysis 05-07
2.1 Feasibility study
2.1.1 Technical Feasibility 06
2.1.2 Economical Feasibility 06
2.1.3 Operational Feasibility 06
2.2 System Environment
2.2.1 Software Requirements 07
2.2.2 Hardware Requirements 07
3. System Tools 08-10
3.1 Java 09
3.2 JSP 09
3.3 MS-Access 09
3.4 Servlet 10
4. System Design 11-17
4.1 Module Description 12
4.1.1 Administrator Module 12
4.1.2 Staff Module 13
4.2 Use Case Diagrams 14
4.3 System Flow Diagram 15
4.4 Data Flow Diagram 16
4.5 E-R Diagram 17
5. Snapshots 18-22
5.1Front End 19
5.1.1 Login screen 19
5.1.2 Home page 19
5.1.3 Add Student 20
5.1.4 Add Staff 20
5.1.5 Student list 21
5.1.6 Output view 21
5.1.7 Update Password 22
5.2Back End
5.2.1 My SQL work Bench View 22
6. Testing 23-27
6.1Introduction 24
6.2Testing Methodologies 25
6.2.1 Unit Testing 25
6.2.2 System Testing 25
6.2.3 Performance Testing 25
6.3Test Cases 26
6.3.1 Agent and Admin Login Form 26
6.3.2 Master Form 27
7. Conclusion and future enhancements 28-29
7.1Conclusion 29
7.2Future Enhancements 29
8. References 30-31
Table of Figure
Figure 4.2 Use case Diagram 14
Figure 4.3System Flow Diagram 15
Figure 4.4Data Flow Diagram 16
Figure 4.5 ER Diagram 17
List of Tables
Table 6.3.1. Agent and Admin Login Form
Table 6.3.2. Master Form
CHAPTER - 1
INTRODUCTION
1.1 About the System:
Analysis can be defined as breaking up of any whole so as to find out their
nature and function etc. It defines design as to make preliminary sketches of; to sketch
a pattern outline for plan. To plan and carry out especially by artistic arrangement or in
a
Skill full wall. System analysis and design can be characterized as a set of techniques
and processes, a community of interests a culture and an intellectual orientation.
The various tasks in the system analysis include the following:
➢ Understanding application.
➢ Planning.
➢ Scheduling.
➢ Developing candidate solution.
➢ Performing trade studies.
➢ Performing cost benefit analysis.
➢ Recommending alternative solutions.
➢ Selling of the system.
➢ Supervising, installing and maintaining the system.
This system manages to the analysis of the report creation and develops manual
entry of the student attendance. First design the student’s entry form, staff allocation
and time table allocation forms. This project will help the attendance system for the
1
department calculate percentage and reports for eligibility criteria of examination.The
application attendance entry system will provide flexible report for all students.
1.2 Existing System:
The Existing system is an annual entry for the students. Here the attendance
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 retrieval of the information is
not as easy as their codes are maintained in the hand written registers.
This application requires correct feed on input into the respective field. Suppose
the wrong inputs are entered, the application resist to work. So, the user find it difficult
to use.
1.3 Proposed System & Advantages:
To overcome the draw backs of the existing system, the proposed system has
been evolved. 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 using this proposed system.
Advantages of Proposed System
➢ It is trouble-free to use.
➢ It is fast approach to enter attendance
➢ It is reliable, approximate result from user
➢ Best users interface
➢ Efficient reports
1.4 Objective:
“Attendance Management 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 username and password based
2
On the subject they handle. An accurate report based on the student attendance is
generated here. This system will also help in evaluating attendance eligibility criteria
of a student. Report of the student’s attendance on weekly and monthly basis is
generated.
1.5 Scope of the System:
The project can be implemented on intranet. Project can be updated in near
future as and when requirement for the same arises, as it is very flexible in terms of
expansion. With the proposed software of database Space Manager ready and fully
functional the client is now able to manage and hence run the entire work in a much
better, accurate and error free manner. The following are the future scope for the
project.
Discontinue of particular student eliminate potential attendance.
Face recognization based attendance
system.
Individual Attendance system with photo using Student login.
Location tracking and decline fake attendance.
3
CHAPTER 2
SYTEM ANALYSIS
2.1 Feasibility Study
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
feasibility to be determined. They are,
2.1.1. Technical Feasibility
The technical requirement for the system is economic and it does not use any
other additional Hardware and software. Technical evaluation must also assess
whether the existing systems can be upgraded to use the new technology and
whether the organization has the expertise to use it.
This application depends on Microsoft office and intranet service, database.
Enter their attendance and generate the report to excel sheet.
2.1.2 Economical Feasibility
Development of this application is highly economically feasible.
The only thing to be done is making an environment with effective supervision.
It is cost effective in the sense that has eliminated the paper work
completely. The system is also time effective because the calculations are
automated which are made at the end of the month or as per the user requirement.
2.1.3 Operational Feasibility:
4
The system working is quite easy to use and learn due to its simple but
attractive interface. User requires no special training for operating the system
technical performance includes issues such as determining whether the system can
provide the right information for the Department personnel student details, and
whether the system can be organized so that it always delivers this information at
the right place and on time using intranet services. Acceptance revolves around
the current system and its personal.
2.2 System Environment
2.2.1 Software Requirements
➢
Operating System- Windows 7 is used as the operating system as it is
stable and supports more features and is user friendly.
➢
Front-End: Java is used to develop front end Graphical User Interface.
➢
Database – Ms-Access is used as database as it easy to maintain and
retrieve records by simple queries.
2.2.2 Hardware Requirements
➢
Inter Core i3 is used as processor because it is relatively fast and
provide reliable and stable environment.
➢
RAM 1 GB is used as it will provide fast reading and writing
capabilities and will in turn support in processing.
➢
40 GB Hard disk is used to store database.
5
CHAPTER 3
SYSTEM TOOLS ANALYSIS
3.1 JAVA:
Java is a general-purpose Computer-Programming Language that is Concurrent,
Class-Based, Object-oriented, and specifically designed to have as few implementation
dependencies as possible. It is intended to let application developers
“Write once, run anywhere” (WORA), that can run on any Java Virtual Machine
(JVM) regardless of Computer Architecture. Java was originally developed by JAMES
GOSLING at SUN MICROSYSTEM (which has since been acquired by oracle
corporation) and released in 1995 as a core component of sun Microsystems Java
platform. The language derives much of its original features from Small Talk, with a
syntax similar to C and C++, but it has fewer low-level facilities than either of them.
3.2 JSP:
JSP is known as JAVA SERVER PAGES, is a technology that helps software
developer create dynamically generated web pages based on HTML, XML, or other
document types. Released in 1999 by SUN MICROSYSTEMS, JSP is similar to PHP
and ASP, but it uses the java programming language.
3.3 Ms-Access:
Microsoft Access is a Database Management System (DBMS) 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.
• Microsoft Access is just one part of Microsoft’s overall data management
product strategy.
6
• It stores data in its own format based on the Access Jet Database Engine.
• Like relational databases, Microsoft Access also allows you to link related
information easily. For example, Student and Fee Receipt data.
• It can also import or link directly to data stored in other applications and
databases.
• As its name implies, Access can work directly with data from other sources,
including many popular PC database programs, with many SQL (Structured
Query Language) databases on the desktop, on servers, on minicomputers,
or on mainframes, and with data stored on Internet or intranet web servers
• Access can also understand and use a wide variety of other data formats,
including many other database file structures.
• You can export data to and import data from word processing files,
spreadsheets, or database files directly.
• Access can work with most popular databases that support the Open
Database Connectivity (ODBC) standard, including SQL Server, Oracle,
and DB2.
3.4 SERVLET:
Servlets are the Java programs that runs on the Java-enabled web server or application
server. They are used to handle the request obtained from the web server, process the
request, produce the response, then send response back to the web server.
• MySQL Workbench is a unified visual tool for database architects,
developers, and DBAs. MySQL Workbench provides data modeling, SQL
development, and comprehensive administration tools for server
configuration, user administration, backup, and much more. MySQL
Workbench is available on Windows, Linux and Mac OS X.
• Apache Tomcat, often referred to as Tomcat Server, is an open-source Java
Servlet Container developed by the Apache Software Foundation (ASF).
Tomcat implements several Java EE specifications including Java Servlet,
7
Java Server Pages (JSP), Java EL, and WebSocket, and provides a "pure Java"
HTTP web server environment in which Java code can run.
• Google Chrome Browser is a cross-platform web browser developed by
Google. It was first released in 2008 for Microsoft Windows, and was later
ported to Linux, macOS, iOS, and Android. The browser is also the main
component of Chrome OS, where it serves as the platform for web apps.
8
CHAPTER 4
SYSTEM DESIGN
4.1 MODULE DESCRIPTION:
The system should be designed 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 always be in control of the application
and not the vice versa. The user interface should be consistent so that the user can
handle the application with ease and speed. The application should be visually,
conceptually clear.
4.1.1 ADMINISTRATOR MODULE:
• Student Details:
In this module deals with the allocation of roll no and personal details for new
batch. It will generate of personal details of student and academic details of the
students with the photos.
• Staff Details:
➢ It helps to a lot the subject and the subject code to the particular staffs.
➢ It provides the facility to have a user name and password to the staffs.
• Time table details:
➢ It will retrieve the subject information from the subject database and
assign time table to the staffs.
➢ It will help the admin, staff to make the entry of attendance based of the
subject and period allotted to the respective staff
• Attendance details:
➢ It will be makes to the attendance database all students. Entered
attendance to stored in the database subject, period wise into the
particular date.
➢ It will helps to the get report of weekly and consolidate of the attendance.
9
• Report details:
➢ weekly report get all hour details of attendance starting date to ending
date and display the status
➢ Consolidate report get all student attendance details starting date to
ending date status help for the eligibility criteria of the student to attend
the examination.
4.1.2 STAFFS MODULE:
• Attendance details:
➢ It assists the staff to mark attendance to the students for their
subject. This will authenticate the staff before making the entry.
• Report details:
1. weekly report get particular hour details of attendance from
starting date to ending date and display the status.
consolidate report get all student attendance details from starting date to ending date
status help for the eligibility criteria of the student to attend the examination
10
4.2 Use case Diagram:
A use case diagram in the Unified Modelling Language (UML) is a type of
behavioural diagram defined by and created from a Use-case analysis. Its purpose is to
present a graphical overview of the functionality provided by a system in terms of
actors, their goals (represented as use cases), and any dependencies between those use
cases. The main purpose of a use case diagram is to show what system functions are
performed for which actor. Roles of the actors in the system can be depicted
Figure:5.6 Use Case Diagram
The use case diagram is usually referred to as behaviour diagram used to
describe the actions of all user in a system. All user describe in use case are actors and
the functionality as action of system.
The Use case diagram is a collection of diagram and text together that make
action on goal of a process.
11
4.3 SYSTEM FLOW DIAGRAM:
System Flow Diagram is basically a graphical and sequential representation of the
major steps involved in a systematic process.
12
4.4Dataflow Diagrams:
13
4.5 ER-Diagram:
14
CHAPTER 5
SNAPSHOTS
5.1 Front End
5.1.1 Login Screen:
5.1.2 Home Page:
5.1.3 Add Student
15
5.1.4 Add Staff
5.1.5Students List
16
5.1.6 Output View:
17
5.1.7 View for changing Staff & student’s password:
5.1.8 MySQL Work Bench view :
( Showing how students table data looks like)
CHAPTER 6
18
TESTING
6.1 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 is 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 test that,
(1) Exercise the internal logic of software components, and
(2) Exercise the input and output domains of the program to uncover errors In
program function, behavior and performance.
(3) Steps: Software is tested from two different perspectives:
1. Internal 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.
19
6.2. Testing Methodologies:
A strategy for software testing must accommodate low-level tests that are
necessary to verify that a small source code segment has been correctly implemented as
wellas 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 a time when
deadline pressure begins to rise, progress must be measurable and problems must
surface as early as possible. Following testing techniques are well known and the same
strategy is adopted during this project testing.
6.2.1.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 data are stored in database and retrieved. If you
want required module to access input or get the output from the End user. any error will
accrue the time will provide handler to show what type of error will accrate.
6.2.2. 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 is must.
6.2.3Performance Testing
Performance testing is designed to test the run-time performance of software
within the context of an integrated system. Performance testing occurs throughout all
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.
20
This project reduces attendance table, codes. it will generate report fast.no have
extra time or waiting of results. entered correct data will show result few milliseconds.
Just used only low memory of our system. Automatically do not getting access at
another software. Get user permission and access to other applications.
6.3 Test Cases
6.3.1 Agent and Admin Login Form
Sno Test case id Test case Test case Step Expected Actual Test case
name desc result Result status
pass/fail
1 Login Validate loginTo verify Enter the Login Login Pass
admin that login login successful or successful
name on name and an error
login password message “In
page and click valid login
submit or password”
button must be
displayed
2 Login Staff Validate To verify Enter the Login Login Pass
login that login successful successful
login name or an error
name on and message
login password “In valid
page and click login or
submit password
button ” must be
displayed
21
3. Password Validate To verify Enter An error An error fail
password that password message message
password and login “password “password
on login name invalid” invalid”
page click must be must be
submit displayed displayed
button
22
6.3.2 Master Form
23
CHAPTER 7
CONCLUSION AND FUTURE ENHANCEMENTS
7.1 Conclusion
To conclude, Project Data Grid works like a component which can access
all the databases and picks up different functions. It overcomes the many
limitations incorporated in the attendance.
• Easy implementation Environment
• Generate report Flexibly
7.2 Future Enhancements
The project has a very vast scope in future. The project can be implemented on
intranet in future. Project can be updated in near future as and when requirement for
the same arises, as it is very flexible in terms of expansion. With the proposed software
of database Space Manager ready and fully functional the client is now able to manage
and hence run the entire work in a much better, accurate and error free manner. The
following are the future scope for the project. Discontinue of particular student
eliminate potential attendance.
➢ Bar code Reader based attendance system.
➢ Individual Attendance system with photo using Student login.
CHAPTER 8
24
REFERENCES
[1] Mc GrawHill’s , Java : The complete reference 7thEdition, Herbert Schildit
[2] Sachin Malhotra, Saurabh Choudhary, Programming in Java(2e)
[3] http://www.stackoverflow.com
[4] https://www.eclipse.org
25
