CIS 101

Intro. to Computer Information Systems

Fall 2009

Ticket #: 20183

Room SS139

Time: Friday 9:00 - 12:00

Instructor: Susan Fuschetto

Phone: (562) 860-2451, 2781

Back to My Home Page

 

COURSE OBJECTIVES:                                                             BACK TO TOP

 

A. To gain essential knowledge required for a well-rounded understanding of the use of the computer as a tool in small and large business environments

B. To achieve an understanding of computer technology, hardware, software and how computers can be used to produce meaningful information

C. To solve problems in spreadsheet preparation and analysis using Microsoft Excel

D. To solve problems in database management using Microsoft Access

 

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.

 

TEXTS:                                                                                           BACK TO TOP

 

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 .

 

 

GRADING AND ASSIGNMENTS:                                            BACK TO TOP

 

Grade Points Required:

 

 

Lab Assignments (11 at 20 points each)

Tests (3 at 50 points each)

Final Exam

 

220

150

   50

Total:   420

 

Scale:

90% of Total points = A

80% of Total points = B

70% of Total points = C

60% of Total points = D

<60% of Total pts =   F

 

HOMEWORK:                                                                              BACK TO TOP

 

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:                                                                            BACK TO TOP

 

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. 

 

 

EXAMS:                                                                                          BACK TO TOP

 

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.

 

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.

 

CLASS SCHEDULE:                                                                    BACK TO TOP

 

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

8/21

 

Chapter 1

About This Course

Introduction to Computers

 

8/28

Chapter 2

The Internet and World Wide Web

9/4

Windows Project

Managing Your Files

9/11

Chapter 3

Application Software

 Windows

9/18

Test #1, Chapters 1 - 3, Word 1

9/25

Chapter 4
Word 2

The Components of the Systems Unit
Creating a Research Paper

Word 1

10/2

Chapter 5
PowerPoint

Input and Output
Creating and Editing a Presentation

Word 2

10/9

Chapter 6
Access Project 1

Storage
Creating and Using a Database

PowerPoint

10/16

 

Access Project 2

Test #2, Chapters 4 - 6

Querying a Database

Access 1

10/23

Chapter 7
Excel Project 1

Operating Systems and Utility Programs
Creating a Worksheet and an Embedded Chart

Access 2

10/30

Chapter 8

Excel Project 2
 

Communications and Networks
Formulas, Functions, Formatting, and Web Queries

Excel 1

11/6

Chapter 9

Database Management

Excel 2

11/13

 

Excel Project 3

Test #3, Chapters 7 - 9

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

 

11/20
 

Excel Project 4
Excel Project 6

Financial Functions, Data Tables, Amortization Schedules
Creating Templates and Working with Multiple Worksheets and Workbooks

 Excel 3

11/27

Thanksgiving Holiday

12/4

Chapter 10
 

Computers and Society, Security, Privacy, and Ethics

Excel 4 & 6

12/11

Chapter 11

Information Systems Development and Programming Languages

12/18 at
10:00 AM

 

FINAL EXAM, Chapters 10 - 11

Please note:  CIS labs are closed during final exams.

 

Back to My Home Page