MAIN MENU

Computer Information Science

CISP Course Descriptions

Course Descriptions CISP

CISP 300 Algorithm Design/Problem Solving

Units: 3

Hours: 54 hours LEC

Prerequisite: MATH 120 with a grade of "C" or better, or equivalent skills demonstrated through the assessment process.

Transferable: CSU; UC

This course covers the foundational concepts of computer languages such as C++, SQL, Visual Basic, JavaScript, PHP, and C#. Students will learn what lies underneath desktop, web, mobile, and database applications. Students may petition for GE Area B5 credit after transfer to CSUS.

Student Learning Outcomes

Upon completion of this course, the student will be able to:

SLO #1: MANAGE DATA INVOLVED IN AN ALGORITHM

CISP 310 Assembly Language Programming for Microcomputers

Units: 4

Hours: 54 hours LEC; 54 hours LAB

Prerequisite: CISP 360 with a grade of "C" or better

Transferable: CSU; UC

CID: C-ID COMP 142

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.

Student Learning Outcomes

Upon completion of this course, the student will be able to:

SLO 1: RECOGNIZE THE COMPUTER ARCHITECTURE ISSUES NEEDED TO WRITE ASSEMBLY LANGUAGE CODE.

CISP 350 Database Programming

Units: 3

Hours: 54 hours LEC

Prerequisite: CISA 320 with a grade of "C" or better; and three units in any programming language.

Transferable: CSU; UC

This is an introductory course in programming databases. Topics include analysis and design, modular programming, screen displays and menus, and multiple databases.

Student Learning Outcomes

Upon completion of this course, the student will be able to:

IDENTIFY THE PURPOSE OF COMMON DATABASE LANGUAGES (SLO# 1)

CISP 351 Introduction to Relational Database Design and SQL

Units: 3

Hours: 54 hours LEC

Prerequisite: None.

Transferable: CSU

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.

Student Learning Outcomes

Upon completion of this course, the student will be able to:

SLO# 1: Demonstrate an understanding of basic Relational Database Management System terminology

CISP 352 Intermediate SQL

Units: 3

Hours: 54 hours LEC

Prerequisite: None.

Advisory: CISP 351

Transferable: CSU

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.

Student Learning Outcomes

Upon completion of this course, the student will be able to:

SLO# 1: Design, implement, and demonstrate an understanding of SQL constructs to include data definition language, data manipulation language, and data query language

CISP 353 Application Development in a Client Server Environment

Units: 3

Hours: 54 hours LEC

Prerequisite: None.

Advisory: CISP 352

Transferable: CSU

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.

Student Learning Outcomes

Upon completion of this course, the student will be able to:

SLO# 1: Design and develop robust Graphical User Interfaces (GUIs).

CISP 354 Introduction to Relational Database Administration

Units: 3

Hours: 54 hours LEC

Prerequisite: None.

Advisory: CISP 352

Transferable: CSU

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.

Student Learning Outcomes

Upon completion of this course, the student will be able to:

DESCRIBE NORMALIZATION OF DATA IN A DATABASE (SLO #01).

CISP 356 Relational Database Design and Information Retrieval

Units: 3

Hours: 54 hours LEC

Prerequisite: CISP 350 with a grade of "C" or better

Transferable: CSU

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.

Student Learning Outcomes

Upon completion of this course, the student will be able to:

SLO#1: assess and utilize knowledge of the scientific method in database design.

CISP 360 Introduction to Structured Programming

Units: 4

Hours: 54 hours LEC; 54 hours LAB

Prerequisite: CISP 300 or MATH 400 with a grade of "C" or better, or equivalent skills demonstrated through the assessment process.

Transferable: CSU; UC

CID: C-ID COMP 112

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.

Student Learning Outcomes

Upon completion of this course, the student will be able to:

SLO 1: DEMONSTRATE AN UNDERSTANDING OF STRUCTURED PROGRAMMING CONCEPTS

CISP 370 Beginning Visual Basic

Units: 4

Hours: 54 hours LEC; 54 hours LAB

Prerequisite: None.

Advisory: CISC 310 or CISP 300

Transferable: CSU; UC

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.

Student Learning Outcomes

Upon completion of this course, the student will be able to:

SLO #1: Design and develop robust Graphical User Interfaces (GUIs).

CISP 400 Object Oriented Programming with C++

Units: 4

Hours: 54 hours LEC; 54 hours LAB

Prerequisite: CISP 360 with a grade of "C" or better

Transferable: CSU; UC

CID: C-ID COMP 122

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. (C-ID COMP 122)

Student Learning Outcomes

Upon completion of this course, the student will be able to:

SLO #1: DEMONSTRATE AN UNDERSTANDING OF C++ OBJECT ORIENTED PROGRAMMING (OOP) CONCEPTS.

CISP 401 Object Oriented Programming with Java

Units: 4

Hours: 54 hours LEC; 54 hours LAB

Prerequisite: CISP 360 with a grade of "C" or better

Transferable: CSU; UC

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 applets, 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.

Student Learning Outcomes

Upon completion of this course, the student will be able to:

SLO #1: DISCOVER AND UNDERSTAND THE OBJECT ORIENTED JAVA PROGRAMMING CONCEPTS, KNOWLEDGE AND POTENTIALS.

CISP 402 Java - Data Handling

Units: 4

Hours: 54 hours LEC; 54 hours LAB

Prerequisite: CISP 401 with a grade of "C" or better

Transferable: CSU

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).

Student Learning Outcomes

Upon completion of this course, the student will be able to:

SLO #1: EMPLOY JAVA TO CREATE HIGHER LEVEL PROGRAMS.

CISP 405 Object Oriented Programming using C# on Visual Studio .NET

Units: 4

Hours: 54 hours LEC; 54 hours LAB

Prerequisite: CISP 400 or 401 with a grade of "C" or better, or equivalent skills demonstrated through the assessment process.

Transferable: CSU; UC

This course is an introduction to C# object-oriented programming language in a 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-based as well as system development capabilities of C#.

Student Learning Outcomes

Upon completion of this course, the student will be able to:

SLO #1: DISCOVER AND UNDERSTAND THE OBJECT ORIENTED C# PROGRAMMING CONCEPTS, KNOWLEDGE AND POTENTIALS.

CISP 430 Data Structures

Units: 4

Hours: 54 hours LEC; 54 hours LAB

Prerequisite: CISP 400 or CISP 401 with a grade of “C” or better or an equivalent level programming course in the programming language used in this course

Transferable: CSU; UC

CID: C-ID COMP 132

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. Data structures include stacks, queues, trees, lists, etc. Advanced language features related to strings, non-text files, pointers, recursion, and object-oriented programming methodology are covered. Searching and sorting techniques are discussed. Consult the class schedule for specific topics.

Student Learning Outcomes

Upon completion of this course, the student will be able to:

SLO #1: ANALYZE PROGRAMMING PROBLEMS AND DETERMINE WHAT OBJECT ORIENTED PROGRAMMING APPROACHES AND TOOLS WOULD BE MOST APPROPRIATE TO DEVELOP PROGRAMS TO RESOLVE THEM.

CISP 440 Discrete Structures for Computer Science

Units: 3

Hours: 54 hours LEC

Prerequisite: MATH 370 with a grade of "C" or better

Corequisite: CISP 430

Transferable: CSU; UC

CID: C-ID COMP 152

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.

Student Learning Outcomes

Upon completion of this course, the student will be able to:

Validate logical arguments within the context of computer computations. (SLO 1)