Republic of the Philippines
EAST PACIFIC COMPUTER COLLEGE
EPCC Campound, Baybay, Catarman
Northern Samar

PAYROLL SYSTEM OF EMPLOYEES IN EAST PACIFIC COMPUTER COLLEGE

BY

SUBMITTED TO

RAUL C. GACUSAN, Ph. D.

DEDICATED TO

OUR PARENTS
OUR FRIENDS
LOVED ONES
AND
OUR ALMIGHTY GOD

Table of Contents
Chapter 1- INTRODUCTION
Background of the Study 1
Objectives of the Study 2

CHAPTER 1
PROJECT BACKGROUND

Background of the Study
A grading system is a great help to students and to the school Administrator in maintaining and monitoring students’ performance. It will be easy for the students to determine their grades in every subject taken especially right after the end of a semester.
A student final grade is a result of class activities, quizzes, and major examinations. Grades are given based on point systems and most schools encounter problems in recording student grades due to manual method of handling students’ grades.
It is very important for every school to have a systematic and upgraded system in keeping or recording of grades. This was the reason this study on computerized grade monitoring system was conducted by the information technology of East Pacific Computer College so that as students transact with the registrar to ask for their grades, it could be easy for the registry office to release the grades of the students instantly. A grading system could be a great help, not only for the students but also for the school administration for the enhancement of the school’s grade recording system.
The East Pacific Computer College (EPCC) encounters problem always in releasing the grades of the students for the reason that it takes them time to browse of scan the cabinet files just to find the students grades, due to manual system of students’ grades safekeeping. This is the main reason a grade monitoring system was proposed, for the benefit of accessible and instant search of grades by the students.

Project Objectives
The purpose of this project is to put into practice what we have learnt so far in our software engineering class. We spent most of the semester studying extreme programming. With extreme programming, the client knows how far he or her software is coming and knows what to except at one particular time or the other. The software is built exactly the way the client wants it to be built.
The main purpose of this study was to; 1. Create a system that helps the students and school administration to evaluate and monitor grades at the end of the semester. 2. Help the school registrar of EPCC on easy access and release of students’ grades when needed. 3. Organize students’ grades for accessible search.

Statement of the Study
Design a program that will accept as data input the grades of the students in East pacific Computer College.
This study will of great help to the student in monitoring their grades, the following reasons was stated; 1. What is a computerized grade monitoring and keeping? 2. How to electronically update students’ grades? 3. How to organize students’ grades?

Scope and Limitation The study only concentrates on Computerized grade Monitoring System in East pacific Computer College in Catarman, Northern Samar. The content of the proposed system covers the course, year, subject and grades, as basis of evaluating and monitoring students’ grades every end of the semester.

Significance of the Study The study must be significant most importantly to the administration of the East Pacific Computer College especially the registrar because it will be made easy for them to compute the grades and monitor the grades of the students. This will help them managed will in the processing of the students semestral grades through the proposed system. Particulalrly to the students, it is significant to them because through this program students can update and monitor their grades every end of the semester, through this computerized monitoring grading system. The study must also be helpful to the future studies related to this because this will help them substantiate the data they needed.

Chapter II
Organizational Background
School History

Below is the mission and vision of the East Pacific Computer College; Vision
EPCC will be the center of excellence in information technology, electronics, engineering, business, education and other fields of study in which we will engage in. we will bench mark not with local competitors but with the best of the country and the world.
Mission
The EPCC will exist to provide a quality, affordable education no-more-no-less. By the quality education we mean facilitating the learners to acquire knowledge, skills, principles and ideals, values and attitudes necessary to develop the fullest potential of a person and to succeed in life and in the process to become faithful citizens of our country.

ORGANIZATIONAL STRUCTURE
East Pacific Computer College
Catarman, Northern Samar

President

V-President

VP for Admin
VP for Academic

Course 4
Course 3
Course 2
Course 1
Finance
Librarian
Registrar

Guidance

Faculty
Faculty
Faculty
Utility
Faculty

Existing System The Grade Monitoring system that the East Pacific Computer College is presently administering follows the traditional system or method. The instructor submits students’ grade to the registrar in file folder and at the end of the semester, the students request for release of grades. This is the time where the registrar has to assists the students in searching for their grades manually.

Chapter III
Data Flow Diagram
(Existing)
“Grade Monitoring System”

1. Submit Students’ Grades

INSTRUCTOR

Requested4. Release Students’ grades
Registrar
Student grades Forward grades

Manually Recoded the Grades
2. Record Students’ Grades

Final Record of Grades Student

Verify grades Forward for Verification
Administrator

3. Verify Students’ Grades Check grades

CONTEXT DIAGRAM
Proposed System
“GRADE MONITORING SYSTEM”

“GRADE MONITORING SYSTEM”

Verify Records Updated Records
REGISTRAR

ADMINISTRATOR

Record of Updated Record
Grades Submission

The Science of Information technology students have proposes the “Grade Monitoring System” in East pacific Computer College, Catarman, Northern Samar for the benefit of the school and the students. It is about the student grade monitoring system that composed of data such as the course, year, subject and the grade or the performance of the student. Likewise, grade monitoring system was designed for a hierarchical system. With this new and modernized method of students grade monitor, it could be easy for the school to release instantly the students’ grade, and there will be an organized and updated profile of grade system.

Chapter IV
Data Dictionary

Chapter V
System Flowchart

Chapter VI
Program Modules/Sub-Modules

H I P O
(HEIRARCHECAL INPUT PROCESS AND OUTPUT)

GRADE MONITORING SYSTEM

ADD-IN

SETTING

UTILITY

DATE ENTRY
INQUIRY

Chapter VII
Data Structure/File Design
Chapter VIII
SAMPLE OUTPUT

Chapter IX
SCREEN DESIGN

Chapter X
PROGRAM LISTING
The Complete Program Listing

Dim acc As new Access.Application (STUDENT DATA)

Private Sub address_Key Press(KeyAscii As Integer)
If keyAscii = 13 Then
Caddress.SetFocus
End If
End Sub

Private Sub age_Key Press(KeyAscii As Integer)
Age.Mask = “##”
If keyAscii = 13 Then cmage.SetFocus End If
End Sub

Private Sub bdate_Key Press(KeyAscii As Integer) bdate.Mask = “##-##-####”
If keyAscii = 13 Then cmbdate.SetFocus End If
End Sub

Private Sub course_Key Press(KeyAscii As Integer) bdate.Mask = “##-##-####”
If keyAscii = 13 Then cmbcourse.SetFocus End If
End Sub

Private Sub cmbcitizenship_Key Press(KeyAscii As Integer) bdate.Mask = “##-##-####”
If keyAscii = 13 Then cperson.SetFocus End If
End Sub

Private Sub cmbcourse_Key Press(KeyAscii As Integer)
If keyAscii = 13 Then cmbyyear.SetFocus End If
End Sub

Private Sub cmbcstat_Key Press(KeyAscii As Integer)
If keyAscii = 13 Then cmbstat.SetFocus End If
End Sub

Private Sub cmbgender_Key Press(KeyAscii As Integer)
If keyAscii = 13 Then cmbgender.SetFocus End If
End Sub

Private Sub cmbreligion_Key Press(KeyAscii As Integer)
If keyAscii = 13 Then cmbcitizenship.SetFocus End If
End Sub

Private Sub cmbreligion_Key Press(KeyAscii As Integer)
If keyAscii = 13 Then cmbreligion.SetFocus End If
End Sub

Private Sub cmbsem_Key Press(KeyAscii As Integer)
If keyAscii = 13 Then
Set db = OpenDatabase(App.path & “\jemcc”) s = “select * from add where course = “’ & cmbcourse & “’ and sem = “” & cmbesem &“’ Set rec = db.OpenRecordset(s,dbOpenSnapshop) If rec.EOF = False Then sca = rec!sc1 scb = rec!sc2 scc = rec!sc3 scd = rec!sc4 sce = rec!sc5 scf = rec!sc6 scg = rec!sc7 sch = rec!sc8 sci = rec!sc9 scj = rec!sc10 dt1 = rec!dt1 dt2 = rec!dt2 dt3 = rec!dt3 dt4 = rec!dt4 dt5 = rec!dt5 dt6 = rec!dt6 dt7 = rec!dt7 dt8 = rec!dt8 dt9 = rec!dt9 dt10 = rec!dt10 If Is null(rec!unit1) Then Unit1 = 0 Else unit1 = rec!unit1 End If If IsNull(rec!unit2) Then unit2 = 0 Else unit2 = rec!unit2 End If If IsNull(rec!unit3) Then Unit3 = 0 Else unit3 = rec!unit3 End If If IsNull(rec!unit4) Then unit4 = 0 Else unit4 = rec!unit4 End If If IsNull(rec!unit5) Then unit5 = 0 Else Unit5 = rec!unit5 End If If IsNull(rec!unit6) Then unit6 = 0 Else Unit6 = rec!unit6 End If If IsNull(rec!unit7) Then unit7 = 0 Else unit7 = rec!unit7 End If If IsNull(rec!unit8) Then unit8 = 0 Else unit3 = rec!unit8 End If If IsNull(rec!unit9) Then unit9 = 0 Else unit9 = rec!unit9 End If If IsNull(rec!unit10) Then unit10 = 0 Else unit10 = rec!unit10 End If time1 = rec!time1 time2 = rec!time2 time3 = rec!time3 time4 = rec!time4 time5 = rec!time5 time6 = rec!time6 time7 = rec!time7 time8 = rec!time8 time9 = rec!time9 time10 = rec!time10 day1 = rec!day1 day2 = rec!day2 day3 = rec!day3 day4 = rec!day4 day5 = rec!day5 day6 = rec!day6 day7 = rec!day7 day8 = rec!day8 day9 = rec!day9 day10 = rec!day10 room1 = rec!room1 room2 = rec!room2 room3 = rec!room3 room4 = rec!room4 room5 = rec!room5 room6 = rec!room6 room7 = rec!room7 room8 = rec!room8 room9 = rec!room9 room10 = rec!room10 db.Close ef.SetFocus
Else
MsgBox “Record not Found”,vbCritical,
“Note”
End If
End if
End Sub

Private Sub cmdclear_Click()
Studno.Mask – “07-____”
Bdate.Mask = “__-__-____”
Iname = “”
Fname = “” mi = “” male.Value = False female.Value = False cmbstat.ListIndex = 0 age.Mask = “__” cmbreligion.ListIndex = “0” cmbcitizenship.ListIndex = “0” cperson = “” cno = “” address = “” caddress = “”

unit1 = “” unit2 = “” unit3 = “” unit4 = “” unit5 = “” unit6 = “” unit7 = “” unit8 = “” unit9 = “” unit10 = “”