SYLLABUS
Bus. 91L Business Productivity Tools
Spring 2012 Section 2 (Class No. 24746)
BBC 301; 7:30PM - 8:45PM; February 6 - April 16, 2012
http://www.cob.sjsu.edu/kwan_p
INSTRUCTOR: Patricia
I. Kwan
OFFICE: Business Tower 260
OFFICE
HOURS:
Mondays, 8:45 to 9:30PM
EMAIL: Patricia.Kwan@sjsu.edu
OFFICE PHONE: (408)
924-3533
Course Description:
The course covers Word, Excel and PowerPoint
applications using
Office 2007.
At the end of the course you should be confident and
comfortable when using these applications. You will learn advanced formatting
techniques in Word to quickly make your work look distinctive and professional,
and basic to intermediate skills in Excel and PowerPoint. Course assignments
(courtesy of Mr. Mike Splane) are based on a fictional
cafe, Java Juice. These assignments are designed to help you understand how
Office applications are used in a business environment.
Course Methodology:
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. The recommended (but not required) text is
Business Productivity Tools, Second Edition.
The publisher is
Kendall Hunt. The author is Mike Splane. ISBN #
978-0-7575-5879-5.
FORMAL LEARNING OBJECTIVES:
1. Learn the Office 2007 interface.
2. Understand
the key features in 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.
URL:
Desire2Learn Login Page
Important Instructions to be read before using Desire2Learn:
Desire2Learn Instructions
for students.pdf
NOTE: Change email address to re-route messages to your normal email address
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 302.
Your instructor does not have access to reset student passwords.
Printing: I don't require you to print anything, but you start with a $5.00 credit for this course.
Printing in the lab costs 10 cents per page.
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.
Projection 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:
I come to the classroom early to set up. I want to start promptly. Please help me by showing up on time.
Please turn off or set to silent your cell phone while you are in class.
The lab is a shared environment. Please do your part to keep it clean and neat.
No food is allowed in the labs.
Log off when you leave. You don’t want other people printing papers at your expense.
You 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.
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 ahead, or explore other resources on the subject matter,
or help others sitting next to you who may be struggling.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.
Class Calendar [Subject to Change. Check back here often]:
|
Date |
Topic |
Activity |
Reading |
Start Homework |
|
2/6 |
Course Overview Office 2007 |
Survey (No grade points)
|
None |
|
|
2/13 |
Word |
(Do Not Print) Due 2/20 |
||
|
2/20 |
PowerPoint |
Due 2/27 |
||
|
2/27 |
Excel Introduction |
None |
||
|
3/5 |
Excel Formulas |
|
Excel shortcut and function keys;
|
Create Sales Forecast
Due 3/12 |
|
3/12 |
Excel Charts |
Create Charts in Excel 2007; Excel 2007 Column Chart Tutorial; Excel 2007 Line Graph Tutorial; Excel 2007 Pie Chart Tutorial |
(Do Not Print)
Due 3/19 |
|
|
3/19 |
Excel Functions |
If, Data
Validation, VLookUp |
Selection Functions: COUNTIFS, VLOOKUP (video) |
(Do Not Print) |
|
4/2 |
Excel Data Tools |
Work with Data Tools - Sorting, Filtering |
Create Data Reports Due 4/9 |
|
|
4/9 |
Excel Odds and Ends |
Instructor Evaluation |
None |
|
|
4/16 |
Excel Exam |
Exam - Open Notes |
|
30 points. |
Homework
counts for 70 points: 10 points for Word, 10 points for PowerPoint, 50 points for Excel.
Assignments
can be submitted early, and are accepted via
D2L.
|
Homework: |
Points |
Due Date |
Submission |
|
10 |
2/20 |
via D2L |
|
|
10 |
2/27 |
via D2L |
|
|
15 |
3/12 |
via D2L |
|
|
10 |
3/19 |
via D2L |
|
|
15 |
4/2 |
via D2L |
|
|
10 |
4/9 |
via D2L |
Grading: This is a Credit/No Credit course. There are 6 homework assignments and an exam. You can earn up to 100 points; 80 points or more is a passing grade. NOTE: You have to score at least 24 points on the Exam to pass the course.
The Exam counts for 30 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. These extra points can be applied to your homework points, but not the exam.
Ask Questions: 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. Also, it is very likely someone else has the same questions but may not feel comfortable asking.
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!
Getting Help: If you get lost or need help I’ll stay after class. I also encourage you to get to know your neighbor and see if s/he can help you.
If you have to miss a class, let me know in advance via email, and check the website. All of the class material (assignments and reading) is available here.
This 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 Policies
Students should know that the University’s Academic Integrity Policy is available at http://www.sa.sjsu.edu/download/judicial_affairs/Academic_Integrity_Policy_S07-2.pdf. Your own commitment to learning, as evidenced by your enrollment at San Jose State University and the University’s integrity policy, require you to be honest in all your academic course work. Faculty members are required to report all infractions to the office of Student Conduct and Ethical Development. The website for Student Conduct and Ethical Development is available for purchase from the Spartan Bookstore, and is also available at http://www.sa.sjsu.edu/judicial_affairs/index.html.
Instances of academic dishonesty will not be tolerated. Cheating on exams or plagiarism (presenting the work of another as your own, or the use of another person’s ideas without giving proper credit) will result in a failing grade and sanctions by the University. For this class, all assignments are to be completed by the individual student unless otherwise specified. If you would like to include in your assignment any material you have submitted, or plan to submit for another class, please note that SJSU’s Academic Policy F06-1 requires approval of instructors.
If you need course adaptations or accommodations because of a disability, or if you need to make 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 requesting accommodations must register with the DRC (Disability Resource Center) to establish a record of their disability.
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.