(October 13 –
November 12)
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 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.
|
Date |
Topic |
Activity |
|
Homework |
|
10/13 |
Course
overview, Office 2007 |
|
Syllabus |
None |
|
10/15 |
Word |
Lecture/Demo
using Java Juice
|
Create a webpage Due 11/3 15 points |
|
|
10/20 |
Excel
Introduction |
Tic Tac Toe Cashier
Report |
None |
|
|
10/22 |
Excel
Formulas |
Formula
Practice Payroll
Forecast |
Sales Forecast Due 10/27 15 points |
|
|
10/27 |
Excel
Charts |
Homework
review Build a
chart |
Create 3 Charts Due 11/3 10 points |
|
|
10/29 |
PowerPoint |
Build a
Presentation |
Create a presentation Due 11/3 15 points |
|
|
11/3 |
Excel
Functions |
IF
Functions VLOOKUP
Functions Steak And
Eggs |
Delivery Form Due 11/10 15 points |
|
|
11/5 |
Excel
Data Tools |
Work with
Data Tools |
Data Reports Due 11/10 10 points |
|
|
11/10 |
Excel
Odds and Ends |
Beverage
Inventory Instructor
Evaluation |
None |
|
|
11/12 |
Excel Exam |
Exam -
Open Notes |
|
|
|
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. Students can re-do homework
assignments for better scores. You will need to download an Excel file for this course. www.cob.sjsu.edu/bus91l/Textbook2/BPTData.xls |
||||
Grading:
This is a Credit/No Credit course. There will be 6 homework assignments and an exam. The exam counts for 20 points, homework counts for 80 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.
The course covers the Office 2007 version of Word, PowerPoint and Excel. Word instruction introduces the new Office 12007 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.
All
9 chapters are available online. Follow the links in the syllabus. We will also
be using an excel file for several assignments. Download it here:
www.cob.sjsu.edu/bus91l/Textbook2/BPTData.xls
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).
”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.”