Business 91L

Business Productivity Tools

Spring 2016

Business 91-L  -  Spring 2016 Schedule

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

Section

Code

Days

Times

Instructor

Dates

Syllabus

3

21766

Monday

1:30 - 2:45

Splane, Mike

2/15 -4/25

Section 3

4

21767

Monday

3:00 – 4:15

Splane, Mike

2/15 – 4/25

Section 4

5

21768

Tuesday

1:30 - 2:45

Splane, Mike

2/16 – 4/26

Section 5

6

21769

Tuesday

3:00 – 4:15

Splane, Mike

2/16 – 4/26

Section 6

7

21771

Wednesday

1:30 - 2:45

Splane, Mike

2/17 – 4/27

Section 7

8

21772

Wednesday

3:00 – 4:15

Splane, Mike

2/17 – 4/27

Section 8

9

21773

Thursday

1:30 - 2:45

Splane, Mike

2/18 – 4/28

Section 9

10

21774

Thursday

3:00 – 4:15

Splane, Mike

2/18 – 4/28

Section 10

 

Date

Pre-Class Reading

1-3 skills

In-Class Activities

1-3 skills

Homework

1-3 skills

Advanced Students

4-5 skills

2/15-18

Syllabus

Introduction

Form teams

Excel Basics

PowerPoint 1

Inventory Project

 

2/22-25

Excel Concepts 1

Team Talk Time

Formulas Handout

Formulas

PowerPoint 2

PowerPoint 2

HW Begin projects

2/29 -3/3

Presentation Skills

Excel Toolkit

 

Budget 1

 

Pivot Tables

HW - Project Work

3/7-10

Excel Concepts 2

Function Basics

 

Budget 2

Macros

HW - Project Work

3/14-17

Excel Concepts 3

If Functions

 

Charts 1

 

Dashboards

HW - Project Work

3/21-24

Excel Concepts 4

Lookup Functions

Lookup Handout

Charts 2

 

Data Tools 2

HW - Project Work

4/4-7

Learning Skills

Data Tools

Pivot Tables

 

Advanced Functions

HW - Project Work

4/11-14

 

Macros

Dashboards

Charts 3

HW - Project Work

4/18-21

Study Guide

Inventory Project

Survey Forms

Sample Exam

 (Not graded)

MOS prep

HW - Project Work

4/25-28

 

Final Exam (Excel)

(Open Notes)

 

Project presentations

 

 

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

 

 

Mike Splane’s Home Page

END