Computerized Library System 3i3h2k

Chapter 1 THE PROBLEM AND ITS BACKGROUND

Introduction

Now, in our society all over the world technology is the most important advancement, a necessity in bringing about progress as we move along in this computerized world. These changes in effect make man’s life easier and more convenient. The relationship between the library and computer is constantly changing that the use of computer contributes to the way man learns and communicates. It easy in this world to strive for changes and since library is no different from any firm and institution, considering the use of computer to perform a given task will be efficient. Librarians have the responsibility not only to know about the ways in which libraries will be managed using techniques of computerized, but also to be aware of the changes that computerized can bring to the library services in the near future.(Grace, 2011)

Traditionally, library systems are implemented manually. Forms are given to Librarian and they fill them of using pens. Afterwards, the school s process them manually and complied on large bulky file cabinet. Indeed, the manual Library system is very costly, time consuming and tedious. The primary complaint of school 1

s with this system is the tiresome task of searching through records just to your query data. The fast phased of technology attributed a lot to the improvement of the library system. Technology enabled software developers to computerize the library system. The automated library system helped the academe greatly. Library, transactions and queries can be created in a single click.

Background of the Study

A college strengthens its educational level through the advancement of its library. The Botolan Community College Computerized Library System aimed to enhance the procedures of the library, from manually operated to a computerized system. This proposal’s purpose was to ease the transactions in the library, i.e., lending of books, storing of books, search engine for books, manage of the library and secure the library system. The librarian and the library s still use the manual way of transacting of borrowing and returning of books. The librarian use log books in listing the books. They use library cards and card catalogues in searching for reading and reference materials.

Objectives of the Study General Objective The objective of the study was to develop a computerized library system that will store the student’s records such as student’s basic information, books record, list of borrowers, returned books, borrowed books, and prescriptions of the librarian. 2

Specific Objectives To be specific, it attempted to satisfy the following objectives: a) To design a system that will lessen the time and effort of the student in their transaction b) To quickly search the book needed by the student of the library c) To print out reports immediately d) To implement the system efficiency to the student

Scope and Limitations of the Study The study was about the Computerized Library System for the Botolan Community College. The implementation of the system will reduce the time and effort of the s in of adding, editing, searching, deleting and printing of records. The system can also help in reducing the expenses of the library such as papers, folders, pens and other materials needed in their current system. The system is LAN-based that enables the librarian to share the records of the student such as the borrowing books, returning books, search books, and prescriptions of the librarian. The student’s personal information/data may be stored upon the request of authorized librarian. The assigned librarians are the only one who can share any of the records/data of the students. The system is not capable of sharing its data from other databases. The system will be developed using the Microsoft Visual Basic 6.0.

3

Significance of the Study The significance of this study was to help and give a benefit to the concerned group below. This study will be beneficial to the following: BCC Students. Through a computerized library system, they can easily find the books that they are looking for without going through the traditional way of searching a library material. Convenience is more visible for it is not time-consuming, resulting to a number of accomplished works. Librarian. The computerized library system would improve the monitoring capacities of those who maintain the library. It would be easier to determine whether a particular book is on-shelf or not. In addition, they can easily identify when will the borrowed material be returned and if a borrower has failed to return the book on its due date. Furthermore, the librarian would be much guided when it comes to recognizing new inventory books, letting them arrange it promptly and accordingly.

Conceptual Model of the Study A Computerized Library System identifies the modern process of technology, on how it works quickly for the students/librarian. Based on the objectives of the study and aforementioned theories and concepts derived from the review of related literature and studies, the following conceptual model of study was developed

4

INPUT



Knowledge Requirements



s’ Needs

PROCESS



Data gathering



Procedure



Survey



Existing Applications





Questionnaires

Development Tools and Techniques



Interviews



Technical Literature



Statistical tools



Results of s Survey



Frequency





Mean

Expert Advice



 .

Weighted mean

Software



Requirements



Hardware Requirements

OUTPUT

Botolan Community College Computerized Library System

Evaluation and Performance Test (ISO/IEC 9126)

Figure 1. Conceptual Model of Study

The conceptual model of study is best illustrated on the paradigm of the input box; it deals on knowledge requirements, s Needs, Existing Applications, Development Tools and Techniques, Technical Literature, Results of s survey, expert advice, software, requirements, hardware requirements. It deals on the perceptions towards the existing manual system and the proposed Computerized Library System as to accuracy, friendliness, security and speed of data and information.

5

On the process box, it deals on the process of gathering data using questionnaires and unstructured interviews, the different statistical tools as mean, frequency, percentage, analysis of variance in order to test the significant difference on the formulated hypothesis. On the output frame, it deals on the final objective of the study which is the development of the proposed Library System for the Botolan Community College in Botolan, Zambales.

Definition of Computerized. To equips with or automates by computers. Computerized Library system. A computerized library system for a university keeps track of all books and periodicals in the library and their check-out status. Checkout and return are automated through a bar code reader (an external device). The library system also interfaces with an external relational database which stores information about the library s (students, faculty, and staff), including whether they have any library items checked out. . Library s can access the catalog and recall books and periodicals. Library employees have the same access as well as additional capabilities (e.g., listing the status of an item). Data. Factual information or information for computer processing, distinct pieces of information usually formatted in a special way. All software is divided into two general categories: data and programs. Programs are collections of instructions for manipulating data. Data can exist in a variety of forms -- as numbers or text on pieces of paper, as bits and by test stored in electronic memory, or as facts stored in a person's mind. 6

Database. A set of data that has a regular structure and that is organized in such a way that a computer can easily find the desired information. . LAN(Local Area Network). This serves a local area (typically the area of a floor of a building, but in some cases spanning a distance of several kilometers). Records. Data, details, documents, file, information, or reports. In the structure of a database, the part consisting of several uniquely named components called data fields. Several data records make up a data file, and several data files make up a database. Share. Distributing or giving files, or a resource such as a file, folder or printer, that has been made sharable with other s on the network.

7

Chapter 2 REVIEW OF RELATED LITERATURE

Related Literature Foreign According to Robson (2001), usability is a key requirement for s, says Elisabeth Robson, Product manager for Online Computer Library Center. The catalogue has become a way to pull together disparate resources, including commercial resources and web links. management systems also allow circulation, including check in/check out and enable libraries to purchase materials and track where they are. According to Chad (2009), consulting is at a major point of change in the wider information economy within which library systems form part of a larger whole. He was writing in a briefing paper about the study in library management systems. This study examined the systems used in higher-education libraries across the UK and came up with some significant observations and recommendations. It noted that the LMS market in UK higher education is already mature and that four main vendors (ExLibris, Innovative, SirsiDynix and Talis) have almost 90 per cent of the market. This market maturity means, according to the study authors, that the benefits to libraries of changing LMS provider are limited. 8

Library s expect to find everything together says Stephen Abram, vice president for innovation at SirsiDynix, the leading provider of software solutions and associated services for libraries. According to her traditionally, the library management system or integrated library system (ILS) was responsible for running libraries efficiently and effectively. Over the last few years, the role of the ILS has been expanding from meeting library needs to delivering experience.

Local According to Eden (2011), views that most libraries are forced to work with fewer staff because of the having a more improved and modernized system for their library. According also to the study, the library istration need to emphasize to their staff that the organization has a vested interest in providing them with the tools and training they need to assist the organization in the new information marketplace. These may include search engines, circulation systems, and the online public access catalog. According to Lopez (2002), University of the Philippines Mindanao when UP in Mindanao accepted its first batch of students in 1996, the Main Library collection was integrated with the core collection of the School of Management (SOM) Library at the Stanfilco Bldg., Ladislawa Avenue, Buhangin, Davao City. The Filipiniana and General References were housed together with the College of Arts and Sciences (CAS) collection in Room 2 of the Philippine Coconut Authority. In the Second Semester AY 1996-1997, the CAS Library moved to its main campus in Bago Oshiro. Upon the recognition of UP in Mindanao by the Board of Regents (BOR) as a constituent unit (CU) of the UP System, the CAS was split into two (2), namely: College of Humanities and Social

9

Sciences (CHSS) and the College of Science and Mathematics (CSM). The Main Library transferred to the newly renovated building where the main collection was set-up beside the books of the CHSS and the CSM. In July 2002, the library established the Library Educational Media and Information Technology Office (LEMITO). The LEMITO handles the audio-visual services, internet and the connectivity of the library. It currently holds office at the Elias B. Lopez Hall Dormitory. Later, the Main Library collection which grew from 100 titles to 6,191 volumes at the end of May 2004, and was transferred to the istration Bldg today, the Main Library occupies the former UP in Mindanao Cultural Center (UPMCC) building.

Related Studies Foreign According to Charuasia (2010), connotes the term library with use of automatic data processing machines to perform routine library activities. It implies a high degree of mechanization of various routine and repetitive tasks &operations and processes are left to be performed by human beings. The study stresses library automation as the application of computers and utilization of computer based products and services in the performance of different operations and functions or in the provision of various services and output products. In addition to computer advancement, telecommunication and audio-visual technologies gives away to new possibilities in information processing. According to Back & Bailey (2010), explored the design space of mash-up techniques for the faultless inclusion of information from Web services into websites. They considered the cases where an Online Public Access Catalog (OPAC) is either the

10

target of such addition or the basis of the information being included. They focused on client-side techniques in which each ’s browser s Web services directly because this approach lends itself to the creation of HTML widgets. The widgets allow the integration and customization of Web services without requiring programming. They also described in detail the functionality and use of several widget libraries and Web services we built. Although the specific requirements for (2010), explored the design space of mash-up techniques for the faultless inclusion of information from Web services into websites. They considered the cases where an Online Public Access Catalog (OPAC) is either the target of such addition or the basis of the information being included. They focused on client-side techniques in which each ’s browser s Web services directly because this approach lends itself to the creation of HTML widgets. The widgets allow the integration and customization of Web services without requiring programming. They also described in detail the functionality and use of several widget libraries and Web services we built. Although the specific requirements for 13each system differ because of their respective nature, all systems are designed to be deployable with minimum effort and resource requirements. This low entry cost, combined with the provision of a high-level, non-programming interface, constitute two vital precondition for the broad adoption of techniques in libraries, which in turn has the potential to vastly increase the reach and visibility of their electronic resources in the wider community.

Local According to Lou (1986), a survey on the computer application in 223 libraries in Metro Manila. The study revealed that they prioritize the three library functions to be

11

computerized as catag, indexing, and circulation. However, the plans for automation for the libraries cannot be implemented due to financial incapability of the libraries, and the lack of funds from the government. Despite of this drawback, the libraries are not turning their backs unto the automation of their libraries. According to Agena (2008) made a study about the collection usage of the students of the Jose Rizal University in a period of three years using the quantitative and qualitative approach. The goal of the study is to assess the usefulness of the faculty of students to their library and it been revealed that it is generally important for them to go to the library for their academic needs.

12

Chapter 3 RESEARCH METHODOLOGY

This chapter starts on the discussion about the project research design methodology. The second part presents the development of the system. The third part tells the operation, process and testing. The last parts discuss the evaluation procedure.

Project Development The Systems Development Life Cycle (SDLC) is a conceptual model used in project management that describes the stages involved in an information system development project from an initial feasibility study through maintenance of the completed application. Various SDLC methodologies have been developed to guide the processes involved including the waterfall model (the original SDLC method), rapid application development (RAD), t application development (JAD), the fountain model and the spiral model. Mostly, several models are combined into some sort of hybrid methodology. Documentation is crucial regardless of the type of model chosen or devised for any application, and is usually done in parallel with the development process. Some methods work better for specific types of projects, but in the final analysis, the

13

most important factor for the success of a project may be how closely particular plan was followed.

Waterfall Model Planning Analysis

Deg

Software Developmen t Testing

Operation Maintenance

Figure 2.Waterfall Model

Project Design

Planning. In planning, the researchers conducted an interview to the client to gather some information about on how the librarian manage the books, borrowed books, returned books, all record of the student. It is observed that the librarian writes the

14

records manually of every students who borrowed or returned the Books. The student uses the form given by the librarian.

Analysis. Based on the proposed Computerized Library System is designed purely from the s' viewpoint without considering the constraints of hardware (such as computers). In addition, system structures required to achieve such designs are clarified.

After

checking requirement specifications included in the basic plan, the overview of the project is represented by the use of diagrams so that the processing and flows of data can be easily understood.

Deg. The software design specifically targeted to librarian of the researchers used a -friendly design to attract the to use the new automated system. Here the system was designed purely from the s' viewpoint without considering the constraints of hardware (such as computers). In addition, system structures required to achieve such designs are clarified.

After checking the requirement specifications included in the

planning, the overview of the system represented by the use of diagrams so that the processed of data can be easily understood. Based on the representations, the division into sub-systems and input/output deg was performed. The entire project was divided into a number of modules on a functional basis, and each module was further divided into smaller units. The deg of the code, such as the determination of a coding system, was conducted.

In addition, relationships between the data were

analyzed.

15

Software Development – Coding. In the development of the system, the researchers made used of Microsoft Visual Basic 6.0 for encoding source code of the system, in order to be accurate and fast acquisition of data/information. Testing. The researchers installed the new System. The researchers encountered problems while processing it for the first time but after several weeks the system has been successful and introduced it to the respondents. Operating. The researchers were responsible for conducting an operation test. The researchers conducted a test under the actual operation conditions, and verified that the system satisfies the required specifications. Because this test was intended to have a developed system accepted by the , it was called an approval test or an acceptance test. The researchers conducted an operation test by running a program on a machine being used for actual operations. Maintenance. The researchers conducted maintenance in software to correct faults, to maintain performance or other attributes. The researchers’ common perception of maintenance merely involves fixing detects. The researchers’ maintenance management system allows segment chiefs to plan maintenance work on fixed assets, such as equipment, machinery and property.

Analytical Tools The researchers presented the analytical tools used in the system which areIPO (Input-Process-Output), VTOC (Visual Table of Contents) and Context DIAGRAM. IPO (Input – Process – Output),Chart shows the processing activity for any given

module in the Visual Table of Contents.

16

VTOC (Visual Table of Contents).Chart shows a hierarchy in which level of detail increases from the top of the chart to the bottom, moving from general to specific. This is called Top–Down Development.

Context diagram. A context diagram shows the system boundaries, external entities that interact with the system, and the relevant information flows between these external entities and the system.

Respondents

In order to determine whether standard questionnaire does play an important role in conducting Computerized Library System survey, a total of 50 respondents were asked to participate. To achieve pertinent information, certain inclusion criteria were imposed. The participants qualified for sample selection must be the students and all the s who will be using the library. This qualification ensured that the participants understand the nature of personality questionnaire and its use for employment, making the survey items easy for them to accomplish. These respondents where ask on the problems they have encountered in visiting and using the library. And also there were ask to answer the questions given, based on their observation inside the library.

17

Table 1. Distribution of Respondents

Respondents

Frequency

Students

49

Instructor

0

Librarian

1

Total

50

Evaluation Procedure

Data Instrument. Based on the related literature and studies reviewed, the researcher uses a standard questionnaire to assess the performance of the program.

The

questionnaire will be distributed to the respondents. The evaluation instrument is based on the characteristics and sub-characteristics provided by ISO/IEC 9126. ISO/IEC 9126 suggests only five software metrics (Excellent, Very Good, Good, Fair and Poor).

Table 2. Numerical Scale Scale

Interpretation

4.51 to 5.00

Excellent

3.51 to 4.50

Very Good

2.51 to 3.50

Good

1.51 to 2.50

Fair

1.00 to 1.50

Poor

18

Statistical Treatment The data obtained from the respondents were tabulated systematically in order to obtain accurate information related to each element of the target population. Frequency Distribution. The arrangement of the values that one or more variables take in a sample. Each entry in the table contains the frequency or count of the occurrences of values within a particular group or interval, and in this way, the table summarizes the distribution of values in the sample. Percentage Distribution. Display of data that shows the percentage of items that falls above or below certain values. To calculate the percentage distribution, divide the class frequency by the total number of items grouped and multiply by 100. Arithmetic Weighted Mean. These were utilized to determine the weight of the individual option as to levels of efficiency of both existing procedures and the proposed automated system in of Security of data and information, Speed of processing, Accuracy of data and Information, Friendliness and the alleviation of procedures in accomplishing tasks. ISO/IEC 9126 Data Instrument. Product quality is an international standard for the evaluation of software quality. The fundamental objective of this standard is to address some of the well known human biases that can adversely affect the delivery and perception of a software development project. These biases include changing priorities after the start of a project or not having any clear definitions of "success". By clarifying, then agreeing on the project priorities and subsequently converting abstract priorities (compliance) to measurable values (output data can be validated against schema X with

19

zero intervention), ISO/IEC 9126 tries to develop a common understanding of the project's objectives and goals. Economic Feasibility. For any system if the expected benefits equal or exceed the expected costs, the system can be judged to be economically feasible. In economic feasibility, cost benefit analysis is done in which expected costs and benefits are evaluated. Economic analysis is used for evaluating the effectiveness of the proposed system. In economic feasibility, the most important is cost-benefit analysis. As the name suggests, it is an analysis of the costs to be incurred in the system and benefits derivable out of the system. Cost-Benefit Analysis (CBA) estimates and totals up the equivalent money value of the benefits and costs to the community of projects to establish whether they are worthwhile.

20

Chapter 4 PRESENTATION OF DATA, INTERPRETATION OF RESULTS AND SOFTWARE PRODUCT ANALYSIS

This chapter presents the data gathering of the study, interpretation of the results from the conducted survey and the software product analysis.

Table 3 Evaluation of the Respondents towards the Proposed Botolan Community College Computerized Library System in of Functionality A. In of Functionality Level Efficiency

1.Functions required for the system are implemented (suitability) 2.Functional accuracy is provided (accurateness) 3. Function meet specification (compliance)

E

VG

G

F

P

(5) 21

(4) 29

(3) 0

(2) 0

(1) 0

(105) 17

(116) 26

(0) 7

(0) 0

(0) 0

(85) 15

(104) 23

(21) 12

(0) 0

(0) 0

(75)

(92)

(36)

(0)

(0)

AWM

QI

4.42

E

4.2

E

4.06

E

21

4. Ease of connecting with other systems is provided (interoperability) 5. Substantial security is provided (security)

22

24

4

0

0

(110)

(96)

(12)

(0)

(0)

21

22

7

0

0

(105)

(88)

Overall Weighted Mean

(21)

(0)

4.36

E

4.28

E

4.27

E

(0)

Table 3 shows the evaluation of the respondents towards the proposed Botolan Community College Computerized Library System in of functionality. For indicator 1, “Functions required for the system are implemented (suitability).” there were twenty-one(21) who responded on Excellent (E); twenty-nine (29) Very Good (VG); nobody responded on Good (G); nobody responded on fair (F) and Poor (P). Indicator 1 in of functionality obtained a weighted mean value of 4.42 and interpreted as Excellent (E). For indicator 2, “Functions required for the system are implemented (accurateness).” there were seventeen (17) who responded on Excellent (E); twenty-six (26) for Very Good (VG); seven (7) for Good (G); nobody responded on fair (F) and Poor (P). Indicator 2 in of functionality obtained a weighted mean value of 4.2 and interpreted as Excellent (E). For indicator 3, “Functions required for the system are implemented (compliance).” there were fifteen (15) who responded on Excellent (E); twenty-three (23) for Very Good (VG); twelve (12) for Good (G); nobody responded on fair (F) and Poor (P), respectively. Indicator 3 in of functionality obtained a weighted mean value of 4.06 and interpreted as Excellent (E). 22

For indicator 4, “Functions required for the system are implemented (interoperability).” there were twenty- two (22) who responded on Excellent (E); twentyfour (24) for Very Good (VG); four (4) for Good (G); nobody responded on fair (F) and Poor (P). Indicator 4 in of functionality obtained a weighted mean value of 4.36 and interpreted as Excellent (E). For indicator 5, “Functions required for the system are implemented (security).” there were twenty-one (21) who responded on Excellent (E); twenty-two (22) for Very Good (VG); seven (7) for Good (G); nobody responded on fair (F) and Poor (P), respectively. Indicator 5 in of functionality obtained a weighted mean value of 4.28 and interpreted as Excellent (E). The overall computed weighted mean for Botolan Community College Computerized Library System in of functionality. Obtained 4.27 and interpreted as Excellent (E). Table 4 Evaluation of the Respondents towards the Proposed Botolan Community College Computerized Library System in of Reliability B. In of Reliability Level Efficiency

1.Software includes no bug: (maturity) 2.A certain system level is maintained even when a trouble (fault tolerance)

E

VG

G

F

P

(5) 19

(4) 25

(3) 6

(2) 0

(1) 0

(95) 16

(100) 23

(18) 11

(0) 0

(0) 0

(80)

(92)

(33)

(0)

(0)

AWM

QI

4.26

E

4.1

E

23

3. normal operations are restored readily, when troubles occurs (recoverability)

21

22

7

0

0

(105)

(88)

(21)

(0)

(0)

Overall Weighted Mean

4.28

E

4.21

E

Table 4 shows the evaluation of the respondents towards the proposed Botolan Community College Computerized Library System in of Reliability For indicator 1, “Reliance required for the system are implemented (maturity).” there were nineteen (19) who responded on Excellent (E); twenty-five (25) Very Good (VG); six (6) for Good (G); nobody responded on fair (F) and Poor (P). Indicator 1 in of reliability obtained a weighted mean value of 4.26 and interpreted as Excellent (E). For indicator 2, “Reliance required for the system are implemented (fault tolerance).” there were sixteen (16) who responded on Excellent (E); twenty-three (23) for Very Good (VG); eleven (11) for Good (G); nobody responded on fair (F) and Poor (P). Indicator 2 in of reliability obtained a weighted mean value of 4.1 and interpreted as Excellent (E). For indicator 3, “Reliance required for

the system

is

implemented

(recoverability).” there were twenty-one (21) who responded on Excellent (E); twentytwo (22) for Very Good (VG); seven (7) for Good (G); nobody responded on fair (F) and Poor (P), respectively. Indicator 3 in of reliability obtained a weighted mean value of 4.28 and interpreted as Excellent (E).

24

The overall computed weighted mean for Botolan Community College Computerized Library System in of Reliability obtained 4.21 and interpreted as Excellent (E).

Table 5 Evaluation of the Respondents towards the Proposed Botolan Community College Computerized Library System in of Usability C. In of Usability Level Efficiency

1.Easy to operate: (understandability) 2.Easy to (learnability)

3. Allows easy operation management(operability)

E

VG

G

F

P

(5) 33

(4) 11

(3) 6

(2) 0

(1) 0

(165) 21

(44) 20

(18) 9

(0) 0

(0) 0

(105) 30

(80) 17

(18) 3

(0) 0

(0) 0

(150)

(68)

(9)

(0)

(0)

Overall Weighted Mean

AWM

QI

4.54

E

4.06

E

4.54

E

4.38

E

Table 5 shows the evaluation of the respondents towards the proposed Botolan Community College Computerized Library System in of Usability. For

indicator

1,

“Usage

required

for

the

system

is

implemented

understandability).” there were thirty-three (33) who responded on Excellent (E); eleven (11) Very Good (VG); 6 for Good (G); nobody responded on fair (F) and Poor (P).

25

Indicator 1 in of usability obtained a weighted mean value of 4.38 and interpreted as Excellent (E). For indicator 2, “Usage required for the system are implemented (learn ability).” there were twenty-one (21) who responded on Excellent (E); twenty (20) for Very Good (VG); nine (9) for Good (G); nobody responded on fair (F) and Poor (P). Indicator 2 in of usability obtained a weighted mean value of 4.06 and interpreted as Excellent (E). For indicator 3, “Usage required for the system is implemented (operability).” there were thirty (30) who responded on Excellent (E); seventeen (17) for Very Good (VG); three (3) for Good (G); nobody responded on fair (F) and Poor (P). Indicator 3 in of usability obtained a weighted mean value of 4.54 and interpreted as Excellent (E). The overall computed weighted mean for Botolan Community College Computerized Library System in of Usability obtained 4.38 and interpreted as Excellent (E).

Table 6 Evaluation of the Respondents towards the Proposed Botolan Community College Computerized Library System in of Efficiency D. In of Efficiency Level Efficiency E

VG

G

F

P

(5)

(4)

(3)

(2)

(1)

AWM

QI

26

1.Provides good responses and high throughput (time behavior) 2.Allows effective use of system resources (resource behavior)

20

30

0

0

0

(100 ) 22

(120)

(0)

(0)

(0)

20

8

0

0

(110 )

(80)

(24 )

(0)

(0)

Overall Weighted Mean

4.4

E

4.28

E

4.34

E

Table 6 shows the evaluation of the respondents towards the proposed Botolan Community College Computerized Library System in of Efficiency. For indicator 1, “Efficient required for the system are implemented (time behaviour).” there were twenty (20) who responded on Excellent (E); thirty (30) Very Good (VG); nobody responded on Good (G); nobody responded on fair (F) and Poor (P). Indicator 1 in of efficiency obtained a weighted mean value of 4.4 and interpreted as Very Good (VG). For indicator 2, “Efficient required for the system are implemented (resource behavior).” there were twenty-two (22) who responded on Excellent (E); twenty (20) for Very Good (VG); eight (8) for Good (G); nobody responded on fair (F) and Poor (P). Indicator 2 in of efficiency obtained a weighted mean value of 4.28 and interpreted as Excellent (E). The overall computed weighted mean for Botolan Community College Computerized Library System in of Efficiency obtained 4.34 and interpreted as Excellent (E).

27

Table 7 Evaluation of the Respondents towards the Proposed Botolan Community College Computerized Library System in of Maintainability E. In of Maintainability Level Efficiency E

VG

G

F

P

(5)

(4)

(3)

(1)

1.Allows easy analysis of design 19 documents and programs when a bug is found (analyzability) (95)

23

8

(2 ) 0

(92)

(24)

(0)

25

11

(0 ) 0

(100)

(33)

(0)

12

26

12

(0 ) 0

(60)

(104)

(36)

(0)

21

18

11

(0 ) 0

(10 5)

(72)

(33)

(0 )

(0)

2. Allows easy expansion and 14 modification of the system (70) (changeability) 3. Modification of the system does not affect others (stability)

4. Laborious tests are not required after a modification is made (testability)

Overall Weighted Mean

AWM

QI

4.22

E

4.06

E

4

VG

4.2

E

4.12

E

0

0

0

0

Table 7 shows the evaluation of the respondents towards the proposed Botolan Community College Computerized Library System in of Maintainability. For indicator 1, “Maintenance required for the system are implemented (analyzability).” there were nineteen (19) who responded on Excellent (E); twenty-three (23) Very Good (VG); eight (8) for Good (G); nobody responded on fair (F) and Poor

28

(P). Indicator 1 in of maintainability obtained a weighted mean value of 4.22 and interpreted as Excellent (E). For indicator 2, “Maintenance required for the system is implemented (changeability).” there were fourteen (14) who responded on Excellent (E); twenty-five (25) for Very Good (VG); eleven (11) for Good (G); nobody responded on fair (F) and Poor (P). Indicator 2 in of maintainability obtained a weighted mean value of 4.06 and interpreted as Excellent (E). For indicator 3, “Maintenance required for the system is implemented (stability).” there were twelve (12) who responded on Excellent (E); twenty-six (26) for Very Good (VG); twelve (12) for Good (G); nobody responded on fair (F) and Poor (P). Indicator 3 in of maintainability obtained a weighted mean value of 4 and interpreted as Very Good (VG). For indicator 4, “Maintenance required for the system is implemented (testability).” there were twelve (12) who responded on Excellent (E); eighteen (18) for Very Good (VG); eleven (11) for Good (G); nobody responded on fair (F) and Poor (P). Indicator 4 in of maintainability obtained a weighted mean value of 4.2 and interpreted as Excellent (E). The overall computed weighted mean for Botolan Community College Computerized Library System in of Maintainability obtained 4.12 and interpreted as Excellent (E).

29

Table 8 Evaluation of the Respondents towards the Proposed Botolan Community College Computerized Library System in of Portability F. In of Portability Level Efficiency

1.Provides flexible environment (adaptability)

E

VG

G

F

P

(5) 10

(4) 26

(3) 14

(2) 0

(1) 0

(50) 2. Providing easy installation (installability)

3. Complying with porting specification (conformance)

11

(0)

(0)

0

0

(55)

(60)

(72)

(0)

(0)

7

23

20

0

0

(35) 4. Allows easily replacement with other software (replaceability)

(104 (42) ) 15 24

18 (90)

(92)

(60)

(0)

(0)

17

15

0

0

(68)

(45)

(0)

AWM

QI

3.92

V G

3.74

V G

3.74

V G

4.06

E

(0)

Overall Weighted Mean

3.9

V G

Table 8 shows the evaluation of the respondents towards the proposed Botolan Community College Computerized Library System in of Portability. For indicator 1, “Portable required for the system are implemented (adaptability).” there were ten (10) who responded on Excellent (E); twenty-six (26) Very Good (VG);fourteen (14) for Good (G); nobody responded on fair (F) and Poor (P),

30

respectively. Indicator 1 in of portability obtained a weighted mean value of 3.92 and interpreted as Very Good (VG).

For indicator 2, “Portable required for the system is implemented (installability).” there were eleven (11) who responded on Excellent (E); fifteen (15) for Very Good (VG); twenty-four (24) for Good (G); nobody responded on fair (F) and Poor (P). Indicator 2 in of portability obtained a weighted mean value of 3.74 and interpreted as Very Good (VG). For indicator 3, “Portable required for the system is implemented (conformance).” there were seven (7) who responded on Excellent (E); twenty-three (23) for Very Good (VG); twenty (20) for Good (G); nobody responded on fair (F) and Poor (P). Indicator 3 in of portability obtained a weighted mean value of 3.74 and interpreted as Very Good (VG). For

indicator

4,

“Portable

required

for

the

system

is

implemented

(replaceability).” there were eighteen (18) who responded on Excellent (E); seventeen (17) for Very Good (VG); fifteen (15) for Good (G); nobody responded on fair (F) and Poor (P). Indicator 4 in of portability. Indicator 2 in of portability obtained a weighted mean value of 4.06 and interpreted as Excellent (E). The overall computed weighted mean for Botolan Community College Computerized Library System in of Portability obtained 3.9 and interpreted as Very Good (VG).

31

Table 9 Arithmetic Weighted Mean of the Proposed Botolan Community College Computerized Library System in of the Software Characteristics

Software Characteristics

AWM

QI

A.

Functionality

4.27

E

B.

Reliability

4.21

E

C.

Usability

4.38

E

D.

Efficiency

4.34

E

E.

Maintainability

4.12

E

F.

Portability

3.9

VG

4.20

E

Average Computed Mean

Table 9 shows the Software Characteristics of Computerized Botolan Community College Computerized Library System For indicator 1, for Botolan Community College Computerized Library System in of “Functionality”, obtained a weighted mean value of 4.27 and interpreted as Excellent (E). For indicator 2, for Botolan Community College Computerized Library System in of “Reliability”, obtained a weighted mean value of 4.21 and interpreted as Excellent (E).

32

For indicator 3, for Botolan Community College Computerized Library System in of “Usability”, obtained a weighted mean value of 4.38 and interpreted as Excellent (E). For indicator 4, for Botolan Community College Computerized Library System in of “Efficiency”, obtained a weighted mean value of 4.34 and interpreted as Excellent (E). For indicator 5, for Botolan Community College Computerized Library System in of “Maintainability”, obtained a weighted mean value of 4.12 and interpreted as Excellent (E). For indicator 6, for Botolan Community College Computerized Library System in of “Portability”, obtained a weighted mean value of 3.9 and interpreted as Very Good (VG). The overall computed weighted mean for Botolan Community College Computerized Library System for the Software Characteristics obtained 4.20 and interpreted as Excellent (E).

33

Chapter 5 CONCLUSIONS AND RECOMMENDATION

This chapter discusses the summary, conclusion and recommendation of the software “Botolan Community College Computerized Library System”.

Conclusions Based on the findings, the researchers come up with the following conclusions:

1. The researchers concluded that the Botolan Community College Library System is efficient to use based on the results of the study. The computed average weighted mean is 4.20 and interpreted as excellent. 2. As a whole, the proposed system and the existing system have a tremendous distinction. The difference from the traditional to the proposed system is truly beneficial to the library, librarian and student. 3. The researchers concluded that the study will opt an opportunity to improve the library service to the students and faculty.

34

Recommendations Based on the results of the findings and conclusions gathered, the researchers would like to recommend the following:

1. The researchers recommend that the Library consider the proposed Library system for them to increase the number of their student or . 2. The researchers recommend the proposed system be implemented by the librarian because it is more productive and more capable of recording data in library. 3. Future researchers should continue to improve the proposed system. 4. Training must be conducted before the actual operation of the developed system.

35

BIBLIOGRAPHY

A. ONLINE RESOURCES

Elisabeth, Robson. (May 30, 2011). Product manager for Online Computer Library Centers. (December 14, 2011).http://www.idoub.com/doc/56632694/library-system Ken Chad (December 2008/January 2009) Library management systems embrace change (December 20, 2011) http://www.researchinformation.info/features/feature.php?feature_id=198 Written by (June 01, 2009) UP in Mindanao accepted its first batch of students. (January 02, 2011). http://upmin.edu.ph/index.php?option=com_content&view=article&id=350&Itemid=100 329 Eden (September 18, 2011) website of FMS, Inc. (January 11, 2011). www.idoub.com/doc/.../61293355-Chapter-2 Charuasia (August 6, 2011) St. John Berchmans Academy will sustain the needs of an automated library. (February 5, 2011). www.idoub.com/doc/61741505/jjjjjjjj Lou Zelie, F. Destination (July 13, 1986) made a survey on the computer application in 223 libraries in Metro Manila. (March 1, 2011). http://apslibrary.ateneo.edu/4WEB/2008%20Thesis%20Index Back & Bailey (March 3, 2010) explored the design space of mash- up techniques for the faultless inclusion of information from Web services into websites. (March 2, 2011)www.idoub.com/doc/.../61293355-Chapter-2 Editha P. Agena (November 2, 2008) Analysis of the Usage of the Jose Rizal University Library Collection A Basis for Further Development. (April 12, 2011). http://lisresearchphil.blogspot.com/2008/11/analysis-of-usage-of-jose-rizal.html

36

Appendix A BCC Mission

37

Mission Botolan Community College shall endeavor to explore avenues and opportunities to promote and maintain equitable access to relevant and quality education for all Botoleños at all times

38

Appendix B BCC Vision

39

Vision Botolan Community College is a caring institution committed to making relevant and quality education accessible to the students of Botolan toward providing this municipality with dynamic human resources capable of transforming their beloved town into a community responsive to the needs of its people within their rapidly changing environment.

40

Appendix C Project Title Proposal

41

Republic of the Philippines COLLEGE OF INFORMATION AND COMMUNICATION TECHNOLOGY BOTOLAN ZAMBALES

Name of Researchers:

Dio P. Doble Reggie Romero

I.

PROJECT TITLE PROPOSAL: “BOTOLAN COMMUNITY COLLEGE LIBRARY SYSTEM”

II.

AREA OF INVESTIGATION: The study is about a computerized Library System designed for better management system of the and convenience of the students or . The proposed system is a LAN-based which transacts book records and student record operation such as book availability, unreturn books, penalty and student’s record. This system is developed by using Microsoft Visual Basic 6.0 and MySQL Database.

III.

REASON OF CHOICE: The researchers came up with the decision of developing this kind of study to lessen human errors such as inaccurate record of student and books occupied or the number of books and student that are available and losing the records of your student or occurs.

42

IV.

IMPORTANCE OF THE STUDY: The development of this study will give systematic and manageable work. The system save processing time which helps s provides better management for the students and books.

V.

TARGET S/BENEFICIARIES: The library, and their student are the target s and beneficiaries of the proposed system.

VI.

SIMILARITIES WITH PREVOIOUS STUDIES/PROJECTS: The researchers are aware of any study or project similar to the proposed system.

VII.

PROJECT TIME TABLE: (See Gantt Chart Attached)

43

Botolan Community College BotolanZambales GANNT CHART Computerized Library System TIMEFRAME (in weeks) ACTIVITIES 1

2

June 3

4

5

July 6 7

8

9

August 10 11

12

13

September 14 15

16

17

October 18 19

20

1. Problem identification and Analysis 2.Defense & Approval of Project Title Proposal 3.Data Gathering 4.Writing of Chapter 1, 2, and 3 5.Developing the system/ software 6.Review of Related Literature and Studies 7. Testing and Debugging 8. Writing of Chapter 4 and 5 9. Implementation 10. Submission of Chapter 4 and 5 11. Oral Defense 12. Revision of documents and software/ system 13. Submission of softbound documents and softcopy of system/ software

44

Appendix D IPO

45

A.

INPUT Keyboard Mouse Click Data

IPO Overview Diagram

PROCESS

OUTPUT

Automated Data Processing

Data Records

Program: BCC Computerized Library System

Author: Dio P. Doble Reggie V. Romero

Module:

Date Created: August 23, 2011

0.0 Log-In

INPUT

PROCESS

OUTPUT File Submenu

Mouse Click On “File”

Load / Display File Sub Menu

-Ok -Cancel

46

Program: BCC Computerized Library System Module: 1.0 Main Menu

INPUT

Mouse Click On “Security”

Mouse Click On “File”

Dio P. Doble Reggie V. Romero

Date Created: August 23, 2011

PROCESS

Load / Display File Sub Menu

Program: BCC Computerized Library System Module: 2.0 Book Records INPUT

Author:

Author:

OUTPUT File Submenu -Book Records -Student Records - s -Borrowed Books -Returned Books -List of Borrower -Transaction -Settings

Dio P. Doble Reggie V. Romero

Date Created: August 23, 2011

PROCESS

Load / Display File Sub Menu

OUTPUT File Submenu -Add -Edit -Delete -Search -Print -Save -Cancel -Back

47

Program: BCC Computerized Library System

Author:

Module: Records

Date Created: August 23, 2011

3.0 Student

INPUT

Mouse Click On “Security”

PROCESS

Load / Display File Sub Menu

Dio P. Doble Reggie V. Romero

OUTPUT File Submenu -Add -Edit -Delete -Search -Exit -Save -Cancel -Back

Program: BCC Computerized Library System

Author:

Module:

Date Created: August 23, 2011

4.0 s

INPUT

Mouse Click On “File”

PROCESS

Load / Display File Sub Menu

Dio P. Doble Reggie V. Romero

OUTPUT File Submenu -Add -Edit -Delete -Search -Exit -Save -Cancel -Back

48

Program: BCC Computerized Library System Module: 5.0 Borrowed Books INPUT

Mouse Click On “File”

Author:

Dio P. Doble Reggie V. Romero Date Created: August 23, 2011

PROCESS

Load / Display File Sub Menu

OUTPUT File Submenu -Add -Edit -Delete -Search -Exit -Save -Cancel -Back

Program: BCC Computerized Library System

Author:

Module: Books

Date Created: August 23, 2011

6.0 Returned

INPUT

Mouse Click On “File”

PROCESS

Load / Display File Sub Menu

Dio P. Doble Reggie V. Romero

OUTPUT File Submenu -Add -Edit -Delete -Search -Exit -Save -Cancel -Back

49

Program: BCC Computerized Library System Module: 7.0 Lists of Borrowers INPUT

Mouse Click On “File”

Mouse Click On “File”

Dio P. Doble Reggie V. Romero Date Created: August 23, 2011

PROCESS

Load / Display File Sub Menu

Program: BCC Computerized Library System Module: 8.0 Transactions

INPUT

Author:

Author:

OUTPUT File Submenu -Add -Edit -Delete -Search -Exit -Save -Cancel -Back

Dio P. Doble Reggie V. Romero

Date Created: August 23, 2011

PROCESS

Load / Display File Sub Menu

OUTPUT File Submenu -Add -Edit -Delete -Search -Exit -Save -Cancel -Back

50

Program: BCC Computerized Library System Module: 9.0 Settings

INPUT

Mouse Click On “File”

Author:

Dio P. Doble Reggie V. Romero Date Created: August 23, 2011

PROCESS

OUTPUT

Load / Display File Sub Menu

File Submenu - Manage Department/ Course/Year - Set Penalty Rate - Configuration

Program: BCC Computerized Library System

Author:

Module: 9.1 Manage Department/ Course/Year

Date Created: August 23, 2011

INPUT

Mouse Click On “File”

PROCESS

Load / Display File Sub Menu

Dio P. Doble Reggie V. Romero

OUTPUT File Submenu -Add -Change -Delete -Save -Cancel -Back to Settings

51

Program: BCC Computerized Library System

Author:

Module: Rate

Date Created: August 23, 2011

9.2 Set Penalty

INPUT

PROCESS

Mouse Click On “File”

Load / Display File Sub Menu

Dio P. Doble Reggie V. Romero

OUTPUT File Submenu -Add -Change -Delete -Save -Cancel -Back to Settings

Program: BCC Computerized Library System

Author:

Module:

Date Created: August 23, 2011

9.3 Configurations

INPUT

Mouse Click On “File”

PROCESS

Load / Display File Sub Menu

Dio P. Doble Reggie V. Romero

OUTPUT File Submenu -Add -Change -Delete -Save -Cancel -Back to Settings

52

Appendix E CONTEXT DFD

53

54

Appendix F HIPO

55

56

Appendix G Performance and Evaluation Test

57

EVALUATION INSTRUMENT Botolan Community College Library System

General Direction. Please accomplish this questionnaire very carefully and honestly. Please rest assured that any information that you supply will be treated with the greatest confidentiality and anonymity. I.

Qualification of the Respondent Please put a check mark on the answers most applicable to you on the space provided. 1. Name: ______________________________ 2. Age on last birthday

____ 55 and above

____ 40-44

____ 25-29

____ 50-54

____ 35-39

____ 20-24

____ 45-49

____ 30-34

____ 15-19

3. Sex ____ Male

____ Female

4. Highest educational attainment

____ With doctoral degree ____ With doctoral units ____ Withmasteral degree ____ Withmasteral units ____ College degree holder ____ College undergraduate ____ High school graduate

5. Are you an IT professional/student? ____ Yes

____ No

6. Is your present job description related to the study? ____ Yes

____ No

II. Software Evaluation 58

Kindly put a check mark at the right of the software evaluation characteristics under the proper heading to indicate your assessment on the software product based on the specified factor. SOFTWARE EVALUATION CHARACTERISTICS

Excellent Very Good Good Fair Poor

Functionality Functions required for the system

____

____

____

____ ____

are implemented (suitability) Functional accuracy is provided

____

____

____

____ ____

(accurateness) Functions meet specifications

____

____

____

____ ____

____

____

____

____ ____

____

____

____ ____

(compliance) Ease of connecting with other

systems is provided (interoperability) Substantial security is provided

____

(security) Reliability Software includes no bug: (maturity) ____

____

____

____ ____

A certain system level is maintained even when a trouble occurs

____

____

____

____ ____

____

____

____

____ ____

(fault tolerance) Normal operations are restored readily, when a failure occurs (recoverability) Usability Easy to operate (understandability) Easy to (learn ability) Allows easy operation management

____ ____

____

____

____ ____

____

____

____ ____

____

____

____

____ ____

____

____

____

____ ____

(Operability) Efficiency Provides good responses and

59

high throughput (time behavior) Allows effective use of system

____

____

____

____ ____

____

____

____

____ ____

resources (resource behavior) Maintainability Allows easy analysis of design documents and programs when a bug is found (analyze ability) Allows easy expansion and modification of the system

____

____

____

____ ____

(Changeability) Modification of the system does

____

____

____

____ ____

____

____

____

____ ____

____

____

____

____ ____

____

____

____

____ ____

____ ____

____

____ ____

____ ____

____

____ ____

not affect others (stability) Laborious tests are not required after a modification is made (testability). Portability Provides flexible environment (adaptability) Providing easy installation work (install ability) Complying with porting specifications (conformance)

Allows easily replacement with other software (replace ability)

60

Appendix H Cost Benefits Analysis (CBA)

61

Cost Benefits Analysis between the Existing System and the Proposed Botolan Community College Library System Particulars

PC Express Desktop Pentium Packagewith Canon IP2770 Printer

16,500.00

Windows XP Professional

5,550.00

Visual Basic 6.0

5,000.00

Botolan Community College Computerized Library System

10,000.00 37,050.00

Salary of one (1) Staff

12 x 5,500.00 66,000.00

Handling the Existing System

Savings (PHP)

29,000.00

% of Savings

43.93%

Source: Villman Computers (www.villman.com), PC Express (www.pcexpress.com.ph) Source:http://studentdiscounts.com/microsoftvisualstudioprofessional2010installsonupto2computers.aspx

62

Appendix I Sample Output

63

Figure 1. Log-In

Figure 2. Main Menu 64

Figure 3. Book Records

Figure 4. Student Records 65

Figure 5. s

Figure 6. List of Borrowers 66

Figure 7. Borrow Books

Figure 8. Return Books 67

Figure 9. Settings

Figure 10. Set Penalty 68

Figure 11. Database Configuration

Figure 12. Set Time and Date 69

Appendix J Curriculum Vitae

70

Dio P. Doble Taugtog, Botolan, Zambales Cellphone no. 09461299220 Email Address: [email protected] PERSONAL DATA Birthplace Birth date Age Civil Status Citizenship Religion Sex Weight Height Language Spoken

: : : : : : : : : :

IbaZambales Hospital November 23, 1991 20 years old Single Filipino Born Again Male 52 lbs. 5’5 meters English, Tagalog, Zambal

EDUCATIONAL ATTAINMENT

BOTOLAN COMMUNITY COLLEGE BatonlapocBotolan, Zambales

Course Bachelor of Science in Information Technology (2012) - Present

: TAUGTOG NATIONAL HIGHSCHOOL TaugtogBotolan, Zambales

Secondary (2006-2009)

TAUGTOG ELEMENTRY SCHOOL TaugtogBotolan, Zambales

Elementary (2000-2006)

SPECIAL SKILLS Y4IT Information Technology (IT) UP Diliman, Quezon City September 16, 2011 SCITE Information Technology (IT) Luis Restaurant, Balanga Bataan February 3, 2012 ADOBE ILUSTRATOR Information Technology (IT) Botolan Community College, Batonlapoc Botolan, Zambales 71

72

73

74

75