Thesis Sadsign

1.0 Introduction
In our life today, computer is one of the many inventions that greatly affected our way of living. In fact, it is regarded as an essential tool in any organization and establishment that exists. It can perform operation and process data rapidly, accurately and reliably and by using this task as easy as possible and nothing seems too tiring. Technological improvements can be useful tools to help in the development of new methods to eliminate the disadvantages of the classical methods while enhancing its advantages. Improving our technology will make us do our things faster than we thought. That is why we come up into the idea of improving the manual generating report on student attendance.
Generating report on attendance of students into classrooms is important and can be considered as the starting point towards attaining a good education. Among the classical methods of generating report on attendance are looking for a document or class record and check if there is a student that does not attend for the whole semester or month. The instructor will generate a report on student attendance manually based on their record. That is why we developed software, list of ongoing classes report generator.
LOGC Report Generator System makes easy to the instructor to generate a report on student attendance. It is software developed for daily student attendance in school and to generate student attendance report to be passed by the faculty head easily. It will also help the faculty head to get the report easily and to give the reports to administrator easily. It facilitates to access the attendance information of a particular student in a particular class. This system will also help in evaluating attendance eligibility criteria of a student. It will help the administrator and the faculty head to get the accurate report on student attendance.

2.1 Background of the Company
STI was organized in 1983, when entrepreneurs Augusto C. Lagman, Herman T. Gamboa, Benjamin A. Santos and Edgar H. Sarte set up the Systems Technology Institute to train people in programming and IT, they had a vision of molding Filipino youth for nation building with the mission providing quality computer education to as many Filipinos as possible At first there were two schools, and now there are more than 100.
But started last 2006, the acronym of STI is no longer the meaning as Systems Technology Institute because it is not only the school of Technology and Sciences but with Health, Arts, Managements, Businesses, Hospitality and Culinary school. It is only STI College without meaning but the school for learning students. But still in this present, IT and CS courses is the largest population in this school.
To fulfill its promise, STI innovate academic delivery to its students. Reaching out by making quality education accessible across the nation and across the region, STI paved the way for more opportunity is beyond information technology. It also integrated the foundation of education with the establishment of the pre-school, grade school, and high school. Strengthening its commitment to academic excellence, STI continue to redefine the education landscape through its unique approach to human resources development. STI institutionalized the first and the only Enrollment to Employment System, preparing students for real world challenges.
The construction of STI College Southwoods was accomplished on October 14, 1995. It was inaugurated on August 23, 1996 as part of their obligation to provide our youth with quality education in computer science and allied studies and help build strong technology industry in our country.
In 1996, STI College Southwoods was opened as STI’s first Multi Disciplinary Center of Excellence located in Carmona, Cavite. It offers a comprehensive curriculum accredited by the top international companies, highly experienced academic staff, modern building, spacious campus and air-conditioned classrooms. And part of it is the modern or advancement of the systems that are being implemented and used for information.
Recognizing STI trust’s global industry leaders partnered, empowering the young generation towards securing a better future. Fuelled by complete approach to learning experiences and nurturing the student’s passion and talent STI continue to develop well-rounded, competent and responsible members of the society. For more than 28 years STI has change the lives of many millions to quality education beyond information technology. Today STI stays true to its assurance to every student tomorrow moves forward in shaping the next generation of heroes a heroes in their own lives, in their families, and a heroes of our nation.

2.2 GRACE RUMAL
Assoc Registrar

JEFFREY RAMIREZ
Admissions Officer

MARY ROSE EVARISTO
School Administrator

ALLAN CODEN
Driver/Messenger

ECHELON SECURITY SERVICES

CARMONA FULLFORCE JANITORIAL SERVICES

RESTY ALDANA
Academic Head

LILY MAE CADIZ
Accountant
CORA SANA
Cashier
NIDA FERNANDEZ
Administrative Assistant
MAM ALI
Acting Registrar
?
Career Adviser

DAHLIA DE MESA
Chair, IT

IT / ENG’G FACULTY
ARVIE BERNAL
Network Administrator

ARJAY AMATORIO
Lab Facilitator

RAYMOND AGUILA
Lab Technician
MARC OCHOA
Dean, Healthcare
CLINICAL INSTRUCTORS
MA. VERONICA QUINQUITO
Head, HRM/TM Department
HRM FACULTY
REA JOAN ATIENZA
Head, GE & BA Department
GE FACULTY
RESTY ALDANA
Dean, Graduate Studies

ROWENA JAVIER
Librarian

?
Disciple Officer Studies

PRECY CALVEZ
Guidance Counselor Studies

CYRIL NER
Alumni & Placement Officer Studies

Company Organizational Chart

2.3 Department Organizational Chart
REA JOAN MAYANO
ATIENZA
GE Dept. Head
FACULTY MEMBERS
CRIS B. TAN

ANNA MARIE
R. ALITAGTAG
ARLYN B. ALAMBRA
RONALD F. MANGA
Ronald F. Nicdao
ANTON A. ARCIAGA
MA. MIMOSA C. MAHUSAY
EDITHA H. ORONICO
RONALD E. ESLABON
JENALYN M. CORDERO

MARJORIE GRACE M. PERALES
SALVADOR A. GENIO
AQUINO C. IRASGA JR.
MARIA CRISTINA D. GUANZON

GENY T. MANEUEL
GE/BA Department

IT/COE Department
DE MESA, DAHLIA S.
IT Dept. Head
FACULTY MEMBERS
GUARINO,
ANTHONY A.

MARTILLANO, DENNIS A.
RND Head &
Faculty

BERNAL,ARVIE P.
Net.Admin &
Faculty
LAUREL,ALJAY A.

TIONGSON,KHRISTIAN M.

NUEROS,NOEL A.
DEJESUS, ERICKSON T.

DINO, MICHELLE A.
ALFELOR, FRANCIS S.

VILLAVIZA, JOSE JOLLY R.
.
EDANOŇO,ORNEL LLOYD P.

HRM Department Ma. Veronica Quinquito
Head Department

Carmi Dilag
Faculty
George Tepaurel
Faculty
Gilbert Semilla
Faculty

Healthcare Department
Dr. Stanley E. Luces
Clinical Instructor/ School Psychologist
Mana A. Pasco
RN,MAN,OR/Dr. Specialist/Clinical Instructor
Marcos C. Ochoa
BIO,RN,MAN
Dean,College of healthcare

Ryan Domingo D. Llanto
RN,MANO,Level III Coordinator/Clinical Instructor/Nightingangles Org. Adviser/School nurse
Samuel O. Alatiit
RN,KRN,USRN,Level IV Coordinator/Clinical Instructor/ Review Lecturer/ School nurse

Andrew Paul R. Carticiano
RN,MAN,Level II Coordinator/ Clinical Instructor/ Documentation Officer/School Nurse

1.4 Overview of the Manual System
The manual system generates student attendance reports manually. The faculty instructor usually generates student attendance report, to be passed by the STI administrator. 1.5 Statement of the Problem 1.6.1 General Problem
Traditionally, generating report on student attendance is done using pen and papers. The process in generating report on attendance of student are performed manually by the lecturer, it increases the workload on them and makes the work tedious. There is always a greater chance of errors. Time consuming is expected in manual generating of report. The retrieval data of the student is very slow. To ensure quality report in maintaining attendance, therefore, it is necessary to monitor and create a system of list of ongoing classes report generator. 1.6.2 Specific Problems
In the development of study, the list of ongoing classes report generator cited a particular problem that should be answered. They were defined as follows: * How will the system retrieve accurate data faster than the manual system? * How will the system lessen the use of pen and papers? * How will the system decrease the workload in checking attendance? * How will the system pass the generated report to faculty head and to administrator faster than the manual system? 1.6 Objectives of the Study 1.7.3 General Objective
The study aims to develop an efficient list of ongoing classes report generator that could enhance the manual generating of students attendance. 1.7.4 Specific Objectives
Specifically the project aims to: * To generate a report on student attendance faster than the manual system. * To lessen the use of pen and papers. * To decrease the workload of the faculty on checking attendance. * To easily retrieve an accurate data in generating report. 1.7 Scope and Limitations
Our proposed system primarily focuses on managing the attendance and processing them to generate reports. It helps instructors for monitoring absence of student. The system has four user type; academic head, department head, faculty and the guidance counselor. The academic head is responsible for adding and deleting faculty user. The department head is responsible in report consolidation. The faculty is responsible for generating report on student attendance, adding student class list and generating class schedule. The guidance counselor is responsible in report generation, adding or importing the student master list.
The system is developed using Microsoft Visual Basic .net 2010. The system has a simple but clear interface. The system is not capable in viewing the records in previous semester. The system is not applicable to computers with other OS aside from Windows 1.8 Significance of the Study
The system generates the Student Attendance for STI College Southwoods because it will generally benefit the following entities: FACULTY INSTRUCTORS; in monitoring the student’s attendance it will free them from the difficulties of typing, printing and then past the report to the office. The user who is usually in charge of the manual monitoring of students attendance can now save time and effort to do other works because the system automatically generates reports of the student’s attendance. GUIDANCE COUNSELLOR and DEPARTMENT HEAD The counselor can view the generated reports of the student easily and faster.

2.0 Analysis of the Manual System 2.1 Detailed Discussion of the Manual System
In the present system all work is done on paper. The whole semester or month attendance is stored in register and at the end of the session the reports are generated. The existing system is not user friendly because the retrieval of data is very slow and data is not maintained efficiently. The instructor requires more calculations to generate the report so it is generated at the end of the month or semester. All calculations to generate report are done manually so there is greater chance of errors. Loss of even a single register/record led to difficult situation because all the papers are needed to generate the reports. Every work is done manually so we cannot generate report in the middle of the month or semester, it is very time consuming. There are large amount of data, accessing any data from the manual system is very difficult. The users would have to go through each and every record sequentially until they find the required data. This process is a tedious process when there are many records. 2.2 DFD of the Manual System 2.3.1 Context DFD
Report Consolidation
Report Generation
Attendance Monitoring
Faculty Instructors
Department Head
Guidance Counselor
Attendance Management Report

Faculty Instructors

Manage student attendance record
Student Class List
Student Attendance Report
Student Class List
Student Class List

Generate Attendance Report
Department Head
Guidance Counselor
Level 0 DFD
Check attendance

Generate report using the stored data

Get the report
Report consolidation

2.3 Database Model of the Manual System 2.3.1 ERD
Faculty Instructors
Faculty_ID
Faculty_Name
Generate
POP
Room
End
Attendance
Unit
Day
Faculty_ID
Subject_code
Section
Start
Generate
Report
Reason
Student Not Attending
POP

2.3.2 Sample Reports

3 Proposed Project Design
The proposed system is the List of Ongoing classes report generator. 3.1 Detailed Discussion of the Proposed System
The proposed system generates report on student attendance. It 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. Attendance reports can be easily generated in the proposed system so user can generate the report as per the requirement (monthly) or in the end of the semester. The proposed system requires very less paper work. All the data is give into the computer immediately and reports can be generated through computers. Accurate information can be achieved within a short span of time. Moreover work becomes very easy because there is no need to keep data on papers. The storing and retrieving of information is easy. So work can be done speedily and in time. 3.2 Process Design 3.2.1 Context DFD
Faculty Instructors
Department Head
Guidance Counselor
Academic Head
Attendance Management Report
Faculty Loading
Report Consolidation
Report Generation
Attendance Monitoring

3.2.2 Level 0 DFD
Academic Head
Faculty Instructors

User Login
Faculty
Check attendance, Create Schedule
Department Head
Guidance Counselor
Student Class List
Student Attendance Report
Login Verification
Academic
Create or delete faculty user
Student Class List
Student Class List

Attendance
Student Class List
Student Class List

Schedule

Student Class List
Student Class List

Faculty List
Dept.Head / Guidance Counselor

Attendance Report

3.3 Logic Design
1.0
LOGC SYSTEM
2.0
MANAGE DATA
2.1
MODIFY DATA
2.2
ADD DATA
2.3
DELETE DATA
3.0
GENERATE REPORT

3.2
RESPOND TO QUERY
3.2.1
CHECK STUDENT CLASS LIST
3.2.2
CHECK STUDENT ATTENDANCE
3.1
STATUS REPORT
4.0
UPDATE DATA
4.1
PROCESS ATTENDANCE
4.3
PROCESS PASSING DATA
4.2
PROCESS RETURN 3.3.1 HIPO Chart

START
MODULE 1.0
3.0
GENERATE REPORT
Generate student attendance report, generate users report.
2.0
MANAGE DATA
Add, update and delete students and user faculty. Prepare the user file, master List and administrator file.
4.0
UPDATE DATA
Process student information, user information, student class list, student master list, student attendance report.
INPUT
PROCESS
OUTPUT
3.3.2 IPO Chart
SUB MODULE 1.0
INPUT
3.0
Input student attendance, verify record, if error display message

2.0
Input user, student list, sub-courses, verify record, if error display message

4.0
Input user, student list, sub-courses, student attendance, verify record, if error display message

PROCESS
2.0
3.0
4.0
OUTPUT
Valid User name
Invalid User name
Generating Report Complete
Update stock data

UPDATED STOCK DATA
UPDATED CLASS LIST
UPDATED STUDENT MASTER LIST
UPDATED USER FACULTY
GENERATED ATTENDANCE REPORT
UPDATED SUBJECTS
UPDATED FACULTY SCHEDULE
STUDENT MASTER LIST
STUDENT ATTENDANCE
FACULTY SCHEDULE
USER FACULTY
STUDENT CLASS LIST
SUBJECTS

3.4 Database Design 3.4.1 ERD of the Proposed System
Has
USERS
PASS
Email
User_Type
Fac_NO
Has
FACULTY
FacNo
Fac_Ln
Fac_created
Fac_Mn
Fac_dept
Fac_Fn
Has
Has
ATTENDANCE
Stud_Id
Check_date
Stud_ID
ISpresent
Check_ID
PARENTS
Address
Name
StudNO
Contact
SCHEDULE
Sy
Type
Start
Day
Room
Subj_ID
Unit
Fac_Ln
End
Description
Sched_ID
STUDENT
Has
StudNo
LN
FN
Contact
Address
ClassID
MI
Has
PROGRAM
Prog_ID
Subj_Code
Unit
Description
Semester
Belongs
Has
Description
SUBJECT
Yr_level
Unit
Subj_ID
Semester
Program
StudNO
CLASS
FacNo
Sched_ID
StudNO
Subj_ID
Program
Semester
Section
ClassID

3.4.2 Table Structures Schedule | | Fields | Data type | Sched_Id | Integer | Fac_no | VARCHAR(45) | Section | VARCHAR(45) | Subject_Id | VARCHAR(45) | Description | VARCHAR(45) | Day | VARCHAR(45) | Start | Time | End | Time | Room | VARCHAR(45) | Type | VARCHAR(45) | Semester | Integer | Sy | VARCHAR(45) | Unit | Integer | Stud_Pop | Integer | | | faculty | | Fields | Data Type | fac_no | VARCHAR(15) | fac_Ln | VARCHAR(45) | fac_Mi | VARCHAR(2) | fac_fn | VARCHAR(100) | fac_dept | VARCHAR(10) | date_created | DATETIME | | | Attendance | | Fields | Data type | Check_ID | Integer | Sched_ID | Integer | Student_ID | Varchar | Check_Date | Date time | IsPresent | TINYINT(1) | | | Parents | | Fields | Data Type | Student_No | VARCHAR(15) | Name | VARCHAR(100) | Contact | VARCHAR(100) | Address | VARCHAR(150) | Program | | Fields | Data Type | Program | VARCHAR(10) | subject_code | VARCHAR(45) | subject_description | VARCHAR(45) | semester | Integer | Unit | Integer |

User | | Fields | Data type | fac_no | Varchar(45) | user_type | Varchar(45) | pass | Varchar(45) | Email | Varchar(45) | Population | | Fields | Data Type | Pop_ID | Integer | Sched_ID | Integer | Pop | Integer | | | User | | Fields | Data Type | fac_No | VARCHAR(15) | User_type | VARCHAR(20) | Pass | VARCHAR(45) | Email | VARCHAR(100) | | | Students | | Fields | Data Type | Student No. | VARCHAR(15) | Fn | VARCHAR(45) | Ln | VARCHAR(45) | Mi | VARCHAR(2) | Address | VARCHAR(150) | Contact | VARCHAR(45) | Subject | | Fields | Data type | ID | INTEGER | Program | VARCHAR(45) | Subject_id | VARCHAR(45) | Description | VARCHAR(45) | Unit | INTEGER | Semester | INTEGER | Year_Level | INTEGER | Class | FacNo | INTEGER | Stud_NO | INTEGER | Subj_ID | VARCHAR(45) | Program | VARCHAR(45) | Semester | INTEGER |

3.4.3 Populated Tables User | | | | fac_no | User_type | Pass | Email | 880P-0510-012 | Administrator | ******** | [e-mail] | 880P-0510-014 | Faculty | ******** | [e-mail] | Faculty | | | | | | fac_No | fac_Ln | fac_Mi | fac_Fn | fac_dept | date_Created | 880P-0510-013 | Nicdao | F | Ronald | GE/BA | 3/13/2012 | 880P-0510-014 | Elabon | F | Ronald | GE/BA | 3/13/2012 | 880P-0510-015 | Manga | R | Ronald | GE/BA | 3/12/2012 | Program | | | | | Program | subject_code | subject_description | semester | Unit | BSIT | CORLANG | Computer and Assembly lang. | 2 | 4 | BSCOE | CHEMONE1 | Chemistry 1 | 2 | 2 | Attendance | | | | Check_ID | Sched_ID | Student_ID | Check_Date | IsPresent | 1 | 1 | 088-2010-0242 | 3/13/2012 | 0 | 2 | 2 | 088-2010-0343 | 3/13/2012 | 1 | Population | | | Pop_ID | Sched_ID | Pop | 22 | 1 | 1 | 21 | 2 | 2 | 3 | 3 | 4 | parents | | | | Student_No | Name | Contact | Address | 088-2010-0242 | Lorna Tan | 91283423755 | GMA Area | 088-2010-0343 | Anabel Rama | 91247658933 | Binan, Laguna | Student | | | | | | Student No. | Fn | Ln | Mi | Address | Contact | 088-2010-0242 | Arlene | AMORES | G | GMA Area | 91283423755 | 088-2010-0343 | Kesssa Marie | CAJURAO | P | Binan, Laguna | 91247658933 | Subject | | | | | | | ID | Program | Subject_Id | Description | Unit | Semester | Year Level | 1 | BSIT | Corlang | Computer and assembly language | 4 | 2 | 2 | 2 | BSBM | NATSCI1 | Natural Science 2 | 3 | 2 | 2 |

FacNo | Stud_NO | Subj_ID | Program | Semester | 880P-0510-021 | 088-2010-0242 | Corlang | BSIT | 2 | 880P-0510-022 | 088-2010-0343 | NATSCI1 | BSCOE | 2 |
3.5 Interface Design 3.5.1 Screen Shots of major parts of the Proposed System

Figure 1: Main Form Figure 2: Administrator Form

Figure 3: Department Head Form Figure 4: Academic Head Form

Figure 5: Faculty Form

3.5.2 Description of the Screen Shots
Figure 1: Login form This is where the user can login an account. The users; can create password using their faculty number in system menu but before they can create a password the user should contact their academic head to create them an account, can recover password and edit the system clock.
Figure 2: Administrator Form The administrator; can add, delete or import student master list, can view the report.
Figure 3: Department Head Form The department head; can view the report.
Figure 4: Academic Head Form The academic head; can add and delete faculty user.
Figure 5: Faculty Form The faculty; can add and delete subject schedule, can add and delete student class list and can check attendance.

3.6 Form & Report Design 3.6.1 Form Design (w/ description)

Figure 1: About Form – This is where the user can view the information about the system.

Figure 2: Create New Password Form – This is where the user can create the password to access their account.

Figure 3: Password Recovery Form – This is where the user can recover their password account through email.

Figure 4: View Faculty Form – This is the form where the academic head can view the created faculty user.
Figure 5: Add New Faculty Form – This is where the academic head can add new faculty user.

Figure 6: Add New Subject – This is the form where the administrator can add new subject.

Figure 7: Add New Student Form – The administrator need to fill-up all the fields to add student.

Figure 8: View Student – The administrator can see the list of student whether it is import or manually added.

Figure 9: Add Schedule – This is where the faculty user can add schedule. The faculty can view their schedule in schedule form.

Figure 10: Add Class Student –The faculty can search all the students in his/her class list they need to add.

Figure 11: Help Form – The user can browse the help form if they do not know to use it.

.

3.7 Network Design (if necessary)

3.8 Implementation Design The developers of the system must know the requirements and the user’s point of view. The developers must know how the report generations are being processed. There are ways of knowing the requirements. First, observe and witness the actual flow of the current system. Second, research on other system and compare them in order to vision the best way to design the system. Third, interview the authorized person directly involved in the tools.
3.8.1 Resources In implementing the system, there are things to consider. First, the computer that will be used in installing the system must meet the hardware requirements. Second, the needed software must secure the security of the system and the functionality of the system. Third, the developers must think who will use the system. The developers based the design of the system according to the gathered requirements and problems presented during the interview with their client.
3.8.1.1 Hardware
The computer that will be used in implementing the system requires at least above or equal of the following: Windows Operating System, 1G or Higher hard disk, Intel® Atom™ CPU N570 @ 1.66 GHz 1.67 GH Processor, 12 GB or Higher System Memory. Items | Specifications | Operating system | Windows | Graphic Card | NVIDIA GeForce FX5200 or higher | Keyboard | Standard or Generic | Mouse | Optical mouse Genius Microsoft PS12 mouse | Hard Disk | 1G or Higher | Processor | Intel® Atom™ CPU N570 @ 1.66 GHz 1.67 GH | System Memory | 12GB or Higher | Monitor | Standard or Generic | LAN | |

3.8.1.2 Software
The language used in the system is Dot NET and MySQL. The Dot NET Framework is a software framework that runs primarily on Microsoft Windows.
The system is opened to faculty member and administrator. All data of the users is protected. The system was design to speed up to standardized the attendance report generation. But due to some security purposes, this information can only be access by the registered users 3.8.1.3 People The primary users of the system are the faculty instructor and the administrator. The use of the system requires only basic knowledge on how to operate basic steps using computer. The user will have easy time in the operation of the system since it is user-friendly. Furthermore, it is assumed that since the users are exposed to technology, they can easily understand the function of the system. The system requires a technical person who will be in charge with fixing the circuit in case of damage.
3.8.2 Procedures

Account Login

Step 1: Run the system; choose the user type from guidance counselor, academic head, department head and faculty. (Employee Number (0000-0000-000)). Step 2: User Account will show.

Create a faculty account (academic head user only)

Step 1: When the academic head account shows, look in the menu on upper left corner. Manage the faculty. Step 2: Click add faculty in manage faculty menu.

Import student information (guidance counselor user only) Step 1: Click Student from menu on the upper left corner of guidance counselor form. Step 2: Choose ‘Add New’ to Add new Student and ‘Import’ to get Students list from the master list.

Add Subject (guidance counselor user only) Step 1: On the Upper left corner click Subjects from menu. Step 2: A message box will appear after filling out all the information needed

Create Faculty Password Step 1: Run the program; look in the menu on the upper left corner. Click system then go to Create user password. Step 2: A message box will appear after giving the entire information required click Ok. Add Schedule (faculty user only) Step 1: Look in the menu on the upper left corner. Click Schedule then go to Add Schedule. Step 2: Fill-up all the fields to add schedule.

STOCK ROOM
SSO and Guidance Office
Guidance Counselor table
STI 3rd floor
CORR
IDOR
3.8.3 Office Layout

Annexes / Indices