Computer Info Science - Program Course Descriptions
CISP 300
Algorithm Design/Problem Solving
3 Units
Prerequisite: None
Corequisite: CISC 310 with a grade of "C" or better (may be taken previously)
Course Transferable to UC/CSU
Hours: 54 hours LEC
This course is designed to assist the Computer Science major with the understanding of typical computer problems. Topics covered include assessing and analyzing computer problems in a top down, divide and conquer approach that leads to a programming solution. Students will create programming plans and detailed design documents from which source code versions of programs can be created.
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.
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 database. The topics include analysis and design, modular programming, screen displays and menus, and multiple databases. Students may receive three units credit for each topic offered. Consult the class schedule for specific topics. This course may be taken four times for credit.
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 database design section focuses on logical model design and entity relationship (ER) modeling. 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 370 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 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. The specific topics will change as the programming language changes. The course may be taken two times for credit using two different versions of the programming language.
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. The course may be taken three times with different versions of the Visual Basic language.
CISP 371
Intermediate Visual Basic
4 Units
Prerequisite: CISP 370 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 covers the .NET Framework classes including the ADO.NET and ASP.NET libraries. Topics include data files, programming with advanced controls, extending the .NET Framework classes using inheritance, collection-type classes, manipulation of database files with ADO.NET, and development of ASP.NET web applications and web services. This course may be taken up to three times for credit using different versions of Visual Basic.
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 students' abilities 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.
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: CISP400 or CISP409 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. Student may receive four units of credit for each topic offered. Consult the class schedule for specific topics. This course may be taken four times for credit. Note - As this course is a data structure course designed to further enhance the students' abilities to design and develop object-oriented programs, the programming language used in the course could be different. Repeating students will use different programming language from the programming language he/she previously used to complete the course.
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.
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