SYLLABUS

Bus. 91L Business Productivity Tools
Spring 2012 Section 2 (Class No. 24746)

BBC 301; 7:30PM - 8:45PM; February 6  -  April 16, 2012
http://www.cob.sjsu.edu/kwan_p

INSTRUCTOR: Patricia I. Kwan
OFFICE: Business Tower 260   
OFFICE HOURS:  Mondays, 8:45 to 9:30PM
EMAIL: Patricia.Kwan@sjsu.edu
OFFICE PHONE: (408) 924-3533


Course Description:

The course covers Word, Excel and PowerPoint applications using Office 2007. At the end of the course you should be confident and comfortable when using these applications. You will learn advanced formatting techniques in Word to quickly make your work look distinctive and professional, and basic to intermediate skills in Excel and PowerPoint. Course assignments (courtesy of Mr. Mike Splane) are based on a fictional cafe, Java Juice. These assignments are designed to help you understand how Office applications are used in a business environment.

 

Course Methodology:
This course uses a hands-on approach to learning Microsoft Office applications. Students will use a combination of homework, reading, in-class activities, demonstrations and lectures to learn practical skills. The recommended (but not required) text is
Business Productivity Tools, Second Edition. The publisher is Kendall Hunt. The author is Mike Splane. ISBN # 978-0-7575-5879-5.

FORMAL LEARNING OBJECTIVES:

1. Learn the Office 2007 interface.

2. Understand the key features in Word, including shortcuts and tips.
2. Learn frequently used Excel functions and charts.
3. Learn the basics of PowerPoint.
4. Learn basic skills needed for class work in the business school.

5. Learn some aspects of developing a business plan document.

6. Learn to feel comfortable using these applications.

7. Learn how these applications are used in a business environment.

8. Make your work more visually exciting.


D2L Instructions:

   URL: Desire2Learn Login Page
   Important Instructions to be read before using Desire2Learn: Desire2Learn Instructions for students.pdf

   NOTE: Change email address to re-route messages to your normal email address

The Computer Lab:

   To log on:

            Domain is LAB

Username is your student ID Number: 9 digits starting with a zero.

            Password for first time users is the last two letters of your last name followed by the last 4 digits of your student ID.
                           After you log on for the first time you have to change your password.

            Password trouble: Go to the help desk in room 302. Your instructor does not have access to reset student passwords.
 

   Printing: I don't require you to print anything, but you start with a $5.00 credit for this course.

                  Printing in the lab costs 10 cents per page.
                  If you run out of funds on your account you can not print. Money can be added to your account at the help desk
                  in room BBC 302. You have to set up a printer before you can print. See the instructions posted on the front and
                  back walls of the lab.
 

   Projection Screen: Warning: The display screen is hard to see from the two back rows.
                      To get a better view, sit in one of the first four rows. Students should never be seated in the back row,
                      if space is available up front.
 

   Behavior:

Class Calendar [Subject to Change. Check back here often]: 

Date

Topic

Activity

Reading

    Start Homework

2/6

Course Overview

Office 2007

Survey  (No grade points)

 

Word 2007;

PowerPoint 2007;

Excel 2007

None

2/13

Word

Using Word 2007

Word 2007 Quick Reference;

Word 2007 Keyboard Shortcuts

Essay

(Do Not Print)

Due 2/20

2/20

PowerPoint

Using PowerPoint 2007

PowerPoint 2007 - Get up to speed;

Tips # 1; Tips #2; Sample #1

PowerPoint 2007 Keyboard Shortcuts

Create a presentation

Due 2/27

2/27

Excel Introduction

Introduction to Excel 2007
using Cashier's Report

Up to speed with Excel 2007

None

3/5

Excel Formulas

Writing Simple Formulas

 

Excel shortcut and function keys;
Get to know Excel 2007: Enter formulas

Create Sales Forecast
(Do Not Print)

Due 3/12

3/12

Excel Charts

Only 4-clicks to Create a Chart

Create Charts in Excel 2007;
Excel 2007 Column Chart Tutorial;
Excel 2007 Line Graph Tutorial;
Excel 2007 Pie Chart Tutorial

Create 3 Charts

(Do Not Print)

Due 3/19
To select data for charts

3/19

Excel Functions

If, Data Validation,  VLookUp
(using Select-Function example)

Selection Functions: COUNTIFS, VLOOKUP (video)

Create Delivery Form

(Do Not Print)
Due 4/2

4/2

Excel Data Tools

Work with Data Tools - Sorting, Filtering
(See
DataSet sheet)

Overview of Excel tables;
Pivot Tables

Create Data Reports
(Do Not Print; submit one file)

Due 4/9

4/9

Excel Odds and Ends

Instructor Evaluation
Review for Exam

Demo on Excel 2007 macros

None

4/16

Excel Exam

Exam  -  Open Notes

 

30 points.

Homework counts for 70 points: 10 points for Word, 10 points for PowerPoint, 50 points for Excel. Assignments can be submitted early, and are accepted via D2L.
 

Homework:

Points

Due Date

Submission

Essay

10

2/20

via D2L

Create a presentation

10

2/27

via D2L

Create Sales Forecast

15

3/12

via D2L

Create 3 Charts

10

3/19

via D2L

Create Delivery Form

15

4/2

via D2L

Create Data Reports

10

4/9

via D2L

Grading: This is a Credit/No Credit course. There are 6 homework assignments and an exam. You can earn up to 100 points; 80 points or more is a passing grade. NOTE: You have to score at least 24 points on the Exam to pass the course.

The Exam counts for 30 points. Notes and handouts may be used for the exam. Bring a picture ID to the exam. Getting help from neighbors, IMing, text messaging, or using a cell phone during an exam is NOT OK!  I do not give make-up exams without prior arrangement.

Extra Credit is possible. If you give me a good shortcut or tip that I don’t already know I’ll give you a point. These extra points can be applied to your homework points, but not the exam.

Ask Questions: There are NO BAD or STUPID QUESTIONS as long as they are on topic. Your questions help other students and show me where I need to improve my teaching. Also, it is very likely someone else has the same questions but may not feel comfortable asking.

If you start to get lost, you need to say something. I allow extra time for questions and interruptions. The goal is for you to learn, not for me to talk. ASK QUESTIONS!

Getting Help: If you get lost or need help I’ll stay after class. I also encourage you to get to know your neighbor and see if s/he can help you.

If you have to miss a class, let me know in advance via email, and check the website. All of the class material (assignments and reading) is available here.

This Website: I may update this syllabus page. Be sure to check it between classes.


Standard disclaimers: The student is responsible for adhering to the add/drop policy of the course as well as all University and College rules for academic behavior and conduct. Students are encouraged to talk, consult, work and learn together on their assignments and projects. If you need course adaptations or accommodations because of a disability, or if you have emergency medical information to share with me, or if you need 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.


University Policies

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 for purchase from the Spartan Bookstore, and is also 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.

College of Business Policies and Procedures

“Your own commitment to learning, as evidenced by your enrollment at San Jose State University, and the University’s Academic Integrity Policy requires 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 policy on academic integrity can be found at www.sjsu.edu/president/docs/directives/PD_2007-04.pdf

“If you need course adaptations or accommodations because of a disability, or if you need 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 register with DRC to establish a record of their disability.