Business 91L

Business Productivity Tools

Fall 2017

Mike Splane

Office: Business Tower 260

Phone: (408) 924-3533

FAX:  924-7793

Email: mike.splane@sjsu.edu

 

Fall 2017 Office Hours

Wed   4:30 - 5:00 in BT260

No Office Hours After November 8th

 

Link to the Bus 91L Textbook Page

Link to the BUS 91A Page

Link to Mike's Home Page

 

Free Excel Software for Students

Free Antivirus for Students

ithelpdesk@sjsu.edu or 408-924-1530

 

 

Section

Code

Days

Room / Times

Instructor

Dates

Syllabus

3

42177

Monday

305 / 1:30 - 2:45

Splane, Mike

8/28 – 11/6

Section 3

4

42178

Monday

305 / 3:00 – 4:15

Splane, Mike

8/28 – 11/6

Section 4

5

42179

Tuesday

305 / 1:30 - 2:45

Splane, Mike

8/29 – 10/31

Section 5

6

42180

Tuesday

305 / 3:00 – 4:15

Splane, Mike

8/29 – 10/31

Section 6

7

42266

Wednesday

305 / 1:30 - 2:45

Splane, Mike

8/23 – 10/25

Section 7

8

43142

Wednesday

305 / 3:00 – 4:15

Splane, Mike

8/23 – 10/25

Section 8

9

43195

Thursday

305 / 1:30 - 2:45

Splane, Mike

8/24 – 10/26

Section 9

10

43196

Thursday

305 / 3:00 – 4:15

Splane, Mike

8/24 – 10/26

Section 10

11

48737

Monday

305 / 4:30 – 5:45

Splane, Mike

8/28 – 11/6

Section 11

BUS 91A

48771

Tuesday

305 / 4:30 – 5:45

Splane, Mike

8/29 – 11/7

Section 1

 

MO

TU

WE

TH

Business 91L Schedule   Fall 2017

Meeting Dates. HW is due one week later.

In-Class Activity

Homework

8/28

8/29

8/23

8/24

Introduction

Review syllabus

Form teams

Reading:  Excel Overview 1

9/11

9/5

8/30

8/31

Excel Basics

Formulas

9/18

9/12

9/6

9/7

Budget 1

Budget 2

9/25

9/19

9/13

9/14

Team Building Project

Excel Toolkit

Reading;  Excel Overview 2

10/2

9/26

9/20

9/21

Charts 1

Charts 2

10/9

10/3

9/27

9/28

Function Basics

Data Tools

10/16

10/10

10/4

10/5

Lookup Functions

If Functions

10/23

10/17

10/11

10/12

Pivot Tables

Dashboards 1

10/30

10/24

10/18

10/19

Inventory Project

Reading:  Study Guide

Deadline to submit CFU’s.

Practice:  Sample Exam

11/6

10/31

10/25

10/26

Final Exam (Open Notes)

Make up exams 11/13, 11/16

 

Microsoft Office for PC - Resources

 

List of PC Videos

 

Convert Google Sheets to Excel and Excel to Google Sheets   3:03

 

30+ Keyboard Shortcuts   12:22 Covers both Mac and PC versions of each shortcut.

 

Insert a Screen Shot using a Word Icon    1:13

Insert a Screen Shot using a Keyboard Shortcut    2:33

 

Overview

This 13:47 video is useful for someone new to Formulas.

Introducing Formulas

This 9:59 video is a quick overview of Excel.

Brief Excel Overview

This 4:25 video teaches how to Format cells.

Special Formats (Format Cells Dialog Box)  

Wrap Text    1:00

Formula Bar    2:16

Excel Interview Questions   4:32

 

Microsoft Office for MAC - Resources

 

List of Mac Videos

 

Keyboard Shortcuts in Excel

This article explains the differences between Mac and Windows shortcuts.

https://exceljet.net/excel-shortcuts-on-the-mac

 

This page shows a list of Excel keyboard shortcuts for both Mac and PC, shown side by side.

https://exceljet.net/keyboard-shortcuts

 

Comparing Mac and PC Shortcut keys

https://www.youtube.com/watch?v=sR3-vhvKTg8

 

Basic Mac Keyboard Shortcuts

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

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

 

Commonly use shortcuts. Covers both Mac and PC versions of each shortcut.

30+ Keyboard Shortcuts   12:22

 

 

 

 

 

 

Life Skills

Presentation Skills

Learning Skills

People Skills

Communication Skills

Peer Connections provides one on one appointments for peer mentoring and tutoring. They also offer several workshops a month on academic success skills. The Writing Center offers one on one tutoring for writing, online resources, and workshops. The Communications Center has drop in and one on one appointments for oral and written communication. There are also numerous tutoring centers in the departments and colleges listed on the Tutoring Hub.

 

Educational Counseling provides one on one appointments, workshops, and online resources for academic success. The library has technology workshops. In addition, the library offers resources to support students in research, including details online to help the student define the type of resources and help they need and how to connect with a librarian. The library also has laptop and I-pad rentals, meeting rooms that can reserved for teamwork or collaboration, and online resources on referencing and literature reviews and tutorials on plagiarism. The Spartan Success Portal has a range of online, academic success modules.

 

 

END