Course Syllabus

Format V 4.0
Institute of Business Management and Governance SPAMAST
Bachelor of Science in Accounting and Information Systems

COURSE SYLLABUS
Second Semester, School Year 2024-2025

Course No. : AEIC 327

Course Title : Managing Information and Technology Prepared by: JOSELITO J. MEBOLOS
Faculty

Course Description : Emphasis on database management systems, and the software

development process. Students survey types of information Reviewed by: JESSE ROY M. ALCARAZ, CPA
systems used by modern organizations: transaction processing, Program Head, IT
decision support, executive information, functional area support, (need initial from the subject
strategic, and expert systems. specialist before signing by the Dept.
Chair)

Recommending
Approval: GLENN M. DEMILLO, MBA
Dean
Course & Year: : BSAIS 3B

Course Credit : 3 units

Prerequisite/s :
Approved: MARLYN B. LLAMEG, Ph.D.
Contact Hours/ Week VPAA
Lecture: : 2 hours per week
Laboratory: : 3 hours per week

Page 1 of 13
 VISION MISSION GUIDANCE PRINCIPLES
“By 2028, SPAMAST will be a premier “SPAMAST is committed to provide quality and
Higher Education Institution transforming transformative education with innovative and culture
communities toward the attainment of sensitive programs, protect the environment, and contribute
to national economic prosperity.”
Sustainable Development”

GRADUATE ATTRIBUTES

Common to All Programs

Language and Communication Skills Entrepreneurial Skills Socio-Cultural, Environmental Responsiveness and
Professional Competency Capabilities for Life Long Learning Gender Sensitivity
Creativity and Innovativeness Leadership, Teamwork and Interpersonal Skills
Critical Thinking Skills Universal Outlook and Global Competence

SPAMAST GRADUATE ATTRIBUTES

(A SPAMAST Graduate shall possess. . .)

Leadership, Teamwork
Entrepreneurial Skills

Universal outlook and

Communication skills

Capabilities for Life

responsiveness and
global competency

gender sensitivity
PROGRAM OUTCOMES

and Interpersonal
Critical Thinking
Innovativeness

Long Learning

Socio-cultural,
environmental
Creativity and
Language and

Competency
Professional

Skills

Skills
PROGRAM OUTCOMES

(Common to all Programs in all types of schools)

1. Articulate and discuss the latest development in the specific field of practice. 

Page 2 of 13
2. Effectively communicate orally and in writing using both English and Filipino. 
3. Work effectively and independently in multidisciplinary and multicultural teams. 
4. Act in recognition of professional, social, and ethical responsibility.  
5. Preserve and promote “Filipino historical and cultural heritage” based on RA

7722.
(Common to the Business and Management Discipline)    
6. Describe the basic functions of management such as planning, organizing, leading

and controlling.
7. Identify and describe the basic concepts that underlie each of the functional areas
of business (marketing, finance, human resources management, production and 
    
operations management, information technology, and strategic management) and
employ these concepts in various business situations.
8. Select the proper decision making tools to critically, analytically and creatively
 
solve problems and drive results.
9. Express clearly and communicates effectively with stakeholders both oral and
    
written forms.
10. Apply information and communication technology (ICT) skills as required by the
 
business environment.
11. Work effectively with other stakeholders and manage conflict in the workplace.   
12. Organize and lead groups to plan and implement business related activities.   
13. Demonstrate corporate citizenship and social responsibility.    
14. Exercise high personal moral ethical standards.   
(Program Outcomes for BSAIS)
15. Resolve business issues and problems, with a global and strategic perspective
using their knowledge and technical proficiency in the areas of financial
  
accounting and reporting, cost accounting and management, management
accounting and control, taxation and accounting information systems.
16. Conduct Accounting Information System research through independent studies of
  
relevant literature and appropriate use of accounting theory and methodologies.
17. Employ technology as a business tool in capturing financial and non-financial
 
information, generating reports and making decisions.
18. Apply knowledge and skills that will enable then to successfully respond to  
Page 3 of 13
 various types of assessments (including professional licensure and certifications).
19. Confidently maintain a commitment to good corporate citizenship, social  
responsibility and ethical practice in performing functions as an accountant.
(Common to a horizontal type as defined in CMO No. 46, s. 2012)
20. Graduates of professional institutions demonstrate a service orientation in one’s      
profession.
21. Graduates of colleges participate in various types of employment, development
activities, and public discourses, particularly in response to the needs of the    
communities one serves.
22. Graduates of universities participate in the generation of new knowledge or in  
research and development projects.

P P P P P
COURSE OUTCOMES P P P P P P P P P P P P P P P P P
O O O O O
O O O O O O O O O O1 O O O O O O O
At the end of the semester, the students should be 1 2 3 4 5 6 7 8 9
1 1 1 1
4 15 16 17 18 19
2
21 22
0 1 2 3 0
able to:
1. Evaluate the role of database management systems
in information technology applications within P P P P P P P P P P P P P P P P
organizations;
2. Identify and use contemporary logical design
P P P P P P P P P
methods and tools for databases;
3. Derive a physical design for a database from its
P P P P P P P P
logical design;
4. Implement a database solution to an information
P P P P P P P P P P P P P
technology problem;
5. Define the SQL data definition and SQL query
P P P P P P P P P
languages;
6. Identify alternative design techniques and utilize
P P P P P P P P P
Management Reporting applications.

Page 4 of 13
LEGEND:
I-INTRODUCED (The student get introduced to the concepts/principles)
P-PRACTICED (The student practices the competencies with supervision)
D-DEMONSTRATED (The student practices the competencies across different settings with minimal supervision)

COURSE PLAN
STUDENT LEARNING MAP COURSE CONTENT/ TEACHING ASSESSMENT RESOURCES NEEDED
TIME OUTCOMES SUBJECT MATTER AND TASKS (ATs)
FRAM (refer to LEARNING
E At the end of the lesson, Course ACTIVITIES
the students will be able to: Outcomes (TLAs)
)
Week 1 At the end of the lesson, -  SPAMAST’s Vision, Mission  Power point  VMGO  Laptop/Cellular phone
the students will be able to: and Core Values (FAITH to presentation  Internet connection
 Converse the importance SPAMAST) (Lecture)  DLP
of the course in relation  Program Educational  Online  Module
to the attainment of the Objectives Discussion
Institutions VMGO.  Classroom Policies
 Identify the course and  Grading System
course requirements  Assessment and Evaluation
Guidelines
Week 2 Identify technologies  Classroom  Quizzes  Laptop/Cellular phone
available today and discussion/  Oral  Internet connection
 DLP
emerging technology Online Recitation  Module
trends. discussion  Laboratory
software applications to  Laboratory activities
CO1  Managing IT in a Digital
support business World demonstration  Exams
operations and business  Self-paced
intelligence study
 Peer teaching
 Group
discussion
Week 3 Given a user requirement, CO1  Introduction to Database  Classroom  Quizzes  Laptop/Cellular phone
To students will be able to discussion/  Oral  Internet connection

Page 5 of 13
 STUDENT LEARNING MAP COURSE CONTENT/ TEACHING ASSESSMENT RESOURCES NEEDED
TIME OUTCOMES SUBJECT MATTER AND TASKS (ATs)
FRAM (refer to LEARNING
E At the end of the lesson, Course ACTIVITIES
the students will be able to: Outcomes (TLAs)
)
Week 4 identify the type of Recitation  DLP
database needed to  Laboratory  Module
Online
address the user discussion activities
requirement.  Laboratory  Exams
In an instance in which a demonstration
possible customer does
not understand what a  Self-paced
database and relies on study
keeping data physically,  Peer teaching
students will be able to  Group
discuss the importance of
using a database in record discussion
keeping/storing data.
Week 5  Design databases using  Classroom  Quizzes  Laptop/Cellular phone
To the six phases in the discussion/  Oral  Internet connection
Week 6  DLP
Database Life Cycle Online Recitation  Module
(DBLC) framework discussion  Laboratory
 Distinguish between CO1  Laboratory activities
centralized and CO2  Database Design demonstration  Exams
decentralized conceptual CO3  Self-paced
database design study
 Peer teaching
 Group
discussion
Week 7  Identify the basic CO3  Introduction to Structured  Classroom  Quizzes  Laptop/Cellular phone
To commands and functions CO4 Query Language discussion/  Oral  Internet connection
Week 8 CO5  DLP
of SQL CO6 Online Recitation  Module
Page 6 of 13
 STUDENT LEARNING MAP COURSE CONTENT/ TEACHING ASSESSMENT RESOURCES NEEDED
TIME OUTCOMES SUBJECT MATTER AND TASKS (ATs)
FRAM (refer to LEARNING
E At the end of the lesson, Course ACTIVITIES
the students will be able to: Outcomes (TLAs)
)
Explain how to use SQL discussion  Laboratory
for data administration,  Laboratory activities
data manipulation, and to demonstration  Exams
query a database for  Self-paced
useful information study
 Peer teaching
 Group
discussion
Week 9  In a scenario where  Quizzes  Laptop/Cellular phone
to 11 possible customers have  Oral  Internet connection
 DLP
problems regarding data Recitation  Module
 Classroom
redundancy, students will  Laboratory
discussion/
be able to discuss the activities
Online
importance of using a  Exams
discussion
relational database to CO3  Laboratory
eradicate the problem. CO4  The Relational Database
CO5 Model demonstration
 In an instance in which
CO6  Self-paced
data redundancy occurs in
study
a database designed
 Peer teaching
according to specific user
 Group
requirements, students
discussion
will be able to accurately
troubleshoot the database
and fix the problem.
Week 12  In a discussion with a CO3  Entity Relationship Modeling  Classroom  Quizzes  Laptop/Cellular phone
to 14 CO4  Internet connection
Page 7 of 13
 STUDENT LEARNING MAP COURSE CONTENT/ TEACHING ASSESSMENT RESOURCES NEEDED
TIME OUTCOMES SUBJECT MATTER AND TASKS (ATs)
FRAM (refer to LEARNING
E At the end of the lesson, Course ACTIVITIES
the students will be able to: Outcomes (TLAs)
)
possible customer,  Oral  DLP
students will be able to Recitation  Module
discuss to how ERD discussion/  Laboratory
components affect the Online activities
database design and discussion  Exams
implementation.  Laboratory
During database CO5 demonstration
development, students CO6  Self-paced
will be able to accurately study
identify entities that will  Peer teaching
be included in the in the  Group
database design according discussion
to specific user
requirements.
Week 15  Discuss normalization  Classroom  Quizzes  Laptop/Cellular phone
to 18 and its role in the discussion/  Oral  Internet connection
 DLP
database design process Online Recitation  Module
 Identify and describe discussion  Laboratory
each of the normal forms: CO3  Laboratory activities
CO4  Normalization of Database
1NF, 2NF, 3NF, BCNF, CO5 Tables demonstration  Exams
and 4NF CO6  Self-paced
Apply normalization rules study
to evaluate and correct  Peer teaching
table structures  Group
discussion

Page 8 of 13
Assessment Task Details (Content-based)
Assessment Schedule Coverage Assessment Task Details
Midterm Examination Part 2 to 5 Written Examination
 True or False 20%
 Matching Type 20% The students will be assessed through written examination.
 Essay/Illustration/Problem Solving
30%
Final Examination Part 2 to 5 and 6 Written Examination
to 8  True or False 20%
 Matching Type 20% The students will be assessed through written examination.
 Essay/Illustration/Problem Solving
30%
Assessment Task Details (Performance-based)
Assessment Schedule Coverage Assessment Task Details
Mid-term Examination Part 2 to 5 Laboratory activities The students will be assessed through laboratory activities.
Final Examination Part 6 to 8 Laboratory activities The students will be assessed through laboratory activities.

COURSE GRADING SYSTEM

CLASS POLICY
REQUIREMENTS

Quizzes Quizzes 20% Individual Responsibility:

Laboratory Activities Exam 20%
Requirements 60%
Midterm Examination Every student is expected to:
100%
Final Examination
Note:  JOIN the course page/eClassroom and GC created by the faculty for the course
with OFFICIAL account (last name AND first name)
Final Grade = 50% MG + 50% FTG **any student who will REFUSE to JOIN or LEAVE the group without valid
reason (officially drop from the course) shall be considered UNOFFICIALLY
DROPPED from the course
**in case the student has accidentally left the group, she/he shall JOIN again to
the group
 DOWNLOAD all materials provided in this course
 STUDY and LEARN the subject matter under this course
Page 9 of 13
  Be RESOURCEFUL enough in finding other resources to better understand the
topic
 SUBMIT outputs required by the course both Learning Task/s and Assessment
Task/s ON TIME
 Should there be any concern, DO NOT HESITATE TO ASK thru thread or DM
Group Responsibility:

 Every group is composed of 3 to 4 members

 Every member shall participate or cooperate in every task
 Every group is expected to submit all deliverables ON TIME

Queries:

Queries can be done through email or messenger. If through messenger, expect that:

 all queries through messages/email will be responded though response may not
be immediate (especially during weekends and days with school activities)
 messages that is not tagged may be overlooked, it is suggested that you mention
the person the message is intended for
 personal concerns about the course may not be entertained in GC, instead, it is
encouraged to send it through DM
 all redundant queries may not be answered, you are encouraged to BACK-READ
the messages for certain concerns in that period to avoid waste of time and
energy

Deliverable Submissions:

Deliverable refers to the LEARNING TASK/S and ASSESSMENT TASK/S

Page 10 of 13
 Schedule: Deliverables MUST be submitted 10 days before the deadline of
submission of grades.

FAIL to SUBMIT DELEVERABLES: MAKE SURE that you are able to submit all
deliverables WITHIN THE SEMESTER to avoid IP or Failing marks.

Form: All deliverables / outputs must be submitted in softcopy with format (ITC
213<LastNameFirstName> basis, first name initials only):

Individual submission: ITC 213 <LastNameFirstName><TaskNo>

Ex. ITC 213 MebolosJJ AT1 MebolosJJ Activity1

Group submission: in alphabetical order

ITC 213 <LNFN1>< LNFN2><LNFN3>< LNFN4><TaskNo>

Ex. ITC 213 MebolosJJ DalamBP PanaliganNR AlbarracinAR
Activity1

Where to submit:

Every output is confidential, thus you are required to submit it to

mebolosjj@gmail.com and NOT in GC or Course Group, except to those outputs that
we agree to share.

Meetings Online:

Every student is expected to be responsible and act professionally during the

online meetings.

 Join the virtual meeting room 5 mins before the meeting starts
Page 11 of 13
  Wear appropriate clothes
 Always turn on your camera
 Learn how to mute your microphone
 Speak clearly and use good manners when ask to speak
 Do not talk unnecessary things during the discussion of important matters
 Pay attention to the meeting and not to the distractions around
 Be prepared for technical difficulties

PROFESSIONAL ETHICS:

3rd year level is the stage wherein you start to PREPARE yourselves for
employment or you are preparing to manage your own company, thus, as part of your
training, EVERY JUNIOR STUDENT is expected to:

 Practice professionalism at all times – in times of difficulties, DO THE TASK

FIRST, rather than complain before you attempt to comply the tasks; do not
PROCASTINATE
 Keep yourself motivated – in case you feel weary and exhausted, DO NOT
GIVE UP and BE ENTHUSIASTIC and make your parents and dreams be your
inspiration
 Keep discussions discrete – do not announce to the public whatever matters we
discussed in the class if not necessary
 Always keep your credibility intact – do not adopt SCHADENFREUDE attitude
Note: For other class policies, please refer to the student handbook.

SUGGESTED READINGS AND REFERENCES Counterchecked by:

TEXTBOOKS: IVY A. ORTIGA, RL, MLIS
Librarian
Penn, M. (2019). Database Systems Design, Implementation, and Management. Willford Press.
Page 12 of 13
Taylor, A. G. (2019). SQL for Dummies. John Wiley and Sons.

Abante, M., De La Cruz, A. R., Anthony, J. E. S., Delos Trinos, M. J. A., Delizo, R. A. (2019). MySQL.
Unlimited Books.

Anonymous (2018). Database Systems. 3-G E-Learning LLC.

Pratt, P. J., Last, M. Z. (2016). Database Management Systems. Cengage Learning.

ONLINE SOURCES:

Coronel, C., Morris, S.(2017). Database Systems: Design, Implementation, and Management. Retrieved from
http://www.cherrycreekeducation.com/bbk/b/Cengage_Learning_Database_Systems_12th_Edition_13056
27482.pdf January 16, 2025.
Brown, C. V., Dehayes, D. W., Hoffer, J. A., Wainright Martin, E., Perkins, William, C. (2012). Retrieved from
https://www.homeworkforyou.com/static_media/uploadedfiles/Managing%20Information
%20Technology%207th%20Edition.pdf January 16, 2025.

Form No : FM-SPAMAST-PRS-01
Issue Status : 03
Revision No. : 03
Date Effective : 10 June 2024
Approved by : President

Page 13 of 13