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

Riverside Community College District
Integrated Course Outline of Record

Computer Information Systems 1B


COURSE DESCRIPTION
1B Adv Concepts in CIS Units: 3.00
 
Prerequisite(s):
CIS-1A.
Advanced computer concepts, theory, and computer applications. Advanced skills of word processing, spreadsheets, presentation graphics, the Internet and databases with an emphasis on multitasking, integrating applications, linking, and embedding are covered. Concepts covered include communications and networks, E-Commerce, ethical issues, security, privacy, databases and information management, information systems development, program development and programming languages, computer careers and certification. 54 hours lecture and 18 hours laboratory.
 
SHORT DESCRIPTION FOR CLASS SCHEDULE
Advanced word processing, spreadsheet, presentation, and database skills are covered through lecture and hands-on computer assignments.
 
ADVISORY ENTRY SKILLS
Before entering the course, students will be able to:
  1. Identify the fundamental computer concepts and terminology used for input, processing, output, and storage.

  2. Identify the key features of a variety of software such as operating systems, word processors, spreadsheets, databases, communications and graphics.

  3. Apply the principles of and solve problems with word processing, spreadsheet, database, communications and file management programs.

  4. Create electronic presentations with presentation graphics.

  5. Use the Internet to send electronic messages.

  6. Demonstrate the principles of Internet research.

  7. Understand the principles of computer security, ethics and privacy.

  8. Understand and apply the principles of distance education software.

  9. Sign Up for CIS 96/97

  10. CIS 96 and 97 are self-paced, competency-based, skill development computer labs. They provide the computer practice times to master the skills taught in the lecture classes. There is one-on-one instructor assistance available with additional help provided by student aides. Basically, the skills that are presented in the lecture classes have to be practiced to be mastered.
STUDENT LEARNING OUTCOMES
 Upon successful completion of the course, students should be able to:

Identify the concepts and terminology used in file and database
management, information systems development, and
communications.

Apply advanced word processing skills to solve problems.

Apply advanced spreadsheet skills to analyze and solve problems.

Apply advanced database skills to analyze and solve problems.

Apply advanced presentation skills to design and edit electronic presentations.

Use the Internet to search for information and evaluate Internet resources.

Integrate, link and embed work processing documents, worksheets, charts and databases.
 
COURSE CONTENT
  TOPICS
 
  1. Students are guided through advanced computer application features and functions.  Focus is on the acquisition of advanced application skills, determining when the use of a particular application is most appropriate and how an application should best be utilized in solving a specific problem.
  2. Coverage of topics is devoted to organizing, gathering, and communicating information.  Strategies are modeled for managing files that simplify access to information and improve productivity.  Effective methods of conducting Internet research are discussed.  Word is examined as a tool for composing, reviewing, updating, circulating, and formatting documents, such as flyers, newsletters, brochures, memos, and reports.  PowerPoint is explored as a way to create professional presentations that engage an audience and add impact and value to ideas.
  3. Instructors should model Excel as a tool for solving problems and supporting decision making. Instructors should guide students through examples of what-if analysis, statistical analysis, and quantitative analysis. Effective display of data using formatting and charts is covered.  Examples of complex logical constructs for solving problems and methods of retrieving data for computation, analysis, and reference are presented.
  4. Instructors should use Access to guide students through the process of database design and creation.  Access is examined as a tool to analyze data for effective decision making, and for the collection of data to create well-designed forms and to develop effective reports.
  5. Topic coverage should also include use of Office to integrate data to produce useful documents, presentations, and provide information on the Internet.
  6. Concepts covered include communications and networks, E-Commerce, ethical issues, security, privacy, databases and information management, information systems development, program development and programming languages, computer careers and certification.   
 
METHODS OF INSTRUCTION
 Methods of instruction used to achieve student learning outcomes may include, but are not limited to:

  • Presentation of class lectures/discussions/demonstrations in order to clarify advanced computer concepts, show and explain computer fluency topics and how these topics apply to society.
  • Presentation of class lectures/discussions/demonstrations in order to model and explain effective use of advanced computer applications skills.
  • Web-based/web-enhanced/online/distance learning tasks/activities such as web quests in order to reinforce understanding of concepts related to computer fluency and advanced computer application skills.
  • Web-based/web-enhanced/online/distance learning tasks/activities such as Internet presentations, emails, discussion board postings, and online file submissions in order for students to understand the principles of computer security, ethics and privacy.
  • Online and Laboratory activities and application assignments in order to address areas of improvement in computer fluency and advanced computer application skills.
  • Projects in order to facilitate and demonstrate the acquisition of advanced skills required to create documents, spreadsheets, databases and presentations.
  • Collaborative projects/cooperative learning tasks in order to encourage students to develop and apply computer fluency, advanced computer application skills and team work 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 advanced computer concepts and terminology.
  • Exercises/projects designed to demonstrate the acquisition of computer fluency concepts and advanced computer application skills.
  • Projects and oral reports combining the use of word processing, spreadsheet, database and presentation software and internet research principles designed to measure students’ critical thinking, comprehension, and organizational skills.
  • Collaborative projects designed to demonstrate successful understanding and application of computer concepts, advanced computer application skills and team work skills.
  • Computer Laboratory assignments/projects designed to clarify students’ individual computer fluency strengths and areas of improvement related to advanced computer application skills.
  • Common final examination designed to evaluate students’ overall achievement of course objectives in computer fluency concepts and advanced computer 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:

  • Akaiwa, Frank, et al.. Succeeding in Business® Applications with Microsoft Office 2007: A Problem-Solving Approach. Thomson, 2008.
  • Shelly, Gary B. and Thomas J. Cashman, Misty E. Vermaat. Microsoft Office 2007: Advanced Concepts and Techniques. Thomson, 2008.
  • Gaskin, Shelley, et al.. GO! with Microsoft Office 2007 Advanced. Prentice Hall, 2008.
08/07
523