ablan's thesis2

UNIVERSITY OF SAINT ANTHONY(DR. SANTIAGO G. ORTEGA MEMORIAL)

IRIGA CITY

CHAPTER I

INTRODUCTION

As technology continues to advance, computers are becoming more part

of everyday life. Computers are everywhere at work, at school, and at

home .Many daily activities either involve the use of or depend on information

from a computer. This maybe because computers are used in almost every field

and profession like education and office works to perform large number of

computer application .It also the best solution for providing information and a

way of communications in every individual and gives better understanding of

some event s that can arouse the interest of some particular subject matter.

The extensive records will not be a problem to a post industrialized

society, likewise the unreliable and slow processing and preparing student record

and enrollment summary of report. Computer can be considered as another

instrument for developing a system like enrollment in every school. This can be a

great help to those students, teachers and school who are handling many task

from providing easier and faster access.

1


IRIGA CITY

Recently, computerization has been a part of the massive globalization of

our modern times. Computerized system is being adopted to replace the

tiresome and time consuming manual operations in performing series of related

task.

Like private establishments, government entities and agencies nowadays

are allocating funds for computerization projects to cope up with the tremendous

demands brought about by the fast-changing projects to cope up with the fast-

changing trends of today’s extremely global competition.

The proposed system is a necessity to College of Business Education

Department in order to generate the class scheduling, faculty loading, and room

assignment at an easier, faster and accurate way and will control numerous

transactions at a time without the risk of losing data and having multiple errors.

The present enrollment procedure of College of Business Education

Department is done computerized. But it caused a lot of inaccuracy and

efficiency like conflicting the subject of the student when it comes upon

enrollment. Too much time and effort are consumed when it happened because it

will affect the present schedule, for example the student will have given a certain

schedule and that student sure about his/her subject on that time. But a few after

weeks the department will force to change the schedule of their students to sure

that the exact schedule of the student was been given and they want to avoid

conflicting the time, teachers, room that the student have.

2


IRIGA CITY

CONCEPTUAL FRAMEWORK

In this research, the researcher aims to provide a better way of scheduling

the subject of each student who categorized their subject from those

departments, where the staff and the management can handle a faster and easy

way of retrieving and scheduling the student’s subject. Only the dean and

secretary/personnel has the authority to use the system that can manipulate the

records in the system. The process of the system is that, the user will encode the

corresponding subject of a student when the enrollment time is near or

happened. The system will provide a reliable and efficient way of checking,

monitoring, updating and keeping subject. The study aims to produce a result of

Automated Scheduler that can cope up with the needs of the College Of

Business Education.

Also this study is based and focuses only on the process of enrollment in

College of Business Education Department. This is also aiming an effective

means of processing transaction and avoiding any kind of conflicting when it

comes to choosing student subjects.

3


IRIGA CITY

Figure 1, illustrates the important features incorporated in this study.

Input It is consist of the existing scheduling, faculty Loading and

Room Assignment of College of Business Education

Department.

Process The study considers the analysis of the existing system and

problems encountered.

Output. The expected output of this study is the “Automated

Scheduler of Faculty Loading and Room Assignment of

CBE, USANT”

Feedback. This touches on the looping in the paradigm to make sure

there is a continues evaluation to improve the Scheduling

Procedure of the College of Business Education

Department.

4

Problem Encountered in Manual Process of Scheduling of Faculty Loading, and Room Assignment of CBE, USANT.

Faculty will be searching the system when they want to check the schedules, edit and delete in the record. Scheduling of Room Assignment become easy and it can avoid conflicting of certain schedules of the students.

“Automated Scheduler of Faculty Loading, And Room Assignment of CBE”, USANT”


IRIGA CITY

Figure (1)

CONCEPTUAL PARADIGM

5


IRIGA CITY

STATEMENT OF THE PROBLEM

Different Problems are as follows:

1. What are the problems encountered of the present/existing system

in the college of Business Education, in terms of:

a.) Class Scheduling

b.) Faculty Loading

c.) Room Assignment

2. What computerized system can be proposed to support the present

system?

These are the main problems encountered during the present

manual procedures of College of Business Education Department. The data

entered in the forms are redundant and inconsistent, retrieving and editing data

are very tedious.

6


IRIGA CITY

ASSUMPTION OF THE STUDY

The following Assumption is adopted in this study:

1. That the existing College of Business Education Department in terms of

processing the schedule of different subject of different student under the

department of College of Commerce are done manually/sufficiently.

2. That the problems encountered by the personnel in keeping/maintaining

the schedule of different subject was said to be conflict when the enrollment time

was conduct or happen.

3. The current system is proposed to aid in minimizing the problems

occurred during the enrollment of enrollees and encountered by the office

personnel (Dean, Secretary).

4. The purposeof the study is to lessen the problems.

7


IRIGA CITY

SIGNIFICANT OF THE STUDY

The study will be a great help to the following:

Dean/Secretary. This study will help them to process student schedule and keep

avoiding any kind of hustle or problem when it comes enrollment from their

department. It will help to handle essential transaction with their students.

Students. The students can will be sure that their corresponding subject has been

get and there’s no need to concern about for conflicting their subjects.

Faculty. The faculty or the teacher can notify about the changes of their schedule

when cant’ avoid conflicting subject through deans’ office.

The Client. This study has great benefits to the clients because it will provide a faster

means if processing their claims by automated process.

Future Researchers. The students who would need information related to the study,

it will serve as a guide in making a system similar to this. It will provide them enough

understanding and insight on how the study was done.

8


IRIGA CITY

SCOPE AND DELIMITATION

The study focuses on the scheduling, assigning of students subject on the

College Business Education Department in USANT. The Automated Scheduling

system is concerned in getting the right schedule in terms of: subjects, time,

room, teachers when a student enrolled by every semester. And every semester

it will updated by the user to encode the another schedule

The study will be limited only to the boundaries of (College Of Business

Education Department).The researchers focused in getting relevant data

including data of the students and make a necessary system for student

scheduling. It has an ability to see, notify, and avoid those kind of unnecessary

thing that gives to the department personnel hustle when it comes to enrollment

procedures. The study covers the computerized preventing conflict among

student’s subjects, the Automated Scheduler of Faculty Loading and Room

Assignment of College Business Education Department at University of Saint

Anthony.

9


IRIGA CITY

DEFINITION OF TERMS

These terminologies were gathered by the researcher for better and

clearer understanding about the study.

Automated. Is the of converting the manual process to automation

operation.

Conflicting. The process/way of giving a hustle or unnecessary problem

on the certain task, process, work.

Edit. Is to view the records in order to make some vital changes.

Operational. The way of relating operation process.

Record. It is the collection of related field with information that usually

pertains to only one subject.

Scheduler. Is the certain program that make for conducting, processing a

schedule.

System. It is a group of interrelated components working together toward

a common goal by accepting input and producing output in an organized

transformation process.

Loading. Is the process of being load of a certain program etc.

Save. A program command that write/copy data from the main memory to

the secondary storage devices like diskettes.

Search. A program features which locate records in database file.

10


IRIGA CITY

REVIEW OF RELATED LITERATURE AND STUDIES

The chapter states the different literature and studies that were conducted for the

research to gain familiarity that are relevant and similar to the present study.

Related Literature

Tinn, (2001) stated that the computerization responded to the call the office or

any workplace to help their daily operation.

Maloloset.al (2002) stated that the study of automation is important in the sense

time that minimizes the time and effort normally exerted in manual process.

Dioso, (2001) stated that computer assist careful intelligent planning,

organizing, actuating and controlling .This maybe observed from the past that

they monitor production activities, solve scientific problem and help arrive in

tentative answer to a multitude of involve conditions.

Mane, (2000) mentioned that the creation of the computer made the easier to

accomplish that by doing it manually, to have the direct access

11


IRIGA CITY

on straightforward answer just monitoring record where in the needs of computer

make possible for everyone to get data in a particular need. We can consider that

the computer is necessary and its productive tool for individual.

Gurewich, (1999) stated that the database system makes the work faster for

every institution. For the mere fact that instead of doing things manually, with the

use of computer technology everything is done fasters.

Towsand, (2005) stated that database is structed collection of data. The data

may be about people, product events in short, any type of information is to

manage the collection of data for reporting and making decision.

Silberschatz, (2006) in his book “Database System Concept” the goal of

database system is to simplify and facilitate access to data.

Hammer (2003) Said that computer could eliminate the need for copying and

rearranging information, which was entered into system. They also perform

mathematical computation; in short computer can eliminate most of the paper

works.

12


IRIGA CITY

Related Studies

Garcia(2002) created the “CSPC Enrollment System”, the study can be a great

help to persons concerned during the enrollment period, the personnel, instructor

of the students as they retrieval necessary information when needed and lessen

the burden manually browsing over enrollment record purposes.

Saayo et.al(2008) Computerized developed System. Due to increasing

population of the institution, and the school currently implementing the manual

system, every student spends a lot of time during enrollment period, such as

choosing their corresponding subject and processing the enrollment

requirements.

Gumitao (2001) System Designed to provide reports of the list of enrollment per

school year, periodical grade of students, and list of new, old and transferees

IPizzara and Veridiano (2001) this system was done using Microsoft Visual

Basic 6.0. This conducted system goes along the trend of computerization to be

in the field of competitiveness and survive to the complicated works.

Dawn RosebergMckoy (2007) “Computer literacy: A NEW GENERATION

SKILL States that in most place of business of computer is standard. In the bank

13


IRIGA CITY

they used computers to look up your account in information. Dean’s offices utilize

computers to state to store student subject and student information

SYNTHESIS OF THE STATE-OF-THE ART

The Advocate of the studies stated on the review of related literature are

therefore similar to the present studies but at some point differs from views of the

present researchers. Furthermore, the discussions were shown below.

The researchers agreed upon what Saayo et.alis the most perfect case

that is parallel to the present study, believed that other innovations can make

ways and helped improve more frequently and secure and no hustle computer

processing system. When It comes to enrollment procedures or period.

The Study of Dawn RosebergMckoy is stated that the computer is good

sure equipment in the business world. Like in the College Department stated that

Dean’s offices utilize computers to state to store student subject and student

information.

Their study focused on improving the process of enrollment and alters it

with a computerized one. Together with it is the information system of the school.

14


IRIGA CITY

RESEARCH GAP

Through brief analysis made, the present study “Automated Scheduler

of Faculty Loading and Room Assignment of CBE, USANT” focuses on

checking and maintaining the corresponding subject of various students who

enrolled on this department with their corresponding course. Through the help of

this kind of propose system. However, the present study focuses not only at

concerning/avoiding about the conflicting the subject of students process, but

also it talks about the maintaining and upgrading the subjects through every

semester happened before the day that the dean announces when we can start

inquiring about the subjects we suppose to enrolled.

After a careful analysis of the different literature and studies, it shows that

some studies gently analyzed the system we proposed is seldom seen or used

by some school and university because deans and other faculty still used the

manual process of scheduling and arranging room assignment.

The system offers instructions to users on how to manipulate and operate

the program themselves. A window-based program and runs by a mouse by only

clicking a certain item.

The study was an idea of the researchers to produce a system that can

use to make the scheduling of Faculty Loading and Room Assignment become a

fully automated system.

15


IRIGA CITY

NOTES

First Name MI Last Name.TITLE OF BOOK/THESIS.Publisher. c. 2010

Garcia,“CSPC Enrollment System”, ( Unpublished Baby Thesis, CSPC, 2001)

Saayo et.al Computerized Developed System,

Gumitao, (System Designed) Prentice Hall, 1992, pg. 1

Dawn RosebergMckoy Computer literacy: “A NEW GENERATION SKILL” New York: Van Nostrand Reinhold.

Camarines Sur Polytechnic Colleges Budget Office Records System (CSPC) (Unpublished Thesis, CSPC, March 2005)

Grace Navaro et.al. “Proposed Computerized Scheduling System of BUPC” (Unpublished Baby Thesis, CSPC, 2000)

CENRO “Delos Santos et al2, (2004)”

16


IRIGA CITY

CHAPTER II

RESEARCH METHODOLOGY AND FINDINGS

This chapter covers a discussion on the research methodology and

procedure used. Details in gathering tools, data collection instruments, and

statistical treatment of the data gathered were conferred for the clean

presentation of the findings regarding the problem of the proposed system.

THE RESEARCH METHOD

This study made use of the descriptive survey and normative method

employing a questionnaire. It is the fundamental instrument used in gathering the

necessary data from the awareness of the target respondents about the problem

encountered and the implication of the findings of using the manual system. The

descriptive survey is a method used to collect information or data; it is simple and

helpful enough in data gathering. Thus, the data gathered on, the survey will give

the researcher the accurate summary of information.

17


IRIGA CITY

RESPONDENTS

Figure 1, Show on the next page, portray the respondents of the study and

their position. There were 100 total number of respondents, consists of student,

personnel, faculty and others that participated in the distribution of the

questionnaire.

Table1

Function in school

Function in school

18


IRIGA CITY

The data gathering tools in this study that helped and enriched the

knowledge of the researcher in collecting the data are the following:

Interview. Formal, informal and follow-up interviews were conducted to gather

necessary information from the respondents. It was conducted during their

leisure time so as not interrupt with their business flow especially during class

hours. The questions used were explained in a dialect understandable manner to

each respondent.

Questionnaire. Before the questionnaires were made, several meetings of said

respondents were performed to collect what possible questions should be

formulated.

The researchers also observed the attitude of the respondents if they will truly

cooperate. After the questionnaire was made, draft was submitted to the adviser

to correct errors and for suggestions, comment and recommendation.

The questionnaire were formulated clearly and based on their level of

intelligence. On the interval of the questionnaires, the researcher conducts a

follow-up interview to check the veracity of the answer so that reliability

information regarding the study will be gathered.

19


IRIGA CITY

Library Technique. Other needed information was gathered through research

conducted from different libraries.

Internet. It is the fast technology-based source of information/ data used for this

study. Internet is used for gathering important information and data from many

sources that has been very helpful to the completion of this study.

STATISTICAL TREATMENT OF DATA

To have a clear summarized presentation, the data gathered were tallied

and tabulated.

Percentage. Thisis the technique used because of its accuracy and efficiency in

obtaining the proportioned indication of the responses. The following formula is

used.

P= r∗100R

Where:

r = number of the respondents

R = total number of the respondents

P = percentage

20


IRIGA CITY

Rank = A technique used in obtaining the proportion of the response.

R= fF

Where:

f: total rank number of similar frequency

F: sum of number of similar frequency

R: rank

FINDINGS

The following tables reflected the data gathered from the One Hundred (100)

respondents.

Table 1

Gender of the Respondents

21


IRIGA CITY

Graph1: shows the respondents gender tallied with their percentage rate.

Female consist of fifty-eight(58) and has fifty-eightpercent (58%) while male has

forty-two (42) and has forty-two percent (42%) of the total respondents.

Table 2

Problem Encountered with Manual Transaction

Problem of Manual Transaction

FREQUENCY RANK

Slow processing of Scheduling Faculty Loading & Room Assignment

32 3

Consume too much time and effort when it comes upon time scheduling and making reports.

63 1

Conflicting of Schedules 39 2

22


IRIGA CITY

Table 2: Shows the ranking and the frequency of the problem

encountered by the school, the most common and chosen problem meet by the

school is the “Consume too much time and effort when it comes upon time

scheduling and room assignment chosen by the sixty three (63) respondents.

Second top this is “Conflicting subject schedule having thirty nine (39)of the

respondents. Last chosen problem is the “Slow processing of Room

Assignment”, having thirty two (32) of the respondents.

Table 3

Efficiency of the current systemRATING FREQUENCY PERCENTAGE

POOR 10 10

SATISFACTORY 51 51

EXCELLENT 26 26

VERY SATISFACTORY 13 13

TOTAL 100 100

Table 3: Shows the percentage rate of the current system with the

frequency indicated. This question was only limited to the employees of the

school only considering the Faculty, Dean, Personnel and Student. There were

100 despondence that had the chance to answer the question, including the

Dean. Fifty one (51) of them answered as satisfactory rating of the school with

fifty-one percent (51%) in average. Twenty six (26) answered excellent with only

23


IRIGA CITY

twenty six percent (26%) and thirteen (13) answered very satisfactory with the

average of thirteen percent (13%). While as poor rating with ten respondents with

ten percent (10%) in average.

Table 4

Satisfactoryof thecurrent processof scheduling system

INDICATOR STUDENT PERSONNEL / FACULTY

FREQUENCY PERCENTAGE FREQUENCY PERCENTAGE

YES 1 17 44 47

NO 5 3 50 53

TOTAL 6 100 94 100

Table 4: Illustrate the percentage of the satisfaction of the faculty and

student by their current process of scheduling system. It shows the satisfaction

rating of the faculty of the school with their scheduling process. Most of them

answered they were not satisfied with the process and only one answer yes. The

students the satisfaction of the current system was also showed above. There

were personnel / faculty who had answered yes with the rating of forty seven

percent (47%), they were satisfied of the current system with their department.

And fifty three percent (53%) of the respondents were not satisfied of the current

manual system.

24


IRIGA CITY

TABLE 5

Preferred system of the faculty and students

INDICATOR FACULTY / PERSONNEL STUDENTS

FREQUENCY PERCENTAGE FREQUENCY PERCENTAGE

COMPUTERIZED SYSTEM

6 100 92 98

MANUAL SYSTEM 0 0 2 2

TOTAL 6 100 94 100

Table 5: Shows the hundred percent (100%) of the employees likes to

have a computerized system. And out of one hundred (100) respondents there

are ninety two (92) who wanted to have a computerized system. While remaining

two (2) respondents wanted the usual system the current manual system

25


IRIGA CITY

CHAPTER III

TECHNICAL INVESTIGATION AND IMPLEMENTATION OF SETTING

Figure 1

GEOGRAPHICAL LOCATION

College of Education Department, University of Saint Anthony is located at San

Miguel Iriga City, 4431.

Figure 2

26


IRIGA CITY

UNIVERSITY OF SAINT ANTHONY SGO CAMPUS

27


IRIGA CITY

Figure 3

COLLEGE OF COMMERSE DEPARTMENT OFFICIAL LOGO

THE COLLEGE OF COMMERCE BRIEF HISTORY

The four-year degree leading to Bachelor of Science in Commerce (BSC)

major in Economics, Finance, Management and Marketing was first offered in

1966 to keep up with the demands of times. In 1983, computer subjects were

integrated n the curriculum to meet the country’s growing demand for computer-

trained commerce graduates.

At present, the commerce program enjoys the benefits of the level II

accredited status as awarded by the Philippine Association of Colleges and

28


IRIGA CITY

University – Commission on Accreditation (PACUCOA) and embodied in CHED

ORDER No. 31, s. 1995 with validity date up to November 2010.

VISION

The College of Commerce vision is to produce graduates who are globally

competitive.

MISSION

The mission of the college of Commerce is to provide quality education

necessary to equip students with values, knowledge and skills essential in the

work environment in local and international job opportunities.

GOALS AD OBJECTIVES

The college of Commerce provides an instruction geared toward the

preparation of the students to keep apace with the demands of global

competitiveness.

29


IRIGA CITY

The Commerce program is designed to provide student with:

1. A common foundation of knowledge of a specific area through a core

cluster of courses consisting of general education and professional

courses.

2. Sufficient to the realities of work environment particularly in the use of

computer technology;

3. Skills for self or cooperate employment;

4. Proper motivation, opportunities for the inculcation of values and the

promotion of professional growth; and

5. A proper environment to develop a firm commitment and participation in

the realization of national and regional development.

MOTTO

College of Business Education. . reinventing the future

30

ANALYSIS

SYSTEM ENGINEERING

DESIGN

CODING

TESTING

MAINTENANCE


IRIGA CITY

PROGRAMMING PARADIGM

Figure 4

The programming paradigm adopted in development of this software is the

classic life cycle, commonly referred to as the “waterfall model”.

31


IRIGA CITY

The Classical Lifecycle Paradigm

The classic life cycle is composed of the following: the system

engineering, analysis, design, coding testing and maintenance. The researchers

believe that this paradigm is the best suit to the proposed system.

System Engineering

The first phase of the paradigm involves the great task to be tackled by

the researchers. A thorough investigation is needed to overcome this phase and

so comprehensive research and personal interview to the concerned officers are

needed to gather necessary information to arrive at a useful data needed to

study further the transactions conducted in the office. Thru the interview and

questionnaire done it derive an overview of transaction and process conducted at

the institution.

The gathered information and system requirements were studied one by

one and critically analyzed all the important details needed in making the system.

The researcher gathers all information needed from Mrs. Marieta L.

Monte, Dean, College of Commerce, USANT. The information gathered would

help to make system that will suits their needs and meet their expectations.

32


IRIGA CITY

Analysis

The second phase in the paradigm is the Analysis which is the major

function is to study completely all the gathered data and information. Before the

researcher designed the system, they must first identify what the system needed

by the institution employee. Thus, understanding the system intent and functions

starts with an examination of the requirements. In this place, the researchers

performed a study to assess the overall scope of the problem and determine the

risk factor in making the system.

In making the analysis of the system, an interview is accomplished from

the Dean, Secretary and Faculty. Gathering of data through questionnaire was

carried out. These were distributed to the Faculty, Students, and School

Personnel to add more information needed in making the system.

In programming paradigm, conceptualization of requirements and

converting it to Data Flow Diagram (DFD) and Entity- Relationship (E-R) will

show clearly the flow of the system to be made. Analyzing the problems

encountered by the respondents and reflects on the best solution that we could

be proposed to solve the problems. DFD and E-R provides an overview of actual

transaction that they currently using and presents the possible solutions to

minimized, if not it eliminate totally the problems that they are encountering.

33


IRIGA CITY

Design

The next phase is the one responsible in making of blue print of the

system. Software design focuses on the four (4) distinct attributes of the program

such as data structure, software architectures, procedural detail and interface

characterizing.

The researchers reviewed the data and information on the existing

system. We gathered information and documents, the kinds and types of

information to be processed by the system. In this phase of paradigm, we made

the work design of the system from Graphical User Interface (GUI) to the system

design was made know how it will looks like, how will the transaction flows and

how the data will treated by the system.

Final studies of the transaction used, analyzed the proposed solution and

made the final design and overview on how the new system will work.

Coding

After the 3rd phase, coding is the most substantial phase wherein we

divided the series of large program into bits and pieces of sub programs in order

to accomplish the coding mechanically. This is the process in which fourth phase

take place.

34


IRIGA CITY

Also known as programming, this phase involves the creation of system

software. The requirements and system specification from the system design

steps and translated into machine readable computer code.

This is most important parts of developing the system. The specification,

verification and condition of system where given emphasis.

Testing

The fifth phase covers the debugging of errors of the system and testing

the system logic of the program to ensure that all the users’ requirement has

been met. The purpose if this is to establish from a variety of possible errors that

should be checked that the modules were coded correctly.

The researchers had satisfied all the errors that will cause of malfunctions

of the system, in case debugging of the program will be applied and find ways to

avoid system failures and made the system function accurately.

Maintenance

Maintenance must be applied so that the system can accommodate

changes in its system environment because testing does not guarantee that

there will be no totally errors can happen in program. There are always some

errors detected that must be corrected. Also maintenance includes

enhancements of capabilities adaption of the software to new processing

environments and corrections of software bugs.

35


IRIGA CITY

Through testing was conducted before the actual usage of the system.

Updating the system is important to make it free from errors therefore the

expected convenience and satisfaction of the user will be attained.

36


IRIGA CITY

ANALYSIS OF SYSTEM REQUIREMENTS

The “Automated Scheduler of Faculty Loading and Room

Assignment of CBE, USANT” requires the following hardware specifications for

better performance.

COMPONENTS DESCRIPTION

Type of processor - Pentium or Higher

Primary Memory - 2GB RAM or Higher

Secondary Memory -149GB Hard disk or Higher, CD Room Drive

Windows OS -Windows XP Professional Service Pack 3 32

bit

Input / Output Device -Mouse, Keyboard, Printer

Monitor -Compaq LCD Monitor

Screen Resolution -1024 X 768-60Hz Screen Resolutions

Printing Device - Continuous Printer

Programming Tool - Microsoft Visual Basic 6.0, Microsoft Access

2007

Back-Up Device - Flash Drive, External Hard Disk

37


IRIGA CITY

ANALYSIS OF SOFTWARE REQUIREMENTS

1. Windows XP Professional Service Pack

2. Microsoft Access 2003/2007

3. Microsoft Visual Basic 6.0

4. Printer Driver

5. Macromedia Plash Application

6. AAA Logo

7. Image Converter Plus

8. Microsoft Vision

38


IRIGA CITY

ANALYSIS OF SYSTEM PROCEDURE

MANUAL SYSTEM

The College of Business Education Department used present manual

encoded system and papers when scheduling and processing their own

transaction in that department. Their assigning, analyzing, scheduling the certain

subject of their students under their department.

PROJECT SOLUTION

The current system being used by College of Business Education

Department has a lot of disadvantage. With the new system, they are able to

manipulate, notify and analyzing the entire schedule in terms; of (Room, Time,

Teachers, Subjects) and all the transaction are automatically in the database so

there is no need to write in a record book. And within anytime they can generate

report to post in for the reminders of loans.

The main objective is to replace the old style of scheduling, loading

transaction of College of Business Education Department.

39

Issue Schedule

Form

Checked

Filling Up

Submitted

Schedule

Enrollees Schedule

Create Schedule

Student-Information

Class Rec.

Received Request

Schedule

Print

ENROLLESS

PERSONNEL

STUDENT

1Request

Enrollment Schedule Form

3Form Submission

4Checked for conflict Schedule

5Give in right schedule

6Record the Schedule

7Create student schedule

2Filling up of Schedule form


IRIGA CITY

DATA FLOW DIAGRAM ENROLLMENT SYSTEM

Figure 5

40


IRIGA CITY

PROPOSED SYSTEM


Assignment of CBE, USANT” were designed specifically for the Faculty in

College of Business Education Department. The proposed system is customized

according to the given expectation and requirement of the client. The goal of this

system is to automate the old procedure which utilized a manual procedure for

Scheduling Faculty loading Assignment and Room Assignment. For the user to

begin, first they prompt their given USERNAME and PASSWORD to access the

system.

41


IRIGA CITY

Figure 6

MAIN FORM

It has thirteen menus that will be show to select several lists options. The

thirteen menus are shown at the right side part of the form. Which are the

followingth

eTIME,FACULTY,ROOM,SUBJECTS,YEARLEVEL,COURSE,ROOM_SCHEDU

LE,DAY,FACULTY_SCHEDULE,SCHEDULE,CLASS_SCHEDULE ,

LOGOFF, SHUTDOWN. And it includes 3 button namely; VIEW CALENDAR,

MANAGE, SYSTEM DEVELOPER.

42

ENROLEES-IDNAMEADDRESSAGEGENDERDATE OF BIRTHSTATUS

ENROLEES-IDFORM-NODATE_REQUESTED

FORM-NOPERSONNEL-NAMEDATE_SUBMMITTEDSTUDENT-NOFNAMELNAMEMNAMEDATE OF BIRTHAGEGENDERPERSON_CONTACTCELLPHONE/TELEPHONE NO.COURSE_LEVELSCHOOL LAST_ATTENDED

PERSONNEL-NAMERECORD-NOSTUDENT_NO

ENROLLEES

Request

FORM

Submit

To

PERSONNEL

Give Right

Schedule

CheckedSchedule

ENROLLESSSCHEDULE

Record

Student -Information

Class-Record CreateSchedu

le

STUDENT

STUDENT-NO

RECORD-NOSTUDENT_NOFNAMELNAMEMNAMECOURSE_LEVELTEACHER_NAMESUBJECT_NAMETIMEDAYROOM_NO

ENROLLESS-IDPERSONNEL-IDDATE_CHECKED

ENROLEES_IDPERSONNEL_NAMEDATE_GIVEN

PERSONNEL-NAME

FORM-NO

ENROLLESS-IDENROLLESS FORM

RECORD-NOSTUDENT-NODATE_SCHEDULE


IRIGA CITY

Figure 7

ENTITY RELATIONSHIP DIAGRAM FORM SCHEDULE

AS

43


IRIGA CITY

DATABASE SCHEME

ADMINISTRATORS INFORMATION

Figure 8

FIELD NAME DATATYPE FIELD SIZE DESCRIPTIONSAMPLE

DATE

User_ID Text 50 User ID of the administrator

Administrator

Password Text 50Password of the

administrator*****

Figure 9

44


IRIGA CITY

CLASS SCHEDULE TABLE

45

Field Name

Data Type

Size Description Sample

No. Text 50 Student Number

081021197

Fname Text 50 First Name of Student

Melvin

Lname Text 50 Given Name of Student

Garbida

MIname Text 50 Middle initial D.

Course Text 50 Course in Schedule

COMSCI

Year Number 10 Year Level 4

Subject Text 50 Subject Enrolled

ComSci 501

Unit Number 20 Unit/ Subject 3

Time Number 20 Scheduled Time

1:00-3:00

Days Text 50 Scheduled Day

Mon

Room Text 50 Given Setting

SGO 305


IRIGA CITY

46

Field Name Data Type Size Description Sample

No. Texr 50 Student Number 081071081

Fname Text 50 Faculty First Name Marietta

Lname Text 50 Faculty Last Name Monte

MIname Text 50 Middle initial L

Course Text 50 Course inSchedule BS in Accountancy

Year Level Number 10 Year Level 4

Subject Text 50 Subject Enrolled Accounting 1

Unit Number 20 Unit/ Subject 3

Time Number 20 Scheduled Time 8:00-10:00

Days Text 50 Scheduled Day Thurs

Room Text 50 Given Setting SGO 303


IRIGA CITY

SIZE OF INPUT

The bulk of data will come from daily transaction will approximately hold

150kb and for each Employee features about 50kb will be used so therefore,

200kb is more than enough to store the subscriber information, and daily

transaction.

DIVISION OF MODULES


Assignment of CBE” are divided to different modules namely: save, edit, search

and print is used in adding data in the choose transaction.

Figure 10

SPLASH FORM

47


IRIGA CITY

Figure 11

LOGIN FORM

Once the splash form is executed it automatically show fisrt only the tow options botton for choosing the account type for ADMIN OR STUDENT.In this scenario user choose the admin account type.so, it appears the User ID & Password to be input.

48


IRIGA CITY

Figure 12

ADMIN MAIN FORM

This holds the overall transaction of the system. The user can access all the transaction of the system.

49


IRIGA CITY

Figure 13

USER(s) ACCOUNT

Show in the main form the button from MANAGE when it click the four

button will be pop down significantly.

In this button named User when it click this goes like this;

50


IRIGA CITY

Figure 14

SCHEDULE FORM

It Show the process of inputting the schedule in corresponding input area.

51


IRIGA CITY

Figure 15

ROOM SCHEDULE FORM

It shows the schedule by room there has a 3 button namely; Delete, Print,

Cancel. And the user can choose in the combo box the room he/she want to

search and then print.

52


IRIGA CITY

Figure 16

FACULTY SCHEDULE FORM

It shows the schedule by room there has a 4 button namely; Search,

Delete, Print, Cancel. And the user click the search button to find the

corresponding faculty to be search in; then it shows the faculty schedule at the

list box and the the name of faculty was written at the bottom side of list box.

53


IRIGA CITY

Figure 17

PRINT SCHEDULE FORM

It shows the form for printing the schedule by day; by Course And Year &

Course there has a 3 button namely; Delete, Print, Cancel. The user let choose

in 2 corresponding option button at the left side of form namely; Print By Day,

Print By Course And Year

54


IRIGA CITY

CHAPTER IV

SUMMARY, CONCLUSION AND RECOMMENDATIONS

This chapter is a presentation of the summary of findings, the conclusions

drawn from the interpreted data and the recommendations of the research

entitled “Automated Scheduler of Faculty Loading and Room Assignment, CBE

USANT”.

This study deals about the factors affecting the Schedules and information

system used in Automated Scheduler of Faculty Loading and Room Assignment.

What is the existing system used in recording schedules and reports of the

College of Business Education: Loading and Information System office in terms

of:

1. Recording of schedules incurred by the personnel.

2. Generating reports from the encoded records such as conflicting of

schedules.

3. What are the problems encountered by the office personnel in scheduling

and producing reports using the existing scheduling system?

4. What proposed system will aid in minimizing problems encountered by the

office personnel?

5. What improvements will be brought about by the new system?

55


IRIGA CITY

FINDINGS

Based from the summary

1. That the existing College of Commerce Department Scheduling System in

terms of faculty loading and room assignment incurred by the office and

the generating of reports from the encoded records are done manually.

2. That the problems encountered by the personnel in making and

generating schedule reports using the manual record time, effort

consuming, redundancy of work, and conflicting of schedules.

3. The current system is proposed to aid in minimizing the problems

encountered by the office personnel.

4. The proposed study generated the encoded reports are now done

automatically and it’s lessen the problems encountered by office

personnel.

56


IRIGA CITY

CONCLUSIONS

We concluded that this study will help to minimize, diminish the time of

long process and eliminate the problem which the College of Business Education

Department encountered. It removes the manual way of scheduling of Faculty

Loading and Room Assignment.

RECOMMENDATIONS

1. A computer server use an Uninterrupted Power Supply (UPS), to avoid

data lose, data damage and data inconsistency in the database.

2. The project should be considered as an input and guide to the College of

Business Education Department: Scheduling and Information System, If

they plan fully develop a computerized scheduling system.

3. The office of College of Business Education Department needs software

application program to make accurate information and fast tracking of

conflicting data.

4. They need to back-up the database records, to avoid data loss.

57


IRIGA CITY

APPENDICES

58


IRIGA CITY

LETTER TO CONDUCT A STUDY

MRS. MARIETTA L. MONTE, CPA, MBA

Dean, College of Business Education

University of Saint Anthony

San Miguel Iriga City

Dear Ma’am:

Greetings!

We, the 4th year Bachelor of Science in Computer Science students of University Of Saint Anthony, are making a software project in partial fulfillment of the requirement in our degree. We are proposing the thesis entitled “AUTOMATED SCHEDULER OF FACULTY LOADING AND ROOM ASSIGNMENT, CBE USANT”.

In connection with this, we would like your permission for us to conduct a study/interview the important information that we need, to complete our proposed system. We firmly believe that your expertise will be a major influence in the completion of the software.

We are hoping for your favorable response. Thank you very much!

Sincerely yours,

Reynaldo Quindo

Victorio Ablan

Mark Joseph Naldo

Norvic Ocile

.

Noted by: Approved by:

MELVIN ROY D. GARBIDA MRS. MARIETTA L. MONTE, CPA, MBASoftware Project Instructor Dean Of College of Business Education

59


IRIGA CITY

LETTER TO CONDUCT LIBRARY RESEARCH

THE LIBRARIAN

_____________________

_____________________

Dear Sir/Madam:

We, the undersigned 4th year Computer students of University of Saint Anthony, are making a software project in partial fulfillment of the requirements in our course. We are proposing our thesis entitled“AUTOMATED SCHEDULER OF FACULTY LOADING AND ROOM ASSIGNMENT, CBE USANT””.

In connection with this, we would like to ask permission from your good office, or us to conduct a research in your published books, to be used in our review of related studies in our thesis.

We are hoping for your favorable response. Thank you very much!

Sincerely yours,

Reynaldo Quindo

Victorio Ablan

Mark Joseph Naldo

Norvic Ocile

Noted by: Approved by:MELVIN ROY D. GARBIDA MRS. MARIETTA L. MONTE, CPA, MBASoftware Project Instructor Dean Of College of Business Education

60


IRIGA CITY

SAMPLE QUESTIONNAIRE

This questionnaire has been prepared to gather information and data needed

which will be utilized as basis in the preparation of the thesis entitled” AUTOMATED

SCHEDULER OF FACULTY LOADING AND ROOM ASSIGNMENT, CBE USANT” as

partial fulfillment in our software project.

QuestionnaireThe purpose of these questionnaires is to provide statistical information

and to obtain additional facts and information from the respondents about.

This is not a test. Please feel free to accurately answer each item according to

your own preferences. All your answer will be held confidential.

Direction:

Kindly answer the questions by checking the option on the space provided.

1. Your function in school?

Dean Personnel

Faculty Student Others

2. Gender:

Male Female

3. What are the problems you encountered?

Having Conflict to a Certain Subject.

Consumes too much time and efforts when it comes upon enrollment.

Conflicting subjects through enrollment.

Others please specify: ________________________________

61


IRIGA CITY

4. Are you satisfied with the current system on your school?

Yes No

5. How efficient is the system on you school?

Poor Very Satisfactory

Excellent Satisfactory

6. Do you want to improve your current computer system which used when it comes

to enrollment procedures at College of Business Education Department?.

Yes No

62


IRIGA CITY

INTERVIEW PLAN

MRS. MARIETTA L. MONTE, CPA, MBADean of College of Business Education

QUESTIONS:

1. What are the disadvantages of using your manual process of?

2. Do you commonly encounter errors that fatally complicate your dealings?

3. What are the common problems encountered in FACULTY LOADING AND

ROOM ASSIGNMENT at your office which you know can possibly be

automated?

4. How would you want the system to be designed?

5. What conditions do you want to impose when creating the system?

6. How often do you update your records?

7. Would it annoy you if we come back here from time to time for updates as well as

to show you the development of our system?

8. How strict is your audit system?

9. How often do you check your accounting records?

63


IRIGA CITY

SAMPLE REPORT

64


IRIGA CITY

Information Report

65


IRIGA CITY

USER LOGIN/LOGOUT REPORT

66

Account Type Login Time Logout Time

Admin 08:03:37AM Monday, February 27, 2012 08:34:06 am Monday, February 27, 2012

Admin 09:14:24 AM Monday, February 27, 2012 09:20:02 am Monday, February 27, 2012

Admin 09:31:46 AM Monday, February 27, 2012 09:35:20 am Monday, February 27,2012

Admin 09:46:04 AM Monday, February 27,2012 09:48:12 am Monday, February 27,2012

Admin 10:12:09:AM Monday, February 27, 2012 10:19:37:am Monday, February 27, 2012

Admin 10:31:32 AM Monday, February 27, 2012 10:36:09 am Monday, February 27, 2012



Admin 11:03:05 AM Monday, February 27,2012 11:10:53 am Monday, February 27,2012

Admin 11:16:47 AM Monday, February 27,2012 11:28:19 am Monday, February 27, 2012

Admin 08:05:14 AM Wednesday, February 29,2012 08:17:25 am Wednesday, February 29,2012


Admin 09:26:39 Am Wednesday, February 29,2012 09:36:59 am Wednesday, February 29,2012



Admin 01:05:53 PM Wednesday, February 29,2012 01:35:29 pm Wednesday, February 29,2012





Admin 09:08:46 AM March 05, 2012 09:18:47 am March 05, 2012


IRIGA CITY

LETTER OF SOFTWARE DELIVERY

February 28, 2012

MRS. MARIETTA L. MONTE, CPA, MBA

Dean, College of Business Education

University of Saint Anthony

San Miguel Iriga City

Dear Maam:

We, the undersigned 4th year Bachelor of Science in Computer Science

students of the University of Saint Anthony, have already accomplished our

software thesis entitled “AUTOMATED SCHEDULER OF FACULTY LOADING

AND ROOM ASSIGNMENT, CBE USANT” in partial fulfillment of the

requirements of our degree.

In connection with this, we would like to ask for your kind authorization to

implement our said system in your institution for at list (1) month.

Sincerely Yours,

Reynaldo Quindo

Victorio Ablan

Mark Joseph Naldo

Norvic Ocile

Noted by Approved by

MR. MELVIN ROY D. GARBIDASoftware Project Instructor

MRS. MARIETTA L. MONTE, CPA, MBADean, College of Business Educ

67

UNIVERSITY OF SAINT ANTHONY(Dr. Santiago G. Ortega Memorial)

City of Iriga

College of Business Education

“Automated Scheduler of Faculty Loading and Room Assignment”

A Software Implementation and Maintenance Daily Time Record

REYNALDO F. QUINDO

Mr. Melvin Roy D. GarbidaSoftware Project Instructor

68

DATE TIME IN TIME OUT ACCOMPLISHMENT

February 27, 2012 08:01 AM 11:30 AM Computer Checking

February 29,2012 08:00-10:30 AM 01:00-04:15 PM Rechecking

March 05, 2012 09:00-11:31 AM 01:00-02:15 PM Copying the Software/Delivery

March 07, 2012 08:00-11:30 AM 01:30-01:50 PM Installing/Inputting Data


City of Iriga




VICTORIO R. ABLAN


69







City of Iriga




MARK JOSEPH A. NALDO


70







City of Iriga




NORVIC B. OCILE


71







City of Iriga

LETTER OF REQUEST TO THE PANELIST

72

CERTIFICATION

This is to certify that we are accepting the software thesis made by Reynaldo F. Quindo,

Victor R. Ablan Jr., Mark Joseph A. Naldo, and Norvic B. Ocile entitled “Automated Scheduler

of Faculty Loading and Room Assignment”.

Furthermore, we are allowing them to implement the said software in your office for (1) Month.

Given this ___ day of ___ 2011 for record purposes.


City of Iriga


February 23, 2012

MR. RENE LAGRIMASCollege InstructorUniversity of Saint Anthony

Dear Sir:

Greetings!

In connection with our software project entitled “Automated Scheduler of Faculty Loading and Room Assignment, CBE USANT”. We the undersigned Computer Science students would like to ask permission if you could spare time with us to be one of the panelist in our Oral Defense which will be held on the 9th day of March, 2012, 10:00 A.M at SAP Defense Room.

Thank You Very Much!

Respectfully yours,

Reynaldo Quindo

Victor Ablan II

Mark Joseph Naldo

Norvic Ocile

Noted by:


Approved by:

MRS. MARIETTA L. MONTE, CPA, MBADean, College of Business Education

73


City of Iriga


February 23, 2012

MRS. JOY BOLIVARCollege InstructorUniversity of Saint Anthony

Dear Maam:

Greetings!



Respectfully yours,

Reynaldo Quindo

Victor Ablan II

Mark Joseph Naldo

Norvic Ocile

Noted by:


Approved by:


74


City of Iriga


February 23, 2012

MR. MELVIN ROY D. GARBIDACollege InstructorUniversity of Saint Anthony

Dear Sir:

Greetings!



Respectfully yours,

Reynaldo Quindo

Victor Ablan II

Mark Joseph Naldo

Norvic Ocile

Noted by:


Approved by:


75


City of Iriga


February 23, 2012

MRS. MARIETTA L. MONTE, CPA, MBADean, College of Business EducationUniversity of Saint Anthony

Dear Sir:

Greetings!



Respectfully yours,

Reynaldo Quindo

Victor Ablan II

Mark Joseph Naldo

Norvic Ocile

Noted by:


Approved by:


76


City of Iriga

USER MANUAL

77


City of Iriga

SPLASH FORMFIGURE 18

This form will loan before you gain access to the system envirornment.

LOG – IN FORM FOR ADMINISTRATOR

Once the splash form is executed it automatically show fisrt only the tow

options botton for choosing the account type for ADMIN OR STUDENT.In this

scenario user choose the admin account type.so, it appears the User ID &

Password to be input.

78


City of Iriga

LOG – IN FORM FOR STUDENT

FIGURE 19

Once the splash form is executed it automatically show fisrt only the tow options

botton for choosing the account type for ADMIN OR STUDENT.In this scenario user

choose the Student account type.so, it appears the message box saying Enter By the

Student!, then you will only choose among thoose two option Yes Or No?.

79


City of Iriga

ADMINISTRATOR MAIN FORM

FIGURE 20

This holds the overall transaction of the system. The user can access all the transaction of the system.

A. Show the System Calendar.

B. In this button when it click it shows the User(s) Account.

C. When it click it show the pictures of developer who develop/created the system.

80

A

B

C

C


City of Iriga

STUDENT MAIN FORM

FIGURE 21

D. In this scenario there is one button compare to ADMIN FORM. When it click the

button named SYSTEM DEVELOPER it show the pictures of developer who

develop/created the system.

81

A1


City of Iriga

Figure 22

A1. Show in the main form the menu in right side of form pointing the time button.

Then you will see at bottom of this page is the output of that time button.

82

A2


City of Iriga

Figure 23

A2. Show in the main form the menu in right side of form pointing the Faculty button. Then you will see at bottom of this page is the output of that Faculty button.

83

A3


City of Iriga

Figure 24

A3. Show in the main form the menu in right side of form pointing the Room button.

Then you will see at bottom of this page is the output of that time Room button.

84

A4


City of Iriga

Figure 25

A1. Show in the main form the menu in right side of form pointing the time button.

Then you will see at bottom of this page is the output of that time button.

85

A5


City of Iriga

Figure 26

A5. Show in the main form the menu in right side of form pointing the Year

Level button. Then you will see at bottom of this page is the output of that Year

Level button.

86

A6


City of Iriga

Figure 25

A6. Show in the main form the menu in right side of form pointing the Course

button. Then you will see at bottom of this page is the output of that Course button.

87

A7


City of Iriga

Figure 26

A7. Show in the main form the menu in right side of form pointing the Room

Schedule button. Then you will see at bottom of this page is the output of that Room

Schedule.

88

A8


City of Iriga

Figure 27

A8. Show in the main form the menu in right side of form pointing the Day button.

Then you will see at bottom of this page is the output of that Day button.

89

A9


City of Iriga

Figure 29

A9. Show in the main form the menu in right side of form pointing the Faculty

Schedule button. Then you will see at bottom of this page is the output of that Faculty

Schedule.

90

A10


City of Iriga

Figure 30

A10. Show in the main form the menu in right side of form pointing the

Schedule button. Then you will see at bottom of this page is the output of that

Schedule button.

91


City of Iriga

Figure 31

A(10). It shows in the schedule form when there is a conflict happened to a

certain scheduled in terms; of Time, Faculty, Subject Unit, Room, Day, Year

Level, and Course.

92

A11


City of Iriga

Figure 32

A11. Show in the main form the menu in right side of form pointing the Class

Schedule button. Then you will see at bottom of this page is the output of that

Class Schedule button

93


City of Iriga

Figure 33

A(11). Show in the Class Schedule the user choose the option Print by

Day, so the details area shows the schedule will printed by day.

94


City of Iriga

Figure 34

A(11). Show in the Class Schedule the user choose the option Print by

Course and Year, so the details area shows the schedule will printed by day.

95

A12


City of Iriga

Figure 35



A12.In this button named User when it click this goes like this;

96

A13


City of Iriga

Figure 36



A13.In this button named Backup when it click this goes like this;

97

A14


City of Iriga

Figure 37

Show in the main form the button from MANAGE when it click the four button will be pop down significantly.

A14.In this button named Restore when it click this goes like this;

98


City of Iriga

Figure 37

Show in the main form the button from MANAGE when it click the four button will

be pop down significantly.

A15.In this button named About when it click this goes like this;

99


City of Iriga

SOURCE CODE

100


City of Iriga

LOGIN FORM

Private Sub cmdCancel_Click()

End

LoginSuccess = False

End Sub

Private Sub cmdOK_Click()

Dim msg As String

If cboUser.Text <> "" Then

Set clsUserData = New clsUsers

If True = clsUserData.Login(cboUser.Text, txtpass.Text, msg) Then

DoEvents

LoginSuccess = True

CurrentUser = cboUser

Unload Me

FrmMain.Show

FrmMain.lblusername.Caption = "Admin”

Else

LoginSuccess = False

CurrentUser = ""

MsgBox msg, vbInformation, ""

txtpass = ""

txtpass.SetFocus

End If

Set clsUserData = Nothing

End If

101


City of Iriga

End Sub

Private Sub Form_Activate()

Option3.SetFocus

End Sub

Private Sub Form_Load()

Set clsUserData = New clsUsers

If clsUserData.GetUsers(cboUser) = False Then Load Me

Set clsUser = Nothing

Label1.Visible = False

Label2.Visible = False

cboUser.Visible = False

txtpass.Visible = False

cmdOK.Visible = False

cmdCancel.Visible = False

End Sub

Private Sub Option1_Click()

Label1.Visible = True

Label2.Visible = True

cboUser.Visible = True

txtpass.Visible = True

cmdOK.Visible = True

cmdCancel.Visible = True

End Sub

102


City of Iriga


If vbYes = MsgBox("Enter By the Student!", vbInformation + vbYesNo, "Student!") Then

FrmMainStudent.Show

cboUser.ListIndex = -1

txtpass.Text = -1

End If

End Sub

Time/Date In Login Form

Private Sub Timer1_Timer()

lbltime.Caption = Format(Now, "hh:mm:ss AM/PM")

lbldate.Caption = Format(Now, "mmmm dd, yyyy")

End Sub

Main Form

Dim bhide As Boolean

Dim bhide1 As Boolean


Private Sub cmdabout_Click()

FrmAbout.Show

End Sub

Private Sub cmddate_Click()

If Calendar1.Visible = True Then

103


City of Iriga

tmr2.Interval = 10

bhide1 = True

Else

tmr2.Interval = 10

bhide1 = False

Calendar1.Visible = True

End If

End Sub

Private Sub cmdFile_Click()

If picprint.Visible = True Then

tmr1.Interval = 10

bhide = True

Else

tmr1.Interval = 10

bhide = False

picprint.Visible = True

End If

End Sub

Private Sub cmdBackup_Click()

BackupFrm.Show 1, FrmMain

End Sub

Private Sub cmdRestore_Click()

RestoreFrm.Show 1, FrmMain

104


City of Iriga

End Sub

Private Sub cmdReyn_Click()

FrmReyn.Show

FrmReyn.Image1.Visible = False

FrmReyn.Label1.Visible = False





















105


City of Iriga


















End Sub

Private Sub cmdSD_Click()

If pctSD.Visible = True Then

tmr3.Interval = 10

bhide2 = True

Else

tmr3.Interval = 10

106


City of Iriga

bhide2 = False

pctSD.Visible = True

End If

End Sub

Private Sub cmduser_Click()

AccountsFrm.Show 1, FrmMain

End Sub


AddQuickLaunchItems

'lblUser.Caption = CurrentUser

End Sub

Private Sub AddQuickLaunchItems()

listQuickLaunch.ListItems.Clear

listQuickLaunch.ListItems.Add _

, "AddTime", "Time", "time", "time"


, "AddFaculty", "Faculty", "instructor", "instructor"


107


City of Iriga

, "AddRoom", "Room", "room", "room"


, "AddSubjects", "Subjects", "subjects", "subjects"


, "Addyearlevel", "Year Levels", "yearlevel", "yearlevel"


, "AddSection", "Course", "course", "course"


, "PrintRoomSchedule", "Room Schedule", "roomschedule", "roomschedule"


, "AddDay", "Day", "day", "day"

'listQuickLaunch.ListItems.Add _

, "AddUnit", "Unit", "units", "units"


, "PrintFacultySchedule", "Faculty Schedule", "facultyschedule", "facultyschedule"

108


City of Iriga


, "AddSchedule", "Schedule", "schedule", "schedule"


, "PrintSchedule", "Class Schedule", "printschedule", "printschedule"


, "Logoff", "Log-off", "logoff", "logoff"


, "Shutdown", "Shutdown", "shutdown", "shutdown"

End Sub

Private Sub img2_MouseMove(Button As Integer, Shift As Integer, X As Single, y As Single)

cmduser.Visible = True

cmdRestore.Visible = True

cmdBackup.Visible = True

End Sub

Private Sub listQuickLaunch_Click()

Select Case listQuickLaunch.SelectedItem.Key

Case "AddSection"

FrmSection.Show

Case "Addyearlevel"

FrmYearLevel.Show

109


City of Iriga

Case "AddTime"

FrmTime.Show

Case "AddRoom"

FrmRoom.Show

Case "AddUnit"

FrmUnit.Show

Case "AddFaculty"

FrmFaculty.Show

Case "AddDay"

FrmDay.Show

Case "AddSubjects"

FrmSubjects.Show

Case "AddSchedule"

FrmSchedule.Show

Case "Logoff"

If vbYes = MsgBox("Log-off?", vbQuestion + vbYesNo, "Log-Off") Then

Unload Me

FrmLogin.Show

End If

Case "Shutdown"

If vbYes = MsgBox("Are you Sure you Want to Exit?", vbQuestion + vbYesNo, "Exit!!") Then

End

End If

Case "PrintSchedule"

FrmPrintSchedule.Show

110


City of Iriga

Case "PrintFacultySchedule"

FrmPrintFacultySchedule.Show

Case "PrintRoomSchedule"

FrmPrintRoomSchedule.Show

End Select

End Sub


lblmaintime.Caption = Format(Now, "hh:mm:ss AM/PM")

lblmaindate.Caption = Format(Now, "mmmm dd, yyyy")

End Sub

Private Sub tmr1_Timer()

If bhide = False Then

If picprint.Height >= 3500 Then

'picMenu.Height = 3390

tmr1.Interval = 0

Else

picprint.Height = picprint.Height + 249

Dim bhide As Boolean



Private Sub cmdabout_Click()

FrmAbout.Show

End Sub

111


City of Iriga

Private Sub cmddate_Click()

If Calendar1.Visible = True Then

tmr2.Interval = 10

bhide1 = True

Else

tmr2.Interval = 10

bhide1 = False

Calendar1.Visible = True

End If

End Sub

Private Sub cmdFile_Click()

If picprint.Visible = True Then

tmr1.Interval = 10

bhide = True

Else

tmr1.Interval = 10

bhide = False

picprint.Visible = True

End If

End Sub

Private Sub cmdBackup_Click()

BackupFrm.Show 1, FrmMain

End Sub

112


City of Iriga

Private Sub cmdRestore_Click()


End Sub

Private Sub cmdReyn_Click()

FrmReyn.Show

FrmReyn.Image1.Visible = False



















113


City of Iriga





















End Sub

Private Sub cmdSD_Click()

If pctSD.Visible = True Then

tmr3.Interval = 10

114


City of Iriga

bhide2 = True

Else

tmr3.Interval = 10

bhide2 = False

pctSD.Visible = True

End If

End Sub

Private Sub cmduser_Click()


End Sub


AddQuickLaunchItems

'lblUser.Caption = CurrentUser

End Sub

Private Sub AddQuickLaunchItems()

listQuickLaunch.ListItems.Clear


, "AddTime", "Time", "time", "time"


, "AddFaculty", "Faculty", "instructor", "instructor"

115


City of Iriga


, "AddRoom", "Room", "room", "room"


, "AddSubjects", "Subjects", "subjects", "subjects"


, "Addyearlevel", "Year Levels", "yearlevel", "yearlevel"


, "AddSection", "Course", "course", "course"


, "PrintRoomSchedule", "Room Schedule", "roomschedule", "roomschedule"


, "AddDay", "Day", "day", "day"

'listQuickLaunch.ListItems.Add _

, "AddUnit", "Unit", "units", "units"


, "PrintFacultySchedule", "Faculty Schedule", "facultyschedule", "facultyschedule"

116


City of Iriga


, "AddSchedule", "Schedule", "schedule", "schedule"


, "PrintSchedule", "Class Schedule", "printschedule", "printschedule"


, "Logoff", "Log-off", "logoff", "logoff"


, "Shutdown", "Shutdown", "shutdown", "shutdown"

End Sub

Private Sub img2_MouseMove(Button As Integer, Shift As Integer, X As Single, y As Single)

cmduser.Visible = True

cmdRestore.Visible = True

cmdBackup.Visible = True

End Sub

Private Sub listQuickLaunch_Click()

Select Case listQuickLaunch.SelectedItem.Key

Case "AddSection"

FrmSection.Show

117


City of Iriga

Case "Addyearlevel"

FrmYearLevel.Show

Case "AddTime"

FrmTime.Show

Case "AddRoom"

FrmRoom.Show

Case "AddUnit"

FrmUnit.Show

Case "AddFaculty"

FrmFaculty.Show

Case "AddDay"

FrmDay.Show

Case "AddSubjects"

FrmSubjects.Show

Case "AddSchedule"

FrmSchedule.Show

Case "Logoff"

If vbYes = MsgBox("Log-off?", vbQuestion + vbYesNo, "Log-Off") Then

Unload Me

FrmLogin.Show

End If

Case "Shutdown"

If vbYes = MsgBox("Are you Sure you Want to Exit?", vbQuestion + vbYesNo, "Exit!!") Then

End

End If

118


City of Iriga

Case "PrintSchedule"

FrmPrintSchedule.Show

Case "PrintFacultySchedule"

FrmPrintFacultySchedule.Show

Case "PrintRoomSchedule"

FrmPrintRoomSchedule.Show

End Select

End Sub


lblmaintime.Caption = Format(Now, "hh:mm:ss AM/PM")

lblmaindate.Caption = Format(Now, "mmmm dd, yyyy")

End Sub


If bhide = False Then

If picprint.Height >= 3500 Then


tmr1.Interval = 0

Else

picprint.Height = picprint.Height + 249

End If

119


City of Iriga

Els

If picprint.Height <= 600 Then

picprint.Height = 0

tmr1.Interval = 0

picprint.Visible = False

Else

picprint.Height = picprint.Height - 249

DoEvents

End If

End If

End Sub

Private Sub inlockall()

'picMenu.Visible = False

' bhide = True

' Timer3.Interval = 10

'picMenu.Visible = True

'picSet.Visible = False

' bhide = True


'picSet.Visible = True

'picbut.Visible = False

' bhide = True

'Timer1.Interval = 10

120


City of Iriga

'picbut.Visible = True

'cmdFile.Enabled = False

'cmdSet.Enabled = False

'cmdAbout.Enabled = False

End Sub


If bhide1 = False Then

If Calendar1.Height >= 2500 Then


tmr2.Interval = 0

Else

Calendar1.Height = Calendar1.Height + 249

End If

Else

If Calendar1.Height <= 600 Then

Calendar1.Height = 0

tmr2.Interval = 0

Calendar1.Visible = False

Else

Calendar1.Height = Calendar1.Height - 249

DoEvents

End If

121


City of Iriga

End If

End Sub

Private Sub txtusername_Change()

FrmMain.Visible = True

FrmMainStudent.Visible = False

End Sub



If pctSD.Height >= 2500 Then


tmr3.Interval = 0

Else

pctSD.Height = pctSD.Height + 249

End If

Else

If pctSD.Height <= 600 Then

pctSD.Height = 0

tmr3.Interval = 0

pctSD.Visible = False

Else

pctSD.Height = pctSD.Height - 249

DoEvents

End If

End If

End Sub

122


City of Iriga

Else

If picprint.Height <= 600 Then

picprint.Height = 0

tmr1.Interval = 0

picprint.Visible = False

Else

picprint.Height = picprint.Height - 249

DoEvents

End If

End If

End Sub

Private Sub inlockall()

'picMenu.Visible = False

' bhide = True


'picMenu.Visible = True

'picSet.Visible = False

' bhide = True


123


City of Iriga

'picSet.Visible = True

'picbut.Visible = False

' bhide = True

'Timer1.Interval = 10

'picbut.Visible = True

'cmdFile.Enabled = False

'cmdSet.Enabled = False

'cmdAbout.Enabled = False

End Sub



If Calendar1.Height >= 2500 Then


tmr2.Interval = 0

Else

Calendar1.Height = Calendar1.Height + 249

End If

Else

If Calendar1.Height <= 600 Then

Calendar1.Height = 0

tmr2.Interval = 0

Calendar1.Visible = False

Else

Calendar1.Height = Calendar1.Height - 249

124


City of Iriga

DoEvents

End If

End If

End Sub

Private Sub txtusername_Change()

FrmMain.Visible = True

FrmMainStudent.Visible = False

End Sub



If pctSD.Height >= 2500 Then


tmr3.Interval = 0

Else

pctSD.Height = pctSD.Height + 249

End If

Else

If pctSD.Height <= 600 Then

pctSD.Height = 0

tmr3.Interval = 0

pctSD.Visible = False

Else

pctSD.Height = pctSD.Height - 249

DoEvents

125


City of Iriga

End If

End If

End Sub

DAY FORM

Dim clsData As New clsDay

Dim OLDDay As String

Private Sub cmdAdd_Click()

If cmdAdd.Caption = "&Add" Then

cmdAdd.Caption = "&Save"

Clear

txtSy.SetFocus

Else

If checkfield = False Then

clsData.AddDay txtID, txtSy, cboStat.Text

Unload Me

FrmDay.Show

End If

End If

End Sub


Unload Me

End Sub

Private Sub cmdDelete_Click()

126


City of Iriga

If vbYes = MsgBox("Delete Item?", vbQuestion + vbYesNo, "DELETE?") Then

clsData.DeleteDay txtID

Unload Me

FrmDay.Show

End If

End Sub

Private Sub cmdEdit_Click()


clsData.UpdateDay txtID, txtSy, cboStat.Text, OLDDay

Unload Me

FrmDay.Show

End If

End Sub


clsData.DisplayDay lstDay

txtID = clsData.GetID

If FrmMain.Tag <> "Admin" Then

cmdDelete.Enabled = False

Else

cmdDelete.Enabled = True

End If

End Sub

Function checkfield() As Boolean

127


City of Iriga

checkfield = True

If Trim(txtSy.Text) = "" Then

MsgBox "Don't Leave the Field Empty.", vbCritical, "CAUTION!"

txtSy.SetFocus

Exit Function

ElseIf Trim(cboStat.Text) = "" Then


cboStat.SetFocus

Exit Function

End If

checkfield = False

End Function

Public Sub Clear()


txtSy = ""

cboStat = ""

End Sub

Private Sub lstDay_ItemClick(ByVal Item As MSComctlLib.ListItem)

OLDDay = Item.ListSubItems(1)

txtID = Item.ListSubItems(1)

txtSy = Item.ListSubItems(2)

cboStat = Item.ListSubItems(3)

End Sub

128


City of Iriga

FACULTY FORM

Dim clsData As New clsStudents

Dim OldStudID As String




Lockfalse

Clear

txtLname.SetFocus

Else

If ValidateEntry = False Then

cmdAdd.Caption = "&Add"

Lockfalse

txtLname.SetFocus

clsData.AddFaculty txtID, txtLname, txtFname, txtMname, cbostatus, txtCon

Clear

Unload Me

FrmFaculty.Show 1, FrmMain

End If

End If

End Sub


129


City of Iriga

Unload Me

End Sub


If vbYes = MsgBox("Delete Data?", vbQuestion + vbYesNo, "DELETE?") Then

clsData.DeleteFaculty txtID

Unload Me


End If

End Sub


If cmdEdit.Caption = "&Edit" Then

cmdEdit.Caption = "&Update"

Lockfalse

txtLname.SetFocus

Else


cmdEdit.Caption = "&Edit"

Lockfalse

clsData.UpdateFaculty txtID, txtLname, txtFname, txtMname, cbostatus, txtCon, OldStudID

Clear

Unload Me


End If

130


City of Iriga

End If

End Sub



clsData.DisplayFacInfo lstStudents, ""



Else


End If

End Sub

Function ValidateEntry() As Boolean

ValidateEntry = True

If Trim(txtLname.Text) = "" Then


txtLname.SetFocus

Exit Function

ElseIf Trim(txtFname.Text) = "" Then


txtFname.SetFocus

Exit Function

ElseIf Trim(txtMname.Text) = "" Then


131


City of Iriga

txtMname.SetFocus

Exit Function

ElseIf Trim(cbostatus.Text) = "" Then


txtAdd.SetFocus

Exit Function

ElseIf Trim(txtCon.Text) = "" Then


txtCon.SetFocus

Exit Function

End If

ValidateEntry = False

End Function

Public Sub Clear()


txtLname = ""

txtMname = ""

txtFname = ""

cbostatus = ""

txtCon = ""

'cboSex.Text = ""

'cboSY.Text = ""

'cboCourse.Text = ""

End Sub

132


City of Iriga

Public Sub Lockfalse()

txtLname.Locked = False

txtMname.Locked = False

txtFname.Locked = False

cbostatus.Locked = False

txtCon.Locked = False

End Sub

Private Sub lstStudents_ItemClick(ByVal Item As MSComctlLib.ListItem)

OldStudID = lstStudents.SelectedItem.ListSubItems(1)

txtID = lstStudents.SelectedItem.ListSubItems(1)

txtLname = lstStudents.SelectedItem.ListSubItems(2)

txtFname = lstStudents.SelectedItem.ListSubItems(3)

txtMname = lstStudents.SelectedItem.ListSubItems(4)

cbostatus = lstStudents.SelectedItem.ListSubItems(5)

txtCon = lstStudents.SelectedItem.ListSubItems(6)

End Sub

Private Sub txtCon_KeyPress(KeyAscii As Integer)

If (KeyAscii >= vbKey0 And KeyAscii <= vbKey9) Or KeyAscii = 46 Or KeyAscii = vbKeyBack Then

Else

Beep

KeyAscii = 0

End If

133


City of Iriga

End Sub

Private Sub txtMotherName_Change()

If Trim(txtMotherName.Text) = "" Then

clsData.DisplayFacInfo lstStudents, ""

Else

clsData.DisplayFacInfo lstStudents, txtMotherName.Text

End If

End Sub

ROOM FORM

Dim clsData As New clsRoom

Dim OLDYL As String




Clear

txtSy.SetFocus

Else


clsData.AddRoom txtID, txtSy, cboStat.Text

Unload Me

FrmRoom.Show

134


City of Iriga

End If

End If

End Sub


Unload Me

End Sub



clsData.DeleteRoom txtID

Unload Me

FrmRoom.Show

End If

End Sub



clsData.UpdateRoom txtID, txtSy, cboStat.Text, OLDYL

Unload Me

FrmRoom.Show

End If

End Sub

135


City of Iriga


clsData.DisplayRoom lstYL




Else


End If

End Sub


checkfield = True



txtSy.SetFocus

Exit Function


MsgBox "Don't leave the field empty.", vbCritical, ""

cboStat.SetFocus

Exit Function

End If

checkfield = False

End Function

136


City of Iriga

Public Sub Clear()


txtSy = ""

cboStat = ""

End Sub

Private Sub lstYL_ItemClick(ByVal Item As MSComctlLib.ListItem)

OLDYL = Item.ListSubItems(1)




End Sub

SUBJECT FORM

Dim clsData As New clsSubjects

Dim OLDSY As String




Clear

txtSCode.SetFocus

Else

137


City of Iriga


clsData.AddSubject txtID, txtSCode, txtSName, cboYearLevel.Text, txtunit.Text

Unload Me

FrmSubjects.Show 1, FrmMain

End If

End If

End Sub


Unload Me

End Sub



clsData.DeleteSubject txtID

Unload Me


End If

End Sub


138


City of Iriga


clsData.UpdateSubject txtID, txtSCode, txtSName, cboYearLevel.Text, cbosem.Text, OLDSY

Unload Me


End If

End Sub


clsData.DisplaySubjects lstSY, ""


AddYearLevel



Else


End If

End Sub

Private Sub lstSY_ItemClick(ByVal Item As MSComctlLib.ListItem)

OLDSY = Item.ListSubItems(1)


txtSCode = Item.ListSubItems(2)

txtSName = Item.ListSubItems(3)

cboYearLevel.Text = Item.ListSubItems(4)

cbosem = Item.ListSubItems(5)

139


City of Iriga

End Sub


If Trim(txtMotherName.Text) = "" Then

clsData.DisplaySubjects lstSY, ""

Else

clsData.DisplaySubjects lstSY, txtMotherName.Text

End If

End Sub


checkfield = True

If Trim(txtSCode.Text) = "" Then


txtSCode.SetFocus

Exit Function

ElseIf Trim(txtSName.Text) = "" Then


txtSName.SetFocus

Exit Function

ElseIf Trim(cboYearLevel.Text) = "" Then


cboYearLevel.SetFocus

Exit Function

ElseIf Trim(cbosem.Text) = "" Then


140


City of Iriga

txtunit.SetFocus

Exit Function

End If

checkfield = False

End Function

Public Sub Clear()


txtSCode = ""

txtSName = ""

End Sub

Sub AddYearLevel()

If rs.State = adStateOpen Then rs.Close

msql = " Select * From YearLevel Order By LevelNumerals"

rs.Open msql, conn

cboYearLevel.Clear

Do While Not rs.EOF

cboYearLevel.AddItem rs!LevelNumerals

rs.MoveNext

Loop

End Sub

YEAR LEVEL FORM

Dim clsData As New clsYearLevel

141


City of Iriga

Dim OLDYL As String




Clear

txtSy.SetFocus

Else


clsData.AddYL txtID, txtSy, cboStat.Text

Unload Me

FrmYearLevel.Show

End If

End If

End Sub


Unload Me

End Sub



clsData.DeleteYL txtID

Unload Me

FrmYearLevel.Show

142


City of Iriga

End If

End Sub



clsData.UpdateYL txtID, txtSy, cboStat.Text, OLDYL

Unload Me

FrmYearLevel.Show

End If

End Sub


clsData.DisplayYL lstYL




Else


End If

End Sub


checkfield = True



txtSy.SetFocus

143


City of Iriga

Exit Function



cboStat.SetFocus

Exit Function

End If

checkfield = False

End Function

Public Sub Clear()


txtSy = ""

cboStat = ""

End Sub

Private Sub lstYL_ItemClick(ByVal Item As MSComctlLib.ListItem)

OLDYL = Item.ListSubItems(1)




End Sub

144


City of Iriga

COURSE FORM

Dim clsData As New clsSection

Dim OLDSID As String




Clear

txtYL.SetFocus

Else

If ValidateParentsInfo = False Then

clsData.AddSection txtSNo, txtYL, txtSName

Unload Me

FrmSection.Show

End If

End If

End Sub


Unload Me

End Sub

145


City of Iriga



clsData.DeleteSection txtSNo

Unload Me

FrmSection.Show

End If

End Sub


If ValidateParentsInfo = False Then

clsData.UpdateSection txtSNo, txtYL, txtSName, OLDSID

Unload Me

FrmSection.Show

End If

End Sub


clsData.DisplaySection lstSection, ""

txtSNo = clsData.GetID



Else


End If

End Sub

146


City of Iriga

Function ValidateParentsInfo() As Boolean

ValidateParentsInfo = True

If Trim(txtSNo.Text) = "" Then


txtSNo.SetFocus

Exit Function

ElseIf Trim(txtYL.Text) = "" Then


txtYL.SetFocus

Exit Function

ElseIf Trim(txtSName.Text) = "" Then


txtSName.SetFocus

Exit Function

End If

ValidateParentsInfo = False

End Function

Private Sub jcbutton1_Click()

SearchYLFrm.Show 1

'txtYL = TempLevelNo

End Sub

Private Sub lstSection_ItemClick(ByVal Item As MSComctlLib.ListItem)

OLDSID = Item.ListSubItems(1).Text

147


City of Iriga

txtSNo = Item.ListSubItems(1).Text

txtYL = Item.ListSubItems(2).Text

txtSName = Item.ListSubItems(3).Text

End Sub

Public Sub Clear()

txtSNo = clsData.GetID

txtYL = ""

txtSName = ""

End Sub


If Trim(txtMotherName) = "" Then

clsData.DisplaySection lstSection, ""

Else

clsData.DisplaySection lstSection, txtMotherName.Text

End If

End Sub

PRINT ROOM SCHEDULE

Dim clsData As New clsSchedule

Private Sub cboRoom_Change()

clsData.DisplayRoomSchedule lstSY, cboRoom.Text

End Sub

Private Sub cboRoom_Click()

148


City of Iriga

clsData.DisplayRoomSchedule lstSY, cboRoom.Text

End Sub


Unload Me

End Sub

Sub AddRoom()


msql = " Select * From MyRoom Order By RoomNumber"

rs.Open msql, conn

cboRoom.Clear

Do While Not rs.EOF

cboRoom.AddItem rs!RoomNumber

rs.MoveNext

Loop

End Sub



clsData.DeleteSchedule lstSY.SelectedItem.ListSubItems(1)

Unload Me

FrmPrintRoomSchedule.Show 1, FrmMain

End If

End Sub

149


City of Iriga

Private Sub cmdPrint_Click()

If cboRoom.Text = "" Then

MsgBox " Please Select Room Number.", vbInformation, "Print"

cboRoom.SetFocus

Else

clsData.PrintRoomSchedule cboRoom.Text

End If

End Sub


AddRoom



Else


End If

End Sub

DAY FORM

Dim clsData As New clsDay

Dim OLDDay As String



150


City of Iriga


Clear

txtSy.SetFocus

Else


clsData.AddDay txtID, txtSy, cboStat.Text

Unload Me

FrmDay.Show

End If

End If

End Sub


Unload Me

End Sub



clsData.DeleteDay txtID

Unload Me

FrmDay.Show

End If

End Sub


151


City of Iriga


clsData.UpdateDay txtID, txtSy, cboStat.Text, OLDDay

Unload Me

FrmDay.Show

End If

End Sub


clsData.DisplayDay lstDay




Else


End If

End Sub


checkfield = True



txtSy.SetFocus

Exit Function



152


City of Iriga

cboStat.SetFocus

Exit Function

End If

checkfield = False

End Function

Public Sub Clear()


txtSy = ""

cboStat = ""

End Sub

Private Sub lstDay_ItemClick(ByVal Item As MSComctlLib.ListItem)

OLDDay = Item.ListSubItems(1)




End Sub

PRINT FACULTY SCHEDULE FORM



Unload Me

End Sub

153


City of Iriga




Unload Me

FrmPrintFacultySchedule.Show 1, FrmMain

End If

End Sub


If Trim(txtName.Text) <> "" Then

clsData.PrintFacultySchedule txtName.Text

Else

MsgBox " Please Enter Faculty Name.", vbInformation, ""

End If

End Sub

Private Sub cmdSearch_Click()

FrmSearchFaculty.Show 1

End Sub


clsData.DisplayFacultySchedule lstSY, ""

End Sub

Private Sub txtName_Change()

If Trim(txtName.Text) = "" Then

clsData.DisplayFacultySchedule lstSY, ""

154


City of Iriga

Else

clsData.DisplayFacultySchedule lstSY, txtName.Text

End If

End Sub

SCHEDULE FORM


Private Sub cboDay_Change()

'clsData.DisplayFilterSchedule lstSY, cboTime.Text, cboRoom.Text, cboDay.Text

End Sub

Private Sub cboDay_Click()


End Sub

Private Sub cboFilterSection_Change()

clsData.DisplayScheduleByYearAndSection lstSchedules, cboFilterYear.Text, cboFilterSection.Text

End Sub

Private Sub cboFilterSection_Click()


End Sub

Private Sub cboFilterYear_Change()

AddFilterSection


155


City of Iriga

End Sub

Private Sub cboFilterYear_Click()

AddFilterSection


End Sub

Private Sub cboRoom_Change()


End Sub

Private Sub cboRoom_Click()


End Sub

Private Sub cboTime_Change()


End Sub

Private Sub cboTime_Click()


End Sub

Private Sub cboYearLevel_Change()

AddSection

End Sub

Private Sub cboYearLevel_Click()

AddSection

End Sub


156


City of Iriga

'If cmdAdd.Caption = "&Add" Then

'cmdAdd.Caption = "&Save"

'Clear

'txtSpan.SetFocus

lblID.Caption = clsData.GetID

'Else

'If FacultyInUse = False And RoomInUse = False Then

If DataInUse = False Then


clsData.AddSchedule lblID.Caption, cboTime.Text, cboFaculty.Text, cboSubject.Text, cboRoom.Text, cboDay.Text, cboYearLevel.Text, cboSection.Text

Unload Me

FrmSchedule.Show 1, FrmMain

'Else

' MsgBox "error", vbInformation, ""

End If

'End If

End Sub

Function DataInUse() As Boolean

DataInUse = True

If FacultyInUse = True Then

MsgBox "Faculty is Currently Unavailable.", vbInformation, "CAUTION!"

cboFaculty.SetFocus

157


City of Iriga

DisplayFacultyInUse

DisplayLabelConflictForFaculty

Exit Function

ElseIf RoomInUse = True Then

MsgBox "Room is Currently Unavailable.", vbInformation, "CAUTION!"

cboRoom.SetFocus

DisplayRoomInUse

DisplayLabelConflictForRoom

Exit Function

ElseIf SectionInUse = True Then

MsgBox "Course is Currently Unavailable.", vbInformation, "CAUTION"

cboSection.SetFocus

DisplaySectionInUse

DisplayLabelConflictForSection

Exit Function

End If

DataInUse = False

End Function


Unload Me

End Sub



clsData.DeleteSchedule lstSchedules.SelectedItem.ListSubItems(1)

Unload Me

158


City of Iriga


End If

End Sub


AddTime

AddFaculty

AddSubjects

AddRoom

AddDay

AddYearLevel


'clsData.DisplaySchedule lstSY



Else


End If

End Sub

Sub AddYearLevel()



rs.Open msql, conn

cboYearLevel.Clear

cboFilterYear.Clear

Do While Not rs.EOF

159


City of Iriga


cboFilterYear.AddItem rs!LevelNumerals

rs.MoveNext

Loop

End Sub

Sub AddTime()


msql = " Select * From MyTime Order By TimeSpan"

rs.Open msql, conn

cboTime.Clear

Do While Not rs.EOF

cboTime.AddItem rs!TimeSpan

rs.MoveNext

Loop

End Sub

Sub AddFaculty()


msql = " Select * From Faculty Order By LName"

rs.Open msql, conn

cboFaculty.Clear

Do While Not rs.EOF

cboFaculty.AddItem rs!Lname & ", " & rs!Fname

rs.MoveNext

Loop

End Sub

160


City of Iriga

Sub AddSubjects()


msql = " Select * From Subject Order By SubjectName"

rs.Open msql, conn

cboSubject.Clear

Do While Not rs.EOF

cboSubject.AddItem rs!SubjectName

rs.MoveNext

Loop

End Sub

Sub AddRoom()


msql = " Select * From MyRoom Order By RoomNumber"

rs.Open msql, conn

cboRoom.Clear

Do While Not rs.EOF

cboRoom.AddItem rs!RoomNumber

rs.MoveNext

Loop

End Sub

Sub AddDay()


msql = " Select * From MyDay Order By DayInitial"

rs.Open msql, conn

cboDay.Clear

161


City of Iriga

Do While Not rs.EOF

cboDay.AddItem rs!DayInitial

rs.MoveNext

Loop

End Sub

Sub AddSection()


msql = " Select * From Sections Where LevelNumber='" & cboYearLevel.Text & "' Order By SectionName"

rs.Open msql, conn

cboSection.Clear

Do While Not rs.EOF

cboSection.AddItem rs!SectionName

rs.MoveNext

Loop

End Sub

Sub AddFilterSection()


msql = " Select * From Sections Where LevelNumber='" & cboFilterYear.Text & "' Order By SectionName"

rs.Open msql, conn

cboFilterSection.Clear

Do While Not rs.EOF

cboFilterSection.AddItem rs!SectionName

rs.MoveNext

Loop

162


City of Iriga

End Sub


If DataInUse = False Then

clsData.UpdateSchedule lblID.Caption, cboTime.Text, cboFaculty.Text, cboSubject.Text, cboRoom.Text, cboDay.Text, cboYearLevel.Text, cboSection.Text

Unload Me


End If

End Sub


Unload Me


End Sub

Private Sub lstSchedules_ItemClick(ByVal Item As MSComctlLib.ListItem)

lblID.Caption = Item.ListSubItems(1)

cboTime.Text = Item.ListSubItems(2)

cboFaculty.Text = Item.ListSubItems(3)

cboSubject.Text = Item.ListSubItems(4)

cboRoom.Text = Item.ListSubItems(5)

cboDay.Text = Item.ListSubItems(6)

cboYearLevel.Text = Item.ListSubItems(7)

cboSection.Text = Item.ListSubItems(8)

163


City of Iriga

'txtunit.Text = Item.ListSubItems(9)

cmdAdd.Enabled = False

End Sub

Function FacultyInUse() As Boolean


msql = " Select * from ClassSchedule Where cTime like'" & cboTime.Text & "%' and cFaculty like'" & cboFaculty.Text & "%' and cDay like '" & cboDay.Text & "'"

rs.Open msql, conn

If rs.RecordCount >= 1 Then

FacultyInUse = True

Else

FacultyInUse = False

End If

End Function

Sub DisplayFacultyInUse()

Dim lstItem As ListItem, a As Integer


'msql = " Select * from ClassSchedule Where cTime like'" & cboTime.Text & "%' and cFaculty like'" & cboFaculty.Text & "%' and cDay like '" & cboDay.Text & "'"

msql = " SELECT ClassSchedule.ID, ClassSchedule.cTime, ClassSchedule.cFaculty, ClassSchedule.cSubjects, ClassSchedule.cRoom, ClassSchedule.cDay, ClassSchedule.cYearLevel, ClassSchedule.cSection" & _

" From ClassSchedule" & _

" Where ClassSchedule.cFaculty='" & cboFaculty.Text & "'" & _

164


City of Iriga

" GROUP BY ClassSchedule.ID, ClassSchedule.cTime, ClassSchedule.cFaculty, ClassSchedule.cSubjects, ClassSchedule.cRoom, ClassSchedule.cDay, ClassSchedule.cYearLevel, ClassSchedule.cSection" & _

" ORDER BY ClassSchedule.ID;"

rs.Open msql, conn

lstSY.ListItems.Clear

Do While Not rs.EOF

a = a + 1

Set lstItem = lstSY.ListItems.Add(, , a)

lstItem.SubItems(1) = rs(0).Value








rs.MoveNext

Loop

End Sub

Function RoomInUse() As Boolean


msql = " Select * from ClassSchedule Where cTime like'" & cboTime.Text & "%' and cRoom like'" & cboRoom.Text & "%'and cDay like '" & cboDay.Text & "'"

165


City of Iriga

rs.Open msql, conn


RoomInUse = True

Else

RoomInUse = False

End If

End Function

Sub DisplayRoomInUse()






" Where ClassSchedule.cRoom='" & cboRoom.Text & "'" & _



rs.Open msql, conn


Do While Not rs.EOF

a = a + 1



166


City of Iriga








rs.MoveNext

Loop

End Sub

Function SectionInUse() As Boolean


msql = " Select * from ClassSchedule Where cTime like'" & cboTime.Text & "%' and cSection like'" & cboSection.Text & "%' and cDay like '" & cboDay.Text & "'"

rs.Open msql, conn


SectionInUse = True

Else

SectionInUse = False

End If

End Function

Sub DisplaySectionInUse()



167


City of Iriga




" Where ClassSchedule.cSection='" & cboSection.Text & "'" & _



rs.Open msql, conn


Do While Not rs.EOF

a = a + 1










rs.MoveNext

Loop

168


City of Iriga

End Sub

Sub DisplayLabelConflictForFaculty()

If lstSY.ListItems.Count >= 1 Then

lblConflict.Caption = " Conflict Schedules For: " & cboFaculty.Text

Else

lblConflict.Caption = "NO Concflict"

End If

End Sub

Sub DisplayLabelConflictForRoom()


lblConflict.Caption = " Conflict Schedules For Room: " & cboRoom.Text

Else


End If

End Sub

Sub DisplayLabelConflictForSection()


lblConflict.Caption = " Conflict Schedules For Course: " & cboSection.Text

Else


End If

End Sub

Private Sub txtunit_Change()


169


City of Iriga

End Sub

PRINT SCHEDULE FORM


Private Sub cboDay_Change()

clsData.DisplayScheduleByDay lstSY, cboDay.Text

End Sub

Private Sub cboDay_Click()

clsData.DisplayScheduleByDay lstSY, cboDay.Text

End Sub

Private Sub cboSection_Change()

clsData.DisplayScheduleByYearAndSection lstSY, cboYearLevel.Text, cboSection.Text

End Sub

Private Sub cboSection_Click()


End Sub

Private Sub cboYearLevel_Change()

AddSection


End Sub

Private Sub cboYearLevel_Click()

170


City of Iriga

AddSection


End Sub


Unload Me

End Sub




Unload Me

FrmPrintSchedule.Show 1, FrmMain

End If

End Sub


If optionDay.Value = True Then

If cboDay.Text = "" Then

MsgBox "Please Select Day.", vbCritical, "CAUTION"

Else

clsData.PrintScheduleByDay cboDay.Text

End If

171


City of Iriga

Else

If Option1.Value = True Then

If cboYearLevel.Text = "" Or cboSection.Text = "" Then

MsgBox "Please Select Yearlevel and Course.", vbCritical, "CAUTION!"

Else

clsData.PrintScheduleByYearAndSection cboYearLevel.Text, cboSection.Text

End If

End If

End If

'clsData.PrintSchedule

End Sub


'clsData.DisplaySchedule lstSY

AddYearLevel

AddDay



Else


End If

End Sub

Sub AddYearLevel()



172


City of Iriga

rs.Open msql, conn

cboYearLevel.Clear

'cboYearLevel.AddItem "All"

Do While Not rs.EOF


rs.MoveNext

Loop

End Sub

Sub AddSection()


msql = " Select * From Sections Where LevelNumber='" & cboYearLevel.Text & "' Order By SectionName"

rs.Open msql, conn

cboSection.Clear

'cboSection.AddItem "All"

Do While Not rs.EOF

cboSection.AddItem rs!SectionName

rs.MoveNext

Loop

End Sub

Sub AddDay()


msql = " Select * From MyDay Order By DayInitial"

rs.Open msql, conn

cboDay.Clear

Do While Not rs.EOF

173


City of Iriga

cboDay.AddItem rs!DayInitial

rs.MoveNext

Loop

End Sub


Frame3.Visible = False

Frame2.Visible = True

cboDay.ListIndex = -1

End Sub

Private Sub optionDay_Click()

Frame3.Visible = True

Frame2.Visible = False

cboYearLevel.ListIndex = -1

cboSection.ListIndex = -1

End Sub

ACCOUNT(s) FORM

Option Explicit

Dim clsData As New clsUsers

Dim OldID As String

Private Sub cmdClose_Click()

Unload Me

174


City of Iriga

End Sub


'If rAdd = False Then MsgBox "Access Denied. The operation is not allowed", vbCritical, "Restriction": Exit Sub



Lockfalse

Clear

Else


cmdAdd.Caption = "&Add"

txtUser.SetFocus

Lockfalse

clsData.AddUser txtUser, txtpass, cbotype.Text

Clear

Unload Me


End If

End If

End Sub


Unload Me

End Sub

175


City of Iriga


'If rDelete = False Then MsgBox "Access Denied. The operation is not allowed", vbCritical, "Restriction": Exit Sub

If txtUser = "" Then Exit Sub

If txtUser = CurrentUser Then

MsgBox "Can't Delete Your Own Profile.", vbCritical, "RESTRICTION!"

Else

If vbYes = MsgBox("Are you Sure You Want to Delete this User" & vbCrLf & "Username: " & OldID, vbQuestion + vbYesNo, "DELETE?") Then

clsData.DeleteUser txtUser

End If

End If

Unload Me


End Sub


Lockfalse

txtUser.SetFocus

End Sub

Private Sub cmdUpdate_Click()

'If rUpdate = False Then MsgBox "Access Denied. The operation is not allowed", vbCritical, "Restriction": Exit Sub


176


City of Iriga

clsData.UpdateUser txtUser, txtpass, cbotype, OldID

Unload Me


End If

End Sub

Private Sub Form_Activate()

Set clsData = New clsUsers

clsData.DisplayUsers lstUser

Warna_Row_Listview lstUser, &HC0FFFF, vbWhite

End Sub

Public Sub Lockfalse()

txtUser.Locked = False

txtpass.Locked = False

txtVerify.Locked = False

cbotype.Locked = False

End Sub

Public Sub Clear()

txtUser = ""

txtpass = ""

txtVerify = ""

cbotype.ListIndex = 0

177


City of Iriga

End Sub

Public Function ValidateEntry() As Boolean

ValidateEntry = True

If Trim(txtUser) = "" Then

MsgBox "Please Enter Username", vbInformation, ""

Exit Function

ElseIf Trim(txtpass) <> Trim(txtVerify) Then

MsgBox "Password Mismatch.", vbInformation, "CAUTION!"

Exit Function

End If

ValidateEntry = False

End Function

Private Sub lstUser_ItemClick(ByVal Item As MSComctlLib.ListItem)

'Dim a As Boolean, b As Boolean, c As Boolean, d As Boolean

OldID = Item.ListSubItems(1).Text

txtUser = Item.ListSubItems(1).Text

txtpass = Item.ListSubItems(5).Text

txtVerify = Item.ListSubItems(5).Text

cbotype.Text = Item.ListSubItems(2).Text

clsData.GetUserPrivileges txtUser, UserTitle

End Sub

Private Sub Warna_Row_Listview(LST1 As ListView, ByVal BackColorOne As OLE_COLOR, ByVal BackColorTwo As OLE_COLOR)

178


City of Iriga

Dim lH As Long

Dim lSM As Byte

Dim picTMP As PictureBox

With LST1

If .View = lvwReport And .ListItems.Count Then

Set picTMP = Me.Controls.Add("VB.PictureBox", "picTMP")

lSM = .Parent.ScaleMode

.Parent.ScaleMode = vbTwips

.PictureAlignment = lvwTile

lH = .ListItems(1).Height

With picTMP

.BackColor = BackColorOne

.AutoRedraw = True

.Height = lH * 2

.BorderStyle = 0

.Width = 10 * Screen.TwipsPerPixelX

picTMP.Line (0, lH)-(.ScaleWidth, lH * 2), BackColorTwo, BF

Set LST1.Picture = .Image

End With

Set picTMP = Nothing

Me.Controls.Remove "picTMP"

LST1.Parent.ScaleMode = lSM

End If

End With

End Sub

179


City of Iriga

BACKUP FORM

Private Declare Sub Sleep Lib "Kernel32" (ByVal dwMilliseconds As Long)


Unload Me

End Sub


DataBackup

End Sub

Private Sub Dir1_Change()

Dir1_Click

End Sub

Private Sub Dir1_Click()

On Error GoTo hell:

File1.Path = Dir1.Path

txtBackupPath = Dir1.Path

180


City of Iriga

Exit Sub

hell:

MsgBox " Error drive is not accessible", vbInformation, "CAUTION!"

Drive1.Drive = "c:"

End Sub

Private Sub Drive1_Change()

On Error GoTo heaven

Dir1.Path = Drive1.Drive

Exit Sub

heaven:

MsgBox " Error Drive is not Accessible", vbInformation, "CAUTION!"

Drive1.Drive = "c:"

End Sub

Sub DataBackup()

Dim FS As New FileSystemObject, a As Integer

'ProgressBar1.Value = 0

FS.CopyFile App.Path & "\data.mdb", txtBackupPath & "\Class" & File1.ListCount & ".junkit", True

'For a = 1 To 10

'DoEvents

Sleep 500

' ProgressBar1 = ProgressBar1 + 10

' BackupFrm.Height = 6240

'Next

Set FS = Nothing

MsgBox "Backup Successful", vbInformation, "Success"

181


City of Iriga

'BackupFrm.Height = 5520


Exit Sub

End Sub

RESTORE FORM

Private Declare Sub Sleep Lib "Kernel32" (ByVal dwMilliseconds As Long)


Unload Me

End Sub


RestoreData

End Sub

Private Sub Dir1_Change()

On Error GoTo hell1

File1.Path = Dir1.Path

Exit Sub

hell1:

MsgBox "Error Drive is not Accessible", vbInformation, ""

182


City of Iriga

Drive1.Drive = "c:"

End Sub

Private Sub Drive1_Change()

On Error GoTo hell2

Dir1.Path = Drive1.Drive

Exit Sub

hell2:

MsgBox "Error Drive is not Accessible", vbInformation, ""

Drive1.Drive = "c:"

End Sub

Private Sub File1_Click()

txtBackupPath = File1.Path & "\" & File1.FileName

End Sub

Sub RestoreData()

Dim FS As New FileSystemObject, a As Integer

If Trim(txtBackupPath) = "" Then MsgBox "Please Choose Filename of Database you Want to Restore.", vbInformation, "CAUTION!": Exit Sub


FS.CopyFile txtBackupPath, App.Path & "\Data.mdb", True

'For a = 1 To 10

'DoEvents

'Sleep 500

' ProgressBar1 = ProgressBar1 + 10

'RestoreFrm.Height = 6240

183


City of Iriga

'Next

MsgBox "Restore Successful", vbInformation, ""

Set FS = Nothing

'RestoreFrm.Height = 5520


Exit Sub

End Sub


Unload Me


End Sub

ABOUT FORM

Private Sub cmdback_Click()

FrmMain.Show

Unload Me

End Sub

184


City of Iriga

CURRICULUM VITAE

185


City of Iriga

CURRICULUM VITAE

NAME: Reynaldo Fillone Qunido

COURSE/YEAR: BS in Computer Science

ADDRESS: Zone 3, Agos Bato, Camarines Sur

CLASSIFICATION: Undergraduate

AGE: 20

DATE OF BIRTH: July 01, 1991

PLACE OF BIRTH: Dr. Jose Favilla Memorial Hospital (Manila)

STATUS: Single

RELIGION: Roman Catholic

GENDER: Male

NATIONALITY: Filipino

CONTACT NUMBER: !.!.!.!.!.!.!.!.!.!.!

EMAIL ADDRESS: [email protected]

EDUCATIONALATTAINMENT

ELEMENTARY: Bato North Central School

Tress Reyes Bato,Camarines Sur

SECONDARY: Nabua National High School

San Miguel, Nabua, Camarines Sur

TERTIARY: University of Saint Anthony

San Miguel, Iriga City

186


City of Iriga

CURRICULUM VITAE

NAME: Victor Realubit Ablan

COURSE/YEAR: BS in Computer Science

ADDRESS: Zone 5, San Agusin Libon Albay


AGE: 20

DATE OF BIRTH: August 7, 1991

PLACE OF BIRTH: Matacon Polangui Albay

STATUS: Single

RELIGION: Roman Catholic

GENDER: Male

NATINALITY: Filipino

CONTACT NUMBER: 094*49*548*



ELEMENTARY: San Agustin Integrated School

San Agustin Libon Albay

SECONDARY: Polangui General Comprehensive High School

Polangui Albay



187


City of Iriga

CURRICULUM VITAE

NAME: Mark Joseph A. Naldo

COURSE/YEAR: BS Computer Science

ADDRESS: #560 Balintawak St. San Isidro Iriga City


DATE OF BIRTH: March 12, 1991

PLACE OF BIRTH: Novaliches, Quezon City

STATUS: Single


CONTACT NUMBER: 0948937761



ELEMENTARY: Iriga Seventh-day Adventist Multi-grade School

San Nicolas, Iriga City

SECONDARY: University of Saint Anthony




188


City of Iriga

189


City of Iriga

CURRICULUM VITAE

NAME: Norvic B. Ocile

COURSE/YEAR: BS Computer Science

ADDRESS: San Miguel, Iriga City


DATE OF BIRTH:

PLACE OF BIRTH:

STATUS: Single


CONTACT NUMBER: 09*****F*c*



ELEMENTARY: University of Saint Anthony


SECONDARY: University of Saint Anthony




190

ablan's thesis2

Documents