Computer Information Science

2 class hrs/wk, 2 cr.

Introduces teaching methods, materials, and instructional design as related to training computer users.

Prerequisite: second-year standing in the Computer Programming program.

Sp

3 lab hrs/wk, 3 cr.

Introduces the basic microcomputer hardware/software system. Covers the concepts of system software and application software, including word processing, spreadsheet, database, presentation and introduction to Internet.

Prerequisite: touch keyboarding ability and college textbook reading (RD090 or equivalent) recommended.

F, W, Sp, Su

3 class hrs/wk, 3 cr.

Provides the basic knowledge of the security, political and social issues, and human factors concerning the use of current computer technologies and how people are aff ected by computer security breaches and technology misuse. Discusses electronic voting, Radio Frequency Identifi cation (RFID) tags, location-based tracking technologies, and the Digital Millennium Copyright Act (DMCA). Explores computer security exploits such as buffer overflow, Denial of Service, spoofing, viruses, Trojan Horses, phishing and pharming scams, and intrusion detection. Covers how to protect yourself from malicious computer activities.

Prerequisite: CIS101 or CIS120, or consent of instructor.

Offered as needed.

3 class hrs/wk, 3 cr.

Introduces the Graphical User Interface (GUI) environment with an emphasis on the operation of Microsoft Windows. Focuses on the multitasking environment, including multiple window interface, common user access (CUA) pull-down menus, and the interaction of RAM memory and PC hardware.

Prerequisite: CIS101 or CIS120.

F, W, Sp, Su

1 class hr/wk, 1 cr.

Exposes students to many diff erent career opportunities in computer information sciences and computer technology, and assists with planning an academic pathway at Chemeketa Community College.

F, W, Sp, Su

4 class hrs/wk, 4 cr.

Introduces terminology and overview of the historical development of computer and information science. Focuses on the basic concepts of computer hardware and software systems, the science of information representation, and the fundamental elements of program design and computer language. Concepts are reinforced in a laboratory environment. First in a three-course sequence.

Prerequisite: MTH070 and RD115, or equivalent level of skill as demonstrated by satisfactory score on placement test.

F, W, Sp

4 class hrs/wk, 4 cr.

Introduces fundamental logic in designing specific algorithms for processing information typified by management information systems and the logical thought process used when programming. Covers structured programming and object-oriented programming concepts that include problem definition, generating a description of its step-bystep solution (the algorithm), writing the program, and finally documenting a program. Second of the three core CIS courses and is applicable to non-CS majors.

Prerequisite: CIS120 or concurrent enrollment, or consent of instructor.

F, W

4 class hrs/wk, 4 cr.

Introduces software and languages used in today’s network environment. Covers features of objectoriented design and programming concepts and contrasts them with structured methodology and related language. Th ird in a three-course sequence.

Prerequisite: CIS121 or consent of instructor.

Sp, Su

3 class hrs/wk, 3 cr.

Focuses on microcomputer database software using Microsoft Access. Includes navigation through Windows and Access menus; PC relational database concepts; creation and updating of a relational database; simple queries, reports, and forms; complex queries, reporting, and forms.

Prerequisite: CIS101 or CIS120, or consent of instructor.

F, W, Sp

4 class hrs/wk, 4 cr.

Presents electronic spreadsheets in a multiworksheet environment using Excel.

Prerequisite: CIS101 or CIS120, or consent of instructor.

F, W, Sp, Su

4 class hrs/wk, 4 cr.

Surveys the field of computer game development, including a study of the history and business of computer gaming, computer game categories and platforms, and computer game technologies. Covers an overview of the game development process and introduces game graphics. Provides complete game development lifecycle using a high-level game development framework to design and develop a computer game.

Prerequisite: computer literacy; CIS120 or CIS101 recommended.

F, W, Sp

4 class hrs/wk, 4 cr.

Provides hands-on experience using Visual Studio using ASP.NET Framework using the C# programming language. Covers the essentials of the C# programming language, introducing built-in data types, operators, control structures, classes, and methods.

Prerequisite: CIS121 and any fi rst-term programming course including CIS133J, S133U, or CS161, or consent of instructor.

Offered as needed.

4 class hrs/wk, 4 cr.

Introduces Java programming language. Provides a conceptual understanding of object-oriented programming using Java. Covers the structure of the language, the manipulation of data and arrays, how to handle input and output, and how to create classes, objects, and applications.

Prerequisite: MTH060; CIS101or CIS120; or consent of instructor.

F

4 class hrs/wk, 4 cr.

Covers the fundamentals of JavaScript as a Web programming language, including basic programming concepts as they apply to using and writing JavaScript. Focuses on learning to create interactivity using JavaScript with text and graphics. Provides the foundation for continuing with JavaScript in the Intermediate JavaScript course, and features current Web-standards compliant techniques for using JavaScript.

Prerequisite: CIS122, or CIS195, or CIS178I, and any fi rst-term programming course including CIS133J, CS133U, or CS161, or consent of instructor.

Offered as needed.

4 class hrs/wk, 4 cr.

Provides the knowledge and skills necessary to write and maintain scripts that automate aspects of system administration for computers running the Microsoft Windows operating system. Covers scripting languages, hosts, and libraries, and the interfaces built into the Windows operating system.

Prerequisite: CIS121 or consent of instructor.

F

4 class hrs/wk, 4 cr.

Continues use of the Visual Basic programming environment. Emphasizes application of event-driven and structured problem-solving and programming techniques to develop software. Introduces objectoriented programming, Web applications, and database access. Includes the design, coding, testing, and debugging of several programs.

Prerequisite: CIS121 or equivalent VB programming experience as determined by the instructor.

W, Sp

3 class hrs/wk, 3 cr.

Studies operating systems currently used on larger microcomputers and small minicomputers. Includes experience in using these operating systems to access fi les and communicate with other microcomputers.

Prerequisite: CIS101 or CIS120, or equivalent.

W

3 class and 4 lab hrs/wk, 5 cr.

Covers the basic concepts of the Solaris Operating System and provides practical experience using UNIX components.

Prerequisite: CIS101 or CIS120, or consent of instructor.

Offered as needed.

3 class hrs/wk, 3 cr.

Covers the Unix operating system using Linux. Includes experience in using the Unix operating system to run a microcomputer, access files and communicate with other microcomputers.

Prerequisite: CIS101 or CIS120, or consent of instructor.

F, Sp

3 class and 2 lab hrs/wk, 4 cr.

Studies the hardware concepts necessary to install and maintain computers and computer peripherals. Explains the interface between software and hardware and incorporates the requirements for A+ certification.

Prerequisite: CIS240 or concurrent enrollment, or CIS140B, or NET123.

W

3 class hrs/wk, 3 cr.

Introduces the use and history of the global computer network known as the Internet or information superhighway. Explores the philosophy of the Internet, as well as its use as a tool for research, communication, and entertainment. Students will develop and publish a simple Web page on the World-Wide Web.

Prerequisite: CIS101 or CIS120, or consent of instructor.

F, W, Sp, Su

3 class and 4 lab hrs/wk, 5 cr.

Covers fundamentals of Web design using Adobe Systems software. Focuses on the overall production processes surrounding Web design. Emphasizes design elements involving layout, navigation, and interactivity. Includes hands-on Web design exercises using Adobe PhotoShop, Adobe Illustrator, Adobe GoLive, Adobe LiveMotion, and Adobe Premiere.

Prerequisite: CIS101 or CIS120, or consent of instructor.

F, W

4 class hrs/wk, 4 cr.

Introduces computer networks from an enduser perspective. Provides experience installing, administering, and managing network software and resources, including user accounts, in a clientserver environment.

Prerequisite: CIS140B or NET123.

F, Sp

4 class hrs/wk, 4 cr.

Provides the basics of computer forensics as they apply to personal computers and workstations, including how to obtain and analyze digital information for use as evidence in civil, criminal, or administrative cases.

Prerequisite: CIS102A, CIS120, CIS140B, CIS179, or consent of instructor.

Offered as needed.

4 class hrs/wk, 4 cr.

Covers Web site planning, organization, and implementation. Explores Web development applications. Discusses XHTML, XML, style sheets, and basic scripting. Addresses accessibility, browsers compatibility, and globalization issues.

Prerequisite: CIS178I or consent of instructor.

F, Sp

4 class hrs/wk, 4 cr.

Continues the Fundamentals of Java Programming 1 course. Provides a conceptual understanding of encapsulation, polymorphism, and inheritance related to the object-oriented programming paradigm and Java. Covers the use of java.lang, java.util, java.applet, java.awt and java.io packages to create program code. Includes documenting program code using the Javadoc interface and creating a Graphical User Interface (GUI) application using a visual Interface Development Environment (IDE). Prerequisite: CIS133J or consent of instructor.

W

4 class hrs/wk, 4 cr.

Continues the Fundamentals of Java Programming 2 course and serves as a capstone project course. Provides an overview of the Abstract Windowing Toolkit (AWT) from the Java platform to create programs with graphical user interface (GUI) components (buttons, checkboxes, text fi elds, etc.). Presents the mechanics for handling events and exceptions generated by GUI components. Covers a conceptual overview of connecting to a database such as SQL Server, Oracle, etc., and manipulate data from the same databases using the Java database connectivity (JDBC) application programmer interface (API).

Prerequisite: CIS233J or consent of instructor.

3 class hrs/wk, 3 cr.

Studies advanced operating systems. Incorporates the use of third-party utility programs, hard disk management concepts, MS/DOS in a network environment, and MS/DOS-OS-AIX migration considerations.

Prerequisite: CIS140B or consent of instructor.

W

4 class hrs/wk, 4 cr.

Offers an advanced course covering the concepts used for installing, administering, and maintaining a UNIX/LINUX system. Includes installing and managing a version of LINUX in the laboratory experience.

Prerequisite: CIS140U or consent of instructor.

3 class hrs/wk, 3 cr.

Covers basic administrative procedures. Includes principles of organizing, planning, and administering a procedure program. Presents methods of carrying out individual systems and procedures studies. Also includes procedures analysis and improvement techniques, the role of systems and procedures in business management, systems charting, work simplifi cation, and measurement.

Sp

1 class hr/wk, 1 cr.

Brings together project elements and milestones using industry best practices to create specifications for an information systems project. Students will develop a project that is closely related to their focused area of study and complete all of the CIS244 milestones under the guidance of a CIS instructor. Requires concurrent enrollment in CIS244 during the final year of the program.

Prerequisite: concurrent enrollment in CIS244.

Sp

3 class hrs/wk, 3 cr.

Presents the fundamentals of automated systems and procedures. Includes techniques and principles of top-down systems analysis and design, data gathering, feasibility studies, problem analysis, systems economics, forms design and control, procedure writing, and the planning involved in the installation of electronic data processing systems.

Prerequisite: CIS244.

Offered as needed.

4 class hrs/wk, 4 cr.

Offers an extensive introduction to data server technology. Examines the concepts of both relational and object relational databases and the Structured Query Language (SQL) programming language. Covers creating and maintaining database objects and storing, retrieving, and manipulating data. Also covers retrieving data by using advanced techniques such as ROLLUP, CUBE, set operators, and hierarchical retrieval. Includes writing SQL and SQL*Plus script fi les using the iSQL*Plus tool to generate report-like output.

Prerequisite: CS275 or consent of instructor.

W

4 class hrs/wk, 4 cr.

Introduces Procedural Language/Structural Query Language (PL/SQL) and the benefi ts of this Oracle programming language. Covers creating PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Also covers creating procedures, functions, packages, and database triggers. Uses iSQL*Plus to develop program units. Includes managing PL/SQL program units and database triggers, managing dependencies, manipulating large objects, and using some of the Oracle-supplied packages.

Prerequisite: CIS121 or equivalent and CIS276A, or consent of instructor.

Sp

4 class hrs/wk, 4 cr.

Focuses on designing and building a variety of standard and custom Internet Web and paper reports using Oracle Reports Developer, Tool for Oracle Application Developers (TOAD), and Crystal Reports. Covers working in the declarative environment of Reports Builder, TOAD, and Crystal Reports. Includes how to retrieve data from a data source, display it in readable format, and publish the output.

Prerequisite: CIS276A, CIS276B or consent of instructor.

Offered as needed.

4 class hrs/wk, 4 cr.

Offers a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Covers how to create an operational database and properly manage the various structures in an eff ective and efficient manner.

Prerequisite: CIS276A or consent of instructor.

Offered as needed.

4 class hrs/wk, 4 cr.

Covers transporting data between databases and the utilities used to perform these activities. Introduces networking concepts and configuration parameters, as well as solving some common network problems. Also addresses backup and recovery techniques, and examines various backup, failure, restore, and recovery scenarios. Examines backup methodologies based on business requirements in a mission-critical enterprise. Covers multiple strategies and Oracle Recovery Manager to perform backups, and restore and recovery operations.

Prerequisite: CIS277A or consent of instructor.

Offered as needed.

4 class hrs/wk, 4 cr.

Focuses on database and instance tuning of the Oracle database. Uses the available Oracle tools such as Oracle Enterprise Management (with the Diagnostics and Tuning Packs) and STATSPACK. Covers how to recognize, troubleshoot, and resolve common performance-related problems in administering an Oracle database.

Prerequisite: CIS277B or consent of instructor.

Offered as needed.

3 class hrs/wk, 3 cr.

Covers fundamental concepts in data communication, including definition of terms, communicating concepts, comparison of voice and data communication (analog vs. digital signals), medium access, elementary data ling protocols, topologies, servers, and operating system standards implemented in local area networks (LAN).

Prerequisite: second-year standing in the Computer Systems and Information Technology program.

W

3 class and 4 lab hrs/wk, 5 cr.

Covers the Local Area Network Systems (LANS) and Wide Area Network Systems (WANS) using Novell’s operating system. Focuses on the design, construction, operation, maintenance, and management of a network, including the installation of software packages, printers, and adding new users.

Prerequisite: CIS145, and CIS278 or NET151.

Sp

See CWE—Cooperative Work Experience.

3 class hrs/wk, 3 cr.

Introduces new users of relational databases to Structured Query Language (SQL). Covers building a database and accessing stored information by performing queries. Includes retrieving, adding, and deleting data from an SQL-compliant database.

Prerequisite: CS275 or consent of instructor.

Offered as needed.

3 class and 2 lab hrs/wk, 4 cr.

Explains the process to design and build an Internet system. Includes establishing a multi-server environment that requires Web services, common gateway interfaces, e-mail services, database services, and other Web-based applications.

Prerequisite: CIS140U and CIS288.

Sp

4 class hrs/wk, 4 cr.

Provides experience installing, confi guring, customizing, administering, and maintaining a server and its resources in a client-server network.

Prerequisite: CIS179.

F, Sp

3 class and 2 lab hrs/wk, 4 cr.

Focuses on software and hardware troubleshooting and support required in a Local Area Network environment.

Prerequisite: concurrent enrollment in CIS279, or consent of instructor.

Sp

4 class hrs/wk, 4 cr.

Covers the development of Web applications using various scripting languages. Explains the process of Web application development. Stresses proper coding practices and documentation and implementation of databases for dynamic Web content.

Prerequisite: CIS178I or CIS195 or VC237 or consent of instructor.

W