Computer Science | Computer Information Systems

UC:CSU
(UC Credit Limit: 1 course maximum from: CO SCI 201 or CIS 101 and CAOT 035).
(Formerly CO SCI 201). LECTURE, 3 HOURS.

This course teaches concepts of information systems and their role in business. This course focuses on information systems, database management systems, networking, Internet, e-commerce, ethics and security, computer systems hardware and software components, and webpage development. This course includes a hands-on component for developing computer-based solutions to common business problems, and practical workplace skills.

CSU (Formerly CO SCI 234)
Prerequisite: Computer Information Systems 101 or Computer Science Information Technology 201.
LECTURE, 2 HOURS; LABORATORY, 2 HOURS.

This course provides an introduction to operating systems concepts including installation, configuration, file systems, directory structures, memory and storage management, utilities, and maintenance using a variety of operating systems.

CSU (Formerly CO SCI 233).
Prerequisite: Computer Information Systems 101 or Computer Science Information Technology 201
LECTURE, S HOURS; LABORATORY, 2 HOURS.

This course covers a complete presentation of database creation and management using Access. It includes database design, creation of tables, forms, queries, reports, macros, integrating data into a database, and using Structured Query Language (SQL).

CSU (Formerly CO SCI 200)
Prerequisite: Computer Information Systems 101 or Computer Science Information Technology 201.
LECTURE, 3 HOURS.

This course teaches advanced techniques in word processing and spreadsheets. It includes creating mailmerged documents using Excel and Access data sources, Excel advanced formulas,and the use of advanced adaptive Excel tools (formulas, logic, conditional formatting, data validation, pivot tables, pivot charts, and relationships).

CSU (Formerly CO SCI 259).
LECTURE, 2 HOURS; LABORATORY, 2 HOURS.

This course is designed to introduce students the basics of web design using HTML (Hypertext Markup Language), CSS (Cascading Style Sheets), Photoshop, Content Man­agement Systems, and web editing tools. The course does not require any prior knowledge of HTML or web design. Throughout the course students are introduced to plan­ning and designing effective web pages; understanding of website development phases, implementing web pages by writing HTML and CSS code; enhancing web pages with the use of page layout techniques, text formatting, graph­ics, images, and multimedia; and developing dynamic websites.

CSU (Formerly CO SCI 259).
LECTURE, 2 HOURS; LABORATORY, 2 HOURS.

Students learn basic internet concepts and technologies. Students learn to develop web sites by applying concepts like tables, layers, cascading styles sheets, frame sets, image maps, lists, forms, and dynamic content using basic JavaScript and JQuery. Website folder structures are covered to ensure students learn how to organize and maintain their website appropriately. Students also learn how to use SFTP to upload and maintain their websites.

CSU (Formerly CO SCI 211).
LECTURE, 2 HOURS; LABORATORY, 2 HOURS.

This course introduces the fundamental concepts and skills required to pursue a career in Cyber Security, Information Security and Risk Management, at an organizational level. Topics covered include hardware, software, processes, communications, applications, policies, and procedures with respect to organizational Cyber Security and Risk Management best practices. This course also assists in the preparation for the CompTIA Security+ certification exams.

CSU (Formerly CO SCI 276). LECTURE, 2 HOURS; LABORATORY, 2 HOURS.

This course introduces cloud computing which shifts information systems from on-premises computing infrastructure to highly scalable Internet architectures. The course provides a solid foundation of cloud computing technologies and provides students with the understanding required to effectively evaluate and assess the business and technical benefits of cloud computing and cloud applications. Students analyze a variety of cloud services (storage, servers and software applications) and cloud providers. Case studies are used to examine various industry cloud practices and applications. The course also surveys cloud careers and discusses industry demand for cloud skills

CSU (Formerly CO SCI 277)
Prerequisite: Comuter Information Systems 192 or Computer Science Information Technology 276
LECTURE, 2 HOURS; LABORATORY, 2 HOURS.

This course addresses cloud database management which supports a number of different approaches for storing data. In the course, students define, operate and scale both SQL and noSQL data storage solutions. This course considers factors that should be balanced during the design of a storage solution. Principles are applied by performing exercises using Amazon RDS and SQL to create and fill tables, retrieve and manipulate data. Object-based APIs are used to serialize objects to Amazon DynamoDB for noSQL solutions. Topics include automated backups, transaction logs, restoration, and retention.

CSU (Formerly CO SCI 278)
Prerequisite: Comuter Information Systems 192 or Computer Science Information Technology 276.
LECTURE, 2 HOURS; LABORATORY, 2 HOURS.

Cloud computing systems are built using a common set of core technologies, algorithms, and design principles centered around distributed systems. In this hands-on introductory course, students use the Amazon Web Services (AWS) Management Console to provision, load-balance and scale their applications using the Elastic Compute Cloud (EC2) and the AWS Elastic Beanstalk. This course Business Administration Department 184 EAST LOS ANGELES COLLEGE | GENERAL CATALOG | 2020 – 2021 discusses, from a developer perspective, the most important reasons for using AWS and examines the underlying design principles of scalable cloud applications.

CSU (Formerly CO SCI 279)
Prerequisite: Comuter Information Systems 192 or Computer Science Information Technology 276.
LECTURE, 2 HOURS; LABORATORY, 2 HOURS.

Protecting the confidentiality, integrity and availability of computing systems and data is of utmost importance to all organizations. In this hands-on introductory class, students learn how Amazon Web Service (AWS) uses redundant and layered controls, continuous validation and testing, and a substantial amount of automation to ensure the underlying infrastructure is continuously monitored and protected. Students examine the AWS Shared Responsibility Model and access the AWS Management Console to learn more about security tools and features provided by the AWS platform.

CSU (Formerly CO SCI 237).
LECTURE, 3 HOURS.

This course covers the fundamental principles and concepts of networks and data communications. It explores the fundamentals of telecommunications, data and voice transmission, transmission media, network equipment and devices, networking software, topologies, architecture, protocols and standards, the Open Systems Interconnection (OSI) model, Transmission Control Protocol/Internet Protocol (TCP/IP), local area networks (LAN), wide area networks (WAN), and network security.

CSU (Formerly CO SCI 212)
LECTURE, 1 HOUR; LABORATORY, 2 HOURS.

This course provides an introduction to troubleshooting and maintenance techniques for personal and laptop computers. The course provides the student with applicable knowledge in different hardware such as RAM, hard drives, and processors. A step by step approach is taken to operating system procedures used for maintaining and repairing personal computers. Some of these procedures include virus scan, program installation and removal, and Windows configurations.

UC:CSU (Formerly CO SCI 208)
LECTURE, 2 HOURS; LABORATORY, 2 HOURS.

This course teaches the fundamental principles of object-oriented programming (OOP) design and concepts, using the Visual Basic programming language. It teaches the basics of the Visual Basic programming language using the latest version of Visual Studio Integrated Development Environment (IDE). Students learn to design and develop programs using the following programming constructs and techniques: data representation using variable and constant objects; sequential, selection, and repetition control structures; designing classes, subroutines, and functions; use of arrays to sort and search data lists;

UC:CSU (Formerly CO SCI 262)
Advisory: Computer Information Systems 146 or Computer Science Information Technology 257
LECTURE, 2 HOURS; LABORATORY, 2 HOURS.

Introduces JavaScript to Web developers with HTML and CSS background who want to create dynamic Web pages and to Server-side programmers who use languages like ASP, JSP, or PHP and would like to add JavaScript programming to their skill sets. Students integrate script elements, outputting to a web document, working with selections, repetition structures, writing functions; and accessibility to create dynamic web applications.

UC:CSU (Formerly CO SCI 290)
LECTURE, 2 HOURS; LABORATORY, 2 HOURS.

This course teaches the fundamental principles of object-oriented programming design and concepts to design applications, using the Java programming language. It uses the latest version of the Java Standard Edition Development Kit. Students learn to design and develop programs using the following programming techniques and constructs: Algorithm development, data representation using variable and constant objects; control structures; designing classes, methods, and functions; use of arrays; and Graphical User Interface design.

UC:CSU (Formerly CO SCI 295)
LECTURE, 2 HOURS; LABORATORY, 2 HOURS.

This course covers principles of event-driven programming and object-oriented design in Windows applications using the C# programming language (including data encapsulation, inheritance, and polymorphism). Topics include the Visual Studio IDE and .NET Framework control classes. Students create Graphical User Interface (GUI) classes, objects, methods, event-handlers, constructors, arrays, and multi-form projects, including use of strings, data validation, and exception handling and access modifiers.

UC:CSU (Formerly CO SCI 243)
Prerequisite: Computer Information Systems 101 or Computer Science Information Technology 201
116 Programming in C++ (3) UC:CSU (Formerly CO SCI 243).

In this course, students are introduced to basic concepts of Computer Science, problem-solving methods, algorithms, software design principles, testing, debugging, and basics of C++. Topics include variables, expressions, data types, input/output (I/O), branches, loops, functions, parameter passing, file I/O, and arrays

UC:CSU (Formerly CO SCI 224)
Prerequisite: Computer Information Systems 101 or Computer Science Information Technology 201.
LECTURE, 2 HOURS; LABORATORY, 2 HOURS.

This course covers topics of the Python language, which include: Data types, variables, control structures, objects and object-oriented programming, standard mathematical libraries, tool-chain use and Python Frameworks, user-defined classes and abstract collections, single arrays, multidimensional arrays, Python lists, tuples, collections, and dictionaries.

UC:CSU (Formerly CO SCI 216)
Prerequisite: Computer Science 116 or Computer Science Information Technology 243 or Computer Science 113 or Computer Science Information Technology 290.
LECTURE, 2 HOURS; LABORATORY, 2 HOURS.

This course covers the basics of computer architecture concepts and Assembly language. Topics include data representation, number systems, records and arrays, instruction sets and addressing modes, subroutines and macros, I/O and interrupts, machine language, and Assembly programming.

UC:CSU (Formerly CO SCI 252)
Prerequisite: Computer Science 116 or Computer Science Information Technology 243 or Computer 113 or Computer Science Information Technology 290.
LECTURE, 2 HOURS; LABORATORY, 2 HOURS.

This course is an introduction to the discrete structures used in Computer Science with an emphasis on their applications. Topics covered include: Functions, Relations and Sets, Basic Logic, Proof Techniques, Basics of Counting, Graphs and Trees, and Discrete Probability.

UC:CSU (Formerly CO SCI 236)
Prerequisite: Computer Science 116 or Computer Science Information Technology 243 or Computer 113 or Computer Science Information Technology 290.
LECTURE, 2 HOURS; LABORATORY, 2 HOURS.

This course is an introduction to the study of Data Structures. It introduces the student to data structures as formed from primitive data types. The role of abstract data types (including stacks, queues, lists, trees, and graphs), their definitions, implementation and application in program design and algorithm development are discussed. The course covers the broader topic of Abstract Data Types (ADTs) - the study of classes of objects whose logical behavior is defined by a set of values and a set of operations. This course is equivalent to CS2 as defined by the Association for Computing Machinery (ACM) organization.

CSU (Formerly CO SCI 258)
LECTURE, 2 HOURS; LABORATORY, 2 HOURS.

This course introduces students to create database-driven web application using the open-source dynamic object-oriented scripting language Ruby. The course covers the web development life cycle by using HTML 5, CSS, and Ruby a modern web scripting language used by several cutting edge companies. Students learn about object-oriented programming, conditionals, loops, methods, variables, arrays, classes, and objects. Debugging and error checking methods such as exception handling, regular expressions I/O objects, and modules are also covered in the class. Introduction to database languages such as SQL, and MySQL databases and the interaction both the server-side language and backend database are taught. This is course is for students who are interested in developing web applications using the latest scripting languages like Ruby on Rails.

CSU
CONFERENCE, 1 HOUR PER WEEK PER UNIT.

The above courses allow students with the opportunity to gain additional programming and operating skills on a micro, midrange or mainframe computer on a contract basis under the direction of a supervising instructor.

UC:CSU (Formerly CO SCI 238)
Prerequisite: Computer Science 111. LECTURE, 2 HOURS; LABORATORY, 2 HOURS.

This course teaches advanced principles of object-oriented programming (OOP) design and concepts, using the Visual Basic programming language using the latest version of Visual Studio Integrated Development Environment (IDE). Students learn to design and develop programs with objects, classes, exception handling, GUI, DBMS, SQL, ASP. NET, Data Structures, and Recursion.

UC:CSU (Formerly CO SCI 246)
Prerequisite: Computer Science 113.
LECTURE, 2 HOURS; LABORATORY, 2 HOURS.

This course covers principles of object-oriented design and programming using Java. Additional topics include writing applets, working with exceptions, file input/output, networking, building event driven GUIs, and developing multithreaded programs using concurrency, and Unified Modeling Language.

UC:CSU (Formerly CO SCI 240)
Prerequisite: Computer Science 116 or Computer Science Information Technology 243 or Computer 113 or Computer Science Information Technology 290.
LECTURE, 2 HOURS; LABORATORY, 2 HOURS.

In this course, students learn Object-Oriented and Advanced programming with C++ including Classes, Data Abstractions, Inheritance, Composition, Virtual Functions, Operators & Functions Overloading, Templates, Exception Handling, Recursion, Pointers, Dynamic Data Types, and Linked Lists.