BTAC 194 - Excel: Data Consolidation and What-If Analysis

Credits: 1
Focuses on data consolidations, links, and formula auditing. Covers use of spreadsheets for decision making with “what-if” analysis.

Recommended: BTAC 191 and keyboarding skills.

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

Consolidate and use data from multiple worksheets.
Create and apply validation rules.
Audit formulas.
Set up a Watch Window.
Create one-variable and two-variable data tables.
Use What-if Analysis tools.

Program Outcomes

Implement calculator/computer technology to solve problems.
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.