I.

SchEd – Class Scheduling System Commented [BS1]: Update your title to a more formal
and technical title

Mobile Class Schedule Information System

Submitted By:
Yangan, Jeffrey P.
Magpulong, Jun Alfer Z.
Gomez, Rica
Ong, Jason
Lata
Alo, Christian Anthony
Layam, John Paul
 CHAPTER 1

1.0 Introduction

The world seems to be rapidly evolving towards modernization and continuously gearing

up on becoming a technology-driven planet because of the changes information technology offers.

IT infrastructures have already invaded various aspect of our lives. Technology is the making,

modification, usage, and knowledge of tools, machines, Techniques, crafts, systems and methods

of organization, in order to solve a problem, improve a pre- existing solution to a problem, achieve

a goal, handle an applied input or output relation or perform a specific function. They become vital

instruments in our activities. More and more establishments, institutions and organizations both

public and private, are instituting IT systems in their operations to achieve better speed, accuracy

and efficiency in the quality of their works. Obviously, the school/institute is the one that would

benefit at most because the system would eliminate the tedious task of manual scheduling or time

tabling of the availability of faculty, students and classrooms and it would be the greatest

contribution of an IT could impart to the school/institute.

An I.SchEd which “I” means my/mine or me and “SchEd” for class schedule is a mobile

application system that allows someone/students to construct schedules, search your schedule

rooms through given UI images from school gate to desire destination, small video clips and school

mapping in an easier, faster and more accurate. This information is generally useful for students

especially for new students who do not have the knowledge of each buildings and rooms.

Students/end-users can also monitor if they have class session on each schedule time every day.

The admin arranged class schedule, and Instructors are the master control of each room schedules.

They have the prior to modify, post update/notification and receive students’ message concern.
 It is a fact that arranging class schedules, instructor’s load and room utilization for the

students and faculty in every department is one of the many activities that each department heads

as well as the administration must be prepare before classes start. But the school used the manual

way of preparing the class schedule. With the manual system, more time and labor force is required

to plot, arrange, and revise the class schedules, rooms’ utilizations and instructor’s load provided

by the department heads. So we decide to create system that brought out of our knowledge for Commented [BS2]: Avoid 1st person references

faster and easiest way.

1.1 Objectives

General Objectives:

This aims to create and develop a class scheduling system through android application for

a collaborative preparation of class schedules at Northwestern Mindanao State College of Science Commented [BS3]: Remove or retain this?

This line implies that your system will provide interfaces and
and Technology (NMSCST) in faster, easier, and more accurate which each students especially
mechanisms that allow the deans and secretaries from
different departments create a class schedule
for new students and transferees will be able to find their schedule rooms and know each schedule collaboratively to avoid class conflicts.

If you wish to retain, please update your specific objectives.

time sessions.

Specific Objectives:

The development of I.SchEd class scheduling system simplify the:

 The students will be able to know their instructors’ profile and what subject/time

they handle.

 The students are capable of sending message to their instructors.

 The students will be able to know if they have class on given time schedule.
  The students will be able to know the rooms’ location through images, video

clips, and school map.

1.2 Scope and Limitation

Scope

The thesis project focuses on the creation of class scheduling system through mobile

application that allows end-users/students to be able to know each room schedule and what time

schedule would the instructors will be teaching or not and the instructors are the one who control

system. Commented [BS4]: For each objective please explain

what aspects will and will not be included in your study. The
explanation should be in paragraph form

Limitation

The design system only support android device and cannot operate if no data used. The

system is set only for the school of Northwestern Mindanao State College of Science and

Technology.
 Chapter 2

Review of Related Literature and Studies

Now a days, technologies become usually a part of our daily life. Research has increasingly
important for institutions. The literature and studies cited in this chapter tackle the prospects of
Institutions, as well as the process of scheduling.

Foreign Literature and Studies

There has been a significant studies about scheduling. In particular, Conception L. Khan
conduct a study “This work designed and developed a class-scheduling system that will allow
collaborative preparation of schedules among several users. The system integrated five
components: the data management module, course assignment module, scheduling module, result
storage module, and the report module. It has an engine that uses the greedy algorithm for creating
schedules and detecting conflicts.” This study is closely related to our study for it directly mentions Commented [BS5]: Very large quotation please adjust or
rephrase to remove quotation
the modules of scheduling. A Course Scheduling System for the Executive Education Unit at the
Universidad de Chile by Jaime Miranda according to her “The application will be able identify
and prevent schedule conflicts eliminating common problems in the scheduling process. It
may be used to produce an on-time, reliable, conflict-free, and efficient schedule taking
into account the different entities attached such as block, room, course and faculty. The
schedule generated will be used as a valuable data in the registration thus minimizing registration
problems frequently encountered due to scheduling errors.” This study is relevant to the future Commented [BS6]: Very large quotation again

studies in that it tackled about scheduling. Also Through the application, unit registrars can easily
identify these vacant courses. The application will also consider the maximum allowed number
of students in a room to fit which block is to accommodate. Faculty workload can be easily
prepared because the application includes the scheduling of faculty members to handle a course.
The problem on uneven distribution of teaching loads can be easily addressed. At the same time,
the need for additional faculty to handle excess teaching loads can be determined and addressed
earlier.
Local Literature
Khavee Agustus W. Botangen states that The occurrences of problems relative to the
scheduling of classes in the academic units that used the application were compared with the
five academic units that did not use it. In the comparisons made, there is a significant effect of
the use of the application to the occurrences of the observed scheduling problems. This work aimed
to develop, implement, and evaluate a web-based scheduling application for a collaborative
preparation of class schedules at the Central Luzon State University. The development
integrated an algorithm for automated plotting and conflict-checking of the different
scheduling entities based on their availability considering different constraints and preferences.
The application was deployed using a free Virtual Private Network software, Hamachi. Four
academic units in the University collaboratively created their class schedules using the scheduling
application.

Local Studies

Integrated Class Scheduling System for Selected State Universities and Colleges with Satellite
Campuses in the Philippines by Digna S. Evale her study This study aimed to develop a new system
that will provide those colleges and universities with satellite campuses a new, easy and quick way
of creating and generating room, class and individual faculty time-table and at the same time allows
users to automatically detect and prevent conflicts upon the creation of schedule. The study used
an appropriate development method for the system design and analysis. Then, the researchers the
most suitable programming language and database that were utilized in the development of a
reliable scheduling system intended for deployment via a suitable on-line access. Her study is
relevant to the present study. However she dealt mostly with the scheduling procedures.
The present study like the article reviewed aims to establish a connection on the various
websites used by the students and their impact on the society.
 Chapter 3

Methodology

3.1 Requirements Analysis

3.1.1 Project Design

The method used in this project is prototyping. The said method is a systems development

method which prototype is being tested and experimented until it finally achieved the complete

system. Prototyping helps the in order for the researchers/developers can identify and avoid false

errors that might occur later in the development of the system. Commented [BS7]: Add diagram of prototyping SDLC.

Current Technical Situation

The NMSCST admin print out every Certificate of Registration (COR) after students finishes their

enrolment requirements. In COR, it contains every student’s information such as personal profile,

account details and every subject schedules and name of rooms. The students will locate which or

what rooms in their specific subject schedules. The problem is that new students or transferees

encounter difficulty in finding the rooms. Commented [BS8]: There should be a freestyle diagram
here to depict what is being explained in this narrative. The
narrative should talk about the current situation of how
students gather information on their class schedule and
room locations. It’s limitations and problems.
3.1.2 Existing DFD Commented [BS9]: Add a narrative for this DFD
Commented [BS10]: Please portrait this diagram
3.2 Requirement Documentation

3.2.1 Functional Requirements

 Student /Instructor Registration

The admin will create an account both student and instructor in order for them to

enter or login on the application system.

 Account Login

All users can login with their account.

 Add, Edit, Update

Every instructor can add, edit, and update every subject they handle particularly the

subject codes, rooms, and time and they can also modify their profile.

 Controls the system app

All instructor is able to manipulate the control of the system app through dragging

the bar icon that notify if it is not active which is color black, green for active/class and red

for no class and it can leave message to specific rooms and every student can receive and

read it.

 Monitor/Message

All students are able to monitor the schedule through searching their specific rooms

in system app and they are able to read and leave message to their subject instructor.

3.2.2 Non-Functional Requirements

  Internet Connectivity

The system app will not work without internet connection.

3.2.3 Software and Hardware Tools

Software

 Android Studio- is software Integrated development environment (IDE) that support and

design for creating and developing android application.

Hardware

 Laptop – use to run android studio and develop android application.

 Android Phone/Table – it is the main device to run the developing application.

 Modem/Wifi/Router – it the life of the system application, without internet, the system app

is dead.
3.3 Design of Software, System and Processes

3.3.1 Conceptual Framework (I.P.O Diagram) Commented [BS11]: Update your system name on this
diagram

INPUT OUTPUT PROCESS

Planning
Knowledge Requirements  Develop a system app
that will help students
of NMSCST to locate
Related Literature and know or aware of
their classes.
 The importance of Class I.SchEd – Class
Scheduling to Design Scheduling
Universities System
 Physical and logical
Related System design of the system.

 NMSCST enrolment System Development

system and scheduling
 Coding/Programming
Gather Data
System Testing
 Enrolment scheduling
 Alpha and Beta
Hardware Requirements Testing

 Laptop: Acer/Dell
 Flash Drive: Sandisk
 Smart Pocket Wifi/LTE
router- 10 MBPS
Software Requirements
 Android Studio

Figure 3.3.1 I.P.O Diagram

3.3.2 Context Diagram Commented [BS12]: Information lines should be labeled
with nouns, not action words.

ADMIN INSTRUCTOR

Manage Student Schedule Receive Student Message

Manage Room Location I.SchEd- Class Sent Notification to Student

Scheduling
Input Subject Schedules Manage/Control Student Classes

Sent Message to Instructor

Search room location Monitor Classes

STUDENT
Receive Classes Info Receive Notification Message

Figure 3.3.2 Context Diagram I.SchEd Class Scheduling

3.3.3 Proposed Data Flow Diagram (D.F.D)

a. Instructor Login

instructor_details
Instructor Login
Invalid_instructor_details

instructor_info
instructor_info instructor_info

Add, Edit,
Update tbl_instructor tbltbl_login_logs
Instructor Add_Edit_Update_instructor_info
Account

Narrative:

The admin provide instructor account with the username and password. If given details is

mismatch or invalid, the system app will confirm error. The instructor should provide correct

details in order to login and access the system app.

b. Student Login
student_details
Student
Login
invalid_student_details

student_info
student_info student_info

Add, Edit,
Update
tbl_student tbl_login_logs
Instructor
Add_Edit_Update_student_info
Account
Narrative:

The admin provide student account with the username and password. If given details is mismatch

or invalid, the system app will confirm error. The student should provide correct details in order

to login and access the system app.

c. Add, Edit, Update Subject and Room Schedule

subject_details verified_subject_details
Instructor
Verify
room_details

Verified_room_
details tbl_subject
tbl_room_schedule
Narrative:

Every instructor is able to add, edit, and update subject schedules as well as the changing of room

if it is available to occupy and used for classes. When details submitted, it will be verified and save

in system app database.

d. Upload Subject Schedule

Instructor sent_subject_schedule
Verify

verified_sent_subject_schedule

tbl_subject_schedule
sent_subject_schedule_info Upload
Narrative:

In this process, the instructor will sent or upload subject schedule through swiping bar icon and

the details will be save to system app database.

e. Upload Classroom Location

image_video_clip_map_details
Admin
Upload

tbl_room_location

Narrative:

The admin insert image, video clip, and map and save it to the system app database and soon use

for the student to locate room location.

f. Search

details subject_details
tbl_subject
Student Search
details
search_details_info subject_schedule_details

tbl_subject_schedule

tbl_instructor
instructor_info

tbl_room_location
room_location_info
Narrative:

The student will search certain details like course subject, room location, and instructor subject

schedule in the system app. The data that stored in the database will be retrieving and student can

receive that details information.

3.3.4 Entity Relationship Diagram

Physical Database Design

3.3.5 Data Dictionary

Table Name Field Name Data Length Not Auto- Primary

Increment Key
Type Null

tbl_intructor Instructor_ID int 11 YES YES YES

Username varchar 50 YES

Password varchar 50 YES

tbl_instructor_login_log Instructor_ID int 11 YES YES YES

Date_Time datetime YES

tbl_student Student_ID int 11 YES YES YES

Username varchar 50 YES

Password varchar 50 YES

tbl_student_login_logs Student_ID int 11 YES YES YES

Date_Time datetime YES

tbl_subject Subject_ID int 11 YES YES YES

Subject_Code varchar 50 YES

Subject_Name varchar 75 YES

Subject_Time time YES

Subject_Date date YES

 tbl_subject_schedule Subject_ID int 11 YES YES YES

Subject_Code varchar 50 YES

Subject_Name varchar 75 YES

Subject_Time varchar YES

Subject_Date date YES

Classroom_ID int 11 YES YES YES

tbl_room_schedule Classroom_ID int 11 YES YES YES

Classroom_Code varchar 50 YES

Classroom_Name varchar 75 YES

Subject_ID int 11 YES

tbl_room_location Classroom_ID int 11 YES YES YES

Classroom_images longblob YES

Classroom_video_clip longblob YES

Class_room_map longblob YES

3.3.6 Use Case Diagram- MANGAYO KO SAMPLE ANI SIR BILL

3.3.7 Mock GUI ( NOT FINAL PROTOTYPE)

Welcome Screen

Home Screen

Welcome Screen
Student/Instructor Login Screen
Instructor Login Form
Instructor Home Screen
Instructor Schedule Command
Instructor Add, Edit, Update Subject and Profile
Instructor Create Notification Message
Student Login Form
Student Home Screen
Classroom Location Guide
chedule
Notification Message from Instructor