Home | wang_w@cob.sjsu.edu | San Jose State University  | | meeting time | instructor | textbook | Lab log in | course goals | Semester schedule | Assignment | grading | honor code

Last update: January 16, 2008

BUS 91L - Business Productivity Tools - Spring 2008

Section 9 and 11
(Feb 12 - Mar 13)

Check your grade



Time and place
TuTh
Section 9 (1:30PM - 2:45PM)
Section 11 (3:00PM - 4:15PM)
class room: BBC 301

Instructor
 Dr. Wendy Wang
Assistant Professor
Management Information Systems
Office: BT 265
Tel: (458) 924-3522(office)
E-mail: wang_w@cob.sjsu.edu (All emails to me should include your full name and the section number)
Office hours: 9:30 am - 12:30 pm (T, Th)

Textbook
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 506 by Kendall Hunt. ISBN# 0-7575-3450-7 The price is about $18.

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: Your instructor does not have access to student passwords.
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. Go to the help desk in room 304.

Course goals
This course prepares students to gain an overall understanding of Information systems and their roles in business. By the end of this class, you should be able to do the following:
  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.

Responsible conduct that will lead to success in this class

  1. 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.
  2. No food is allowed in the labs.
  3. Log off when you leave. You don’t want other people printing papers at your expense.
  4. Students are not allowed to install or use instant messaging or file sharing programs in the lab.
  5. No equipment should ever be unplugged by a student. This includes network cables.

Semester schedule (This schedule is subject to change based on class progress)
 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.

Date
Topic
 Activity Reading Assignment
2/12
Introduction
Excel Intro
 Survey
Ch 3, Ex 1: page 25
Ch 3, Ex 2: page 27		 Syllabus
Chapter 8		  
2/14
Excel Intro
 Ch 3, Ex 3: page 31 Chapter 3 Ch 3, Ex 4 p. 33
Ch 3, Ex 5 p. 35
Ch 3, Ex 6 p. 37
Ch 3, Ex 7 p. 39
2/19
Excel Formulas
Discuss homework
Ch 4, Ex 1: page 49		 Chapter 4 Ch 4, Ex 2 p. 51
2/21
Word Graphics
Build a Table
Use drawing Toolbar		 Chapter 1 Ch 1, Ex 1 p. 7
2/26
Excel Charts
Ch 5, Ex 1: page 57
Sample #1    Data		 Chapter 5 Ch 5, Ex 2 p. 59
Sample #2
2/28
Word formatting
Lecture/Demo using Java Juice Chapter 2 Ch 2, Ex 1 p. 17
3/4
Excel
IF Functions Worksheet
Friday night document 		Chapter 6 Inventory Form
Ch 6, Ex 1: p 65
3/6
PowerPoint
 Build a presentation Ch 7 Ch 7, Ex 1 p. 79
3/11
Excel
Exam review
Ch 6, Ex 2: page 69
Delivery form		 Chapter 6 Steak and Eggs
3/13
Excel Exam
Exam - Open Notes Study guide 20 points


Assignment
Homework counts for 80 points: 20 points for Word, 10 points for PowerPoint, 35 points for Excel, 10 points for Charts, and 5 points for turning in all of the homework. Be sure you do your printing before class; printing is restricted in the labs. Assignments can be submitted by email:wang_w@cob.sjsu.edu
Homework
Points
Due Date Format
Formula practice
0
None Practice only
Copying Formulas
0
None Practice only
Excel - Campus Life
5
2/19 Hard copy
Excel - Times Table
 5
2/19 Hard copy
Word - Drawing Fun
10
2/28 Hard copy
Excel - Sales Worksheet
20
2/28 Hard copy
Word - Essay 10
3/6 Hard copy
Charts Assignment 10
3/6 Hard copy
Excel - Inventory 5
3/11 Hard copy
PowerPoint
10
 3/11 Email the file
Steak and eggs
0
3/11 practice only
Bonus
5
  For turning in all homework


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

The Exam counts for 20 points. You will be given a list of 40 tasks to perform in Excel. Each task is worth ½ point. 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.

Honor code
DON’T CHEAT! You’ll need the skills you’ll learn in this course in every other course you take, as well as in your professional career. Cheating only hurts you! Cheating includes turning in another student’s file with your name on it. It also is considered cheating to turn in the same paper for two courses without instructor approval. Getting help on an exam via cell-phone, email, or from another student is cheating. If you cheat, you will not pass. A definition of plagiarism can be found on Judicial Affairs website.