Catalog

Yamhill Valley campus students study math

Computer Information Systems Course Descriptions

CIS060 Techniques of User Training
Introduces teaching methods, materials and instructional design as related to training computer users. Prerequisite: Second-year standing in the Computer Systems and Information Technology program. Sp
2 Credits

CIS101 Intro to Microcomputer Apps
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. Recommended: Touch keyboarding ability and placement into RD090 or higher; or consent of instructor. F, W, Sp, Su
3 Credits

CIS101CE CIS101 Challenge Exam
Computer Information Science
3 Credits

CIS102A Cyber Security and Safety
Provides basic knowledge of the security, political, and social issues, and human factors concerning the use of current computer technologies. Covers how people are affected by computer security breaches and technology misuse. Discusses electronic voting, Radio Frequency Identification tags, location-based tracking technologies, and the Digital Millennium Copyright Act. Explores computer security exploits such as buffer overflow, Denial of Service, spoofing, viruses, Trojan Horses, phishing and pharming scams, and intrusion detection. Includes how to protect yourself from malicious computer activities. Prerequisite: CIS101 or CIS120, either with a grade of C or better; or equivalent knowledge as determined by instructor; or consent of instructor. W, Su
4 Credits

CIS120 Digital Literacy
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. Includes concepts reinforced in a laboratory environment. Prerequisite: Placement into MTH095 or higher, and RD115 or higher; or MTH070 or higher with a grade of C or better; or consent of instructor. F, W, Sp
4 Credits

CIS120A CIS Pathway
Exposes students to many different career opportunities in computer information sciences and computer technology, and assists with planning an academic pathway at Chemeketa Community College. F, W
1 Credits

CIS121 Intro to Programming Concepts
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-by-step solution (the algorithm), writing the program, and finally documenting the program. Prerequisite/Corequisite: CIS120 with a grade of C or better; or consent of instructor. F, W
4 Credits

CIS125A Micro Database Software-Access
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, reports and forms. Prerequisite: CIS101 or CIS120, either with a grade of C or better; or consent of instructor. F, W, Sp, Su
3 Credits

CIS125E Excel-Workbooks
Presents electronic spreadsheets in a multi-worksheet environment using Excel. Prerequisite: CIS101 or CIS120, either with a grade of C or better; or consent of instructor. F, W, Sp, Su
4 Credits

CIS125G Intro to Comp Game Development
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. Recommended: CIS120 or CIS101, either with a grade of C or better. F, Sp
4 Credits

CIS125H xHTML Basics
Introduces software and application development environments used on the Internet and typical enterprise intranets. Covers HTML fundamentals, development tools for HTML, and introduces object-oriented programming using JavaScript and XML. Prerequisite: CIS120 with a grade of C or better; or consent of instructor
4 Credits

CIS133J Fund of Java Programming 1
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; CIS101 or CIS120; or consent of instructor. (All prerequisite courses must be completed with a grade of C or better.) F
4 Credits

CIS133JS JavaScript Web Program 1
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, CIS195, or CIS178I; and any first term programming course including CIS133J, CS133U, or CS161; or consent of instructor. (All prerequisite courses must be completed with a grade of C or better.) W
4 Credits

CIS133SC Fundamentals of Scripting Lang
Provides the knowledge and skills necessary to write and maintain scripts which automate aspects of web functionality for both client side and server side computers. Covers scripting languages, hosts, and libraries, and Web development tools. Prerequisite: CIS121 with a grade of C or better; of consent of instructor. F, Offered as needed
4 Credits

CIS133VB Visual Basic-Event Drive Prog
Continues use of the Visual Basic programming environment. Emphasizes application of event driven and structured problem solving and programming techniques to develop software. Introduces object-oriented programming, Web applications, and database access. Includes the design, coding, testing, and debugging of several problems. Prerequisite: CIS121 with a grade of C or better; or equivalent VB programming experience as determined by the instructor; or consent of instructor. W, Sp
4 Credits

CIS135AE Advanced MS Excel
Introduces Microsoft Excel 2010 Programming concepts to the non-programmer user who is already proficient with the Excel user interface. Covers recording and editing macros, using variables, and constants, writing subroutines and functions, conditional statements, and various methods of coding loops to repeat actions. Introduces using Visual Basic for Applications script in Microsoft Excel 2010. Prerequisite: CIS125E with a grade of C or better; or consent of instructor. Offered as needed
4 Credits

CIS140B Microcomputer Operating System
Studies operating systems currently used on larger microcomputers and small minicomputers. Includes experience in using these operating systems to access files and communicate with other microcomputers. Prerequisite: CIS101 or CIS120, either with a grade of C or better; or consent of instructor. W, Su
3 Credits

CIS140U UNIX/Linux
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, either with a grade of C or better; or consent of instructor. F, Sp
3 Credits

CIS145 Microcomputer Hardware
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: CIS140B or NET123, either with a grade of C or better; or consent of instructor. W
4 Credits

CIS178I Intro Internet/World Wide Web
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. Covers developing and publishing a simple web page on the World Wide Web. Prerequisite: CIS101 or CIS120, either with a grade of C or better; or consent of instructor. F, W, Sp, Su
3 Credits

CIS178W Fundamentals of Web Design
Covers fundamentals of web design using Adobe Systems software. Focuses on the overall production processes surrounding web site design. Emphasizes design elements involving layout, navigation, and interactivity. Includes hands-on web design exercises using Adobe Dreamweaver, Adobe Fireworks, and Adobe Flash. Prerequisite: CIS101 or CIS120, either with a grade of C or better; or consent of instructor. F, W
4 Credits

CIS179 Introduction to Client-Server
Introduces computer networks from an end-user perspective while providing a thorough study of clients in an enterprise environment. Includes hands-on experience installing, administering, and managing desktop software and resources including both local and domain accounts in the client-server network. Prepares students to obtain the Microsoft Certified Technical Specialist certification. Prerequisite: CIS140B with a grade of C or better; or consent of instructor. Sp
4 Credits

CIS186 Computer Forensics
Provides the basics of computer forensics as it applies 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, and CIS179; or consent of instructor. (All prerequisite courses must be completed with a grade of C or better.) Offered as needed.
4 Credits

CIS195 Web Site Development
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 with a grade of C or better; or consent of instructor. F, Sp, Su
4 Credits

CIS233J Fund of Java Programming 2
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.lag, 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 application using a visual Interface Development Environment. Prerequisite: CIS133J with a grade of C or better; or consent of instructor. W
4 Credits

CIS234J Fund of Java Programming 3
Continues the Fundamentals of Java Programming 2 course and serves as a capstone project course. Provides an overview of the Abstract Windowing Toolkit from the Java platform to create programs with graphical user interface (GUI) components (buttons, checkboxes, text fields, 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 manipulating data from the same databases using the Java database connectivity application programmer interface. Prerequisite: CIS233J with a grade of C or better; or consent of instructor. Sp
4 Credits

CIS244 Systems Analysis 1
Covers basic administrative procedures. Includes the principles of organizing, planning, and administering a procedure program; methods of carrying out individual systems and procedures studies; procedure analysis and improvement techniques; the role of systems and procedures in business management; systems charting; work simplification and measurement. Brings together project elements and milestones using industry best practices to create specifications for an information systems project. Sp
4 Credits

CIS276A Intro to Oracle: SQL
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 files using the iSQL*Plus tool to generate report-like output. Prerequisite/Corequisite: CS275 with a grade of C or better; or consent of instructor. F
4 Credits

CIS276B Oracle: Program with PL/SQL
Introduces Procedural Language/Structured Query Language (PL/SQL) and the benefits 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 as determined by instructor; and CIS276A; or consent of instructor. (All prerequisite courses must be completed with a grade of C or better.) W
4 Credits

CIS276C Oracle: Building Reports
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: CIS276B with a grade of C or better; or consent of instructor. Offered as needed.
4 Credits

CIS276D Oracle Academy 1-SQL
Focuses on Database Design and Programming with Structured Query Language (SQL). It covers the history of databases. Includes analyzing complex business scenarios and creating entity relation data models and conceptual data models' representations of those scenarios. Discusses unique identifiers and transitive dependencies, and normalizing tables. Introduces SQL; also covers the rules and guidelines needed to construct valid SQL statements. Introduces Oracle Application Express, Oracle Data Modeler, and Oracle SQL Developer software programs. F
4 Credits

CIS276E Oracle Academy 2-PL/SQL
Covers Database Programming with Procedural Language/Structured Query Language (PL/SQL). Introduces the PL/SQL block structure and coding anonymous blocks in Oracle Application Express. Explains the difference between SQL and the PL/SQL block structure. Introduces writing PL/SQL control structures, data types, cursors, functions, procedures, and exception handling. Prerequisite: CIS276D with a grade of C or better; or consent of instructor W, Offered as needed
4 Credits

CIS277A Database Administration Fund 1
Offers a conceptual understanding of database architecture and how their internal and external components work and interact within each particular database management system. Covers how to 1) create an operational database using MySQL, Microsoft SQL Server, and Oracle Database Management Systems, and 2) properly manage the various structures in an effective and efficient manner. Prerequisite: CIS276A with a grade of C or better; or consent of instructor. Offered as needed
4 Credits

CIS277B Database Administration Fund 2
Covers transporting data between databases and the utilities used to perform these activities using MySQL, SQL Server, and Oracle. 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 for performing backups, and restore and recovery operations. Prerequisite: CIS277A with a grade of C or better; or consent of instructor. Offered as needed
4 Credits

CIS278 Data Communications
Covers fundamental concepts in data communication including definition of terms, communicating concepts, comparison of voice and data communication (analog versus digital signals), medium access, elementary data ling protocols, topologies, servers, and operating system standards implemented in local area networks. Uses hands-on software activity related to protocols, switching, routing, and peer-to-peer networking using a VM environment. Prerequisite: CIS120 and CIS179, both with a grade of C or better; or consent of instructor. W
4 Credits

CIS279 Network Management
Focuses on the logical design, construction, operation, maintenance, and management of a network using directory services which includes installation of network server(s); configuring and managing DHCP, DNS, and RRAS; file and print services; system updates; and network security using secure IPSEC protocols. Prepares students to obtain both the Microsoft Certified Technical Specialist and Microsoft Certified Information Technology Professional certifications. Prerequisite: CIS179 with a grade of C or better; or consent of instructor. W
4 Credits

CIS280A Cooperative Work Experience
Offers placement in a business, agency, and/or industry for on-the-job training related to the student's curriculum.
1 Credits

CIS280B Cooperative Work Experience
Offers placement in a business, agency, and/or industry for on-the-job training related to the student's curriculum.
2 Credits

CIS280C Cooperative Work Experience
Offers placement in a business, agency, and/or industry for on-the-job training related to the student's curriculum.
3 Credits

CIS280D Cooperative Work Experience
Offers placement in a business, agency, and/or industry for on-the-job training related to the student's curriculum.
4 Credits

CIS280E Cooperative Work Experience
Offers placement in a business, agency, and/or industry for on-the-job training related to the student's curriculum.
5 Credits

CIS280F Cooperative Work Experience
Offers placement in a business, agency, and/or industry for on-the-job training related to the student's curriculum.
6 Credits

CIS280G Cooperative Work Experience
Offers placement in a business, agency, and/or industry for on-the-job training related to the student's curriculum.
7 Credits

CIS280H Cooperative Work Experience
Offers placement in a business, agency, and/or industry for on-the-job training related to the student's curriculum.
8 Credits

CIS280I Cooperative Work Experience
Offers placement in a business, agency, and/or industry for on-the-job training related to the student's curriculum.
9 Credits

CIS280J Cooperative Work Experience
Offers placement in a business, agency, and/or industry for on-the-job training related to the student's curriculum.
10 Credits

CIS280L Cooperative Work Experience
Offers placement in a business, agency, and/or industry for on-the-job training related to the student's curriculum.
12 Credits

CIS288 Advanced Client-Server Network
Provides hands-on experience installing, configuring, customizing, administering, and maintaining a server and outlines its various roles in an enterprise environment. Includes installation and administration of DHCP, DNS, remote access, virtualization, domain management, and group policy design. Prepares students to obtain both the Microsoft Certified Technical Specialist and Microsoft Certified Information Technology Professional certifications. Prerequisite: CIS179 and CIS279, both with a grade of C or better; or consent of instructor. W
4 Credits

CIS289 Adv Network Apps Support
Provides experience supporting and troubleshooting software and hardware on a virtualized local area network. Covers the various server roles of email server services, remote access, and domain security. Prepares students to obtain the Microsoft Certified Information Technology Professional certification. Prerequisite: CIS288 and CIS279, both with a grade of C or better; and consent of instructor. W
4 Credits

CIS295 Web Application Development
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, CIS195, or VC237; or consent of instructor. (All prerequisite courses must be completed with a grade of C or better.) W
4 Credits

CIS299A CISCO Instr Solaris-Unix Op Sy
Prepares instructors to teach the Solaris Operating System using CISCO-sponsored curriculum. Covers the basic concepts of the Solaris Operating System and provides practical information on using UNIX components. Prerequisite: CIS101 Introduction to Microcomputer Applications or consent of instructor.
4 Credits