CISP 300    Algorithm Design/Problem Solving    3 Units

Prerequisite: CISC 310. Grade of "C" or better required to meet prerequisite.
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 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 (E-R) modeling. Students will leave the course with a good working knowledge of database technology. This course may be taken three times for credit using different Relational Database Management System software such as Oracle, SQL Server or MySQL.

Schedule: Eight Week - First, Aug 22-Oct 16
MySQL
T            07:00PM-10:05PM   LEC   D.Cooper             FLC MAIN FL1 104     24184
MySQL
TBA          TBA               LEC   D.Cooper             FLC MAIN FLC ONLINE  24184
This is a hybrid course in which approximately one-half of the class is online. The class will meet on campus once a week during the times listed above.

CISP 352    Intermediate SQL    3 Units

Prerequisite: None.
Advisory: CISP 351
Course Transferable to CSU
Hours: 54 hours LEC
Description: This course builds upon the Introduction to Relational Databases and Structured Query Language (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, and table and column constraints, union, intersection, minus, triggers, procedures and functions.

Schedule: Eight Week - Second, Oct 17-Dec 11
MySQL
T            07:00PM-10:05PM   LEC   D.Cooper             FLC MAIN FL1 104     23960
MySQL
TBA          TBA               LEC   D.Cooper             FLC MAIN FLC ONLINE  23960
This is a hybrid course in which approximately one-half of the class is online. The class will meet on campus once a week during the times listed above.

CISP 360    Introduction to Structured Programming    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: 72 hours LEC
Description: This course is an introduction to structured programming. The topics covered include: top-down design, input/output considerations, control structures and flow control, variables, constants, the use of libraries, simple to intermediate data structures, functions, and arguments. An introduction into objects will be included.

CISP 370    Beginning Visual Basic    4 Units

Prerequisite: CISP 300 with a grade of "C" or better
Course Transferable to UC/CSU
Hours: 72 hours LEC
Description: This course is an introduction to the Visual Basic programming language. Students will design Console and Graphical User Interface programs for the Windows environment. Topics include control structures such as simple sequence, decisions, and iteration, procedures events, properties, error handling, form handling, and the use of typical controls such as buttons, textboxes, checkboxes, and listboxes. This course will provide students with a foundation in the use of objects, object libraries, and object-oriented-event-driven programming techniques.

CISP 430    Data Structures    4 Units

Prerequisite: CISP 360
Advisory: CISP 400
Course Transferable to UC/CSU
Hours: 72 hours LEC
Description: This is a course in data structures for computer science. Topics include time complexity analysis and big-O notation, recursion, searching and sorting, linked lists, stacks, queues, priority queues, binary trees, B-trees, graphs, hashing, and basic encryption algorithms.

Schedule: Full Term, Aug 22-Dec 17
Th           06:00PM-07:40PM   LEC   D.Ross               FLC MAIN FL5 11      31422
TBA          TBA               LEC   D.Ross               FLC MAIN FLC ONLINE  31422
This is a hybrid course in which approximately one-half of the class is online. The class will meet on campus once a week during the times listed above.