course descriptions

 

 

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 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 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 142

Advanced JAVA

3 UNITS - (A)
Prerequisite: CO SCI 141 with a satisfactory grade or better or equivalent.
This is a sequel to CO SCI 141.  It covers numerous topics beyond the introductory Java course.  Topics included are: (1) UML, (2) Multithreading, (3) Networking, (4) Exception handling, (5) Recursion, (6) Files & Streams, (7) JDBC, and (8) Generics.  This course will prepare a student to tackle the Sun Certified Java Programmer industry certification Exam.

 

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 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 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 198

PL/SQL Programming for Oracle

3 UNITS - (A)

Prerequisite: CO SCI 186 with a satisfactory grade or better or equivalent.
The Oracle PL/SQL language provides for programming logic features not contained within SQL.  The grammar, .syntax and benefits of using the PL/SQL language within an Oracle database environment are considered.  Create and manage user defined packages and Oracle supplied packages.  Create functions and procedures to encapsulate business functionality.  Enables skills to sit for Oracle Developer Certification.
 
COMPUTER SCIENCE/INFORMATION TECHNOLOGY 199

Oracle Forms and Reports

3 UNITS - (A)

Prerequisite: CO SCI 198 with a satisfactory grade or better or equivalent.
To enable the creation, manipulation, extraction of data from an Oracle database using the Oracle Forms & Reports Interfaces. The course takes you through creating basic forms and reports and enhancing them to create the basis of complex applications incorporating formatting techniques and images, logos and objects. This course will enable the student to take the Oracle developers exam.

 
Send mail to CsitWebMaster@lacitycollege.edu with questions or comments about this web site.