CENTRAL PHILIPPINE UNIVERSITY COURSE SYLLABUS

COLLEGE OF BUSINESS AND ACCOUNTANCY Acctg 2312 – IT Application Tools in Business

Jaro, Iloilo City, Philippines (Accounting)

Vision
A university committed to Exemplary Christian Education for Life (EXCEL) and responsive to the needs of the total person and the
world.

Mission
The mission of Central Philippine University is to carry out a program of spiritual, intellectual, moral, scientific,
technological and cultural training and allied studies under influences which strengthen Christian faith, build up character and promote
scholarship, research and community service.

Institutional Outcomes (IOs)

In three to five years after graduation, graduates of Central Philippine University shall:
1. Practice professionalism with integrity and demonstrate Christ-like character.
2. Demonstrate patriotism and be law-abiding citizens
3. Use responsibly God-given talents, skills, and resources to promote well-being and productivity of communities and society.
4. Demonstrate technological competence in the practice of profession
5. Demonstrate continuous effort to grow professionally

Program Educational Objectives (PEO) and its Relationship to CPU’s Institutional Outcomes
PROGRAM EDUCATIONAL OBJECTIVES(PEO) IOs
Within five years after graduation, alumni of the Accountancy Department should
be able to: 1 2 3 4 5
a. Demonstrate competence, professionalism and integrity in the practice
 
of the accountancy profession and in business-related activities   
b. Generate and communicate economic information in an efficient and
effective manner using English, Filipino or any appropriate language for 
multicultural or multi-sectoral stakeholders 
c. Demonstrate managerial or entrepreneurial skills in the practice of

profession or allied activities
d. Pursue continuing professional development or scholarly activities. 
e. Participates in a professional, civic or local organization which

strengthens the profession, promotes social responsibility or nationalism. 

PROGRAM OUTCOMES for BS Accountancy. Graduates of BS Accountancy should be able to:

a) 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 accounting and control, taxation or
accounting information systems.
b) Conduct accountancy research through independent studies of relevant literature and appropriate use of accounting theory and
methodologies.
c) Employ technology as a business tool in capturing financial and non-financial information, generating reports and making
decisions.
d) Apply knowledge and skills that will successfully respond to various types of assessments (including professional licensure and
certifications).
e) Confidently maintain a commitment to good corporate citizenship, social responsibility and ethical practice in performing
functions as an accountant.

Program Outcomes (PO) related to the course and its Relationships to Program Educational Objectives (PEO)
PEO
PROGRAM OUTCOMES (PO)
a b c d e
a. 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 accounting and control, taxation or accounting information
systems.
b. Conduct accountancy research through independent studies of relevant literature and √
Students are strongly encouraged to take advantage of instructor’s consultation hours for help with coursework or anything else
connected with the course and their progress.

Approved by:
Revision No.
Prepared by:
0
Date of Effectivity:
Revision Date: Page 1 of 5
Summer 2020
June 2020 PROF. R. S. BALDEVARONA DR. L. GRANDE
LORNA T. GRANDE / JEANIL SAJO
Chairperson, Dept. of Accty. Dean, CBA
 appropriate use of accounting theory and methodologies. √
c. Employ technology as a business tool in capturing financial and non-financial information,
√ √
generating reports and making decisions.
d. Apply knowledge and skills that will successfully respond to various types of assessments
√
(including professional licensure and certifications).
e. Confidently maintain a commitment to good corporate citizenship, social responsibility and
√
ethical practice in performing functions as an accountant. √

Course Information
Course Code : Acctg 2312
Course Title : IT Application Tools in Business (Accounting)
Course Description : The course provides an introduction to information technology and applications. The
course addresses the computer proficiency requirement for future accounting
professionals. Topics to be covered include word processing, spreadsheet analysis and
data management, business graphics, and presentation techniques. The course provides
hands-on training using the Microsoft Office (MS Word, Excel, PowerPoint) to expose
students to different business applications of computers and software and how they are
applied to business environment. It also seeks to expose students in understanding the
business processes of a business enterprise from the start of the business transaction
down to the end process where they are exposed to a multi-tiered level of user,
application processing and data management. Exposure on how data is collected, stored
and used by each students to understand the appetite of the business enterprise on the
level of information system it would like to adapt.
Pre-requisite : None
Credit : 3 units Lecture/Laboratory: 3 units
Class Schedule : Lecture/Laboratory: 10 hours per week Time: 1:30-3:30 Day: M-F Room: MTCL

Instructor
Name: Lorna T. Grande/ Jeanil Sajo
Office: Dept. of Accountancy Rm: NV110 Tel . No.: (033) 329-1971 Local 1057
Consultation Time: 4-5:30 PM Day: M-FRm: CBA Dean’s Office
Email Address: [email protected]

Other Teacher(s) teaching the course

Name: Consultation Time/Day: Rm:
Name: Consultation Time/Day: Rm:

Course Coordinator: Consultation Time/Day: 4-5:30 PM MWF Rm: NV 108

Course Outcomes (CO) and Relationship to Program Outcomes (PO)

Course Outcomes Program Outcomes
After completing the course, the student must be able to:
A b c d e
CO1. Identify the different business applications of computers and software. √ √ √
CO2. Proficiently apply different business applications of computers and software
in recording business transactions and presentation of financial statements √ √ √ √ √
and other reports required by the management and government agencies.
CO3. Prepare reports, power point presentations, and financial statements using
Microsoft Office (MS Word, Excel, PowerPoint). √ √ √ √ √
CO4. Internalize the CPU core values such as Christian faith, commitment,
cooperation, confidence, honesty, respect, and responsible stewardship in √
his/her life.

Course Design
Desired Learning Teaching and
Time Course Content/ Textbook/ Assessment
Outcome/s Learning Assessment Tool
Frame Subject Matter References Task
Activities
Week 1 CO1 Microsoft word Microsoft Office 2016 Lecture and Online quiz and Rubric for written
CO2 1. Introduction and Step by Step – Joan online practice tests Examination
CO3 basic operation Lambert, Curtis Frye presentation
CO4 2. Microsoft Word Verbal
Components reasoning
3. Paragraph and
character Reports (to be

Students are strongly encouraged to take advantage of instructor’s consultation hours for help with coursework or anything else
connected with the course and their progress.

Approved by:
Revision No.
Prepared by:
0
Date of Effectivity:
Revision Date: Page 2 of 5
Summer 2020
June 2020 PROF. R. S. BALDEVARONA DR. L. GRANDE
LORNA T. GRANDE / JEANIL SAJO
Chairperson, Dept. of Accty. Dean, CBA
 Desired Learning Teaching and
Time Course Content/ Textbook/ Assessment
Outcome/s Learning Assessment Tool
Frame Subject Matter References Task
Activities
formatting using submitted)
tables, graphs,
schedules,
images and
graphics
4. Managing text
flow
5. Formatting a
business letter
Week 2 CO1 Power point Microsoft Office 2016 Lecture and Online quiz and Rubric for written
CO2 1. Introduction and Step by Step – Joan online practice tests Examination
CO3 basic operations Lambert, Curtis Frye presentation
of MS Verbal
CO4
Powerpoint www.tutorialspoint.co reasoning
2. Editing m
presentation Reports (to be
3. Formatting submitted)
presentation
4. Working with
multimedia
5. Sharing
presentation
Week 2 Midsummer EXAMINATION
Week 3 CO1 Excel Lecture and Online quiz and Rubric for written
CO2 1. Introduction and online exercises Examination
CO3 basic operation presentation
CO4 2. Recording of
business Reports (to be
transactions submitted)
3. Posting from
journals to
ledgers using the
formula and
links.
4. Preparation of
trial balance
using the
formula and
links.
5. Preparation of
Financial
Statements
based on the trial
balance
Week 4 CO1 6. Preparation of Rubric for written
CO2 financial Examination
CO3 statements with
CO4 supporting notes
to financial
statements
7. Sorting and
filtering of data
8. Graphs
Week 4 Consultation

Week 4 FINAL EXAMINATION

Textbook:

Lambert, Joan and Frye, Curtis. Microsoft Office 2016 Step by Step –

Mayes, Timothy R. and AhNK, Todd M. (2015 Seventh Edition). Financial Analysis with Microsoft Excel
2013. Cengage Learning, Boston, USA.

McFedries , Paul. (2013). Teach Yourself Visually Microsoft Excel 2013. John Wiley & Sons, Inc.,
Indianapolis.

Reding, Elizabeth Eisner and Wermer, Lynn. (2014 International Edition). Microsoft Excel 2013 Illustrated.
Cengage Learning.
Students are strongly encouraged to take advantage of instructor’s consultation hours for help with coursework or anything else
connected with the course and their progress.

Approved by:
Revision No.
Prepared by:
0
Date of Effectivity:
Revision Date: Page 3 of 5
Summer 2020
June 2020 PROF. R. S. BALDEVARONA DR. L. GRANDE
LORNA T. GRANDE / JEANIL SAJO
Chairperson, Dept. of Accty. Dean, CBA
 Walkenbach, John. (2013). 101 Microsoft Excel 2013 Tips, Tricks & Timesavers. John Wiley & Sons, Inc.,
Hoboken, New Jersey.

Journals (if needed)

Online Resources
www.tutorialspoint.com

Grading System

Summer Term

A. Mid-Summer Examination 25%

B. Final Examination 35%

C. Quizzes 25%

D. Other Requirements (Assignment/Seatwork/Board work/Recitation, 15%

etc)
TOTAL 100%

PASSING MARK 60%

General Weigthed Average−Passing Mark

Transmuted Value = x 25 + 75
100−Passing Mark

(Transmuted value of the final grade should be rounded off to the nearest whole number)

Standard Transmutation Table to Obtain the Final Grade

Transmuted Value Numerical Grade
98-100 1.00
95-97 1.25
92-94 1.50
89-91 1.75
86-88 2.00
83-85 2.25
80-82 2.50
77-79 2.75
75-76 3.00
Below 75 5.00

 Students with incomplete (INC) grade and no other subjects enrolled must enroll for Academic Residency during the succeeding
semester/s until he/she completes the requirement, but not to exceed one year, otherwise, the student must reenroll the course. The
official date of graduation of students with INC mark will be after compliance of the requirements in the residency period.
 Students who missed the scheduled Prelim, Midterm or Final Examination should take the special exam within ten (10) school
days after the last day of the scheduled major exam, otherwise the missed exam shall automatically be given a score of zero equivalent
to a grade of 5.0.

CLASS POLICIES:

The student’s responsibility is to come to each class prepared. He/She is expected to take all examinations on the
scheduled date. He/She should read/analyse/answer the assigned problem before coming
to class. He/She is expected to attend each class and participate actively in the discussion.

1. Wearing of uniform is required except on Wednesday.

2. A re-admission slip is required after three (3) absences made in a semester or after 2 absences made in summer.
3. Cell phones should be in silent mode during class time. Except on emergency cases, the use of cell phone during class
hours is prohibited.

ACADEMIC DISHONESTY

Students are strongly encouraged to take advantage of instructor’s consultation hours for help with coursework or anything else
connected with the course and their progress.

Approved by:
Revision No.
Prepared by:
0
Date of Effectivity:
Revision Date: Page 4 of 5
Summer 2020
June 2020 PROF. R. S. BALDEVARONA DR. L. GRANDE
LORNA T. GRANDE / JEANIL SAJO
Chairperson, Dept. of Accty. Dean, CBA
 All students in the College of Business and Accountancy are expected to be academically honest. Cheating, lying and other
forms of immoral and unethical behavior will not be tolerated. Any student
found guilty of cheating in examinations or plagiarism in submitted course requirements will (at minimum) receive zero score or failure
in the course requirement or in the course. Plagiarism and cheating
refer to the use of unauthorized books, notes or otherwise securing held in a test; copying tests, assignments, reports or term papers;
representing the work of another person as one’s own; collaborating
without authority, with another student during an examination or in preparing academic work; signing another student’s name on an
attendance sheet; or otherwise practicing scholastic dishonesty.

Statement of Commitment

As a student of the CPU College of Business and Accountancy, I recognize that I am a part of a community that espouses
Christian values, academic excellence and highest level of professionalism. I therefore commit myself to support these quality policy and
uphold to the best of my ability, the COE Standard of Academic Integrity. I will claim ownership only for work output which is truly my
own; I will give appropriate credit where credit is due; I will use resources provided with care; and I will choose to be fair and honest in
all of my dealings.

____________________________________
Signature over Printed Name of Student

_________________
Date

======================================================================

Students are strongly encouraged to take advantage of instructor’s consultation hours for help with coursework or anything else
connected with the course and their progress.

Approved by:
Revision No.
Prepared by:
0
Date of Effectivity:
Revision Date: Page 5 of 5
Summer 2020
June 2020 PROF. R. S. BALDEVARONA DR. L. GRANDE
LORNA T. GRANDE / JEANIL SAJO
Chairperson, Dept. of Accty. Dean, CBA