Business 91A

Advanced Business Productivity Tools

Fall 2018

Mike Splane

Office: Business Tower 260

Phone: (408) 924-3533

FAX:  924-7793

Email: mike.splane@sjsu.edu

 

Fall 2018 Office Hours

Monday   4:30 - 5:00 in BBC305

Tuesday   4:30 - 5:00 in BT260

No Office Hours after November 5th

 

Link to the Bus 91L Textbook Page

Link to the BUS 91L Page

Link to Mike's Home Page

Free Excel Software for students

BUS 91A Syllabus

Information About Business 91A

You don’t need a textbook for this course.

All of the course material is online.

The exercises are all designed for the PC version of Excel, not for the MAC version or for Google Sheets.

 

Section

Code

Day

Room / Times

Instructor

Dates

1

45660

Monday

305 / 4:30 – 5:45

Splane, Mike

1/24 – 4/18

If you have not taken the Bus 91L course, please take this Basic Excel Skills exam before coming to the first day of class. http://bus91L.altervista.org/Assignments/SampleExam.htm

If you don’t understand everything in the exam, work through these assignments to fill in any gaps in your knowledge. http://bus91l.altervista.org/Ideas/91A_Prereqs.htm

 

Online Course Evaluations need to be completed during the week of 10/28 to 11/4. These are accessed through MySJSU.

 

Class Date

Assignments

Due Date

8/27

Introductions and Course Review

Inventory  (In class work – can be finished at home)

9/10

9/10

Forms Arrays

9/17

9/10

Form Teams

Team-Building Project

9/24

9/17

Customizing Excel

9/24

9/24

DashBoards 2

10/01

10/01

Toolkit 2

10/08

10/08

 Macros 1 Introduction

10/15

10/15

Macros 2  Writing macros

10/22

10/22

Macros 3  Animations

10/29

10/25

Course Evaluations through MySJSU

11/4

10/29

MOS Certification 

11/5

11/5

Attendance required  

Review of Poker Project status

11/5

 

Class Date

 Team Projects

Due Date

9/10

Form Teams

Team-Building Project

9/24

9/24

Poker Project  Part 1

10/08

10/08

Poker Project  Part 2

10/22

10/22

Poker Project  Part 3

10/29

10/29

Poker Project  Part 4

11/19

 

Additional Course Material

Mike Splane’s Home Page

Office 2013 Videos

 

Assignments Worksheet 2013Data.xlsx

 

Exam Help Study Guide

Exam Help Sample Exam

 

Assignments Worksheet 96XData.xlsx

 

Video     Time = 3:03

Convert Google Sheets to Excel and Excel to Google Sheets

 

Microsoft Office for MAC - Resources

 

A 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

 

Life Skills

Presentation Skills

Learning Skills

People Skills

Communication Skills

 

 

END