• Day 1 - 6.1 Introduction to Spreadsheets Google Slide (Teacher Resource)

• Day 2

As a class or individually work through the tutorials below

• Why It Matters: Microsoft Excel Basic Skills

• Introduction to Using Excel

• Creating a New Workbook

• Entering Data

• Introduction to Basic Formatting and Layout

• Table Styles

• Cell Styles

• Cell Format

• Comma Styles

• Rearranging Tables

• Changing Width of Columns and Rows

• Introduction to Using Multiple Worksheets

• Creating a Workbook with Multiple Worksheets

Student Activity

• Putting It Together: Microsoft Excel Basic Skills ( Google Sheets Copy)

• Assignment: Organize Sales Data

• Discussion: Merging and Centering Cells

Day 2 & 3

• Student Activity- 6.1 Introduction to Spreadsheets Student Activity: Employee Earnings -(Provide each student a Copy)-

• 6.2 Intro to Spreadsheets Intermediate Google Slide (Teacher Resource)

• 6.2 Intro to Spreadsheets Intermediate Student Activity (provide a copy to all students)

As a class or individually work through the tutorials below

• Why It Matters: Microsoft Excel Intermediate Skills

• Introduction to Using Excel for Data Analysis

• Sorting Data

• Filtering Data

• Functions

• Introduction to Automating Data Entry

• Flash Fill

• SUM Data

• Simple Math

• Introduction to Graphics

• Graphics

• Modify Graphics

• Format Graphics

• Introduction to Charts

• Charts

• Clustered Column Charts

• Chart Types

Student Activity

• Putting It Together: Microsoft Excel Intermediate Skills

• Assignment: Analyze Yearly Trends

• Discussion: Hard Return within a Cell

Microsoft Excel Advanced Skills

As a class or individually work through the tutorials below

• Why It Matters: Microsoft Excel Advanced Skills

• Introduction to Sparklines

• Sparklines

• Introduction to More Formatting and Layout

• Conditional Formatting

• Viewing a Worksheet

• Introduction to Pivot Tables

• Pivot Tables

• Introduction to Macros

• Macros

• Recording a Macro

• Introduction to Statistical Functions and Formulas

• What is a Function?

• Lookup Functions and Formulas

• Logical Functions and Formulas

• Financial Functions and Formulas

• Introduction to Add-Ins

• Add-Ins

• Introduction to Internet and Excel

• Internet and Excel

Ethics for Unit 6 (5 different scenarios)

Robert G DelCampo from the Anderson School of Management put together Resources for teaching Ethics from Scenes from the Office.

The videos should not be shown to discuss the unethical practices. As Delcampo notes: "Using traditional cases might be pedagogically helpful, but they are often easily forgotten. To enrich case-based learning for business ethics instruction, we will discuss sample cases that feature popular culture television, and you will learn how to use sample episodes from the television show The Office to engage and motivate students in your classroom."

Teacher Choice: (Sheets Capstone Project)

You may choose to have a capstone project (2-3 days) for this unit. Here is one example, of course you may have one that you have used in the past.

• My Dream Car Project