CIS 101

Intro. to Computer Information Systems

Fall 2008

Ticket #: 42819

Room SS139

Time: Friday 1:00 - 4:45

Instructor: Susan Fuschetto

Office Hours: Tuesdays 3:30 - 4:30 PM, Wednesdays 6:00 - 7:00 PM, Fridays 12:00 - 1:00 PM

Web Page Address: www.cerritos.edu/sfuschetto

Phone: (562) 860-2451, 2781

Office: SS24

Email: sfuschetto@cerritos.edu

Texts:    

The three required books are sold as a bundle in the Cerritos College bookstore.  The ISBN bundle number is 1435435796.  If you buy the books separately, then here's the details of what books are in the bundle:

• ISBN: 1423927028 (Shelly/Cashman) Discovering Computers Fundamentals Edition, Fifth Edition

• ISBN: 1418843431 (Shelly/Cashman) Microsoft Excel 2007, Complete

• ISBN: 1423973941 (Shelly/Cashman/Vermat) Introduction to Office 2007, Custom Edition for Cerritos College, Windows XP Edition

Other Materials:

• 1 USB Drive (if you are using the computers on campus), 4 SCANTRONs #882 or #882e answer sheets and a pencil for tests and the final exam.

• A computer with the Windows XP operating system, Microsoft Office 2007 Professional, 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:

• 75% of the students in the class will be able to create an organized set of folders, and successfully copy, move, delete, and rename folders and files according to a model assigned by the instructor.

Homework:

You are expected to keep up with the scheduled reading assignments and lab assignments.  It is necessary to keep up with your lab assignments since new assignments build upon previous assignments.  Lab assignments have strict deadlines.  Late assignments will be accepted up to one week after the deadline.  If the assignment is late, then it will be marked down one letter grade (4 points).   Check the dates in the Class Schedule section.  Here is the link to the Lab Assignments page where you will find the instructions for each lab assignment. 

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.

1 hour TBA Labs:  The lab assignments listed below are to be completed during the 1 hour to be arranged lab times.

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:

Below is the test and reading schedule.  Chapters 1 - 11 are in the Discovering Computers book.  Please click this link to go to the Lab Assignments page where you will find the instructions for each lab assignment.

DUE DATE

READ

TOPIC

LAB ASSIGNMENTS

9/12

Chapter 1
Chapter 2

Introduction to Computers
The Internet and World Wide Web

9/19

Chapter 3
Windows Project

Application Software
Managing Your Files

9/26

Word 1
Word 2

Test #1, Chapters 1 - 3
Creating and Editing a Word Document
Creating a Research Paper

Windows

10/3

Chapter 4
PowerPoint

The Components of the Systems Unit
Creating and Editing a Presentation

Word 1 & 2

10/10

Chapter 5
Access Project 1

Input and Output
Creating and Using a Database

PowerPoint

10/17

Chapter 6
Access Project 2

Storage
Querying a Database

Access 1

10/24

Excel Project 1

Test #2, Chapters 4 - 6

Creating a Worksheet and an Embedded Chart

Access 2

10/31

Chapter 7
Excel Project 2

Operating Systems and Utility Programs
Formulas, Functions, Formatting, and Web Queries

Excel 1

11/7

Chapter 8
Excel Project 3

Communications and Networks
What-If Analysis, Charting, and Working with Large Worksheets

Excel 2

11/14

Chapter 9
Excel Project 4

Database Management
Financial Functions, Data Tables, Amortization Schedules

Excel 3

11/21

Test #3, Chapters 7 - 9

11/28

Thanksgiving Holiday

12/5

Chapter 10
Excel Project 6

Computers and Society, Security, Privacy, and Ethics
Creating Templates and Working with Multiple Worksheets and Workbooks

Excel 4

12/12

Chapter 11

Information Systems Development and Programming Languages

Excel 6

12/19 1:00 PM

FINAL EXAM, Chapters 10 - 11

Please note:  CIS labs are closed during final exams.