COMPUTER SCIENCE/INFORMATION TECHNOLOGY 100

Workshop Laboratory

1 UNIT -  (RPT 3) (A)

This course is designed to supplement and enhance learning experience in other computer-related courses by providing tutorial and self-help assistance with computers, programs, software, hardware and other learning aids.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 101

Introduction to Computers and Their Uses

4 UNITS -  (UC:CSU)

Advisory: English 21/73 or equivalent.

Credit not allowed if student has credit for CSIT 103.

A general computer literacy course open to all students. Presents computer hardware, software, terminology, ethics, and societal impact. Students will  overview operating systems, word processing, spreadsheets, database management systems, telecommunications, and networks.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 103

Introduction to Computer Systems for MIS

4 UNITS -  (UC:CSU)

Advisory: English 21/73 or equivalent.

An introduction to computers for a one-semester transfer course or for certificates or a degree in CSIT. Topics include computers, programming and systems design, programming languages and flowcharting. Laboratory includes word processing, spreadsheets, database concepts and extensive programming in BASIC.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 104

Mathematics for Programmers

3 UNITS -  (CSU)

Advisory: CSIT 103 or equivalent.

Development of the specialized mathematical concepts necessary for writing computer programs, including the internal representation of numeric data, logical operators, set theory, vector and matrix operations, and linear equations.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 106

Beginning PASCAL Programming

4 UNITS -  (UC:CSU) (CAN CSCI 12)

Advisory: CSIT 103 or equivalent.

Introduces the  PASCAL programming language instructions and structure. Increasingly complex programs are designed and written in PASCAL by the students.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 107

Programming Logic

3 UNITS -  (UC:CSU)

Prerequisite: CSIT 103 with a satisfactory grade or better or equivalent.

Advisory: Mathematics 125 or equivalent.

Introduces the discipline of computer science using a high level language; provides an overview of computer organization and an introduction to software engineering. Includes program design, development, style, testing, documentation, algorithms, control structures, sub-programs, and elementary data structures. 

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 108

Beginning Basic Programming

3 UNITS -  (UC:CSU)

Prerequisite: CSIT 101 with a satisfactory grade or better or equivalent.

A beginning programming course in the Visual Basic Programming Language.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 115   Beginning COBOL Programming 

4 UNITS -  (UC:CSU)

Prerequisite: CSIT 103 with a satisfactory grade or better or equivalent.

An introduction to the ANSI COBOL programming language.  The effective and efficient use of ANSI COBOL in writing business programs.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 117   Beginning Micro Assembly Language

4 UNITS -  (UC:CSU)

This course introduces the student to symbolic programming languages and their application as diagnostic tools. The skills of writing and using programs will be stressed. Emphasis is placed on the use of diagnostic programs which can be used to trouble shoot and isolate computer problems.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 133

Microcomputer Data Base Programming

3 UNITS -  (CSU)

Prerequisite: CSIT 103 with a satisfactory grade or better or equivalent.

This course focuses on the essential principles and concepts of a microcomputer data base environment. A comprehensive examination of the functions of a data base command language is included.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 134 Operating Systems

3 UNITS -  (CSU)

Prerequisite: CSIT 101 or 103 with a satisfactory grade or better or equivalent.

Fundamental principles functions, application and use of operating systems such as DOS, UNIX, Windows 98/NT/2000, and Netinase and related applications software. Analysis of capabilities and limitations of the different operating systems and environments. Applicable to A+ certification software preparation.     

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 136

Introduction to Data Structures

3 UNITS -  (UC:CSU)

Prerequisite: CSIT 140 with a satisfactory grade or better or equivalent.

Principles and applications of data structures. Design implementation, and analysis of algorithms to manipulate arrays, lists, stacks, guesses, trees, graphs, and other objects. Examination of sorting and searching methods. Recursive and object-oriented programming techniques.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 138

Advanced Basic Programming

3 UNITS -  (UC:CSU)

Prerequisite: CSIT 108 with a satisfactory grade or better or equivalent.

An advanced programming course in the Visual Basic programming language with objects, classes, active X topics, and the Windows API.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 139

Programming in C

3 UNITS -  (UC:CSU)

Prerequisite: CSIT 104 and CSIT 107 with satisfactory grades or better or equivalent.

The course provides students the ability to write computer programs in a language used by professional programmers and software developers.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 140

Programming in C++

3 UNITS - (UC:CSU)

Prerequisite: CSIT 139 with a satisfactory grade or better or equivalent.

This course addresses class construct, an extension of C Structure. The course emphasizes superiority of C++ to C as a general purpose programming language because of its new features and C++ as an object oriented programming language.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 141

Programming in JAVA

3 UNITS - (UC:CSU)

Prerequisite: CSIT 101 or CSIT 103 with a satisfactory grade or better or equivalent.

Advisory: CSIT 107 and CSIT 104.

An introductory university-level course of a leading-edge programming paradigm object-oriented programming that is truly portable and therefore appropriate for implementing internet-based and World-Wide Web based applications.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 144

Practical Extraction and Report Language (PERL)

3 UNITS - (UC:CSU)

Prerequisite: CSIT 158 with a satisfactory grade or better or equivalent.

An introductory university-level course in Practical Extraction and Report Language (PERL), a standard tool for UNIX server administration and server side support of interactive World Wide Web pages.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 145

Advanced COBOL PROGRAMMING

4 UNITS -  (UC:CSU)

Prerequisites: CSIT 115 with a satisfactory grade or better or equivalent.

This course is a continuation of CSIT 115 Beginning COBOL Programming. Topics include the “Sort” feature, the “Search” feature, LINKAGE section, and advanced file handling techniques.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 148

Advanced Spreadsheet Applications

3 UNITS -  (CSU)

Prerequisite: CSIT 101 or 103 with a satisfactory grade or better or equivalent.

A course in advanced spreadsheet operations, including macro development, macrologic, printing enhancements and spreadsheet systems development.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 151

Macromedia Dreamweaver

3 UNITS -  (A)

Prerequisite: CSIT 101 and CSIT 103 with a satisfactory grade or better or equivalent.

This course provides an extensive practical and theoretical framework for using Macromedia’s Dreamweaver to develop web sites. It includes enhancements for web page layout, coding, and webmaster-user interactivity.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 152 Macromedia Flash

3 UNITS -  (A)

Prerequisite: CSIT 151 with a satisfactory grade or better or equivalent.

This course covers Macromedia’s Flash; a state-of-the-art Web animation software for creating highly compact, vector-based content for transmission over the Internet.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 153 Macromedia Director

3 UNITS -  (A)

Prerequisite: CSIT 151 with a satisfactory grade or better or equivalent.

This course is designed for multimedia webmasters interested in learning Macromedia Director to develop web-based Shockwave projects, create interactive learning modules, design interactive kiosks and catalogs, program with Lingo, and create animated presentations and projects.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 154

Macromedia Authorware

3 UNITS -  (A)

Prerequisite: CSIT 151 with a satisfactory grade or better or equivalent.

This course is designed for individuals interested in creating educational and professional modules using Authorware 5 Attain, Macromedia’s leading application for creating visually-rich media for the web and online learning.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 155

Electronic Commerce (E-Commerce) Technologies

3 UNITS -  (A)

Prerequisite: CSIT 101 and CSIT 103 with satisfactory grades or better or equivalent.

This course offers hands-on experience in designing and implementing business-to-consumer and business-to-business web commerce sites.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 156

XML Programming

3 UNITS -  (CSU)

Prerequisite: CSIT 158 with a satisfactory grade or better or equivalent.

This course offers hands-on experience in designing and programming XML documents that enable the structured delivery of data and information over a corporate intranet, the internet, or for simple XML messaging between HTTP servers. The course also provide skills to build business-to-business E-commerce applications. 

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 157

Internet 

3 UNITS -  (CSU)

Prerequisite: CSIT 101 or CSIT 103 with a satisfactory grade or better or equivalent.

Prepares students to transact business on the Internet. Content includes communications devices and protocols, script development, business communications, marketing, and research using Internet resources including e-mail, Usenet News groups, www, Gopher, Wais, Telnet FTP, Archie, and future Internet development.ddç8

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 158

Hyper-Text Markup Language (HTML)

3 UNITS -  (UC:CSU)

Prerequisite: CSIT 101 with a satisfactory grade or better or equivalent.

Covers Hyper-Text Makeup Language, including formatting concepts of hypermedia composition, lists, tables, graphics, maps, frames, forms and form processing. CGI, web site management, and an overview of more advanced features.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 159

Web Projects

3 UNITS - (CSU) (RPT 2)

Prerequisite: CSIT 158 with a satisfactory grade or better or equivalent.

Covers more complex topics in rapidly changing technology of web pages construction including multimedia developments, plug-ins, helper applications, CSS, DHTML and new developments. Students will complete web projects with emphasis placed upon recent developments in students and software.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 160

Business Systems Design

3 UNITS -  (CSU)

This course covers the fundamentals of business systems analysis and design. It defines the core of the systems analyst, and describes experience in screen and form design, implementation and project management.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 167

Microcomputer Operating Environemtns - Windows

3 UNITS - (CSU)

Prerequisite: CSIT 101 or 103 and CSIT 134 with satisfactory grades or better or equivalent.

Advanced course focusing on graphical user interface theory and operating system environment maintenance, contrasting DOS interface with graphical user interface, reviewing DOS fundamentals, introducing Windows applications use and installation and covering communications, macro generation, object embedding, memory management and network configurations.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 168

The UNIX Operating System

3 UNITS - (CSU)

Prerequisite: CSIT 101 with a satisfactory grade or better or equivalent.

Covers basic features of the UNIX operating system including commands and concepts for running, application handling files, directories, permissions, networking, and scripting.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 169

Apache Web Server

3 UNITS - (CSU)

Prerequisite: CSIT 168 with a satisfactory grade or better or equivalent.

A course covering the tasks involved in administering an Internet web server running Apache web server software under UNIX.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 181

Computer Networking I - CISCO

3 UNITS -  (CSU)

Advisory:  Eligibility for English 28/31 or equivalent.

This course covers fundamentals of computer networking.  Topics include evolution of networking, seven layers of the OSI reference model, and networking devices such as bridges, hubs, switches, and routers.  Internet protocol, IP addressing, subnetting, network topology, and cabling will also be covered.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 182

Computer Networking II - CISCO

3 UNITS -  (CSU)

Prerequisite:  CSIT 181 with a satisfactory grade or better or equivalent.

This course covers a wide area of internetworking fundamentals. Topics include router fundamentals, router setup and configuration, network management, routing and routed protocols, and network troubleshooting.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 183

Computer Networking III - CISCO

3 UNITS - (A)

Prerequisite: CSIT 182 with a satisfactory grade or better or equivalent.

This course covers routers configuration for various industry standard protocols. Topics include segmentation of LAN’s using bridge, routers and switches. Virtual LAN”s (Local Area Network), Fast Ethernet, cut-through and store-and-forward LAC switching are also discussed.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 184

Computer Networking IV - CISCO

3 UNITS - (A)

Prerequisite: CSIT 183 with a satisfactory grade or better or equivalent.

This course covers Wide Area Network design and configuration. Various techniques and terms used to configure Wide Area Network include Frame Relay, ISDN (type of A network connection), and Point-to-Point protocol are discussed.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 186

Introduction to Oracle: SQL and PL/SQL

4 UNITS - (A)

An extensive introduction to data server technology. The class covers the concepts of both relational and object relational database and the powerful SQL and PL/SQL programming languages. Students are taught to create and maintain database objects and to store, retrieve, and manipulate data.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 187

Oracle DBA (Database Administration) Part 1A: Architecture and Administration

4 UNITS - (A)

Prerequisite: CSIT 186 with a satisfactory grade or better or equivalent.

This course is designed to give the students a firm foundation in basic administrative tasks and the necessary knowledge and skills to set up, maintain, and troubleshoot an oracle database. The students learn to use an administration tool to startup and shutdown a database, manage file and database storage, and manage users and their privileges.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 188

Oracle DBA (Database Administration) Part 1B:

Backup and Recovery

3 UNITS - (A)

Prerequisite: CSIT 187 with a satisfactory grade or better or equivalent.

This course focuses on planning and implementing database backup and recovery strategies. The class addresses backup and recovery techniques and examines various database backup, failure, restore and recovery scenarios. In hands-on exercises, students examine backup methodologies based on mission critical requirements of business enterprises.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 189

Oracle DBA (Database Administration) Part 2:

Performance and Tuning

3 UNITS - (A)

Prerequisite: CSIT 187 with a satisfactory grade or better or equivalent.

This course will introduce students to a series of tuning steps which can be used to improve the performance of the Oracle Server. The focus is on database rather than specific operating system performance issues. Using a variety of tools, students also learn how to recognize, troubleshoot and resolve common performance related problems in administering an Oracle database.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 191

Programming Laboratory

1 UNIT -  (RPT 3) (A)

Co-rerequisite:  Concurrent enrollment in any CSIT course other than CSIT 100, 191, 192.

This is a programming laboratory is designed to provide the student an opportunity to apply the computer concepts being studied in a concurrent CSIT lecture/discussion class section.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 192

Programming Laboratory

1 UNIT -  (RPT 3) (A)

Prerequisite: Open to students who have repeated CSIT 191 three times.

Co-rerequisite:  Concurrent enrollment in any CSIT course other than CSIT 100, 191, 192.

This is a programming laboratory is designed to provide the student an opportunity to apply the computer concepts being studied in a concurrent CSIT lecture/discussion class section.

COMPUTER SCIENCE 195

Computer Networking V:CCNP Cisco Networking Academy Program, Advanced Routing

Corrections Institutions

3 UNITS -  (A)

Prerequisite: CO SCI 184  with a satisfactory grade or better or equivalent.

This course covers configuration of various routing protocols that include Open Shortest Pass First (OSPF), Enhanced Interior Gateway Routing Protocol (EIGRP), and Border Gateway Protocol (BGP).  Route optimization and security are also discussed.  This course also provides students with the knowledge and skills to pass the CCNP Routing Exam and further the students’ career opportunities in computer networking. 

COMPUTER SCIENCE 196

Computer Networking VI:CCNP Cisco Networking Academy Program, Remote Access

3 UNITS -  (A)

Prerequisite: CO SCI 195 with a satisfactory grade or better or equivalent.

This course will provide students with an overview of remote access technologies and their relationship to the Cisco Internet network Operating System.

COMPUTER SCIENCE 197

Computer Networking VII: CCNP Cisco networking Academy Program, Switching

3 UNITS -  (A)

Prerequisite: CO SCI 195 with a satisfactory grade or better or equivalent.

This course covers all the major topics on the Cisco Switching exam, including switched Ethernet, trunking, multicasting, multilayer switching, Virtual Local Area Networks (VLANs), inter VLAN routing, Hot Standby Routing Protocol, network traffic control, monitoring, and troubleshooting techniques.