Table of contents of PAYROLL SYS

OUR LADY OF FATIMA UNIVERSITY – ANTIPOLO CAMPUS

iii

ACKNOWLEDGEMENT This Software Software Project Project would would not have been possible possible without without the guidance and the help of several individuals who in one way or another contributed and extended their valuable assistance in the preparation and completion of this study. First and foremost, we are grateful for God, the merciful and the passionate, for providing us the opportunity to step in the excellent world of technology. We owe owe our our deep deepes estt appr apprec eciat iatio ion n to Mrs. Mrs. Jan Safr Safran an Chio Chiong ng-Parrales Parrales Software Software Project Project adviser, adviser, whose sincerity, sincerity, perseveran perseverance ce and enco encour urag agem emen entt we will ill neve neverr forg forget et.. We are are also also grat gratef eful ul to Dr. Dr. Marmelo V. Abante- Program Coordinator College of Computer Studies, Dr. Cayeta Cayetano no A. Nicola Nicolas-Te s-Techn chnica icall Advise Adviser, r, Ms. Jemely Jemelyn n V. Lomabas Lomabas Finan Finance ce Offic Officer er of Blanc Blanco o Famil Family y Ac Acade ademy my for for makin making g the the sy syste stem m significant. Most importantly, none of this would have been possible without the love and patience of our family and friends. Our immediate family, to whom this Software Project is dedicated, has been a constant source of love, concern, support and strength all these years. We would like to express our heart-felt gratitude to our family. Our extended family has

C O L L E G E O F C O M P U T E R S T U D I E S


iv

aided and encouraged us throughout this endeavor. Thank you all. God Bless You.

DEDICATION This piece piece of hard word is is lovingly lovingly dedicate dedicated d to our our family family that that gives gives endless love and support.

Thank you you for all the encouragem encouragement ent and trust you you had given, given, now we finally find the joy and the fulfillment.

To our friends, friends, this is is for all all of you you who stands by by us upon upon all the obstacles and struggles along our way.

C.I.B J.A.V



ABSTRACT Title: LAN-BASED TIMEKEEPING AND PAYROLL SYSTEM USING BIOMETRICS FOR BLANCO FAMILY ACADEMY Name:

CHESTER I. BARRY JOEMEL JOEMEL A. VALENZU VALENZUELA ELA

Course:

BACHELOR OF SCIENCE IN INFORMATION TECHNOLOG TECHNOLOGY Y

School:

OUR LADY OF FATIMA UNIVERSITY - ANTIPOLO

School Year:

2011-2012

Adviser:

DR. CAYETANO A. NICOLAS

In requirements as a graduating student the proponents create this this Thesis Thesis entitl entitled ed LAN-Ba LAN-Based sed Time Time keepin keeping g and Payrol Payrolll for Blanco Blanco Famil Family y Ac Acade ademy my.. This This sy syste stem m is hassl hassle e free free in reco record rdin ing g the the time time keep keeping ing reco record rd of the the emplo employe yees es by us usin ing g Biom Biomet etric rics s that that rely rely to automated and computerizes Payroll. The proponents’ proponents’ interest interest to conduct conduct an investigation investigation has led them to understand the payroll system of Blanco Family Academy present problems such as what are the common problems encountered by the acco accoun untin ting g staff staff of Blanc Blanco o Fami Family ly Ac Acade ademy my in term terms s of us usin ing g their their

v



vi

manual system in processing payroll and time keeping how it will help the accounting staff in terms of the generating payroll transaction, easy

Way Way

tim timekee ekeepi ping ng

usin us ing g

biom biomet etri rics cs,,

secu secure re

all all

pay payroll roll

reco record rds, s,

calculating and generate generate all payroll reports. The study deals deals with a proposal proposal for a LAN-Based LAN-Based Timekeeping Timekeeping and Payroll using Biometric for Blanco Family Academy. The objective of the study was aimed to help the Blanco Family Academy to have an efficient and effective way of Employees Time Keeping and Payroll System using biometrics to give a higher quality of service and to: 1.) Develop a system that will improve the Blanco Family Academy’s operation in the Timekeeping and Payroll. 2.) 2.) To deve develo lop p a sy syst stem em that that will will monit monitor or emplo employe yee’ e’s s data data that that is efficient to use. 3.) To use biometrics tool (Fingerprint scanner) that will provide an easy log-in and log-out of the employees and staff. 4.) Secure the records of employees and to have more manageable files. 5.) 5.) Easy Easy Calc Calcul ulati ation on of Payr Payrol olll Tran Transa sact ctio ion n and Summ Summar ariz ize e all all the the Deducted Contribution of Employees.



FINDINGS

vii

C O L L E G E

Acco Ac cord rdin ing g to the the resu result lts, s, the the orga organi niza zati tion on mus ustt adop adoptt the the deve develo lope ped d sy syst stem em beca becaus use e it will will be a gre great help help for for the the Scho School ol especially to the personnel who manage the employee transaction when it comes into the payroll processes because of its module timekeeping usin us ing g a biom biomet etri rics cs for for thei theirr tim time logs logs and and payr payrol olll sy syst stem em for for the the computations of employee’s salary.

O F C O M P U T E R S T U D I E S


TABLE OF CONTENTS Page

viii

C O L L E G E

TITLE PAGE PAGE............................................................................................ ...............................................................................................i ...i APPROVA APPROVAL L SHEET................................................................................ SHEET........................................................................ ............ii ....ii ACKNOWLEDGEMENT.............................................................................iii DEDICATION...........................................................................................iv ABSTRACT...............................................................................................v TABLE OF CONTENT CONTENTS............................................................................ S.............................................................................vii .vii LIST OF TABLES.......................................................................................x LIST OF FIGURES FIGURES ...................................................................................xii CHAPTER 1: INTRODUCTION

O F C O M P U T E R

Background of the Study.........................................................1 Rationale.................................................................................3 Statemen Statementt of the Problem Problem................................................... ........................................................3 .....3 Hypothesi Hypothesis s of the Study......................................................... Study...........................................................4 ..4 Objective Objectives s of the Study............................................................5 Study............................................................5 Theoretic Theoretical al Assumpti Assumptions ons of the the Study......................................5 Study......................................5 Scope and Delimitatio Delimitation.......................................................... n............................................................7 ..7 Information Information Technology Technology Innovation..........................................8 Innovation..........................................8 Significanc Significance e of the Study.................................................... Study............................................ .............9 .....9 CHAPTER 2: REVIEW OF RELATED LITERATURE AND STUDIES Conceptual Conceptual Framewo Framework............................................... rk....................................................... ...........11 ...11 Related Related Literature Literature............................................................. ..................................................................12 .....12

S T U D I E S


ix

Related Related Studies......................................................................16 Studies......................................................................16 Relevance of the Reviewed Related Literature and Studies to the present studies....................................................... studies............................................................19 .....19 Operationa Operationall Definition Definition of Terms............................. Terms..................................... ................19 ........19

CHAPTER 3: METHODS OF RESEARCH AND SYSTEM DESIGN Methods Methods of Research Research Used.....................................................24 Data Gathering Gathering Instrument Instrument..................................... ............................................. ...............26 .......26 Statistical Statistical Tool........................................................ Tool................................................................. ...............28 ......28

C O L L E G E O F

Analytical Analytical Tools......................................................................31 Tools......................................................................31 Process Process used in Developing Developing the Software.............. Software...................... ............ ........34 ....34 Analysis Analysis used for Product Evaluation Evaluation............. ..................... ................. ................39 .......39

CHAPTER 4: 4: ANALYSIS, PRESENTATION PRESENTATION OF DATA, DATA, AND INTERPRETATION OF FINDINGS Survey...................................................................................54 User Testing Results from the Existing System......................61 User Testing Results from the Survey Questionnaires............62 User Testing Results from the Proposed System....................64 System System Testing......................................................................65 Testing............................................................... .......65 Results of Software Evaluation in One way Anova..................66

CHAPTER 5: SUMMARY, CONCLUSIONS AND RECOMMENDATIONS Summary...............................................................................68 Conclusions...........................................................................72 Recommendations.................................................................73 APPENDICES.........................................................................................xiv

C O M P U T E R S T U D I E S


x

BIBLIOGRAP BIBLIOGRAPHY.......................................................................................xv HY.......................................................................................xv CURRICULU CURRICULUM M VITAE................................................................. VITAE......................................................................... .............xvi .....xvi

LIST OF TABLES Table Page

O F

1.

Surv Survey ey Crit Criter eria ia... ...... ...... ...... ...... ....... ....... ...... ...... ...... ...... ...... ...... ...... ...... ....... ....... ...... ...... ...... ....... ......... .......... .......... .......... .....29 29

2.

User User Testi Testing ng Crite Criteri ria. a.... ...... ...... ....... ....... ...... ...... ...... ...... ...... ...... ...... ...... ........ .......... .......... .......... .......... .......... .......... ......2 .29 9

3.

Syst System em Test Testing ing Crit Criter eria ia... ...... ...... ....... ....... ...... ...... ...... ...... ...... ...... ...... ...... ....... ....... ...... ...... ...... ....... ......... .......... ........ ...30 30

4.

Hard Hardwa ware re Requ Requir irem emen ents ts... ...... ....... ....... ...... ...... ...... ...... ...... ...... ....... ......... .......... .......... .......... .......... .......... .......... ......3 .39 9

5.

Softw Softwar are e Requ Requir irem emen ents ts... ...... ...... ....... ....... ...... ...... ...... ...... ...... ...... ...... ...... ....... ....... ...... ...... ...... ...... ....... ......... .......... .....40 40

6.

Dist Distri ribu buti tion on of of Resp Respon onde dent nts s in Term Terms s of of Gende Gender. r.... ........ .......... .......... .......... .......... .......... ......5 .54 4

7.

Dist Distri ribu buti tion on of Resp Respon onde dent nts s in in Term Terms s of of Age Age..... .......... .......... ......... ......... ............ ........55 .55

8.

Dist Distri ribu buti tion on of Resp Respon onde dent nts s in Term Terms s of of Sat Satis isfa fact ctio ion n using a Bundy Clock...................................................................56

9.

Dist Distri ribu buti tion on of Resp Respon onde dent nts s in in Ter Term ms of of Upg Upgra radi ding ng in Computerized.........................................................................57

10.. 10

Dist Distri ribu buti tion on of of Resp Respon onde dent nts s in Term Terms s of Biom Biomet etric rics s is accurate than usual Timecard....................................... Timecard............................................... ..........58 ..58

11.. 11

Distrib Distributi ution on of of Respo Responde ndents nts in Term Terms s of lessen lessen the Fraud. Fraud............. ....................59 ........59

12.. 12

Dist Distri ribu buti tion on of of Resp Respon onde dent nts s in Term Terms s of Opti Optimi mizi zing ng the process process in computing computing wages wages and timekeepi timekeeping........ ng............. ......... ........60 ....60

13.. 13

Resu Result lts s of of Sof Softw twar are e Eva Evalu luat atio ion n Acc Accor ordi ding ng to Respondent’s Category of Existing System................ System.......... .......... ........ ........ ....61 61

14.. 14

C O L L E G E

Resu Result lts s of of Sof Softw twar are e Eva Evalu luat atio ion n Acc Accor ordi ding ng

C O M P U T E R S T U D I E S


xi

to Respondent’s Respondent’s Category Category of Prototype Prototype system........ system................ ............... ..........62 ...62 15.. 15

Resu Result lts s of of Sof Softw twar are e Eva Evalu luat atio ion n Acc Accor ordi ding ng to Respondent’s Category of Proposed System...........................64

16.. 16

Perc Percen enta tage ge of of the the Syst System em Effic Efficie ienc ncy y Eval Evaluat uated ed by the System System Testing Testing Result................................ Result......................................... ................. .............65 .....65

17.

Result Result of of Softwar Software e Evalu Evaluatio ation n compute computed d in One One way way ANOVA ANOVA...... ............ ...........6 .....66 6

18.. 18

Resu Result lt of Softw Software are Eva Evalu luat atio ion: n: Exist Existing ing,, Proto Prototy type pe and Proposed Proposed System System ............................................................ .................................................... .............67 .....67

19.. 19

Correc Correctne tness ss Evalua Evaluatio tion n of Exis Existin ting g System System ............. ................... ............ ............ ................1 ..........127 27

20.. 20

Reliab Reliabili ility ty Eval Evaluat uation ion of Exis Existin ting g Syste System m ....... ............. ............. ................. ........................1 ..............127 27

21.. 21

Efficie Efficiency ncy Evalua Evaluatio tion n of of Exis Existin ting g Syst System em ............ ................................ ................................1 ............128 28

22.. 22

Testab Testabilit ility y Eval Evaluat uation ion of Exis Existin ting g Syste System m ....... ............. ................. ..............................1 ...................128 28

23.. 23

Portab Portabilit ility y Evalu Evaluatio ation n of Existi Existing ng Syste System m .......... ................ ............ ............ ............ ............. ..........1 ...129 29

24.. 24

Correc Correctne tness ss E Eval valuat uation ion of Prot Prototy otype pe Syst System em ............ .................. ....................... ....................12 ...129 9

25.. 25

Reliab Reliabili ility ty Eval Evaluat uation ion of Prot Prototy otype pe System System...... ............ ..................... ..............................1 ...............130 30

26.. 26

Efficie Efficiency ncy Evalua Evaluatio tion n of Protot Prototype ype System System.............. ..................................... ............................13 .....130 0

27.. 27

Testab Testabilit ility yE Eval valuat uation ion of Protot Prototype ype Syste System... m......... .............................. ................................1 ........131 31

28.. 28

Portab Portabilit ility y Evalu Evaluatio ation n of Proto Prototyp type e Syste System.. m........ ............. ............. ............ ............ ...............1 .........131 31

29.. 29

Correc Correctne tness ss Evalua Evaluatio tion n of Propo Proposed sed Syst System em....... ............. ............ ............ ............ ...............1 .........132 32

30.. 30

Reliab Reliabili ility ty Eval Evaluat uation ion of Prop Propose osed d Syste System.. m........ ............ ............ ............. ....................... ................13 132 2

31.. 31

Efficie Efficiency ncy Evalua Evaluatio tion n of of Prop Propose osed d Syst System em...... ............ .................. ...............................1 ...................133 33

32.. 32

Testab Testabilit ility y Eval Evaluat uation ion of Prop Propose osed d Syste System.. m......... ............. ............ ........................... .....................13 133 3

33.. 33

Portab Portabilit ility y Evalua Evaluatio tion n of Propose Proposed d System System...... .......................... ....................................1 ................134 34

34.. 34

One way way Anova. Anova........ ............. ............ ............ ............ ............. ............. ............ ............ .................. ..........................1 ..............134 34



LIST OF FIGURES Figure Page 1.

Netwo Network rk Diagra Diagram.. m........ ............ ............ ............. ............. ............ ............ ............ ............. .............. .......................... ...................6 6

2.

Input Input Proce Process ss Output Output...... ............ ............ ............. ............. ............ ............ ............ ............. ............. ............ ............... .........12 12

3.

Agile Agi le unif unified ied Proce Process ss Li Life fe Cycl Cycle... e......... ............ ............ ............ ............. ...................... ...........................3 ............35 5

4.

Contex Contextt Diag Diagram ram....... ............. ............ ............ ............ ............. ............. ............ ............ ............ ............. ..................... ..............76 76

5.

Data Data Flow Flow Diagr Diagram am ....... ............. ............ ............. ............. ............ ............ ............ ............. ............. ............ ............ ..........7 ....77 7

6.

System System Flow Flowcha chart.. rt........ ............ ............ ............ ............. ............. ............ ............ ............ ............. ............. ............ ............7 ......78 8

7.

Hierar Hierarchi chical cal Input Input Proc Process ess Output Output...... ............ ............ ............. ............. ........................... ..........................79 .....79

8.

Visual Vis ual Tabl Table e of Cont Content ents.... s.......... ............. ............. ............ ............ ............ ............. ............. ............ ............ ............8 ......83 3

9.

Entity Entity Relatio Relation n Diagra Diagram m ............ .................. ............ ............. ............. ............. .............................. ...........................88 ....88

10.. Main 10 Main Form.. Form......... ............. ............ ............ ............ ............. ............. ............ ............ ............ ............. ...................... ....................1 .....135 35 11. Form Manual Login.......................................................................... Login..............................................................................136 ....136 12.. Form 12 Form Manual Manual...... ............ ............. ............. ............ ............ ............ ............. ............. ............ ......................... .........................1 ......137 37 13.. Login 13 Login Form. Form........ ............. ............ ............ ............ ............. ............. ............ ............ ............ ............. ...................... ....................1 .....138 38 14. Form Manageme Management................................................................... nt............................................................................ ...........139 ..139 15. Employee Employee Managemen Managementt Form............................................................. Form..............................................................140 .140 16.. Form 16 Form Sched Schedule ule...... ............. ............. ............ ............ ............ ............. ............. ............ .................... ............................1 ..............141 41 17. Salary Form....................................................................................... Form.........................................................................................142 ..142 18. Finger Finger Print Registrati Registration.....................................................................143 on.....................................................................143 19. Payroll Payroll Transactio Transaction n Form................................................................. Form.....................................................................144 ....144 20.. Loan Form.. 20 Form........ ............ ............ ............ ............. ............. ............ ............ ............ ............. ............. ............ ..................... ...............14 145 5

xii



xiii

21. Holiday Holiday Form.................................................................................. Form.......................................................................................146 .....146 22.. Leave 22 Leave Form.. Form........ ............ ............ ............. ............. ............ ............ ............ ............. ............. ..................... .........................1 ..........147 47 23.. Form 23 Form Repor Reports. ts........ ............. ............ ............ ............ ............. ............. ............ ...................... ................................... ...................14 148 8 24. Form Access Access Controls...................................................................... Controls..........................................................................149 ....149

APPENDICES Appendix

Page

A.

Transcr Transcript ipt of the the Intervi Interview ew....... ............. ............ ............ ............ ............. ................... .............................. ..................74 74

B.

Contex Contextt Diagra Diagram m ......... ............... ............ ............ ............ ............. ............. ............ ............ ............ ................ ..................7 ........76 6

C.

Data Data Flow Diagr Diagram am...... ............ ............ ............. ............. ............ ............ ............ ............. ............. ............ ............ ............ ......77 77

D.

System System Flowc Flowchar hartt ............ .................. ............. ............. ............ ............ ............ ............. ............. ............ ............ ............7 ......78 8

E.

Hierar Hierarchi chical cal Input Input Proc Process ess Output Output ............. ................... ............ .............. ............................... .......................79 79

F.

Visual Vis ual Table Table of of Conte Contents nts...... ............ ............. ............. ............ ............ ............ ............. ............. ............ ............ ..........8 ....83 3

G.

Entity Entity Relatio Relation n Diagr Diagram am ....... ............. ............ ............ ............. ............. ................ ................................. .......................88 88

H.

Econom Economic ic Feasib Feasibilit ility... y......... ............ ............ ............. ............. ............ ............ ............ ............. ............. ............ .............8 .......89 9

I.

Surve Survey y Form.. Form........ ............ ............ ............. ............. ............ ............ ............ ............. ............. ............ ............ ............ ............1 ......100 00

J.

User Testin Testing g Form.................................................................... Form............................................................................ ...........102 ...102

K.

System System Testin Testing g Form. Form....... ............. ............. ............ ............ ............ ............................. ....................................1 .............104 04

L.

Existi Existing ng Syste System.. m........ ............ ............. ............. ............ ............ ............ ............. ............. ............ ............ ............ ............. .......11 114 4

M.

Thesis Thesis Prop Proposal osal...... ............ ............. ............. ............ ............ ............ ............. ................ ................................ .......................11 115 5

N.

Advise Adviserr Ac Accep ceptanc tance e Form Form ............ .................. ............ ............. ............. ............ ............ ............ .................1 ...........117 17

O.

Company Company Ac Accep ceptanc tance e Lette Letterr .......... ................. ............. ............ ......................... .................................1 ..............118 18

P.

Propon Proponent ents s Monito Monitorin ring g Sheet Sheet ............. ................... ............ ................... ................................... ......................11 119 9

Q.

Grade Grade Sheet... Sheet......... ............. ............. ............ ............ ............ ............. ............. ............ ............ ............ ....................... .................12 121 1

R.

Form Form 21: 21: Endorse Endorseme ment nt to the the Englis English h Depart Departme ment. nt....... ............. ............. ................1 ..........126 26

S.

Result Result of SPSS SPSS Statist Statistica icall Treatm Treatment ent ............ ................................ ....................................1 ................127 27

T.

User Manual Manual ....................................................................... ............................................................................... ................135 ........135



xiv

C O L L E G E O F C O M P U T E R

APPENDICES

S T U D I E S


xv


BIBLIOGRAPHY

S T U D I E S


xvi


CURRICULUM VITAE

S T U D I E S

Table of contents of PAYROLL SYS

Recommend Documents