Monday-

Importing data from an Excel File

Tuesday-

Sorting and Filtering

Wednesday-

Creating relationships

Thursday-

Project: Creating a customer information database

Friday-

Review

Monday-

Working in the Navigation Pane

Tuesday-

Save Options and compact and repair

Wednesday-

Project: Managing the Access Environment; Quiz: Managing the Access Environment

Thursday-

Creating an Access Database and Table

Friday-

Entering data

Monday-

Project: Recording a Macro

Tuesday-

Merge to create letters

Wednesday-Thursday

Project: Creating a merge

Friday-

Quiz: Word Advanced Skills

Monday-

Quiz 2: Enhancing Microsoft Excel Charts; creating picture charts

Tuesday-

Sparklines

Wednesday-

Stock Market Project part 6- Creating Advanced charts

Thursday-

Quiz 3: Advanced charting options; Review

Friday-

Test

Monday-

Creating charts

Tuesday-

Quiz 1- Creating charts in Microsoft Excel

Wednesday-

Formatting charts; enhancing charts with illustrations

Thursday-

Formatting Illustrations

Friday-

Project: Stock market part 5- creating and enhancing charts

Monday-

Function wizard and linking formulas

Tuesday-

Analyzing data by sorting and filtering; project: Stock market project Part 4- Entering functions

Wednesday-

Quiz 4:  Utilizing functions and data commands

Thursday-

Review

Friday-

Test

Monday-

Order of operations

Tuesday-

Microsoft Excel formulas

Wednesday-

Types of cell references in formulas

Thursday-

Project: Stock Market Project Part 3- entering formulas; Quiz 3: creating formulas

Friday-

Functions in Microsoft Excel

Monday-

Project 5: Stock Market Project Part 1- Researching and Recording stock prices

Tuesday-

Quiz 1: Data Entry

Wednesday-

Cell Formats; editing cells, rows, and columns

Thursday-

Managing worksheets

Friday-

Project:  Stock market project part 2- Formatting a spreadsheet

Monday-

Quiz 3:  Managing File settings

Tuesday-

Lesson 26 Review and Test

Wednesday-

Microsoft Excel Data Types

Thursday-

Entering and Editing Cell data

Friday-

Selecting, filling, moving and copying cell data; auto fill

Monday-

Quiz 2:  Spreadsheet basics; workbook properties

Tuesday-

Saving and File formats

Wednesday-

Sharing worksheet data

Thursday-

Managing comments, printing worksheets and workbooks

Friday-

Begin project-  Saving and printing Microsoft Excel Files