Documentation 1 - Copy

(1)

COMPUTERIZED GRADING SYSTEM

Libertad National High School

Libertad, Abulug, Cagayan

A Project Proposal

Presented to the Faculty

Of the College of Information Technology

International School of Asia and the Pacific

Alimannao Hills, Penablanca, Cagayan

In Partial Fulfillment of the Requirements for the Degree

Bachelor of Science in Information Technology

Presented by:

Rhea A. Tingle

Trofie C. Raña

(2)

LIBERTAD NATIONAL HIGH SCHOOL

COMPUTERIZED GRADING SYSTEM

A Project Proposal

Presented to the Faculty

Of the College of Information Technology

International School of Asia and the Pacific

Alimannao Hills, Penablanca, Cagayan

In Partial Fulfillment of the Requirements for the Degree

Bachelor of Science in Information Technology

Presented by:

Rhea A. Tingle

Trofie C. Raña

(3)

iii

APPROVAL SHEET

March 2011

In partial fulfillment of the requirements for the degree BACHELOR OF SCIENCE IN

INFORMATION TECHNOLOGY, this thesis entitled “Libertad National High School

Computerized Grading System”, has been prepared by Rhea A. Tingle and Trofie C. Raña.

____________________

Adviser

Approved by the tribunal of the Oral Examination

____________________

Panel Member

Accepted as partial fulfillment of the requirements for the degree Bachelor of

Science in Information Technology.

___________________________________

Program Coordinator

(4)

iv

ACKNOWLEDGEMENT

The researcher‟s wishes to extend their sincerest appreciation to the Principal of

the LIBERTAD NATIONAL HIGH SCHOOL, Abulug, Cagayan, Teacher and Students for their

concern and assistance to the researchers work made it a success.

Special acknowledgement to their subject teachers of the INTERNATIONAL SCHOOL

OF ASIA AND THE PACIFIC for their patience and advices.

(5)

v

DEDICATION

This study is dedicated to the Teachers and Students of the LIBERTAD NATIONAL

HIGH SCHOOL for a better performance and analization of their performances.

Also dedicated to the researchers, as a requirement for their subject at the

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC.

(6)

vi

APPROVAL SHEET ... iii

ACKNOWLEDGEMENT ... Error! Bookmark not defined.

DEDICATION ... iv

TABLE OF CONTENTS ... iv

CHAPTER I- Background of the Study ... 1

Introduction ... 1

Statement of the Problem ... 1

Objectives of the Study ... 3

Significance of the Study ... 4

Scope and delimitation ... 4

Methodology of the Study ... 4

Definition of Terms ... 7

Schedule of the Study ... 7

CHAPTER II – Analysis and Presentation... 10

History ... 10

Functions and Objectives of the Organization ... 10

Organizational Chart ... 11

Flow Chart Symbol ... 13

Flow Chart of the Present System ... 16

CHAPTER III – The Proposed System ... 17

Description of the Proposed System ... 17

Flow Chart of the Proposed System ... 17

Input-Process-Output Diagram ... 18

Hierarchical Input-Process-Output Diagram ... 19

Entity Relationship Diagram ... 21

Cost Benefit Analysis ... 22

Schedule of the Proposed System ... 26

CHAPTER IV - Program... 27

(7)

vii

Screen Shots ... 27

Code ... 39

CHAPTER V – Conclusion and Reccomendation ... 27

Conclusion ... 84

(8)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 1

Chapter I: Background of the Study

CHAPTER I

BACKGROUND OF THE STUDY

Introduction

Computer world is now at our hands, this give improvement and development

of all programs in the different agencies, in offices and in schools. Paper work become

easy, computation is faster, record keeping and bringing out is fast. In schools, all works

became easily fast to look at record, easily to reproduce student record. Since,

computation of grades is one burden of the teachers, computerization made the answer in

solving, in recording and computing students performances and achievement. The same is

through in keeping records and forms incorporated in their work aside from guidance and

advice.

Computation of grades in school became easy for modern teacher but for traditional

one they found difficult but now no burden in recording, transmitting, giving the equivalent

and the final grades for teachers who are computer literate, where time, effort and energy

is minimized.

This is the point of this study, to device a program in order to ease the computation

of grades and ranking the students basing their subject‟s performances. This is now the

scenario and dilemma of LIBERTAD NATIONAL HIGH SCHOOL.

(9)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 2

Chapter I: Background of the Study

Now, with the technology which is to be developed, it will enable them to do more

with less effort. The program will not continuously find way to improve and expedite the

calculation of grades.

The use of computer nowadays is necessary to replace the manual system that

affects efficiency and effectiveness, accuracy and reliability.

(10)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 3

Chapter I: Background of the Study

Statement of the Problem

The upgrading of the LIBERTAD NATIONAL HIGH SCHOOL will facilitate the teachers

in preparing grades, submitting grading sheets thus lesser time to prepare High School

Card to deliver to Parents during Card Day. Effort is lessened due to immediate inputting of

data to each student in their records prepared earlier in enrollment, thus gives automatic

computation of the equivalence, summing up and multiplied to its percentage for the final

grade.

This device is for all teachers to record all the required data needed for the

component on the grading system. The final grade comes out. This system is truly

organized because all the required data is pre-programmed and settled and as a result,

computation is facilitated and made easier and aside from this all records, data can be save

and keep.

For the student, in order to understand easily the grading system, the teacher

explains the operation in the computation of their grades.

(11)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 4

Chapter I: Background of the Study

Objectives of the Study

General Objective:



To have a base system of grade computation of the LIBERTAD NATIONAL HIGH

SCHOOL. This aims to lessen the time and effort in computing grades.



Accurate and faster manipulating of data.

Specific Objective:



Manipulate data easily.



Find/copy other data easier and faster.



Fast tracking in the checking of the grading sheets.



Lesser time in monitoring the preparation of grading sheets.

Significance of the Study

This study is beneficial on the part of the direct recipient, and the researchers itself.

Scope and delimitation

Scope

The computerized grading system provides faculty staffs/teachers a faster and more

accurate way of grade computation. This system is an enhanced way provided for the

teachers of Libertad National High School for an easier way and ease of access of student

grade computation and assessment.

(12)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 5

Chapter I: Background of the Study

Delimitation



Fast application process.



Fast in tracking and manipulating of grade.



Lessen the time in the preparation of grading sheets.



Lesser time and effort in importing grade and other data.

Methodology of the Study

In this study, descriptive method is use; to do this the researchers issued

questionnaires of the grading system of the different subject areas of LIBERTAD NATIONAL

HIGH SCHOOL. It includes visitation, observation of the work environment and interview.

Site Visit

To have a clearer background, the researchers visited the location of the school,

LIBERTAD NATIONAL HIGH SCHOOL at Barangay Libertad, Abulug, Cagayan and see the

Computer Laboratory of the School.

Interview

It is a kind of collecting information or data from an individual face to face.

The researchers interview the teacher‟s computer teacher and principal of the school as to

the system of grading used by the school.

(13)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 6

Chapter I: Background of the Study

Observation

The researchers observe the teachers in manually recording computing and

transmitting the grades obtain by the students in the class record to the grading sheet for

checking at the office.

Data Gathering

In order to arrive a good output, the researchers gathered data by the descriptive

Method of Research. In this method, researchers used descriptive survey through the

questionnaires floated to respondents, the school teachers and students, so that

researchers can gather important data and information regarding to the study that cannot

ask verbally.

Internet Surfing

The Department of Education Website is used in gathering some data needed

(14)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 7

Chapter I: Background of the Study

Definition of Terms

To better understand this study, listed below are terms, which are used by the

Researchers in pursuing this study:



Analysis – the process of examining a problem and its element using a define

procedure.



Computer – an electronic device capable of accepting data, performing arithmetic

and logical procedure.



Computerized – refers to that system that carries control or it s conducted by

means or computer.



Data - collection of facts in the forms of figure, members and symbols, letters,

name, etc.



Database – an organized have related information for future references.



Documentation – the collecting, abstracting, and coding have of information for

future references.



Fields – single item of information about a person, place, or thing such s name,

address, etc.



Form – a class referring to an object as the controls in graphical interface.



Information – pertains to the data and knowledge obtained from investigation,

study or instruction.

(15)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 8

Chapter I: Background of the Study



Input – the data entered by the user, which is being transformed into meaningful

operation.



Manual System – the process of doing or operating a certain thing involving the

hands or physical force utilizing more efforts in performing.



Proposal – a suggestion presented to accepting or reflecting and providing the

results of the process.



Researchers – the person involved in the study.



Reports – printed output as user generated.



System Analysis – the analysis, design, development, and implementation of

computer based information system.



System – it is a collection of machines, methods organized to accomplish a set of

(16)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 9

Chapter I: Background of the Study

Schedule of the Study

Gant Chart of the Schedule of the Study

Activities

JUNE

JULY

AUGUST

SEPTEMBER

Week Number

1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4

Data Gathering

Problem

Definition

Project Planning

System Analysis

System Design

Prototype

Encoding

Documentation

System Testing

Implementation

System

Evaluation

(17)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 10

Chapter II: Analysis and Presentation

CHAPTER II

ANALYSIS AND PRESENTATION

History

The School was founded in 1967 through the joint efforts of Ex-Vice Mayor of

Abulug, Mr. Antonio Dumayas(Deceased) with Dr. Felina G. Castillejos as School

Administrator, the Libertad Barrio Council headed by Barrio Captain Rodrigo Asejo at the

PTA Officials.

The area of 18,125 square meters located opposite the Office of Department of

Public Works and Highway, Second District of Cagayan, through President Proclamation

number 699 last July 1989.The Administrator was:

1967-1968

Mrs. Felina Gummayen

1968-1970

Mr. Eladio Miranda

1970-1977

Mr. Pedro Agaceta

1977-1980

Mr. Pricilla Fernandez

1980-1982

Mr. Wilfredo P. Agustin

1982-2001

Mrs. Paz F. Tagoc

2001-2003

Mr. Abraham C. Acosta

2003-present

Mrs. Priscilla T. Pacis

(18)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 11

Chapter II: Analysis and Presentation

Functions and Objectives of the Organization

The Libertad National High School is a learning institution for the Basic Education

with competent Teachers and supportive Parents and Community, who works together as a

team to mould unique child towards the total development of his multiple intelligence in a

caring and nurturing environment.

Vision

We shall strive for our school to be known for its student who are

multitalented and whose motivations, aspirations, manners and dealings manifest a high

degree of excellence who will be developed by teachers who are good models of virtues

and who are creative, self-propelled, and innovative together with parents and community

who are cooperative and supportive in a caring and nurturing environment.

Mission

The Libertad National High School is a learning institution for the Basic Education

with competent teachers and supportive parents and community who work together as a

team to mould each unique child towards the total development of his multiple intelligence

in a caring and nurturing environment.

(19)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 12

Chapter II: Analysis and Presentation

(20)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 13

Chapter II: Analysis and Presentation

Flow Chart Symbol

Terminal Block. This symbol is used to mark the start and

end of the list of instruction. Start is used to mark the

starting point and the End is used to mark the end of the

flowchart.

Input/output Block. The parallelogram symbol is used for

input and output instructions. For input, the instruction that

can be used is Read or Input, followed by a list of variables

separated by a comma. For output, the instruction that can

be used is Display or Print, followed by a list of variables

and/or text that will be displayed or printed.

Processing Block. This symbol is used to process

calculations. Formulas are usually entered in this section of

the flowchart. Formulas include variables that will be

replaced by figures entered by the user. Activities that are to

be performed are also included.

Decision Block. A diamond shaped symbol used to indicate

decisions. Done in question form and is answerable by yes or

no. Uses logical relations such as equal(=), not equal(≠),

(21)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 14

Chapter II: Analysis and Presentation

greater than(>), greater than or equal to(≥) and less than or

equal to(≤).

On-page Connectors. Flowcharts are written from top to

bottom, left to right. Once the bottom of the left side is

reached continuation of the flowchart can be at the right side

on the same page.

Off-page Connectors. This symbol is used if the flowchart

is to be continued on the next page.

Flowlines. This shows the direction of the flowchart.

Preparation. This symbol is used to initialize the value/s of

the variable/s to be used.

Magnetic Disk. This symbol is used where data is to be

(22)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 15

Chapter II: Analysis and Presentation

Document. This represents a document or a printed

output.

Multi Document. This represents multiple documents to be

printed.

Stored Data. This corresponds to any data stored in a

memory or storage unit.

Manual Input. This denotes a manual entry of data.

Display. This represents data to be displayed on a monitor

or projector.

Manual Operation. For process flowcharts this will indicate

(23)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 16

Chapter II: Analysis and Presentation

Flow Chart of the Present System

N

Y

Start

Subject Teacher Compute the Final

Grade

Principal Returns to the Subject

Teacher

Grades are written in the Student„s Form 137 and

stored in cabinet Class Adviser Passes Grade to the Principal

Final Grade

Valid?

After Principals Validation, the Teacher writes the Grades on Student‟s Form

138 Validation

(24)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 17

Chapter V: Conclusion and Recommendation

CHAPTER III

THE PROPOSED SYSTEM

Description of the Proposed System

The Grading System of Libertad National High School will greatly improve the

efficiency and speed of computing grades of the student.

This Computerized Grading System will help improve the speed in computing the

grades of the student making the work of the teachers during examination dates easier.

Likewise, in the preparation of examination, the teachers will have easier way in encoding

and printing out the computed grade for the approval with an interactive interface making

the process easier and comfortable for the teachers. It would eliminate the use of test

papers in taking examination making it more economically friendly. It would help the

students receive their scores right after examination to know their academic performance

in a particular subject.

(25)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 18

Chapter V: Conclusion and Recommendation

Flow Chart of the Proposed System

Start

Subject Teacher choose first the grading period

Subject Teacher search and select the name of

the student

Subject Teacher search and select the subject.

Input grades of student in grading areas

If all fields are filled up?

Fill up all fields then save Save?

End

Automatically save in the database.

N

Y

(26)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 19

Chapter V: Conclusion and Recommendation

Input-Process-Output Diagram

HELP REPORTS TRANSACTION LIBRARIES EXIT INDIVIDUAL GRADE LOGOUT STUDENT CLASS RECORD SUBJECT LIST OF STUDENT COMPUTE GRADE FOURTH GRADING THIRD GRADING CLASS RECORD SECTION ABOUT SYSTEM LOGIN MAIN SETUP LIST OF SUBJECT RANKING SPLASH SCREEN USER ACCOUNT ABOUT DEVELOPER FIRST GRADING SECOND GRADING YEAR LEVEL GRADING SHHET

(27)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 20

Chapter V: Conclusion and Recommendation

Hierarchical Input-Process-Output Diagram

INPUT

PROCESS

OUTPUT

tblUser

Username

Password

tblStudent

Student ID

Student Name

Address

Gender

Birth Date

Contact Number

Religion

tblSubj

Subject

Subject Code

tblGrade1

1

st

_Grading

2

nd

_Grading

3

rd

Grading

4

th

_Grading

ADD

This allows the user to

add another record.

EDIT

This allows the user to

edit one‟s record.

DELETE

This allows the user to

delete/erase record.

CANCEL

This allows the user to

cancel what he/she do

not want to happen.

SAVE

This allows the user to

save records.

COMPUTE

This allows the user to

compute the grade on

student.

Reports

List of Student

List of Subject

Class Record

(28)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 21

Chapter V: Conclusion and Recommendation

Entity Relationship Diagram

tblUser

tblStudent

tblSubj

tblGrade

LNHS

tblUser

UserID

UserName

_Password

Type

(29)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 22

Chapter V: Conclusion and Recommendation

IDNO Subject Name SubjNo

tblGrade1

PT1 B1 Q1 PER1 PRO1 UT1 A1 TOTAL1 Yearlevel Section PT4 B4 Q4 PER4 PRO4 UT4 A4 TOTAL4 PT3 B3 Q3 PER3 PRO3 UT3 A3 TOTAL3 PT2 B2 Q2 PER2 PRO2 UT2 A2 TOTAL2

(30)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 23

Chapter V: Conclusion and Recommendation

tblStudent

FName

MNam

e

LName

Gender

BDate

Contact

StudentNo

Year_Level

StudentSec

Address

Religion

tblSubj

Project

Subject

Quizzes

Performance

Unit Test

Periodic Test

Assignment

SubjNo

Behavior

(31)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 24

Chapter V: Conclusion and Recommendation

Cost Benefit Analysis

Description Present System

QTY

Amount

Proposed System

QTY

Amount

Variance Remarks I. Cost of Labor Professional Rate(PR) PR=25000/month =25000/30 =833/day =833/9 PR=92/hour SUB-PROFESSIONAL RATE (SPR) SPR=PR*35% =25000*.35 =8750/month =3500/30 =291.67/day =291.67/5 SPR=58.33/hour SYSTEM DEVELOPMENT PERIOD (SDP) SDP=4 mo.* 4 wks/mo.* 7 days * 5 hrs. SDP=560 hrs. COST OF LABOR (CL) CL= SDP * SPR = 560 hrs. * P58.33 CL = P32,664.8 II. Computer Equipment A. Computer Rentals Total hands-on hours in school = 80 hrs 2 (P32,664.8) P65,329.6 The estimated professional rate per month is P25, 000.00. The sub-professional rate is computed 35% of the estimated professional rate

The cost of labor is computed as system development period multiplied by sub-professional rate per hour multiplied by the number of researchers. To compute for the number of hours to be consumed outside the school, 80 hours is subtracted from the total number of hours for the system

(32)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 25

Chapter V: Conclusion and Recommendation

Total hands-on hours off –school = SDP – 80 hrs = 480 hrs Printing Expenses =P650 III. Supplies Ink Bond Paper IV. Miscellaneous Photo Copy(3) Book Binding (P650) 2 3 P650 which is 560 hours. The printing expense cost is P650

(33)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 26

Chapter V: Conclusion and Recommendation

Schedule of the Proposed System

Gant Chart of the Schedule of the Proposed System

Activities

JUNE

JULY

AUGUST

SEPTEMBER

Week Number

1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4

Data Gathering

Problem

Definition

Project Planning

System Analysis

System Design

Prototype

Encoding

Documentation

System Testing

Implementation

System

Evaluation

(34)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 27

Chapter V: Conclusion and Recommendation

CHAPTER IV

PROGRAM

User’s Manual

This is the Splash Screen, the first to show on the system when it runs.

This is the Login form where you can input your Username and Password to enter the

system.

(35)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 28

Chapter V: Conclusion and Recommendation

This is the content of the Setup in the Main Form

This is the Student Form which is under the content of Library.

This Form shows, add, edit, delete, save Student Information. At

the other Section of the form, the user can search and print

student record.

(36)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 29

Chapter V: Conclusion and Recommendation

This is the Subject Form which is under the content of Library. This shows, add, edit,

delete, and save Subject with its corresponding percentage.

This is the User Account where the User can add, edit, delete, save its

Account to enter the system. If the login user is not admin the submenu

will be disabled.

(37)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 30

Chapter V: Conclusion and Recommendation

When you click Logout in Setup‟s content this message will show. If you click yes, it will go

back to Login Form and if no, it will stay remain in the Main Form.

(38)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 31

Chapter V: Conclusion and Recommendation

This is the Compute Form under the Transaction Menu. This allows the user to compute

the grade of the student in every Subject.

(39)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 32

Chapter V: Conclusion and Recommendation

This is the content of Report in the Menu. It contains Class Record; List of Students

contains the Section, Year Level and Individual Grade. The List of Subject is ready to print.

This is the Section Form; it allows User to Search the Student‟s Year Level and Section that

is ready to print when the preview button is click. This displays the Section Report.

(40)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 33

Chapter V: Conclusion and Recommendation

When the Search is done and Preview Button has been click it will show the Search Section

in Report and ready to print.

This is the Year Level Form; it allows User to Search the Student‟s Year Level and Section

that is ready to print when the preview button is click. This displays the Grades of Student

per year level and per section..

(41)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 34

Chapter V: Conclusion and Recommendation

This is the result of searching on the Year Level form and it is now ready to print.

This is the Ranking Form with allows the user to search Year Level, Section and the Subject

number. The user can select what grading period he/she like and print it when the button

preview click.

(42)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 35

Chapter V: Conclusion and Recommendation

This is the Class Record Form; the User search and choose subject depending on what year

level and section then the report shows the Student who has the subject chosen with their

corresponding grades from 1

st

_{grading to 4}

th

_{grading and their final grade.}

After choosing a Subject, a Report will appear showing the list of Student who has the

Subject that has been chosen with their grade.

(43)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 36

Chapter V: Conclusion and Recommendation

This is the Grade Sheet Form; user can search the year level and section of the student

and the subject he/she want to search to show the computed grade from 1

st

grading to 4

th

grading including the final grade.

This is the report of the Grading sheet it displays the total grade from 1

st

_{grading to 4}

th

grading and automatically computes the final Grade.

(44)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 37

Chapter V: Conclusion and Recommendation

This is the content of the about menu.

(45)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 38

Chapter V: Conclusion and Recommendation

This is the Developer‟s Form; it shows the developer of the system, it helps the user to run

the system if there is a trouble.

(46)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 39

Chapter V: Conclusion and Recommendation

Code

Splash

Option Explicit

Private Sub Form_KeyPress(KeyAscii As Integer) frmLogin.txtUser.SetFocus

End Sub

Private Sub Timer1_Timer()

pbLoader.Value = pbLoader.Value + 1

lblPercent.Caption = pbLoader.Value / pbLoader.Max * 100 & " %" If pbLoader.Value > 1 And pbLoader.Value < 20 Then

lblLoad.Caption = "Loading Program...." Else

If pbLoader.Value > 20 And pbLoader.Value < 30 Then lblLoad.Caption = "Loading Tools...."

Else

If pbLoader.Value > 30 And pbLoader.Value < 45 Then lblLoad.Caption = "Loading Database...."

End If End If End If If pbLoader.Value = 70 Then lblLoad.Caption = "Initializing...." Timer1.Interval = 30 End If If pbLoader.Value = 80 Then Timer1.Interval = 30

lblLoad.Caption = "Executing Program...." End If

If pbLoader.Value = pbLoader.Max Then Timer1.Interval = 0 Unload Me frmLogin.Show End If End Sub Login

Private Sub cmdClose_Click()

If MsgBox("Are you sure you want to Close?", vbQuestion + vbYesNo, "Close") = vbYes Then End

End If End Sub

Private Sub cmdOK_Click() Static try As Integer

(47)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 40

Chapter V: Conclusion and Recommendation

Set con = New ADODB.Connection Set rs = New ADODB.Recordset Call connect

rs.Open "select * from tbluser where username = '" & Replace(Trim(txtUser.Text), "'", "") & "' and password = '" & Replace(Trim(txtPass.Text), "'", "") & "'", conn, adOpenStatic, adLockReadOnly

If rs.EOF Then

MsgBox "Invalid Username or Password! " & (2 - try) & " Try remaining", vbExclamation, "LNHS" txtUser.Text = ""

txtPass.Text = "" txtUser.SetFocus try = try + 1 If try = 3 Then

MsgBox "You have reached the maximum trial for Logging in!", vbInformation, "Program Shutting Down" End

End If Else

MsgBox "Welcome " & rs.Fields("username") & " to Computerized Grading System of LNHS", vbInformation, "LNHS"

frmMain.StatusBar1.Panels(2).Text = rs.Fields("username") If rs.Fields("Type").Value = "User" Then

frmMain.mnutransaction.Enabled = False frmMain.mnuuseracc.Enabled = False frmMain.mnulibraries.Enabled = False frmMain.mnuindividualgrade.Enabled = False End If Unload Me frmMain.Show End If End Sub Main

'Private Sub MDIForm_QueryUnload(Cancel As Integer, UnloadMode As Integer) 'Dim a As Integer

'a = MsgBox("Are you sure you want to exit?", vbQuestion + vbOKCancel, "LNHS Computerized Grading System") ' If a = vbOK Then 'Cancel = False 'Else 'Cancel = True ' End If 'End Sub

Private Sub mnuclassrec1_Click() frmClassRec.Show vbModal, frmMain End Sub

(48)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 41

Chapter V: Conclusion and Recommendation

frmChooseSubj.Label2.Caption = 1 frmChooseSubj.Show vbModal, frmMain End Sub

Private Sub mnucompute_Click() frmgrade.Show

End Sub

Private Sub mnudeveloper_Click() frmDeveloper.Show vbModal, frmMain End Sub

Private Sub mnuexit_Click()

If MsgBox("Are You Sure You Want to Exit?", vbQuestion + vbYesNo, "Exit") = vbYes Then Unload Me

End If End Sub

Private Sub mnugradingsheet_Click() frmChooseSubj.Show

frmChooseSubj.Label2.Caption = 2 End Sub

Private Sub mnuGS_Click()

frmChooseGS.Show vbModal, frmMain End Sub

Private Sub mnuindividualgrade_Click() frmgrade.Show

End Sub

Private Sub mnulistsubj_Click() frmChooseYL.Show vbModal, frmMain End Sub

Private Sub mnulogout_Click()

If MsgBox("Are You Sure You Want to Logout?", vbQuestion + vbYesNo, "Logout") = vbYes Then Unload Me

frmLogin.Show End If

End Sub

Private Sub mnuranking_Click() frmRank.Show vbModal, frmMain End Sub

(49)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 42

Chapter V: Conclusion and Recommendation

frmSection.Show End Sub

Private Sub mnustudent_Click() frmStudent.Show vbModal, frmMain End Sub

Private Sub mnusubject_Click() frmSubject.Show vbModal, frmMain End Sub

Private Sub mnusystem_Click() frmSystem.Show

End Sub

Private Sub mnuuseracc_Click() frmUserAcc.Show vbModal, frmMain End Sub

Private Sub mnuyearlevel_Click() frmYearLevel.Show

End Sub

Student

Dim temocode As Integer Private Sub cmbreligion_Click() t9.Text = cmbreligion.Text End Sub

Private Sub cmdAdd_Click()

Adodc1.RecordSource = "SELECT * FROM tblstudent order by studentno" Adodc1.Refresh If Adodc1.Recordset.RecordCount = 0 Then tempcode = 1 Else Adodc1.Recordset.MoveLast tempcode = Val(Adodc1.Recordset(0)) + 1 End If Adodc1.Recordset.AddNew ENA t1.Text = Format(tempcode, "0") t2.SetFocus End Sub

(50)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 43

Chapter V: Conclusion and Recommendation

If MsgBox("Are You Sure You Want to Cancel?", vbQuestion + vbYesNo, "Cancel") = vbYes Then Adodc1.Recordset.CancelBatch

Adodc1.Refresh dis

End If End Sub

If MsgBox("Are You Sure You Want to Close?", vbQuestion + vbYesNo, "Close") = vbYes Then Unload Me

End If End Sub

Private Sub cmdDel_Click()

If Adodc1.Recordset.RecordCount = 0 Then

MsgBox "No Record to Delete.", vbInformation, "Delete" Else

If MsgBox("Are You Sure you Want to Delete", vbQuestion + vbYesNo, "Delete") = vbYes Then Adodc1.Recordset.Delete End If dis Unload Me Me.Show End If End Sub

Private Sub cmdEdit_Click()

If Adodc1.Recordset.RecordCount = 0 Then MsgBox "No Record to Edit.", vbInformation, "Edit" Else

ENA t1.SetFocus End If End Sub

Private Sub cmdFirst_Click()

If Adodc1.Recordset.RecordCount <> 0 Then Adodc1.Recordset.MoveFirst

End If End Sub

Private Sub cmdLast_Click()

If Adodc1.Recordset.RecordCount <> 0 Then Adodc1.Recordset.MoveLast

End If End Sub

(51)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 44

Chapter V: Conclusion and Recommendation

Private Sub cmdNext_Click()

If Adodc1.Recordset.RecordCount = 0 Then MsgBox "No Records", vbInformation, "LNHS" Else

Adodc1.Recordset.MoveNext If Adodc1.Recordset.EOF Then

If MsgBox("Last Record", vbInformation, "LNHS Computerized Grading System") = vbOK Then Adodc1.Recordset.MoveLast

End If End If End If End Sub

Private Sub cmdPre_Click()

If Adodc1.Recordset.RecordCount = 0 Then MsgBox "No Records", vbInformation, "LNHS" Else

Adodc1.Recordset.MovePrevious If Adodc1.Recordset.BOF Then Adodc1.Recordset.MoveFirst

If MsgBox("First Record", vbInformation, "LNHS Computerized Grading System") = vbYes Then End If

End If End If End Sub

Private Sub cmdsave_Click()

If t1.Text = "" Or t2.Text = "" Or t3.Text = "" Or t4.Text = "" Or t5.Text = "" Or cmbSection.Text = "" Or _ DTPicker1.Value = "" Or t8.Text = "" Or t9.Text = "" Or cmbgender.Text = "" Or cmbYL.Text = "" Then MsgBox "Please Fill Out All Fields", vbInformation

Else

If MsgBox("Are You Sure You Want to Save?", vbQuestion + vbYesNo, "Save") = vbYes Then Adodc1.Recordset.Update dis End If End If End Sub Function ENA() Frame1.Enabled = True cmdAdd.Enabled = False cmdEdit.Enabled = False cmdDel.Enabled = False cmdSave.Enabled = True cmdCancel.Enabled = True

(52)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 45

Chapter V: Conclusion and Recommendation

cmdClose.Enabled = False End Function Function dis() Frame1.Enabled = False cmdAdd.Enabled = True cmdEdit.Enabled = True cmdDel.Enabled = True cmdSave.Enabled = False cmdCancel.Enabled = False cmdClose.Enabled = True End Function

Private Sub cmdSearch_Click()

Adodc2.RecordSource = "select * from tblStudent where Year_Level like '" & Combo1.Text & "' and StudentSec like '" & Text2.Text & "' order by Lname "

Adodc2.Refresh DataGrid2.Refresh End Sub

Private Sub Command1_Click()

If Adodc2.Recordset.RecordCount = 0 Then Adodc2.Refresh

MsgBox ("No Record!") Else

With de.rsStudent

.Open de.rsCommand2_Grouping.Filter = "Year_level ='" & Combo1.Text & "' And StudentSec ='" & Text2.Text & "'" rptStudent.Show vbModal, frmMain

.Close End With End If Unload Me End Sub

Private Sub t8_KeyPress(KeyAscii As Integer) If KeyAscii = 13 Then cmbreligion.SetFocus End If Dim str As String str = "0123456789" If KeyAscii > 26 Then

If InStr(str, Chr(KeyAscii)) = 0 Then KeyAscii = 0

(53)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 46

Chapter V: Conclusion and Recommendation

Private Sub txtdate_KeyPress(KeyAscii As Integer) If KeyAscii = 13 Then t8.SetFocus End If Dim str As String str = "0123456789" If KeyAscii > 26 Then

If InStr(str, Chr(KeyAscii)) = 0 Then KeyAscii = 0

Subject

Dim temocode As Integer Private Sub cmbgender_Click() t6.Text = cmbgender.Text End Sub

Private Sub cmdAdd_Click()

Adodc1.RecordSource = "select * from tblsubj order by subjno" Adodc1.Refresh If Adodc1.Recordset.RecordCount = 0 Then tempcode = 1 Else Adodc1.Recordset.MoveLast tempcode = Val(Adodc1.Recordset(0)) + 1 End If Adodc1.Recordset.AddNew ENA t1.Text = Format(tempcode, "000") t2.SetFocus End Sub

Private Sub cmdCancel_Click()

If MsgBox("Are You Sure You Want to Cancel?", vbQuestion + vbYesNo, "LNHS Computerized Grading System") = vbYes Then Adodc1.Recordset.CancelBatch Adodc1.Refresh dis End If End Sub

(54)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 47

Chapter V: Conclusion and Recommendation

If MsgBox("Are You Sure You Want to Close?", vbQuestion + vbYesNo, "LNHS Computerized Grading System") = vbYes Then

Unload Me End If End Sub

MsgBox "No Record to Delete.", vbInformation, "LNHS Computerized Grading System" Else

If MsgBox("Are You Sure you Want to Delete", vbQuestion + vbYesNo, "LNHS Computerized Grading System") = vbYes Then Adodc1.Recordset.Delete End If dis Unload Me Me.Show End If End Sub

MsgBox "No Record to Edit.", vbInformation, "LNHS Computerized Grading System" Else

ENA t1.SetFocus End If End Sub

Private Sub cmdFirst_Click()

If Adodc1.Recordset.RecordCount <> 0 Then Adodc1.Recordset.MoveFirst

End If End Sub

Private Sub cmdLast_Click()

If Adodc1.Recordset.RecordCount <> 0 Then Adodc1.Recordset.MoveLast

End If End Sub

Private Sub cmdNext_Click()

MsgBox "No Records", vbInformation, "LNHS Computerized Grading System" Else

(55)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 48

Chapter V: Conclusion and Recommendation

If Adodc1.Recordset.EOF Then

If MsgBox("Last Record", vbInformation, "LNHS Computerized Grading System") = vbOK Then Adodc1.Recordset.MoveLast

End If End If End If End Sub

Private Sub cmdPre_Click()

MsgBox "No Records", vbInformation, "LNHS Computerized Grading System" Else

Adodc1.Recordset.MovePrevious If Adodc1.Recordset.BOF Then Adodc1.Recordset.MoveFirst

If MsgBox("First Record", vbInformation, "LNHS Computerized Grading System") = vbYes Then End If

If t1.Text = "" Or t2.Text = "" Or t3.Text = "" Or t4.Text = "" Or t5.Text = "" Or t6.Text = "" Or _ t7.Text = "" Or t8.Text = "" Or t9.Text = "" Then

MsgBox "Please Fill Out All Fields", vbInformation, "LNHS Computerized Grading System" Else

If Val(t10.Text) = 100 Then

If MsgBox("Are You Sure You Want to Save?", vbQuestion + vbYesNo, "LNHS Computerized Grading System") = vbYes Then

Adodc1.Recordset.Update dis

End If Else

MsgBox "Total must be 100%", vbInformation, "LNHS Computerized Grading System" End If End If End Sub Function ENA() Frame1.Enabled = True Frame2.Enabled = True cmdAdd.Enabled = False cmdEdit.Enabled = False cmdDel.Enabled = False cmdSave.Enabled = True cmdCancel.Enabled = True

(56)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 49

Chapter V: Conclusion and Recommendation

cmdClose.Enabled = False End Function Function dis() Frame1.Enabled = False Frame2.Enabled = False cmdAdd.Enabled = True cmdEdit.Enabled = True cmdDel.Enabled = True cmdSave.Enabled = False cmdCancel.Enabled = False cmdClose.Enabled = True End Function

Private Sub t3_Change() COMPTOTAL

End Sub

Function COMPTOTAL()

t10.Text = Val(t3.Text) + Val(t4.Text) + Val(t5.Text) + Val(t6.Text) + Val(t7.Text) + Val(t8.Text) + Val(t9.Text) End Function

End Sub

(57)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 50

Chapter V: Conclusion and Recommendation

End Sub

User Account

Private Sub chkpas_Click() If chkpas.Value = 1 Then txtpassword.PasswordChar = "" Else txtpassword.PasswordChar = "*" End If End Sub

Private Sub cmbLevel_Click() txtLevel.Text = cmbLevel.Text End Sub

Private Sub cmdAdd_Click() ENA

On Error Resume Next Adodc1.Recordset.AddNew txtusername.SetFocus End Sub

If MsgBox("Are you sure you want to Cancel?", vbQuestion + vbYesNo, "Cancel") = vbYes Then Adodc1.Recordset.CancelBatch

Adodc1.Refresh dis

End If End Sub

If MsgBox("Are You Sure You Want to Close?", vbQuestion + vbYesNo, "Close") = vbYes Then Unload Me

End If End Sub

Private Sub cmdDelete_Click()

If MsgBox("Are You Sure you Want to Delete this Supplier from the List", vbQuestion + vbYesNo, "LNHS Computerized Grading System") = vbYes Then

Adodc1.Recordset.Fields("Deleted").Value = "YES" Adodc1.Recordset.Update End If dis PosLeft = Me.Left PosTop = Me.Top

(58)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 51

Chapter V: Conclusion and Recommendation

Unload Me Me.Show Me.Left = PosLeft Me.Top = PosTop End Sub

If txtLevel.Text = "Administrator" Then

MsgBox "Sorry, Unable to Delete The Administrator Account.", vbInformation, "Delete" Else

MsgBox "No Record to Delete.", vbInformation, "Delete" Else

If MsgBox("Are You Sure you Want to Delete", vbQuestion + vbYesNo, "Delete") = vbYes Then Adodc1.Recordset.Delete End If dis Unload Me Me.Show End If End If End Sub

If Adodc1.Recordset.RecordCount = 0 Then MsgBox "No Record to Edit.", vbInformation, "Edit" Else

ENA End If End Sub

Private Sub cmdFirst_Click() Adodc1.Recordset.MoveFirst End Sub

Private Sub cmdLast_Click() Adodc1.Recordset.MoveLast End Sub

Private Sub cmdNext_Click() Adodc1.Recordset.MoveNext If Adodc1.Recordset.EOF Then Adodc1.Recordset.MoveLast

MsgBox "Last Record", vbInformation, "LNHS Computerized Grading System" End If

(59)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 52

Chapter V: Conclusion and Recommendation

End Sub

Private Sub cmdPre_Click() Adodc1.Recordset.MovePrevious If Adodc1.Recordset.BOF Then Adodc1.Recordset.MoveFirst

MsgBox "First Record", vbInformation, "LNHS Computerized Grading System" End If

End Sub

If txtusername.Text = "" Or txtpassword.Text = "" Or txtLevel.Text = "" Then MsgBox "Please Fill Out All Fields", vbInformation, "Save"

Else

If MsgBox("Are You Sure You Want to Save?", vbQuestion + vbYesNo, "Save") = vbYes Then Adodc1.Recordset.Update dis End If End If End Sub Function ENA() Frame2.Enabled = True cmdAdd.Enabled = False cmdEdit.Enabled = False cmdDel.Enabled = False cmdSave.Enabled = True cmdCancel.Enabled = True cmdClose.Enabled = False End Function Function dis() Frame2.Enabled = False cmdAdd.Enabled = True cmdEdit.Enabled = True cmdDel.Enabled = True cmdSave.Enabled = False cmdCancel.Enabled = False cmdClose.Enabled = True End Function

Private Sub Form_Load()

Adodc1.RecordSource = "select * from tblUser" Adodc1.Refresh

dis End Sub

(60)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 53

Chapter V: Conclusion and Recommendation

First Grading

Private Sub cmdAdd_Click() ENA

End Sub

Private Sub cmd1_Click() frmgrade.Show cmd1.Enabled = True cmd2.Enabled = False cmd3.Enabled = False cmd4.Enabled = False Frame1.Enabled = True Frame2.Enabled = True Frame3.Enabled = True Frame4.Enabled = True End Sub

Private Sub cmd2_Click() frmgrade2.Show Unload Me End Sub

Private Sub cmd5_Click() frmCompute.Show Unload Me End Sub

Private Sub cmd6_Click() frmComputeFG.Show Unload Me

End Sub

If MsgBox("Are You Sure You Want to Cancel?", vbQuestion + vbYesNo, "Cancel") = vbYes Then AdoGrade.Recordset.CancelBatch

(61)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 54

Chapter V: Conclusion and Recommendation

AdoGrade.Refresh Unload Me Me.Show End If End Sub

If MsgBox("Are You Sure You Want to Close?", vbQuestion + vbYesNo, "CLose") = vbYes Then Unload Me

End If End Sub

Private Sub cmdsave_Click() On Error GoTo bj

AdoGrade.Recordset(0).Value = t1.Text

AdoGrade.Recordset(1).Value = t2.Text & ", " & t3.Text & " " & t4.Text AdoGrade.Recordset(2).Value = t5.Text AdoGrade.Recordset(3).Value = t6.Text AdoGrade.Recordset(4).Value = t7.Text AdoGrade.Recordset(5).Value = t8.Text AdoGrade.Recordset(6).Value = t9.Text AdoGrade.Recordset(7).Value = t10.Text AdoGrade.Recordset(8).Value = t11.Text AdoGrade.Recordset(9).Value = t12.Text AdoGrade.Recordset(10).Value = t13.Text AdoGrade.Recordset(11).Value = t14.Text AdoGrade.Recordset(37).Value = Text1.Text AdoGrade.Recordset(38).Value = Text2.Text

If Me.t7.Text = "" Or Me.t8.Text = "" Or Me.t9.Text = "" Or Me.t10.Text = "" Or Me.t11.Text = "" Or Me.t12.Text = "" Or Me.t13.Text = "" Or Me.t14.Text = "" Then

MsgBox "All textboxes are required to fill-up.", vbInformation, "LNHS Computerized Grading System" Else

If MsgBox("Waiting for your confirmation to Save.", vbQuestion + vbYesNo, "Save") = vbYes Then AdoGrade.Recordset.Update AdoGrade.Recordset.Update Unload Me Me.Show End If End If Exit Sub bj: End Sub

Private Sub cmdSearch_Click() frmSearch.Show

(62)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 55

Chapter V: Conclusion and Recommendation

End Sub

Private Sub cmdsearch2_Click() frmSearch2.Show

frmSearch2.Label1 = 1 End Sub

Private Sub Form_Load()

AdoStud.RecordSource = "select * from tblStudENt where Studentno ='" & t1.Text & "' " AdoStud.Refresh

AdoSubj.RecordSource = "select * from tblSubj where SubjNo='" & t5.Text & "' " AdoSubj.Refresh

AdoSubj.RecordSource = "select * from tblSubj where Subject='" & t5.Text & "' " AdoSubj.Refresh

End Sub

Private Sub t1_Change()

AdoStud.RecordSource = "select * from tblStudENt where Studentno ='" & t1.Text & "' " AdoStud.Refresh

End Sub

Private Sub t5_Change() On Error Resume Next

AdoSubj.RecordSource = "select * from tblSubj where SubjNo='" & t5.Text & "' " AdoSubj.Refresh

l(0).Caption = "X " & AdoSubj.Recordset(2).Value & " % " l(1).Caption = "X " & AdoSubj.Recordset(3).Value & " % " l(2).Caption = "X " & AdoSubj.Recordset(4).Value & " % " l(3).Caption = "X " & AdoSubj.Recordset(5).Value & " % " l(4).Caption = "X " & AdoSubj.Recordset(6).Value & " % " l(5).Caption = "X " & AdoSubj.Recordset(7).Value & " % " l(6).Caption = "X " & AdoSubj.Recordset(8).Value & " % "

AdoGrade.RecordSource = "select * from tblgrade1 where idno = '" & t1.Text & "' and SubjNo = '" & t5.Text & "'" AdoGrade.Refresh If AdoGrade.Recordset.RecordCount = 1 Then t7.Text = AdoGrade.Recordset(4).Value t8.Text = AdoGrade.Recordset(5).Value t9.Text = AdoGrade.Recordset(6).Value t10.Text = AdoGrade.Recordset(7).Value t11.Text = AdoGrade.Recordset(8).Value t12.Text = AdoGrade.Recordset(9).Value t13.Text = AdoGrade.Recordset(10).Value t14.Text = AdoGrade.Recordset(11).Value AdoGrade.Recordset.Requery Else t7.Text = ""

(63)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 56

Chapter V: Conclusion and Recommendation

t8.Text = "" t9.Text = "" t10.Text = "" t11.Text = "" t12.Text = "" t13.Text = "" t14.Text = "" AdoGrade.Recordset.AddNew Me.Frame3.Enabled = True Me.cmdsave.Enabled = True Me.cmdCancel.Enabled = True End If End Sub

Private Sub t7_Change() On Error Resume Next Dim dig$, i, digi$, digits$ If t7.Text <> "" Then

dig$ = Mid(t7.Text, Len(t7.Text), 1) If Asc(dig$) < 46 Or Asc(dig$) > 57 Then For i = 1 To Len(t7.Text) - 1

digi$ = Mid(t7.Text, i, 1) digits$ = digits$ & digi$ Next i

t7.Text = digits$

t7.SelStart = Len(t7.Text) End If

End If

l(0).Caption = "X " & AdoSubj.Recordset(2).Value & " % = " & Val(t7.Text) * (Val(AdoSubj.Recordset(2).Value) / 100) comp

End Sub

t8.Text = digits$

(64)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 57

Chapter V: Conclusion and Recommendation

End Sub

t9.Text = digits$

End If

End Sub

t10.Text = digits$

End If

End Sub

(65)

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC

Alimannao Hills, Peñablanca, Cagayan

Page 58

Chapter V: Conclusion and Recommendation

digits$ = digits$ & digi$ Next i

t11.Text = digits$

End If

End Sub

t12.Text = digits$

End If

End Sub

t13.Text = digits$

End If

End Sub Function comp()

Documentation 1 - Copy

COMPUTERIZED GRADING SYSTEM

Libertad National High School

Libertad, Abulug, Cagayan

A Project Proposal

Presented to the Faculty

Of the College of Information Technology

International School of Asia and the Pacific

Alimannao Hills, Penablanca, Cagayan

In Partial Fulfillment of the Requirements for the Degree

Bachelor of Science in Information Technology

Presented by:

Rhea A. Tingle

Trofie C. Raña

LIBERTAD NATIONAL HIGH SCHOOL

COMPUTERIZED GRADING SYSTEM

A Project Proposal

Presented to the Faculty

Of the College of Information Technology

International School of Asia and the Pacific

Alimannao Hills, Penablanca, Cagayan

In Partial Fulfillment of the Requirements for the Degree

Bachelor of Science in Information Technology

Presented by:

Rhea A. Tingle

Trofie C. Raña

iii

APPROVAL SHEET

March 2011

In partial fulfillment of the requirements for the degree BACHELOR OF SCIENCE IN

INFORMATION TECHNOLOGY, this thesis entitled “Libertad National High School

Computerized Grading System”, has been prepared by Rhea A. Tingle and Trofie C. Raña.

____________________

Adviser

Approved by the tribunal of the Oral Examination

____________________

Panel Member

Accepted as partial fulfillment of the requirements for the degree Bachelor of

Science in Information Technology.

___________________________________

Program Coordinator

iv

ACKNOWLEDGEMENT

The researcher‟s wishes to extend their sincerest appreciation to the Principal of

the LIBERTAD NATIONAL HIGH SCHOOL, Abulug, Cagayan, Teacher and Students for their

concern and assistance to the researchers work made it a success.

Special acknowledgement to their subject teachers of the INTERNATIONAL SCHOOL

OF ASIA AND THE PACIFIC for their patience and advices.

v

DEDICATION

This study is dedicated to the Teachers and Students of the LIBERTAD NATIONAL

HIGH SCHOOL for a better performance and analization of their performances.

Also dedicated to the researchers, as a requirement for their subject at the

INTERNATIONAL SCHOOL OF ASIA AND THE PACIFIC.

vi

Table of Contents

APPROVAL SHEET ... iii

ACKNOWLEDGEMENT ... Error! Bookmark not defined.

DEDICATION ... iv

TABLE OF CONTENTS ... iv

CHAPTER I- Background of the Study ... 1

Introduction ... 1

Statement of the Problem ... 1

Objectives of the Study ... 3

Significance of the Study ... 4

Scope and delimitation ... 4

Methodology of the Study ... 4

Definition of Terms ... 7

Schedule of the Study ... 7

CHAPTER II – Analysis and Presentation... 10

History ... 10

Functions and Objectives of the Organization ... 10

Organizational Chart ... 11

Flow Chart Symbol ... 13

Flow Chart of the Present System ... 16

CHAPTER III – The Proposed System ... 17

Description of the Proposed System ... 17

Flow Chart of the Proposed System ... 17

Input-Process-Output Diagram ... 18

Hierarchical Input-Process-Output Diagram ... 19