Jun 16, 2024  
2022-2023 Catalog 
2022-2023 Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

BTAC 193 - Excel as a Database

Credits: 1
Covers Excel’s database functions, pivot tables, conditional functions, and amortization table.

Recommended: BTAC 191  and keyboarding skills.

Course Fee: $5.00

Course Outcomes:
Students who successfully complete this class will be able to:

  1. Design and create tables based on data table theory.
  2. Import data from text files and other sources.
  3. Apply advanced formatting, filtering and sorting.
  4. Create and use range names.
  5. Use advanced functions.
  6. Create, format and apply PivotTables and PivotCharts.

Program Outcomes
  1. Implement calculator/computer technology to solve problems.
  2. Integrate Microsoft Office software applications to present information in a meaningful manner.

College-wide Outcomes
  • Critical Thinking - Critical thinking finds expression in all disciplines and everyday life. It is characterized by an ability to reflect upon thinking patterns, including the role of emotions on thoughts, and to rigorously assess the quality of thought through its work products. Critical thinkers routinely evaluate thinking processes and alter them, as necessary, to facilitate an improvement in their thinking and potentially foster certain dispositions or intellectual traits over time.
  • Responsibility - Responsibility encompasses those behaviors and dispositions necessary for students to be effective members of a community. This outcome is designed to help students recognize the value of a commitment to those responsibilities which will enable them to work successfully individually and with others.

Add to Portfolio (opens a new window)