Course Title: Office Programming-VBA
Title Abbreviation: OFFICE PROGRAMMING-VBA
Department: CIS
Course #: 243
Credits: 5
Variable: No
IUs: 5
CIP: 110301
EPC: 514
REV: 2018
Course Description
Office Programming-VBA is a capstone course that explores ways to customize and improve procedures across the office suite using various tools. Topics include macros, application customization and development, object linking and embedding and cross-application development.
Prerequisite
Prerequisite: introductory database programming experience using VBA as presented in CIS 242 is essential. Students should be comfortable with customizing Microsoft Access queries, forms and reports to respond to runtime events.
Contact Hours (based on 11 week quarter)
Lecture: 55
Lab: 0
Other: 0
Systems: 0
Clinical: 0
Intent: Distribution Requirement(s) Status:
Vocational Preparatory Required for ATA degree, Elective
Equivalencies At Other Institutions
Learning Outcomes
After completing this course, the student will be able to:
General Education Learning Values & Outcomes
Revised August 2008 and affects outlines for 2008 year 1 and later.
2. Critical Thinking
Definition: The ability to think critically about the nature of knowledge within a discipline and about the ways in which that knowledge is constructed and validated and to be sensitive to the ways these processes often vary among disciplines.
Outcomes: Students will be able to . . . 2.1 Identify and express concepts, terms, and facts related to a specific discipline. 2.2 Analyze issues and develop questions within a discipline. 2.3 Identify, interpret, and evaluate pertinent data and previous experience to reach conclusions.
6. Individual Awareness & Responsibility
Definition: Understanding, managing, and taking responsibility for one’s learning and behavior in varied and changing environments.
Outcomes: Students will be able to . . . 6.2 Demonstrate standards of professionalism in manner, appearance, and setting appropriate to the context, including the classroom, workplace, and community.
8. Mathematical Reasoning
Definition: Understanding and applying concepts of mathematics and logical reasoning in a variety of contexts, both academic and non-academic.
Outcomes: Students will be able to . . . 8.2 Correctly apply logical reasoning and mathematical principles to solve problems. 8.3 Interpret information and reasoning expressed mathematically (for example in spreadsheets, diagrams, charts, formulas, etc.). 8.4 Communicate mathematical information effectively.
10. Technology
Definition: Understanding the role of technology in society and using technology appropriately and effectively.
Outcomes: Students will be able to . . . 10.2 Demonstrate an understanding of legal, ethical, and environmental issues in the use and misuse of technology.
Course Contents