Degrees, Certificates & Course Descriptions

CIS 1, Introduction to Computer Information Systems

4 Units
3 hrs lecture, 3 hrs lab (GR or P/NP).

Acceptable for credit: UC/CSU
AA/AS area 4c
General nature of computer hardware, software and systems: Hands-on applications include introduction to word processing, spreadsheet, database management, and presentation software, and a brief introduction to web browsing and e-mail. 0702.00

CIS 5, Introduction to Computer Science

5 Units
4 hrs lecture, 3 hrs lab (GR or P/NP).

Acceptable for credit: UC/CSU
AA/AS area 4c
Introduction to computer science: Architecture of digital computers, design of algorithms for solving various problems, and basic skills in computer programming. 0706.00

CIS 6, Introduction to Computer Programming

5 Units
4 hrs lecture, 3 hrs lab (GR or P/NP).
Recommended preparation: CIS 5.

Acceptable for credit: UC/CSU
AA/AS area 4c; (C-ID COMP 122)
Introduction to computer programming: Algorithm design, flow charting, and debugging; elements of good programming style. Course may be instructed in any programming language. 0707.10

CIS 20, Microcomputer Assembly Language

4 Units
3 hrs lecture, 3 hrs laboratory (GR or P/NP).
Prerequisite: CIS 6, 25, or 36A.

Acceptable for credit: UC/CSU
AA/AS area 4c (C-ID COMP 142)
Introduction to assembly language: Input/output operations, use of files, program flow controls, interaction with OS via interrupts, pointers and arrays, strings and structured programming, and related applications. 0707.10

CIS 23, C# Programming

4 Units
3 hrs lecture, 3 hrs lab (GR or P/NP)
Recommended preparation: CIS 6, 10, 25, or 26.

Acceptable for credit: UC/CSU
AA/AS area 4c
Introduction to C# programming: Basic unified modeling language (UML) notation in objectoriented software design and development using the C# programming language in a .Net environment; focus on the program structure, syntax, constructs and keywords of the C# programming language, concepts of intermediate languages (ILs), the common language runtime (CLR), and .Net standard data types. 0707.10

CIS 25, Object-Oriented Programming Using C++

4 Units
3 hrs lecture, 3 hrs lab (GR).
Recommended preparation: CIS 6 or 26.

Acceptable for credit: UC/CSU
AA/AS area 4c
Object-oriented methods of software development using C++: including the design and implementation of objects, class construction and destruction, encapsulation, inheritance, and polymorphism. 0707.10

CIS 27, Data Structures and Algorithms

4 Units
3 hrs lecture, 3 hrs lab (GR or P/NP).
Prerequisite: CIS 25, 26, 36A.

Acceptable for credit: UC/CSU
AA/AS area 4c
Use of abstract forms of data in programming: Concepts, and implementation and applicability of different forms of data to various programming problems. 0707.10

CIS 36A, Java Programming Language I

4 Units
3 hrs lecture, 3 hrs lab (GR or P/NP).
Recommended preparation: CIS 6 or 61.

Acceptable for credit: UC/CSU
AA/AS area 4c
Introduction to object-oriented program design using Java: Developing web pages and standalone applications. 0707.10

CIS 36B, Java Programming Language II

4 Units
3 hrs lecture, 3 hrs lab (GR or P/NP).
Prerequisite: CIS 25 or 36A.

Acceptable for credit: UC/CSU
AA/AS area 4c
Object-oriented program design using the Java programming language: Designing and programming with exceptions, threads, file input/output (I/O); networking and graphics classes; developing codes using tools such as Java 2D API and SWING; and working with projects in areas such as animation. 0707.10

CIS 42A, Spreadsheet Applications I

2 Units
1.5 hrs lecture, 1.5 hrs lab (GR or P/NP).
Recommended preparation: CIS 1 or 200.

Acceptable for credit: CSU
AA/AS area 4c
Principles of electronic spreadsheets using features available with currently popular spreadsheet software: Worksheet creation and formatting; entering of data, formulas, and functions; editing and printing; basic charting; basic database functions of sorting and querying. 0702.10

CIS 42B, Spreadsheet Applications II

2 Units
1.5 hrs lecture, 1.5 hrs lab (GR or P/NP).
Prerequisite: CIS 42A (may be taken during same term as CIS 42B during the first 9-week session).

Acceptable for credit: CSU
AA/AS area 4c
Principles of electronic spreadsheets using features available with currently popular spreadsheet software: Financial functions, logical functions, forecasting trends, lookup tables, “pivot tables”, graphic design for financial statements, statistical operations (regression analysis), macro programming. 0702.10

CIS 81, Systems Analysis with UML

3 Units
3 hrs lecture (GR or P/NP).
Prerequisite: CIS 36A.

Acceptable for credit: CSU
AA/AS area 4c
Principles of systems analysis: Techniques of analysis and design emphasizing UML in software requirements analysis, and the design and documentation phase of software development; utilizing life cycle of systems design, iterative, and waterfall development processes, object oriented analysis and design. 0707.30

CIS 82, Design Patterns

4 Units
3 hrs lecture, 3 hrs lab (GR or P/NP).
Prerequisite: CIS 36A, Recommended
Preparation: CIS 81.

Acceptable for credit: CSU
AA/AS area 4c
Principles of designing robust reusable objectoriented software: The most common designpattern strategies; enterprise program design. 0707.10

CIS 83A, Web Programming Capstone Project

3 Units
1 hour Lecture, 6 hrs Lab (GR or P/NP).
Prerequisite: CIS 36A, 81, 84, 85, and 103.

Acceptable for credit: CSU
AA/AS area 4c
Substantial client-specified work-like project: Team project includes writing, analyzing, designing, implementing, testing, documenting, and presenting to client; use of programming and systems analysis skills developed in previous courses; demonstration of mastery of program competencies. 0707.10

CIS 83B, Computer Programming Capstone Project

3 Units
1 hour Lecture, 6 hrs Lab (GR or P/NP).
Prerequisite: CIS 27, 36A, 81, and 82.

Acceptable for credit: CSU
AA/AS area 4c
Culminating project-based experience that applies computer programming knowledge and skills developed in previous courses towards the design, implementation, testing, documentation, and presentation of a specific idea, task, or product. 0707.10

CIS 84, Database Programming for the Web

4 Units
3 hrs lecture, 3 hrs lab (GR or P/NP).
Recommended Preparation: CIS 6, 36A, and 105.

Acceptable for credit: CSU
AA/AS area 4c
Web-enabled database concepts: Relational database principles, Structured Query Language (SQL); use of client-side scripts and server-side scripts. 0707.20

CIS 85, JSP and Servlets

4 Units
3 hrs lecture, 3 hrs lab (GR or P/NP).
Prerequisite: CIS 36A.

Acceptable for credit: CSU
AA/AS area 4c
Java servlet and JSP technology and deployment of web applications: Interactive web pages, secure access to the web site, JDBC database connectivity, web security, generation of dynamic web pages, and maintenance of client session data; quick introduction to Java bean components and J2EE. 0707.10

CIS 86, Windows Operating Systems

4 Units
3 hrs lecture, 3 hrs lab (GR or P/NP).
Recommended Preparation: CIS 1

Acceptable for credit: CSU
AA/AS area 4c
Computer operating system environment through a study of the main features and functions of MS Windows: Operating system fundamentals, configurations, installation & upgrading, managing applications, files and directories, managing devices and other resources, system maintenance. 0702.00

CIS 90, Security Fundamentals

4 Units
3 hrs lecture, 3 hrs lab (GR or P/NP).
Recommended Preparation: CIS 1.

Acceptable for credit: CSU
AA/AS area 4c
Basics of Network and Windows Server system security: Core security principles, understanding security layering concepts, authentication-authorization-accounting, security policies through access and permissions, understanding network security, protecting the client server environment, encryption, PKI and Certificates. 0708.20

CIS 103, Survey of Programming Languages for the Web–Continuation

4 Units
3 hrs lecture, 3 hrs lab (GR or P/NP).
Recommended Preparation: CIS 36A and 104.

Acceptable for credit: CSU
AA/AS area 4c
E-commerce web page design principles: Extend web page “functionality” with interactivity, multimedia, security, and database capability using XML, JavaScript and related technologies. 0707.10

CIS 104, Survey of Programming Languages for the Web

3 Units
2 hrs lecture, 3 hrs lab (GR or P/NP).
Recommended preparation: CIS 1 and 105.

Acceptable for credit: CSU
AA/AS area 4c
Survey of programming languages for the Web for non-programmers: History and motivation for development; review of basic concepts and syntax, such as variables, loops, conditions, arrays, structures; capabilities and limitations; functions of object-oriented and event-driven programming. Taught using HTML5, CSS, Java with jQuery. 0707.10

CIS 105, Mechanics of Web Page Design

Unit
1 hour lecture (GR or P/NP).
Recommended preparation: CIS 237

Acceptable for credit: CSU
AA/AS area 4c
Basic theory and practice of web page construction using HTML: Preparation of images for the web, interface design, and interactivity. 0709.00

CIS 200, Computer Concepts and Applications

1.5 Units
1 hour lecture, 2 hrs lab (GR or P/NP).

AA/AS area 4c
Introduction to computer concepts: Terminology, word processing, spreadsheets, database management, presentation graphics, and the Internet. 0702.10

CIS 230, Laboratory Practice in Microcomputers

0.5 Units
1.5 hrs lab (GR or P/NP).
Recommended preparation: CIS 200.

Designed to provide lab experience not covered under other course offerings: Prescribed lab activities or establishment of a specialized course of study under direction of instructor. 0702.00

CIS 231, Advanced Laboratory Projects in Microcomputers

1 Unit
3 hrs lab (GR or P/NP).
Recommended preparation: CIS 210, 212,
220, or 235.

AA/AS area 4c
Designed to provide advanced lab experience not covered under other course offerings: Specialized projects using advanced
applications/programs or multiple application programs under direction of instructor for students with prior user or programming experience. 0702.00

CIS 231A, Advanced Laboratory Projects in Word

1 Unit
3 hrs lab (GR or P/NP).
Recommended Preparation: CIS 1.

AA/AS area 4c
Advanced word skills: Creating templates and themes, adding multimedia to documents, and protecting documents by completing specialized projects. 0702.00

CIS 231B, Advanced Laboratory Projects in Outlook

1 Unit
3 hrs lab (GR or P/NP). Recommended
Preparation: CIS 1.

AA/AS area 4c
Outlook: Perform scheduling, manage tasks and meetings, manage contacts and emails, manage communication, and work efficiently by completing specialized projects. 0702.00

CIS 231C, Advanced Laboratory Projects in SharePoint

1 Unit
3 hrs lab (GR or P/NP).
Recommended Preparation: CIS 1.

AA/AS area 4c
SharePoint: Collaborating on activities, sharing data, and presenting business applications and content by completing specialized projects. 0702.00

CIS 231D, Advanced Laboratory
Projects in OneNote

1 Unit
3 hrs lab (GR or P/NP).
Recommended Preparation: CIS 1

AA/AS area 4c
OneNote: Creating, collecting, categorizing, organizing, and searching documents and notes by completing specialized projects. 0702.00

CIS 232, Exploring Robotics

2 Units
1 hrs lecture, 3 hrs lab (GR or P/NP).

AA/AS area 4c
Introduction to robotics and computing:
Modeling, designing, planning, and programming; hands-on robotic projects using motors and sensors. 0706.00

CIS 237, Introduction to Internet Basics

1 Unit
1 hour lecture (GR or P/NP).
Recommended preparation: CIS 200.

AA/AS area 4c
Introduction to Internet basics: Connecting to the Internet; exploring the World Wide Web; using email, search engines and directories, FTP/Newsgroups/TELNET; creating and publishing HTML pages and ethical issues. 0709.00

CIS 245A, Introduction to Microsoft Access I

2 Units
1.5 hour lecture, 1.5 hrs lab (GR or P/NP). Corequisite:
CIS 1 or 200.

AA/AS area 4c
Introduction to Microsoft Access database management: Designing, creating, and managing a database, developing and building tables, creating queries forms and reports.0707.20

CIS 245B, Introduction to Microsoft Access II

2 Units
1.5 hrs lecture, 1.5 hrs lab (GR or P/NP).
Prerequisite: CIS 245A.

AA/AS area 4c
Microsoft Access Database design, management and optimization of relational databases: Advanced queries, enhanced table design, tools for custom form and report generation, data sharing and analysis, action queries and advanced table relationships, automating tasks with macros, using and writing Visual Basic application code. 0707.20

CIS 246, Introduction to PowerPoint

1.5 Units
1 hour lecture, 1.5 hrs lab (GR or P/NP).
Recommended Preparation: CIS 1.

AA/AS area 4c
Introduction to Microsoft PowerPoint presentation graphics: Preparation for creating, saving, editing and printing presentation materials; graphic techniques and overhead transparencies, color slides, outline notes, handouts, and on-screen graphics. 0702.10

(Source: Berkeley City College Catalog 2019-20)