SYLLABUS
Bus. 91L Business Productivity Tools
Spring 2007 Sections 11 and 12
(Feb 15 – April 26)
http://www.cob.sjsu.edu/andra_u
INSTRUCTOR:
OFFICE:
OFFICE HOURS: Thursday 5:30pm to 6:00pm and 8:45pm to 9:15pm
OFFICE PHONE: (408) 924-3533
EMAIL: Andra_u@cob.sjsu.edu
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.
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 textbook is “Business Productivity Tools”, by Mike Splane, published in 2006 by Kendall Hunt. ISBN# 0-7575-3400-7 The price is ~ $17.
The course assumes you know how to operate a computer and do basic tasks in Word; some links to tutorials are provided. You can not learn applications without practice, so expect to spend two hours or more each week on homework. You’ll need to keep up with the homework to do well in the class.
Class Calendar:
|
Date |
Topic |
Activity |
|
Start Homework |
|
2/15 |
Introduction
Excel Intro |
Tic Tac Toe Ch 3, Ex 1: page 25 Ch 3, Ex 2: page 27 |
Syllabus Chapter 8
|
|
|
2/22 |
Word Graphics |
Build a Table. Use drawing Toolbar |
Chapter 1
|
Ch 1, Ex 1 p. 7 |
|
3/1 |
Word Formatting |
Lecture/Demo using Java Juice |
Chapter 2
|
Ch 2, Ex 1 p. 17
|
|
3/8 |
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 |
|
3/15 |
Excel Formulas |
Discuss homework Ch 4, Ex 1: page 49 |
Chapter 4
|
Ch 4, Ex 2 p. 51 |
|
3/22 |
Excel Charts |
Ch 5, Ex 1: page 57 |
Chapter 5 |
Ch 5, Ex 2 p. 59 |
|
4/5 |
Excel Topics |
Ch 6, Ex 2: page 69 |
Chapter 6 |
Ch 6, Ex 1: p 65 |
|
4/12 |
PowerPoint |
Build a presentation |
Chapter 7 |
Ch 7, Ex 1 p. 79 |
|
4/19 |
Excel |
HW and Exam review IF Functions Worksheet Saturday Night Document |
|
|
|
4/26 |
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 bonus points for completing all of the assignments. I will accept homework assignments up to the Sunday following the end of the class. Keep a copy of each assignment; in case I have problems with your files. Be sure you do your printing before class. Printing is restricted in the labs.
|
Homework: |
Points |
Start Date |
Due Date |
Format |
|
10 |
2/22 |
3/1 |
Hard Copy |
|
|
10 |
3/1 |
3/8 |
Hard Copy |
|
|
5 |
3/8 |
3/15 |
Hard Copy |
|
|
5 |
3/8 |
3/15 |
Hard Copy |
|
|
20 |
3/15 |
3/22 |
Hard Copy |
|
|
10 |
3/22 |
4/5 |
Hard Copy |
|
|
5 |
4/5 |
4/12 |
Hard Copy |
|
|
10 |
4/12 |
4/19 |
Email the File |
|
|
Homework Bonus |
5 |
For turning in all 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 15 points on the Excel exam to pass the course.
You’ll find a link to your grades on the 91-L web page. Check your grades!
The Exam counts for 20 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: I don't give extra credit. Instead, I allow students to fix and re-submit assignments if they are not happy with their score. The proctor for the Instructor Evaluation gets a point.
The hands-on demonstrations will have you prepare different sections of a typical business plan for a small business. These are not graded, they are for practice.
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: Please 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 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 make an appointment with me as soon as possible or see me during office hours.
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.”