Computer Information Science

¹Substitute course, BUSTEC 126 - Outlook: Basics, is available at Folsom Lake College.

²Substitute course(s), CISC 300 - Computer Familiarization, is available at American River College, and 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, BUS 312 - Workplace Behavior and Ethics, is available at American River College.

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

⁸Substitute courses: PRJMGT 300 - Introduction to Project Management, available at Folsom Lake College; MGMT 142 - Project Management Techniques and Software, available at American River College; CISA 160 - Project Management Techniques and Software, available at American River College.

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

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

• Demonstrate an understanding of major functional areas of business organizations including planning, management, marketing, and finance.
• Exhibit an understanding of accounting as an information system and how it is used by investors, creditors, and others to make decisions. Understand the recording and reporting of business transactions, generally accepted accounting principles, financial statements, and statement analysis.
• Demonstrate proficiency in advanced business technology applications and employ computer applications to create relevant business documents.
• Demonstrate proficiency in business administration and leadership skills needed to manage a multicultural workforce.
• Employ customer service skills in a business environment and skills required to deliver a positive customer service experience.
• Compose effective oral and written communications in various business settings.
• Research, develop, evaluate, and test possible solutions using creativity, critical thinking, and technology skills.

Business information professionals are employed in many different industries. These middle-skill occupations require more education and training than a high school diploma but less than a four-year degree and include positions such as customer service representatives, receptionists and information clerks, and executive secretaries and executive administrative assistants. With an A.S. degree, the higher level opportunities include: business analysts, technical support specialists, and first-line supervisors of office and administrative support workers.

¹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, and either (a) the Local General Education Pattern or (b) the California General Education Transfer Curriculum (Cal-GETC), plus sufficient electives for a total of at least 60 units. 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, and either (a) the Local General Education Pattern or (b) the California General Education Transfer Curriculum (Cal-GETC), plus sufficient electives for a total of at least 60 units. 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, and either (a) the Local General Education Pattern or (b) the California General Education Transfer Curriculum (Cal-GETC), plus sufficient electives for a total of at least 60 units. 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, and either (a) the Local General Education Pattern or (b) the California General Education Transfer Curriculum (Cal-GETC), plus sufficient electives for a total of at least 60 units. 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, and either (a) the Local General Education Pattern or (b) the California General Education Transfer Curriculum (Cal-GETC), plus sufficient electives for a total of at least 60 units. 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.

¹Substitute course, BUS 312 - Workplace Behavior and Ethics, is available at American River College.

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

• PSLO #1: DEMONSTRATE PROFICIENCY IN ADVANCED BUSINESS TECHNOLOGY APPLICATIONS
• Evaluate the use of technology, leadership, and communication skills for business administration and managing a multicultural workforce.
• PSLO #2: DEMONSTRATE PROFICIENCY IN BUSINESS COMMUNICATION
• Manage the complexities of intercultural communications.
• PSLO #3: DEMONSTRATE CUSTOMER SERVICE SKILLS IN A BUSINESS ENVIRONMENT
• Choose approaches that may provide a positive customer service experience.

According to the Center of Excellence labor market data, business information professional jobs are projected to have an increase in annual openings in the North (Greater Sacramento) sub-region. These middle-skill occupations require more education and training beyond a high school diploma but less than a four-year degree and include positions such as first-line supervisors of office and administrative support workers, customer service representatives, receptionists and information clerks, and executive secretaries and executive administrative assistants.

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