SYLLABUS
Bus. 91L Business Productivity Tools
Summer 2008 Section 1
(June 3 – July 10)
INSTRUCTOR: Mike Splane
OFFICE:
OFFICE HOURS: Tuesday 4:30 to 5:30
OFFICE PHONE: (408) 924-3533
EMAIL: Splane_m@cob.sjsu.edu
http://www.cob.sjsu.edu/splane_m
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 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.
Textbook: The textbook is “Business Productivity Tools”, by Mike Splane, published in 2006 by Kendall Hunt. ISBN# 0-7575-3400-7 The price is ~ $18.
Challenge Exam: I will give a challenge exam on Thursday, June 5th. Students who pass the exam will not have to attend the class. There is no penalty for failing the exam. The exam is open book/open notes. Students will have 2 1/2 hours to finish the exam.
Class Calendar:
|
Date |
Topic |
Activity |
|
Homework |
|
6/3 |
Introduction Excel Intro |
Tic Tac Toe Ch 3, Ex 1: page 25 Ch 3, Ex 2: page 27 |
Syllabus Chapter 8
p. 85 |
|
|
6/5 |
PowerPoint Excel |
Challenge Exam 3:00 - 5:30 |
The Exam
covers PowerPoint and Excel |
|
|
6/10 |
Excel Intro |
Ch 3, Ex 3: page 31 |
Chapter
3 pp. 21-24 |
Ch 3, Ex
5 p. 35 Ch 3, Ex
7 p. 39 |
|
6/12 |
Word Graphics |
Build a Table. Use drawing Toolbar |
Chapter 1 pp. 1-5 |
Ch 1, Ex 1
p. 7 |
|
6/17 |
Excel Formulas |
Discuss homework Ch 4, Ex 1: page 49 |
Chapter 4 pp. 43-47 |
Ch 4, Ex
2 p. 51 |
|
6/19 |
Word Formatting |
Lecture/Demo using Java Juice |
Chapter 2 pp. 9-16 |
Ch 2, Ex
1 p. 17 |
|
6/24 |
Excel Charts |
Ch 5, Ex 1: page 57 |
Chapter 5 pp. 55-56 |
Ch 5, Ex 2 p. 59 |
|
6/26 |
PowerPoint |
Build a presentation |
Chapter 7 pp. 73-77 |
Ch 7, Ex 1 p. 79 |
|
7/1 |
Excel |
IF
Functions Worksheet Friday
Night Document |
Chapter 6 pp. 63-64 |
Ch 6, Ex
1: p 65 |
|
7/3 |
Excel |
Ch 6, Ex 2: page 69 |
||
|
7/8 |
Excel |
Excel Topic (TBA) Exam review Instructor Evaluation |
|
|
|
7/10 |
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: Splane_m@cob.sjsu.edu.
I subtract one point for each late
assignment. Keep up with the homework.
|
Homework: |
Points |
Start Date |
Due Date |
Format |
|
5 |
6/10 |
6/17 |
Hard Copy |
|
|
5 |
6/10 |
6/17 |
Hard Copy |
|
|
10 |
6/12 |
6/24 |
Hard Copy |
|
|
20 |
6/17 |
6/24 |
Hard Copy |
|
|
10 |
6/19 |
7/1 |
Hard Copy |
|
|
10 |
6/24 |
7/1 |
Hard Copy |
|
|
10 |
6/26 |
7/8 |
Email the File |
|
|
5 |
7/1 |
7/8 |
Hard Copy |
|
|
5 |
7/3 |
7/8 |
Email the file |
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 with hints and information. Be sure to check it between classes. www.cob.sjsu.edu/splane_m/index2.htm.
You’ll find a link to your grades on the 91-L
web page. Check your grades!
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).
Generic Stuff:
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.”