Computer Science - Information Technology

NOTE: The official abbreviation for Computer Science/Information Technology (CSIT) is “CO SCI”. If you have a talent for math and science our programs will prepare you to enter more advanced university programs or directly enter careers related to Computer and Information Systems,System Analysis, Computer Science, Database Administration, Computer Operations, Information Processing Services, Computer Software

Engineering, Telecommunications, and Web Development and Technologies. According to the Department of Labor median hourly earnings for high demand occupations in technology and other computer fields at the entry levels range from nearly $12/hour to $26/hour. With advance training and or a Bachelors degree, salaries can exceed $42/ hour.

COURSES UNITS

First Semester

CO SCI 104..............................................................................................3

CO SCI 107..............................................................................................3

(CO SCI 103 is a prerequisite to required CO SCI courses

and can be used to fulfill a general education requirement)

CO SCI 134..............................................................................................3

CO SCI 139..............................................................................................3

Physics 1..................................................................................................4

Math 261..................................................................................................5

CO SCI 140 or 141.................................................................................3

CO SCI 186..............................................................................................3

Philosophy 7, 8, or 9...............................................................................3

CO SCI 136..............................................................................................3

CO SCI 158..............................................................................................3

Total Major Units................................................................................24

Note: On approval by the Computer Science/Information Technology disci-pline, students may use Math 262, 263 and Physics 2, 3 as substitute to anyof the CO SCI requirements except CO SCI 139, CO SCI 140 (or 141), andCO SCI 136 as long as a minimum of 18 CO SCI units is met.To complete general education requirements in this area of study,Plan A for the AA/AS Degree is required.

PLAN A: Please consult with a counselor about specific courses needed or see the college catalog"Graduation Requirements" section. Plan A is designed for transfer to a four-year college or univer-sity. However, requirements vary depending upon the individual institution. Please consult with acounselor for the specific requirements of the university you plan to attend.

(Math 115 or higher or passing score on Los Angeles Community College District Math competencyexam)

CO SCI 104..............................................................................................3

CO SCI 107..............................................................................................3

CO SCI 134..............................................................................................3

CO SCI 139 or 141..................................................................................3

CO SCI 158..............................................................................................3

CO SCI 181..............................................................................................3

CO SCI 136..............................................................................................3

CO SCI 156..............................................................................................3

CO SCI 182..............................................................................................3

CO SCI 186..............................................................................................3

CO SCI 138, 140, or 142.........................................................................3

CO SCI 187..............................................................................................3

CO SCI 167..............................................................................................3

CO SCI 168..............................................................................................3

Total Major Units..................................................................................36

To complete general education requirements in this area of study, Plan B for the AA/ASDegree is required.

PLAN B: Please consult with a counselor about specific courses needed or see the college catalog"Graduation Requirements" section. Plan B is not designed for transfer to a four-year college.

Certificates in Computer Science-Information technology will be issued bythe Computer Science/Information Technology discipline upon application tothe department by the student and successful completion of one or more ofthe following sequences.

This sequence of courses prepares students for careers in applications soft-ware development and usage in fields related to databases, networking, webtechnologies, business analysis, and/or programming. Students success-fully completing this program will find opportunities for employment in variousindustries depending on the track chosen for the electives.

COURSES UNITS

CO SCI 103 or 101 and 108.................................................................4-7

CO SCI 104..............................................................................................3

CO SCI 107..............................................................................................3

CO SCI 134..............................................................................................3

CO SCI 138..............................................................................................3

CO SCI 148..............................................................................................3

CO SCI 186..............................................................................................3

Electives...................................................................................................6

Total Units........................................................................................28-31

This course sequence provides students with comprehensive training in high-demand programming languages and tools such as Visual Basic, C++, Java,Perl, XML, ASP, and others. Students can choose electives from three excit-ing tracks: Databases, Web Development, and Operating Systems. Successfulcompletion of the program will prepare students for an exciting career in soft-ware analysis, design, and development.

COURSES UNITS

CO SCI 103 or 101 and 108.................................................................4-7

CO SCI 104..............................................................................................3

CO SCI 107..............................................................................................3

CO SCI 134..............................................................................................3

CO SCI 136..............................................................................................3

CO SCI 138..............................................................................................3

CO SCI 139 or 141..................................................................................3

CO SCI 140 or 142..................................................................................3

CO SCI 186..............................................................................................3

Electives...................................................................................................9

Total..................................................................................................37-40

This course sequence offers state of the art hands-on training in designing,configuring, and maintaining basic networks using Cisco routers and switches.The program also prepares students for the Cisco Certified Networking Asso-ciate (CCNA) exam.

CO SCI 181..............................................................................................3

CO SCI 182..............................................................................................3

CO SCI 183..............................................................................................3

CO SCI 184..............................................................................................3

Total Units............................................................................................ 12

This course sequence offers state of the art hands-on training in setting upand administering Oracle relational databases and prepares students for theOracle professional certification in database administration.

COURSES UNITS

CO SCI 186............................................................................................. 3

CO SCI 187..............................................................................................3

CO SCI 188............................................................................................. 3

CO SCI 189..............................................................................................3

Total Units.............................................................................................12

Use Oracle Developer Suite 10g and deploy applications on the Web withOracle Application Server 10g. The students learn how to build forms andreports and use the web to access them.

This program provides hands-on training in the use of UNIX and WINDOWS operating systems and prepares students for Microsoft Certificate Professional(MCP) examination.

CO SCI 134..............................................................................................3

CO SCI 167..............................................................................................3

CO SCI 168............................................................................................. 3

CO SCI 169..............................................................................................3

Total Units.............................................................................................12

The UNIX operating system is very widely used in education, business, sci-ence, and industry both in servers and in desktop applications. Almost 70%of the Internet’s World-Wide Web servers are driven by some version ofUNIX or LINUX. UNIX is used in specialty desktop systems that require com-plex graphics or scientific processing. In servers, UNIX supports web ser-vices, database systems, advanced scientific computing, and vast commu-nications networks. UNIX can be used in cluster systems requiring thou-sands of processors or in small embedded systems involved in simple ro-botic applications. It is the system of choice for the vast majority of universityapplications.

COURSES UNITS

CO SCI 144..............................................................................................3

CO SCI 158..............................................................................................3

CO SCI 168..............................................................................................3

CO SCI 169............................................................................................. 3

CO SCI 170..............................................................................................3

CO SCI 171..............................................................................................3

Total Units.............................................................................................18

Program provides training in the use of client-side web technologies for de-sign and development of interactive web sites. Skills include use of HTML,DHTML, XML, Java, Java Script, Dreamweaver and Flash in web site devel-opment.

COURSES UNITS

CO SCI 141............................................................................................. 3

CO SCI 151..............................................................................................3

CO SCI 152..............................................................................................3

CO SCI 156..............................................................................................3

CO SCI 158............................................................................................. 3

Total Units............................................................................................ 15

The Web Server Technologies program provides training in the use of server-side web technologies for the design and development of E-Commerce websites. These include the use of CGI scripts, Active Server Pages, and Data-base Servers to create realistic e-commerce sites. Server-side conceptsrelated to the Windows and Unix operating systems are covered. Studentswill also get introduction to the Oracle’s database technology and how todevelop dynamic, interactive and scalable database-driven Web applica-tions.

CO SCI 134..............................................................................................3

CO SCI 155..............................................................................................3

CO SCI 159..............................................................................................3

CO SCI 167 or 168..................................................................................3

CO SCI 158..............................................................................................3

Total Units.............................................................................................15

NOTE: Not every class is offered each semester. Refer to the current classschedule for current class offerings.PREREQUISITES: Specified prerequisites must be completed with a satis-factory grade or equivalent.

The official abbreviation for Computer Science/Information Technology (CSIT)is “CO SCI”.

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

Credit not allowed if student has credit for CO SCI 103.A general computer literacy course open to all students. Presents computerhardware, software, terminology, ethics, and societal impact. Students willoverview operating systems, word processing, spreadsheets, database man-agement systems, telecommunications, and networks.

Advisory: English 73.An introduction to computers for a one-semester transfer course or for cer-tificates or a degree in CSIT. Topics include computers, programming andsystems design, programming languages and flowcharting. Laboratory in-cludes word processing, spreadsheets, database concepts and extensiveprogramming in BASIC.

Advisory: CO SCI 103 or equivalent.Development of the specialized mathematical concepts necessary for writ-ing computer programs, including the internal representation of numeric data,logical operators, set theory, vector and matrix operations, and linear equations.

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

Prerequisite: CO SCI 101 with a satisfactory grade or better or equivalent.A beginning programming course in the Visual Basic Programming Language.

Prerequisite: CO SCI 103 with a satisfactory grade or better or equivalent.This course focuses on the essential principles and concepts of a micro-computer data base environment. A comprehensive examination of the functions of a data base command language is included.

Prerequisite: CO SCI 101 or 103 with a satisfactory grade or better orequivalent.

Fundamental principles functions, application and use of operating sys-tems such as DOS, UNIX, Windows 98/NT/2000, and Netinase and re-lated applications software. Analysis of capabilities and limitations of thedifferent operating systems and environments. Applicable to A+ certifica-tion software preparation.

Prerequisite: CO SCI 140 with a satisfactory grade or better or equivalent.Principles and applications of data structures. Design implementation, andanalysis of algorithms to manipulate arrays, lists, stacks, queues, trees,graphs, and other objects. Examination of sorting and searching methods.Recursive and object-oriented programming techniques.

Prerequisite: CO SCI 108 with a satisfactory grade or better or equivalent.An advanced programming course in the Visual Basic .Net programminglanguage with objects, classes, exception handling, GUI, DBMS, SQL, ASP.NET, Data Structures, and Recursion.

Prerequisite: CO SCI 104 and CO SCI 107 with satisfactory grades or bet-ter or equivalent.The course provides students the ability to write computer programs in alanguage used by professional programmers and software developers.

Prerequisite: CO SCI 139 with a satisfactory grade or better or equivalent.This course addresses class construct, an extension of C Structure. Thecourse emphasizes superiority of C++ to C as a general purpose program-ming language because of its new features and C++ as an object orientedprogramming language.

Prerequisite: CO SCI 101 or CO SCI 103 with a satisfactory grade or betteror equivalent.Advisory: CO SCI 107 and CO SCI 104.An introductory university-level course of a leading-edge programming para-digm object-oriented programming that is truly portable and therefore ap-propriate for implementing internet-based and World-Wide Web based ap-plications.

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 theintroductory 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 tacklethe Sun Certified Java Programmer industry certification Exam.

Prerequisite: CO SCI 158 with a satisfactory grade or better or equivalent.An introductory university-level course in Practical Extraction and ReportLanguage (PERL), a standard tool for UNIX server administration and serverside support of interactive World Wide Web pages.

Prerequisite: CO SCI 101 or 103 with a satisfactory grade or better or equiva-lent.A course in advanced spreadsheet operations, including nested functions,data tables, exporting/importing data, what-if analysis, macro development,macrologic, printing enhancements and spreadsheet systems development.

Advisory: CO SCI 103 or CO SCI 108 with a satisfactory grade or better orequivalent.This course provides an extensive practical and theoretical framework forusing Macromedia’s Dreamweaver to develop web sites. It includes en-hancements for web page layout, coding, and webmaster-user interactivity.

Advisory: CO SCI 151 with a satisfactory grade or better or equivalent.This course covers Macromedia’s Flash; a state-of-the-art Web animationsoftware for creating highly compact, vector-based content for transmis-sion over the Internet. Topics include introduction to ActionScript, EventHandlers, objects and Dynamic Data.

Prerequisite: CO SCI 101 and CO SCI 103 with satisfactory grades or bet-ter or equivalent.

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

Prerequisite: CO SCI 158 with a satisfactory grade or better or equivalent.This course offers hands-on experience in designing and programming XMLdocuments that enable the structured delivery of data and information overa corporate intranet, the internet, or for simple XML messaging betweenHTTP servers. The course also provide skills to build business-to-busi-ness E-commerce applications.

Prerequisite: CO SCI 101 with a satisfactory grade or better or equivalent.Covers Hyper-Text Makeup Language, including formatting concepts ofhypermedia composition, lists, tables, graphics, maps, frames, forms andform processing. CGI, web site management, and an overview of moreadvanced features.

Prerequisite: CO SCI 158 with a satisfactory grade or better or equivalent.Covers more complex topics in rapidly changing technology of web pagesconstruction including multimedia developments, plug-ins, helper applica-tions, CSS, DHTML and new developments. Students will complete webprojects with emphasis placed upon recent developments in students andsoftware.

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

Prerequisite: CO SCI 101 or 103 and CO SCI 134 with satisfactory gradesor better or equivalent.Advanced course focusing on graphical user interface theory and operat-ing system environment maintenance, contrasting DOS interface withgraphical user interface, reviewing DOS fundamentals, introducing Win-dows applications use and installation and covering communications, macrogeneration, object embedding, memory management and network configu-rations.

Prerequisite: CO SCI 101 with a satisfactory grade or better or equivalent.Covers basic features of the UNIX operating system including commandsand concepts for running, application handling files, directories, permissions,networking, and scripting.

Prerequisite: CO SCI 168 with a satisfactory grade or better or equivalent.A course covering the tasks involved in administering an Internet web serverrunning Apache web server software under UNIX.

Covers advanced topics in UNIX system administration including user ad-dition and management, system disk drive installation and preparation,application installation, network installation and configuration, printer at-tachment, booth procedures and scripting, and management of event log-ging. The student builds a UNIX server from scratch and configures it torequired specifications.

Covers both theoretical and practical aspects of UNIX system security, in-cluding UNIX password systems, file system hardening, crytography basics,physical security for hardware, protocol security, network authenticationmethods, secure programming and account defense.

Prerequisites: CO SCI 101 or 103 with a satisfactory grade or better or equiva-lent.This course covers fundamentals of computer networking. Topics includeevolution of networking, seven layers of the OSI reference model, and net-working devices such as bridges, hubs, switches, and routers. Internet pro-tocol, IP addressing, subnetting, network topology, and cabling will also becovered.

Prerequisite: CO SCI 181 with a satisfactory grade or better or equivalent.This course covers a wide area of internetworking fundamentals. Topics in-clude router fundamentals, router setup and configuration, network man-agement, routing and routed protocols, and network troubleshooting.

Prerequisite: CO SCI 182 with a satisfactory grade or better or equivalent.This course covers routers configuration for various industry standard proto-cols. 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.

Prerequisite: CO SCI 183 with a satisfactory grade or better or equivalent.This course covers Wide Area Network design and configuration. Varioustechniques and terms used to configure Wide Area Network include FrameRelay, ISDN (type of A network connection), and Point-to-Point protocol arediscussed.

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

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

Prerequisite: CO SCI 186 with a satisfactory grade or better or equivalent.This course is designed to give the students a firm foundation in basic ad-ministrative tasks and the necessary knowledge and skills to set up, main-tain, and troubleshoot an oracle database. The students learn to use anadministration tool to startup and shutdown a database, manage file anddatabase storage, and manage users and their privileges.

Prerequisite: CO SCI 187 with a satisfactory grade or better or equivalent.This course focuses on planning and implementing database backup andrecovery strategies. The class addresses backup and recovery techniquesand examines various database backup, failure, restore and recovery sce-narios. In hands-on exercises, students examine backup methodologiesbased on mission critical requirements of business enterprises.

Prerequisite: CO SCI 187 with a satisfactory grade or better or equivalent.This course will introduce students to a series of tuning steps, which can beused to improve the performance of the Oracle Server. The focus is on data-base rather than specific operating system performance issues. Using a va-riety of tools, students also learn how to recognize, troubleshoot and resolvecommon performance related problems in administering an Oracle database.

Co-requisite: Concurrent enrollment in any CSIT course other than CO SCI100, 191, 192. This is a programming laboratory is designed to provide thestudent an opportunity to apply the computer concepts being studied in aconcurrent CSIT lecture/discussion class section.

Prerequisite: Open to students who have repeated CO SCI 191 three times.Co-requisite: Concurrent enrollment in any CSIT course other than CO SCI100, 191, 192.This is a programming laboratory is designed to provide the student an op-portunity to apply the computer concepts being studied in a concurrent CSITlecture/discussion class section.

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

Prerequisite: CO SCI 184 with a satisfactory grade or better or equivalent.This course covers configuration of various routing protocols that includeOpen Shortest Pass First (OSPF), Enhanced Interior Gateway Routing Pro-tocol (EIGRP), and Border Gateway Protocol (BGP). Route optimizationand security are also discussed. This course also provides students withthe knowledge and skills to pass the CCNP Routing Exam and further thestudents’ career opportunities in computer networking.

Prerequisite: CO SCI 195 with a satisfactory grade or better or equivalent.This course will provide students with an overview of remote access tech-nologies and their relationship to the Cisco Internet network Operating Sys-tem.

Prerequisite: CO SCI 195 with a satisfactory grade or better or equivalent.This course covers all the major topics on the Cisco Switching exam, includ-ing switched Ethernet, trunking, multicasting, multilayer switching, VirtualLocal Area Networks (VLANs), inter VLAN routing, Hot Standby Routing Pro-tocol, network traffic control, monitoring, and troubleshooting techniques.

Prerequisite: CO SCI 186 with a satisfactory grade or better or equivalent.The Oracle PL/SQL language provides for programming logic features notcontained within SQL. The grammar, .syntax and benefits of using the PL/SQL language within an Oracle database environment are considered. Cre-ate 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.

Prerequisite: CO SCI 198 with a satisfactory grade or better or equivalent.To enable the creation, manipulation, extraction of data from an Oracle data-base using the Oracle Forms & Reports Interfaces. The course takes youthrough creating basic forms and reports and enhancing them to create thebasis of complex applications incorporating formatting techniques and im-ages, logos and objects. This course will enable the student to take theOracle developers exam.Chair: Roger Wolf