Discipline: Computer Information Systems Degree Credit  [ ]
Non Credit  [ ]
Nondegree Credit  [ ]
Comm Service  [ ]
 

Riverside Community College District
Integrated Course Outline of Record

Computer Information Systems 1A


COURSE DESCRIPTION
1A Intro to Comp Info Sys Units: 3.00
 
Prerequisite(s): None.

Advisory: CIS 96 or CIS 97
An introduction to computer concepts, theory, and computer applications. Functions and capabilities of word processors, spreadsheets, databases, presentation graphics and the Internet are covered through lecture, discussion, and hands-on computer assignments. Concepts covered include types of software, hardware components, and operating systems with an emphasis on terminology and functionality. 54 hours lecture and 18 hours laboratory.
 
SHORT DESCRIPTION FOR CLASS SCHEDULE
An introduction to computer concepts, theory, and computer applications. Functions and capabilities of word processors, spreadsheets, databases, presentation graphics, and the Internet are covered through lecture, discussion, and hands-on computer assignments.
 
ADVISORY ENTRY SKILLS
None.

STUDENT LEARNING OUTCOMES
 Upon successful completion of the course, students should be able to:
Identify the fundamental computer concepts and terminology used for input, processing, output, and storage. Identify the key features of a variety of software such as operating systems, word processors, spreadsheets, databases, communications and graphics. Apply the principles of and solve problems with word processing, spreadsheet, database, communications and file management programs. Create electronic presentations with presentation graphics. Use the Internet to send electronic messages. Demonstrate the principles of Internet research. Understand the principles of computer security, ethics and privacy. Understand and apply the principles of distance education software.
 
COURSE CONTENT
  TOPICS
 
  1. Computer Concepts and Theory
    1.  Overview Concepts and Theory
      1. The Information Processing Cycle
      2. Components of a Computer
      3. Computer Software
      4. Networks and the Internet
      5. Categories of Computers
      6.  Elements of an Information System
    1. The Internet and World Wide Web
      1.  History of the Internet
      2. Accessing the Internet
      3. Electronic Commerce
      4.  Web Publishing
    1.  Application Software
      1.  Word Processing
      2.  Spreadsheet
      3.  Database
      4. Graphics, Presentation Graphics and Multimedia
      5.  Communications
    1.  The System Unit
      1.  Motherboards
      2. Central Processing Unit
      3. Data Representation
      4.  RAM, ROM, and Cache Memory
      5. Expansion Slots and Cards
      6.  Ports, Buses, Bays, and Power Supplies
    1.  Computer Input
      1. Keyboard
      2.  Pointing Devices
      3.  Voice
      4.  Digital Cameras and Video
      5.  Scanners and Reading Devices
    1.  Computer Output
      1.  Display Devices
      2.  Printers
      3.  Speakers and Headsets
      4.  Terminals
    1.  Secondary Storage
      1.  Magnetic Disks
      2.  CDs and DVDs
      3.  Magnetic Tapes
      4.  Non-Digital Storage
    1.  Operating Systems and Utility Programs
      1.  Functions and Types
      2.  Stand-Alone
      3.  Network
      4.  Embedded
      5.  Utilities
    1.  Computer Applications in Society
      1.  Education
      2.  Finance
      3.  Government
      4.  Health Care
      5.  Science
      6.  Publishing
      7.  Travel
      8.  Industry
    2.  Computer Security, Ethics and Privacy
  2.  Applications
    1.  Windows
      1.  Communicating with Windows
      2.  Keyboard and Keyboard Shortcuts
      3.  Desktop Views
      4.  Launching an Application
      5.  Using Help
    2.  Internet
      1.  The Internet and the World Wide Web
      2.  Web Browsers
      3.  URL's
      4.  Bookmarks
      5.  Saving Information
      6.  Printing Web Pages
      7.  Using Search Engines
      8.  Downloading Files
      9.  Electronic Mail
    3.  Word Processing
      1.  Creating and Editing Documents
      2.  Entering Text
      3.  Entering Graphics
      4.  Formatting Text
      5.  Saving and Printing Documents
      6.  Grammar and Spell Checking Documents
      7.  Adjusting Line Spacing
      8.  Adjusting Margins
      9.  Inserting Hyperlinks
      10. Cutting, Pasting, Copying, Moving Text
      11.  Selecting and Replacing Text
      12.  Creating Headers and Footers
      13. Using Wizards
      14. Setting Tabs
      15. Creating and Formatting Tables
    4. Spreadsheets
      1. Creating and Editing Worksheets
      2.  Entering Text
      3.  Entering Numbers
      4.  Entering Formulas and Functions
      5.  Saving and Printing Worksheets
      6.  Creating Charts
      7.  Formatting Cells
      8.  Cutting, Pasting, Copying, Moving Cell Contents
      9.  Spell Checking Worksheets
    5.  Databases
      1.  Introduction to Databases
      2.  Designing a Database
      3.  Creating a Database Structures
      4.  Saving Database Structures
      5.  Adding Records to Tables
      6.  Printing Tables
      7.  Creating a Queries
      8.  Creating Reports
      9.  Calculating Statistics
      10.  Sorting Data in a Query
      11.  Joining Tables
      12. Saving and Printing Queries
    6.  Presentation Graphics
      1.  Design Templates
      2.  Creating Slides
      3.  Setting Text Attributes
      4.  Viewing the Presentation
      5.  Spell Checking Presentation
      6.  Cutting, Pasting, Copying, Moving Text
      7.  Adding Graphics to Slides
      8.  Adding Animation Effects
      9.  Saving and Printing Presentation
    7. . Communications Software
      1.  Open, read, print, reply to and delete electronic mail messages
      2. Compose, format and send electronic mail messages
      3. View a file attachment
      4.  Create a personal folder
    8.  File Management
      1.  Windows Explorer and My Computer
      2.  Creating Folders
      3. Copying and Moving Files and Folders
      4.  Deleting Files and Folders
      5.  Renaming Files and Folders

Students are also assigned reading, writing and other outside assignments equivalent to two hours per one-hour lecture.

 
 
METHODS OF INSTRUCTION
 Methods of instruction used to achieve student learning outcomes may include, but are not limited to:

• Class lectures/discussions/demonstrations in order to clarify the concepts, show and explain computer literacy topics and how these topics apply to society.
• Class lectures/discussions/demonstrations that model and explain effective use of computer applications.
• Quizzes designed to motivate and facilitate the acquisition of computer literacy.
• Online and Laboratory activities and application assignments to address areas of improvement in computer literacy and application skills.
• Projects designed to facilitate and demonstrate the acquisition of skills required to create documents, spreadsheets, databases and presentations.
• Collaborative projects/cooperative learning tasks that encourage students to develop and apply computer literacy and application skills.
 
METHODS OF EVALUATION
 Students will be evaluated for progress in and/or mastery of learning outcomes by methods of evaluation which may include, but are not limited to:

·         Quizzes/examinations designed to measure students’ degree of mastery of course objectives of progression toward master of course objectives.

·         Exercises/projects designed to demonstrate the acquisition of computer literacy concepts and application skills.

·         Oral reports/examinations designed to measure students’ critical thinking, comprehension, and organizational skills.

·         Collaborative projects designed to evaluate students’ ability to work together to address a given task.

·         Computer Laboratory assignments/projects designed to clarify students’ individual computer literacy strengths and areas of improvement related to computer application skills.

·         Common final examination designed to evaluate students’ overall achievement of course objectives in computer literacy concepts and application skills.


ASSIGNMENTS

Required Reading Assignments


Required Writing Assignments


Other Outside-of-Class Assignments
 
COURSE MATERIALS
 All materials used in this course will be periodically reviewed to ensure that they are appropriate for college level instruction. Possible texts include:

  • Shelly, Cashman and Vermaat (2006). Discovering Computers 2006, A Gateway to Information -.
  • Shelly, Cashman and Vermaat (2005). Office 2003, Introductory Concepts and Techniques Course Technology.
03/06
522