Second Syllabus CC 105 Information Management
Second Syllabus CC 105 Information Management
Second Syllabus CC 105 Information Management
DESIRED LEARNING OUTCOMES TIME COURSE CONTENT/TOPICS TEACHING & ASSESSMENT LEARNING VALUES GRADING
(DLO) FRAME LEARNING TASK/S RESOURCES INFUSED CRITERIA
ACTIVITIES (TLAs) (Core Values)
* Discuss of the school policies, Week 1 I. Orientation *Reading of School Recitation Student Driven by Rubrics for
grading system, topic outline, and 1 hour a. School Policies and Guidelines and laboratory Reflection Handbook Faith recitation
orientation, etc.) b. Classroom Protocols and laboratory Policies and Computer Agility
rules Guidelines. LCD Respect
c. Course Outline Projector Excellence
d. Grading System Service
e. Course Expectations
DESIRED LEARNING OUTCOMES TIME COURSE CONTENT/TOPICS TEACHING & ASSESSMENT LEARNING VALUES GRADING
(DLO) FRAME LEARNING TASK/S RESOURCES INFUSED CRITERIA
ACTIVITIES (TLAs) (Core Values)
Week 3 IV. Relational Databases
*Classify the modern and futuristic 2 hours a. Purpose of Database System Discussion Report Textbook Honesty Rubrics for
database applications based on b. Data Models Lecture Quiz Hand-outs Cooperation reporting
size and complexity c. Database System Architecture Brainstorming Assignment Website Respect
Week 4 d. Introduction to relational databases Library work Independence Checklist for
*Appraise how advanced databases 3 hours e. Relational Model Objectivity assignment
differ from traditional databases. Use a Moodle / Critical Thinking
Google Classroom
for lectures, quizzes
and assignments
V. Structured Query Language
*understand and use the basic of Week 4 (SQL) Discussion Report Textbook Honesty Rubrics for
DML and DDL and advance 2 hours a. History of Structures Query Lecture Quiz Hand-outs Cooperation reporting
features SQL Language Language Brainstorming Assignment Website Respect
Week 5 b. Data Manipulation Language (DML) Library work Independence Checklist for
5 hours c. Data Definition Language (DDL) Objectivity assignment
d. Introduction of basic SQL Use a Moodle / Critical Thinking
Language Google Classroom
for lectures, quizzes
and assignments
Week 6 TRINAL EXAMINATION, QUIZZES,
REQUIREMENTS
Week 7 VI. Database Design
*Map ER model to Relational model 5 hours a. Entity-Relationship model Discussion Report Textbook Honesty Rubrics for
to perform database design b. E-R Diagrams Lecture Quiz Hand-outs Cooperation reporting
effectively Week 8 c. ER-to-Relational Mapping Brainstorming Assignment Website Respect
5 hours d. First, Second, Third Normal Forms Library work Independence Checklist for
*Write queries using normalization e. Boyce/Codd Normal Form Objectivity assignment
criteria and optimize queries Use a Moodle / Critical Thinking
Google Classroom
for lectures, quizzes
and assignments
DESIRED LEARNING OUTCOMES TIME COURSE CONTENT/TOPICS TEACHING & ASSESSMENT LEARNING VALUES GRADING
(DLO) FRAME LEARNING TASK/S RESOURCES INFUSED CRITERIA
ACTIVITIES (TLAs) (Core Values)
Week 9 VII. UML Diagrams
*Design and use both structural and 5 hours a. Structural UML diagrams (Class Discussion Report Textbook Honesty Rubrics for
behavioral UML Diagrams. diagram, Package diagram, Object Lecture Quiz Hand-outs Cooperation reporting
diagram, Component diagram, Brainstorming Assignment Website Respect
Week 10 Composite structure diagram, Library work Independence Checklist for
5 hours Deployment diagram) Objectivity assignment
Use a Moodle / Critical Thinking
Week 11 b. Behavioral UML diagrams (Activity Google Classroom
3 hours diagram, Sequence diagram, Use for lectures, quizzes
case diagram, State diagram, and assignments
Communication diagram, Interaction
overview diagram, Timing diagram
Week 12 MIDTERM EXAMINATION,
QUIZZES, REQUIREMENTS
VIII. Security, Control and
* Apply and compare security, Week 13 Reporting Discussion Report Textbook Honesty Rubrics for
control and reporting. 5 hours a. Security and Testing Lecture Quiz Hand-outs Cooperation reporting
b. Error detection and Controls Brainstorming Assignment Website Respect
c. Disaster Management Library work Independence Checklist for
d. Computer Crimes Objectivity assignment
e. Securing the Web Use a Moodle / Critical Thinking
f. Intranets and Wireless Networks Google Classroom
g. Ethics in IT for lectures, quizzes
h. User Interface and reporting and assignments
Week 14 IX. Information Management
*Describe and explain the role of 5 hours a. Role of information management Discussion Report Textbook Honesty Rubrics for
information management. (ERP, e-business, e-governance, Lecture Quiz Hand-outs Cooperation reporting
Data Mining, Business Intelligence, Brainstorming Assignment Website Respect
Cloud computing) Library work Independence Checklist for
Objectivity assignment
Use a Moodle / Critical Thinking
Google Classroom
for lectures, quizzes
and assignments
DESIRED LEARNING OUTCOMES TIME COURSE CONTENT/TOPICS TEACHING & ASSESSMENT LEARNING VALUES GRADING
(DLO) FRAME LEARNING TASK/S RESOURCES INFUSED CRITERIA
ACTIVITIES (TLAs) (Core Values)
Week 15 X. Final Project: Development of
* Analyze an existing database 5 hours database systems Discussion Report Textbook Honesty Rubrics for
system with respect to quality Lecture Quiz Hand-outs Cooperation reporting
issues, readability, scalability, Brainstorming Assignment Website Respect
efficiency, effectiveness and Week 16 Library work Independence Checklist for
security 5 hours Objectivity assignment
Use a Moodle / Critical Thinking
* design a database based on user Google Classroom
requirements using a widely used Week 17 for lectures, quizzes
modeling notation, and be able to 5 hours and assignments
use declarative query language to
elicit information.