SYLLABUS
Bus-91L Business Productivity Tools
Fall 2007, Sections 3 and 4
September 13 – November 15, 2007
INSTRUCTOR: Usha Andra
OFFICE:
OFFICE HOURS: Thursday 5:30pm-6:00pm and 8:45pm-9:15pm
OFFICE PHONE: (408) 924-3533
EMAIL: andra_u@cob.sjsu.edu
http://www.cob.sjsu.edu/andra_u
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.
Go to the help desk in room
304.
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.
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.
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.
Course Description:
The course covers Internet Explorer, Word, PowerPoint and Excel. Word instruction covers advanced features with lots of tricks and 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.
The textbook is “Business Productivity Tools”, by Mike Splane, published in 2006 by Kendall Hunt. ISBN# 0-7575-3400-7. The price is ~ $18.
Class Calendar:
|
Date |
Topic |
Activity |
|
Homework |
|
9/13 |
Introduction Excel Intro |
Tic Tac Toe Ch 3, Ex 1: page 25 Ch 3, Ex 2: page 27 |
Syllabus Chapter 8 |
|
|
9/20 |
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 |
|
9/27 |
Excel Formulas |
Discuss homework Ch 4, Ex 1: page 49 |
Chapter 4 |
|
|
10/4 |
Word Graphics |
Build a Table. Use drawing Toolbar |
Chapter 1 |
|
|
10/11 |
Excel Charts |
Ch 5, Ex 1: page 57 |
Chapter 5 |
|
|
10/18 |
Word Formatting |
Lecture/Demo using Java
Juice |
Chapter
2 |
|
|
10/25 |
Excel |
IF Functions
Worksheet Friday Night
Document |
Chapter 6 |
Ch 6, Ex 1: p 65 |
|
11/1 |
PowerPoint |
Build a presentation |
Chapter
7 |
|
|
11/8 |
Excel |
Exam review Ch 6, Ex 2: page 69 |
Chapter 6 |
|
|
11/15 |
Excel Exam |
Exam - Open Notes |
20 points. |
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: andra_u@cob.sjsu.edu.
Carrot and Stick: To encourage students to
do the homework, I award 5 bonus points for completing all of the assignments.
I also subtract one point for each late assignment. Keep up with the homework.
|
Homework: |
Points |
Start Date |
Due Date |
Format |
|
0 |
9/20 |
None |
For Practice Only |
|
|
0 |
9/20 |
None |
For Practice Only |
|
|
5 |
9/20 |
9/27 |
Hard Copy |
|
|
5 |
9/20 |
9/27 |
Hard Copy |
|
|
20 |
9/27 |
10/4 |
Hard Copy |
|
|
10 |
10/4 |
10/11 |
Hard Copy |
|
|
10 |
10/11 |
10/18 |
Hard Copy |
|
|
10 |
10/18 |
10/25 |
Hard Copy |
|
|
5 |
10/25 |
11/1 |
Hard Copy |
|
|
10 |
11/1 |
11/8 |
Email the File |
|
|
5 |
11/8 |
11/15 |
Hard Copy |
|
|
Homework Bonus |
5 |
For turning in
all graded assignments. |
||
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.
Extra Credit: I don’t give extra credit. Instead,
I allow students to fix and re-submit assignments if they are not happy with
their score.
Un-graded Assignments: Except for the exam, I never
grade in-class work. We will work through several exercises together.
There are three un-graded practice assignments to do at home.
The Website:
I frequently update my website. Grades are also posted on the
website. Be sure to check it between classes. www.cob.sjsu.edu/andra_u/index.htm.
Bad
questions are questions about a different application in the middle of a
lecture or demonstration, or questions about paperwork or other administrative
issues. Save those for a break.
I notice on the evaluations that I tend to go a bit too fast
for some students. 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: If you already know the
material being covered, please read the handouts, explore some of the other
resources on the 91L page, or read the instructor’s homepage. The student
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 bored or surfing the web, go ahead and quietly ask
them for help.
If you have to miss a class, check
the website. All of the class material (assignments and reading) is
available there. If I teach another section later in the week that covers the
same material, it’s ok to attend it (space permitting).
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 see me as soon as
possible.
Formal 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.
Please
read the UNIVERSITY POLICY ON ACADEMIC
DISHONESTY
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.
Plagiarism
Self-Testing Tutorial - Learn what is ok and what is not ok. http://education.indiana.edu/~frick/plagiarism/item1.html
College
of Business Policies and Procedures
“Your
own commitment to learning, as evidenced by your enrollment at
“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.”