Software Application
Software Application
Prerequisite :
Page 1 of 16
CORE VALUES: INSTITUTIONAL OUTCOMES:
Dr. Ronald P. Guzman is a visionary founder and Christian Leader who pursuits for the The International School of Asia and the Pacific Institutional Outcomes are the qualities that
transformation of the nation. The following core values exhibited by the founder should be ISAPians must possess.
imbibed to all members of the ISAP: 1. Demonstrates through institutional mechanisms, quality standards and code of good
practice which are reflective of equal participatory decision making and
I- INTEGRITY accountability.
S- SPIRITUAL UPRIGHTNESS 2. Practices spiritual values and ethical behaviours which promote and inspire greater
A- ALTRUISM harmony to project a credible image in the society.
P- PATIENCE 3. Exhibits life-long learning and global competency proficient in entrepreneurial skills,
I- INNOVATIVENESS selfless innovative mind set and socio-civic services.
A- ADAPTIVENESS 4. Manifests self-discipline, self-direction and adaptability in dealing with life’s situations
N- NATIONALISM
and challenges.
PURPOSE: 5. Mobilizes community resources to foster and sustain institutional programs for
community development.
“Transforming Lives through Selfless Service”
GRADUATE ATTRIBUTES:
PHILOSOPHY: 1. Role Model – imbued with self-discipline rooted from constitutional provisions, social
God created man in His image with distinct talents and skills integral to human progression. norms and other regulations contributory to social development and progress.
These talents, once given adequate appreciation and encouragement, can foster holistic 2. Research Enthusiast – equipped with knowledge of the past and present social
development for his benefit and betterment of his fellowmen for the glory of God. milieu, who is skilled and motivated to discover new ideas, to introduce novel
approaches and strategies and to utilize discoveries for social change and
development.
3. Exceptional Professional – provided with sufficient learning experiences and
exposures both locally and globally, who is equipped with the attributes required of
his professional field and chosen area of expertise.
4. Altruistic – imbued with outpouring love for the poor and under privileged, the
welfare of communities, the development of the country and the promotion of dignity
and humanity, who is ready to utilize his blessings and gifts without counting the
cost.
5. Life-long Learner – a professional of both formal and informal learning opportunities
throughout people’s lives and to foster continuously the knowledge and skills needed
for employment and personal fulfilment.
Page 2 of 16
6. Mighty Eagle – like an eagle, who is fearless to dream and pursue his goals,
directed to the realizations of his plans, strong and confident to deal with challenges,
resilient to the signs and demands of the times and nurturing of the succeeding
generation’s future.
7. Spiritually Upright – one who keeps the Laws of God primary in all his undertakings
and transcends human aspirations into God’s willful promises.
PROGRAM EDUCATIONAL OBJECTIVES (PEO)
The Accountancy Department of the International School of Asia and the Pacific is dedicated to produce Accountancy graduates who, within few years of graduation are expected to:
a. Possess the graduate attributes expected of an ISAPian;
b. Articulate and discuss the latest developments in the specific field of practice and can effectively communicate orally and in writing using English, Filipino, mother tongue language,
and in appropriate Foreign Language required by the industry.
c. Act in recognition of professional, social, and ethical responsibility than can work effectively and independently in multi-disciplinary and multi-cultural teams;
d. Preserve and promote “Filipino historical and cultural heritage”;
e. Perform the basic functions of management such as planning; organizing, leading and controlling that can apply the basic concepts that underlie each of the functional areas of
business;
f. Be equipped with knowledge, skills, attitudes and values through quality instruction and training for professional and entrepreneurial development;
g. Directed by his/her vision and mission in life as a visualizer of truth in business by manifesting true leadership, innovativeness and compassion in his/her field of expertise as an
Accountant;
h. 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;
i. Select proper decision-making tools to critically, analytically, and creatively solve problems and drive results and express clearly and communicate effectively with stakeholders both
in oral and written forms; and
j. Demonstrate corporate citizenship and social responsibility and exercise high personal moral and ethical standards.
STUDENT OUTCOMES:
A graduate of accountancy degree should be able to:
a. Resolve business issues and problems, with a global and strategic perspective using knowledge and technical proficiency in the areas of financial accounting and reporting, cost
accounting and management, accounting and control, taxation and 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.
Page 3 of 16
COURSE DESCRIPTION:
This 3-unit course is intended to provide the students with the necessary knowledge and skills in software applications. Integration of applications from popular business productivity
software suites. Instruction in embedding data, linking and combining documents using word processing, spreadsheets, databases, and presentation media software.
1. Describe the fundamentals of Information Technology (IT) infrastructure components: hardware, software, and data communications systems.
2. Explain the guiding principles of professional behavior in computing.
3. Demonstrate proper file management techniques to manipulate electronic files and folders in a local and networked environment.
4. Use business productivity software to manipulate data and find solutions to business problems.
5. Explain the concepts and terminology used in the operation of application systems in a business environment.
6. Identify emerging technologies for use in business applications.
7. Complete projects that integrate business software applications.
VALUE AIMS:
This course shall guide the students to develop love for computer both hardware and software by designing and developing in a systemic way in manipulating computers applications to
contribute to the building of our nation and strengthen their knowledge in starting-up a business without any bias nor false malice in the future.
COURSE REQUIREMENTS: Grading:
assignments The student’s grade at the end of the semester represents the combined marks for
project (software applications case study) Knowledge (AQ, TT, Rotation Exam, Case Presentation); Skills (Actual Performance in the
three to four quizzes each periodic coverage Laboratory); and Attitude (Attendance, Recitation, Assignment and Behavior/ Conduct).
laboratory exercises There are four (4) grading periods namely, Preliminary, Midterm, Semi – Final and Final
periodic examination (prelims, midterms, semi-finals and finals) Examinations. The school has adopted the cumulative grading system, which is computed as
follows:
CLASSROOM MANAGEMENT
1. Prelim Grade
Teachers: PG= ((AQ+CS+TT)/3+ S )
1. All teachers are expected to conduct themselves in a professional manner PG= Average (60%) + S(40%)
especially when dealing with their students.
2. Classroom shall be neat and orderly before the class starts. 2. Midterm Grade
MG = ((AQ+CS+TT)/3+ S )
MG= Average (60%) + S (40%)
Page 4 of 16
3. A permanent seat plan of the students shall be prepared by the subject MCA= PG + 2(MG)
teacher every beginning of the semester and must be followed during the
entire duration of the semester. 3. Semi – Final Grade
4. The class should start with a prayer and end with a prayer. SFG= ((AQ+CS+TT)/3+ S )
5. Teachers must be in their classes 5 minutes before the schedule. SFG= Average (60%) + S (40%)
6. Teachers should erase the boards before leaving the class and put off all SFCA= MG + 2(SFG)
electrical appliances including lights and electric fans.
7. The teacher should be the last to leave the room in case there are no more 4. Final Grade
subjects after his / her class. FG= ((AQ+CS+(TT(70%)+CE(30%)))/3+ S )
8. He / she should ask students to pick up pieces of papers or plastics before FG= Average (60%) + S (40%)
leaving the classroom. FCA= FG + 2(SFG)
9. Any damage to the classroom used by teachers should immediately be
reported to the General Services Office or through the Quality Assurance
Moderator for Administration.
LEGEND:
Students: AQ = Average Quiz
All students must come on time and must be in their complete uniform during CS = Class Standing
class hours. TT = Term Test
Strictly NO littering inside the class and no eating while class is going on. S = Skills
All students must conduct themselves with discipline throughout the entire PG = Prelim Grade
class. MG = Midterm Grade
Shouting or howling is strictly prohibited as it would disturb other classes in MCA = Midterm Cumulative Average
adjacent classrooms or buildings. SFG = Semi-Final Grade
SFCA =Semi – Final cumulative Average
LABORATORY MANAGEMENT: FG = Final Grade
1. Only those authorized to work inside the laboratory are allowed to enter the FCA = Final Cumulative Average
area. Students should log before and after working in the laboratory CE = Comprehensive Exam
2. Good housekeeping and safety precautions should be observed at all times.
3. Eating and bringing of food and soft drinks are strictly prohibited inside the
laboratory.
4. Log-in/out notebook should be filled out every time a particular equipment is
to be used. Any malfunctioning of an equipment should be immediately
reported to the instructor.
5. Damages must be reported immediately to the instructor or lab technician and
an immediate replacement should be arranged.
Page 5 of 16
6. The computer connected to the equipment should not be used for other
purposes not related to the operation of the equipment where it is attached.
7. The last person who leaves the room should see to it that every
utility(equipment, lights, aircon, etc.) is turned off
8. All students are required to attend the Laboratory Safety Seminar sponsored
by the college prior to their laboratory schedules.
9. The following are not allowed inside the laboratory
• Vandalism. Do not write anything on the tables and walls
• Smoking, Sleeping and Playing Cards.
• Computer Games, especially obscene and pornographic ones
TEXTBOOK:
1. Lloyd D. Brooks, EMC/Paradigm Publishing Company: Integrated Computer Projects
2. Shelley Gaskin, Alicia Vargas, Debra Geoghan, & Nancy Graviett: Access to Microsoft Office 2016 (Word, Excel, Access, PowerPoint)
ADDITIONAL REFERENCES:
1. CISCO System: IT Essentials PC Hardware & Software Lab Manual, 2010
2. Shelly, Gary: Microsoft Office PowerPoint 2007 Introductory Concepts & Techniques, 2008
3. Kroenke, David: Database Concepts, 2008
4. Jain, Piyush: Education on Internet Programming, 2006
5. Nortons, Peter: Intro to Computers, 2006
E-BOOKS
1. Carol V. Brown: Managing Information Technology (7th Edition), 2012
2. June Jamrich Parsons, Dan Oja, and Donna Mulder: Practical Microsoft Office 2010, 2010
3. WebSiteLink.com: The Ultimate Computer Repair Guide-2010, 2010
4. Beskeen, Cram, Duff, Friedrichsen, Reding: Microsoft Office 2010 Illustrated Introductory, First Course (1st Edition), 2011
Page 6 of 16
PRELIMINARY PERIOD
PRELIM PERIOD
Follow classroom policies and Course Orientation
have a background of the course. Classroom policies overview of the course
Week 1
to week Learn how to use productivity
software like MS office. Lab Exercise 1: Audio Visual Presentation Laptop, computer Hands-on activity
5
Understand the significance of the --Taking a tour of Windows about windows followed by unit, overhead followed by a quiz
different computer system --Creating and deleting files a lab activity projector and speaker
components. --Formatting text and performing common
Set the margin of a document. printing functions
2 HRS Adjust line and paragraph spacing.
Create and modify bulleted and 1. Identifying software and hardware interactions Discussion and recitation on Laptop, PowerPoint Quiz using pen and
LEC
numbered list. and types of software the said topic followed by a presentation and paper technique
Organize a document in outline Lab activity. projector
3 HRS
view. Lab Exercise 2:
LAB
Distinguish the importance of --Using graphic tools Formatting paragraphs Student will be group into 5 Laptop, PowerPoint Accomplishment of
and documents and each will be given a presentation and the laboratory
number system in relation to
module to create something projector worksheets.
computer and its application,
2. Using Word Processing Software using word processing
Know the relation between various
types of numbers.
Lab Exercise 3: Discussion and recitation on Laptop, PowerPoint
Understand how table work the said topic followed by a presentation and Quiz using pen and
--Working with tables
Format the table --Using outline, track changes and language Lab activity. projector paper technique
Modify the Borders and Shading tools
Adjust the width or Height
Change the alignment Lab Exercise 5: Interactive learning through Laptop, PowerPoint
Insert and Delete --Working with Pictures lab activity and hands-on in presentation and Accomplishment of
rows/columns/cells --Working with Objects using word processing projector the laboratory
Merge and Split Cells worksheets.
1.5
Explore the relation between
hours
various types of numbers and
examin
tables
ation
Explore objects
PRELIM EXAMINATION
Page 7 of 16
MIDTERM PERIOD
MIDTERM PERIOD
MIDTERM EXAM
Page 8 of 16
SEMI FINAL PERIOD
SEMI-FINAL PERIOD
Identify the latest trend in ICT and 1. Latest Trends and Issues in Information
Week how it can be applied to the society Technology Discussion and recitation on Computer unit, Quiz using pen and
10 to Create Presentations the different latest issues PowerPoint and paper technique
Week Display information in the Lab. Exercise 1: and trends in information overhead projector
14 Presentation --Using Presentation Software technology in relation to
Create a Master Slide 1.1. ICT Applications in Society business education followed Computer unit and lab Assessment of
Insert Headers and Footers a lab activity using manuals Individual skills
Manage the Slides Lab. Exercise 2: PowerPoint through the Skills
Explore, and analyze how ICT -- Using presentation software Performance
impacts on society at large. Apply what you learned to a Checklist
1.2. Working with Objects small Powerpoint file. As you Computer unit and lab
Insert Clip Art Images
1.3. Office productivity tools finish each practice, save the manuals Accomplishment of
Insert Graphics from other sources
2 HRS file. the laboratory
Create and Using Tables worksheets.
LEC Lab. Exercise 3:
Format the Table -- Using presentation software The groups will continue in Computer unit and lab
Create a chart making their powerpoint manuals
3 HRS Create Objects 1.4. Enhancing the Présentation presentation Hands-on exam and
LAB Change the Background Color Discussion and recitation Computer unit, will be graded using
Determine which productivity tool about how to enhance PowerPoint and rubrics
is applicable for the use of desktop PowerPoint presentation overhead projector
publishing software and publishing into a meaningful and Quiz using pen and
tools for educational attractive one paper technique
communication and instruction.
1.5 Animate Objects
hours customize the animation
examin Apply slide Transitions
ation
SEMI-FINAL EXAM
FINAL PERIOD
Page 9 of 16
FINAL PERIOD
Evaluate the different internet 1. Introduction to Internet Technologies Classroom discussion and Books, PowerPoint Quiz using pen and
technologies --Identifying network recitation on the different and Projector paper technique
Learn how to use email --Fundamentals internet technologies and
Week
Information sources in the internet --Identifying the Relationship between concepts.
15 to
Use a web browser computer and networks, telephone networks,
Week
And searching the internet and the internet
18
Learn the basic Hardware and --Understanding e-mail
2 HRS software Troubleshooting.
Learn how to install Windows Lab. Exercise 1:
LEC
--Hardware and software installation, Each student will perform on Computer unit and lab Hands-on activity and
Troubleshooting, Maintenance, Upgrading how to install windows 10 manuals will be graded using
--Install Windows and after which they will rubrics
3 HRS
create a checklist both
LAB
hardware and software parts
2. Introduction to Microsoft Access Research works in the library Books, computer Submission of
Identify the use of Microsoft
2.1. Relational Database and Queries about Microsoft access, unit, internet, research work
access as a small database.
2.2. Customize, Analyze, and Summarize followed by discussion and PowerPoint and Quiz using pen and
Identify the terminology and
Query Data recitation projector paper technique
functions common to most
2.3. Creating and Using Professional Forms
1.5 database management systems.
and Reports
hours
examin Learn how to how to plan, design,
Lab. Exercise 2:
ation create, manipulate and query
--Create a database using mircrosoft access Student will be group into 5, Hands-on activity and
databases.
they will be given a simple Computer unit and lab will be graded using
system title to create in manuals rubrics
Microsoft access database
FINAL EXAM
Total no
of hrs:
90 hrs
Page 10 of 16
ALIGNMENT OF PROGRAM EDUCATIONAL OBJECTIVES AND OUTCOMES
Vision -Mission Vision –Mission Vision – Vision – Vision –Mission Vision – Vision – Vision –
1 2 Mission 3 Mission 4 5 Mission 6 Mission 7 Mission 8
Multi-
Producing
disciplinary and Producing Empowering Socially Passion for Global
exceptionally- Uplifting the
integrated values-oriented self-sustaining responsible excellence in staging is
skilled quality of life
academic professionals communities individual service unwavering
professionals
approaches
a. Possess the graduate attributes expected of
/ / / / / / / /
an ISAPian;
b. Articulate and discuss the latest
developments in the specific field of practice
and can effectively communicate orally and
/ / / / / / / /
in writing using English, Filipino, mother
tongue language, and in appropriate
Foreign Language required by the industry.
c. Act in recognition of professional, social, and
ethical responsibility than can work
effectively and independently in multi- / / / / / / / /
disciplinary and multi-cultural teams;
d. Preserve and promote “ Filipino Historical
/ / / /
and Cultural Heritage”;
e. Perform the basic functions of management
such as planning; organizing, leading and
controlling that can apply the basic concepts / / / / / / / /
that underlie each of the functional areas of
business;
f. Be equipped with knowledge, skills, attitudes
/ / / / / / /
and values through quality instruction and
Page 11 of 16
training for professional and entrepreneurial
development;
g. Directed by his/her vision and mission in life
as a fiscalizer of truth in business by
manifesting true leadership, innovativeness / / / / / / / /
and compassion in his/her field of expertise
as an Accountant;
h. 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;
i. Select proper decision making tools to
critically, analytically, and creatively solve
problems and drive results and express / / / / / / / /
clearly and communicate effectively with
stakeholders both in oral and written forms;
j. Demonstrate corporate citizenship and social
responsibility and exercise high personal / / / / /
moral and ethical standards.
Page 12 of 16
language, and in appropriate Foreign Language required by
the industry.
c. Act in recognition of professional, social, and ethical
responsibility than can work effectively and independently / / / / /
in multi-disciplinary and multi-cultural teams;
d. Preserve and promote “Filipino historical and cultural
/
heritage”;
e. Perform the basic functions of management such as
planning; organizing, leading and controlling that can apply
/ / / / /
the basic concepts that underlie each of the functional areas
of business;
f. Be equipped with knowledge, skills, attitudes and values
through quality instruction and training for professional and / / / /
entrepreneurial development;
g. Directed by his/her vision and mission in life as a fiscalizer
of truth in business guided by the core values of the / / / / /
school;
h. 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;
i. Select proper decision making tools to critically, analytically,
and creatively solve problems and drive results and express
/ / / / /
clearly and communicate effectively with stakeholders both
in oral and written forms;
j. Demonstrate corporate citizenship and social responsibility
/ / / / /
and exercise high personal moral and ethical standards.
Page 13 of 16
C. STUDENT OUTCOMES TO COURSE OUTCOMES
COURSE
COURSE OUTCOMES
STUDENT OUTCOMES (SO) LEVEL OUTCOMES
Proficiency assessed by
Satisfied
A. Resolve business issues and problems, with a global and strategic perspective using knowledge and technical Oral & written
proficiency in the areas of financial accounting and reporting, cost accounting and management, accounting and examination with the use
L /
control, taxation and accounting information systems. of OBE rubrics
B. Conduct accountancy research through independent studies of relevant literature and appropriate use of accounting Oral & written
theory and methodologies. O / examination with the use
of OBE rubrics
C. Employ technology as a business tool in capturing financial and non-financial information, generating reports and Oral & written
making decisions. O / examination with the use
of OBE rubrics
D. Apply knowledge and skills that will successfully respond to various types of assessments (including professional Oral & written
licensure and certifications). L / examination with the use
of OBE rubrics
E. Confidently maintain a commitment to good corporate citizenship, social responsibility and ethical practice in Oral & written
performing functions as an accountant. O / examination with the use
of OBE rubrics
Page 14 of 16
D. STUDENT OUTCOMES TO COURSE CONTENTS
STUDENT OUTCOMES
COURSE CONTENTS
A B C D E
3. Demonstrate proper file management techniques to manipulate electronic files and folders in
/ / / /
a local and networked environment.
4. Use business productivity software to manipulate data and find solutions to business
/ / / / /
problems.
5. Explain the concepts and terminology used in the operation of application systems in a
/ / / / /
business environment.
6. Identify emerging technologies for use in business applications. / / / / /
Page 15 of 16
CURRICULUM MAP
KEY LEGENDS:
L - Facilitate Learning of the competencies (input is provided and competency is evaluated)
P - Allow student to practice competencies (no input is provided and competency is evaluated)
O - Provide opportunity for development (no input is provided, but there is opportunity to practice competencies)
A B C D E F G H I J
Page 16 of 16