CCSF Catalog CS Certificate Programs

Computer Science

Announcement of Curricula

DEGREE CURRICULA

Major

Computer Science
Computer and Information Science

CREDIT CERTIFICATE CURRICULA

General Information

The Computer Science Department offers courses in computer programming, databases, Unix/Linux administration and programming, and multimedia. We have transfer and degree programs, as well as certificate programs. Our courses range from entry-level to professional development.

Courses and programs offered by the Computer Science Department change frequently. For the latest information about our courses, please consult the department web site at www.ccsf.edu/CS.

Degree Curriculum

Graduates of the two-year program in Computer Science will have the skills in computer programming required for transfer to a four-year college or for employment as programming assistants, maintenance programmers, and other entry level or trainee positions. Upon successful completion of the curriculum, students receive the Associate of Science (AS) degree.

Options. Students may choose from two options for their course of study towards a degree.

    1. Computer Science. The Computer Science option prepares students for transfer to four-year colleges for further study
    in Computer Science, as well as related areas such as Computer Engineering and Information Science. Students also gain foundational knowledge that
    will assist them in entry-level employment as computer programmers and analysts.

    2. Computer and Information Science.The Computer and Information Science option prepares students for transfer to four-year college for further
    study in areas such as Information Science and Information Technology. Those who want to prepare themselves for a career in other fields requiring
    computer theory and practice will also benefit from this course of study.

Admission. Enrollment is recommended only to students who have completed one year of high school algebra with a final grade of C or higher and one year of high school geometry with a final grade of C or higher, or equivalent.

Course of Study. The curriculum includes instruction in the fundamentals of computer use, problem solving, systems analysis, programming in languages (such as C++, Visual Basic, and Java), computer operations, Unix administration, databases (such as Oracle), and systems tools. Additional requirements include the fundamentals of accounting, quantitative methods and communication skills.

Transfer to Other Colleges and Universities. Students who complete the two-year Associate of Science degree program are encouraged to continue their education and earn the Bachelor’s degree. City College of San Francisco has transfer agreements with many of the California State Universities and University of California campuses. Students who are interested in transferring after completion of the two-year degree program should consult the “Transfer Information” section of this catalog and discuss their plans with their program advisor or counselor. Students should pay particular attention to which programming series they take (CS 110A-B-C or CS 111A-B-C), as different four-year schools may take one or the other track. The web site www.assist.org can provide additional information about applicable courses for transfer.

Computer Science

The Major in Computer Science prepares students for transfer to a four-year college. These courses are applicable to students wishing to pursue a degree in Computer Science. Students wishing to major in related fields (Computer Engineering, Information Science, etc.) should consult with the Computer Science department degree advisor. Students should consider transfer applicability to their desired 4-year college when choosing whether to take the programming sequence in C++ or Java.

Courses Required for the Major in Computer Science

Course                                                          Units
CS 110A/111A Intro to Programming (C++/Java)...................... 3
CS 110B/111B Programming Fundamentals (C++/Java).................. 3
CS 110C/111C* Data Structures and Algorithms (C++/Java)........... 3
CS 270 Computer Architecture with Assembly Language .............. 3
MATH 110A Calculus I ............................................. 4
MATH 110B Calculus II ............................................ 4
MATH 115 Discrete Mathematics .................................... 3
PHYC 4A Physics for Scientists and Engineers ..................... 4
PHYC 4AL Phsyics Laboratory for Scientists & Engineers ........... 1
PHYC 4B Physics for Scientists and Engineers ..................... 4
PHYC 4BL Physics Laboratory for Scientists & Engineers ........... 1
    Total Units ................................................. 33

*Students who complete CS 110B must take CS 110C, and students who complete CS 111B must take CS 111C.

Computer and Information Science

The Major in Computer and Information Science prepares students for transfer to a four-year college for majors such as Information Science, Electronic Commerce, and Information Technology. Students should consider transfer applicability to their desired 4-year college when choosing whether to take the programming sequence in C++, Java, or C#.

Courses Required for the Major in Computer & Information Science

Course                                                           Units
CS 110A/111A Intro to Programming (C++/Java) ..................... 3
CS 110B/111B/114B Programming Fundamentals (C++/Java/C#) ......... 3
MATH 75 Math Analysis for Business ............................... 3
ACCT 1 Financial Accounting ...................................... 4
ACCT 2 Manag Acct ................................................ 4
ECON 1 Macroeconomics ............................................ 3
    Total Units ................................................. 20

Certificate Curricula

The certificate programs are designed to meet the needs of students who want 1) to obtain entry-level employment, 2) to increase their opportunities to advance in their current positions, or 3) to change the kind of work they do currently. Certificate programs make it possible for a student to demonstrate specialization in the areas such as computer programming, multimedia, and Unix administration and programming.

Requirements for the Certificate. A student may obtain the Certificate of Accomplishment by completing each of the courses offered in the certificate program with a grade of C or higher while maintaining a 2.00 GPA at City College. Pass/No-Pass grades will not be accepted toward completion of a certificate program. Core courses must be taken at CCSF.

Five certificate programs are available. Each program prepares a student for a different career path. Additional information is available from the Department degree advisor or the Department Chairperson.

Certificate in Computer Programming: C++
Certificate in Computer Programming: Java
Certificate in Computer Programming: Visual Basic.NET with Database
Certificate in Multimedia Programming
Certificate in Unix/Linux Administration
Certificate in Unix/Linux Programing

Computer Programming: C++

The program of study for the certificate in Computer Programming: C++ includes instruction and practice in the C++ programming language, as well as computer systems and the principles of automatic business data processing. This course of study prepares students for entry-level positions in quality assurance and computer programming in a variety of settings.

Courses Required for the Certificate of Accomplishment in Computer Programming: C++

Course                                             Unit
CS 160A Introduction to Unix/Linux ................. 2
CS 101 Intro to Information Systems
    or CS 176 Systems Analysis and Design
    or CS 177 Software Engineering ................. 3
CS 110A Introduction to Programming: C++ ........... 3
CS 110B Programming Fundamentals: C++ .............. 3
CS 110C Data Structures and Algorithms: C++ ........ 3
CS 150A Intro to Databases Using T-SQL
    or CS 151A Oracle SQL Databases 
    or CS 155A MySQL Databases ..................... 3
    Total Units ................................... 17

Students must achieve a grade of C or higher in all courses. Where available, grades of "Credit" may also be used.

Computer Programming: Java

The program of study for the certificate in Computer Programming: Java includes instruction and practice in the Java programming language, as well as computer systems and the principles of automatic business data processing. This course of study prepares students for entry-level positions in quality assurance and computer programming in a variety of settings.

Courses Required for the Certificate of Accomplishment in Computer Programming: Java

Course                                             Units
CS 160A Introduction to Unix/Linux ................. 2
CS 101 Intro to Information Systems
    or CS 176 Systems Analysis and Design
    or CS 177 Software Engineering ................. 3
CS 111A Intro to Programming: Java ................. 3
CS 111B Programming Fundamentals: Java ............. 3
CS 111C Data Structures and Algorithms: Java ....... 3
CS 150A Intro to Databases Using T-SQL
    or CS 151A Oracle SQL Databases
    or CS 155A MySQL Databases
    or CS 211S Advanced Java: Standard Edition
    or CS 211E Advanced Java: Enterprise Edition
    or CS 211M Advanced Java: Micro Edition ...... 2-3
    Total Units ................................. 16-17

Students must receive a grade of C or higher in all courses. Where available, grades of "Credit" may also be used.

Computing Skills for Scientists

This certificate will give working scientists an introduction to technical computing skills. Students will learn the basics of working in a Unix or Linux environment, will learn basic programming techniques using Perl, and will learn database fundamentals using MySQL. This certificate can be completed in one semester.

Courses Required for the Certificate of Accomplishment in Computing Skills for Scientists

Course                                             Units
CS 160A Introduction to Unix/Linux ................. 2
CS 113A Introduction to Perl Programming ........... 3
CS 155A MySQL Databases ............................ 3
    Total .......................................... 8

Students must receive a grade of C or higher in all courses. Where available, grades of "Pass" may also be used.

Database Programming

This certificate is designed to intoduce students to database fundamentals and computer program interaction with databases. It is expected that students have at least one semester of programming experience before attempting this certificate, such as CS 110A, 111A, or 112A.

Courses Required for the Certificate of Accomplishment in Database Programming

Concentration in Oracle

Course                                             Units         
CS 151A Oracle SQL Databases ....................... 3
CS 151B Oracle Database Administration ............. 3
CS 151P Oracle PL/SQL Programming .................. 3
CS 159A Database Design and Modeling ............... 3
    Total Units.................................... 12

Concentration in MySQL/Open Source Technologies

CS 155A MySQL Databases ............................ 3
CS 155B MySQL Database Administration .............. 3
CS 130A PHP Programming
    or CS 113A Intro to Perl Programming
    or CS 131A Python Programming .................. 3
CS 159A Database Design and Modeling ............... 3
    Total Units ................................... 12

Concentration in Microsoft

CS 150A Intro to Database Using T-SQL .............. 3
CS 152A Prog SQL Server Using T-SQL ................ 4
CS 112D Visual Basic .NET w/ Databases ............. 3
CS 159A Database Design and Modeling ............... 3
    Total Units ................................... 13

Students must receive a grade of C or higher in all courses. Where available, grades of “Credit” may also be used.

Multimedia Programming

Multimedia Studies is a multi-disciplined curriculum in the design, development, tools, and production of interactive media. Four certificates of concentration are in Web Design and Graphics, Image and Sound, Performance Arts, and Computer Programming. (See Multimedia Studies in the IDST program for complete details.)
Multimedia Programming includes instruction and practice in specific programming languages and authoring tools. This course of study prepares graduates for entry level positions in computer programming in the multimedia field.

Unix/Linux Administration

The program of study for the certificate in Unix/Linux Administration includes instruction and practice in using and administering a Unix/Linux system. This course of study prepares students for entry-level positions in Unix/Linux operations and administration.

Courses Required for the Certificate of Accomplishment in Unix/Linux Administration

Course                                             Units
CS 160A Introduction to Unix/Linux ................. 2
CS 160B Unix/Linux Shell Scripting ................. 2
CS 260A Unix/Linux System Admin .................... 3
CNIT 270 Unix/Linux Network Services ............... 3
CNIT 271 Apache Web Server Introduction ............ 1

Choose one from the following group

CS 113A Introduction to Perl Programming ........... 3
CS 161 C for Unix and Linux ........................ 3

Choose one from the following group

CNIT 106 Introduction to Networks .................. 3
CNIT 201 Internetwork Design ....................... 3
    Total Units ................................... 17

Students must receive a grade of C or higher in all courses. Where available, grades of "Credit" may also be used.

Unix/Linux Programming

The program of study for the certificate in Unix/Linux Programming includes instruction and practice in writing computer programs for a Unix/Linux system. this course of study prepares students for entry-level positions in Unix/Linux operations. It is required that a student have completed the certificate in Unix/Linux Adminstration prior to pursuing this program of study.

Courses Required for the Certificate of Accomplishment in Unix/Linux Programming

Course                                             Units
CS 113A Introduction to Perl Programming*
    or CS 161 C for Unix and Linux* ................ 3
CS 261A Unix/Linux System Programming .............. 3
CS 261B Advanced Unix/Linux System Programming ..... 3
CS 262 Unix/Linux Network Programming .............. 3

Choose one from the following group

CS 113B Object-Oriented Perl Programming ........... 3
CS 130A PHP Programming ............................ 3
    Total Units ................................... 15

*Students will have taken either CS 113A or CS 161 as part of completing the Certificate  in Unix/Linux Administration. To 
get the certificate in Unix/Linux Programming, they will need to take the other course.

Students must receive a grade of C or higher in all courses. Where available, grades of "Credit" may also be used.

Computer Programming: Visual Basic.NET with Database

The program of study for the certificate in Computer Programming: Visual Basic.NET with Database includes instruction and practice in the programming language Visual Basic.NET and in database theory, design, and programming. This course of study prepares students for entry-level positions in computer programming in a variety of settings.

Courses Required for the Certificate in Computer Programming: Visual Basic.NET with Database

Course                                             Units
CS 112A Intro to Visual Basic.NET ................. 3
CS 112B Visual Basic.NET Object Oriented .......... 3
CS 112D Visual Basic.NET w/ Databases ............. 3
CS 150A Intro to Databases Using T-SQL ............ 3
CS 152A Programming SQL Server using Transact-SQL . 3
CS 159A Database Design and Modeling .............. 3
    Total Units ...................................18

Students must receive a grade of C or higher in all courses. Where available, grades of "Credit" may also be used.