Computer Information Science

¹The corequisite for this course can be applied to the CRC graduation requirements.

The CIS - Computer Science Associate in Science (A.S.) degree may be obtained by completion of the required program, plus general education requirements, plus sufficient electives to meet a 60-unit total. See CRC graduation requirements.

Upon completion of this program, the student will be able to:

• Redefine a complex problem into a sequential set of parts that can be translated into the language of programming logic.
• Design, write, test, and debug computer programs in a structured language, a low-level language, and an object-oriented language.
• Incorporate foundational data management concepts such as data structures within computer programs.

¹or CompTIA's ITF+ certification

²or CompTIA's A+ certification

³or Microsoft AZ-800 certification

⁴or CompTIA Network+ certification

⁵or CompTIA Security+ certification

The Cybersecurity and Information Assurance Associate in Science (A.S.) degree may be obtained by completion of the required program, plus general education requirements, plus sufficient electives to meet a 60-unit total. See CRC graduation requirements.

Upon completion of this program, the student will be able to:

• Design and produce business information systems solutions incorporating current Information Technology, trends, security, and best practices (PSLO 1).
• Execute Linux system commands from either a keyboard or a shell script using correct command syntax (PSLO 2).
• Analyze and implement security concepts and security policies (PSLO 3).
• Analyze common threats to and vulnerabilities of computer systems and networks (PSLO 4).
• Implement and manage Cisco secure networks (PSLO 5).
• Implement network perimeter defense (PSLO 6).

Some career opportunities associated with this degree include: security analyst, network systems security administrator, security policy analyst, information technology specialist (State of California) and more.

¹or CompTIA ITF+ certification

²or CompTIA A+ certification

The Information Technology Associate Associate in Science (A.S.) degree may be obtained by completion of the required program, plus general education requirements, plus sufficient electives to meet a 60-unit total. See CRC graduation requirements.

Upon completion of this program, the student will be able to:

• PSLO #1: Apply fundamental knowledge of computing and the current use of technology techniques, skills, and tools necessary for the computing practice.
• PSLO #2: Evaluate and solve business problems with technology solutions using qualitative and quantitative information.
• PSLO #3: Assess user needs in the selection, creation, evaluation and administration of computer-based information systems.
• PSLO #4: Demonstrate appreciation of the Information Technology career field and the need to be lifelong learners.

The Associate's degree in Information Technology prepares students to either enter the workforce as an entry-level computer or network support technician or pursue a bachelor's degree in managing information systems. Several CSUs currently offer baccalaureate IT or CT programs, as do several private universities.

¹MATH 341 is recommended, but the other courses listed in this group will also meet the second MATH course requirement for Business Administration majors (all Concentrations, including Management Information Systems) transferring to CSU Sacramento.

The Management Information Systems Associate in Science (A.S.) degree may be obtained by completion of the required program, plus general education requirements, plus sufficient electives to meet a 60-unit total. See CRC graduation requirements.

Upon completion of this program, the student will be able to:

• Apply fundamental information and communication technology concepts in various types of organizational settings (PSLO #01).
• Organize data sets by using spreadsheet application software in various types of organizational settings (PSLO #02).
• Apply fundamental accounting concepts and principles to decision-making processes in various organizational settings (PSLO #03).
• Apply fundamental economics concepts and principles to decision-making processes in various organizational settings (PSLO #04).
• Apply fundamental legal concepts and principles to decision-making processes in various organizational settings (PSLO #05).
• Use statistical and mathematical methods to support decision-making processes in various organizational settings (PSLO #6).

Applications Software Specialist; Business Operations Manager;

The Web Developer Associate in Science (A.S.) degree may be obtained by completion of the required program, plus general education requirements, plus sufficient electives to meet a 60-unit total. See CRC graduation requirements.

Upon completion of this program, the student will be able to:

• Manage a multi-level Web site hosted on a Web server.
• Utilize multiple programs simultaneously in order to develop Web sites.
• Recommend Web scripting language, current markup language or Web authoring software, and cascading style sheets to develop complex Web sites that are uploaded via File Transfer Protocol (FTP) to a Web server.
• Research and implement current, valid World Wide Web Consortium (W3C) standards including technical recommendations for markup languages, and other recommendations as they are introduced.
• Plan a structured approach to Web site development that identifies the information dissemination needs of a client and organizes the content effectively and efficiently in order to communicate to an identified audience; then develop and implement an appropriate Web solution.
• Utilize client-side scripting in order to manipulate interactive objects like navigation bars, forms, rollovers, other event handling, and the control of windows, frames, and/or layers.
• Develop Web solutions that include form validation and processing, server-side programming, and database-driven Web development.
• Demonstrate proficiency in the process of Web project management on a real-world Web site including design specification, research, production, modification, time estimation, and presentation.
• Write code in a currently used Web scripting language.

This Web Developer Degree prepares students to become Web Developer, Webmaster, Systems Analyst, Web Systems Analyst, IT Analyst, ICT Analyst, Web Database Administrator, Back-end Developer, and Web Programmer.

¹Substitute course, BUSTEC 126 - Outlook: Basics is available at Folsom Lake College, or Course CISA 126 - Outlook: Basics is available at American River College.

²Substitute course(s), CISC 300 - Computer Familiarization, is available at American River College and Sacramento City College, BUSTEC 309 - Computer Familiarization is available at Folsom Lake College.

³Substitute course, BUSTEC 360 - Word Processing Beyond the Essentials, is available at Folsom Lake College.

⁴Substitute course, BUSTEC 362 - Comprehensive Electronic Spreadsheets, is available at Folsom Lake College.

⁵Substitute course, BUSTEC 366 - Electronic Presentations, is available at Folsom Lake College.

⁶Substitute course, BUSTEC 498 - Work Experience in Business Technology, is available at Folsom Lake College.

Upon completion of this program, the student will be able to:

• PSLO #1: DEMONSTRATE COMMON OFFICE APPLICATION SKILLS.
• Demonstrate proficiency in business technology applications.
• Construct projects efficiently generating solutions using various workplace computer programs and shortcuts.
• PSLO #2: DEMONSTRATE COMMON OFFICE ADMINISTRATION SKILLS.
• Demonstrate proficiency in business administration skills.
• Integrate the features of working with tasks and schedules to organize both professional and personal information.
• PSLO #3: DEMONSTRATE BASIC OFFICE COMMUNICATION SKILLS.
• Demonstrate proficiency in business communication skills.
• Identify techniques to send, receive and manage email messages.
• PSLO #4: EXAMINE CUSTOMER SERVICE NEEDS AND REQUIREMENTS
• Apply customer service skills in a business environment and provide a positive customer service experience.
• Analyze the extent to which customer service is facilitated by the effective use of technology.

Students who successfully complete the Business Information Professional Certificate are prepared for entry-level positions in office, computer, and administrative support positions in a variety of industries.

To be eligible for enrollment in the program, the student must meet the following criteria:

• (None)

Eligible students are selected for the program according to the following steps:

• (None)

Upon completion of this program, the student will be able to:

• PSLO #1. DEMONSTRATE COMMON OFFICE APPLICATIONS SKILLS.
• Diagram and differentiate basic computer terminology and apply it to communication.
• Construct and modify solutions to simple personal, educational or business needs applying use of office workplace computer programs.
• Design, diagram, and construct simple file folder structure on local storage, and access files for upload/download to/from online tools.
• Formulate expressions and construct logic comparisons using proper symbols and syntax in workplace computer programs.
• Create and organize various types of files using various workplace computer programs.
• Construct projects efficiently generating solutions using various workplace computer programs and shortcuts.
• Demonstrate the mechanics and use of word processing software to organize and present data in a multicolumn, multipage newsletter format including banner, bordering, tables, text effects and embedded graphics.
• Demonstrate appropriate pagination and word processing features to apply a formal (MLA/APA/Chicago) style of documentation in the creation of a multi-section research paper or report with Table of Contents, Index, and Bibliography.
• Design and construct a form using multiple content controls.
• Apply advanced Excel tools such as pivot tables, pivot charts, and templates to workbooks.
• Create audience centric business documents to enhance readability.
• PSLO #2. DEMONSTRATE COMMON OFFICE ADMINISTRATION SKILLS.
• Integrate the features of working with tasks and schedules to organize both professional and personal information.
• Design and assess plans for backup and maintenance of Outlook files and information.
• Analyze trends in technologies and evaluate their effects on organizational data analysis.
• PSLO #3. DEMONSTRATE BASIC OFFICE COMMUNICATION SKILLS.
• Identify techniques to send, receive and manage email messages.
• Analyze business situations and determine appropriate methods to deliver negative and positive messages.
• PSLO #4. EXAMINE CUSTOMER SERVICE NEEDS AND REQUIREMENTS.
• Explain the elements of a service culture.
• Analyze strategies for promoting a positive service culture.
• Analyze the extent to which customer service is facilitated by the effective use of technology.

Students who successfully complete the Business Information Worker Certificate are prepared for entry-level positions in general office environments in a variety of fields.

Upon completion of this program, the student will be able to:

• List and describe the hardware components of a computer system and differentiate among system and application software.
• describe and assess the relationship of operating systems to database file management.
• devise computerized solutions in the development of databases by applying a solid foundation of algorithmic principles.
• compare and contrast hierarchical, network, and relational databases.
• design, create, and administer relational databases
• design and develop tables, forms, queries, and reports using SQL.

Computer Operator; Programmer; Computer Systems Specialist

Upon completion of this program, the student will be able to:

• list the hardware components of a computer system and differentiate among system and application software.
• describe the relationship of operating systems to database file management.
• devise computerized solutions in the development of databases by applying a solid foundation of algorithmic principles.
• compare and contrast hierarchical, network, and relational databases.
• design, create, and administer relational databases.
• create client applications using structured query language (SQL).

Upon completion of this program, the student will be able to:

• SLO# 1: Describe relational database technologies for desktop, enterprise and Internet platforms.
• Analyze and employ relational database technologies to solve common business problems using standard database principles and practices.
• SLO# 2: Explain and discuss database theory and principles.
• SLO# 3: Select Entity-Relationship diagrams to solve problems related to database design.
• SLO# 4: Devise computerized solutions in the development of databases by applying a solid foundation of algorithmic principles and SQL.
• Apply techniques of Structured Query Language Programming to solve problems related to information retrieval from relational databases.
• SLO# 5: Evaluate proposed database design solutions and create relational databases to meet stated objections

Computer Operator; Applications Software Specialist; Programmer; Data Entry Specialist; Database Designer; Database Developer.

To be eligible for enrollment in the program, the student must meet the following criteria:

• Pass CISP360, Introduction to Structured Programming, or equivalent course with a C or better.

Upon completion of this program, the student will be able to:

• Formulate problems as steps so be able to solve systematically.
• Describe the principles of object oriented programming.
• Use structure programming skills proficiently in an object oriented program.
• Apply the concepts of object oriented programming skills such as reusability, portability, data encapsulation, inheritance, polymorphism and etc. to a program.
• Design and develop programs with Graphical User Interfaces.
• Use an object oriented language to develop solutions for real life projects in a team work environment.

This certificate is designed to prepare students for advancing their study in game programming, computer science, computer engineering, software engineering, computer graphics, and other related fields for under graduate and graduated study. It could be used for students to improvement their job skills in high tech computer science, computer programming, game programming, research, teaching, etc.

Upon completion of this program, the student will be able to:

• Apply Object and Structure programming in programs
• Use a C/C++ programming development tool to develop programs.
• Communicate and analyze programming problems, and determine what object-oriented programming approach would be most appropriate to resolve them.

Computer Operator; Applications Software Specialist; Programmer; Data Entry Specialist; Systems Analyst, and Database Administrator.

Upon completion of this program, the student will be able to:

• Analyze and list the hardware components of a computer system and differentiate among system and application software.
• Plan and design tables, forms, queries, and reports using office database application software.
• Assess and design multi-table forms, establish table relationships
• Describe the relationship of operating systems to database file management.
• Devise computerized solutions in the development of databases by applying a solid foundation of algorithmic principles.
• Compare and contrast hierarchical, network, and relational databases.
• Demonstrate ability to design, create, and administer relational databases.
• Create client applications using structured query language (SQL).

Computer Operator; Applications Software Specialist; Systems Analyst; Programmer; Data Entry Specialist; Computer Systems Specialist; Computer Technician

¹Linux Operating System

²C or C#

Upon completion of this program, the student will be able to:

• PSLO 1: Design, develop, support, and maintain professional Web pages.
• PSLO 2: Demonstrate knowledge of web-related technology and media applications.
• PSLO 3: Be competent evaluators and users of the World Wide Web.
• PSLO 4: Adapt to technological changes and select a current solution for a given problem.
• PSLO 5: Understand how to deal with interoperability between different products, systems, and platforms.
• PSLO 6: Find effective solutions to maintaining and supporting web sites and related resources.

Full-Stack Web Developer; Front/Back-end Web Developer; Computer Operator; Applications Software Specialist; Programmer; Data Entry Specialist; Internet Technician

¹Select either Windows (through CISC 308) or Linux (through CISC 323) operating system.

²CISW 310 is recommended to meet this 4-unit requirement.

Upon completion of this program, the student will be able to:

• Demonstrate knowledge of web-related technology and media applications.
• Be competent evaluators and users of the World Wide Web.
• Adapt to technological changes and select a current solution for a given problem.
• Understand how to deal with interoperability between different products, systems, and platforms.
• Find effective solutions to maintaining and supporting web sites and related resources.

Applications Software Specialist; Data Entry Specialist; Computer Technician; Internet Technician

¹The one that you take will depend on your transfer university. Speak with a CRC counselor for more information.

Upon completion of this program, the student will be able to:

• PSLO #1 Design an algorithm from data types, operations, and logic structures to solve complex problems.
• PSLO #2 Refactor a complex algorithm into single job components such as functions or modules.
• PSLO #3 Translate an algorithm into a low-level or high-level programming language.
• PSLO #4 Compare and contrast the data, operations, and logic structure of a high-level language such as C++ and a low-level language such as Assembly Language.
• PSLO #5 Organize data and functions into classes.
• PSLO #6 Organize data into structures such as trees, linked lists, and dictionaries.
• PSLO #7 Construct a recursive algorithm to solve a word problem.
• PSLO #8 Model simple computation using finite state automata and regular languages.

The North/Far North Center of Excellence (April 2019) compiled a report that gave the job prospects for software development occupations in the Sacramento region. The report found that Computer Programmers, Software Developers (Applications and Systems Software), and Web Developers have been and will continue to be in demand. The demand for these occupations is expected to increase in the Greater Sacramento region. The report noted that these careers pay well above the Sacramento County Living Wage.

¹or Microsoft AZ-800 certification

²or CompTIA Network+ certification

³or CompTIA Security+ certification

Upon completion of this program, the student will be able to:

• PSLO 1: Describe the key concepts in network defense (defense in depth, minimizing exposure, etc.).
• PSLO 2: Explain how network defense tools (firewalls, IDS, etc.) are used to defend against attacks and mitigate vulnerabilities.
• PSLO 3: Analyze how security policies are implemented on systems to protect a network.
• PSLO 4: Evaluate how network operational procedures relate to network security.

Cyber Defense Analyst - Uses data collected from a variety of cyber defense tools (e.g., IDS alerts, firewalls, network traffic logs) to analyze events that occur within their environments for the purposes of mitigating threats. Cyber Defense Infrastructure Support Specialist - Tests, implements, deploys, maintains, and administers the infrastructure hardware and software. Cyber Defense Incident Responder - Investigates, analyzes, and responds to cyber incidents within the network environment or enclave. Vulnerability Assessment Analyst - Performs assessments of systems and networks within the network environment or enclave and identifies where those systems/networks deviate from acceptable configurations, enclave policy, or local policy. Measures effectiveness of defense-in-depth architecture against known vulnerabilities.

¹or CompTIA A+ certification

²or CompTIA ITF+ certification

³or CompTIA Linux+ certification

⁴or CompTIA Network+ certification

⁵or CompTIA Security+ certification

⁶or CISCO CCENT certification

⁷or CCNA CyberOPS certification

⁸or CCNA Automation and Programmability certification

⁹or CCNA Security certification

Upon completion of this program, the student will be able to:

• Design and produce business information systems solutions incorporating current Information Technology, trends, security, and best practices (PSLO 1).
• Execute Linux system commands from either a keyboard or a shell script using correct command syntax (PSLO 2).
• Analyze and implement security concepts and security policies (PSLO 3).
• Analyze common threats to and vulnerabilities of computer systems and networks (PSLO 4).
• Implement and manage Cisco secure networks (PSLO 5).
• Implement network perimeter defense (PSLO 6).

Some career opportunities associated with this degree include: security analyst, network systems security administrator, security policy analyst, and more.

¹or CompTIA A+ certification

²or Microsoft AZ-800 certification

³or CompTIA Security+ certification

Upon completion of this program, the student will be able to:

• PSLO #1: Apply fundamental knowledge of computing and the current use of technology techniques, skills, and tools necessary for the computing practice.
• PSLO #2: Evaluate and solve business problems with technology solutions using qualitative and quantitative information.
• PSLO #3: Assess user needs in the selection, creation, evaluation and administration of computer-based information systems.
• PSLO #4: Demonstrate appreciation of the Information Technology career field and the need to be lifelong learners.

The Certificate in Information Technology prepares students to either enter the workforce as an entry-level computer or network support technician. Several CSUs currently offer baccalaureate IT or CT programs, as do several private universities.

¹or CompTIA ITF+ certification

²or CompTIA A+ certification

Upon completion of this program, the student will be able to:

• Analyze the fundamentals of an operating system. Examine the relationship of the operating system to other applications programs (PSLO #1).
• Demonstrate knowledge of networking technology. Judge the strengths and weaknesses of the different network operating systems and technologies (PSLO #2).
• Analyze the effects of an application on a network operating system (PSLO #3).
• Analyze the effects of network intruders and viruses on an application and an operating system (PSLO #4).

Computer Operator; Applications Software Specialist; Information Technology Technician