Business 91A

Advanced Business Productivity Tools

Spring 2018

Mike Splane

Office: Business Tower 260

Phone: (408) 924-3533

FAX:  924-7793

Email: mike.splane@sjsu.edu

 

Spring 2018 Office Hours

Wednesday   4:30 - 5:00 in BBC305

No Office Hours after April 18th

 

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.

 

Section

Code

Day

Room / Times

Instructor

Dates

1

27941

Wednesday

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

 

 

Class Date

Activity

Due Date

1/24

Inventory

Team-Building Project (HW)

1/24

2/7

1/31

Forms Arrays

2/7

2/7

Customizing Excel

2/14

2/14

DashBoards 2

2/21

2/21

Toolkit 2

2/28

2/28

 Macros 1 Introduction

3/7

3/7

Macros 2  Writing macros

3/14

3/14

Macros 3  Animations

3/21

3/21

MOS Certification 

4/11

4/4

Poker Project 

4/18

4/11

Continue Poker Project work

 

4/18

Present projects.

 

 

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