Business 91L

Business Productivity Tools

Spring 2015

 

Assignments

Date

Pre-Class work

In-Class Activities

Homework

Homework Videos

2/9 -11

Learning Skills

Introduction

Form teams

Word Graphics

 

Page Backgrounds

Screen Shot

Table of Contents

2/16-18

Excel Concepts 1

Excel Basics

SHARED Learning

Formulas

Cell References

2/23-25

People Skills

AutoFill Handle

Special Formats

Wrap Text

Formula Bar

Freeze Panes

Protection

Excel Toolkit

 

Budget 1

 

None

3/2-4

Excel Concepts 2

Dialog Box

AutoSum Icon

Rounding

Function Basics

 

Budget 2

 

3/9-11

Excel Concepts 3

IF and AND

COUNTIF    Filters

If Functions

 

Charts 1

 

None

3/16-18

Communication

VLOOKUP Function

Lookup Functions

 

Charts 2

 

PowerPoint Charts

Combination Charts

3/30-4/2

Excel Concepts 4

Visible Cells

Form Tool

Advanced Filters

Data Tools

 

Pivot Tables

 

Intro Pivots

Pivot Table Tools

Slicers    Pivot Charts

4/6-8

Presentation Skills

 

Electives:

Choose from either the PowerPoint or the Advanced Excel lessons.

PowerPoint 1

PowerPoint 2

Transitions

Embed 1    Embed 2

Slide Master

Combine Images

Macros

Dashboards

Conditional Formatting

Dashboard Formatting

Dashboard Charts

4/13-15

None

Inventory Project

Sample Exam

 

4/20-22

 

Final Exam (Excel)

(Open Notes)

 

 

 

 

 

Additional Course Material

Mike Splane

MAC/Office 2011 help

Excel Help Excel Concepts

Excel Help Reference Guide

Exam Help Study Guide

Exam Help Sample Exam

Exam Worksheet 2010Exam.xlsx

Assignments Worksheet 2010Data.xlsx

 

 

Life Skills

Presentation Skills

Learning Skills

People Skills

Communication Skills

 

Business 91-L  -  Spring 2015 Schedule

All sections meet for 10 weeks, starting in the third week of the semester, in BBC 301.

Section

Code

Days

Times

Instructor

Dates

Syllabus

1

22255

Tuesday

6:00 – 7:15 PM

Kwan, Patricia

2/10  -  4/28

 

2

28221

Tuesday

7:30 – 8:45 PM

Kwan, Patricia

2/10  -  4/28

 

3

22256

Monday

9:00 – 10:15 AM

Splane, Mike

2/9  -  4/20

Section 3

4

22257

Monday

10:30 -  11:45 AM

Splane, Mike

2/9  -  4/20

Section 4

5

22258

Monday

1:30 – 2:45 PM

Splane, Mike

2/9  -  4/20

Section 5

6

22259

Monday

3:00 – 4:15 PM

Splane, Mike

2/9  -  4/20

Section 6

7

22261

Wednesday

9:00 – 10:15 AM

Splane, Mike

2/11  -  4/22

Section 7

8

2262

Wednesday

10:30 -  11:45 AM

Splane, Mike

2/11  -  4/22

Section 8

9

22263

Wednesday

1:30 – 2:45 PM

Splane, Mike

2/11  -  4/22

Section 9

10

22264

Wednesday

3:00 – 4:15 PM

Splane, Mike

2/11  -  4/22

Section 10

 

Mike Splane’s Home Page

Patricia Kwan’s Home Page

END