(February 2 – March 4)
INSTRUCTOR: Mike
Splane
OFFICE:
OFFICE HOURS: Tuesday and Wednesday 4:30 to 5:30
OFFICE PHONE: (408) 924-3533
EMAIL: Splane_m@cob.sjsu.edu
http://www.cob.sjsu.edu/splane_m
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 302.
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.
|
Date |
Topic |
Activity |
|
Homework |
|
2/2 |
Course
overview, Office 2007 |
Syllabus |
Chapter 2 Do Exercise 2 For Practice Exercise 3 Due 2/11 10 points |
|
|
2/4 |
Word |
|||
|
2/9 |
Excel
Introduction |
Tic Tac Toe Cashier
Report |
None |
|
|
2/11 |
Excel
Formulas |
Formula
Practice Payroll
Forecast |
Exercise 3 Due 2/16 15 points |
|
|
2/16 |
Excel
Charts |
Homework
review Build a
chart |
Exercise 2 Due 2/23 10 points |
|
|
2/18 |
Excel
Functions |
IF &
VLOOKUP Functions Steak
& Eggs |
Exercise 3 Due 2/25 10 points |
|
|
2/23 |
Excel
Multiple Worksheets |
Beverage
Inventory |
None |
|
|
2/25 |
PowerPoint |
Build a
Presentation |
Exercise 2 Due 3/2 Submit by Email 15 points |
|
|
3/2 |
Excel
Data Tools |
Data
Tools. Instructor Evaluation |
Do Exercise 1 For Practice |
|
|
3/4 |
Excel Exam |
Exam -
Open Notes |
|
|
|
Turn in printed copies of the homework assignments. Printed assignments do not have to be in color. Be sure you do your printing before class; printing is
restricted in the labs. PowerPoint Homework will be submitted by email: Splane_m@cob.sjsu.edu
or MikeSplane@Yahoo.com. |
||||
The textbook is Business Productivity Tools, Second Edition.
The publisher is Kendall Hunt. The author is Mike Splane. ISBN #
978-0-7575-5879-5.
Excel
File: www.cob.sjsu.edu/bus91l/Textbook2/BPTData.xlsx
Grading:
This is a Credit/N Credit course. There will be 5 homework assignments and an exam. The exam counts for 40 points, homework counts for 60 points. Except for the exam, I never grade in-class work. You’ll find a link to your grades here: www.cob.sjsu.edu/splane_m/index2.htm. Check your grades! The minimum passing grade is 80% on the exam plus 80% on the homework. I accept late homework up until the Sunday after the last day of class.
The course covers the Office 2007 version of Word, PowerPoint and Excel. Word instruction introduces the new Office 2007 user interface. It covers the new features, useful tricks and shortcuts. PowerPoint covers medium level skills and deals with graphics. Excel covers the basics and some advanced tasks.
If you get
lost or need help I’ll stay after class. I encourage you to get to know
your neighbor.
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).
”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.
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?”
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.
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 the Office 2007 interface.
2. Understand the new features of
Word, including shortcuts and tips.
3. Learn frequently used Excel
functions and charts.
4. Learn the basics of PowerPoint.
5. Learn basic skills needed for
class work in the business school.
6. Learn some aspects of developing
a business plan document.
7. Learn to feel comfortable using these
applications.
8. Learn how these applications are used in a
business environment.
9. 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
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
“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.”