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.
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.
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 |
|
FireFox Tips
Excel Basics |
CampusLife (use this Excel file; do not print)
Ch 3, Ex
5 p. 35 |
|
2/18 |
Word Graphics |
Use drawing Toolbar |
Chapter 1
|
Drawing Fun (do not print) Ch 1, Ex 1 p. xx |
|
2/25 |
Word Formatting |
|
Chapter 2 Practice using Java Juice Instructions |
Essay (do not print) Ch 2, Ex 1 p. xx |
|
3/3 |
Excel Intro |
|
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 |
Sample Slide Show
Build a presentation - use this outline |
||
|
3/10 |
Excel Formulas |
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 |
Ch 5, Ex 2 p. 59 |
|
|
3/24 |
||||
|
3/31 |
||||
|
4/7 |
Excel Topics |
Delivery Form:
Database capabilities |
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 |
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.
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.
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!
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.