Interim Report - Attendance Monitoring System for a School

This interim report discusses the development of an attendance monitoring system for a school using XAMPP, HTML5, CSS3, JavaScript, PHP, and MySQL. It covers the background, literature review, initial design, and advantages of the system. The report also highlights the importance of security and authentication in the system.

Running head: INTERIM REPORT
Interim Report
Name of the Student
Name of the University
Author’s Note:

1INTERIM REPORT
Table of Contents
1. Background:...........................................................................................................................2
2. Literature Review:..................................................................................................................3
3. Initial Design:.........................................................................................................................9
Bibliography:............................................................................................................................13

2INTERIM REPORT
1. Background:
The project is undertaken for developing an attendance monitoring system for a
school. The project will be completed using the technologies like XAMP, HTML5, CSS3,
JavaScript, PHP and MySQL. The backend of the final product will process the collected data
and store in the school’s database. The project will develop a user interface for the users. This
user interface will be used for providing a understandable font end which is connected to the
system core. The school has three classes assigned to each year. A responsible person/staff
check the school register for two times a day. The timing for checking the register is 9 am
and 2 pm. The school wants the students to be present within the school by 8.30 am. If they
cannot reach school by that time, they will be marked as late present. The system will allow
the parent and staff of the school to login using the system. The system will show the
attendance graph based on the parameters like student attendance per class, student
attendance per year, student attendance for morning and student attendance for afternoon.
The system can automatically track the low attending students and generate reports for them.
The parent can see only their child’s attendance report.
The proposed student monitoring system can be developed by configuring the
software, hardware, information and human resources to track and manage the attendance of
the student. The system has a communication technology that can connect various parts of an
organization and generate a centralized process. The proposed case study for the report is
attendance monitoring system of a school. The attendance monitoring system module of the
school will maintain accurate and quick storing of attendance of the system. This system
module will be utilized for recognizing the indiscretions within the interest of academic of the
student. The module can also be accessed for identifying the reason of absence of the students
from the lectures and classes. The attendance monitoring system can assist in charging fines

3INTERIM REPORT
regarding late comings and absence. The school authorities can generate full attendance
reports and student attendance summary through this system module. It can be implemented
that the based on the percentage of the attendance, the student may be allowed to sit in the
exams.
The implementation of the attendance monitoring system can provide various
advantages to the operations of the school. The manual process of marking attendance usually
takes a lot of time. The proposed attendance monitoring system application will automatically
track the student attendance. The records of attendance is stored in a safe place and these
information can be retrieved easily from the database. The software module can record
accurate attendance information in a very less time. The system can automatically generate
reports and it saves a lot of time and human resource. The attendance monitoring system is
extremely scalable in nature can be used even if the school gets large.
2. Literature Review:
Bromham CofE Primary School developed the student monitoring system. The
system was able to cope with the small number of students at the beginning (Bromham CofE
Primary School 2019). However, once the number of student starts increasing, the system
was not able to handle the amount of requests and information. With the advancement in the
technology, the system should be upgraded so that system can function properly. Bromham
CofE Primary School developed its application by deploying it into cloud. The cost of the
development was decreased drastically and the school management decided to use that
money in better technology investment. The system allowed the school to access accurate
information. Bromham CofE Primary School was able to put into practice good leadership
through the use of the monitoring system. In order make the most of student monitoring
system, adequate reporting systems and record keeping was also considered. All these

4INTERIM REPORT
resulted into better and accurate student attendance tracking. The teacher and student both
were able to enhance their capability because the reports generated from the student
monitoring system could specify what the real issues are. The management of school also
utilized the student monitoring system for various planning (Lean System Society, 2019).
From the above description it is clear that the system has a lot of responsibilities and almost
all the operations are carried out accurately. No matter how well the system performs, no
technology is absolute. The system started to malfunction when the load was more than
normal. With the growing number of student, the processes student monitoring system
execute simultaneously also increased. In few years, the system will be backdated and not
able to cope up with the changing nature of the school (Ksrmccs.ac.in, 2019).
XAMPP
The XAMPP will provide the project team a local hosting environment. The browsers
are not able to process the backend codes written in PHP and MySQL. The XAMPP will
process those codes for the browser and show the intended information. The student
monitoring system cannot be developed without the XAMPP local host environment.
According to Zhao (2017), XAMPP is a package that is integrated in nature. This helps in the
processing of the project management regarding the interlinking of the packaging of the easy
host web sites and projection of the different platforms. Implementation of the Apache, which
is considered to be a popular web server, runs on the packaging of XAMPP. Perl is another
programming language that runs on the platform of XAMPP. Pro FTPD is a FTP server that
uses the packaging of XAMPP for commencing the project management that is required to be
performed by the Pro FTPD. Installation of XAMPP is not very difficult in nature. This is the
sole reason that the implementation of XAMPP I so very high in today’s society.
Downloading of the XAMPP installer helps in downloading of the XAMPP. Usage of the
default directory acts beneficial in installation of the entire application. The main issue that is

5INTERIM REPORT
present in the XAMPP system is that the port 80 is occupied by other programs and this will
lead to the fact that the management of installation might get affected in a negative manner.
According to Kennedy, B. and Musciano (2017), updates provided to XAMPP are
very regular in nature. Different instances of XAMPP can exist in one computer. The
different instance that are stored in the data base of the organization can be copied from one
computer too another computer. XAMPP is available in both the full versions and standard
version. The usage of the XAMPP is done by the designers in regards to the development of
the tools. The security that was present in the commencement of the project gets structured as
the designers needs to explore. This is the reason that the security aspect is disabled by
default settings. Password protection tool is provided along with the XAMPP in order to keep
the project protected.
MySQL
The project will be needed a data storage medium which can store the student,
attendance and other data to a secure place. The MySQL will be the data storage medium.
The SQL codes will be written as per MySQL. The MySQL SQL codes will store,
manipulate and retrieve student monitoring system data from the database. According to Hur
and Ubelhor (2017), MySQL was initially written in C++ and C programming platform.
Usage of dual licensing is provided with the MySQL project. The dual licensing is performed
with the help of the GPL versions. Oracle provides support to MySQL in terms of financial
prosecution. Maria DB and Percona also provides supports to the project management
system. With an increase in the versions of the MySQL, the ANSI SQL 99 subset is provided
as per the extension of the project. Cross platform support is also provided in the
management of the MySQL. Implementation of the online data definition language during the
usage of the InnooDB storage engine.

6INTERIM REPORT
According to Scherman and Smit (2017), a set of built in replication involves the fact
that the functioning of the entire system is performed as per the master slave methodology.
Query catching is one of the main advantage that are enjoyed by the prosecution of the
project completion. Implementation of the native storage engines gets performed in a better
manner. More than an update is launched for MySQL every month. This is the main reason
that the projects that are performed with the help of the MySQL are performed with highest
efficiency. The main issue that is present due to the implementation of MySQL is that the
default version of InnooDB does not comply with the MySQL that is standardized in nature.
MySQL can be installed with the help of the manual source code and this is the main reason
that the installation of the binary packages are done. Despite the fact that there are several
advantages, the main issue that is encountered includes imbalance in the scaling of the
platforms.
According to Zhang, Lv and Wang (2016), mysqldump acts as the logical backup tool
for better consumption of the data and managing the data that are stored in the data base.
XtraBackup is also another data securing device. This application helps in keeping the data
safe. This is one of the main reason that the projection of the MySQL gets implemented in a
greater extent. MySQL also provides the usage facility of graphical user interface.
Implementation of the third party proprietary helps in enhancing the command line interfaces.
MySQL workbench is one of the main reason that the integrated environment is taken into
consideration. Data base Workbench supports the functional aspect of the rational database.
Oracle database is considered to be one of the main reason that management of the project
gets performed in a better manner.
HTML

7INTERIM REPORT
The HTML will be the fond end code of the student monitoring system. The system
will provide a understandable and structured interface to the users through the HTML. The
forms, input fields, reports and other user understandable things will be developed using the
HTML. HTML will also be the medium of communication among backend codes and users.
According to Kennedy, B. and Musciano (2017), HTML helps in creating the building blocks
that are processed with the help of the constructs and images. The projection of the constructs
that are maintained will include the fact that the HTML can be embed the scripting language
as per the functioning of the JavaScript. The implementation of the World Wide Web
Consortium. Most of the values that are present includes the aspect of ismap. According to
Hur and Ubelhor (2017), the id attribute helps in getting the prospect that the commencement
of the entire project gets managed with the help of better managerial prospect. Escaping of
characters are considered to be one of the main problem that persists in the management of
the project. Implementation of the HTML5 and XHTML in the documents are termed to be
the major reason behind prosecution of the management. Escaping of the project also insists
the fact that the completion of the project that are not very easily typed gets
Student monitoring System
According to Scherman and Smit (2017), student monitoring system is created with
the help of XAMPP, MySQL and HTML. This system is mainly concerned with the
attendance tracking and checking the late comings of the students. This monitoring of the
students will help in understanding the track record of individuals. This ensures the fact that
the management of the project gets done with the help of the digital platform and analysis of
the carrier curve gets managed in a better manner.
Importance of security:

8INTERIM REPORT
According to Anjum and Kamble (2017), Student monitoring is very important in the
maintenance of the daily record of students. The functioning of the student monitoring system
framework is very sensitive in nature. Manipulation of the student monitoring system is very
high and this is the sole reason that the management of the student monitoring system must
be performed with higher efficiency. With an increase in advancement of the platform of the
flexibility of data management also gets increased. Understanding dependency of the
variables are very important and this is the main reason that the projection of the management
of the student monitoring system needs to be performed by personnel’s who has expertise in
this field.
All the discussions are made based on the similar projects. The basic architecture and
functional requirements are same for all the systems that have been considered while making
the literature review. According to Zhang, Lv and Wang (2016), the entire student monitoring
table can be accessed by two units. The units are namely the parents of the student and the
staffs’ of the school. Safety of the student monitoring system is very important as the
attendance % calculation is very important. In case there is any kind of miscalculation in the
percentage the main issue that will arise is that the projection of the attendance tracker will
fail to provide the correct data. As there is a direct access of the data base of the student
monitoring from the parent access, the students can itself can get the access of the portal and
enact on behalf of the parents. This issue must be ten into consideration. This issue can be
mitigated with the help of implementation biometrics in the student monitoring system. In
case of the implementation of the biometrics the main advantage that must be taken into
consideration is the face tracking. With the help of the face tracking authentication of the
entire system can be maintained.
Authentication of the entire system is needed to be maintained in order to stay
protected from the illegal access pf the students in the portal (Zhao 2017). This is the main

9INTERIM REPORT
reason that the projection of biometrics acts very important in regular functioning of the
student monitoring system. With higher authentication of the project the main advantage that
is present includes the fact that the data that will be generated will be accurate in nature.
Decision making will get easier with the help of the accurate data.

10INTERIM REPORT
3. Initial Design:
The main issue will be identifying the system designing models that can be used to
create the student monitoring system diagrams. One of the main functional requirement is
authentication. It states that the parent of the student will need to login to the system and
same for the staff of the school. The non-functional requirement is usability. It states that
school must design a simple form that can be easily understood by the parent and staff. The
second issue is the technology. Identification of the technology that can support the need of
the school and also be feasible in terms of complexity and capital needed is a critical task.
The attendance system can be developed suing the ASP.Net and SQL Server, PHP and
MySQL, Java Server Pages and Oracle. ASP.Net and SQL Server and Java Server Pages and
Oracle can provide better security and functionality to the system. Based on the case study
and complexity of work, the additional features ASP.Net and JSP offers are not essential for
the proposed attendance monitoring system.
Figure 1: Entity Relationship Diagram of Attendance Monitoring System
(Source: Created by Author)

11INTERIM REPORT
The entity relationship diagram proposed in the figure 1, shows the entities of the
attendance monitoring system for the students. The ERD shows that the database will hold all
the information of the students, like their name, roll number, class, date of birth and many
more. The studentID is the primary key of the entity. This studentID can allow the system to
recognize each student individually. The parent details will also be stored in the database.
The parent entity will also have a primary key named parentID and it will serve as the foreign
key of student entity. The parent and student entity will have one to many relation among
them as one parent can be guardian of many student but one student will have only one
guardian. The attendance will be marked for a student on a particular day. For this reason, the
attendance entity will have a composite primary key constructed with both studentID and
date. The status will identify whether the student was late, on time, on leave or something
else.

12INTERIM REPORT
Figure 2: Use Case Diagram of Attendance Monitoring System
(Source: Created by Author)
The use case diagram of the attendance monitoring system shows that four users will
be accessing the system. Each of these users has different activities to complete. The
administrator is the new actor about whom no discussion is made in the above sections. The
system will calculate the attendance based on some predefined rules. The administrator will
be responsible for changing this rules based on school management decisions. All the use
case are connected to at least one actor using the association relationship.
Figure 3: Class Diagram of Attendance Monitoring System
(Source: Created by Author)
The class diagram is created based on the information gathered in the entity
relationship diagram and use case diagram. The class diagram’s attributes are derived from
the findings in the ERD and the operations are created based on the findings in the class
diagram.

13INTERIM REPORT
Figure 4: Sequence Diagram of Attendance Monitoring System
(Source: Created by Author)
The sequence diagram shows the lifeline of the messages or operations. The sequence
diagram shows from which object the message flows and for how much time, the message
remains active.

14INTERIM REPORT
Bibliography:
Anjum, R. and Kamble, V., 2017. Student Tracking and Attendance Monitoring System
Using RFID. International Journal of Scientific Research in Computer Science, Engineering
and Information Technology, 2(2).
Bromham CofE Primary School. (2019). Bromham CofE Primary School. [online] Available
at: https://www.bromhamprimary.co.uk/ [Accessed 17 Jan. 2019].
Chong, G. and Jun, Z., 2017. Analysis and Design of Internet-based Library Management
System Based on UML. INNOVATION AND MANAGEMENT.
Dennis, A., Wixom, B.H. and Tegarden, D., 2015. Systems analysis and design: An object-
oriented approach with UML. John wiley & sons.
Fernández-Sáez, A.M., Genero, M., Chaudron, M.R., Caivano, D. and Ramos, I., 2015. Are
Forward Designed or Reverse-Engineered UML diagrams more helpful for code
maintenance?: A family of experiments. Information and Software Technology, 57, pp.644-
663.
Hur, C. and Ubelhor, L., 2017. Developing Business Applications for the Web: With HTML,
CSS, JSP, PHP, ASP. NET, and JavaScript. MC Press, LLC.
Idani, A. and Ledru, Y., 2015, November. B for modeling secure information systems.
In International Conference on Formal Engineering Methods (pp. 312-318). Springer, Cham.
Kennedy, B. and Musciano, C., 2017. HTML & XHTML. The Definitive Guide.
Ksrmccs.ac.in. (2019). [online] Available at:
http://www.ksrmccs.ac.in/wp-content/uploads/2011/11/Orissa_Education_201107301.pdf
[Accessed 17 Jan. 2019].

15INTERIM REPORT
Kumar, B. and Singh, K., 2015. Testing uml designs using class, sequence and activity
diagrams. International Journal for Innovative Research in Science and Technology, 2(3),
pp.71-81.
Lean System Society. (2019). Importance of School Monitoring And Evaluation Systems.
[online] Available at: http://leansystemssociety.org/importance-of-school-monitoring-and-
evaluation-systems/ [Accessed 17 Jan. 2019].
Meloni, J.C., 2017. PHP, MySQL & JavaScript All in One, Sams Teach Yourself.
Rumbaugh, J., Booch, G. and Jacobson, I., 2017. The unified modeling language reference
manual. Addison Wesley.
Scherman, V. and Smit, B., 2017. Using Mixed Methods to Explore the Validity of a
Secondary School Monitoring System: A Case From South Africa. SAGE Publications Ltd.
Schlieter, H., Burwitz, M., Schönherr, O. and Benedict, M., 2015, March. Towards Model
Driven Architecture in Health Care Information System Development.
In Wirtschaftsinformatik (pp. 497-511).
Soares, J.A.C., 2017. Automatic Model Transformation from UML Sequence Diagrams to
Coloured Petri Nets.
Zhang, X., Lv, P. and Wang, J., 2016. A method for materials knowledge extraction from
HTML tables based on sibling comparison. International Journal of Software Engineering
and Knowledge Engineering, 26(06), pp.897-926.
Zhao, A., 2017. XAMPP Apache+ MariaDB+ PHP+ Perl. Haettu osoitteesta https://www.
apachefriends. org/index. html (15.5. 2016).

16INTERIM REPORT