|
CIS 151 |
Excel for Information Technology |
Fall 2008 |
|
Ticket #: 44968 |
Room BE12 |
Time:
Tues./Thurs. 12:30 |
|
Instructor: Susan Fuschetto Office Hours: Tuesdays 3:30 - 4:30 PM, Wednesdays 6:00 - 7:00 PM, and Fridays 12:00 - 1:00 PM Web Page Address:
www.cerritos.edu/sfuschetto |
Phone: (562) 860-2451, 2781 Office: SS24 Email:
sfuschetto@cerritos.edu |
|
|
|
||
|
Textbook:
the exploring series: Microsoft Office, Excel 2007, Comprehensive By: Grauer, Mulbery, and Scheeren ISBN: 978-0-13-157465-6 or 0-13-157465-5 Other Materials: 1 USB Flash Drive for saving your lab assignment files |
|
Student Learning Outcome:
|
|
GRADE POINTS REQUIRED: |
|
|
11 assignments (11 at 20 points each)
Tests (3 at 50 points each)
Final Exam (comprehensive) |
220
150
50
Total:
420 |
|
POINTS REQUIRED |
GRADE EARNED |
|
378 - 420 336 - 377 294 - 335 252 - 293 251 and below |
A B C D F |
|
Homework: The scheduled reading assignments are expected to be read before the date of lecture. This provides for greater understanding during the lecture; and allows for participation and questions. Generally, assignments are due the week following the lecture. It is necessary to keep up with your assignments since each new assignment is based on the previous assignments. See the dates below in the schedule section. Assignments may be turned in late, but no later than one week. Assignments turned in late will be marked down one letter grade. Meaning that if the assignment is 20 points and it is late, then it will be marked down to 16 points. |
|
Attendance: Attendance is very important. To quote the Cerritos College catalogue: "When the hours of
absence exceed one more than twice the number of class hours per week, the
students are considered to be excessively absent and are subject to exclusion
from class." Students will be dropped from the class if they are considered to be excessively absent based on the above criteria. The only exception to this rule will be for authorized or excused absences as described in the Cerritos College catalogue.
For online students attendance will be based upon actively participating in the class. This means doing the weekly activities such as the readings, lab assignments, discussions, quizzes, and tests as assigned by the deadlines. You may be dropped if you fail to do the weekly activities. |
|
Academic Honesty/Dishonesty Policy:
Please be sure to read the college’s Academic Honesty/Dishonesty Policy found in the catalogue. A copy of the catalogue is located at www.cerritos.edu . How does it apply to this class? For tests be sure to study and answer questions on your own without help from other students. For the homework assignments make sure you create your own files from scratch and do your own typing. I know some of you work together, share books and computers. That’s OK. What is not OK is having one person type up the assignment and then submitting it (file or printed document) for multiple students. Trust me I have ways of figuring it out if you are cheating in this manner. If I determine that you are cheating, then I will do one of the following actions as stated from the college’s policy:
One or more of the following actions are available to the faculty member who suspects a student has been cheating or plagiarizing: 1. Review-no action. 2. An oral reprimand with emphasis on counseling toward prevention of further occurrences. 3. A requirement that work be repeated. 4. A reduction of the grade earned on the specific work in question, including the possibility of no credit for the work. 5. A reduction of the course grade as a result of item 4 above, including the possibility of a failing grade for the course. 6. Referral to the Office of Judicial Affairs for further administrative action, such as suspension or expulsion. |
|
Exams: Exams will NOT be "made-up." The only exceptions will be for authorized or excused absences or foreseeable absences. If you know you will not be able to attend
class on a day when an exam is being given, you may take it one week prior to
the scheduled date. You must notify
me two weeks in advance to arrange to take the exam prior to the scheduled
date. |
Class Schedule:
|
DATE |
READ |
TOPIC |
ASSIGNMENT DUE |
|
8/19, 8/21 |
|
About This Course |
|
|
8/26, 8/28 |
Chapter 1 |
Office Fundamentals |
|
|
9/2, 9/4 |
Chapter 1 |
Introduction to Excel |
Office Fundamentals |
|
9/9, 9/11 |
Chapter
2 |
Formulas and Functions |
Chapter 1 |
|
9/16
9/18 |
|
Test #1, Chapter 1 Office Fundamentals and Excel Chapters 1 - 2 |
|
|
9/23, 9/25 |
Chapter 3 |
Charts |
Chapter
2 |
|
9/30, 10/2 |
Chapter 4 |
Working with Large Worksheets and Tables |
Chapter 3 |
|
10/7, 10/9 |
Chapter 5 |
Data to Information |
Chapter 4 |
|
10/14 10/16 |
|
Test #2, Chapters 3 - 5 Open Lab |
|
|
10/21, 10/23 |
Chapter 6 |
Data Tables and Amortization Tables |
Chapter 5 |
|
10/28, 10/30 |
Chapter 7 |
Data Consolidation, Links, and Formula Auditing |
Chapter 6 |
|
11/4 |
Chapter 8 |
What-If Analysis |
|
|
11/11 |
|
Veteran's Day Holiday |
Chapter 7 |
|
11/18, 11/20 |
Chapter 9 |
Collaboration and Workbook Distribution |
Chapter 8 |
|
11/25 |
|
Open Lab |
|
|
12/2, 12/4 |
Chapter 10 |
Templates, Styles, the Web, and Macros |
Chapter 9 |
|
12/9, 12/11 |
|
Open Lab |
Chapter 10 |
|
12/18, 12:00 - 2:00 PM |
|
Final Exam, Chapters 8 - 10 |
|
|
Please note: CIS labs are closed during final exams. |
|||