See discussions, stats, and author profiles for this publication at: https://www.researchgate.

net/publication/380239538

Attendance Management System Project

Article in SSRN Electronic Journal · January 2024

DOI: 10.2139/ssrn.4810251

CITATIONS READS
97 21,792

1 author:

Kamal Acharya
Tribhuvan University
249 PUBLICATIONS 4,427 CITATIONS

SEE PROFILE

All content following this page was uploaded by Kamal Acharya on 09 May 2024.

The user has requested enhancement of the downloaded file.

[ATTENDANCE MANAGEMENT SYSTEM]

INTRODUCTION

Attendance Management System is a software developed for daily student attendance in schools,
colleges and institutes. If 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.

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 report
automatically at the end of the session or in the between of the session.

Electronic copy available at: https://ssrn.com/abstract=4810251

[ATTENDANCE MANAGEMENT SYSTEM]

OBJECTIVES

The main objective of this project is to computerize the manual system & reduce the time
consumption. In other words we can say that our project has the following objectives:-

1. Make the attendance system computerized

2. Reduce time consumption

3. Reduce error scope

4. Paper work is reduced as we need not to maintain registers for future references.

Electronic copy available at: https://ssrn.com/abstract=4810251

[ATTENDANCE MANAGEMENT SYSTEM]

PROJECT CATEGORY

This project as title “ATTENDANCE SYSTEM” is developed with the help of MS EXCEL
2007. This application is for stand alone system.

TOOLS/PLATFORM

This project is developed using the tools, which are most suited for development of the
Application Package. These tools are as follows: -

MS EXCEL 2007 (Macro Enabled programming)

MACROS

Basic Concepts:
1. A macro is a user-programmed routine that can be accessed by shortcut-keys.
2. Visual Basic for Applications (VBA) is a programming language used by Microsoft
Office Programs to allow the user to develop customized routines and functions.
3. Functions are routines that return values.

Features:
1. One approach for developing macros is by recording manual steps
2. Another approach is by loading Visual Basic files
3. The macros can be modified and enhanced by using the Visual Basic Editor.

Electronic copy available at: https://ssrn.com/abstract=4810251

[ATTENDANCE MANAGEMENT SYSTEM]

HARDWARE & SOFTWARE REQUIREMENT

HARDWARE:
Processor Pentium-II or higher

Processor Speed 533 MHZ

Hard Disk Space 20 GB (min.)

Ram Memory 32 MB (64 MB recommended)

SOFTWARE:
Operating System Windows XP/7

MS EXCEL 2007

Electronic copy available at: https://ssrn.com/abstract=4810251

[ATTENDANCE MANAGEMENT SYSTEM]

SYSTEM DESIGN

This project is designed to make the attendance system computerized. Computerized attendance
system provides the facility to feed the attendance easily and reduced manual work. Its easy to
calculate the total attendance of a particular student in a particular subject.

Here we used the MS EXCEL macros capability to computerize the manual attendance system.
The system is stand alone. The project is designed to allow the following features-
1. Feeding the student attendance with less time consumption
2. Report generation
3. Maintenance is easy

The project is designed in the way that it first requires login name and password for the purpose
of security so that no other person can feed the attendance. Then it gives the facility to view &
feed attendance and generate report.

Electronic copy available at: https://ssrn.com/abstract=4810251

[ATTENDANCE MANAGEMENT SYSTEM]

PROCESSING OF ATTENDANCE SYSTEM

USER LOGIN LOGIN

PROCESS
AFTER DATABASE
AFTER
AFTER LOGIN
LOGIN
LOGIN

VIEW
ATTENDANC REPORT
ATTENDANC
E ENTRY GENERATIO
E
REPORT
N
DATA
REQUEST ATTENDANCE
ATTENDANCE ENTRY DATABASE
DATABASE

FACULTY

Electronic copy available at: https://ssrn.com/abstract=4810251

[ATTENDANCE MANAGEMENT SYSTEM]

DATABASE DESIGN

Database Design in most important in any project. We are using the following table to store the
information:

LOGIN DETAIL:

Login id

Password

Status

CLASS DETAIL:

Course

Subject

Start session

End session

ATTENDANCE DETAIL:

Roll no

Name

Date

Electronic copy available at: https://ssrn.com/abstract=4810251

[ATTENDANCE MANAGEMENT SYSTEM]

E-R DIAGRAM

STU_NAME

PASSWORD STU_ROLL_N DATE

LOGIN
O
STATU
S

USER FEED ATTENDANCE

S CE

STU_NAME

STU_ROLL_N TOTAL_ATTENDANC
O E

GENERAT REPORT
ES

The above relationship is maintained in coding itself as the above mentioned E-R
diagram will be the proposed one for web enabled attendance system.

Electronic copy available at: https://ssrn.com/abstract=4810251

[ATTENDANCE MANAGEMENT SYSTEM]

MODULES USED IN THE PROJECT

This project includes the following modules for development of the project. These are as
follows: -

1. LOGIN FORM This form shows the Login name and password when user enter a valid user
name and password then he/she can operate the application.

2. MAIN FORM This form provides the option to view attendance, feed attendance and report
generation.

3. VIEW ATTENDANCE FORM This form provides the option to see the attendance name
wise, date wise and all.

4. FEED ATTENDANCE FORM This form provides the options to feed the attendance.

5. REPORT FORM This form shows the report of attendance of a particular class.

Electronic copy available at: https://ssrn.com/abstract=4810251

[ATTENDANCE MANAGEMENT SYSTEM]

SCREEN SHOTS

10

Electronic copy available at: https://ssrn.com/abstract=4810251

[ATTENDANCE MANAGEMENT SYSTEM]

11

Electronic copy available at: https://ssrn.com/abstract=4810251

[ATTENDANCE MANAGEMENT SYSTEM]

12

Electronic copy available at: https://ssrn.com/abstract=4810251

[ATTENDANCE MANAGEMENT SYSTEM]

13

Electronic copy available at: https://ssrn.com/abstract=4810251

[ATTENDANCE MANAGEMENT SYSTEM]

14

Electronic copy available at: https://ssrn.com/abstract=4810251

[ATTENDANCE MANAGEMENT SYSTEM]

15

Electronic copy available at: https://ssrn.com/abstract=4810251

[ATTENDANCE MANAGEMENT SYSTEM]

16

Electronic copy available at: https://ssrn.com/abstract=4810251

[ATTENDANCE MANAGEMENT SYSTEM]

17

Electronic copy available at: https://ssrn.com/abstract=4810251

[ATTENDANCE MANAGEMENT SYSTEM]

18

Electronic copy available at: https://ssrn.com/abstract=4810251

[ATTENDANCE MANAGEMENT SYSTEM]

19

Electronic copy available at: https://ssrn.com/abstract=4810251

[ATTENDANCE MANAGEMENT SYSTEM]

20

Electronic copy available at: https://ssrn.com/abstract=4810251

[ATTENDANCE MANAGEMENT SYSTEM]

21

Electronic copy available at: https://ssrn.com/abstract=4810251

[ATTENDANCE MANAGEMENT SYSTEM]

22

Electronic copy available at: https://ssrn.com/abstract=4810251

[ATTENDANCE MANAGEMENT SYSTEM]

23

Electronic copy available at: https://ssrn.com/abstract=4810251

[ATTENDANCE MANAGEMENT SYSTEM]

24

Electronic copy available at: https://ssrn.com/abstract=4810251

[ATTENDANCE MANAGEMENT SYSTEM]

25

Electronic copy available at: https://ssrn.com/abstract=4810251

[ATTENDANCE MANAGEMENT SYSTEM]

26

Electronic copy available at: https://ssrn.com/abstract=4810251

[ATTENDANCE MANAGEMENT SYSTEM]

27

Electronic copy available at: https://ssrn.com/abstract=4810251

[ATTENDANCE MANAGEMENT SYSTEM]

28

Electronic copy available at: https://ssrn.com/abstract=4810251

[ATTENDANCE MANAGEMENT SYSTEM]

FUTURE SCOPE OF THE PROJECT

Nothing is perfect in this world. So, we are also no exception. Although, we have tried our best to
present the information effectively, yet, there can be further enhancement in the Application. As
the project is stand alone application this can also be enhanced to be developed using dot net
framework (web enabled) so that information can be online and can seen by student’s parents and
all that need the information.

29

Electronic copy available at: https://ssrn.com/abstract=4810251

[ATTENDANCE MANAGEMENT SYSTEM]

BIBLIOGRAPHY
Acharya, Kamal. "Library Management System Minor Project Report On LIBRARY
MANAGEMENT SYSTEM." Authorea Preprints (2023).
Acharya, Kamal. "STUDENT INFORMATION MANAGEMENT SYSTEM." Authorea
Preprints (2023).

30

Electronic copy available at: https://ssrn.com/abstract=4810251

View publication stats