Skip to main content

Excel & Data Analysis

Chapters

The Excel & Data Analysis unit contains 14 chapters. Students should work through the chapters as shown on the Section Schedule page.

Data Analysis Supplemental Content
Excel Chapter 1
Excel Chapter 2
Excel Chapter 3
Excel Chapter 4
Excel Chapter 5
Excel Chapter 6
Excel Chapter 7
Excel Chapter 8
Excel Chapter 9
Excel Chapter 10
Excel Chapter 11
Excel Chapter 12
Excel Supplemental Content

Unit Learning Objectives

After completing the Excel & Data Analysis unit, students will be able to:

# Unit Learning Objective Learning Activities
& Informal Assessments
Formal Assessments
C05.ED01 Locate and access data and resources necessary to solve problems.
  • Access: Access Basics Participation Project
  • Access: Database Creation Participation Project
  • Access: Database Design Participation Project
  • Access: Fields & Keys Participation Project
  • Access: Forms Participation Project
  • Access: Queries I Participation Project
  • Access: Queries II Participation Project
  • Access: Queries III Participation Project
  • Access: Queries IV Participation Project
  • Access: Reports Participation Project
  • Access: SQL Participation Project
  • Data Analysis: Online Scavenger Hunt Participation Project
  • Excel: Charts Participation Project
  • Excel: Excel Basics Participation Project
  • Excel: Formatting Participation Project
  • Excel: Formulas & Functions I Participation Project
  • Excel: Formulas & Functions II Participation Project
  • Excel: Formulas & Functions III Participation Project
  • Excel: PivotTables Participation Project
  • Excel: Solver Participation Project
  • Excel: Tables Participation Project
  • Excel: What-If Analysis Participation Project
  • PowerPoint: Layout & Formatting Participation Project
  • PowerPoint: Presentation Techniques Participation Project
  • Word: Layout & Pagination Participation Project
  • Word: References & Workflow Participation Project
  • Word: Styles & Illustrations Participation Project
  • Exam #1
  • Exam #2
  • Final Exam
  • Homework #1
  • Homework #2
  • Homework #3
  • Homework #4
  • Homework #5
  • Homework #6
  • MyITLab Bonus Project #1
  • MyITLab Bonus Project #2
  • MyITLab Bonus Project #3
C01.ED02 Create and manage workbooks, worksheets, and their data.
  • Access: Database Design Participation Project
  • Excel: Charts Participation Project
  • Excel: Excel Basics Participation Project
  • Excel: Formatting Participation Project
  • Excel: Formulas & Functions I Participation Project
  • Excel: Formulas & Functions II Participation Project
  • Excel: Formulas & Functions III Participation Project
  • Excel: PivotTables Participation Project
  • Excel: Solver Participation Project
  • Excel: Tables Participation Project
  • Excel: What-If Analysis Participation Project
  • MyITLab Lesson A
  • MyITLab Lesson B
  • Exam #1
  • Final Exam
  • Homework #1
  • Homework #2
  • Homework #3
  • Homework #6
  • MyITLab Lesson A
  • MyITLab Lesson B
  • MyITLab Bonus Project #1
C01.ED03 Format worksheets and cells to create professional reports.
  • Excel: Formatting Participation Project
  • Excel: Tables Participation Project
  • MyITLab Lesson A
  • Exam #1
  • Final Exam
  • Homework #1
  • Homework #2
  • Homework #3
  • MyITLab Lesson A
  • MyITLab Bonus Project #1
C01.ED04 Write formulas using cell references and functions to calculate data.
  • Excel: Formulas & Functions I Participation Project
  • Excel: Formulas & Functions II Participation Project
  • Excel: Formulas & Functions III Participation Project
  • Excel: What-If Analysis Participation Project
  • MyITLab Lesson A
  • MyITLab Lesson B
  • Exam #1
  • Homework #1
  • Homework #2
  • Homework #3
  • MyITLab Lesson A
  • MyITLab Lesson B
  • MyITLab Bonus Project #1
C01.ED05 Use tables and PivotTables to organize data.
  • Excel: PivotTables Participation Project
  • Excel: Tables Participation Project
  • MyITLab Lesson A
  • MyITLab Lesson B
  • Exam #1
  • Final Exam
  • Homework #1
  • Homework #2
  • Homework #3
  • Homework #6
  • MyITLab Lesson A
  • MyITLab Lesson B
  • MyITLab Bonus Project #1
C01.ED06 Use charts, PivotCharts, and sparklines to present data in a graphical format.
  • Excel: Charts Participation Project
  • Excel: PivotTables Participation Project
  • MyITLab Lesson A
  • MyITLab Lesson B
  • Exam #1
  • Final Exam
  • Homework #2
  • Homework #6
  • MyITLab Lesson A
  • MyITLab Lesson B
  • MyITLab Bonus Project #1
C01.ED07 Use what-if analysis tools to project future values and prepare different scenarios.
  • Excel: Charts Participation Project
  • Excel: Solver Participation Project
  • Excel: What-If Analysis Participation Project
  • MyITLab Lesson B
  • Exam #1
  • Final Exam
  • Homework #2
  • Homework #3
  • MyITLab Lesson B
  • MyITLab Bonus Project #1
C05.ED08 Interpret and analyze spreadsheet data
  • Excel: Charts Participation Project
  • Excel: Formatting Participation Project
  • Excel: Formulas & Functions I Participation Project
  • Excel: Formulas & Functions II Participation Project
  • Excel: Formulas & Functions III Participation Project
  • Excel: PivotTables Participation Project
  • Excel: Solver Participation Project
  • Excel: Tables Participation Project
  • Excel: What-If Analysis Participation Project
  • Exam #1
  • Final Exam
  • Homework #1
  • Homework #2
  • Homework #3
  • Homework #6