CMPSC 103-SYMBOLIC LOGIC 3 Units
Also offered as PHILO 103
An introduction to modern logic; includes sentential and predicate logic with identity theory and definite descriptions. Lecture. Not offered every semester.
Transfer: CSU, UC (CAN PHIL 6)
General Education: (MJC-GE:D2) (CSU-GE:A3)
CMPSC 201-GENERAL COMPUTER LITERACY 3 Units
Survey of the functions and uses of computers in business, education, industry, and science with emphasis on the personal computer; study of computers and peripheral equipment as integrated systems; explorations of the impact of computers on society; introduction to problem-solving and applications programming techniques; experience with popular Internet and application packages on the laboratory micorcomuters. (A-F or P/NP) Approved for hybrid, telecourse and on-line instruction.
Transfer:CSU, UC (CAN CSCI 2) (CC CMPSC 1)
General Education: (MJC-GE:D2)
CMPSC 202-BUSNIESS INFORMATION SYSTEMS 3 Units
Prerequisite: Satisfactory completion of BUSAD 201 or 310 and CMPSC 201
Introduction to design, development, and use of information system models to improve managerial decision making. Study of information systems hardware and software; advanced computer codes; systems analysis and planning; systems security; application development using decision support systems; and expert systems. Lab work will focus on Internet research and advanced spreadsheet; database, and word processor functions for solutions to business problems. Field trips may be required. Lecture. Laboratory arranged. Materials fee required.
Transfer: CSU, UC (CAN BUS 6)
CMPSC 203-TECHNICAL COMPUTER LITERACY 3 Units
concepts and techniques for using microcomputer applications. Instruction and extensive practice in Windows, word processing, spreadsheets, database management, Internet basics, file transfer between application, and related auxiliary applications. (A-F or P/NP). Materials fee required.
Transfer: CSU
General Education: (MJC-GE:D)
CMPSC 204-INTRODUCTION TO PROGRAMMING 3 Units
Recommended for Success:Satisfactory completion of MATH 90 or qualification by MJC assessment process.
The first course in computer programming for students with little or no programming experience. General computer literacy issues describing computer hardware, software development, operating systems, and telecommunications will be covered. Beginning problem-solving analysis, documentation, algorithm design, control structures, program coding, using BASIC and C + +, file input and output, and program testing and program maintenance will be stressed. Field trips may be required. Lecture/Laboratory. Materials fee required. (P/NP Only)
Transfer: CSU, UC
CMPSC 205-PROBLEM SOLVING AND PROGRAMMING 1 3 Units
Prerequisite:Satisfactory completion of CMPSC 204
Designed for computer science transfer majors but open to all students. Emphasizes algorithm devlopment and problem analysis skills for computer science. Software engineering skills will be developed for both procedural programming and object-oriented programming. Solution algorithms will be implemented using either the C + + or Java programming languages. Extensive programming projects demonstrating problems solving and implementation skills will be assigned throughout the semester. Filed trips may be required. Lecture/Laboratory. Materials fee required.
Transfer:CSU, UC (CAN CSCI22, CSU, UC) (CC CMPSC 22)
CMPSC 206-INTRODUCTION TO UNIX/LINUX SYSTEMS AND PROGRAMMING
3 Units
Recommended for Success:Satisfactory completion of CMPSC 204
Introduction to the UNIX operating system using Linux. Coverage will include UNIX shells, commands, the role of the system administrator, the UNIX file system, editors, file processing, shell programming utilities, PERL and CGI programming, C and C + + programming, and recent developments in UNIX and the Windows graphical user interface. Extensive hands-on experience using UNIX operating system and programming within the UNIX environment. Filed trips may be required. Lecture/Laboratory. Materials fee required.
Transfer:CSU, UC (CC CMPSC 9)
CMPSC 213-PROGRAMMING WITH VISUAL BASIC 3 Units
Prerequisite:Satisfactory completion of CMPSC 204
Concepts in programming a computer using the language called Visual BASIC.Emphasis on structured design, graphical user interfacing, and documentation. Includes user screen development, control constructs, array processing, elementary file processing, and database access. Extensive interaction with computers will be expected. Lecture/Laboratory. Materials fee required.
Transfer:CSU, UC (CAN CSCI 6) (CC CMPSC 28)
General Education:(MJC-GE:D2)
CMPSC 214-ADVANCED VISUAL BASIC 3 Units
Prerequisite:Satisfactory completion of CMPSC 213 or equivalent.
Advanced concepts of computer programming using Microsoft Visual BASIC. Students will program user interfaces with Microsoft Word, Excel and Access. They will also create Internet and general business interfaces. Graphics and game structure applications will be covered. Lecture/Laboratory. (Spring)
Transfer:CSU, UC
CMPSC 216-JAVASCRIPT PROGRAMMING FOR THE INTERNET 3 Units
Prerequisite:Satisfactory completion of CMPGR 264 and CMPSC 204
Developing World Wide Web applications with HTML and Javascript. An introduction to creating interactive HTML documents through manipulation of the WWW.DOM(Document Object Model). Designing Web-based applications, validating and processing user input, creating dynamic documents utilizing DHTML. Extensive programming projects demonstrating problem solving and implementation skills will be assigned throughout the semester. Hands-on computer assignments required. Field trips may be required. Two maximum completions. Lecture/Laboratory. Materials fee required.
Transfer:CSU,UC
CMPSC 220-SOL SERVER ADMINISTRATION 3 Units
Prerequisite:Satisfactory completion of CMPSC 275
Provides students with the knowledge and skills required to install, configure, administer, and troubleshoot Microsoft SQL Server client/server database management system version 7.0 or higher. Two maximum completions. Lecture/Laboratory. Materials fee required. Not offered every semester.
Transfer:CSU
CMPSC 225-SQL DATABASE IMPLEMENTATION 3 Units
Prerequisite:CMPSC 275
Provides students with the technical skills required to implement a database solution with SQL Server. Topics include:architecture, key feature of SQL Server, reviewing SQL Server programming tools, Transact-SQL, creating database, data integrity, planning and creating indexes, advances query techniques, summarizing data, managing transactions and locks, implementing views, stored procedures and trigger, working with distributed data, and advanced text queries. Two maximum completions. Lecture. Laboratory arranged. Materials fee required. Not offered every semester.
Transfer:CSU
CMPSC 231-INTERMEDIATE WORD PROCESSING 3 Units
Recommended for Success:Satisfactory completion of OFADM 203 and (OFADM 330 or CMPSC 274)
Also offered as OFADM 231
Intermediate word processing features such as mail merge, macros, styles, graphics, tabs, and sorts. Features will be applied in creating business documents. Two maximum completions. Lecture/Laboratory. Materials fee required.
Transfer:CSU (CC OFTEC 141)
CMPSC 241-ASSEMBLE LANGUAGE PROGRAMMING 3 Units
Prerequisite:Satisfactory completion of CMPSC 204
Designed for Computer Science transfer majors, but open to all students. Introduction to microcomputer hardware architecture and assembly language programming. A microprocessor instruction set will be examined in detail. Memory addressing modes, logic and control, data representations and manipulation, table processing, and device I/O control processes will be examined. Macros, program modules, and interrupts will be studied. Extensive hands-on computer projects implementing course objective will be assigned. Filed tips may be required. Lecture/Laboratory. Materials fee required.
Transfer:CSU, UC (CAN CSCI 10, CSU, UC0 (CC CMPSC 40)
General Education: (MJC-GE:D2)
CMPSC 261-PROBLEM SOLVING AND PROGRAMMING 2 3 Units
Prerequisite:Satisfactory completion of CMPSC 205 or ACM CS-1 equivalent
Introduction to simple data structure and objects-oriented programming. Includes more advanced features of high-level languages such as C + + of Java. Continued emphasis on good programming methodologies and problem solving techniques and analysis. Programming problems implementing lists, stacks, queues, and trees will be emphasized. Field trips may be required. Lecture/Laboratory. Materials fee required.
Transfer:CSU, UC (CAN CSCI 24, CSU, UC) (CC CMPSC 24)
General Education:(MJC-GE:D2)
CMPSC 263-NETWORKING ESSENTIALS 3 Units
Prerequisite:Satisfactory completion of an introductory computer class
Concepts of networking technologies. Includes design, media, hardware, standards, protocols, architectures, operations, administration, support, distributed networks, WANs, troubleshooting,and the Internet. Designed to help individuals prepare for Microsoft Certification Exam #70-058. Hands-on computer assignments required. Field trips may be required. Lecture/Laboratory. Materials fee required.
Transfer:CSU
CMPSC 264-WINDOWS SERVER OS 3 Units
Formerly listed as "Windows 2000 server"
Prerequisite:Satisfactory completion of CMPSC 263 and 204
Technical study of the Windows Server operating system. Includes server hardware, installation, configuration, clients, management, network protocols, active directory and security, remote access and virtual private networks, interoperability, Internet and intranets, monitoring, tuning, and troubleshooting. Hands-on computer assignments required. Field trips may be required. Two maximum completions. Lecture/Laboratory. Materials fee required. (A-F of P/NP)
Transfer:CSU
General Education:(MJC-GE:D)
CMPSC 269-NETWORK AND CERTIFICATION TRAINING LAB 1 Unit
Current Enrollment:CMPSC 263
Recommend for Success:Satisfactory completion of any introductory computer course
Also offered as CMPET 269
Network + is quickly becoming the standard for introductory-level industry certification. Designed for those interested in a career in network support, this vendor-neutral certification takes the student through installing and configuring a network client. This laboratory course along with the CMPSC 263 course provides preparation for CompTIA's Network + certification exam. Extensive network lab projects will be required. Field trips may be required. Laboratory. Materials fee required.
Transfer:CSU
CMPS 270-UNDERSTANDING DATA COMMUNICATIONS 3 Units
How data communication systems and their various hardware and software components work. Includes communication between personal computer systems, database services, electronic bulletin boards, and the Internet. Hands-on computer assignments required. Lecture/Laboratory. Materials fee required.
Transfer:CSU
CMPSC 275-DATABASE MANAGEMENT SYSTEMS/MICROCOMPUTERS 3 Units
Introduction to database management systems (DBMS). Instruction on the desgin, setup and maintenance of a DBMS. Application in inventory control, mailing lists, report construction and format, sorting and indexing operations, general file relationships and information retrieval. Hands-on experience using a microcomputer. Emphasis on Microsoft Access or similar DBMS software. Lecture/Laboratory. Materials fee required.
Transfer:CSU (CC CMPSC 55)
CMPSC 276-INTRODCUTION TO DATA WAREHOUSING 3 Units
Formerly listed as:CMPSC 276 Database Programming
Prerequisite:Satisfactory completion of CMPSC 275 or 225 or 220
Introduction to data warehousing. Emphasizes heterogeneous database design, optimization and reporting. Use of a multi-vendor environment such as Oracle, SQL Server, MySQL, or Postgres SQL. Maximum two completions. (A-F or P/NP) Materials fee required.
Transfer:CSU
CMPSC 278-SPREADSHEET SOFTWARE 3 Units
Recommended for Success:Any introductory computer class
Introduction to spreadsheet software. Spreadsheet analysis, design, testing and documenting will be covered. Data entry, data management, graphing and keystroke macros will be emphasized. Applications in various areas will be explored with emphasis in business, professional and educational us. Hands-on experience using a microcomputer. Emphasis on Microsoft Excel or similar spreadsheet application. Lecture/Laboratory. Materials fee required.
Transfer:CSU (CC CMPSC 30)
CMPSC 279-SPREADSHEET DESIGN AND PROGRAMMING 3 Units
Prerequisite:Satisfactory completion of CMPSC 279
Use current spreadsheet macros and command languages to build application programs for small businesses. Emphasizes system design concepts, structured programming strategies, and documentation techniques. Graphics and database management capabilities will be explored along with ancillary and related enhancement programs. Lecture. Laboratory arranged. Materials fee required.
Transfer:CSU
CMPSC 281-ADVANCED NETWORKING & SECURITY 3 Units
Formerly listed as "Windows 2000 Security"
Prerequisite:Satisfactory completion of CMPSC 264 and 206
Technical study of security for Windows Networks. Includes assessing security risks, planning administrative access and user accounts, securing communication channels, securing file and print resources, secure access to remote users and offices, secure network access to Internet users, extending the network to partner organizations, designing a public key infrastructure, and developing a security plan. Hands-on computer assignments required. Field trips may be required. Two maximum completions. Materials fee required. Lecture/Laboratory. (A-F or P/NP)
Transfer:CSU
CMPSC 289-DIRECTORY SERVICES 3 Units
Formerly listed as "Windows 2000 Directory Service"
Prerequisite:Satisfactory completions of CMPSC 264 and 206
Technical study of the Directory Services using tools such as LDAP and Active Directory. Includes the design and implementation of directory services, analyzing business requirements, information technology structures, software,hardware and network requirements, large and small scale directory services design, group policy design, design topology and locations, replication and disaster recovery. Hands-on computer assignments required. Field trips may be required. Two maximum completions. Lecture. Laboratory arranged. Materials fee required. (A-F or P/NP)
Transfer:CSU
CMPSC 291-WINDOWS PROGRAMMING WITH VISUAL C++ 3 Units
Prerequisite:Satisfactory completion of CMPSC 205, or CAN CSCI 22 course equivalent, or ACM CS-1 course equivalent
Introduction to the Microsoft Visual C++ programming environment. Review of the C++ language and object-oriented programming concepts. Emphasis on using Visual C++ to build user application, user interfaces, ActiveX applications, Internet programming, and advanced programming techniques. Hands-on computer programming projects will be required. Field trips may be required. Lecture/Laboratory. Materials fee required.
Transfer:CSU, UC
CMPSC 294-COMPUTER SCIENCE FINAL PROJECT 3 Units
Recommended for Success:Completion of at least 18 units of required courses leading to the Associate Degree in Computer Science
Culminating experience for students pursuing an AS degree in Computer Science. Objectives of degree courses will be integrated into a final managed project advised by one or more Computer Science faculty. Effective project and team management will be emphasized. Field trips may be required. (A-F Only) One completion allowed.
Transfer:CSU
CMPSC 298A,B,C-SPECIAL IN COMPUTER SCIENCE 1,2,3 Units
Prerequisite:Varies with topic
Participation in discussion, analysis, and evaluation of a special topic in computer science, microcomputer applications, and related technologies. Topic to be announced in class schedule. Twelve maximum units in any combination. Field trips may be required. Lecture. Materials fee required.
Transfer:CSU
CMPSC 801-DATABASE MANAGEMENT SYSTEM WORKSHOP
An introduction to a database management system with hands-on instruction using a microcomputer. Students will define, create, and use their own database. Unlimited repeats. Lecture/Laboratory. Materials fee required.
CMPSC 803-SPREADSHEET WORKSHOP
Introduction to the basic application of computers in the business environment. Specific instruction on use of the Electronic Spreadsheet. Unlimited repeats. Lecture/Laboratory. Materials fee required.
CMPSC 805-WORD PROCESSING WORKSHOP
Introduction to the basic application of computers in the business environment. Specific instruction on use of word processing as an office automation tool. Exploration of benefits of word processing and its ability to expand productivity. Unlimited repeats. Lecture/Laboratory. Material fee required.
