OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
1
Appendix A Transcript of Interview
C O L L E G E O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
2
C O L L E G E O F C O M P U T E R S T U D I E S
Appendix B
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
3
Context Diagram C O L L E G E
0
Payslip
Payroll Report
Login FingerPrint Employee Invalid Finger Print
LAN-BASED TIMEKEEPING AND PAYROL PAYROLL L SYSTEM SYSTEM FOR BLANCO FAMILY ACADEM ACADEMY Y
Human Resources Employee Details
SSS,PhilHealth, Pag-Ibig, TAX Details
Employee Details
SSS,PhilHealth, Pag-Ibig, TAX Details
Login Payroll Report
Accountan Accountantt
Figure 4: Context Diagram for Time keeping and Payroll System for Blanco Family Academy
Appendix C
O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
4
Data Flow Diagram Invalid Fingerprint EmployeeAttendanceRecord
1 D1
Fingerprint
Employee
Validate Fingerprint
D2
Employee File le
Employee Record
EmployeeDetails
Deduction tion File
67
ComputedD d Deductions (SSS , Pag -Ibig , PhilHealth WithHoldingTax )
,
Add Employee
C O L L E G E
Computed Gross Pay
2 EmployeeDetails
Compute Gross Pay Accountant
Computed Gross Pay
D3
Deduction Tables (SSS , PhilH lHealth th , Pag -Ibig )
Employee File le
D2
Employee Attendan ance Record
3 SSS , Pag -Ibig , PhilHealthDeduction
Compute Net Pay
Computed payroll oll (Net pay , Deductions
Computed Payroll (net pay deductions
Payslip Details (Employee record , Deduction Details )
4
)
Deduction File File Deduction Detail
5
Generate payroll Report
Generate Payslip
) Payslip li p
D1
D1
/ Admin
Employee
Employee File le
Payroll Report
Admin
Payroll Report
Accountant
EmployeeDetails
7
Update Deduction on or Employee Files
Deduction Details
D2 SSS , Pag -Ibig , PhilHealth Deduction
WithholdingTax
Deduction tion File
D3
Deduction (SSS , Pag -Ibig , PhilHealth
D4
Withholding Tax
)
Deduction details , Employeedetails ployeedetail s SSS , Pag -Ibig , PhilHealth Deduction
Admin /Accountant
Figure 5: Data Flow Diagram for Time keeping and Payroll System for Blanco Family Academy
O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
5
Appendix D System Flowchart
Human Resources
A dd Em plo ye e
Set Basic Salary
Al low an ce s
Deductions an d Loans
Enter New Employee information
Retrieve Old Employee Record
Employee
Time In & Out
Finger Print Registration
Calculate Total hours of worked
Scanning Finger Print
Calculating Payroll Processess
Timekeeping An d Payroll
Payslip
Timesheet
O F Reports
Calculating all the Earnings and Deduction
Payslip
Employees
Figure 6: System Flowchart for Time keeping and Payroll System for Blanco Family Academy
C O L L E G E
C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
6
Appendix E Hierarchical Input Process Output
Proponents: Chester I. Barry and Joemel A. Valenzuela
Program: LAN-BASED Timekeeping and Payroll System using Biometrics for Pag-IBIG Fund Module: 1.0
Input
Process
Output
1
Employee Management
Add, Edit, Delete, Delete, save,& search Employee, Set salary.
New employee record added
2
Finger Print Registration
Search Employee, set name of Finger to be enrolled/scan.
New employee finger print record added
3
Attendance Attendance Monitoring
Retrieves the employees In and out.
Attendance/Daily Attendance/Daily time record
4
Payroll Transaction
Search employee, Schedule Information Generate Payroll
Print Payslip Report
5
Loan
Setting the loan type, amount and payment period
New loan added to employees record
6
Leave
Set the leave date for employee
New leave added to employee record
7
Holiday
Set Holiday
New holiday Record added
8
Report
Generating Reports for payslip, Taxes and timesheet
Summary Reports
9
Access Control Control
Privileges to access some operations
User privileges update
Figure 7: Hierarchical Input Process Output for Time keeping and Payroll System for Blanco Family Academy
C O L L E G E O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
Proponents : Chester I . Ba Barry and Joemel Valenzuela System using
INPUT
Program : LAN - BA BASED T im imekeeping and Payroll Biometrics for Blanco Family Academy Module : 1.1 Employee Management
PROCESS
OUTPUT
Add New Employ Employee’s ee’s Information
Input and Save Employee’s Information
New Employee Information
Edit Em E mployee’s Information
Search Employee and edit
Employee Information updated
Set Schedule
Search Employee to be Scheduled
Employee Schedule Updated
Set Employees Salary
Input Basic Salary Rate And reset reset deduc deduction tion
Employee Salary Updated
Proponents : Chester I . Barry and Joemel Valenzuela System using
INPUT
Program : LAN - BA BASED T im imekeeping and Payroll Biometrics for Blanco Family Academy Module : 1.2 Finger Print Registration Registration
PROCESS
OUTPUT
Employee Name Request
Set Name of Finger Print
Validating Employee Fingerprint
Finger to be enrolled
Scanning of Fingerprint
Employee Fingerprint updated
Figure 7.1: Hierarchical Input Process Output for Time keeping and Payroll System for Blanco Family Academy
7
C O L L E G E O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
Propo ropone nents nts : Che Chest ster er I . Barry arry and Joem Joemel Valen alenzu zuel ela a
INPUT
Progr rogram am : LA LAN -BA -BASED Timek Timekeeping ping and and Payro ayroll ll Syste ystem m usin using g Biometrics for Blanco Family Academy Module Module : 1.3 1 .3 Attendance Attendance Monitoring
PROCESS
OUTPUT
Scanning of Employee Fingerprint
Verifying the Finger Print Login /Logou /Logoutt
Time log updated
Manual Input of Time
Getting the Schedule to be Logged
Time log updated
8
C O L L E G E O F
Propo ropone nents nts : Che Chest ster er I . Barry arry and Joem Joemel Valen alenzu zuel ela a
INPUT
PROCESS
Generate the employee’s Payroll
Employee Name
Propo ropone nents nts : Che Chest ster er I . Barry arry and Joem Joemel Valen alenzu zuel ela a
INPUT
Progr rogram am : LA LAN -BA -BASED Timek Timekeeping ping and and Payro ayroll ll Syste ystem m usin using g Biometrics for Blanco Family Academy Module Module : 1.4 1. 4 Payroll Payroll Transa Transaction
OUTPUT
Payroll Results
Progr rogram am : LA LAN -BA -BASED Timek Timekeeping ping and and Payro ayroll ll Syste ystem m usin using g Biometrics for Blanco Family Academy Module dule : 1.5 Loan Loan
PROCESS
Search Employee Name
Set Type of Loan and Interest And And Amortiz ortizat atio ion n Period
Input amount of cash advance
Checking of cash to be borrowed
OUTPUT
Loan Updated
Cash advance updated
Figure 7.2: Hierarchical Input Process Output for Time keeping and Payroll System for Blanco Family Academy
C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
Prop roponents : Che Chester ster I . Ba Barry rry and Joemel Valen alenzue zuela
Prog rogram ram : LAN -BA -BASED Timekeeping ing and Payro yroll Syste stem using ing Biometrics for Blanco Family Academy Module : 1.6 Leave eave
INPUT
PROCESS
Set Date Period to be submitted
Checking of type of Leave
Prop roponents : Che Chester ster I . Ba Barry rry and Joemel Valen alenzue zuela
PROCESS
Add Add , del delet ete e and save type type of Holiday
Prop roponents : Ch Cheste ster I . Bar Barry ry and Joemel Valen alenzuela
INPUT
Select type of report
Prop roponents : Ch Cheste ster I . Bar Barry ry and Joemel Valen alenzuela
INPUT
Select User
New Leave File
Prog rogram ram : LAN -BA -BASED Timekeeping ing and Payro yroll Syste stem using ing Biometrics for Blanco Family Academy Module : 1.7 Holida Holiday
INPUT
Set Type of Holiday
OUTPUT
OUTPUT
New Holiday Added
Prog rogram ram : LAN -BA -BASED Timekeeping ing and Payro yroll System stemusing ing Biometrics for Blanco Family Academy Modu Module le : 1.8 Repo Reports
PROCESS
OUTPUT
Setting the name of employee , month month and year
View Report
Prog rogram ram : LAN -BA -BASED Timekeeping ing and Payro yroll System stemusing ing Biometrics for Blanco Family Academy Module : 1.9 Access Control
PROCESS
Enrolled sections to be accessed by a user
OUTPUT
New User Added
Figure 7.3: Hierarchical Input Process Output for Time keeping and Payroll System for Blanco Family Academy
9
C O L L E G E O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
10
Appendix F Visual Table of Contents (VTOC)
C O L L E G E
1.0
Timekeeping and Payroll System
1.1
1.2
Emplo loyee Management
1.3
Finger Print Registration
1.6
1.7
Leave
1.4
Attendance Monitoring
Loan
1.9
1.8
Holiday
1.5
Payroll Transaction
Access Control
Reports
Figure 8: Visual Table of Content for Time keeping and Payroll System for Blanco Family Academy
C O M P U T E R S T U D I E S
1.2 Finger Print Registration
1.2.1 Search Employee
O F
1.2.2 Scan Finger
Figure 8.1: Finger Print Registration
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
11
1.1
Employee Management
1.1.1
Ad A d d Employee
1.1.2
Edit Employee
1.1.3
Delete Employee
1.1.4
1.1.5
Save Employee
S et Salary
1.1.6
Set Schedule
1.1.7
Search Employee
C O L L E G E O F
Figure 8.2: Employee Management
1.3
Att Atte endance Monitoring
1.3.1
Time In & Out Identifier
Figure 8.3: Attendance Monitoring
C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
1.4 Payroll Transaction
1.4.1 Search Employee
1.4.2 Calculate
1.4.3 Print
1.4.4 Schedule Information
12
C O L L E G E O F
Figure 8.4: Payroll Transaction
C O M P U T E R
1.5
Loan
1.5.1
Search Employee
1.5.2
1.5.3
Loan Type
Loan Amount
1.5.4
Am A m o un t P e rio ri o
Figure 8.5: Loan
1.6 Leave
1.6.1 Search Employee
1.6.2 Set Date
1.6.3 Submit Leave
S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
13
C O L L E G E O F
Figure 8.6: Leave
C O M P U T E R
1.7 Holiday
1.7.1 Set Holiday
1.7.2 Save
Figure 8.7: Holiday
1.7.3 Delete
S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
14
1.8 Reports
1.8.1 Payslip
1.8.2 Tax
1.8.6 Timesheet
1.8.3 SSS
1.8.7 Loan Contribution
1.8.4 PhilHealth
1.8.8 13th Month
1.8.5 Pag-IBIG
O F
1.8.9 Tax Refund
C O M P U T E R
Figure 8.8: Reports
1.9
Acc A cc es s Control
1.9.1
Select User
1.9.2
Enrolled
1.9.3
Non Enrolled Enrolled
C O L L E G E
1.9.4
1.9.5
Submit
Cancel
Figure 8.9: Access Control
Appendix G Entity Relationship Diagram
1.9.6
Set Username & Password
S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
Age Addres dress
Position
EmployeeID
Admin
EmployeeID
Regist gister er
C O L L E G E
Status
Empname
DeptID
DeptName
Division
Employ ployee
Works For
Department
Name File Record
Has
Daily Time Record
Position
15
Date Time In
& Out
Department
O F
Position Positio ition nID
Positio ition nName
C O M P U T E R
Goes To
EmployeeID
Distributes Payslip
Accountant tant
Employees
Computes
Name
Deduction
Determine
Department Employee’s Salary
Loans & Taxes PagIBIG ITW (BI (BIR )
Gross Pay
PhilHealth
Net Pay SSS
Figure 9: Entity Relation Diagram of Time Keeping and Payroll System for Blanco Family Academy
Appendix H
S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
16
Economic Economic Feasibility OPERATION COST (Existing)
A. Pers Person onne nell
Monthly
Annually (2) Pa Payroll Personnel @ 16 16,000
32,0000.00 384,000.00 32,0 32,000 00.0 .00 0
B.
O F
(2) Log book @ 85.00
C.
384, 384,00 000. 0.00 00
Supplies
170.00
2,040.00
(5) Ball pen @ 7.00
35.00
420.00
(2) Two small box staple wire @ 19.25
38.05
(1) Liquid eraser @ 25.00
25.00
300.00
(1) Small box of paper clip @ 21.00
21.00
252.00
Total Supplies Cost
289.05
462.00
3,474.00
Equipment
(1) Calculator @ 270
C O L L E G E
Salvage value = 270.00 * .2 = 54.00
Description value = 270.00 – 54.00 1 = 216.00/year
C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
(1) (1) Me Medi dium um stap staple lerr @ 75.00 5.00
17
Salva alvag ge valu value e = 75.0 75.00 0 * .2 = 15.00 Description value = 75.00 – 15.00 1 = 60.00/year
(1) 12inch 12inch ruler ruler @ 24.00 24.00
Salvag Salvage e value value = 24.00 24.00 * .2
C O L L E G E O F
= 4.80
Description value = 24.00 – 4.80.00 1 =19.20/year Total Equipment Cost:
310.20
A. Personnel
384,000.00
B. Supplies
3,474.00
C. Equipment
310.20
Total Annual Cost (Existing System)
387,784.20
OPERATION COST (Proposed) A. Pers Person onne nell
Monthly
Annually (1) Payroll Personnel @ 16,000
16,000.00
192,000.00
(The other personnel will be assign
16,0 16,000 00.0 .00 0
192, 192,00 000. 0.00 00
Provided a new job description by the the employer) employer)
C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
B.
Supplies
(2) Ball pen @ 7.00
14.00
168.00
(4) Folder @ 8.00
32.00
384.00
(4) Fastener @ 3.00
12.00
144.00
(1) (1) Re Ream am bond bond pape paperr @ 160. 160.00 00
160. 160.00 00 218.00
C.
18
1,92 1,920. 0.00 00
2,616.00
C O L L E G E O F
Equipment
(1) (1) Me Medi dium um stap staple lerr @ 75.00 5.00
Salva alvage ge valu value e = 75.0 75.00 0 * .2 = 15.00
Description value
= 75.00 – 15.00 1
C O M P U T E R
=60.00/year
(1) (1) Ca Cano non n prin printe terr @ 6525 6525.0 .00 0
Salv Salvag age e valu value e = 6525 6525.0 .00 0 * .2 = 1,305.00
Description value = 6525.00 – 1305.00 3 =1,740.00/year
1BOX LAN CABLE @ 800.00
Salvage value = 800.00 * .2 = 160.00
Description value = 800.00 – 105.00 3
S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
19
=213.33/year
1BOX RJ45 @ 150 .00
Salvage value =150.00 * .2 = 30.00
Description value = 150.00 – 30.00 3 =40.00/year
(1) Router @ 1398 .00
Salvage value =1398.00 * .2
C O L L E G E O F
= 270.06
Description value =1398.00 – 270.06 3 =375.08/year Total Equipment Cost: A. Personnel
5280.33
192,000.00
B. Supplies
2,369.13
C. Equipment
2334.82
Total Annual Cost (Proposed System)
196703.95
Development Cost
A.
C O M P U T E R
Hardware Cost (3) Computer set @ 16181.00
Diamond Evolution LCD17 inch Monitor
= 5082.00
Diamond Evolution AVR
= 535.00
Diamond Evolution Mouse
= 15 150.00
S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
Diamond Evolution Key Board
= 250.00
Diamond Evolution Desktop
=10164.00
Desktop Specs. Internal Memory RAM
= 2.00GB
Hard Disk Capacity
=60.00GB
Processor
= Intel Pentium 1.60GHZ
Video Card
=400 300 AGP
Window System Type
= MS Window7 32bit
20
C O L L E G E O F
Salvage value = 48543.00 * .2 = 9708.06
Description value = 48543.00 – 9708.06
C O M P U T E R
3 =12,944.98/year
(1) Biometrics @ 4500.00
Salvage value = 4500.00 * .2 = 900.00
Description value = 4500.00 – 900.00 3 =1200.00/year
1BOX BOX LAN LAN CA CABLE BLE @ 800. 800.00 00
Salva alvag ge val value ue = 800 800.0 .00 0 * .2 = 160.00
S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
21
Description value = 800.00 – 105.00 3 =213.33 year
1BOX RJ45 @ 150 .00
Salvage value =150.00 * .2 = 30.00
Description value =150.00 – 30.00
C O L L E G E O F
3 =40.00/year
(1) Router @ 1398 .00
Salvage value = 1398.00 * .2 = 270.6
Description value =1398.00 – 270.6 3
C O M P U T E R
=375.8/year
(1) (1) Can Canon on prin printe terr @ 6525 6525.0 .00 0
Salv Salvag age e val value ue = 652 6525. 5.00 00 * .2 .2 = 1305.00
Description value = 6525.00 – 1305.00 3 =1740.00/year Total Hardware Cost
16138.31
S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
B.
22
Software Cost (1) Visual Studio 2008 @ 1825.00
Salvage value =1825.00 * .2 = 365.00
Description value =1825.00 – 365.00 3
C O L L E G E
= 486.26 Total Software Cost C.
D.
486.26
Labor Cost Programmer 12,000 per Month
= 48000.00
Total Labor Cost
= 48000.00
Supplies Cost Printer Ink
500.00
Ream bond paper
160.00
Ball pen 15.00
Total Labor Cost
682.00
Electric Consumption Cost Florescent 25watts * Hrs usage in 4 months/ 4months
25watts * 128 / 4
=
800.00
Computer 220v * Hrs usage in 4 months/ 4months 220v * 128 / 4
Total Labor Cost
C O M P U T E R
7.00
DVD-R
E.
O F
=
2560.00
3650.00
S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
F.
Food and Transportation Cost
2000.00
A. Hardware Cost
16,138.31
B. Software Cost
486.26
C. Labor Cost
48,000.00
D. Supplies Cost
682.00
E. Electric Consumption Cost
3,650.00
F. Food and Transportation Cost
22,956.57
Cost and Benefits Analysis
Existing Cost
387,784.20
Proposed System Cost
196,703.95
Annual Cost Saving
191,980.25
ANNUAL ANNUAL COST
PRESENT VALUE
BENEFIT
C O L L E G E
2,000.00
Total Development Cost
YEAR
23
CUMMLATIVE PRESENT VALUE
1
191,980.25
171,438.00
171,438.00
2
191,980.25
153,200.00
324,628.00
3
191,980.25
136,690.00
461,318.00
4
191,980.25
122,099.00
583,417.00
5
191,980.25
108,853.00
692,270.00
O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
24
To get the Present Value:
Pres Presen entt Valu Value e
=191 =191,9 ,980 80.2 .25* 5* 1 (1+1 (1+12/ 2/10 100) 0)
171,438.00
=191,980.25* 1 / (1.12)
for first year
=191,980.25* .893 Pres Presen entt Valu Value e
=191 =191,9 ,980 80.2 .25* 5* 1 (1+1 (1+12/ 2/10 100) 0)2 2
153,200.00
=191,980.25* 1 / (1.12 x 1.12)
for second year
=191,980.25* .797 Pres Presen entt Valu Value e
=191 =191,9 ,980 80.2 .25* 5* 1 (1+1 (1+12/ 2/10 100) 0)3 3 =191,980.25* 1 / (1.12 x 1.12 x 1.12)
136,690.00 for third year
=191,980.25* .712 Pres Presen entt Valu Value e
=191 =191,9 ,980 80.2 .25* 5* 1 (1+1 (1+12/ 2/10 100) 0)4 4
122,099.00
=191,980.25* 1 /
for fourth year
(1.12 x 1.12 x 1.12 x 1.12) =191,980.25* .636 Pres Presen entt Valu Value e
=191 =191,9 ,980 80.2 .25* 5* 1 (1+1 (1+12/ 2/10 100) 0)5 5
108,853.00
=191,980.25* 1 /
for fifth year
(1.12 x 1.12 x 1.12 x 1.12 x1.12) =191,980.25* .567
To get the payback period: Formula:
Payback Period = Annual Cost / Present Value
C O L L E G E O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
Payback Period per Year
Annual Cost
Present Value
1.1198 YEAR 1
191,980.25
171,438.00
1.2531 YEAR 2
191,980.25
153,200.00
1.2531 YEAR 3
191,980.25
136,690.00
1.5723 YEAR 4
191,980.25
122,099.00
1.76367 YEAR 5
191,980.25
108,853.00
To get the net saving: Formula: Net Saving = End Cumulative Present Value – Total Development Cost Net Saving per Year
End Cumulative Present Value
Total Development Cost
148,481.43 year1
171,438.00
22,956.57
301, 671.43 year2
324,628.00
22,956.57
438,361.43year3
461,318.00
22,956.57
560,460.43year4
583,417.00
22,956.57
669,313.43year5
692,270.00
22,956.57
To get the ROI: Formula:
25
C O L L E G E O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
26
Return of Investment (ROI) (5 years) = ((End ( (End Cumulative Present Value – Total Development Cost / End Cumulative Present Value) * 100 ROI
End Cumulative
Total
End Cumulative
Present Value
Development
Present Value
Cost 86.61 Year 1
171,438.00
22,956.57
171,438.00
92.93 Year 2
324,628.00
22,956.57
324,628.00
95.02 Year 3
461,318.00
22,956.57
461,318.00
96.06 Year 4
583,417.00
22,956.57
583,417.00
96.68 Year 5
692,270.00
22,956.57
692,270.00
C O L L E G E O F C O M P U T E R S T U D I E S
Appendix I Survey Form To the Respondent, Respondent,
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
27
The undersig undersigned ned is currently currently working working on our thesis thesis entitled entitled “LAN-BASED Timekeeping and Payroll System using Biometrics for Blanco Family Academy”. Your Answer Answer to the questions questions is solicited solicited with with great great trust trust that you will will answer answer the questions with the truth and sincerity. Your honest answers will be treated with utmost confidentiality and that they will not be used for any purposes except for this particular research. Thank you very very much much for for your cooperation. cooperation. Chester I. Barry
C O L L E G E
Joemel A. Valenzuela
Researcher
C O M P U T E R
Name of Respondents:
A. Gender: B. Age: C. Profession:
Please check the box that corresponds to your answer:
1. Are you satisfie satisfied d in your current current Timekee Timekeeping ping system system using Bundy Bundy Clock? Clock?
Yes
No
2. Do you want want to change change your your current system to Timekeepin Timekeeping g and Payroll Payroll System System using Biometrics?
Yes
O F
No
S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
28
3. Do you think think using using biometrics biometrics is more accurate accurate than using using the usual usual time time card? Yes
No
4. Do you agree agree that that implementi implementing ng the proposed proposed system to your company company would would lessen the fraud committed by some of the employees?
Yes
No
5. Do you think think that the the system system will will optimize optimize the process process of of the company company in Computing wages and the timekeeping?
Yes
C O L L E G E
No
Signature
O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
Appendix J User Testing Form The undersig undersigned ned is currently currently working working on our thesis thesis entitled entitled “LAN-BASED Timekeeping and Payroll System using Biometrics for Blanco Family Academy”. Your Answer Answer to the questions questions is solicited solicited with with great great trust trust that that you will answer answer the questions with the truth and sincerity. Your honest answers will be treated with utmost confidentiality and that they will not be used for any purposes except for this particular research. Thank you very very much much for for your cooperation. cooperation. Chester I. Barry Joemel A. Valenzuel Valenzuela a
Researcher In a scale of 1 to 5, Kindly test the system according to the following criteria on software quality. Place a check in a box that corresponds to your score. 5 – Excellent Improvement
I.
4- Good
3- Average
2-Poor
1-Needs
CORRECTNESS CORRECTNESS ( refers to the extent to which which a program satisfies its specification and fulfil the user’s objective) Remarks:__________________________ 5 4 3 2 1
II. RELIABILITY (referred as the extent to which a program can be expected to perform its intended function with required precision of results). extent did the program performed its intended function with Remarks:__________________________ 5 4 3 2 1
III. EFFICIENCY (refers to the amount of computing resources and code required by a program to perform its function)
29
C O L L E G E O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
5
4
3
2
1
Remarks:__________________________
IV. TESTABILITY TESTABILITY (referred as the effort required required testing the program program to ensure the program performs its intended function). How hard is it to test this program considering the degree to which it can be understood 5
4
3
2
1
Remarks:__________________________
V. PORTABILITY (referred to the effort required to transfer the program from one hardware and / or software system environment to another). Does the system is made up of separate modules that can be rearranged, replaced or interchanged easily. Remarks:__________________________ 5 4 3 2 1
Evaluated By:
Signature over Printed Name / Date
30
C O L L E G E O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
C O L L E G E
Appendix K System Testing Form SYSTEM TESTING EVALUATION FORM Kindly test the system modules according to its functions and performance with the following categories: Where:
3 – Full Compliance 2 – Partial Compliance 1 – Non Compliance
I. BLOCK BOX TESTING (Test are based on requirements and functionality) and WHITE BOX TESTING (Test are based on coverage of code statement, branches, paths, conditions).
NC
PC
FC
31
REMARKS
TIME LOG FORM
*Log-In
__________________________
*Log-Out
__________________________
*Manual Log button
__________________________
MANUAL LOG-IN FORM
*Username textbox
__________________________
*Password textbox
__________________________
O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
32
*Submit button ______________ _____________________ ____________ _____
*Back button
__________________________
MANUAL FORM
*Get Schedule drop down
C O L L E G E
______________ _____________________ ____________ _____
*Get Schedule button
__________________________
O F
*Manual Time-in ______________ _____________________ ____________ _____
*Manual Time-Out
__________________________
*Save Button
__________________________
*Back Button
__________________________
LOG-IN FORM
*Username textbox
__________________________
*Password textbox
__________________________
*Submit button ______________ _____________________ ____________ _____
*Cancel button ______________ _____________________ ____________ _____
MANAGEMENT FORM
*Employee Management Button ______________ _____________________ ____________ _____ *Finger Print Registration Button
__________________________
*Payroll Transaction Button
__________________________
*Loan Cash Advance Button
__________________________
*Leave Button
__________________________
C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
33
*Holiday Button ______________ _____________________ ____________ _____
*Report Button ______________ _____________________ ____________ _____
*Access Control Button ______________ _____________________ ____________ _____
*Logout Button ______________ _____________________ ____________ _____
C O L L E G E O F
EMPLOYEE MANAGEMENT FORM
* Add Record ________________ _______________________ __________ ___ * Delete Record ________________ _______________________ __________ ___ * Edit Record ________________ _______________________ __________ ___ * Save Record ________________ _______________________ __________ ___ * Clear ________________ _______________________ __________ ___ * Set Schedule ________________ _______________________ __________ ___ *Day ________________ _______________________ __________ ___ *Time-In ________________ _______________________ __________ ___ *Time-Out ________________ _______________________ __________ ___ *Add ________________ _______________________ __________ ___ *Delete ________________ _______________________ __________ ___
C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
34
* Salary Button ________________ _______________________ __________ ___ *Set Monthly Salary ________________ _______________________ __________ ___
C O L L E G E
*Set BIR Exemption ________________ _______________________ __________ ___ *SSS Table Button ________________ _______________________ __________ ___ *PhilHeatth Table Button ________________ _______________________ __________ ___ *Tax *Tax Co Comp mput utat atio ion n Sam Sampl ple e ________________ _______________________ __________ ___
Butt Button on
*Reset ________________ _______________________ __________ ___ *Save ________________ _______________________ __________ ___ *Allowances _______________ ______________________ ___________ ____ *Rice _______________ _______________________ ___________ ___ *Clothing _______________ _______________________ ___________ ___ *Laundry _______________ _______________________ ___________ ___ *Transportation _______________ _______________________ ___________ ___ *Cell phone Load _______________ _______________________ ___________ ___ *Medicine _______________ _______________________ ___________ ___ *Others _______________ _______________________ __________ __
FINGER PRINT REGSTRATION FORM
O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
35
* Search Name ________________ _______________________ __________ ___ * Input Finger Type ________________ _______________________ __________ ___ * Register ________________ _______________________ __________ ___ * Cancel ________________ _______________________ __________ ___
PAYROLL TRANSACTION
* Search ________________ _______________________ __________ ___ * Schedule Information ________________ _______________________ __________ ___ * Calculate ________________ _______________________ __________ ___ * Overtime ________________ _______________________ __________ ___ * Print ________________ _______________________ __________ ___ * View Calculation ________________ _______________________ __________ ___ LOAN / CASH ADVANCE FORM
* Search ________________ _______________________ __________ ___ * Loan Type ________________ _______________________ __________ ___ * Loan Amount ________________ _______________________ __________ ___ * Interest ________________ _______________________ __________ ___ * Payment Period ________________ _______________________ __________ ___
C O L L E G E O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
36
* Save Loan ________________ _______________________ __________ ___ * Delete Loan ________________ _______________________ __________ ___ * Cash Advance ________________ _______________________ __________ ___ *Amount ________________ _______________________ __________ ___ * Save Cash Advance ________________ _______________________ __________ ___ * Delete Cash Advance ________________ _______________________ __________ ___
LEAVE FORM
* Search ________________ _______________________ __________ ___ * Type of Leave ________________ _______________________ __________ ___ * Set Date Leave ________________ _______________________ __________ ___ * Submit ________________ _______________________ __________ ___
HOLIDAY FORM
* Holiday Date ________________ _______________________ __________ ___ * Holiday Name ________________ _______________________ __________ ___ * Set Holiday ________________ _______________________ __________ ___ * Add ________________ _______________________ __________ ___ * Delete ________________ _______________________ __________ ___
C O L L E G E O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
37
* Save ________________ _______________________ __________ ___
REPORT FORM
* Payroll ________________ _______________________ __________ ___ *Report Type ________________ _______________________ __________ ___ *GroupType _______________ ______________________ ___________ ____ *Individual Type _______________ ______________________ ___________ ____ *Month ________________ _______________________ __________ ___ *Year ________________ _______________________ __________ ___ *Generate Report ________________ _______________________ __________ ___ * TAX ________________ _______________________ __________ ___ *Report Type ________________ _______________________ __________ ___ *GroupType _______________ ______________________ ___________ ____ *Individual Type _______________ ______________________ ___________ ____ *Month ________________ _______________________ __________ ___ *Year ________________ _______________________ __________ ___ *Generate Report ________________ _______________________ __________ ___
C O L L E G E O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
38
* SSS ________________ _______________________ __________ ___ *Report Type ________________ _______________________ __________ ___ *GroupType _______________ ______________________ ___________ ____ *Individual Type _______________ ______________________ ___________ ____ *Month ________________ _______________________ __________ ___ *Year ________________ _______________________ __________ ___ *Generate Report ________________ _______________________ __________ ___
* PhilHealth ________________ _______________________ __________ ___ *Report Type ________________ _______________________ __________ ___ *GroupType _______________ ______________________ ___________ ____ *Individual Type _______________ ______________________ ___________ ____ *Month ________________ _______________________ __________ ___ *Year ________________ _______________________ __________ ___ *Generate Report ________________ _______________________ __________ ___ * PAG-IBIG ________________ _______________________ __________ ___ *Report Type ________________ _______________________ __________ ___
C O L L E G E O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
39
*GroupType _______________ ______________________ ___________ ____ *Individual Type _______________ ______________________ ___________ ____ *Month ________________ _______________________ __________ ___ *Year ________________ _______________________ __________ ___ *Generate Report ________________ _______________________ __________ ___ * Timesheet ________________ _______________________ __________ ___ *Report Type ________________ _______________________ __________ ___ *GroupType _______________ ______________________ ___________ ____ *Individual Type _______________ ______________________ ___________ ____ *Month ________________ _______________________ __________ ___ *Year ________________ _______________________ __________ ___ *Generate Report ________________ _______________________ __________ ___
* Loan ________________ _______________________ __________ ___ *Report Type ________________ _______________________ __________ ___ *SSS Loan _______________ ______________________ ___________ ____ *PAG-IBIG _______________ ______________________ ___________ ____
C O L L E G E O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
40
*Month ________________ _______________________ __________ ___ *Year ________________ _______________________ __________ ___ *Generate Report ________________ _______________________ __________ ___
* Others ________________ _______________________ __________ ___ *Report Type ________________ _______________________ __________ ___ *13 Month Pay December _______________ _______________________ ___________ ___ *13 Month Pay March _______________ _______________________ ___________ ___ *Tax Refund _______________ _______________________ ___________ ___ *Year _______________ ______________________ ___________ ____ *Generate Report _______________ ______________________ ___________ ____ ACCESS CONTROL FORM ________________ _______________________ __________ ___
* Search ________________ _______________________ __________ ___ *Drop Acess ________________ _______________________ __________ ___ * Usename ________________ _______________________ __________ ___ * Password ________________ _______________________ __________ ___ * Save ________________ _______________________ __________ ___
C O L L E G E O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
41
* Delete ________________ _______________________ __________ ___
II. UNIT UNIT TESTING TESTING (The most micro micro sale of testing testing is to test test particul particular ar functions functions or code modules, particularly done by a programmer not testers, as it requires detailed knowledge of the internal program design and code.)
NC
PC
FC
TIME LOG FORM ________ ________
MANUAL LOG-IN FORM ________ ________
Remarks
C O L L E G E O F
MANUAL FORM ________ ________
LOG-IN FORM MANAGEMENT FORM ________ ________
EMPLOYEE MANAGEMENT FORM ________ ________
FINGER PRINT REGSTRATION FORM
C O M P U T E R
________ ________
PAYROLL TRANSACTION ________ ________
LOAN / CASH ADVANCE FORM ________ ________
LEAVE FORM ________ ________
REPORT FORM ________ ________
ACCESS CONTROL FORM ________ ________
LOGOUT FORM ________ ________
III.SECURITY TESTING (Testing on how will the system protects against unauthorized personnel internal and external access. This may require sophisticated sophisticated testing techniques.)
S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
42
Account Login Form Private Sub LoginForm1_Load
__________
Username Textbox This serves serves as the username username login
__________
Password Textbox This serves serves as the password password login
C O L L E G E
__________
O F
Login Button This serves serves as the button if you you already entered entered
__________
the username and password Cancel Button This serves serves as a close the LoginForm LoginForm
__________
Timelog Form Form Private Sub formMain_Load
__________
Finger Print Scanning This is the the area were the Employee Employee can scan their Fingerprint to Time in/out
__________
VI. INTEGRATION INTEGRATION TESTING (Testing of combined combined parts of an application to determine determine if they function together correctly. The parts can be code modules, individual applications, etc.) Client and server application on a network capable of copping errors.
NC
PC
FC
REMARKS
Administrator Form
__________ __________
Registrar Registrar Form
__________ __________
C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
Accounting Form
__________ __________
Recommendations / Comments:
_____________ _____________________ _______________ _______________ _______________ _______________ ________________ _______________ _______________ ________________ _______________ _________ __ _____________ _____________________ _______________ _______________ _______________ _______________ ________________ _______________ _______________ ________________ _______________ _________ __ _____________ _____________________ _______________ _______________ _______________ _______________ ________________ _______________ _______________ ________________ _______________ _________ __ _____________ _____________________ _______________ _______________ _______________ _______________ ________________ _______________ _______________ _________ _
Date Schedule of Re-Testing:
_____________ _____________________ _______________ _______________ _______________ _______________ __________ __
Tested by:
_____________ _____________________ _______________ _______________ _______________ _______________ ___________ ___ Signature over Printed Name / Designation/ Company
43
C O L L E G E O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
Appendix L Existing System
This Organization Organi zation is maintaining maintai ning most of their day-to-day day-to -day transactions date in the register (manually). The employees of the organization are doing the whole work manually. All the work is done manu manuall ally y (main (mainta tain ined ed and and regi registe sters) rs) so diffe differe rent nt emplo employe yees es are are appointed for the maintenance of register containing all information related to the organization The Timekeeping Timekeepi ng and Payroll Payrol l System Syste m of the Blanco Family Famil y Academy is inaccurate sometimes when it comes to computing their time logs and payroll. Also, the Employees Employees of the company company are using Bundy Clock to indicate in their Date Time Card their time of work in and and out out ever every y day day and and the Acco Accoun untan tantt admi adminis nistr trato atorr base based d the the wages of each employee in that time Card. It is hustle to use and long term creating the payroll slip, and the time keeping which the Human Resources need to encode all the attendance of employee using using spreads spreadshee heets. ts. Therefo Therefore re the Compan Company’s y’s Time Time Keeping Keeping and Payroll system need improvement.
44
C O L L E G E O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
Appendix M Thesis Proposal
45
C O L L E G E
Our Lady of Fatima University College of Computer Studies
O F
INITIAL THESIS PROPOSAL
Name of Proponents:
Barry, Chester I. Valenzuela, Joemel A.
Propose Title 1:
LAN-BASED Timekeeping and Payroll system using Biometrics for Blanco Family Academy
Area of Investigation:
This study study was aimed aimed to help to have an efficient efficient and effective effective way of Employees Time Keeping and Payroll System to give a higher quality of service. Specifically, this study was aim to develop a system that that will will impro improved ved the the comp company any’s ’s opera operatio tion n in the Emplo Employe yees es Time Time Keeping and Payroll System, that will monitor the employees’ data that is efficient to use and to be secure the records of employees and to have more manageable files.
C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
The Develop Developed ed System System for Blanco Blanco Family Family Academy Academy covers covers many many aspects of time Keeping and Payroll Process. This includes the capture of Information based on an employee’s work schedule, daily time worked, and daily time taken. The system also covers the payroll processing and repo report rtin ing g proc proces ess s enco encomp mpas asse ses s all all activ activiti ities es nece necessa ssary ry to repo report rt employee’s time worked. The system will convert the Time Keeping and Payroll System into Visual Basic 2008 Programming.
46
C O L L E G E O F
Prospective users/beneficiaries: users/beneficiaries:
Employees
The employe employees es of the company company will have a better better access. access. The proper time keeping process will follow and the salary for the hours that the employees have worked will be accurate.
HR Personnel
Managing the time keeping will not be the same again as they will expe experi rien ence ce relie relieve ve.. It woul would d be fast fast and and ea easy sy for for them them to hand handle le transactions such as report making and monitoring time entries. Further
C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
47
determining or computing the payroll manually will be eliminated that will lead to faster transaction.
C O L L E G E O F C O M P U T E R
Appendix N Adviser’s Acceptance Form TECHNICAL TECHNICAL ADVIS ADVISER’S ER’S ACCEPTA ACCEPTANCE NCE FORM FORM The students whose names names and signatures fixed below below have agreed to choose you as their Thesis Adviser for the research entitled:
LAN-BAS LAN-BASED ED TIMEKEE TIMEKEEPIN PING G AND PAYROLL PAYROLL SYSTEM SYSTEM USING USING BIOMETRI BIOMETRICS CS FOR BLANCO FAMILY ACADEMY 1. Barr Barry, y, Ches Cheste terr I. I. 2. Vale Valenz nzuel uela, a, Joe Joemel mel A.
S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
48
By accepting this, you are expected to perform the following responsibilities: 1. Render Render at least one one (1) hour hour per week as consult consultati ation on hour hour to discuss discuss matters related to their research. 2. Guide Guide the Stude Student nts s in accom accompl plish ishin ing g the manu manuscr scrip ipts ts (ACM) (ACM) Fo Forma rmatt Including all the details necessary for the documents in accordance with the thesis format given by the Thesis subject adviser. 3. Provid Provide e assist assistan ance ce in desig designin ning g and and / or coding coding the soft softwa ware re of the project. 4. Re Rec commend the the grou roup for mock and final defe efense if dee eem med appropriate. 5. Rate the students by by giving them the equivale equivalent nt 20% of their final final grade grade in accordance with guidelines and criteria provided by the thesis subject adviser related to document and software. Hoping Hoping for your your utmost utmost coopera cooperatio tion n for the continu continued ed develo developme pment nt of our students.
Appendix O
C O L L E G E O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
49
Company’s Acceptance Form C O L L E G E O F C O M P U T E R S T U D I E S Appendix P
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
50
Proponents Consultation Form C O L L E G E O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
51
C O L L E G E O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
52
Appendix Q Grading Sheet
C O L L E G E O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
53
C O L L E G E O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
54
C O L L E G E O F C O M P U T E R S T U D I E S
Appendix R Form 21: Endorsement to the English Department
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
55
C O L L E G E O F C O M P U T E R S T U D I E S
Appendix S Result of SPSS Statistical Treatment Frequency Table
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
56
Correctness Evaluation of Existing
Frequency
Valid
Percent
Valid
Cumulative
Percent
Percent
Poor
5
45.5
50.0
50.0
Averag
4
36.4
40.0
90.0
Good
1
9.1
10.0
100.0
Total
10
90.9
100.0
1
9.1
11
100.0
e
Missing
System Total
O F
Table 19: Correctness Evaluation of Existing Reliability Evaluation of Existing
Frequency
Valid
Percent
Valid
Cumulative
Percent
Percent
Poor
4
36.4
40.0
40.0
Averag
5
45.5
50.0
90.0
Good
1
9.1
10.0
100.0
Total
10
90.9
100.0
1
9.1
11
100.0
e
Missing
System Total
Table 20: Reliability Evaluation of Existing
Efficiency Evaluation of Existing
Frequency
Percent
C O L L E G E
Valid
Cumulative
Percent
Percent
C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
Valid
Poor
5
45.5
50.0
50.0
Averag
5
45.5
50.0
100.0
Total
10
90.9
100.0
System
1
9.1
Total
11
100.0
e
Missing
57
C O L L E G E
Table 21: Efficiency Evaluation of Existing
O F Testability Testability Evaluation of Existing
Frequency
Valid
Percent
Valid
Cumulative
Percent
Percent
Poor
7
63.6
70.0
70.0
Averag
3
27.3
30.0
100.0
Total
10
90.9
100.0
System
1
9.1
Total
11
100.0
e
Missing
Table 22: Testability Evaluation of Existing
Portability Evaluation of Existing
Frequency
Percent
Valid
Cu Cumulative
C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
Valid
Percent
Percent
Poor
4
36.4
40.0
40.0
Averag
6
54.5
60.0
100.0
Total
10
90.9
100.0
System
1
9.1
Total
11
100.0
e
Missing
Table 23: Portability Evaluation of Existing
Correctness Evaluation of Prototype
Frequency
Valid
Percent
Valid
Cumulative
Percent
Percent
Poor
1
9.1
10.0
10.0
Averag
7
63.6
70.0
80.0
Good
2
18.2
20.0
100.0
Total
10
90.9
100.0
System
1
9.1
Total
11
100.0
e
Missing
Table 24: Correctness Evaluation of Prototype
58
C O L L E G E O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
59
Reliability Evaluation of Prototype
Frequency
Valid
Percent
Valid
Cumulative
Percent
Percent
Poor
1
9.1
10.0
10.0
Averag
5
45.5
50.0
60.0
Good
4
36.4
40.0
100.0
Total
10
90.9
100.0
System
1
9.1
Total
11
100.0
e
Missing
O F
Table 25: Reliability Evaluation of Prototype
Efficiency Evaluation of Prototype
Frequency
Valid
Percent
Valid
Cumulative
Percent
Percent
Poor
2
18.2
20.0
20.0
Averag
3
27.3
30.0
50.0
Good
5
45.5
50.0
100.0
Total
10
90.9
100.0
System
1
9.1
Total
11
100.0
e
Missing
C O L L E G E
Table 26: Efficiency Evaluation of Prototype
C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
Testability Testability Evaluation of Prototype
Frequency
Valid
Percent
Valid
Cumulative
Percent
Percent
Poor
1
9.1
10.0
10.0
Averag
4
36.4
40.0
50.0
Good
5
45.5
50.0
100.0
Total
10
90.9
100.0
1
9.1
11
100.0
e
Missing
System Total
Table 27: Testability Evaluation of Prototype
Portability Evaluation of Prototype
Frequency
Valid
Averag
Percent
Valid
Cumulative
Percent
Percent
8
72.7
80.0
80.0
Good
2
18.2
20.0
100.0
Total
10
90.9
100.0
1
9.1
11
100.0
e
Missing
System Total
Table 28: Portability Evaluation of Prototype
60
C O L L E G E O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
Correctness Evaluation of Proposed
Frequency
Valid
Percent
Valid
Cumulative
Percent
Percent
Average
3
27.3
30.0
30.0
Good
5
45.5
50.0
80.0
Excellen
2
18.2
20.0
10
90.9
100.0
1
9.1
11
100.0
100.0
61
C O L L E G E O F
t Total Missing
System Total
Table 29: Correctness Evaluation of Proposed
Reliability Evaluation of Proposed
Frequency
Valid
Percent
Valid
Cumulative
Percent
Percent
Average
2
18.2
20.0
20.0
Good
5
45.5
50.0
70.0
Excellen
3
27.3
30.0
100.0
10
90.9
100.0
1
9.1
11
100.0
t Total Missing
System Total
Table 30: Reliability Evaluation of Proposed
C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
Efficiency Evaluation of Proposed
Frequency
Valid
Percent
Valid
Cumulative
Percent
Percent
Average
2
18.2
20.0
20.0
Good
5
45.5
50.0
70.0
Excellen
3
27.3
30.0
100.0
10
90.9
100.0
1
9.1
11
100.0
t Total Missing
System Total
Table 31: Efficiency Evaluation of Proposed
Testability Evaluation of Proposed
Frequency
Valid
Percent
Valid
Cumulative
Percent
Percent
Average
2
18.2
20.0
20.0
Good
7
63.6
70.0
90.0
Excellen
1
9.1
10.0
100.0
10
90.9
100.0
1
9.1
11
100.0
t Total Missing
System Total
Table 32: Testability Evaluation of Proposed
62
C O L L E G E O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
C O L L E G E
Portability Portability Evaluation of Proposed
Frequency
Valid
Percent
Valid
Cumulative
Percent
Percent
Average
1
9.1
10.0
10.0
Good
7
63.6
70.0
80.0
Excellen
2
18.2
20.0
100.0
10
90.9
100.0
1
9.1
11
100.0
t Total Missing
System Total
Oneway Anova ANOVA
Type of System System Df
Mean Square
F
Sig.
Squares Between
16.917
11
1.538
3.083
18
.171
20.000
29
Groups Within Groups Total
Table 34: Oneway Anova
8.978
O F C O M P U T E R S T U D I E S
Table 33: Portability Evaluation of Proposed
Sum of
63
.000
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
Appendix T User Manual
64
C O L L E G E O F C O M P U T E R
Figure 10: Main Form Main Form 1.) Picture- it display the employee photo. 2.) Employee Information- it shows the information of the
employee that has been logged. 3.) Login- it display the login name and time of the employee. 4.) Time- display the current time.
S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
65
5.) Logout-it display the logout name and time of the employee. 6.) Manual login- it allow the user to input the logged manually.
C O L L E G E O F
Figure 11: Form Manual Login Form Manual Login 1.) Username- Where the user inputs the username. 2.) Password- Where the user inputs the password. 3.) Login- Submit the username and password to enter the Form
schedule. 4.) Back -cancel -cancel the session and to go back to the Main Form.
C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
66
C O L L E G E O F
Figure 12: Form Manual
Form Manual 1.) Employee Information- Select an Employee that will add a date
and time schedule. 2.) Date- it allow the user to select a date that will to set the
schedule. 3.) Get Schedule- it allows the user to view the Schedule. 4.) Time- where the user inputs the time of the employee’s employee’s time in
and out. 5.) Save- it allows the user to save the schedule. 6.) Back - it allow the user to close the form and go back to the main
form.
C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
67
C O L L E G E O F Figure 13: Login Form Login Form 1.) Username- Where the user inputs the username. 2.) Password- Where the user inputs the password. 3.) Login- Submit the username and password to enter the Form
Management. 4.) Cancel -cancel the session and to go back to the Main Form.
C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
68
C O L L E G E O F Figure 14: Form Management Form Management 1.) Employee Management- it allows the user to add new employee
Information, Information, were it can be edited, set it salary delete and view the information about the employee. Registration- It allows the user to select an 2.) Finger Print Registration
employee employee that will enroll its fingerpri f ingerprint. nt. 3.) Payroll Transaction- Where the user select an employee to view
the work details and compute its salary deduction. 4.) Loan- it allow the user to view, add a new loan and cash advance
for an employee. 5.) Leave- it allow the user to set a leave for an employee whether it
Vacation, Sick, Paternal or Maternal leave. 6.) Holiday - It set a Holiday if it’s it’ s Special or non working Holiday. 7.) Reports- it allow the user to view all kind of reports. 8.) Control access- It allows the admin to add an account that can
be access a limited section in the system. 9.) Logout- it allows the user to close the Form Management.
C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
69
C O L L E G E O F Figure 15: Employee Management Form Employee Management Form 1.) Search- It allows the user to search the name of the Employee. 2.) Next & Previous – it allows the user to view the next or previous
Employee. 3.) Employee Information- it allow the user to enter new and edit
C O M P U T E R
information of the employee. 4.) Add Employee- where the user can add new employee
Information. 5.) Edit Employee- where the user can edit the employee
information. 6.) Salary- allows the user to set the salary for the employee. 7.) Set Schedule- allows the user to set the schedule of the
employee 8.) Delete Employee- where the user can delete the current
employee. 9.) Clear- where the user can clear the information of the employee. 10.) Save Employee- allows the user to save the new employee
information.
S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
70
11.) Back – it allows the user to go back in the Form Management
C O L L E G E O F
Figure 16: Form Schedule Form Schedule 1.) Day- it allow the user to select the days of work of an employee. 2.) Start Time- It allows the user to select what time of start of work
on the employee. 3.) End Time- It allows the user to select what time of end of work on
the employee. 4.) Add- where the user can add the days and time of schedule of the
employee. 5.) Delete- where the user can remove the days of worked the
employee.
C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
71
C O L L E G E
Figure 17: Salary Form Salary Form 1.) Allowances - it allows the user to add some aalowances into the
employee. 2.) Monthly Salary- it allows the user to enter the basic salry of the
employee.
O F C O M P U T E R
3.) Deductions - it allow the user to see the deductions of SSS,
Philhealth and Tax and its contributions every month. month. 4.) Table- it will view the deduction table of SSS, Philhealth and Tax. 5.) Reset- it resets all the deduction of employee. 6.) Save- it saves the deductions of an employee.
S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
72
C O L L E G E O F Figure 18: 18: Finger Print Print Registration Registration Form Fingerprint Registration Form 1.) Emloyeename- it allows the user to select the employee to be
registered its fingerpri f ingerprint. nt. 2.) Search- it allows the user to search employee. 3.) Input finger- it allow the user to select what finger to be
registered. 4.) Register - it registered the finger print of the employee. employee. 5.) Cancel- cancel the registration of the finger print. 6.) Sensor- it recognize the fingerprint of employee to be registered.
C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
73
C O L L E G E O F Figure 19: Payroll Transaction Form Payroll Transaction Form 1.) Search- it allows the user to search the employee. 2.) Print-shows the print results of payslip of the employee. employee. 3.) Close-it close then form and stop the transaction. 4.) Next & Previous- it view the next and previous employee. 5.) Late and Overtime – it Display the value of lates and overtime. 6.) Work Details- it shows the worked hours, days, present absent
and leave of employee. 7.) Deductions - it display the deduction of SSS, Philhealth, Tax and
Loans. 8.) Month- it allows the user to select on what month of the
transaction he/she wants to transact. 9.) Year-it allows theuser yto input on what year he/she wants to
transact. Calculate- it computes the worked details, OT,Lates adn deductions.
10.)
C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
74
Overtime- it shows s hows if the user wants to add the overtime in the computations.
11.)
12.)
View calculations- it allows the user to view the
computations of the transaction.
C O L L E G E O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
75
C O L L E G E O F
Figure 20: Loan Form Loan Form 1.) Search- it allows the user to search the employee’s name. 2.) Loan Type- it allows the user to select select on what type of loan loan that
it will be given to the employee. 3.) Loan Amount and Interest- it inputs the amount and interest
the loan. Amortization Period- it set the period of starting date to end 4.) Amortization
and how long it will be a fiished. 5.) Compute- it computes the loan amount and interest. 6.) Save- save the current type of loan.
C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
76
7.) Cash Advance Amount- it inputs the amount needed by the
employee maximum of 500 pesos. 8.) Save- save the cash advance. 9.) Cancel- cancel the transaction.
C O L L E G E O F C O M P U T E R
Figure 21: Leave Form
Leave Form 1.) Search- it allow the user to search the name of employee. 2.) Date Period-it set the date of Leave. 3.) Type of leave- where the user can select what type of leave.
S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
77
4.) Submit- submit the leave form of employee. 5.) Exit- it close the form and back to the Form Management.
C O L L E G E O F C O M P U T E R
Figure 22: Holiday Form
Holiday Form 1.) Date- sets the date of Holiday. 2.) Description- the user inputs the description of holiday. 3.) Holiday Type- it allows the user to choose what type of holiday
he/she wants to add. 4.) Add- add new type of holiday. 5.) Save- saves the new type of holiday.
S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
78
6.) Delete- It allows the user to delete a type of holiday. 7.) Back - it close the form Holiday.
C O L L E G E O F C O M P U T E R
Figure 23: Form Reports
Form Reports 1.) Reports- it allows the user to select a type of reports. 2.) Report Type- where the user can select a type of report whether
its group or individual. 3.) Search- it allows the user to search the name of employee.
S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
79
4.) Month- it allows the user to select what month he/she wants to
generate. 5.) Year- it allows the user to select what year he/she wants to
generate. 6.) Generate- it allows the user to generate the Report.
C O L L E G E O F C O M P U T E R S T U D I E S
Figure 24: Form Access Control
5 6
Form Access Control
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
80
1.) Select user – it allows the admin to select user that he/she wants
to give some access on the system. 2.) Submit- it allows the admin to submit the enrolled section that
will be accessed by the user. 3.) Cancel- Cancel the enrolled section . 4.) Enrolled button- it allows the admin to enroll some section that
he/she wants to give some access in the system. 5.) Username- it allows the user to input its username to accessed
the system. 6.) Password- it allows the user to input its password to accessed
the system.
C O L L E G E O F C O M P U T E R S T U D I E S
Bibliography
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
81
A. Books
Steven bragg, “Accounting for Payroll” page 42-48, 2004 Walpale Myer, “Probability Statistics for scientist and Engineer”, 7th edition, B. Journals Journals and and Magaz Magazines ines I mplemented Philippine National National Police: “ Biometrics Technology to be Implemented in PNP”,Philippine Inquirer, 2009.
Mendrz, Andrew: Andrew: “Vision Designer Designer Inc.”, 2010 2010 Floran, Ramon: “The Computer Edge of the New Employment and Opportunities”, Philippine Daily Inquirer, Page 14, October 2005.
Primer, Thomas: “Automated Computerize Process” Readers Digest magazine, page 45, May 2005. Better Humans: “Sweet FingerPrint”, 2003 Watson: “ESVES Biometrics System”, 2011 Johnson: Johnson: “Mod “Modern ern Compute Computerr Acceler Accelerates”, ates”, 1994 1994
C. Unpublished Materials (Theses)
C O L L E G E O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
82
Aquilan, Aquilan, John: “Automa Technologicall “Automatio tion n of time attend attendanc ance e System” System” , Technologica Institute of the Philipines, Cubao Quezon City, March 2004.
Cantoma, Cantoma, Andrea: “Compu “Computer ter Librar Library y System System for St. James James Academ Academy” y” Technologic Technological al Institute Institute of of the Philipin Philipines, es, Cubao Cubao Quezon City, March 2004.
Comp Co mput uter er
Engi Engine neer ers: s:
“Comp Comput uter eriz ized ed
Dail Daily y
Time Time
Reco Record rd
Syst System em”, ”,
Technologic Technological al Institute Institute of of the Philipin Philipines, es, Cubao Cubao Quezon City, August 2007.
Olivar: Olivar: “Biometrics University ty of the East, East, Biometrics Attendance Attendance Record Record System”, System”, Universi Manila, March 2001.
C O L L E G E O F C O M P U T E R
D. Electron Electronic ic Source Sources s http://www.scribd.com/doc/45262822/Thesis-1-4-ted
Wikipedia: Terminologies Http://Wikipedia.org
S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
CHESTER I. BARRY Address: C-436 MH Del Pilar Brgy. San Isidro, Antipolo City Mobile: +639164849900 E-mail Address:
[email protected] [email protected] OBJECTIVE: To be able to find a position position that would best fit my knowledge knowledge in the fields of Information Technology that will allow me to make use of everything I have learned and allow me to develop my talent to become more effective for myself and for the company as well.
PROFESSIONAL SKILLS: • • •
• • •
•
Knowledgeable in Microsoft Office (Word, Excel, PowerPoint & Outlook). Basic skills in using Linux OS (CENTOS). Basic skills in Visual Basic 2008, Adobe Photoshop CS3 & CS4, Flash4, PHP and MySql. Basic skills in Computer Networking. Knowledgeable in using SAP Application. Reliable and adaptable, can easily cope up with pressures and changing situation. Willing and able to do wide variety of tasks.
EDUCATIONAL BACKGROUND: Tertiary
Secondary
Primary
Our Lady of Fatima University Bachelor of Science in Information Technology Km. 23 Sumulong Highway, Antipolo City 2008-Present Our Lady of Peace School P. Oliveros St., Antipolo City 2004-2008 Our Lady of Peace School P. Oliveros St., Antipolo City 2001-2004 ST. Clare Montessori School C. Lawis st. Antipolo City 1997-2001
83
C O L L E G E O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
SEMINAR ATTENDED: •
•
•
•
•
•
•
Youth Conference Conference in IT: Think Think IT! Do It!, It!, University University of of the Philippines Philippines Diliman, Quezon City (February 18, 2011). “Network Management”, Our Lady of Fatima University, Antipolo City (September 14, 2010). “Non Linear Video Editing”, Our Lady of Fatima University, Antipolo City (September 14, 2010). “Personality Development Seminar”, “Empowering mind through Information Technology”, Our Lady of Fatima University, Antipolo City (December 10, 2009). “Visual Basic .Net and Net Firmware”, “Empowering mind through Information Technology”, Our Lady of Fatima University, Antipolo City (December 9, 2009). “Robotics in Education”, “Empowering mind through Information Technology”, Technology”, Our Lady Lady of Fatima University, University, Antipolo Antipolo City (Decem (December ber 7, 7, 2009). “Philippine Youth Congress in Information Technology 2009”, University of the Philippines Diliman, Quezon City (September 9, 2009).
TRAININGS: •
On-the-Job-Training “United Laboratories Inc.” Manufacturing Networking Solutions Group (MNSG) Data and System Solution (DSS) Research and Manufacturing Compound, 66 United Street Mandaluyong City. Packaging Material Specification Update using SAP Application. Corporate Audit in Different warehouse and manufacturing in Mandaluyong City and Laguna Cluster. Monthly Report and Follow up email. Master Data Completion and 1 st Square Update. Biz right Biz Rule Update.
“Summit Technologies Inc.” Human Resource Department 3/F Business Solution Center Meralco Compound, Ortigas Ave. Pasig City.
84
C O L L E G E O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
Set-up Computers for the MT Exams. Checking and Merging of Files. Assisting an Applicant for their Interview. Updating and checking the Update Summary.
ACCOMPLISHEMENT: •
•
•
•
• •
Feasibility Study in Software Engineering Top 2 in SE – Student-Fac Student-Faculty ulty Evaluati Evaluation on System System for Our Lady of of Fatima Fatima University - Using PHP and MySql, year 2011 Project Study in Database System Entitled – Reservation System for Sunrock Resort - PHP and MySql. ,year 2010 Feasibility Study in System Analysis and a nd Design Entitled – Student-Faculty Evaluation system for Our Lady of Fatima University -Using Visual Basic 2008 Express Edition with my group mates when I was in year 2010 Accomplished Project Project Study in Management Management in Information I nformation System Entitled - Management in Information System for Eastern Telecommunic Telecommunication ation when I was in 2nd year level. Accomplished Project Study in Logic Switching and Design Task Gathering data’s, conduct interviews and make technical report, Created databases and programs using Microsoft Access 2003, Created databases and programs using VB 2008 Express Edition, Created databases and programs using PHP and MySQL.
AFFILIATION: Member of Fatima Antipolo Computer Studies Society, In Our Lady of Fatima University – Antipolo Campus.
•
PERSONAL INFORMATION: Date of Birth: Place of Birth: Gender: Civil Status: Height:
April 2, 1991 Sta. Mesa, Manila Male Single 5’4
85
C O L L E G E O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
Weight: Citizenship: Language Spoken: Religion:
142 lbs Filipino English, Tagalog Roman Catholic
86
C O L L E G E
REFERENCE:
O F
Mrs. Jan Safran Chiong-Parrales Chiong-Parrales Our Lady of Fatima University Faculty +639105540465
C O M P U T E R
Dr. Marmelo V. Abante Our Lady of Fatima University Program Coordinator, CCS +63916891208 Mr. Alberto A. Amora United Laboratories Inc. DSS-MNSG +639297069227
I hereby testify that the above are true and correct to the best of my knowledge.
Chester I. Barry Proponent
S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
87
C O L L E G E O F
JOEMEL A. VALENZUELA VALENZUELA Address: B9L10 Marigman St. Golden Hills Antipolo City Mobile: +639154449213 E-mail Address: joemel_v joemel_valen alenzuel zuela@ya a@yahoo hoo.com .com OBJECTIVE:
As a documentator and programmer of this software project my knowle knowledg dge e and and techni technique ques s in doing doing progra programm mming ing has has furth furtherm ermor ore e increase as I will use for facing the real-life of my chosen career. PROFESSIONAL SKILLS: •
• •
• • •
•
Knowledgeable in Microsoft Office (Word, Excel, PowerPoint & Outlook). Skills in using Linux OS (CENTOS). Skills in Visual Basic 2008, Adobe Photoshop CS3 & CS4, Flash4, PHP and MySql. Skills in Computer Networking. Knowledgeable in using SAP Application. Reliable and adaptable, can easily cope up with pressures and changing situation. Willing and able to do wide variety of tasks.
EDUCATIONAL BACKGROUND:
C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
Tertiary Tertiary
Secondary
Primary
Our Lady of Fatima University Bachelor of Science in Information Technology Km. 23 Sumulong Highway, Antipolo City 2008-Present San Jose National High School
Circumferential Circumferential Rd. Brgy. San Jose Antipolo City 1999-2003 Lores Elementary School Bath St. Lores Country Homes Antipolo City 2001-1999
88
C O L L E G E O F
SEMINAR ATTENDED: •
•
•
•
•
•
•
Youth Youth Conferen Conference ce in IT: Think Think IT! Do Do It!, University of the Philippines Philippines Diliman, Quezon City (February 18, 2011). “Network Management”, Our Lady of Fatima University, Antipolo City (September 14, 2010). “Non Linear Video Editing”, Our Lady of Fatima University, Antipolo City (September 14, 2010). “Personality Development Seminar”, “Empowering mind through Information Technology”, Our Lady of Fatima University, Antipolo City (December 10, 2009). “Visual Basic .Net and Net Firmware” , “Empowering mind through Information Technology”, Our Lady of Fatima University, Antipolo City (December 9, 2009). “Robotics in Education”, “Empowering mind through Information Technology”, Technology”, Our Lady of Fatima University, Antipolo City (December 7, 2009). “Philippine Youth Congress in Information Technology 2009”, University of the Philippines Diliman, Quezon City (September 9, 2009).
TRAININGS: •
On-the-Job-Training “United Laboratories Inc.” Corporate Information Division
C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
Computer Technical Engineer June – Sept Sept 2011 2011 66 United Street Mandaluyong City. Computer Technician Computer Cloning Computer Format Computer Assemble Networking
“Summit Technologies Inc.” Administrator Administrator Staff 3/F Business Solution Center Meralco Compound, Ortigas Ave. Pasig City. May – June 2011 Updating Records of Employee Updating and checking the Update Summary. Concierge
89
C O L L E G E O F
ACCOMPLISHEMENT: •
•
•
•
•
Feasibility Study in Software Engineering Entitled – Sales and Inventory for Distor De Castro Optical -Using Visual Basic 2008 Express Edition. 3nd Year College Project Study in Database System Entitled – Point of Sale for Snow Patrol Store - Using PHP and MySql. , year 2010 Feasibility Study in System Analysis and Design Entitled – Student-Faculty Evaluation system for Our Lady of Fatima University -Using Visual Basic 2008 Express Edition. 2nd Year College Accomplished Accomplished Project Study in Management Management in Information System Entitled - Management in Information System for Eastern Telecom Telecommun municat ication ion when when I was in 2nd year level. Accomplished Accomplished Project Study in Logic Switching and Design Task Gathering data’s, conduct interviews and make technical report, Created databases and programs using Microsoft Access 2003, Created databases and programs using VB 2008 Express Edition, Created databases and programs using PHP and MySQL.
AFFILIATION:
C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
Member of Fatima Antipolo Computer Studies Society, In Our Lady of Fatima University – Antipolo Campus. SK Member - Antipolo City Sagip Undoy Gift Giving – Volunteer Agham Club 2002 SJNHS – Vice President / Member CAT Officer Offic er Platoon Leader SJNHS – 2002-2003 Class President 3rdyear High School
90
•
• • • • •
AWARDS:
Mr. Information Technology 2010 Mr. Popularity Award Our Lady of Fatima University – Antipolo Campus Top 10 of of the class th 4 year High School San Jose National High School Ginoong Agham 2003 3rd year High School PERSONAL INFORMATION: Date of Birth: Place of Birth: Gender: Civil Status: Height: Weight: Citizenship: Language Spoken: Religion:
REFERENCE:
Mrs. Jan Safran Chiong-Parrales Chiong-Parrales Our Lady of Fatima University Faculty +639105540465 Mr. Huhmn Park Music Professor / Missionaries +639275992220
January January 25, 25, 1987 1987 Antipolo, Rizal Male Single 5’10 155 lbs Filipino English, Tagalog Born Again Christian
C O L L E G E O F C O M P U T E R S T U D I E S
OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS
91
Ptr. Nestor Yape New Life Church Taytay +63907362823
I hereby testify that the above are true and correct to the best of my knowledge.
Joemel Joemel A. Valen Valenzuel zuela a Proponent
C O L L E G E O F C O M P U T E R S T U D I E S