CIS 151 Excel for IT

CIS 151	Excel for Information Technology	Fall 2008
Ticket #: 44970	Room Online	Time: Online
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 Drive (if you are using the computers on campus)
A computer with the Windows XP operating system, Microsoft Office 2007 Professional which includes Excel 2007, and a Web Browser either Internet Explorer or Netscape. Access to the Internet and an email account. These computer tools are available in the CIS computer labs in the Liberal Arts building, LA3 - LA6 and in the open CAI Labs in the Library, LC-137. You may of course use your own computer tools. Also, you may purchase discount software at: http://www.collegesoftware.org .

Student Learning Outcome:

Students will create a professional looking spreadsheet that includes a formatted chart with an expected success rate of 75%.
Students will create a summary spreadsheet by linking multiple spreadsheets with an expected success rate of 75%.
Students will create a spreadsheet that uses macros to automate repetitive tasks with an expected success rate of 75%.

GRADE POINTS REQUIRED:

Orientation Quiz

11 assignments (11 at 20 points each)

Tests (3 at 50 points each)

Final Exam (comprehensive)

220

150

Total: 435

POINTS REQUIRED

GRADE EARNED

391 - 435

348 - 390

304 - 347

261 - 303

260 and below

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		Orientation - Online	Orientation Quiz
8/26	Chapter 1	Office Fundamentals
9/2	Chapter 1	Introduction to Excel	Office Fundamentals
9/9	Chapter 2	Formulas and Functions	Chapter 1
9/16		Test #1, Chapter 1 Office Fundamentals and Excel Chapters 1 - 2
9/23	Chapter 3	Charts	Chapter 2
9/30	Chapter 4	Working with Large Worksheets and Tables	Chapter 3
10/7	Chapter 5	Data to Information	Chapter 4
10/14		Test #2, Chapters 3 - 5
10/21	Chapter 6	Data Tables and Amortization Tables	Chapter 5
10/28	Chapter 7	Data Consolidation, Links, and Formula Auditing	Chapter 6
11/4		Test #3, Chapter 6 - 7
11/11		Veteran's Day Holiday
11/18	Chapter 8	What-If Analysis	Chapter 7
11/25	Chapter 9	Collaboration and Workbook Distribution	Chapter 8
12/2	Chapter 10	Templates, Styles, the Web, and Macros	Chapter 9
12/9		Open Lab	Chapter 10
12/16		Final Exam, Chapters 8 - 10
Please note: CIS labs are closed during final exams.