CISP 300    Algorithm Design/Problem Solving    3 Units

Prerequisite: None
Corequisite: CISC 310 (may be taken previously). Grade of "C" or better required to meet corequisite.
Course Transferable to UC/CSU
Hours: 54 hours LEC
Description: 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
Description: 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.

Schedule: Full Term, Jan 17-May 20
Microsoft Assembler (MASM)
MW           06:00PM-07:20PM   LEC   G.Chapman            CRC MAIN BS 145A     27936
MW           07:30PM-08:50PM   LAB   G.Chapman            CRC MAIN BS 145A     

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
Description: 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
Description: 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 353    Application Development in a Client Server Environment    3 Units

Prerequisite: None
Advisory: CISP 352
Course Transferable to CSU
Hours: 54 hours LEC
Description: 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 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
Description: 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: CISP 300 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
Description: 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. Grade of "C" or better required to meet prerequisite.
Course Transferable to UC/CSU
Hours: 72 hours LEC
Description: This course covers the VB.NET language, data file creation and manipulation, programming with advanced controls, manipulation of database files with a VB.NET front end, development of web applications and web services, and class design and the use of objects.

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: 72 hours LEC
Description: 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 or 370. Grade of "C" or better required to meet prerequisite.
Course Transferable to UC/CSU
Hours: 72 hours LEC
Description: This course is an introduction to object oriented programming using the JAVA language. The student will learn the JAVA programming language as well as a 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 JAVA2D, 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: 72 hours LEC
Description: 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 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 with a grade of "C" or better.
Course Transferable to UC/CSU
Hours: 72 hours LEC
Description: 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.