Due to the COVID-19 pandemic, access to Columbia College is restricted to students
with in person labs and essential personnel only. CTE Division employees are working
remotely to serve students and our community. To reach us, call (209) 588-5142 or
emailmooret@yosemite.edu
Degrees Offered
Programming
Associate in Sciences (AS): Computer Programming
Catalog Listing
Pathway
Digital Media
Associate in Science (AS): Multimedia Technology
Catalog Listing
Pathway
Certificate of Achievement (COA): Multimedia Technician - Digital Media
Catalog Listing
Pathway
Skills Accomplishment Certificates (SAC)
Digital Graphic Arts for Entrepreneurs (Catalog Listing)
Multimedia Technician for Entrepreneurs (Catalog Listing)
Video Production for Entrepreneurs (Catalog Listing)
Digital Media for Business
Associate in Sciences (AS): Business Digital Media Development
Catalog Listing
Pathway
Program Overview
More so than any other time in history, computers play a vital and essential role
in our daily lives, both personally and professionally. Solid computer skills are
a necessity, not a luxury – combining computer skills, good communication and business
knowledge will make you an extremely valuable asset to almost any employer, and ensure
your chances of advancing upward more quickly.
Whether you are a novice first learning about computers or a seasoned veteran already
well along in your career and simply looking for the opportunity to polish your existing
skill set, Columbia College's Computer Programming and Information Systems department
offers courses with concepts you can apply to your goals.
The strength of Columbia's Computer Programming and Information Systems program lies
with our talented team of instructors, who combine effective teaching methods with
years of combined business and industry experience. Our courses are based on real-life
projects using industry standard applications, and through partnerships with the businesses
in the community, we offer practical work experience at applicable job sites for our
students.
The curriculum specializes in two areas: Programming (CCTPG) and Information Systems
(CCTIS), which includes our Geographic Information Systems courses. Also, the fundamentals
taught in this program are compatible with and supportive of those taught in the Entrepreneurship,
Business Administration, Office Technology, and other departments. And if you're looking
to get your head start of a four-year education here, most of the courses are transferable
to four-year universities – plus you can take advantage of the smaller class sizes
and individualized instruction before moving on to bigger classrooms.
First course in computer programming for students with little or no programming experience.
Covers computer architecture, data representation, file systems and networks, software
development methods (structured and object-oriented design), and basic problem-solving
using analysis, documentation, algorithm design and control structures. Write programs
using scripting languages such as JavaScript or Python, and a compiled, object-oriented
language such as Java. This course is designed for majors and non-majors.
Note: Examples of student work in this course and Columbia College's Programming coursework
in general can be foundhere.
Programming Concepts and Methodology I (COMP 11J/11P)
Designed for computer science majors but open to all students. Emphasizes problem
analysis skills and algorithm development. Software engineering skills will be developed
for both procedural and object-oriented programming techniques. Programming language
will be the currently preferred object-oriented language used by equivalent UC/CSU
courses. Extensive programming projects demonstrating problem-solving and implementation
skills will be assigned throughout the semester, including use of data types, conditions
and Boolean logic, loops, recursion, arrays, functions, references, and file input/output.
Programming Concepts and Methodology II (COMP 12J/12P)
A continuation of CCTPG 22 for computer science majors. Problem-solving techniques
using an object-oriented design approach. Programming language will be the currently
preferred object-oriented language used by equivalent UC/CSU courses. Topics include
asymptotic notation, dynamic data structures (linked lists, stacks, queues, binary
trees), directed graphs, generics, and searching/sorting algorithms. Also introduces
programming in an event-driven GUI environment.
Database Management (COMP 70)
Fundamentals of database design and administration. Covers basic terminology, types
of database systems, and how to design a database appropriate to an application. Topics
include linking of tables in a relational database, SQL commands, Query By Example,
and design of input forms and reports. Hands-on component uses a current commercial
database management system in a Windows environment.
Networking Essentials (COMP 60)
An introduction to computer networking and data communications. The focus is on concepts,
terminology, and technologies in current networking environments. It is based on,
and covers the Open System Interconnect (OSI) model including discussions of Local
and Wide Area Networks (LAN & WAN). A laboratory component provides hands-on experience
in network setup and computer configuration. Includes the first semester of Cisco
Networking Academy Program which prepares students for Cisco Certified Network Association(CCNA)
certification. The topics covered are also applicable to Microsoft Certified Systems
Engineer (MCSE) and other industry networking certifications.
Computer Concepts and Information Systems (COMP 1)
This course includes concepts of computer information systems in business, industry
and other institutions. Study of computers, applications and network communications
will also be covered. Actual practice is on personal computers in Windows environment
on a network. Lab applications include graphical user interface, spreadsheets, word
processing, database management, multimedia presentations and access to the Internet
and World Wide Web.
Project Management (COMP 29)
This course is designed to familiarize individuals with current and emerging project
management technologies using the Internet, project management software and other
application software packages as needed for project completion. Project management
knowledge topics will include project integration, scope, time, cost, quality, human
resource, communications, and risk and procurement management. Credit may be earned
for only one of the following: CCTIS 29 or BUSAD 29.
