This course has been changed from the previous catalog, the changed field(s) are highlighted in red:
Course Title: MS Excel and Access II
Title Abbreviation: MS EXCEL and ACCESS II
Department: OBT
Course #: 135
Credits: 5
Variable: No
IUs: 5
CIP: 520302
EPC: 547
REV: 2018
Course Description
Use Microsoft Excel for PCs to apply advanced formatting techniques to spreadsheets and charts, write complex formulas and use advanced functions, use What-if Analysis tools, manage and analyze worksheet data, and automate tasks with templates and macros. Use Microsoft Access for PCs to design a relational database, enhance the design of tables, use advanced query and filter techniques, and design custom forms and reports.
Prerequisite
Prerequisite: OBT 134.
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, Required for certificate
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.
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.
10. Technology
Definition: Understanding the role of technology in society and using technology appropriately and effectively.
Outcomes: Students will be able to . . . 10.3 Use technology appropriate to the context and task to effectively retrieve and manage information, solve problems, and facilitate communication.
Course Contents