34 " Enlistment System
CHAPTER I
INTRODUCTION
Background of the Study
Nowadays, computer technology is vast and changing the lives of every walks of life. Almost all of the establishments, business sectors, schools and universities had their own updates of computer technology. This change improves the marketing strategy that makes them globally competitive. Different application had been used and had been improved; most especially when it comes to enrolment.
Since 2011, the AMA Computer Learning Center – San Francisco (ACLC – SF) have been expected not just to endow with the excellent learning of the students, but also to ensure quality education in terms of classroom accommodation and exceptional facilities at a considerable cost.
During the pioneering years of ACLC-SF, in which the population of the students is about in few numbers (roughly a hundreds), the campus administration drawn the typical and a "must" system for every school which is the enlistment of subjects and scheduling of their classes.
Using a manually planned timetable, the enlistment helped out facilitating the students for almost a couple of years. But as the number of ACLC-SF student rises, the generation of the timetable become tedious. The system is inflexible to changes or adjustment of class schedules; these results into frequent time conflictions and the time spent during the enrolment period.
STATEMENT OF THE PROBLEM
The current Enlistment System of the ACLC-SF is the Finance Officer will encode the subjects listed by the students in the enlistment form which will cause the college to spend more time in enlisting the subjects. One of the problems is also the schedule for the start of classes is postponed for the next day; means the enrolment process is slow. The current system is also not helping the student's but they are wasting their time to wait for their turns. And also they have a human error that they encountered. As our concern, we proposed to make an ENLISTMENT SYSTEM that will make the enrolment process faster. This system is made possible with the creation of a database that collects information pertaining to the subjects enrolled by the students. This system benefits especially the Finance Office of ACLC-SF because it enables them to produce a better Enrolment System with the help of the Enlistment System.
Specially, the study attempted to answer the following question:
1. Which of the two ways of enrollment gives the accurate reports?
2. Which is more faster way to enroll for students?
3. Which is more accessible and faster to enlist for the officer?
1.2 Objectives of the Study
This study will help the Faculty and staffs of AMA Computer Learning Center of San Francisco make the enrolment easy by the help of the enlistment database system for ACLC-SF. The benefits that the college will have are those stated below:
The database system will make the college view the old data and will help lessen the time spent for the listing of the subjects.
The Enlistment database system will store the data of the student this includes the name of the student, section and schedule.
The system will add a good contribution for enrolment process as it will make the enlistment easy and faster.
This will give an accurate, reliable, and more upgraded enlistment system.
Significance of the Study
The significance of this Enlistment System is to lessen the time of the student for their enrolment process and to lessen the work of the finance officer. The finance officer don't need to encode the subjects, time, section, unit and assign room instead of writing the finance officer will click to put the subject, section, time, unit and assign room. And it can be used for promoting the college for the next batch.
1.4 Scope and Limitation
This study aim to develop an enrolment database system for the AMA Computer Learning Center of San Francisco, the system limits on the following fields and functions:
It limits to store the data of the student (First name, Last name, MI, section, year level and subjects) and the subjects and schedules inputted by the authorized personnel.
Only Authorized personnel will be allowed to use the system.
It limits to search, view, add, update and drop the subjects enrolled.
The system will enable to update and store the subjects offered for the certain years and semesters, in which,
The authorized personal will just going to choose the subject with the corresponding schedules that the student wants to enroll.
The system will automatically close the schedules when it reaches the limit of the students enrolled.
Glossary of Terms
Visual Basic – is an object-oriented program produced by Microsoft. Supports the graphical interface needed for today's program because of the operating system windows which supports GUI (Graphical User Interface).
MS Excel – Computerized worksheet.
MS Access – is a relational database management program
that can create, format, save maintain, retrieve and analyze volumes of related information or store thousand of data which you can quickly search and sort.
CHAPTER II
REVIEW OF RELATED LITERATURE
will seek for enlistment form for them to list all the subjects and schedules with the corresponding units they are going to enroll for a certain semester.
Registrar for the evaluation. The students will then go to the registrar for the evaluation of their subjects if they are qualified to enroll the certain subject or not. Evaluates the prerequisites and the credentials of the students. This chapter presents literature and studies that will support the development of this study.
2.1. Enlistment Process
Enlistment is one activity of the enrolment process which enables to list the subjects with the corresponding units and schedules. The Enlistment System (ES) is an enrolment tool offering an extensive range of courses and schedules. The ES is available to all students enrolling for college. The primary reason for the development of enlistment process is to develop the enrolment process.
Admission Office for the Enlistment form. The students
Academic Coordinator for the advice. Academic Coordinator will then check the subjects and units that the student listed in the enlistment form. the responsibility of encoding the correct subjects and records of student is normally left to –
Finance Officer for Final Enlistment. Finance Officer will do the final enlistment of the subject with the corresponding units and rooms using the MS Excel to encode that will then appear to the study load of the student after the cashier computes the total fees. This is the main target of the study.
Cashier. Computes the total fees of the student.
School Director. Approved the hardcopy of the study load.
2.1.1. ACLC Enlistment System
This Enlistment System will make the enrollment process faster since ACLC takes a lot more time to finish for the enrollment. This system will help the college lessen the time spent for the listing of the subjects. It prompts the user for the username and password for a secure login. ACLC Enlistment System will allow the authorized person to search, view, add, update and drop the record of the old and new students as well as their corresponding subjects enrolled. In this system the authorized person will also be able to view the list of the students and schedules offered for the certain years in which the authorized person will just going to choose the subject and schedules what the student wants to enroll in. The system uses database, so it means the data will be kept unless it was deleted intentionally. The database used in this system is MS Access Database so that it can easily be accessed. Only and only the authorized personnel will be able to access the system. It will also automatically close the schedules when it reached the maximum limit of the students enrolled.
The system has a few main functions. The user will be able to input the subjects and the corresponding number of units, input the schedules and assigned rooms and delete subjects.
In terms of functional specification, the authorized user can use all of the System's functionality. The system will ask the user to log in once it is opened and will show a navigation menu that makes you to choose either Old Student or New Student. The related functions that the user can be used are those stated below:
Old Student functions:
Search
If you have some things to clarify regarding the subjects and schedules that the student enrolled, this function will allow the user to search the record of the student using the student number.
View
This function allows the user to view all records of the certain student by searching their student number.
Add
To add the subjects with the corresponding schedules that the student wants to enroll in.
Update
Update the current changes that the user made as requested by the students.
Drop
Deletes the subjects enrolled.
New Student functions:
Add
Add the records of the new student.
Database Management System
A Database Management System (DBMS) is a set of programs that enables you to store, modify, and extract information from a database, it also provides users with tools to add, delete, access, modify, and analyzed data stored in one location. A group can access the data by using query and reporting tools that are part of the DBMS or by using application programs specifically written to access the data. DBMS's also provide the method for maintain the integrity of stored data, running security and user access, and recovering information if the system fails. The information from a database can be presented in a variety of formats. Most DBMS's include a report writer program that enables you to output data in the form of a report. Many DBMS's also include a graphics component that enables you to output information in the form of graphs and charts. Database and database management system are essential to all areas of business, they must be carefully managed. There are many different types of DBMS's, ranging from small systems that run or personal computers to huge systems that run on mainframes. It typically supports query languages, which are in fact high level programming languages, dedicated database languages that considerably simplify writing database application programs. Database languages also simplify the database organization as well as retrieving and presenting information from it. A DBMS provides facilities for controlling data access, enforcing data integrity, managing concurrency control, and recovering the database after failures and restoring it from backup files, as well as maintaining database security.
Relational Database Management System
A relational database management system (RDBMS) is a program that lets you create, update, and administer a relational database. Most commercial RDBMS's used the Structured Query Language (SQL) was invented after the development of the relational model and is not necessary for its use.
The leading RDBMS products are Oracle, IBM's DB2 and Microsoft's SQL Server. Despite repeated challenges by competing technologies, as well as the claim by some experts that no current RDBMS has fully implemented relational principles, the majority of new corporate databases are still being created and managed with an RDBMS.
Visual Basic 6.0
Visual Basic is a third-generation event-driven programming language and integrated development environment (IDE) from Microsoft for its COM programming model first released in 1991. Visual Basic was derived from BASIC and enables the rapid application development (RAD) of graphical user interface (GUI) applications, access to databases using Data Access Objects, Remote Data Objects or ActiveX Data Objects, and creation of ActiveX controls and objects. VBA is effectively the same language as Visual Basic but VBA-code is tied to Microsoft Office and can only run within that environment. The scripting language VBScript is a subset of Visual Basic.
A programmer can put together an application using the components provided with Visual Basic itself. Programs written in Visual Basic can also use the Windows API, but doing so requires external function declarations. Though the program has received criticism for its perceived faults, from version 3 Visual Basic was runaway commercial success, and many companies offered third party controls greatly
MS Access
Is a relational database program that can create, format, save, maintain, retrieve and analyze volumes of related information or data in the format known as a database. Can store thousands of data which you can quickly search and sort.
2.2.1. Review of Related Local Literature
These are the related researches that we found as basis on making the proposed system for AMA Computer Learning Center.
Master Jeremiaia Hiruzen Namakazee. "Class Scheduling System".Technical Documentation Presentation.
"The system is intended to help the university in the immediate making of schedules and allocating classrooms with it. The study will help the university to develop and maximize the use of the limited classrooms and facilities. The university administrators are the ones who will be assisted in this study as this will lessen the burden of them in creating schedules especially in assigning or allocating classrooms. The system is only for making class schedules and exact facilitation of classrooms with respect to the number of students per class section and imports the generated schedule data to the enrollment system."
Explanation:
Since the study of Master Jeremiah is making class schedule, the objective of the study is mostly the same with the objective of enlistment which aims to develop a system that will minimize the time spent.
Tyronsoft. "Class Scheduling System".
FIGURE 2.1 Tyronsoft. "Class Scheduling System".
Explanation:
Since the enlistment will contain and store data, the system is flexible when the data is stored, how prepare and performances like how fast the system will be. The statement suggestion is the same of the idea that the enlistment system for AMA Computer Learning Center is same.
CHAPTER III
METHODOLOGY
The development of this study is patterned with the classic life cycle paradigm, which is also called as the Flow Chart. It demands the Assessment of your system, Knowledge Acquisition, Design and Rule Construction, Hardware and Software and finally Maintenance.
3.1 Assessment
The researchers decided to make the enlistment system because researchers observed that the enlistment of AMA Computer Learning Center is manual. (1) The researchers gather information by asking some questions about the flow of enlistment to the admission officer who is assigned for enlistment. (2) Researchers seek enough some information to the internet to develop the idea getting from the admission officer and knowing the interface of enlistment system.(3) Researchers plan the flow of enlistment system, code, design, and software application.(4) Apply the code and design, through Visual Basic and MS Access Database.
3.2 Knowledge Acquisition
The researchers gather information by asking some questions using how, what, when and who about the flow of enlistment system. Seek enough information to the internet to develop the idea getting from the admission officer and knowing the interface of enlistment system using "Google". Plan the flow of enlistment system, code of visual basic, appropriate design for enlistment system and software application like visual basic and MS Access database. Applying and running the system in a correct format what the researchers want.
3.3 Design and Rule Construction
Systems design is the process of defining the architecture, components, modules, interfaces, and data for a system to satisfy specified requirements. Systems design could see it as the application of systems theory to product development. The present research is based on the current enrolment system of AMA Computer Learning Center which uses manual encoding of data into MS Excel. The Flowchart shows the construction of the Enlistment System and the functions.
3.4. Hardware and Software Requirements
These are the following Hardware and Software Requirements in developing the system:
Hardware:
1 unit of IBM compatible computer at least Pentium 4.
90 MB of Random Access memory
At least 40 GB of Hard Disk Drive.
Flash Drives, at least 1 GB
CD-ROM Drive
Standard Serial Mouse
Standard Serial Keyboard
17 SVGA Color Monitor
500 UPS (Uninterruptible Power Supply)
AVR (Automatic Voltage Regulator)
Software:
Operating System ------------ Windows XP/7
Programming Language ---- Visual Basic 6.0
Relational DBMS ------------- MS Access
Data Sources (ODBC) ------ Microsoft Access Driver
3. 5. Maintenance
System maintenance is the routine updating of master files, such as adding and deleting of subjects and students and changing unit limits and subject schedules. Software, or program, maintenance is the updating of application programs in order to meet changing information requirements, such as adding new functions and changing data formats. It also includes fixing bugs and adapting the software to new hardware devices. Systems maintenance can be de ned simply as changes made to systems or applications software to maintain an effective, efficient, operational, and up-to-date system. These changes which are generally requested by system users or provided by vendors or programmers, are made to meet user's requirements or correct minor system errors before they become major problems. Maintenance can be applied to several areas within the IT facility, including:
Systems hardware
Systems software
Database software
Applications software
3.5 Conceptual Framework
Start
Start
Processing
Processing
Login, Input and Password
Login, Input and Password
Processing
Processing
Choose New Student/ Old Student, Logout
Choose New Student/ Old Student, Logout
NEW STUDENT OLD STUDENT
Fill up the information, student information and the subjects to be enrolled.Search the student record using student number
Fill up the information, student information and the subjects to be enrolled.
Search the student record using student number
End
End
BA
B
A
Returning to MenuReturningChoose, Save, Cancel and BackFill up the information, student information and the subjects to be enrolled.A
Returning to Menu
Returning
Choose, Save, Cancel and Back
Fill up the information, student information and the subjects to be enrolled.
A
SAVE CANCEL
STORAGE
STORAGE
Returning
Returning
BACK
B
B
Search the student record using student number
Search the student record using student number
Processing
Processing
Add the subject to be added.
Add the subject to be added.
Returning to MenuViewing the student record
Returning to Menu
Viewing the student record
Save, Cancel, Back
Save, Cancel, Back
SaveChoose, Add, Drop, Search, Menu
Save
Choose, Add, Drop, Search, Menu
BACK ADD
Return
Return
BACK
Return SEARCH
Return
Viewing the student records and you can drop the subject that has been enrolled.Select subject to be dropped
Viewing the student records and you can drop the subject that has been enrolled.
Select subject to be dropped
DROP
ReturnSave, Cancel, Back
Return
Save, Cancel, Back
Return SAVE CANCEL SAVE CANCEL
Return
Save, Cance, BackSaveSave
Save, Cance, Back
Save
Save
ReturnReturn
Return
Return
ReturnReturn BACK BACK
Return
Return
CHAPTER IV
This chapter shows the database design of ACLC Enlistment System: the Entity Relationship model and the data entry screen.
4.1 Entity Relationship Model
In this figure, then Entity Relationship Model of the ACLC Enlistment relationships were System of AMA Computer Learning Center presents the one-to-one (1:1) discussed in the model of the relation.
Section
Subject code
Description
Unit
Time
Day
Room
Student Information
Student_id
Firstname
Middle
Lastname
Address
Department
Student _Section
Student_id Subject_id
Firstname Description
Middlename Units
Lastname Day
Depertment Ctime
Section Room
Figure 4.1 Entity Relationship Diagram
4.2 Normalize Relationship and Functional Dependencies
The normalization and functional dependencies were examined in the design.
The underline attribute is the primary key.
Table 1 Normalized Table of Entity and Attributes
Student Information
(Student_id, Firstname, Middlename, Lastname, Address, Department)
Section
(Subject code ,Description, Unit, Time, Day, Room)
Student Information/ Section
(Student_id, Section)
4.3 Data Definition
This table shows the attribute name with its corresponding description and data type.
Table 2 Data Definition
NAME
DESCRIPTION
DATA TYPE
Student_id
The primary key of the Student information/Section/Student_info-Section table that serves as an unique identifier of the user
Number
Firstname
First name of the student
Text
Middlename
Middle name of the student
Text
Lastname
Last name of the student
Text
Address
Address of the student
Text
Department
Department/Course of the student
Text
Subject_code
Code of the subject
Text
Description
Description of the subject
Text
Unit
Unit of the subject
Number
Time
Time of the subject
Varchar
Day
Day of the subject
Text
Room
Room of the Student
Number
Section
Section assigned to the student
Text
4.4 Data Entry Screen
Figure 1 Log-in Form
Log-in Form, the user will put his/her valid username and password. This form is used to assure that only the authorized user can open the system.
Figure 2 Selection Form
Selection Form the user can choose whether it is old Student or to register a new student.
Figure 3 Main Menu
Main Menu of the system in which you can choose whether it is to add, update, drop, and search the records of students.
Figure 4 Student Information Form
Student Information Form. This is data entry form for new students. The user will input the student id, first name, middle name, last name, address, department, and phone number of the new student.
Figure 5 Adding Subject Form
Adding Subject Form. This is the data entry form in which the user can search the preferred section of the student and can choose the subjects the student wants to enroll in.
Figure 6 Edit Subject Form
Edit Subject Form. This is data entry form in which the user will input the student number to be able to view, edit, update and drop the list of the subjects enrolled.
Figure 7 Student Drop Form
Student Drop Form. The user will input the id number of the student to drop in college.
Figure 8 Add Subject Form
Add Subject Form. The user will input the assigned section, subject code, description if the subject, units, day, time, and room of the subject to be added. This will also delete, update, edit, and search the intended subject.
Figure 9 Student's Profile Form
Student's Profile Form. The user will input the id number of the student and will be able to view the name, department, section and subjects enrolled. The user will also be able to edit, update, add and drop the subjects.
CHAPTER V
SUMMARY OF FINDINGS, CONCLUSIONS AND RECOMMENDATIONS
This chapter discusses the summary, conclusion and recommendation of the software "Enlistment System".
Summary
It has been always the aspiration of humankind to create devices that would simplify the work of people. With the invention of computers, many businesses have taken the leap to implement automated systems as to maximize the productivity of their business in terms of good efficiency, speed, accuracy and since ACLC-SF is known to have good learning when it comes to computer-related courses, it was expected by the people that it also runs a good system.
Apparently, ACLC-SF is still using the manual system in the enrolment, so the researchers decided to propose and develop an enlistment system that would maximize the productive potential and would minimize the time spent of the college during the enrolment. All these with the use of data gathering and statistical tools such as surveys, observations and interviews, the researchers are able to determine the difference and measure the effectiveness of the existing and the proposed system.
Findings
The manual system provides students with tools to maximize the time spent during the enrolment period. The current system is not capable of tracing the availability of all the subjects enlisted by the students and provides a possibility of loss of files.
The solution to the problem encountered with the manual system is to develop a computerized enlistment system that would lessen the period of enrolment process.
The proposed enlistment system is feasible for implementation.
Conclusions
Based on the findings, the researchers come up with the following conclusions:
The proposed enlistment system will be a big improvement over the existing manual system such that it provides the students faster service during the enrolment period. Aside from that, it also gives the user the faster way of enlisting the subjects for the students.
The proposed system will be a substantial improvement over the current system for students and staff. The implementation of the system can therefore maximize the productive potential of the college.
As a whole, the proposed system and the existing system have a tremendous distinction. The difference from the traditional to the proposed system is truly beneficial to the college, staff and students.
Recommendations
Based on the results of the findings and conclusions gathered, the researchers would like to recommend the following:
The proponents recommend that the college consider the proposed enlistment system to increase the number of enrolled students per day in such way that it would help lessen the spent time and also maximize the productive potential of the college.
The proponents recommend the proposed system be implemented by the school director, students and staff because it is more productive and more capable of giving quality performance during enrolment period.
The proponents recommend that the future researchers continue to improve the proposed system.
Appendix A
FORM USED BY THE COLLEGE
Appendix B
SOURCE CODES
LOGIN Button
Private Sub cmdLogin_Click()
Call connect
rs.Open "select * from login where username='" & Text1.Text & "'", con, OpenDynamic
If Not rs.EOF Then
If Text1.Text = rs!UserName And Text2.Text = rs!Password Then
MsgBox ("Welcome User!"), 0, "Access Granted!"
selection.Show
Me.Hide
Else
MsgBox ("Login Error"), vbCritical, "Error!"
End If
rs.Close
End If
End Sub
CANCEL BUTTON
Private Sub Command1_Click()
Dim a As String
a = MsgBox("Are you sure you want to cancel?", vbYesNo, "Information")
If a = vbYes Then
End
Else
login.Show
End If
End Sub
SAVE BUTTON
Private Sub Command8_Click()
Call connect
If Text1.Text = "" Or Text2.Text = "" Or Text3.Text = "" Or Text4.Text = "" Or Text5.Text = "" Or Text6.Text = "" Or Text7.Text = "" Then
Else
con.Execute "insert into student_info values('" & Text1.Text & "','" & Text2.Text & "','" & Text3.Text & "','" & Text4.Text & "','" & Text5.Text & "','" & Text6.Text & "','" & Text7.Text & "')"
Unload Me
search.Show
End If
con.Close
End Sub
VIEW BUTTON
Private Sub Command1_Click()
Call connect
rs.Open " select * from student_section where Student_id = '" & Text1.Text & "'", con, adOpenDynamic
If Not rs.EOF Then
If Not rs.EOF Then rs.MoveFirst
Do Until rs.EOF
Set Item = ListView1.ListItems.Add(, , rs!Subject_code)
Item.SubItems(1) = rs!Description
Item.SubItems(2) = rs!Units
Item.SubItems(3) = rs!Day
Item.SubItems(4) = rs!cTime
Item.SubItems(5) = rs!Room
Item.SubItems(6) = rs!Section
Item.SubItems(7) = rs!department
rs.MoveNext
Loop
Else
MsgBox "Student ID not Found!"
Command1.Enabled = False
rs.Close
End If
End Sub
DROP BUTTON
Private Sub Command4_Click()
Call connect
Dim a As String
a = ListView1.ListItems(ListView1.SelectedItem.Index)
rs.Open "delete from student_section where Subject_code & Student_id = '" & (a) & "' & '" & Text1.Text & "'", con, adOpenDynamic
MsgBox " successfully deleted!!", vbInformation
rs.Open " select * from student_section where Student_id = '" & Text1.Text & "'", con, adOpenDynamic
ListView1.ListItems.Clear
If Not rs.EOF Then
If Not rs.EOF Then rs.MoveFirst
Do Until rs.EOF
Set Item = ListView1.ListItems.Add(, , rs!Subject_code)
Item.SubItems(1) = rs!Description
Item.SubItems(2) = rs!Units
Item.SubItems(3) = rs!Day
Item.SubItems(4) = rs!cTime
Item.SubItems(5) = rs!Room
Item.SubItems(6) = rs!Section
Item.SubItems(7) = rs!department
Text10.Text = rs!Firstname & " " & rs!Middlename & " " & rs!Lastname
rs.MoveNext
Loop
End If
DROP BUTTON
Private Sub Command1_Click()
Call connect
Dim a As String
rs.Open "select * from student_info where student_id ='" & Text1.Text & "'", con, adOpenDynamic
If Not rs.EOF Then
a = MsgBox("Are you really want to drop this student?", vbYesNo)
If a = vbYes Then
con.Execute "delete from student_section where student_id='" & Text1.Text & "'"
con.Execute "delete from student_info where student_id='" & Text1.Text & "'"
MsgBox ("Deleted!"), 0, "Delete"
Text1.Text = ""
Label3.Caption = ""
Else
End If
Else
MsgBox ("Student Id Not Found!"), 0, "Try Again"
Text1.Text = ""
Label3.Caption = ""
End If
Exit Sub
con.Close
End Sub
BACK BUTTON
Private Sub Command2_Click()
Form1.Show
Me.Hide
End Sub
OK BUTTON
Private Sub Command3_Click()
Call connect
Command1.Enabled = True
rs.Open "select * from student_section where student_id ='" & Text1.Text & "'", con, adOpenDynamic
If Not rs.EOF Then
Label3.Caption = rs!Firstname + " " + rs!Middlename + " " + rs!Lastname
Else
MsgBox "Student not found!"
Text1.Text = ""
Label3.Caption = ""
End If
End Sub
ADD DROP
Private Sub Command9_Click()
Call connect
rs.Open "select * from student_section where subject_code & ctime ='" & Text13.Text & "' & '" & Text19.Text & "'", con, adOpenDynamic
If Not rs.EOF Then
If Text13.Text = rs!Subject_code And Text19.Text = rs!cTime Then
MsgBox "Subject and Time are conflict!"
End If
Else
con.Execute " insert into student_section values ('" & Text12.Text & "','" & Text1.Text & "','" & Text14.Text & "','" & Text15.Text & "','" & Text3.Text & "','" & Text4.Text & "','" & Text13.Text & "','" & Text16.Text & "','" & Text17.Text & "','" & Text18.Text & "','" & Text19.Text & "','" & Text20.Text & "')"
MsgBox "Succesfully Saved !!! ", vbInformation
Set Item = ListView1.ListItems.Add(, , Text13.Text)
Item.SubItems(1) = Text16.Text
Item.SubItems(2) = Text17.Text
Item.SubItems(4) = Text18.Text
Item.SubItems(3) = Text19.Text
Item.SubItems(5) = Text20.Text
con.Close
End If
End If
End Sub
DROP BUTTON
Private Sub Command5_Click()
rs.Open "delete from student_section where Subject_code & Student_id = '" & (a) & "' & '" & Text12.Text & "'", con, adOpenDynamic
MsgBox " successfully deleted!!", vbInformation
rs.Open " select * from student_section where Student_id = '" & Text12.Text & "'", con, adOpenDynamic
ListView1.ListItems.Clear
If Not rs.EOF Then
If Not rs.EOF Then rs.MoveFirst
Do Until rs.EOF
Set Item = ListView1.ListItems.Add(, , rs!Subject_code)
Item.SubItems(1) = rs!Description
Item.SubItems(2) = rs!Units
Item.SubItems(3) = rs!Day
Item.SubItems(4) = rs!cTime
Item.SubItems(5) = rs!Room
rs.MoveNext
Loop
End If
End If
rs.Close
End Sub
ADD BUTTON
Private Sub Command10_Click()
Call connect
Dim ask As String
rs.Open "select * from section where subject_code & ctime ='" & Text2.Text & "' & '" & Text6.Text & "'", con, adOpenDynamic
If Not rs.EOF Then
If Text2.Text = rs!Subject_code And Text6.Text = rs!cTime Then
MsgBox "Subject and Time are conflict!"
End If
Else
a = MsgBox("do you want to ADD this Record ??", vbYesNo)
If a = vbYes Then
con.Execute "insert into section values ( '" & Text2.Text & "', '" & Text3.Text & "', '" & Text4.Text & "', '" & Text5.Text & "', '" & Text6.Text & "','" & Text7.Text & "','" & Text1.Text & "')"
MsgBox "Successfully Added"
Set Item = ListView1.ListItems.Add(, , Text2.Text)
Item.SubItems(1) = Text3.Text
Item.SubItems(2) = Text4.Text
Item.SubItems(4) = Text5.Text
Item.SubItems(3) = Text6.Text
Item.SubItems(5) = Text7.Text
Item.SubItems(6) = Text1.Text
Else
MsgBox " Not Recorded !!!", vbInformation
Exit Sub
duplicate:
MsgBox "Duplicate Subject Code!"
con.Close
End If
End If
End Sub
DELETE BUTTON
Private Sub Command11_Click()
Dim a As String
Dim b As String
a = ListView1.ListItems(ListView1.SelectedItem.Index)
b = MsgBox("Are you sure you want to delete this subject?", vbYesNo)
If b = vbYes Then
rs.Open "delete from section where Subject_code & sec= '" & (a) & "' & '" & Text1.Text & "'", con, adOpenDynamic
MsgBox " successfully deleted!!", vbInformation
Else
MsgBox "Canceled!"
End If
End If
rs.Close
End Sub
EDIT BUTTON
Private Sub Command6_Click()
Command8.Visible = True
Call connect
Dim a As String
a = ListView1.ListItems(ListView1.SelectedItem.Index)
rs.Open "select * from section where Subject_code = '" & (a) & "'", con, adOpenDynamic
If Not rs.EOF Then
Text2.Text = rs!Subject_code
Text3.Text = rs!Description
Text4.Text = rs!Units
Text5.Text = rs!Day
Text6.Text = rs!cTime
Text7.Text = rs!Room
rs.Close
End If
End Sub
SEARCH BUTTON
Private Sub Command9_Click()
Call connect
rs.Open " select * from section where sec = '" & Text1.Text & "'", con, adOpenDynamic
If Not rs.EOF Then
Do Until rs.EOF
Set Item = ListView1.ListItems.Add(, , rs!Subject_code)
Item.SubItems(1) = rs!Description
Item.SubItems(2) = rs!Units
Item.SubItems(4) = rs!Day
Item.SubItems(3) = rs!cTime
Item.SubItems(5) = rs!Room
rs.MoveNext
Loop
rs.Close
End If
End Sub
BACK BUTTON
Private Sub Command12_Click()
selection.Show
Unload Me
End Sub
EDIT BUTTON
Private Sub Command2_Click()
Call connect
con.Execute "update student_info set Firstname ='" & Text1.Text & "' where student_id='" & Combo1.Text & "'"
con.Execute "update student_info set Middlename ='" & Text2.Text & "' where student_id='" & Combo1.Text & "'"
con.Execute "update student_info set Lastname ='" & Text3.Text & "' where student_id='" & Combo1.Text & "'"
con.Execute "update student_info set Address ='" & Text4.Text & "' where student_id='" & Combo1.Text & "'"
con.Execute "update student_info set Department ='" & Text5.Text & "' where student_id='" & Combo1.Text & "'"
con.Execute "update student_info set Phone_number ='" & Text6.Text & "' where student_id='" & Combo1.Text & "'"
'('" & Combo1.Text & "','" & Text1.Text & "','" & Text2.Text & "','" & Text3.Text & "','" & Text4.Text & "','" & Text5.Text & "','" & Text6.Text & "')"
Dim a As String
a = MsgBox("Are you sure?", vbYesNo)
If a = vbYes Then
MsgBox ("save!"), 0, "Success!"
Else
MsgBox "Nothings Change!", vbOKOnly
End If
End Sub
SEARCH BUTTON
Private Sub Command1_Click()
Call connect
rs.Open "select * from student_info where student_id ='" & Combo1.Text & "'", con, OpenDynamic
If Not rs.EOF Then
Text1.Text = rs!Firstname
Text2.Text = rs!Middlename
Text3.Text = rs!Lastname
Text4.Text = rs!address
Text5.Text = rs!department
Text6.Text = rs!phone_number
Else
MsgBox "Not Found!", 0
End If
End Sub
BACK BUTTON
Private Sub Command3_Click()
Unload Me
selection.Show
End Sub
BIBLIOGRAPHY
https://weblearn.ox.ac.uk/portal/help/TOCDisplay/content.hlp?docId=ses_overview
http://www.studymode.com/subjects/grading-and-class-scheduling-system-thesis-page1.html
http://prezi.com/adwniwjatxej/class-scheduling-system
http://www.sourcecodester.com/visual-basic/3818/class-scheduling-system.html .
http://www.dubberly.com/articles/what-is-systems-design.html
http://en.wikipedia.org/wiki/Systems_design
http://www.pcmag.com/encyclopedia_term/0,1237,t=maintenance&i=46542,00.asp
http://www.dissertationwriting.com/write-dissertation-methodology-help.shtml
Appendix C
CURRICULUM VITAE
Name : Edwin Mendoza Walley
N-name : Dwin / Win2x
Age : 20
Address : P-3,Crossing Pinahan,
San Andres, Bunawan, Agusan Del Sur
Gender : Male
Contact # : 09126887023
Email Address :
[email protected]
Birthday : May 21,1992
Motto : Don't mind your problem, let problem mind you
Parents : Mr. Santiago B. Walley Sr.
Mrs. Leonida M. Walley
Name : Ernalyn Lozada Ramos
N-name : Lyn2x
Age : 21
Address : P-2, Brgy. 5 San Francisco, Agusan del Sur
Gender : Female
Contact # : 09109683389
Email Address :
[email protected]
Birthday : June 18, 1991
Motto : Mistake is not the end of your ambition,
Mistake is the inspiration of being successful.
Parents : Mr. Ernesto Valdez Ramos
Mrs. Gerelyn Lozada Ramos
Name : Sheila Mae R. Raganas
N-name : She / Sheng
Age : 23
Address : P-3, Prosperidad Agusan Del Sur
Gender : Female
Contact # : 09078282299 / 09271044102
Email Add :
[email protected]
Birthday : May 11,1989
Motto : Learn from the past, plan for the future by focusing on today. It is better to take the hardship of education than to taste the bitterness of ignorance.
Parents : Mr. Raul R. Raganas
Mrs. Lolita R. Raganas
Name : Chairell Balderas Morta
N-name : Chai-chai / Charie
Age : 18
Address : P-3, Maharlika,Talacogon Agusan Del Sur
Gender : Female
Contact # : 09095883443
Email Address :
[email protected]
Birthday : June 16, 1994
Motto : If anything is worth doing, it's worth overdoing.
Parents : Mr. Junel Morta
Mrs. Arlene Morta
Name : Madel Alidon Corvera
N-name : Madz / Del
Age : 19
Address : P-8, Poblacion, Prosperidad, Agusan del Sur
Gender : Female
Contact # : 09074453313
Email Address :
[email protected]
Motto : Your business is your business; mine is mine.
No one knows anyone.
Your mother didn't know you outside the house.
Parents : Mr. Leodel Laurente Corvera
Mrs. Marlyn Alidon Corvera
Name : Aljon Grabillo Clamucha
N-name : Jon / John loyd
Age : 21
Address : P-1, Wasian, Rosario, Agusan del Sur
Gender : Male
Contact # : 09126886322
Email Address :
[email protected]
Birthday : April 21, 1991
Motto : There are mystically in our faces certain characters which carry in them the motto of our souls, wherein he that cannot read A,B,C may read our natures.
Parents : Mrs. Nora G. Clamucha
Mr. Alfredo H. Clamucha
