Skagit Valley College logo

Catalog Course Search Details

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:    OFTEC

 Course #:    135

 Credits:    4

 Variable:     No

 IUs:    4

 CIP:    n/a

 EPC:    n/a

 REV:    2013


 Course Description  

Use Microsoft Excel 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 to design a relational database, enhance the design of tables, use advanced query and filter techniques, and design custom forms and reports.

 Prerequisite  

Prerequisite: OFTEC 134

Additional Course Details

Contact Hours (based on 11 week quarter)

Lecture: 44

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

Other Institution Equivalencies Table
Institution Course # Remarks
N/A

Learning Outcomes

After completing this course, the student will be able to:

  1. Apply advanced formatting techniques to create attractive worksheets and charts.
  2. Write formulas using advanced mathematical, statistical, financial, logical, lookup, and nested functions to find numerical information.
  3. Use range names, 3-D References, and links to manage and summarize data located in multiple worksheets.
  4. Create, sort, and filter Excel tables to arrange data into logical groupings.
  5. Create PivotTables and PivotCharts to arrange data into meaningful reports and charts.
  6. Use Excel’s What-If Analysis tools for planning and decision-making.
  7. Automate Excel tasks with macros and create templates to improve efficiency.
  8. Enhance the design of Access tables to improve the organization of business or personal records.
  9. Use advanced query techniques to locate data for reporting or decision making.
  10. Design custom Access forms and reports to meet specific communication needs.
  11. Manage the electronic storage of files.
  12. Analyze workplace scenarios requiring number-based solutions or the analysis and reporting of data and apply appropriate strategies to arrive at solutions using Excel and Access.

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

  1. MS Excel: Advanced spreadsheet and chart formatting.
  2. MS Excel: Advanced functions.
  3. MS Excel: Nested formulas.
  4. MS Excel: PivotTables and PivotCharts.
  5. MS Excel: Tables.
  6. MS Excel: What-if Analysis tools (Scenario Manger, Goal Seek, Data Tables).
  7. MS Excel: Workbook management techniques.
  8. MS Excel: Macros and templates.
  9. MS Access: Relationship database design concepts.
  10. MS Access: Advanced table design and query techniques.
  11. MS Access: Form design and customization.
  12. MS Access: Report design and customization.