Computer And Communications Technology Computer And Communications Technology

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 email  mooret@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.

Career Training

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. 

Student Networking

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.

Course Descriptions

Introduction to Programming (COMP 10)

  • 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 found here

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.

 

Please click here for the CCT to COMP Course ID Conversion Crosswalk. 

 
OU Campus Login