Business 91L

Business Productivity Tools

Fall 2014

Business 91-L  -  Fall 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

42592

M

6:00 – 7:15 PM

Splane, Mike

9/8 – 11/10

Section 1

2

42593

M

7:30 – 8:45 PM

Splane, Mike

9/8 – 11/10

Section 2

3

45497

M

1:30 – 2:45 PM

Splane, Mike

9/8 – 11/10

Section 3

4

45498

M

3:00 – 4:15 PM

Splane, Mike

9/8 – 11/10

Section 4

5

45499

T

1:30 – 2:45 PM

Splane, Mike

9/9 – 11/18

Section 5

6

45500

T

3:00 – 4:15 PM

Splane, Mike

9/9 – 11/18

Section 6

7

46553

T

6:00 – 7:15 PM

Kwan, Patricia

9/9 – 11/18

Section 7

8

48923

T

7:30 – 8:45 PM

Kwan, Patricia

9/9 – 11/18

Section 8

9

49033

W

1:30 – 2:45 PM

Splane, Mike

9/10 – 11/12

Section 9

10

49036

W

3:00 – 4:15 PM

Splane, Mike

9/910– 11/12

Section 10

 

Assignments

Week

Before-Class Videos

In-Class Activities

Homework Projects

Homework Videos

1

None

Course Introduction

Form teams

Word Graphics

 

Page Backgrounds

Screen Shot

Table of Contents

Track Changes

2

None

Excel Basics

Help team mates

Discuss CFU’s

Formulas

Cell References

3

AutoFill Handle

Special Formats

Wrap Text

Formula Bar

Freeze Panes

Protection

Excel Toolkit

Help team mates

Discuss CFU’s

Budget 1

None

4

Dialog Box

AutoSum Icon

Rounding

Function Basics

Help team mates

Discuss CFU’s

Budget 2

None

5

IF and AND

COUNTIF

If Functions

Help team mates

Discuss CFU’s

Charts 1

 

None

6

VLOOKUP Function

Lookup Functions

Help team mates

Discuss CFU’s

Charts 2

 

PowerPoint Charts

Combination Charts

7

Visible Cells

Data Tools

Help team mates

Discuss CFU’s

PowerPoint 1

None

8

Intro Pivots

Slicers

Pivot Charts

Pivot Tables

Help team mates

Discuss CFU’s

PowerPoint 2

SOTES

Transitions

Embed 1

Embed 2

Slide Master

Combine Images

9

None

Macros

Help team mates

Discuss CFU’s

Dashboards

Sample Exam

SOTES

Conditional Formatting

Dashboard Formatting

Dashboard Charts

10

 

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