SYLLABUS

BUS4 91A

Advanced Business Productivity Tools

Fall 2017 

Meets August 29 to November 7

INSTRUCTOR: Mike Splane
OFFICE: Business Tower 260
OFFICE HOURS:  Wednesdays 4:30 to 5:00
OFFICE PHONE: (408) 924-3533 (voicemail)
EMAIL: 
mike.splane@sjsu.edu

Course Description

This ten-week-long course is for students wanting to become Excel professionals. After completing the course:

·         Students will be prepared to take and pass the “Microsoft Office Specialist - Excel” certification exam.

·         Students will learn how to customize Excel using behind-the-scenes features.

·         Students will learn how to use a toolkit of advanced features for power users.

·         Students will learn complex formulas and functions to accomplish tasks quickly and efficiently.

·         Students will learn how to create dashboards, graphics, and animations.

·         Students will be able to use macros to automate spreadsheet tasks.

·         Students will develop the skills to create and edit macros using VBA.

Required Texts/Readings

You do not need to buy a textbook. All the material is on the course website.  http://bus91l.altervista.org/Index3.htm 

Course Prerequisites

Students will have to demonstrate a basic understanding of Excel. Either a credit score in the Bus 91L course or passing the qualifying exam will meet this requirement.   

Classroom Protocol

You will form teams of three to four students. Your team will sit in the same seats for every class.  We will spend some time working together on a project in every class period, and on reviewing the lessons, so attendance is required.

If you run into a problem, first try to figure it out yourself as a professional would. If that fails, please ask your teammates or instructor for help. You can also try searching Google or YouTube.

Check for Understanding Forms

Students are required to complete several individual assignments and fill out a “Check for Understanding” (CFU) form for each one.  Printed CFU forms are required; I do not accept soft copies.

Instructions for completing the forms are included in each lesson.

Class Calendar

Class Date

Activity

Due Date

8/29

Introduction

Qualifying Exam

8/29

9/5

Inventory

Team-Building Project (HW)

9/12

9/19

9/12

Forms Arrays

9/19

9/19

Customizing Excel

9/26

9/26

DashBoards 2

10/3

10/3

Toolkit 2

10/10

10/10

 Macros 1 Introduction

10/17

10/17

Macros 2  Writing macros

10/24

10/24

Macros 3  Animations

10/31

10/31

MOS Certification 

11/7

11/7

Final Exam or Project

11/21

Tentative Grading Scale

            Task

% of Course Grade

Inventory Lesson

8%

Dashboards 2 Lesson

8%

Customization Lesson

8%

Certification Lesson

8%

Toolkit 2 Lesson

8%

Forms Arrays

8%

Macros 1 Lesson

8%

Macros 2 Lesson

8%

Macros 3 Lesson

8%

Team Building  Project

8%

Final Exam or Project

20%

Total

100%

Grades

·         The course is graded either “Credit” or “No Credit.”

·         Perfection is not required to get credit for the assignments and projects. All I am looking for is a reasonable “good faith” effort.  If I think you did your best, you will get credit.

·         A score of 85% or higher is required to pass.

This is the end of the information specific to this course.

The rest of the syllabus is boiler plate language that I am required to include.

University Policies

Dropping and Adding

Students are responsible for understanding the policies and procedures about add/drops, academic renewal, etc. Information on add/drops is available at http://info.sjsu.edu/web-dbgen/narr/soc-fall/rec-324.html . Information about late drop is available at http://www.sjsu.edu/sac/advising/latedrops/policy/ . Students should be aware of the current deadlines and penalties for adding and dropping classes.

Academic integrity

Students should know that the University’s Academic Integrity Policy is available at http://www.sa.sjsu.edu/download/judicial_affairs/Academic_Integrity_Policy_S07-2.pdf. Your own commitment to learning, as evidenced by your enrollment at San Jose State University and the University’s integrity policy, require you to be honest in all your academic course work. Faculty members are required to report all infractions to the office of Student Conduct and Ethical Development. The website for Student Conduct and Ethical Development is available at http://www.sa.sjsu.edu/judicial_affairs/index.html.

Instances of academic dishonesty will not be tolerated. Cheating on exams or plagiarism (presenting the work of another as your own, or the use of another person’s ideas without giving proper credit) will result in a failing grade and sanctions by the University. For this class, all assignments are to be completed by the individual student unless otherwise specified. If you would like to include in your assignment any material you have submitted, or plan to submit for another class, please note that SJSU’s Academic Policy F06-1 requires approval of instructors.

Campus Policy in Compliance with the American Disabilities Act

If you need course adaptations or accommodations because of a disability, or if you need to make special arrangements in case the building must be evacuated, please make an appointment with me as soon as possible, or see me during office hours. Presidential Directive 97-03 requires that students with disabilities requesting accommodations must register with the DRC (Disability Resource Center) to establish a record of their disability.


 

Student Technology Resources

Computer labs for student use are available in the Academic Success Center located on the 1st floor of Clark Hall and on the 2nd floor of the Student Union. Additional computer labs may be available in your department/college. Computers are also available in the Martin Luther King Library.

A wide variety of audio-visual equipment is available for student checkout from Media Services located in IRC 112. These items include digital and VHS camcorders, VHS and Beta video players, 16 mm, slide, overhead, DVD, CD, and audiotape players, sound systems, wireless microphones, projection screens and monitors.

Learning Assistance Resource Center

The Learning Assistance Resource Center (LARC) is located in Room 600 in the Student Services Center. It is designed to assist students in the development of their full academic potential and to motivate them to become self-directed learners. The center provides support services, such as skills assessment, individual or group tutorials, subject advising, learning assistance, summer academic preparation and basic skills development. The LARC website is located at http:/www.sjsu.edu/larc/.

SJSU Writing Center

The SJSU Writing Center is located in Room 126 in Clark Hall.  It is staffed by professional instructors and upper-division or graduate-level writing specialists from each of the seven SJSU colleges. Our writing specialists have met a rigorous GPA requirement, and they are well trained to assist all students at all levels within all disciplines to become better writers. The Writing Center website is located at http://www.sjsu.edu/writingcenter/about/staff//.

Peer Mentor Center

The Peer Mentor Center is located on the 1st floor of Clark Hall in the Academic Success Center. The Peer Mentor Center is staffed with Peer Mentors who excel in helping students manage university life, tackling problems that range from academic challenges to interpersonal struggles. On the road to graduation, Peer Mentors are navigators, offering “roadside assistance” to peers who feel a bit lost or simply need help mapping out the locations of campus resources. Peer Mentor services are free and available on a drop –in basis, no reservation required. The Peer Mentor Center website is located at http://www.sjsu.edu/muse/peermentor/ .

Lucas College and Graduate School of Business Program Goals

Goal One: Business Knowledge

Understand basic business principles and demonstrate discipline-specific competencies as applied to local and global environments.

Goal Two: Communication

Communicate ideas clearly, logically, and persuasively in oral and written format, using technology appropriately.

Goal Three: Ethical Awareness

Recognize, analyze, and articulate solutions to ethical issues that arise in business.

Goal Four: Leadership, Teams and Diversity

Comprehend the challenges and opportunities of leading and working in diverse teams and environments.

Goal Five: Critical Thinking

Comprehend, analyze, and critically evaluate complex and unstructured qualitative and quantitative business problems, using appropriate tools and technology.

Goal Six: Innovation

Recognize, analyze, and articulate strategies for promoting creativity and innovation.