Business 91L

Business Productivity Tools

Spring 2014

Business 91-L  -  Spring 2014 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

22994

T

6:00 – 7:15 PM

Kwan, Patricia

2/11 – 4/22

Section 1

3

22996

M

1:30 – 2:45 PM

Splane, Mike

2/10 – 4/28

Section 3

4

22997

M

3:00 – 4:15 PM

Splane, Mike

2/10 – 4/28

Section 4

5

22998

T

1:30 – 2:45 PM

Splane, Mike

2/11 – 4/22

Section 5

6

22999

T

3:00 – 4:15 PM

Splane, Mike

2/11 – 4/22

Section 6

7

23001

W

1:30 – 2:45 PM

Splane, Mike

2/12 – 4/23

Section 7

8

23002

W

3:00 – 4:15 PM

Splane, Mike

2/12 – 4/23

Section 8

9

23003

TH

1:30 – 2:45 PM

Splane, Mike

2/13 – 4/24

Section 9

10

23004

TH

3:00 – 4:15 PM

Splane, Mike

2/13 – 4/24

Section 10

11

29740

T

7:30 – 8:45 PM

Kwan, Patricia

2/11 – 4/22

Section 11

Online

 

M-F

Online

Splane,Mike

3/11-5/19

Online Section

 

Assignments

Week

Exercise 1 Videos

Exercise One

Exercise Two

Exercise 2 Videos

1

 

Course Introduction

Form teams

Word Graphics

 

Page Backgrounds

Screen Shot

Table of Contents

Track Changes

2

None

Excel Basics

Excel for Office 2011

Formulas

Cell References

3

AutoFill Handle

Special Formats

Wrap Text

Formula Bar

Freeze Panes

Protection

Excel Toolkit

Function Basics

Dialog Box

AutoSum Icon

Rounding

4

None

Budget 1

Budget 2

None

5

None

Charts 1

Charts 2

Conditional Format

PowerPoint Charts

Combination Charts

 

6

IF and AND

COUNTIF

If Functions

Lookup Functions

VLOOKUP Function

7

Visible Cells

Break Even

Data Tools

Pivot Tables

Intro Pivots

Slicers

Pivot Chart 1

Pivot Chart 2

8

 

Inventory

 

Test Scores

XY Scatter Plot

9

None

PowerPoint 1

 

PowerPoint 2

 

Transitions

Embed 1

Embed 2

Slide Master

Combine Images

10

Sample Exam

Take this exam before the class.

Final Exam (Excel)

(Open Notes)

 

 

 

 

 

 

Additional Course Material

Mike Splane

FAQ.htm

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

 

Mike Splane’s Home Page

Patricia Kwan’s Home Page

END