Chapters
The Excel & Data Analysis unit contains 15 chapters. Students should work through the chapters as shown on the Section Schedule page.
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. |
|
|
| C01.ED02 | Create and manage workbooks, worksheets, and their data. |
|
|
| C01.ED03 | Format worksheets and cells to create professional reports. |
|
|
| C01.ED04 | Write formulas using cell references and functions to calculate data. |
|
|
| C01.ED05 | Use tables and PivotTables to organize data. |
|
|
| C01.ED06 | Use charts, PivotCharts, and sparklines to present data in a graphical format. |
|
|
| C01.ED07 | Use what-if analysis tools to project future values and prepare different scenarios. |
|
|
| C05.ED08 | Interpret and analyze spreadsheet data |
|
|