Republic of the Philippines

ISABELA STATE UNIVERSITY

Roxas Campus

INSTITUTE OF INFORMATION AND COMMUNICATIONS TECHNOLOGY

Course Syllabus
Second Semester, School Year 2021 – 2022

IT 221 Information Management 3 5 hours

Course Number Course Title Credit Unit/s Hours per Week

VISION INSTITUTIONAL OUTCOMES

A leading research university in the ASEAN region.
Skilled Communicator (SC)
MISSION ● Recognizes and values communication as a tool for conveying and interacting with
The Isabela State University is committed to develop globally competitive human, others and fostering their own learning.
technological resources and services through quality instruction, innovative research,
responsive community engagement and viable resource management programs for Inquiry-focused and Knowledgeable (IFK)
inclusive growth and sustainable development. ● Creates new knowledge and understanding through the process of research and
inquiry.
QUALITY POLICY ● Demonstrate comprehensive theoretical and technical concepts related to their field of
The Isabela State University is determined to be a lead university in instruction, specialization with relevant connections to industry, professional and regional
research, extension and resource generation through continual improvement of services knowledge.
and commits to comply with the standards set by statutory, regulatory and accreditation
bodies. Competent and Productive Professional (CPP)
To uphold this commitment, ISU shall attain the following quality objectives: ● Initiates and innovates better ways of doing things
1. Sustain academic excellence and quality in instruction; ● Promotes quality and productivity
2. Generate research breakthroughs;
3. Engage in sectoral activities for community development; Collaborative and Effective Leader (CEL)
4. Develop products for glocalization; ● Works in collaboration with others and manages group functioning to meet common
5. Support students participation to local and international fora to enhance their goal
potentialities; and
6. Review on periodic basis, the Quality Management System (QMS) and gather Lifelong Learner (LL)
feedback on the level of client satisfaction as basis for continual improvement. ● Acquires new skills and adapts to rapid changes in professional and personal
environments

GOALS OF THE COLLEGE PROGRAM OUTCOMES

In line with the Isabela State University’s vision and mission, the Institute Information The graduates of the Bachelor of Science in Information Technology Program must be able to:

ISUR-ICT-Syl-014
Effectivity: August 1, 2018
Revision: 1
 and Communication Technology (IICT) is tasked to provide each student an equal PO1- Knowledge for Solving Computing Problems
opportunity to develop their computer skills based on the current relevant curricula. This  Apply knowledge of computing, science, and mathematics appropriate to the
scholastic preparation associated with different extra-curricular activities and other discipline
related matters in research extension, and resource generation is necessary to build  Understand best practices and standards and their applications
knowledge and experience to establish a powerful foundation in computer and PO2- Problem Analysis
information systems. Through this, the college shall produce technological-oriented,  Analyze complex problems and identify and define the computing requirements
globally competent and effective IT graduate imbued with moral values in their chosen appropriate to its solution
profession.  Identify and analyze user needs and take them into account in the selection, creation,
evaluation and administration of computer - based systems
PROGRAM OBJECTIVES PO3- Design/Development of Solutions
The BSIT program includes the study of the utilization of both hardware and software  Design, implement and evaluate computer - based systems, processes, components,
technologies involving planning, installing, customizing, operating, managing and or programs to meet desired needs and requirements under various constraints
administering, and maintaining information technology infrastructure that provides  Integrate IT - based solutions into the user environment effectively
computing solutions to address the needs of an organization. The program prepares PO4-Modern Tool Usage
graduates to address various user needs involving the selection, development,
 Apply knowledge through the use of current techniques, skills, tools and practices
application, integration and management of computing technologies within an
necessary for the IT profession.
organization.
PO5- Individual and Team Work
 Function effectively as a member or leader of a development team recognizing the
The BSIT students must possess the following skills upon graduation:
different roles within a team to accomplish a common goal
1. Analyze complex, real-world problems to identify and design computing  Assist in the creation of the effective IT project plan
requirements and apply computational approaches to the problem-solving process; PO6- Communication
2. Design, implement and evaluate a computing-based solution to meet a given set of  Communicate effectively with the computing community and with society at large
computing requirements in the context of the IT discipline; about complex computing activities through logical writing, presentations, and clear
3. Communicate technical information effectively with diverse audience that is instructions.
consistent with the intended audience and purpose; 4. Make informed judgement PO7- Computing Professionalism and Social Responsibility
and include unique perspectives of others in computing practice based on legal and  Analyze the local and global impact of computing information technology on
ethical principles; individuals, organizations and society
5. Function effectively on teams and employ self and peer advocacy to address bias in  Understand professional, ethical, legal, security and social issues and responsibilities
interactions, establish goals, plan tasks, meet deadlines, manage risks and produce in the utilization of information technology
deliverables; and PO8- Life-Long Learning
6. Identify and analyze user needs and consider them during the selection, integration  Recognize the need for and engage in planning self - learning and improving
and administration of computer-based systems. performance as a foundation for continuing professional development.

Course Description:
This course covers discussion of database systems, the nature of the data, associations of data, data semantics and data models. A specific DBMS will be used to implement data
models use in business application programs.

Prerequisite: IT 121

ISUR-ICT-Syl-014
Effectivity: August 1, 2018
Revision: 1
 Learning Outcomes:

At the end of course, students should be able to:

1. Cognitive
1.1 explain various implementations of database management systems;
1.2 create a database plan;

2. Affective
2.1 Appreciate the use of SQL in creating database

3. Psychomotor
3.1 create and design database using data models;
3.2 use database tool to manipulate or process data efficiently;
3.3 perform basic database administrators function; and
3.4 create an information system(prototype).

Course Plan

Graduate Number of Hours

Program Learning Assessment Assessment
Attributes Intended Learning Outcomes Learning Content Teaching Activities
Outcomes Activities Tasks Tools Lec Lab
1.5
LL, CPP,  1, 2,6,  To state the mission vision I. Vision, Mission, Quality Policy, Core o Discussion Class Recitation Rubrics for
CEL Values, Goals and Objectives o Information Participation Recitation
goals and objectives of the
University Campaign
 Discuss the mission, vision,
goals and objectives
Class Recitation Rubrics for 4
SC, IFK,  1, 3, 5, 6  Differentiate Data and o Lecture Participation recitation/quiz
II. Understanding Information
CPP, LL Information o Discussion Recitation Homework
 Define Management Management o Presentation
 Explain Information Quiz
 Data

ISUR-ICT-Syl-014
Effectivity: August 1, 2018
Revision: 1
 Management  Information
 Discuss history of  Management
Information Management
 Information Management
 Importance of Information
Management
 Stages in Information
Management
 Information Management and
the Role in it’s Workplace
6 6
CEL, CPP,  1, 3, 4, 6 III. Introduction to Structured Query o Lecture Class Recitation Rubrics for
IFK,LL  create a database and o Discussion Participation Laboratory
database tables; and Language o Oral interaction Recitation Homework activity
Hands-on
 organize database tables o Laboratory
 SQL Activities Quiz
by adding, updating and Activities
deleting table columns and  What SQL can Do Laboratory
rows activities
 SQLyog and quiz

 Creating a database and

database tables

 Adding, listing and updating

table rows

4 6
CEL, CPP,  1, 3, 4, 6, [Link] Data Definition o Lecture Class Recitation Rubrics for
IFK,LL  manipulate database tables Commands o Discussion Participation Homework Laboratory
by adding and dropping o Oral interaction Recitation Quiz activity
columns from the database  Changing Columns data type Hands-on Laboratory
o Laboratory
table; and and data characteristics Activities activities
Activities and quiz
  Adding and dropping a column

 Truncate records

 Dropping table

ISUR-ICT-Syl-014
Effectivity: August 1, 2018
Revision: 1
  Renaming tables

Preliminary – Exam 1.5 Hours

 perform the different V. PK, FK and SQL Operators 4 6
CEL, CPP,  1, 3, 4, 6 operators  add Primary key and foreign o Lecture Class Recitation Rubrics for
IFK,LL  create primary key and key o Discussion Participation Homework Laboratory
foreign keyy  Arithmetic Operators o Oral interaction Recitation Quiz activity
 Comparison Operators Hands-on Laboratory
o Laboratory
 Logical Operators Activities activities
 Null and Not Null operator Activities and quiz

 Apply the different VI. ADVANCED SELECT 4 6

CEL, CPP,  1, 3, 4, 6 wildcards QUERIES o Lecture Class Recitation Rubrics for
IFK,LL   ORDER BY o Discussion Participation Homework Laboratory
 Select Distinct o Oral interaction Recitation Quiz activity
 LIMIT Clause Hands-on Laboratory
o Laboratory
 Where Clause Activities activities
 SQL Wildcard Characters Activities and quiz
 Delete Statement
 Aliases

2.5 6
CEL, CPP,  1, 3, 4, 6 VII. SQL FUNCTIONS o Lecture Class Recitation Rubrics for
IFK,LL  MIN and MAX Functions o Discussion Participation Homework Laboratory
 use the Date and Time  COUNT, AVG and SUM Recitation Quiz activity
o Oral interaction
Functions; and Functions Hands-on Laboratory
o Library work
 Date and Time Functions Activities activities
 describe Numeric, string  Numeric, String and o Laboratory and quiz
and conversion functions in Conversion Function Activities
the database design.

Mid – Term Examination – 1.5 Hours

CEL, CPP,  1, 3, o Lecture Class Recitation Rubrics for

IFK,LL 4, [Link] JOINS Operators Participation Homework Laboratory
o Discussion
6  create an ER diagram; and Recitation Quiz activity
 CROSS JOIN o Oral interaction
Hands-on Laboratory
 perform different SQL joins o Laboratory
 LEFT JOIN and LEFT Activities activities
in manipulating and quiz
OUTER JOIN Activities
database data.
 OUTER JOIN
 RIGHT JOIN
 FULL JOIN

ISUR-ICT-Syl-014
Effectivity: August 1, 2018
Revision: 1
CEL, CPP,  1, 3, 4, 6 o Lecture Class Recitation Rubrics for
IFK,LL  categorize relational set IX. Advanced SQL Participation Homework Laboratory
o Discussion
operators to manipulate  Relational Set Operators o Oral interaction Recitation Quiz activity
data within the database; Hands-on Laboratory
o Laboratory
◦ UNION, UNION ALL Activities activities
 compare subqueries and Activities and quiz
correlated queries; and  Subqueries and Correlated
Queries
 use multirow subquery.
◦ WHERE, IN, HAVING
Subqueries
 Mutirow Subquery

CEL, CPP,  1, 3, 4, 6 X. Query Processing o Lecture Class Recitation Rubrics for

IFK,LL  make use of query  SQL Parsing Phase o Discussion Participation Homework Laboratory
processing like parsing, o Oral interaction Recitation Quiz activity
 SQL Execution Phase Hands-on Laboratory
execution and fetching; and o Laboratory
 SQL Fetching Phase Activities activities
 create indexes and query Activities and quiz
optimization.  Indexes and Query
Optimization

Final – Term Examination – 1.5 Hours

Course Requirements

The students are required to develop a simple system.

Grading Scheme Grade Equivalent
1.0 98 – 100
LECTURE (60%) LABORATORY (40%) 1.25 95 – 97
1.5 92 – 94
Quizzes 15% Quizzes 20% 1.75 89 – 91
Activities 15% Activities 25% 2.0 86 – 88
Recitation/Participation 5% Recitation/Participation 5% 2.25 83 – 85
Long Exam/Prelim 15% Midterm Exam Hand-on 25% 2.5 80 – 82
Midterm Exam 25% Final Exam Hand-on 25% 2.75 77 – 79
Final Exam 25% 100% 3.0 75 – 76
100% 5.0 74 and below Failed
INC Incomplete
Raw Grade = (Lecture * .60) + (Laboratory *.40)

ISUR-ICT-Syl-014
Effectivity: August 1, 2018
Revision: 1
 Final Grade = (Raw Grade * 0.625) + (37.5)

References:

 P.J. Pratt, et. Al., (2008). Concepts of Database Management. Course Technology, USA
 P. Rob, &C. Coronel (2007).Database Systems Design, Implementation and Management. Course Technology Thomson Learning, Singapore
 R. Emasri, & S. Navathe. (2007). Fundamentals of Database Systems. Pearson Education South Asia Pte. Ltd.
 Sevilla, Consulello G. , et. al. Research Methods. 2005
 Thomas Connolly & Carolyn Begg. (2003). Database Systems A Practical Approach to Design, Implementation and Management. Pearson Education (Asia) Pte. Ltd.
 SQL Tutorial. (2012). Retrieve June 14, 2014 from Refsnes Data.
 Website: www.w3shools .com/sql/[Link]
 Creating a MySQL Database Using XAMPP. (2012). Retrieve June 15, 2014 from Complete, Concrete, Concise.
 Website: [Link]
 PHP Tutorial Using XAMPP. Retrieve June 15, 2014 from [Link]
Classroom Policies:
1. Uniform and dress code
a. Students should be in proper uniform, wear school ID and appropriate shoes except during laboratory class.
b. On Wednesday, hip-hop dresses and get-ups are not allowed, e.g. shorts, slippers, earrings for males, spaghetti strap, etc.
c. PE uniform should be worn only during PE class.
2. Attendance, tardiness and absenteeism
a. A Minimum of 80% attendance of the total contact hours in the subject is required (checking is done every meeting).
b. Tardiness of 15 minutes is equivalent to one-hour period of absence.
c. A minimum of 3 consecutive absences without justifiable reasons requires a promissory note from the college guidance coordinator.
d. 6 consecutive absences in the class mean a “drop” in the subject.
e. Failure to take the prelim exam preceded by absences means a “drop” in the subject.
f. Failure to attend regular classes after taking prelim exam means a grade of 5.0 in the subject.
3. Taking Examinations
a. Cheating and copying are strictly prohibited, “when caught cheating during the quizzes and long exams, deduction of points will be imposed”, during the mid-term or final
exams, means a grade of 5.0 in the subject.
b. Borrowing of exam paraphernalia is NOT allowed during exams.
c. During mid-term and final exams, only answer sheets, permits, pens, pencils and erasers are allowed on the desk; other things should be deposited on a place designated
by the teacher.
d. Other policies will be imposed as deemed necessary and agreed upon between the students and the subject professor.
4. Other Policies:
a. Cell phones should shut-off during class hours.
b. Chairs should be arranged before leaving the classroom.
c. Vandalism is strictly prohibited and punishable.
d. No smoking within the school premises.
e. Students under the influence of liquor are not allowed inside the school compound.
f. Any form of deadly weapons should not be brought to school except cleaning/cutting tools during clean-up days and laboratory classes.
g. Unnecessary noise to the point of creating disturbances is prohibited.

ISUR-ICT-Syl-014
Effectivity: August 1, 2018
Revision: 1
 h. Proper grooming should be observed (i.e. short and undyed hair for males)
i. Other policies will be strictly imposed as contained in the student handbook.

Submitted by: Approved by: Noted by:

JAY E. LAUREL, MIT MA. VALEN D. ALZATE, DIT MARILYN S. LUZANO, PhD
Instructor 1 IICT Program Chair ARA Director

ISUR-ICT-Syl-014
Effectivity: August 1, 2018
Revision: 1