SYLLABUS

Bus. 91L Business Productivity Tools
Spring 2008 Section 2

BBC 301; February 11 – April 21, 2008
http://www.cob.sjsu.edu/kwan_p

If you are using MicroSoft Office 2007, delay taking this course until the Summer semester.

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

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 304.

   Printing:  Printing in the lab costs 10 cents per page. You start with a $5.00 credit.
                  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.

   The 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:    

·        The lab is a shared environment. Please do your part to keep it clean and neat. If you packed it in, pack it out. Put the chairs back under the desk.

·        No food is allowed in the labs. Instructors are allowed to drink water.

·        Log off when you leave. You don’t want other people printing papers at your expense.

·        Students are not allowed to install or use instant messaging or file sharing programs in the lab.

·        No equipment should ever be unplugged by a student. This includes network cables.

 

 

Blackboard: Assignments and exams will be submitted via Blackboard. Follow this link if you need instructions on using Blackboard

To log on:     Username is the same as your 9-digit User ID at SJSU (example: 001234567).

                     Password is spring. After you log on for the first time you should change your password.

 

___________________________________________________________________________________________________ 

Course Description:

The course covers Internet Explorer, Word, Excel and PowerPoint. Word instruction covers advanced features with many shortcuts. Excel and PowerPoint cover the basics. You’ll learn to make presentations that stand out visually, and you’ll learn to save time and work more efficiently.

 

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. A recommended (but not required) textbook is “Business Productivity Tools”, by Mike Splane, published in 2006 by Kendall Hunt. ISBN# 0-7575-3400-7 The price is ~$18.

 

LEARNING OBJECTIVES:

1. Learn frequently used and advanced functions of 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.

 

Class Calendar:

 

Date

Topic

Activity

Reading

    Start Homework

2/11

Introduction

 

Excel Intro

Survey

 

Excel (1)

Internet Explorer Tips

FireFox Tips

Excel Basics
Ch 3, Ex 1: page 25

CampusLife (use this Excel file; do not print)

Ch 3, Ex 5 p. 35

2/18

Word    Graphics 

Word (1)

Use drawing Toolbar

Chapter 1

 

Drawing Fun (do not print)

Ch 1, Ex 1 p. xx

2/25

Word

Formatting

Word (2)

 

Chapter 2

 Practice using Java Juice Instructions

Essay (do not print)

Ch 2, Ex 1 p. xx

3/3

Excel Intro

Excel (1) - contd.

Formula Practice

 

Excel Formulas

Keyboard Shortcuts for Excel
 

 

Ch 3, Ex 2: page 27

Creating a Multiplication Table (ignore steps 18, 19; do not print)

Ch 3, Ex 7 p. 39

3/8 (Sat.)

PowerPoint

Quick Introduction to PowerPoint

PowerPoint Notes

PowerPoint Tips

Sample Slide Show

 

Build a presentation - use this outline

PowerPoint Assignment

3/10

Excel Formulas

Excel (2)
Mail Merge; mailing list

Ch 3, Ex 3: page 31 

Excel Formulas (continued)

 

Sales Forecast (do not print)

Ch 4, Ex 2 p. 51

3/17

Excel Charts

Discuss homework
Excel (3): Charts using data
   
(See also: Ch 5, Ex 1: page 57 Sample #1)

Charts and Graphs

Charts

Ch 5, Ex 2 p. 59

Sample #2
 

How To Select Data for Charts

3/24

Srping Break - No class

3/31

Cesar Chavez Day - Campus Closed -- No class

4/7

Excel Topics

Delivery Form: Database capabilities
     (
See also: Excel (4): Database capabilities;
     Ch 6,Ex 2: page 69)

Database Tools

Steak & Egg (use this form; do not print)

4/14

Excel

Instructor Evaluation

 

HW and Exam review

IF Functions Worksheet

   

4/21

Excel Exam

Exam  -  Open Notes

Study Guide

25 points.

Homework counts for 75 points: 20 points for Word, 10 points for PowerPoint, 35 points for Excel, and 10 points for charts. Assignments can be submitted early, and will be accepted via Blackboard.
 

Homework:

Points

Start Date

Due Date

Format

CampusLife (Ex. 5) -- use this Excel file; do not print

5

2/11

2/18

Submit via Blackboard

Word - Drawing Fun (Ex. 1) -- do not print  

10

2/18

2/25

Submit via Blackboard

Word - Essay (Ex. 1) -- do not print

10

2/25

3/3

Submit via Blackboard

PowerPoint Assignment  -- do not print

10

3/8

3/17

Submit via Blackboard

Excel - Multiplication Table  (Ex. 7) -- ignore steps 18, 19 

5

3/10

3/17

Submit via Blackboard

Excel - Sales Forecast (Ex. 2) --do not print

15

3/17

3/31

Submit via Blackboard

Excel - Charts (Ex. 2) -- do not print

10

3/31

4/14

Submit via Blackboard

Excel Steak & Egg -- use this form; do not print

10

4/7

4/21

Submit via Blackboard

Grading:

This is a Credit/No Credit course. There will be 8 homework assignments and an exam. You can earn up to 100 points; 80 points or more is a passing grade. You have to score at least 16 points on the Exam to pass the course.

You’ll find your grades in Blackboard. Check your grades!

The Exam counts for 25 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.

In Class Hands-on exercises:

The hands-on demonstrations will have you prepare different sections of a typical business plan for a small business.  These are not graded, they are for practice. 

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 to ask.

Some good questions are: “Can you repeat that?”, “How do I do…?”, “Can you show me that again?”, “Wait, I didn’t see how you did …?”, “What keys do I use to do…?” “Can you slow down?”, “Wait, I missed that….” and “Can you speak louder?”   

 

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!

Class Behavior:

I come to the classroom early to set up. I want to start promptly. Please help me by showing up on time. It makes it easier for me if you save any questions for the break or for after class, but it’s ok to ask me questions before class. I’ll stay as late as you need.

Using a cell phone in class is bad manners. Please turn them off while you are in class.

Note: in the event of a fire alarm drill, please take your belongings and exit the building. Please return to the classroom after the all-clear is given. This is a short class, and we can’t afford to lose a whole day of instruction.

Pay attention in class: Please do not surf the web, play games, do homework from other classes, send IMs, or answer email. If you already know the material being covered, please read the handouts, or explore some of the other resources on the 91L page. The students sitting next to you may be struggling. See if they need help.

Getting Help:

If you get lost or need help I’ll stay after class. I encourage you to get to know your neighbor. If you are falling behind and you notice that your neighbor is bored or surfing the web, go ahead and quietly ask him/her for help.

If you have to miss a class, check the website. All of the class material (assignments and reading) is available there.

The 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, College, or Department Policy Information:


a) Academic integrity statement (from Office of Judicial Affairs):

“Your own commitment to learning, as evidenced by your enrollment at

San José State University and the University’s Academic Integrity

Policy requires you to be honest in all your academic course work.

Faculty are required to report all infractions to the Office of Judicial Affairs.
The policy on academic integrity can be found at
http://www2.sjsu.edu/senate/S04-12.pdf


b) Campus policy in compliance with the Americans with Disabilities Act:

“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.”

 

c) College of Business Policies and Procedures:

 

Academic Honesty:

Faculty will make every reasonable effort to foster honest academic conduct in their courses.  They will secure examinations and their answers so that students cannot have prior access to them and proctor examinations to prevent students from copying or exchanging information.  They will be on the alert for plagiarism.  Faculty will provide additional information, ideally on the green sheet, about other unacceptable procedures in class work and examinations.  Students who are caught cheating will be reported to the Judicial Affairs Officer of the University, as prescribed by Academic Senate Policy S04-12. 

 

Mission

The College of Business is the institution of opportunity, providing innovative business education and applied research for the Silicon Valley region.