Course Content and Outcomes Guides (CCOG)

CCOG for BA 169Z Fall 2025


Course Number:
BA 169Z
Course Title:
Data Analysis Using Microsoft Excel (BA216A=BA 169Z)
Credit Hours:
4
Lecture Hours:
40
Lecture/Lab Hours:
0
Lab Hours:
0

Course Description

Covers Microsoft Excel software skills necessary for evidence-based problem-solving, including workbook editing, formula creation, charting, and pivot tables. Emphasizes hands-on learning using Excel functions to perform data analysis to enhance decision-making. This course is part of Oregon Common Course Numbering. BA 216A and BA 169Z are equivalent. Prerequisites: (WR 115 and RD 115) or IRW 115, CIS 120 or BA 106. Audit available.

Addendum to Course Description

Business analytics skills are a requirement across various job functions and are in high demand from employers. Data analysis is designed to expose students to the importance of analytic applications used in industry communication and decision-making processes.  Analyze data in Excel with logical, approximate match lookup, and summary IF functions. Work with financial functions to analyze loans and investments by creating one and two-variable data tables, amortization schedules, calculating interest and principal payments on loans or investment opportunities. Prepare depreciation schedules and determine payback periods. Use regression analysis is to evaluate the effects of one or more independent variables on a single dependent variable. Automate tasks with Macros. Visualize data with advancing charting, building data models, and dashboards. 

Intended Outcomes for the course

Upon successful completion of the course student should be able to: 

  1. Create and manage worksheets using appropriate data formatting.
  2. Construct formulas with relative, absolute, and mixed cell references.
  3. Analyze data using logical, lookup, mathematical, statistical, and text functions.
  4. Manipulate large volumes of data using datasets and tables.
  5. Interpret data using data visualization tools, including pivot tables and charts.

Outcome Assessment Strategies

A letter grade will be issued for this course based upon:

  • Case study analysis
  • Individual or group assignments
  • Assessment examinations
  • Skill assessment software

Course Content (Themes, Concepts, Issues and Skills)

Themes, Concepts, Issues

  • Performing calculations, analyzing and charting financial data
  • Managing data with data tools from multiple sources, and automating tasks with macros
  • Performing What-IF analyses and exploring financial tools and functions
  • Exploring and summarizing data with Data Models, PivotTables, Dashboards
  • Analyzing Data with Business Intelligence (BI) tools and Power Query
  • Visualizing and reporting data with Smart Dashboards and presentations 

Competencies/Skills

  • Create financial formulas and functions
  • Use lookup tables and logical look up functions
  • Work with IF Logical functions
  • Perform What-If Analyses using One and Two Variable data tables
  • Create and edit Charts and Chart elements
  • Work with multiple worksheets, and workbooks, and create Data Models
  • Manage data with sorting, filtering, calculating subtotals, removing and highlighting duplicate values and records, and applying conditional formatting rules.
  • Create and format Dashboards, PivotTables and Pivot Charts
  • Build Data Models and use Power Pivot tools to transform data
  • Analyzing data with Business Intelligence (BI) tools, using Power Query to write, edit and retrieve data
  • Create Smart Dashboards and data visualization reports