MAIN MENU

Computer Information Science

CISP Course Descriptions

Course Descriptions CISP

CISP 300
Algorithm Design/Problem Solving
3 Units
Prerequisite: None.
Advisory: MATH 335
General Education: AA/AS Area II(b) (effective Summer 2015)
Course Transferable to UC/CSU
Hours: 54 hours LEC
This course teaches the programming logic behind every programming language. Topics include data management, the use of if statements and loops, and dividing an algorithm into several single purpose modules. This course is designed for Computer Science majors and students who want to create web, mobile, or database applications.
CISP 310
Assembly Language Programming for Microcomputers
4 Units
Prerequisite: CISP 360 with a grade of "C" or better
Course Transferable to UC/CSU
Hours: 54 hours LEC; 54 hours LAB
This course is an introduction to computer architecture using assembly language programs. Topics include: binary representation of data and instructions, memory addressing modes, subroutines and macros, operating system interrupts, processor architecture, and interfacing with high level languages. (C-ID COMP 142)
CISP 350
Database Programming
3 Units
Prerequisite: CISA 320 with a grade of "C" or better; and three units in any programming language.
General Education: AA/AS Area II(b)
Course Transferable to UC/CSU
Hours: 54 hours LEC
This is an introductory course in programming databases. Topics include analysis and design, modular programming, screen displays and menus, and multiple databases.
CISP 351
Introduction to Relational Database Design and SQL
3 Units
Prerequisite: None.
Course Transferable to CSU
Hours: 54 hours LEC
This course is designed to introduce relational database technology, normalization, entity relationships, logical model design, and ISO-ANSI standard Structured Query Language (SQL). Topics covered include: database design, basic properties of a relational database such as relations, tables, primary keys, foreign keys and principles of normalization, simple SQL select statements, sorting and grouping data, joining tables, subqueries and views. The course covers core concepts in identifying data and information management requirements for organizations, data modeling, and normalization techniques. The database design section focuses on logical model design and entity relationship (ER) modeling. The course exposes students to the use of Relational Database Management Systems using an industrial-strength database management system. Students will leave the course with a good working knowledge of database technology.
CISP 352
Intermediate SQL
3 Units
Prerequisite: None.
Advisory: CISP 351
Course Transferable to CSU
Hours: 54 hours LEC
This course builds upon the Introduction to Relational Databases and SQL course with more in-depth SQL constructs common to most commercial database products and extensions to the SQL language. Topics include: complex joins including inner and outer joins, correlated subqueries, complex table definition, table and column constraints, Union, Intersection, Minus, triggers, procedures and packages.
CISP 353
Application Development in a Client Server Environment
3 Units
Prerequisite: None.
Advisory: CISP 352
Course Transferable to CSU
Hours: 54 hours LEC
This course is designed for the intermediate level SQL programmer to design, create and deploy GUI applications that access relational database management systems. Topics include: GUI design fundamentals, data control and access methods (remote and local), creating datasets, implementing joins, transaction processing, multi-user data access, record locking, and deploying and installing applications on client workstations.
CISP 354
Introduction to Relational Database Administration
3 Units
Prerequisite: None.
Advisory: CISP 352
Course Transferable to CSU
Hours: 54 hours LEC
This course is designed to introduce students to administering a relational database management system. Topics include: managing users, privileges, resources, and tablespaces; creating an operational database, managing database files; how to start up and shut down an instance or database, the data dictionary, transaction processing, and backup and recovery issues. Completion will provide students with sufficient knowledge for an entry level Database Administration position in industry.
CISP 356
Relational Database Design and Information Retrieval
3 Units
Prerequisite: CISP 350 with a grade of "C" or better
Course Transferable to CSU
Hours: 54 hours LEC
This course is designed to serve as an advanced-level course within the Database Design certificate. The course covers advanced database concepts. Topics include: data analysis, principle data models with emphasis on the relational model, entity-relationship diagrams, logical design, data administration and normalization.
CISP 360
Introduction to Structured Programming
4 Units
Prerequisite: CISP 300 or MATH 400 with a grade of "C" or better, or equivalent skills demonstrated through the assessment process.
General Education: AA/AS Area II(b)
Course Transferable to UC/CSU
Hours: 54 hours LEC; 54 hours LAB
This course is an introduction to structured programming. Sample topics include typed variables and constants, operators, control structures, standard libraries, arrays, pointers, I/O with keyboard/monitor and files, and an introduction to objects. (C-ID COMP 112)
CISP 370
Beginning Visual Basic
4 Units
Prerequisite: None.
Advisory: CISC 310 or CISP 300
General Education: AA/AS Area II(b)
Course Transferable to UC/CSU
Hours: 54 hours LEC; 54 hours LAB
This course covers development of Windows-based desktop applications using VB.NET. Topics include best practices for GUI design, use of the Visual Studio .NET development software, organizing code into procedures and modules, calculation techniques, input data validation, file I/O, variable scope, arrays, multiple-window applications, and class development. This course is designed for students who want a strong foundation in building GUI applications and transfer MIS majors.
CISP 400
Object Oriented Programming with C++
4 Units
Prerequisite: CISP 360 with a grade of "C" or better
General Education: AA/AS Area II(b)
Course Transferable to UC/CSU
Hours: 54 hours LEC; 54 hours LAB
This course is an intermediate C++ course designed to further enhance the abilities of students to design and develop object-oriented programs. Included is an emphasis in higher level programming skills' development. Detailed information into class design and implementation, function templates, dynamic data allocation, pointers, strings, arrays, control structures, operator overloading, inheritance, virtual functions, polymorphism, data stream input and output, exception handling and file processing. (C-ID COMP 122)
CISP 401
Object Oriented Programming with Java
4 Units
Prerequisite: CISP 360 with a grade of "C" or better
Course Transferable to UC/CSU
Hours: 54 hours LEC; 54 hours LAB
This course is an introduction to object oriented programming using the Java language. The student will learn the Java programming language as well as the Java compiler. Topics will include: creating Java applications, writing Java applet, using the control statements, creating Java methods, declaring Java arrays, object-based programming, object-oriented programming: inheritance and polymorphism, handling strings and characters, controlling graphics by using graphics and Java 2D, generating graphics by using graphical user interface components, exception handling, multithreading, and managing files and streams handling.
CISP 402
Java - Data Handling
4 Units
Prerequisite: CISP 401 with a grade of "C" or better
Course Transferable to CSU
Hours: 54 hours LEC; 54 hours LAB
This course is an intermediate JAVA class. The student will enhance their knowledge in Java Application Program Interface (API) and programming skills. Topics will include Files and Streams, Networking, Multimedia (Images, Animation and Audio), Data Structures, Java Utilities Package and Bit Manipulation, Collections, Java Database Connectivity with JDBC, Servlets and JavaServer Pages (JSP).
CISP 403
Java - Smart Device Applications
4 Units
Prerequisite: CISP 402 with a grade of "C" or better
Course Transferable to CSU
Hours: 54 hours LEC; 54 hours LAB
This course covers Java Beans, J2ME, Security, and Advanced GUI and Web Services Topics. The student will learn Advanced Swing Graphical User Interface Components, Model-View-Controller, Graphics Programming with Java 2D and Java 3D, Java Beans Component Model, Security, advanced features of Java Database Connectivity (JDBC), Servlets, and JavaServer Pages(JSP), Java-Based Wireless Applications Development and J2ME, and Remote Method Invocation.
CISP 404
Java - Enterprise Applications
4 Units
Prerequisite: CISP 403 with a grade of "C" or better
Course Transferable to CSU
Hours: 54 hours LEC; 54 hours LAB
This course explores features of Enterprise JavaBeans(EJB) and Java 2 Platform, Enterprise Edition(J2EE). Students will gain knowledge of Session EJBs, Distributed Transactions, Entity EJBs, Messaging with JMS, Application Servers, Jini, JavaSpaces, JMX, Jiro, CORBA, Peer-to-Peer Applications, JXTA, Web Services, and SOAP, and apply these knowledge at an enterprise environment.
CISP 405
Object Oriented Programming using C# on Visual Studio .NET
4 Units
Prerequisite: CISP 400 with a grade of "C" or better
Course Transferable to UC/CSU
Hours: 54 hours LEC; 54 hours LAB
This course is an introduction to C# object oriented programming language on Visual Studio environment. Topics will include Visual Studio IDE, Constructors, Methods, Arrays, Inheritance, Polymorphism, Exception Handling, GUI, and Multithreading. This course is designed for students to understand the web base as well as system development capabilities of C#.
CISP 430
Data Structures
4 Units
Prerequisite: The student must have satisfactorily completed a course in intermediate programming in the language of the structures course being offered. For example: CISP 400 or CISP 401 with a grade of "C" or better.
Enrollment Limitation: The student must have satisfactorily completed a course in intermediate programming in the language of the structures course being offered. For example: CISP 409 or 400.
Course Transferable to UC/CSU
Hours: 54 hours LEC; 54 hours LAB
This course applies a case study approach which incorporates techniques for systematic problem analysis, program specification, design, coding, testing, debugging and documentation of large programs. Advanced language features related to strings, non-text files, pointers, recursion, and object-oriented programming methodology are covered. Data structures include stacks, queues, trees, lists, etc. Searching and sorting techniques are discussed. Consult the class schedule for specific topics. (C-ID COMP 132)
CISP 440
Discrete Structures for Computer Science
3 Units
Prerequisite: MATH 370 with a grade of "C" or better
Corequisite: CISP 430
Course Transferable to UC/CSU
Hours: 54 hours LEC
This course is an introduction to the discrete structures used in Computer Science with an emphasis on their applications. Topics covered include: counting methods, elementary formal logic and set theory, recursive programming and algorithm analysis, digital logic and combinational circuits, regular expressions, and finite state automata. (C-ID COMP 152)
CISP 499
Experimental Offering in Computer Information Science - Programming
.5-4 Units
Prerequisite: None
Course Transferable to CSU
See UC Limitations & Counselor
Hours: 18 hours LEC; 54 hours LAB