|
CIS 151 |
Excel for Information Technology |
Spring 2010 |
|
Ticket #: 22499 |
Room Online |
Time: Online |
|
Instructor: Susan Fuschetto |
Phone: (562) 860-2451, 2781 |
|
| Back to My Home Page | ||
|
|
||
|
|
COURSE OBJECTIVES: BACK TO TOP
A.
Creating worksheets B.
Editing data within worksheets C.
Creating and using templates D.
Printing worksheets and workbooks E.
Formatting data within worksheets F.
Formatting worksheets G.
Creating and using labels H.
Saving and retrieving worksheets I.
Designing worksheets which include calculations J.
Using the function Wizard to incorporate functions in worksheets K.
Creating a financial worksheet L.
Recording, running, and revising macros M.
Printing a large worksheet using landscape style N.
Accessing data within EXCEL database O.
Freezing row and column headings to view remote cells within large worksheets P.
Creating and printing bar, pie, or line graph Q.
Creating and printing 3-D, doughnut, radar, or XY (Scatter) graphs R.
Incorporating a text box on a chart S.
Using the chart Wizard T.
Converting one style chart to another style U.
Using the database Wizard V.
Linking multiple worksheets W.
Creating a database X.
Designing worksheets including formulas and functions Y.
Sorting and/or filtering data Z.
Using statistical function AA.
Using the Solver tool for analysis BB.
Using the Goal seeker tool to analyze a worksheet CC. Defining database retrieve specifications DD. Introduction to VBA
STUDENT LEARNING OUTCOME:
|
|
the exploring series: Microsoft Office, Excel 2007, Comprehensive By: Grauer, Mulbery, and Scheeren ISBN: 978-0-13-157465-6 (2008) or Second editions: 978-0-13-503227-5 (2009) or 978-0-13-511980-8 (2010) Other Materials:
|
|
GRADING AND ASSIGNMENTS: BACK TO TOP |
|
GRADE POINTS REQUIRED: |
|
|
Orientation Quiz 11 assignments (11 at 20 points each)
Tests (3 at 50 points each) Final Exam |
15 220
150 50 Total:
435 |
|
POINTS REQUIRED |
GRADE EARNED |
|
391 - 435 348 - 390 304 - 347 261 - 303 260 and below |
A B C D F |
|
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. |
|
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 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. |
|
DATE |
READ |
TOPIC |
ASSIGNMENT DUE |
|
1/12 |
|
Online Orientation |
Orientation Quiz |
|
1/19 |
Chapter 1 |
Office Fundamentals |
|
|
1/26 |
Chapter 1 |
Introduction to Excel |
Office Fundamentals |
|
2/2 |
Chapter
2 |
Formulas and Functions |
Chapter 1 |
|
2/9 |
|
Test #1, Chapter 1 Office Fundamentals and Excel Chapters 1 - 2 |
|
|
2/16 |
Chapter 3 |
Charts |
Chapter
2 |
|
2/23 |
Chapter 4 |
Working with Large Worksheets and Tables |
Chapter 3 |
|
3/2 |
Chapter 5 |
Data to Information |
Chapter 4 |
|
3/9 |
|
Test #2, Chapters 3 - 5 Open Lab |
|
|
3/16 |
Chapter 6 |
Data Tables and Amortization Tables |
Chapter 5 |
|
3/23 |
Chapter 7 |
Data Consolidation, Links, and Formula Auditing |
Chapter 6 |
|
3/30 |
|
Spring Recess |
|
|
4/6 |
|
Test #3, Chapter 6 - 7 |
|
|
4/13 |
Chapter 8 |
What-If Analysis |
Chapter 7 |
|
4/20 |
Chapter 9 |
Collaboration and Workbook Distribution |
Chapter 8 |
|
4/27 |
Open Lab |
||
|
5/4 |
Chapter 10 |
Templates, Styles, the Web, and Macros |
Chapter 9 |
|
5/11 |
|
Open Lab |
Chapter 10 |
|
5/18 |
|
Final Exam, Chapters 8 - 10 |
|
|
Please note: CIS labs are closed during final exams. |
|||