Business 91L

Business Productivity Tools

Fall 2015

Challenge Exam Information:http://www.cob.sjsu.edu/splane_m/IndexA.htm

Fall 2015 Calendar

Week

Pre-Class Reading

In-Class Activities

Homework

1

Syllabus

Introduction

Form teams

Excel Basics

PowerPoint 1

2

Excel Concepts 1

Team Talk Time

Formulas Handout

Formulas

PowerPoint 2

3

Presentation Skills

Excel Toolkit

 

Budget 1

 

4

Excel Concepts 2

Function Basics

 

Budget 2

5

Excel Concepts 3

If Functions

 

Charts 1

 

6

Excel Concepts 4

Lookup Functions

Lookup Handout

Charts 2

 

7

Learning Skills

Data Tools

Pivot Tables

 

8

 

Macros

Dashboards

9

Inventory Project

Sample Exam

10

 

Final Exam (Excel)

(Open Notes)

 

 

Additional Course Material

Mike Splane

MAC/Office 2011 help

Office for Mac Keyboard Shortcuts - Excel

https://www.youtube.com/watch?v=60tEVwXiTEs

25 Basic Mac Keyboard Shortcuts

https://www.youtube.com/watch?v=AdMuZses96Q

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  -  Fall 2015 Schedule

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

Section

Code

Days

Times

Instructor

Dates

Syllabus

1

41792

Tuesday

6:00 PM – 7:15 PM

Kwan, Patricia

9/8 – 11/10

 

2

41793

Tuesday

7:30 PM – 8:45 PM

Kwan, Patricia

9/8 – 11/10

 

3

43263

Monday

1:30 - 2:45

Splane, Mike

9/14 – 11/16

Section 3

4

43264

Monday

3:00 – 4:15

Splane, Mike

9/14 – 11/16

Section 4

5

43265

Tuesday

1:30 - 2:45

Splane, Mike

9/8 – 11/10

Section 5

6

43266

Tuesday

3:00 – 4:15

Splane, Mike

9/8 – 11/10

Section 6

7

43459

Wednesday

1:30 - 2:45

Splane, Mike

9/9 – 11/18

Section 7

8

45201

Wednesday

3:00 – 4:15

Splane, Mike

9/9 – 11/18

Section 8

9

45306

Thursday

1:30 - 2:45

Splane, Mike

9/10 – 11/12

Section 9

10

45309

Thursday

3:00 – 4:15

Splane, Mike

9/10 – 11/12

Section 10

 

Mike Splane’s Home Page

Patricia Kwan’s Home Page

END