Computer Information Science
Computer Information Science - Applications (CISA) Courses
CISA 305 Beginning Word Processing
- Units:2
- Hours:27 hours LEC; 27 hours LAB
- Prerequisite:CISC 300 or 310 with a grade of "C" or better
- Transferable:CSU
- Catalog Date:August 1, 2024
The course introduces the student, through hands-on activities, to the use of word processing on microcomputers. The course includes basic word processing operations such as terminology and screen formats, dialog boxes, text editing, text formatting, text enhancements, sorting, tables, merging functions, saving and retrieving, and printing text.
For this course, PC computers are used with the Windows Operating System, and applications supported by Windows. Students using a Macintosh computer, or any other device should be aware of differences in software that may impact steps for assignments as outlined or differences with assignment steps when using the textbook required for this course. Mac and Windows OS apply the same principles and fundamentals (ie., file management, etc.,); however, features on a Macintosh computer will work differently than those as instructed using the Windows Operating System. Software and textbook materials for this course are intended to be used with a Windows OS. Students should contact the professor if they need help accessing a PC with Windows and Windows applications needed to support this learning.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- create a professional quality document by evaluating needs, entering and editing text, making corrections, and saving in various formats.
- demonstrate the ability to edit and format documents using word processing commands and features.
- demonstrate usage of the mail merge functions.
- examine how to create accessible Microsoft Word documents that conform to the Information and Communications Technology (ICT) Accessibility 508 Standards and 255 Guidelines.
CISA 306 Intermediate Word Processing
- Units:2
- Hours:27 hours LEC; 27 hours LAB
- Prerequisite:CISA 305 with a grade of "C" or better
- Transferable:CSU
- Catalog Date:August 1, 2024
This course builds upon previous training in the use of word processing programs. The course includes a brief review of basic editing and text concepts, and then covers intermediate software features such as document processing functions, macro programming functions, complex document styles and commands, and table and graphics applications. The course incorporates all word processing features into the production of one final presentation.
For this course, PC computers are used with the Windows Operating System, and applications supported by Windows. Students using a Macintosh computer, or any other device should be aware of differences in software that may impact steps for assignments as outlined or differences with assignment steps when using the textbook required for this course. Mac and Windows OS apply the same principles and fundamentals (ie., file management, etc.,); however, features on a Macintosh computer will work differently than those as instructed using the Windows Operating System. Software and textbook materials for this course are intended to be used with a Windows OS. Students should contact the professor if they need help accessing a PC with Windows and Windows applications needed to support this learning.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- design and complete presentation quality documents essential in business using intermediate and advanced word processing commands and features.
- merge a main document with a data source file.
- record and run a macro.
- use word processing commands and features to create Web pages such as: creating and editing hyperlinks, applying background effects, and saving a word processing document as a Web page.
- plan and create online forms and tables for efficient data display and input data into customized forms.
- analyze and complete a multi-page business document including creating table of contents, adding indexes, and embedding and linking a spreadsheet object.
- examine how to create accessible Microsoft Word documents that conform to the Information and Communications Technology (ICT) Accessibility 508 Standards and 255 Guidelines.
CISA 315 Introduction to Electronic Spreadsheets
- Units:2
- Hours:27 hours LEC; 27 hours LAB
- Prerequisite:None.
- Advisory:CISC 300 or 310 with a grade of "C" or better
- Transferable:CSU
- Catalog Date:August 1, 2024
This course introduces the use of electronic spreadsheet programs. Topics of the course will include: professional formatting of spreadsheets; writing formulas and functions to perform mathematical operations; creating charts; creating, sorting, and filtering lists; developing what-if models, performing spreadsheet database functions, and producing reports. The course introduces 3-D cell referencing, various advanced look up and financial functions, and querying techniques.
For this course, PC computers are used with the Windows Operating System, and applications supported by Windows. Students using a Macintosh computer, or any other device should be aware of differences in software that may impact steps for assignments as outlined or differences with assignment steps when using the textbook required for this course. Mac and Windows OS apply the same principles and fundamentals (ie., file management, etc.,); however, features on a Macintosh computer will work differently than those as instructed using the Windows Operating System. Software and textbook materials for this course are intended to be used with a Windows OS. Students should contact the professor if they need help accessing a PC with Windows and Windows applications needed to support this learning.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- use an electronic spreadsheet application to plan, construct, test, and evaluate professional looking worksheets that include text, numbers, formulas, and functions.
- format a worksheet using standard layouts, formats, styles, and themes, special number formats, and conditional formatting.
- analyze data and apply mathematical functions of the program for building financial and data analysis spreadsheets; perform basic worksheet analysis using What-If, Goal Seek, and VLOOKUP procedures.
- utilize relative and absolute addressing when working with worksheets.
- design, create, and revise embedded as well as stand-alone charts based on commonly used standards.
- apply advanced spreadsheet features to analyze and manage data.
- manage multiple workbooks and worksheets using templates as well as consolidating, linking, and 3-D cell referencing procedures.
- examine how to create accessible Microsoft Excel spreadsheets that conform to the Information and Communications Technology (ICT) Accessibility 508 Standards and 255 Guidelines.
CISA 316 Intermediate Electronic Spreadsheets
- Units:2
- Hours:27 hours LEC; 27 hours LAB
- Prerequisite:CISA 315 with a grade of "C" or better
- Transferable:CSU (Effective SP15)
- Catalog Date:August 1, 2024
This course introduces students to the intermediate features of spreadsheet programs. The course covers macros, data tables and lookup functions, logical expressions as well as advanced file operations, functions, and convenience commands. Students will follow spreadsheet templates and design their own sheets.
For this course, PC computers are used with the Windows Operating System, and applications supported by Windows. Students using a Macintosh computer, or any other device should be aware of differences in software that may impact steps for assignments as outlined or differences with assignment steps when using the textbook required for this course. Mac and Windows OS apply the same principles and fundamentals (ie., file management, etc.,); however, features on a Macintosh computer will work differently than those as instructed using the Windows Operating System. Software and textbook materials for this course are intended to be used with a Windows OS. Students should contact the professor if they need help accessing a PC with Windows and Windows applications needed to support this learning.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- create, edit, and run macros.
- restrict data entry and ensure data integrity by creating validation criteria and rules.
- apply conditional formatting by entering parameters for rules, utilizing predefined rules, constructing new rules for individual or grouped worksheets.
- construct formulas using named ranges and advanced financial, logical, lookup, and database functions.
- analyze data by applying advanced math and statistical functions, data filtering options, and Business Intelligence tools.
- integrate data from various computer applications and web sites into a workbook using consolidation techniques and prepare workbook data for distribution to other applications.
- audit a worksheet using auditing tools to trace precedents, troubleshoot, and resolve errors in formulas.
- perform data analysis and summarizing data using PivotTables and PivotCharts.
- examine how to create accessible Microsoft Excel spreadsheets that conform to the Information and Communications Technology (ICT) Accessibility 508 Standards and 255 Guidelines.
CISA 323 Database Management using Microsoft Access
- Units:2
- Hours:27 hours LEC; 27 hours LAB
- Prerequisite:CISC 300 or 310 with a grade of "C" or better
- Transferable:CSU
- Catalog Date:August 1, 2024
This course introduces database management systems in a single-user environment. Topics include database objects, data types, data integrity, relational tables, complex queries, forms, reports, sharing data with other Windows applications, and data maintenance. Students who have completed both CISA 320 and CISA 321 may not receive credit for this course. For this course, PC computers are used with the Windows Operating System, and applications supported by Windows. The software used in the class is not available on Macintosh computers. Software and textbook materials for this course are intended to be used with a Windows OS. Students should contact the professor if they need help accessing a PC with Windows and Windows applications needed to support this learning.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- analyze needs and determine appropriate data structure and solutions essential for business or professional environments.
- create tables, queries, forms, and reports.
- formulate multiple table queries with complex criteria.
- design forms for data entry and data views.
- interpret data with crosstab queries and reports.
- build tables by importing delimited data and export data for sharing with other users.
- design and implement multiple table data management systems involving custom forms, reports, and labels.
- manage database objects, including backup and repair.
- examine screen reader support for Microsoft Access.
CISA 324 Intermediate Database Management using Access
- Units:2
- Hours:27 hours LEC; 27 hours LAB
- Prerequisite:CISA 323 with a grade of "C" or better
- Advisory:CISC 310 with a grade of "C" or better
- Transferable:CSU
- Catalog Date:August 1, 2024
This course will extend the capabilities of students who have completed a first course in microcomputer database management, with emphasis on database design, reporting, application building, and utilization of files created using other software. Students will design and implement practical database applications. Topics include relational database design, data normalization, administering databases on a server, and creating queries using select statements. For this course, PC computers are used with the Windows Operating System, and applications supported by Windows. The software used in the class is not available on Macintosh computers. Software and textbook materials for this course are intended to be used with a Windows OS. Students should contact the professor if they need help accessing a PC with Windows and Windows applications needed to support this learning.
Prerequisite may be fulfilled by completing both CISA 320 and CISA 321 (with a grade of "C" or better) at ARC, CRC, or FLC.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- use and debug macros.
- develop and update modules using Visual Basic for Applications (VBA).
- demonstrate techniques used for data normalization.
- utilize the fundamental vocabulary and constructs of Structured Query Language (SQL).
- create queries and subqueries using select statements in SQL.
- manage and develop security measures for database systems in a business environment.
CISA 340 Presentation Graphics
- Units:2
- Hours:27 hours LEC; 27 hours LAB
- Prerequisite:None.
- Advisory:CISC 300 or 310 with a grade of "C" or better
- Transferable:CSU
- Catalog Date:August 1, 2024
This course presents an in-depth look at using computers as a graphics presentation tool to assist oral, written, and on-screen presentations. Topics include system requirements, graphic software, elements of a good presentation, types of graphics, and designing slideshow techniques for visual presentations. Methods on how to edit and format presentations, animation, organizational charts, and clips (graphics, sounds, or video) will also be covered. Designing presentations linked to word processing, spreadsheet, or database programs is included. Students will use a variety of computer hardware and software to produce individual and/or group projects.For this course, PC computers are used with the Windows Operating System, and applications supported by Windows. Students using a Macintosh computer, or any other device should be aware of differences in software that may impact steps for assignments as outlined or differences with assignment steps when using the textbook required for this course. Mac and Windows OS apply the same principles and fundamentals (ie., file management, etc.,); however, features on a Macintosh computer will work differently than those as instructed using the Windows Operating System. Software and textbook materials for this course are intended to be used with a Windows OS. Students should contact the professor if they need help accessing a PC with Windows and Windows applications needed to support this learning.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- plan, prepare, and present on-screen effective presentations for business, professional, or personal purposes using basic design principles and concepts.
- edit presentations to include basic and advanced enhancements.
- link or embed existing files into presentations, including graphic, word processing, spreadsheet, audio, and video files.
- examine how to create accessible presentation documents that conform to the Information and Communications Technology (ICT) Accessibility 508 Standards and 255 Guidelines.
CISA 499 Experimental Offering in Computer Information Science - Applications
- Units:0.5 - 4
- Prerequisite:None.
- Transferable:CSU
- Catalog Date:August 1, 2024
This is the experimental courses description.
Computer Information Science - Core (CISC) Courses
CISC 299 Experimental Offering in Computer Information Science - Core
- Units:0.5 - 4
- Prerequisite:None.
- Catalog Date:August 1, 2024
This is the experimental courses description.
CISC 300 Computer Familiarization
- Units:1
- Hours:18 hours LEC
- Prerequisite:None.
- Transferable:CSU
- Catalog Date:August 1, 2024
This course acquaints students with how computers are used in the home and in business functions. The course emphasizes microcomputers, how they work, how they can be used, and the terminology of the computer world. Microcomputer applications using the Windows environment are presented with hands-on homework assignments. This course does not serve as a prerequisite to computer science programming courses but does serve as a prerequisite and advisory for Computer Information Science application courses. The course is specially designed for students wanting a very general, non-technical, introductory course in computers. For this course, PC computers are used with the Windows Operating System, and applications supported by Windows. Students using a Macintosh computer, or any other device should be aware of differences in software that may impact steps for assignments as outlined or differences with assignment steps when using the textbook required for this course. Mac and Windows OS apply the same principles and fundamentals (ie., file management, etc.,); however, features on a Macintosh computer will work differently than those as instructed using the Windows Operating System. Software and textbook materials for this course are intended to be used with a Windows OS. Students should contact the professor if they need help accessing a PC with Windows and Windows applications needed to support this learning.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- define common computer terminology and demonstrate an understanding of hardware components, types of software, Windows and Office commands.
- use basic computer and Windows functions including navigation, icons, menus, ribbons, creating folders and subfolders, and copying and moving files.
- use an Office application to create new files, save, edit, format, enter data, and print.
- understand the use of the Internet including search engines, web browsers, email, privacy and security, and managing a digital footprint.
CISC 305 Introduction to the Internet
- Units:1
- Hours:18 hours LEC
- Prerequisite:CISC 300, 310, or 320 with a grade of "C" or better
- Transferable:CSU
- Catalog Date:August 1, 2024
This course explains how the Internet works and how to effectively use basic internet services. Topics include browser basics, search engines and search techniques, e-mail, the World Wide Web (WWW), internet security, internet resources, the Cloud, social networking, and building a simple Web page using Hypertext Markup Language (HTML5). The course includes the review of laws that guide the use of the Internet and intellectual property on the Web. Other topics include Internet protocols, news groups, discussion lists, connecting to a remote server, (S)FTP (Secure File Transfer Protocol), and current emerging technologies.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- describe the structure of the Internet, the Domain Name System (DNS), and connectivity options.
- identify the tools and protocols for connecting to remote servers, such as telnet, transmission control protocol/internet protocol (TCP/IP), secure file transfer protocol (S)FTP, and the World Wide Web (WWW).
- describe the laws and international guidelines for use of the Internet in business, professional, or personal settings.
- experiment with the use of asynchronous communication tools, such as e-mail, discussion lists, and discussion boards.
- explain the use of synchronous communication, such as instant messenger and chat rooms, including the limitations of bandwidth and security.
- describe different types of protocols, (S)FTP, HTTP, and HTTPS. Use multiple browser applications to access and use the World Wide Web.
- examine the security and privacy issues related to using the Internet, including e-commerce, cloud computing and social media platforms. Examine your digital footprint and methods for monitoring. Examine types of threats or harm that can be caused from a digital footprint and/or using online tools.
- locate information stored on the Internet, determine the validity of online resources, assess the use of Artificial Intelligence (AI) and how AI may affect available resources comparative to peer reviewed library subscription databases, download and store files, and use the correct syntax for citing Internet resources.
- create a Web page applying proper HTML5 elements and structure.
CISC 310 Introduction to Computer Information Science
- Units:3
- Hours:54 hours LEC
- Prerequisite:None.
- Advisory:CISC 300 with a grade of "C" or better
- Transferable:CSU; UC
- General Education:AA/AS Area II(b)
- C-ID:C-ID BUS 140; C-ID ITIS 120
- Catalog Date:August 1, 2024
This course examines information systems and their role in business. Hardware, software, networking, e-commerce, ethics, security, and system infrastructure will be examined. Use of ordinary office applications used in the workplace will be introduced. Students will apply technical concepts and related methods through hands-on projects to develop computer-based solutions to business problems. This course will introduce computer programming basics, Web coding basics, employment opportunities in Information Technology and Computer Information Science. Impacts of technology use today will also be discussed. Students should have computer navigation skills, locally and online, know how to create files and folders and understand how to upload or download files to/from the Internet.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- examine how a computer system works, identify hardware components, compare storage formats, apply file management strategies, including folder and file creation, saving in different file types (.txt, .html, .pdf, etc.) and demonstrate the use of an operating system.
- differentiate between the most commonly used computer operating systems.
- examine anti-virus software and implement file management strategies for storage of electronic data.
- demonstrate use of application software (word processing, spreadsheets, database, presentation graphics).
- demonstrate use of cloud-based applications and cloud-based file storage.
- apply HTML5 code to create a Web page using proper structure for a file.
- differentiate between categories of programming languages.
- design and create a simple computer program.
- convert numbers between the decimal and binary numbering systems.
- differentiate between types of careers in the computer information science field.
- examine the phases of the System Development Life Cycle.
- examine the terms Artificial Intelligence and Machine Learning.
CISC 320 Operating Systems
- Units:1
- Hours:9 hours LEC; 27 hours LAB
- Prerequisite:None.
- Advisory:CISC 300 or 310 with a grade of "C" or better
- Transferable:CSU
- Catalog Date:August 1, 2024
This course introduces the microcomputer operating system. Topics include basic features, file and program management, disk management commands, and menus.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- explain the purpose of operating systems and become familiar with Windows OS terms and navigation.
- apply custom Windows OS settings and notifications.
- create folders (directories), subfolders (sub-directories), libraries by using the Windows file management utility and demonstrate how to share files and folders with others.
- create, rename, compress, move, copy and delete files on an internal or external storage device using the Windows file management utility and the Windows command prompt.
- practice with Windows applications, utilities and the Task Manager.
- utilize the Internet safely and efficiently.
- create and manage user accounts and settings.
- manage peripheral devices, network connections, and power options.
- explain how to protect the computer and data on the computer.
CISC 323 Linux Operating System
- Units:1
- Hours:9 hours LEC; 27 hours LAB
- Prerequisite:None.
- Advisory:CISC 300 with a grade of "C" or better; ability to touch type.
- Transferable:CSU
- Catalog Date:August 1, 2024
This course introduces the Linux operating system for microcomputers. Concepts include the kernel, file structures, daemons, Graphical User Interfaces (GUI), open source, file security, and permissions. Procedures for installing software, basic system administration and utilities, the Bourne Again Shell (BASH), command line interface utilities, and introduction to scripting topics are also covered.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- analyze the relationship among the operating system kernel, shell interface, windowing system, applications programs, and the user.
- utilize a Command Line Interface (CLI) and Graphic User Interface (GUI) text editor to create and edit files in the Linux file system.
- employ the use of basic Linux GUI applets and CLI commands in file, disk, video, and printer management.
- formulate CLI commands with correct syntax.
- compare Linux with other operating systems.
- utilize the Linux file system and apply industry standard file security.
- explain and define open-source theory, jargon, practice, and licensing.
- utilize a GUI and/or CLI to complete basic system administration and day-to-day tasks on the computer as used in business, professional, and personal environments.
CISC 324 Intermediate Linux Operating System
- Units:1
- Hours:9 hours LEC; 27 hours LAB
- Prerequisite:CISC 323 with a grade of "C" or better
- Transferable:CSU
- Catalog Date:August 1, 2024
This course is a continuation of CISC 323. Topics include boot loaders, Linux devices, and Command Line Interface (CLI) system management utilities. It covers advanced Bourne Again Shell (BASH) shell scripting, including looping and decision making logic structures. Alternates to the BASH shell and regular expressions and text stream editors are introduced.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- set up a Linux and Microsoft Windows dual booting system with a business, professional, or personal setting.
- set up, configure, and troubleshoot a boot loader.
- utilize advanced Bourne Again Shell (BASH), Command Line Interface (CLI) utilities to inspect and maintain the system and its hardware.
- compare C shell, K shell, and BASH.
- implement decision making logic in scripts.
- create BASH script files utilizing looping structures: do, while, until.
- create BASH script files implementing decision making logic using: if, for, case and nesting.
- describe the use of text stream editor and filters such as awk and sed.
- compose a regular expression for use by the grep utility.
CISC 351 Introduction to Local Area Networks
- Units:1
- Hours:9 hours LEC; 27 hours LAB
- Prerequisite:None.
- Advisory:CISC 320 and 355 with grades of "C" or better
- Transferable:CSU
- Catalog Date:August 1, 2024
This course introduces local area networks (LANs) and provides hands-on training in LAN applications and administration. Topics include planning, installing, and maintaining a LAN, responsibilities of the system administrator, and human implications.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- describe the requirements for a LAN and the devices that may reside on a LAN as used in business or professional environments.
- discuss the advantages of a LAN and the factors to be considered when planning and implementing a network.
- distinguish among topologies, types of cabling, standards, and access methods.
- describe the major functions required for day-to-day system administration (e.g., creating a directory substructure, network users and groups, login scripts, trustee rights, custom menus, and print queues).
- examine the advantages and disadvantages of peer-to-peer LANs versus domain-based LANs.
CISC 355 Introduction to Data Communications
- Units:1.5
- Hours:27 hours LEC
- Prerequisite:None.
- Advisory:CISC 300 or 320 with a grade of "C" or better
- Transferable:CSU
- Catalog Date:August 1, 2024
This course introduces business data communications. It covers media, telecommunications, protocols, interfaces, and packet switching. The Internet will be used for locating, viewing, printing, and downloading information.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- describe the difference between data communications and telecommunications and the role of regulatory and standard-setting agencies within the communication industry.
- identify the basic hardware, media, and software components used within a data communications system.
- explain how basic system components are structured in local, metro, and wide area data communication systems.
- describe the importance of software in a data communication system and compare the common protocols used in local area, wide area, and wireless networks.
- describe the purpose of local area networks and compare them to wide area and metropolitan area networks.
- apply the principles of OSI (Open Systems Interconnect) and IEEE (Institute of Electrical and Electronics Engineers) 802 layered communications models to the design and troubleshooting of local and wide area networks.
- explain the basic components and techniques used to create virus secure data communications systems.
- evaluate the performance of a data communications system within an application environment.
CISC 360 Information & Communication Technology Essentials (A+)
- Units:4
- Hours:54 hours LEC; 54 hours LAB
- Prerequisite:None.
- Advisory:CISC 310, 320, and 351 with grades of "C" or better
- Transferable:CSU
- Catalog Date:August 1, 2024
This course provides an introduction to the computer hardware and software skills needed to help meet the growing demand for entry-level ICT professionals. The
fundamentals of computer hardware and software, as well as advanced concepts such as security, networking, and the responsibilities of an ICT professional, will be introduced. This course will help students prepare for the CompTIA A+ certification exam.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- identify the hardware and software components of a modern computer system.
- assemble hardware and software components based on customer requirements (SLO #01).
- operate personal and mobile computer hardware, and software for end users using the most common operating systems (SLO #02).
- discuss and relate the phases of the System Development Life Cycle.
- define, prepare, and install appropriate applications and operating system software based upon customer requirements within real or virtual environments.
- use the general commands and features of office productivity, operating system, and email software.
- demonstrate effective data organization and management techniques using appropriate digital media.
- demonstrate basic data networking and security/forensics techniques (SLO #03).
- install and configure network adapters for effective operation upon local and wide area networks.
- demonstrate basic virtualization, desktop, imaging, and deployment operations (SLO #04).
- diagnose, record, and resolve common hardware and software issues or customer concerns while applying timely and effective troubleshooting techniques (SLO #05).
- operate search engines, browsers, and related web tools to effectively find and utilize secure World Wide Web information or resources.
- practice appropriate customer support techniques (SLO #06).
- demonstrate knowledge of the changing workplace, the work-site team and environment, and ethical behavior.
CISC 362 Microcomputer and Applications Support
- Units:2
- Hours:27 hours LEC; 27 hours LAB
- Prerequisite:None.
- Advisory:CISA 305, CISA 315, and CISC 320 with grades of "C" or better
- Transferable:CSU
- Catalog Date:August 1, 2024
This course is an in-depth investigation of the technical, business, soft, and self-management skills technicians need to provide effective customer service and support in an information technology (IT) environment. Customer service and problem-solving skills needed for success in a small or large business environment are introduced.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- demonstrate proficiency in customer service skills in the areas of active listening and written and oral communication.
- diagnose, document, and communicate microcomputer problems and solutions using acceptable terminology.
- analyze and troubleshoot hardware and software problems in a variety of multi-user computer lab environments.
- apply business and team building skills for technical professionals.
- identify the causes of stress in computer support and apply stress reduction coping skills.
CISC 495 Independent Studies in Computer Information Science - Core
- Units:1 - 3
- Hours:54 - 162 hours LAB
- Prerequisite:None.
- Transferable:CSU
- Catalog Date:August 1, 2024
This is an independent studies course. The topics are to be arranged between the instructor and the student. UC transfer credit will be awarded only after the course has been evaluated by the enrolling UC campus. The units completed for this course cannot be counted towards the minimum 60 units required for admissions.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- engage in intellectual inquiry in the computer information science area beyond that required in order to pass a course of study.
- design and discuss a proposal of study with supervising instructor qualified in the discipline.
- utilize information resources to gather data and other related information.
- prepare a final report or project incorporating research data and findings.
CISC 499 Experimental Offering in Computer Information Science - Core
- Units:0.5 - 4
- Prerequisite:None.
- Transferable:CSU
- Catalog Date:August 1, 2024
This is the experimental courses description.
Computer Information Science - Data Science (CISD) Courses
CISD 299 Experimental Offering in Computer Information Science - Data Science
- Units:0.5 - 4
- Prerequisite:None.
- Catalog Date:August 1, 2024
This is the experimental courses description.
CISD 357 Introduction to Data Science
- Same As:CISP 357
- Units:4
- Hours:54 hours LEC; 54 hours LAB
- Prerequisite:None.
- Advisory:CISC 310, CISP 301, and CISP 360 with grades of "C" or better
- Transferable:CSU (effective Fall 2024); UC (effective Fall 2024)
- Catalog Date:August 1, 2024
This is an introductory course in programming and problem solving with an emphasis on data science using a programming language commonly used in the field (e.g., Python, R, SAS). Specific topics include programming fundamentals, data science components, process, and application. By learning core techniques of data science (e.g., preparation, cleaning, analyzing, and visualization), students also learn how to think critically about data ethics (e.g., what a data set represents and how it functions in different contexts). Credit may be earned for either CISD 357 or CISP 357, but not both.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- explain data science and the various phases of data processing.
- explain the processing of massive storage for any kind of data.
- build programs in a commonly used programming language for data analytics, data mining, modeling, and visualization.
- apply fundamental programming and data science principles and techniques to concrete issues affecting society.
CISD 358 Data Analysis
- Same As:CISP 358
- Units:4
- Hours:54 hours LEC; 54 hours LAB
- Prerequisite:CISD 357 or CISP 357 with a grade of "C" or better
- Advisory:CISP 350 with a grade of "C" or better
- Transferable:CSU (effective Fall 2024); UC (effective Fall 2024)
- General Education:AA/AS Area II(b) (effective Fall 2024)
- Catalog Date:August 1, 2024
This course covers principles of descriptive statistics, statistical programming (e.g., R, SAS), statistical modeling, hypothesis tests, confidence intervals, analysis of variance, regression, and categorical data analysis. Students will explore and summarize data, apply multiple comparison techniques in analysis of variance (ANOVA), use chi-square statistics to detect associations among categorical variables, and fit multiple logistic regression models. Emphasis is on fitting models, verifying the model assumptions, using alternative analysis strategies when necessary, and applications to data science. Credit may be earned for either CISD 358 or CISP 358, but not both.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- evaluate linear regression models.
- apply logistic regression analysis.
- apply the analysis of variance.
- build computer programs to generate descriptive statistics and explore data with graphs.
- explain statistical inference, analysis of variance, regression, and categorical data analysis.
- apply statistical data science principles and techniques to concrete issues affecting society.
CISD 359 Data Modeling and Machine Learning
- Same As:CISP 359
- Units:4
- Hours:54 hours LEC; 54 hours LAB
- Prerequisite:CISD 357 or CISP 357 with a grade of "C" or better
- Advisory:CISD 358 or CISP 358 with a grade of "C" or better
- Transferable:CSU (effective Fall 2024); UC (effective Fall 2024)
- General Education:AA/AS Area II(b) (effective Fall 2024)
- Catalog Date:August 1, 2024
This course covers techniques for predicting outcomes with supervised machine learning, unearthing patterns in customer behavior, data preparation, analyzing, and visualization, model building, predictive model evaluation, and applications to data science. Credit may be earned for either CISD 359 or CISP 359, but not both.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- predict outcomes with supervised machine learning techniques.
- identify patterns in customer behavior with unsupervised techniques.
- analyze structured and unstructured data.
- apply data analytics techniques for effective data-driven decision-making.
- apply data analytics, modeling, and machine learning techniques to concrete issues affecting society.
CISD 499 Experimental Offering in Computer Information Science - Data Science
- Units:0.5 - 4
- Prerequisite:None.
- Catalog Date:August 1, 2024
This is the experimental courses description.
Computer Information Science - Maker (CISM) Courses
CISM 201 Introduction to App Development
- Units:3
- Hours:45 hours LEC; 27 hours LAB
- Prerequisite:None.
- Catalog Date:August 1, 2024
This course introduces the fundamental concepts of app development and programming. Topics include design thinking, data types, control structures, functions, arrays, and the mechanics of running, testing, and debugging. This course was formerly known as CISM 201: Introduction to App Development with Swift and MAKR 201.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- explain the purpose of computer programming languages.
- explain and use programming language elements including syntax, data types, conditional statements, control structures, procedures, arrays, classes, and objects.
- create programs based on specifications.
- use Integrated Development Environment (IDE) for the editing, building, debugging, and testing of programs.
- apply proper documentation and formatting of source code.
- integrate design thinking principles into app design.
Computer Information Science - Networking (CISN) Courses
CISN 299 Experimental Offering in Computer Information Science - Networking
- Units:0.5 - 4
- Prerequisite:None.
- Catalog Date:August 1, 2024
This is the experimental courses description.
CISN 300 Network Systems Administration
- Units:3
- Hours:45 hours LEC; 27 hours LAB
- Prerequisite:None.
- Advisory:CISC 320 with a grade of "C" or better
- Transferable:CSU
- General Education:AA/AS Area II(b)
- Catalog Date:August 1, 2024
This course covers the administration of a server in a client/server network. Topics include designing a basic network, installing, and configuring a network share, setting up and managing network printers, backing up servers, monitoring and troubleshooting network resources, and establishing policies and procedures for network operations. This course covers materials required for the Microsoft Networking examinations. Recertification is required when the operating system has been updated.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- build a network using a Windows Network Operating System (NOS)as used in business or professional environments.
- utilize the administrative tools of a network using the Windows NOS.
- define and monitor resource sharing including printers using the Windows NOS.
- create and manage user and group accounts using the Windows NOS.
- audit network security by monitoring file usage and user activity using the Windows NOS.
- explain a system backup and how to restore files as needed using the Windows NOS.
- diagnose and troubleshoot network resources using the Windows NOS.
- create a client/server environment using a Windows NOS.
- evaluate policies and procedures used for network operations.
CISN 302 Intermediate Network Systems Administration
- Units:3
- Hours:45 hours LEC; 27 hours LAB
- Prerequisite:CISN 300 with a grade of "C" or better
- Transferable:CSU
- General Education:AA/AS Area II(b)
- Catalog Date:August 1, 2024
This course continues the further study of systems administration in a client/server network. Topics include configuring the server environment, implementing system policies, implementing and managing fault-tolerant disk volumes, managing applications, managing connectivity for different network and client operating systems, managing remote servers, implementing directory replication and file synchronization, and advanced troubleshooting techniques. Recertification is required when the operating system has been updated.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- set up details of a network operating system.
- manage computer system policies.
- select and implement support file systems.
- apply and manage fault-tolerance on network servers.
- evaluate and support network applications and services as used in business or professional environments.
- set up network protocols.
- associate inter-operation with different network and client operating systems.
- analyze and troubleshoot directory replications and file synchronization.
- evaluate and optimize the network server boot process.
- use the network operating system's troubleshooting tools to solve advanced network problems as may be seen in business or professional environments.
CISN 303 Network Administration - Linux Server
- Units:3
- Hours:45 hours LEC; 27 hours LAB
- Prerequisite:None.
- Advisory:CISC 323 with a grade of "C" or better
- Transferable:CSU
- General Education:AA/AS Area II(b)
- Catalog Date:August 1, 2024
This course provides coverage of Linux Network Administration. Topics covered include connecting to a network; utilizing network utilities; planning, accessing, and managing file systems; planning and implementing login and file system security; administering and maintaining the user and printer environment; protecting network data; and installing network applications. This course covers material required for software manufacturer's certification.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- audit and perform basic server functions on a Linux Local Area Network.
- create and manage effective file and security systems for a Linux network.
- measure Linux network memory usage.
- assess and determine the appropriate network services necessary to give full functionality to a Linux Local Area Network.
- distinguish between the graphical system used by Linux and command line.
- analyze the hardware components of your computer system.
- apply the correct file permissions for groups and users.
CISN 304 Networking Technologies
- Units:3
- Hours:45 hours LEC; 27 hours LAB
- Prerequisite:None.
- Advisory:CISC 320 and 355 with grades of "C" or better
- Transferable:CSU
- General Education:AA/AS Area II(b)
- Catalog Date:August 1, 2024
This course introduces the architecture, structure, functions, components, and models of the Internet and other computer networks. The principles and structure of IP (Internet Protocol) addressing and the fundamentals of Ethernet concepts, media, and operations are introduced to provide a foundation for further study of computer networks. It uses the OSI (Open Systems Interconnection) and TCP (Transmission Control Protocol) layered models to examine the nature and roles of protocols and services at the application, network, data link, and physical layers. This course prepares students for the CompTIA Network+ certification exam.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- describe and differentiate the devices and services used to support communications in data networks and the Internet for optimizing communication, collaboration, and data security in the modern workplace..
- describe the role of protocol layers in data networks.
- evaluate the importance of addressing and naming schemes at various layers of data networks in IPv4 and IPv6 environments.
- design, calculate, and apply subnet masks and addresses to fulfill given requirements in IPv4 and IPv6 networks.
- explain fundamental Ethernet concepts such as media, services, and operations.
- build a simple Ethernet network using routers and switches.
- manipulate common network utilities to verify small network operations and analyze data traffic.
CISN 306 Advanced Network Systems Administration
- Units:3
- Hours:45 hours LEC; 27 hours LAB
- Prerequisite:CISN 300 with a grade of "C" or better
- Transferable:CSU
- General Education:AA/AS Area II(b)
- Catalog Date:August 1, 2024
This course covers the administration of a server in an enterprise network. Topics include designing an enterprise network, optimizing network servers for enterprise-related roles, managing enterprise users, groups and resources, planning and implementing connectivity to other networks within the enterprise, server and network optimization, and troubleshooting techniques at the enterprise level. This course covers material required for the Microsoft Networking examinations. Recertification is required when the operating system has been updated.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- define the placement and roles of servers in an enterprise network in business or professional settings.
- locate and plan user access to enterprise network resources.
- plan and implement user profiles across networks.
- plan and implement permissions in the enterprise.
- plan and implement trust relationships between servers.
- audit and support network applications and services across multiple networks.
- employ tools to monitor and optimize network services and enterprise network traffic.
- assess and troubleshoot inter-connected networks and network servers.
CISN 307 Windows Active Directory Services
- Units:3
- Hours:45 hours LEC; 27 hours LAB
- Prerequisite:CISN 300 with a grade of "C" or better
- Transferable:CSU
- Catalog Date:August 1, 2024
This course covers installing, configuring, and administering Microsoft Windows Active Directory services. It also focuses on implementing Group Policy and understanding the Group Policy tasks required to manage users and computers. Group Policies are used to configure and manage the user desktop environment, configure and manage software, and implement and manage security settings. Installation and configuration of Domain Naming System (DNS) and Windows Internet Naming System (WINS) is covered, as well as publishing, replication, and the backup of the directory services data base. This course covers material required for the Microsoft Networking examinations. Recertification is required when the operating system has been updated.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- design and evaluate network architecture, topology, interdependencies, and constraints in relation to an Active Directory domain for optimizing communication, collaboration, and data security in the modern workplace.
- evaluate and implement a plan to install, configure, and administer an Active Directory domain controller.
- analyze and implement a plan to install, configure, administer, and evaluate group policy in an Active Directory environment.
- evaluate and manage Active Directory forests, trees, domains, and operational units.
- analyze and implement a plan to install, configure, and administer Domain Naming System (DNS) services and settings.
- develop and implement a plan to publish, backup, and replicate the Active Directory database.
CISN 308 Internetworking with TCP/IP
- Units:3
- Hours:45 hours LEC; 27 hours LAB
- Prerequisite:CISN 300 with a grade of "C" or better
- Transferable:CSU
- General Education:AA/AS Area II(b)
- Catalog Date:August 1, 2024
This course covers the further implementation of the Transmission Control Protocol/Internet protocol (TCP/IP) suite in an enterprise network. Topics include installing, configuring, and testing TCP/IP, planning and implementing sub-networks, managing IP address assignments and IP routing, installing, and configuring DNS, TCP/IP network printing, troubleshooting the network with TCP/IP utilities, and planning for IPv6. This course covers material required for the Microsoft Networking examinations.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- apply and configure Transmission Control Protocol/Internet Protocol (TCP/IP).
- test the TCP/IP configuration using TCP/IP utilities.
- develop and implement TCP/IP sub-networks.
- manage IP address assignments using DHCP and WINS.
- install and configure the Domain Name System (DNS) in the enterprise network.
- assess and troubleshoot the network with TCP/IP utilities.
- plan and evaluate the future implementation of IPv6.
CISN 315 Advanced Network Administration - Linux Server
- Units:3
- Hours:45 hours LEC; 27 hours LAB
- Prerequisite:CISN 303 with a grade of "C" or better
- Transferable:CSU
- General Education:AA/AS Area II(b)
- Catalog Date:August 1, 2024
This course covers topics necessary for an experienced network administrator to monitor, maintain, and improve the performance of an existing Local Area Network (LAN). This course covers part of the material required for software manufacturer's certification.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- demonstrate how to partition hard drives and install a Linux operating system so that it coexists with other operating systems.
- access network storage using Server Message Blocks (SMB).
- evaluate and secure files with Access Control Lists (ACLs).
- enable, audit, and manage network security and monitoring.
- create and manage network defined users and groups.
- install and configure Network File System (NFS) for sharing directories and files between Linux client workstations.
- manage network communication using firewalls.
- analyze, and troubleshoot the Linux boot process.
CISN 316 Virtualization Concepts and Technologies
- Units:3.5
- Hours:54 hours LEC; 27 hours LAB
- Prerequisite:CISN 300 or 340 with a grade of "C" or better
- Transferable:CSU
- Catalog Date:August 1, 2024
This course covers the knowledge and skills necessary to understand and implement Virtualization environments. The core concepts of creating and managing virtual machines, network servers, and network design are presented. The benefits associated with virtualization such as fault tolerance and high availability will also be covered.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- assess and classify for appropriateness of use server virtualization products and desktop virtualization products.
- recognize server functionality needs and determine whether proposed virtual environment can meet the functional objective.
- migrate physical to virtual servers.
- prepare and implement resources designed to be shared by multiple virtual machines.
CISN 320 Designing Windows Directory Services
- Units:3
- Hours:45 hours LEC; 27 hours LAB
- Prerequisite:CISN 307 with a grade of "C" or better
- Transferable:CSU
- General Education:AA/AS Area II(b)
- Catalog Date:August 1, 2024
This course provides students with further knowledge and skills necessary to design a Microsoft Windows directory services infrastructure in an enterprise network. At the end of the course, students will be able to describe guidelines for gathering business and administrative information from an organization and explain how to use the information to design an Active Directory structure for an enterprise; design an Active Directory naming strategy; develop a plan to secure and delegate administrative authority over Active Directory objects based on the administrative model of an organization; identify business needs and scenarios that may require modifications of the Active Directory schema; create an Active Directory design based on administrative Group Policy requirements defined by business needs; design a site topology for a multi-domain organization; and design an Active Directory replication plan based on the site topology design.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- research data to identify customer requirements to design the network infrastructure for modern workplace.
- evaluate Active Directory and network requirements.
- define scope of work for a network infrastructure project.
- review network architecture, topology, interdependencies, and constraints.
- demonstrate Active Directory design creation.
- audit Active Directory design reviews.
- design an Active Directory replication plan based on the site topology design.
CISN 327 Cloud Infrastructure and Services
- Units:3.5
- Hours:54 hours LEC; 27 hours LAB
- Prerequisite:CISN 300 or 340 with a grade of "C" or better
- Transferable:CSU
- Catalog Date:August 1, 2024
This course covers cloud deployment and service models, cloud infrastructure, and the key considerations in migrating to cloud computing. This course also provides the required technology essentials across all domains; including server, storage, networking, applications, and databases to help develop a strong understanding of virtualization and cloud computing technologies.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- identify the Classic Data Center (CDC).
- describe the Virtualized Data Center (VDC) including techniques, resources, and storage virtualization.
- explain VDC Networking components, technologies and how desktop and applications are virtualized.
- describe “Business Continuity” including fault tolerance and data integrity issues.
- discuss the different models of cloud computing including the infrastructure and service creation for the modern workplace.
- describe the security issues in the cloud infrastructure and cloud migration issues.
CISN 328 Cloud Solution Architect
- Units:3
- Hours:45 hours LEC; 27 hours LAB
- Prerequisite:CISN 327 with a grade of "C" or better
- Transferable:CSU
- Catalog Date:August 1, 2024
This course covers the fundamentals of building IT infrastructure on cloud platforms. Focus is on optimizing the use of the Cloud by understanding services and their interface with cloud-based solutions. Emphasis will be on best practices for Cloud Computing, and will recommend various design patterns for creating optimal IT solutions. This course also provides opportunities to build a variety of infrastructures via a guided, hands-on approach.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- describe the benefits of cloud computing.
- design systems that are secure, reliable, high performing, and cost efficient.
- create, manage, provision, and update related resources in cloud computing.
- select compute, storage, database, and networking resources to improve performance and enable organizations to efficiently manage and scale their IT resources while reducing infrastructure costs and enhancing accessibility and security.
- evaluate the most important performance metrics for your applications.
- troubleshoot common errors.
CISN 329 Cloud SysOps and Operations Administration
- Units:3
- Hours:45 hours LEC; 27 hours LAB
- Prerequisite:CISN 328 with a grade of "C" or better
- Transferable:CSU
- Catalog Date:August 1, 2024
This course covers troubleshooting, solving problems, and applying best practices in Cloud and design patterns. The focus will be on creating automatable and repeatable deployments of networks and systems, as well as specific features and tools related to configuration and deployment. Emphasis will be on how some businesses design their infrastructures and implement various strategies and services. This course also provides opportunities to build a variety of infrastructures through a guided, hands-on approach.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- evaluate and discuss cloud infrastructure as it relates to system operations as used in modern business or professional environments.
- manage, secure, and scale compute instances, databases and configurations.
- build virtual private networks, configure and manage storage options.
- monitor the health of the infrastructure and manage resource usage.
- create and configure automated and repeatable operations.
CISN 336 Wireless Technologies
- Units:3
- Hours:45 hours LEC; 27 hours LAB
- Prerequisite:CISN 341 with a grade of "C" or better
- Transferable:CSU
- General Education:AA/AS Area II(b)
- Catalog Date:August 1, 2024
This course on wireless networking focuses on the design, planning, implementation, operation, and troubleshooting of wireless networks. It covers a comprehensive overview of technologies, security, and design best practices with particular emphasis on hands-on skills in set up and troubleshooting; 802.11a and 802.11b technologies, products, and solutions; site surveys; resilient WLAN design, installation, and configuration; WLAN security and vendor interoperability strategies.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- demonstrate understanding of wireless radio technologies and topologies.
- demonstrate understanding of IEEE 802.11 wireless standards.
- assess locations, configure and install wireless access points, bridges, adapters, and antennas as used in modern workplace.
- design, install, configure, monitor, and maintain wireless technologies using CLI and web-based Device Manager.
- identify wireless security threats and vulnerabilities.
- demonstrate understanding of proper site survey techniques and safety practices.
- configure monitoring technologies such as Syslog, SNMP and logging understand vertical and horizontal wireless implementations and uses.
- troubleshoot wireless installation and configuration.
CISN 340 CISCO Networking Academy (CCNA)tm: Introduction to Networks
- Units:3.5
- Hours:54 hours LEC; 27 hours LAB
- Prerequisite:None.
- Advisory:CISC 300, 310, and 320 with grades of "C" or better
- Transferable:CSU
- General Education:AA/AS Area II(b)
- C-ID:C-ID ITIS 150
- Catalog Date:August 1, 2024
This course is designed to introduce students to data communication and networking fundamentals. The course covers networking addressing, which includes calculations and conversions between binary, decimal, and hexadecimal numbering systems. It also surveys data communication hardware and software components and basic networking concepts. Topics covered include data communication, the OSI Model, IP addressing, routing concepts, LAN media, and network management and analyses. This is the first course in preparation for CISCO CCNA certification examination. SCC is a certified CISCO Networking Academy, and all courses are taught by CISCO Certified Academy Instructors (CCAI).
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- build simple LANs, perform basic configurations for routers and switches, and implement IPv4 and IPv6 addressing schemes.
- configure routers, switches, and end devices to provide access to local and remote network resources and to enable end-to-end connectivity between remote devices.
- utilize the Cisco Internetworking Operating System (IOS).
- configure and troubleshoot connectivity for a small network and access to remote networks.
- develop critical thinking and problem-solving skills for using physical equipment and virtual networks.
- calculate and convert between base 2, base 10, and base 16 networking systems.
CISN 341 CISCO Networking Academy (CCNA)tm:Switching, Routing, and Wireless Essentials
- Units:3.5
- Hours:54 hours LEC; 27 hours LAB
- Prerequisite:CISN 340 with a grade of "C" or better
- Transferable:CSU
- General Education:AA/AS Area II(b)
- Catalog Date:August 1, 2024
This is the second course in preparation for CISCO CCNA certification examination. This course covers networking theory and routing technologies, including OSI Model, beginning router configurations, and routed and routing protocols. It continues and expands the study of binary, decimal, and hexadecimal numbering systems to change variable length subnet addressing. Students will perform basic network configuration and troubleshooting, identify and mitigate LAN security threats, and configure and secure a basic WLAN. SCC is a certified CISCO Networking Academy, and all courses are taught by CISCO Certified Academy Instructors (CCAI). This course was formerly known as CISN 341: CISCO Networking Academy (CCNA)tm: Networking Theory and Routing Technologies.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- demonstrate a knowledge of the underlying technologies utilized in modern networking.
- utilize various protocols across an Internet composed of different topologies.
- share devices and information on a network.
- perform calculations to combine network numbering blocks to develop a functional super networking address system.
CISN 342 CISCO Networking Academy (CCNA)tm: Enterprise Networking, Security, and Automation
- Units:3.5
- Hours:54 hours LEC; 27 hours LAB
- Prerequisite:CISN 341 with a grade of "C" or better
- Transferable:CSU
- Catalog Date:August 1, 2024
This course provides advanced routing and switching technologies. Topics include advanced router configurations, network management, network design, WANs concepts and network security. This is the third course in preparation for CISCO CCNA certification examination. SCC is a certified CISCO Networking Academy, and all courses are taught by CISCO Certified Academy Instructors (CCAI). This course was formerly known as CISCO Networking Academy (CCNA)™: Advanced Routing and Switching.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- configure a wide area network.
- install and maintain a multi-protocol routed network.
- implement network security concepts.
- explain how networking devices implement QOS.
- design, implement, configure and troubleshoot enterprise networks as in modern workplace.
- explain the purpose and characteristics of network virtualization.
CISN 346 Network Design and Projects
- Units:3.5
- Hours:54 hours LEC; 27 hours LAB
- Prerequisite:CISN 341 with a grade of "C" or better
- Transferable:CSU
- General Education:AA/AS Area II(b)
- Catalog Date:August 1, 2024
This course covers various state-of-the-art topics to design CISCO network infrastructures to support network services and solutions. Individual topics may include: introduction to voice design concepts; design principles; network structure and IP addressing design concepts; basic campus switching design and WAN design considerations; routing protocol design considerations; introduction to security design concepts; and network management design concepts.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- identify customer business needs and network requirements, structure, design, and considerations as used in modern business or professional environments.
- assess the existing WAN and LAN, and identify connectivity and performance issues.
- introduce, design, and explain security design and network management design concepts and solutions that suit customer needs.
- plan and verify the implementation of the network design.
CISN 350 CISCO Networking Academy (CCNP)tm: CCNP Enterprise: Core Networking
- Units:3.5
- Hours:54 hours LEC; 27 hours LAB
- Prerequisite:CISN 342 with a grade of "C" or better; or valid CISCO Certified Network Associate (CCNA) certification.
- Transferable:CSU
- Catalog Date:August 1, 2024
This course develops knowledge and skills needed to configure, troubleshoot, and manage enterprise wired and wireless networks. Implementation of security and network design principles in an enterprise network will be covered along with technologies that support software-defined programmable networks. This is the first course in preparation for CISCO CCNP certification examination. SCC is a certified CISCO Networking Academy, and all courses are taught by CISCO Certified Academy Instructors (CCAI).
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- implement advanced technologies to support a secure and scalable enterprise network architecture.
- describe the key requirements for scalable routing protocols.
- evaluate OSPF operations and configuration.
- configure enterprise networks for high availability and optimized performance.
- configure and manage secure site-to-site, remote-access, and wireless networks.
- describe BGP features and operations.
- describe virtualization and network automation.
CISN 351 CISCO Networking Academy (CCNP)tm: CCNP Enterprise: Advanced Routing
- Units:3.5
- Hours:54 hours LEC; 27 hours LAB
- Prerequisite:CISN 342 with a grade of "C" or better; or valid CISCO Certified Network Associate (CCNA) certification.
- Transferable:CSU
- Catalog Date:August 1, 2024
This course focuses on implementation and troubleshooting of advanced routing and redistribution for Open Shortest Path First (OSPF), Enhanced Interior Gateway Routing Protocol (EIGRP), and Border Gateway Protocol (BGP) along with VPN technologies, infrastructure security and management tools used in enterprise networks. This is the second course in a series of two advanced courses in preparation for the CISCO CCNP certification examination. SCC is a certified CISCO Networking Academy, and all courses are taught by CISCO Certified Academy Instructors (CCAI).
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- describe and evaluate how EIGRP and BGP supports large networks.
- configure and manage secure site-to-site and remote-access networks using tunneling technologies.
- optimize network performance using multi-protocol route redistribution and conditional forwarding.
- deploy advanced IPv4 and IPv6 technologies to support a scalable enterprise network architecture.
- configure and evaluate network architecture, protocol layers, static routing, and default routing.
- implement secure mechanisms for network infrastructure and troubleshoot security threats.
CISN 374 Messaging Server Administration
- Units:3
- Hours:45 hours LEC; 27 hours LAB
- Prerequisite:CISN 300 with a grade of "C" or better
- Transferable:CSU
- Catalog Date:August 1, 2024
This course covers the installation and administration of messaging servers. Topics include the installation, configuration, management, and tuning of mail and messaging services on both servers and clients, mail access protocols, security issues, and Internet connectivity.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- construct the configuration of a messaging server.
- develop and implement strategies for installation, administration, and security.
- install and configure messaging server software for clients and message recipients as used in as used in business or professional environments.
- configure address lists and accounts.
- manage users, distribution lists, and public and private information stores.
- monitor server performance.
CISN 378 Database Administration for Microsoft SQL Server
- Units:3
- Hours:45 hours LEC; 27 hours LAB
- Prerequisite:CISN 300 with a grade of "C" or better
- Transferable:CSU
- General Education:AA/AS Area II(b)
- Catalog Date:August 1, 2024
This course provides students with the knowledge and technical skills required to install, configure, administer, and troubleshoot the client/server database management system of Microsoft SQL Server. The students will also learn to manage files and databases; choose and configure a login security method; plan and implement database permissions; secure SQL Server in an enterprise network; perform and automate administrative tasks; create custom administrative tools; monitor and optimize SQL Server performance; and replicate data from one SQL Server to another.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- develop and implement installation of SQL Server.
- describe the upgrade process for an installed SQL Server.
- develop and implement administrative procedures.
- evaluate software installation options that are appropriate for the environment.
- set up Microsoft SQL Server following given specifications.
- verify and troubleshoot the installation of SQL Server.
- develop and implement security procedures.
- analyze system performance to baseline using performance tools.
- set up system backups and restore data.
CISN 499 Experimental Offering in Computer Information Science - Networking
- Units:0.5 - 4
- Prerequisite:None.
- Transferable:CSU
- Catalog Date:August 1, 2024
This is the experimental courses description.
Computer Information Science - Programming (CISP) Courses
CISP 301 Algorithm Design and Implementation
- Units:4
- Hours:54 hours LEC; 54 hours LAB
- Prerequisite:None.
- Corequisite:When CISP 301 is taught in Spanish, students may be required to enroll in one of the following corequisie ESL courses: ESLG 51 or ESLL 51.
- Advisory:CISC 310 with a grade of "C" or better, and Elementary Algebra with a grade of "C" or better.
- Transferable:CSU; UC
- General Education:AA/AS Area II(b)
- Catalog Date:August 1, 2024
This course provides an introduction to the analysis, design, and implementation of software solutions to basic problems using console input and output. Students develop and implement standard algorithms for performing such things as a bubble sort, linear search of an array, and data validation. Other programming topics covered include file input/output and functions. Additional topics include converting numbers between numbering systems, binary addition, and binary subtraction. Some sections of this course may be taught primarily in Spanish. When the course is taught in Spanish, co-enrollment in an ESL course is required per California Education Code § 30.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- analyze basic problems to fully understand the scope and desired outcome.
- create algorithms for solving basic problems demonstrating use of variables, constants, and the proper use of control structures such as sequence, selection, and iteration.
- document algorithms using structure charts, pseudocode, and flowcharts.
- implement, test, and debug a program, based on a documented algorithm, which uses each of the following fundamental programming constructs: arithmetic computation, basic console and file input/output, standard conditional and iterative structures, and functions.
- explain the process of high- to low-level language translation.
- create a test data document that states the testing criteria to thoroughly test a program for completeness and accuracy.
- evaluate the completeness and accuracy of a program in accordance with test data previously created.
- demonstrate the mechanics of parameter passing.
- demonstrate a bubble sort, a linear search of an array, and data validation algorithms.
- convert values between binary, decimal, and hexadecimal number systems in order to understand how data are represented in a computer and interpret ASCII values.
- perform addition of binary numbers and subtraction of binary numbers using two's complement.
CISP 310 Computer Architecture and Organization
- Units:4
- Hours:54 hours LEC; 54 hours LAB
- Prerequisite:CISP 301 and 360 with grades of "C" or better
- Transferable:CSU; UC
- General Education:AA/AS Area II(b)
- C-ID:C-ID COMP 142
- Catalog Date:August 1, 2024
This is an introductory course in assembly language for the Intel family of microprocessors. Students will write and debug programs that use control structures, subprocedures, bit operations, arrays, and interrupts. Upon completion of the course, students will have an increased understanding of the internal operations of computers. This course was formerly known as CISP 310: Assembly Language Programming for Microcomputers.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- describe and explain the architecture of microprocessors.
- design and create programs in microcomputer assembly language.
- manipulate binary, octal, hexadecimal, and ASCII data.
- use interrupts to perform basic input/output operations.
CISP 350 Database Programming
- Units:3
- Hours:54 hours LEC
- Prerequisite:CISP 301 with a grade of "C" or better
- Advisory:CISA 323 with a grade of "C" or better
- Transferable:CSU; UC
- General Education:AA/AS Area II(b)
- Catalog Date:August 1, 2024
This is an introductory course in database programming. Topics include data modeling and database normalization. Structured Query Language (SQL) and stored programs will be used to create database objects, query their contents, and make changes.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- construct basic and complex queries using Structured Query Language (SQL) to retrieve data from a database, incorporating single- and multi-table joins, aggregate functions, and subqueries as appropriate.
- design relational databases that conform to normalization guidelines, and implement using SQL Data Definition Language (DDL) statements.
- modify (insert, update, and delete) database content using SQL Data Manipulation Language (DML) statements.
- develop (analyze, design, implement, and test) stored programs to achieve desired results.
CISP 357 Introduction to Data Science
- Same As:CISD 357
- Units:4
- Hours:54 hours LEC; 54 hours LAB
- Prerequisite:None.
- Advisory:CISC 310, CISP 301, and CISP 360 with grades of "C" or better
- Transferable:CSU; UC
- Catalog Date:August 1, 2024
This is an introductory course in programming and problem solving with an emphasis on data science using a programming language commonly used in the field (e.g., Python, R, SAS). Specific topics include programming fundamentals, data science components, process, and application. By learning core techniques of data science (e.g., preparation, cleaning, analyzing, and visualization), students also learn how to think critically about data ethics (e.g., what a data set represents and how it functions in different contexts). Credit may be earned for either CISD 357 or CISP 357, but not both. This course was formerly known as Introduction to Big Data.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- explain data science and the various phases of data processing.
- explain the processing of massive storage for any kind of data.
- build programs in a commonly used programming language for data analytics, data mining, modeling, and visualization.
- apply fundamental programming and data science principles and techniques to concrete issues affecting society.
CISP 358 Data Analysis
- Same As:CISD 358
- Units:4
- Hours:54 hours LEC; 54 hours LAB
- Prerequisite:CISD 357 or CISP 357 with a grade of "C" or better
- Advisory:CISP 350 with a grade of "C" or better
- Transferable:CSU; UC
- General Education:AA/AS Area II(b)
- Catalog Date:August 1, 2024
This course covers principles of descriptive statistics, statistical programming (e.g., R, SAS), statistical modeling, hypothesis tests, confidence intervals, analysis of variance, regression, and categorical data analysis. Students will explore and summarize data, apply multiple comparison techniques in analysis of variance (ANOVA), use chi-square statistics to detect associations among categorical variables, and fit multiple logistic regression models. Emphasis is on fitting models, verifying the model assumptions, using alternative analysis strategies when necessary, and applications to data science. Credit may be earned for either CISD 358 or CISP 358, but not both.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- evaluate linear regression models.
- apply logistic regression analysis.
- apply the analysis of variance.
- build computer programs to generate descriptive statistics and explore data with graphs.
- explain statistical inference, Analysis of Variance, regression, and categorical data analysis.
- apply statistical data science principles and techniques to concrete issues affecting society.
CISP 359 Data Modeling and Machine Learning
- Same As:CISD 359
- Units:4
- Hours:54 hours LEC; 54 hours LAB
- Prerequisite:CISD 357 or CISP 357 with a grade of "C" or better
- Advisory:CISD 358 or CISP 358 with a grade of "C" or better
- Transferable:CSU; UC
- General Education:AA/AS Area II(b)
- Catalog Date:August 1, 2024
This course covers techniques for predicting outcomes with supervised machine learning, unearthing patterns in customer behavior, data preparation, analyzing, and visualization, model building, predictive model evaluation, and applications to data science. Credit may be earned for either CISD 359 or CISP 359, but not both. This course was formerly known as Big Data Analytics.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- predict outcomes with supervised machine learning techniques.
- identify patterns in customer behavior with unsupervised techniques.
- analyze structured and unstructured data.
- apply data analytics techniques for effective data-driven decision-making.
- apply data analytics, modeling, and machine learning techniques to concrete issues affecting society.
CISP 360 Introduction to Structured Programming
- Units:4
- Hours:54 hours LEC; 54 hours LAB
- Prerequisite:CISP 301 with a grade of "C" or better
- Transferable:CSU; UC
- General Education:AA/AS Area II(b)
- C-ID:C-ID COMP 112
- Catalog Date:August 1, 2024
This course introduces structured programming and objects using techniques that can be applied to common high-level programming languages. Topics include programming concepts, logic, modular design, solving problems affecting society at large, documentation, testing, debugging, and using variables and constants, operators, control structures, functions, standard libraries, pointers, arrays, input/output (including file I/O), classes, and objects.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- analyze problem descriptions and develop efficient algorithms for solving problems.
- design algorithms using the control structures of structured programming.
- express algorithms to solve simple and complex problems using a high-level language.
- develop a modular design for a software implementation to solve a problem.
- design and use classes and objects.
- compare procedural and object-oriented approaches to problem solving.
- apply fundamental computer programming principles and techniques to concrete issues affecting society.
CISP 400 Object Oriented Programming with C++
- Units:4
- Hours:54 hours LEC; 54 hours LAB
- Prerequisite:CISP 360 with a grade of "C" or better
- Advisory:CISC 323 with a grade of "C" or better
- Transferable:CSU; UC
- General Education:AA/AS Area II(b)
- C-ID:C-ID COMP 122
- Catalog Date:August 1, 2024
This course is an introduction to object oriented programming using C++. Topics include differences between C and C++ including declarations, constants, operators, function calling by value and reference, strict type checking; function members and overloading; inheritance and multiple inheritance; derived classes, protected members, and virtual functions.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- compare and contrast structured and object oriented software design methodologies.
- design and implement object oriented software applications using Unified Modeling Language and the C++ language.
- design and implement reusable software components using inheritance, containment, or polymorphism (overload, overrides, templates, virtual or pure virtual classes, and generic classes).
CISP 401 Object Oriented Programming with Java
- Units:4
- Hours:54 hours LEC; 54 hours LAB
- Prerequisite:CISP 360 with a grade of "C" or better
- Transferable:CSU; UC
- General Education:AA/AS Area II(b)
- Catalog Date:August 1, 2024
This course is an introduction to Object Oriented Programming using the Java language. The student will learn how to design and implement object oriented applications. Topics will include: objects, classes, Unified Modeling Language, function overloading, inheritance, static and dynamic class relationships, polymorphism, components, event driven programming, class associations, testing and debugging.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- compare and contrast Structured and Object Oriented software design methodologies.
- design and implement Object Oriented software applications using Unified Modeling Language (UML) and the Java language.
- design and implement reusable software components using Inheritance, Containment, or Polymorphism (Abstract Classes, Interfaces).
- design and implement event driven, Graphical User Interface based software applications.
CISP 430 Data Structures
- Units:4
- Hours:54 hours LEC; 54 hours LAB
- Prerequisite:CISP 400 or 401 with a grade of "C" or better
- Transferable:CSU; UC
- General Education:AA/AS Area II(b)
- C-ID:C-ID COMP 132
- Catalog Date:August 1, 2024
This course is a systematic study of data structures including lists, stacks, queues, priority queues, binary search trees, B-trees, Red-black trees, AVL trees, splay trees, hash tables, graphs and the union/find data structures. It covers analysis of algorithms including
merge sort, quick sort, and heapsort. Graph theory including topological sort, depth-first search, shortest paths, and minimum spanning tree.
If time permits, add any of the following topics: tries, Huffman codes, greedy algorithms, dynamic programming, and basic encryption algorithms.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- estimate the efficiency of various sorting and searching algorithms by applying Big-O Notation.
- implement singly linked lists, doubly linked lists, circular linked lists, stacks, queues, trees, and graphs.
- implement recursive modules.
- implement various sorting and searching algorithms.
- create applications using multiple data structures and perform complexity analysis to justify the choice of implementation.
- evaluate performance and examine tradeoffs among data structures.
CISP 440 Discrete Structures for Computer Science
- Units:3
- Hours:54 hours LEC
- Prerequisite:CISP 400 or 401 with a grade of "C" or better; MATH 372 with a grade of "C" or better
- Transferable:CSU; UC
- General Education:AA/AS Area II(b); CSU Area B4; IGETC Area 2
- C-ID:C-ID COMP 152
- Catalog Date:August 1, 2024
This course introduces the essential discrete structures used in computer science with emphasis on their applications. Topics to be covered include: elementary formal logic and set theory, elementary combinatorics, recursive programming, algorithm analysis, digital logic, combinatorial circuits, and computer arithmetic. Computer programming assignments will be included.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- explain the basic notions of logical proofs, including propositions, conditional propositions, logical equivalence, quantifiers, and mathematical induction.
- describe the fundamentals of sets and relations, including definitions and common uses in computer science of sets, sequences and strings, relations, and functions.
- use basic counting methods including permutations and combinations; apply probability to results.
- define the basic concepts of analysis and complexity of algorithms; implementation and efficiency of recursive algorithms.
- interpolate computer arithmetic including real number representation, binary representation, modular arithmetic, and basic arithmetic algorithms.
- examine the fundamentals of digital logic including Boolean algebra, logic gates, combinational circuits, circuit design methodology, circuit minimization, switches, and transistors.
- identify the essential discrete structures used in computer science programs and applications.
- analyze various methods of tree and graph traversals; examine graph and tree algorithms and their application to solving practical problems.
- understand the concepts of Linear Recurrences, Fibonacci numbers, Dependent (Bayes) probability, Independent (binomial) probability, Pascal's Triangle, the Binomial theorem, Pascal's Identity, and the Master Theorem.
CISP 457 Introduction to Systems Analysis and Design
- Units:3
- Hours:54 hours LEC
- Prerequisite:CISA 323 and CISC 310 with grades of "C" or better; and any one of the following: CISP 360, CISP 400, or CISP 401 with grade of "C" or better.
- Transferable:CSU
- Catalog Date:August 1, 2024
The course presents a systematic methodology for analyzing a business problem or opportunity.
Students will determine what role, if any, computer-based technologies can play in addressing the business need.
Students will also learn how to articulate business requirements for the technology solution and how to specify alternative approaches to acquiring the technology capabilities needed to address the business requirements.
Most importantly students will learn how to specify the requirements for the information systems solution among in-house development, development by third-party providers, or purchase commercial-off-the-shelf packages.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- articulate the types of business needs that can be addressed using information technology-based solutions.
- initiate, specify, and prioritize information systems projects to determine various aspects of feasibility of these projects.
- clearly define problems, opportunities, or mandates that initiate projects.
- use at least one specific methodology for analyzing a business scenario (problem or opportunity), model it using formal technique, and specify requirements for a system which enables productive change in business processes.
- within the context of the methodologies learned, write clear and concise business requirements documents and convert them into technical specifications.
- communicate effectively with various organizational stakeholders to collect information using a variety of techniques and convey proposed solution characteristics to them.
- manage information systems projects using formal project management methods.
- articulate various systems acquisition alternatives, including the use of packaged systems (such as Enterprise Resource Planning [ERP], Customer Relationship Management [CRM], Supply Chain Management [SCM], etc.) and outsourced design and development resources.
- use contemporary Computer-Aided Software Engineering (CASE) tools in process and data modeling.
- compare the acquisition alternatives systematically.
- incorporate principles leading to high levels of security and user experience from the beginning of the systems development process.
- design high-level logical system characteristics (user interface design, design of data and information requirements).
- analyze and articulate ethical, cultural, and legal issues and their feasibility among alternative solutions.
CISP 499 Experimental Offering in Computer Information Science - Programming
- Units:0.5 - 4
- Prerequisite:None.
- Transferable:CSU
- Catalog Date:August 1, 2024
This is the experimental courses description.
Computer Information Science - Security (CISS) Courses
CISS 300 Introduction to Information Systems Security
- Units:1
- Hours:18 hours LEC
- Prerequisite:None.
- Transferable:CSU
- Catalog Date:August 1, 2024
This course is intended for beginner users who want to increase their understanding of information security issues and practices. It is intended for end users who use computers at home or in the office. The course covers need-to-know information about staying secure, including information on relevant topics such as protecting mobile devices and wireless local area networks.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- differentiate among the various aspects of internal Local Area Network (LAN) and Internet security.
- analyze and evaluate fundamental security concepts.
- identify the needs for a secure computer.
- formulate proven security practices at the workplace.
- apply sound personal security principals.
- analyze the use and function of cryptography, authentication, and digital signatures.
CISS 310 Network Security Fundamentals
- Units:3
- Hours:45 hours LEC; 27 hours LAB
- Prerequisite:None.
- Advisory:CISN 300 and 340 with grades of "C" or better
- Transferable:CSU
- Catalog Date:August 1, 2024
This course is an introduction to the fundamental principles and topics of Information Technology security and Risk Management at the organizational level. It also addresses hardware, software, processes, communications, applications, and policies and procedures with respect to cyber-security. In addition, this course prepares students for the CompTIA Security+ certification exam.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- examine different methods of common network attacks.
- analyze the benefits of authentication and complex password techniques.
- examine the tangible and intangible costs of breaches to an organization's security, network resources, and proprietary information.
- investigate logical and physical access control methods.
- configure operating system security and evaluate its effectiveness.
- examine how to protect data using encryption.
- define risk and risk management.
CISS 315 Ethical Hacking
- Units:3
- Hours:45 hours LEC; 27 hours LAB
- Prerequisite:None.
- Advisory:CISC 320 or CISS 300 with a grade of "C" or better
- Transferable:CSU
- Catalog Date:August 1, 2024
This course introduces the network security specialist to the various methodologies for attacking a network. Students will be introduced to the concepts, principles, and techniques, supplemented by hands-on exercises, for attacking and disabling a network within the context of properly securing a network. The course will emphasize network attack methodologies with the emphasis on student use of network attack techniques and tools and appropriate defenses and countermeasures. Students will receive course content information through a variety of methods: lecture and demonstration of hacking tools will be used in addition to a virtual environment. Students will experience a hands-on practical approach to penetration testing measures and ethical hacking.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- describe the tools and methods a “hacker” uses to break into a computer or network.
- practice and use safe techniques on the Internet.
- defend a computer and a LAN against a variety of different types of security attacks using a number of hands-on techniques.
- identify ports, protocols and services.
- construct software configuration settings that will assist in protecting the PC.
- describe what an ethical hacker can and cannot do legally.
- describe Federal and State laws and authorities: a. Computer Security Act b. Sarbanes – Oxley c. Gramm – Leach – Bliley d. Privacy (COPPA) HIPAA / FERPA e. USA Patriot Act f. Americans with Disabilities Act, Section 508 g. other Federal laws and regulations h. other California laws and regulations.
- plan, organize, and perform penetration testing on a simple network.
- evaluate the effectiveness of applications of cybersecurity in preventing crime and abuse.
CISS 316 Cisco Networking Academy(R): CyberOps Associate
- Units:3
- Hours:45 hours LEC; 27 hours LAB
- Prerequisite:None.
- Advisory:CISN 340 and CISS 310 with grades of "C" or better
- Transferable:CSU
- Catalog Date:August 1, 2024
This course covers knowledge and skills needed to successfully handle the tasks, duties, and responsibilities of an associate-level Security Analyst working in a Security Operations Center (SOC). It helps students to prepare for the Cisco Certified CyberOps Associate industry certification. This course was formerly known as CISS 316: Cisco Networking Academy™: CCNA Cybersecurity Operations.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- implement and manage Cisco secure networks.
- implement network perimeter defense.
- analyze threats and vulnerabilities to networks.
CISS 321 Scripting for Cyber Security
- Units:3
- Hours:45 hours LEC; 27 hours LAB
- Prerequisite:CISN 340, CISS 310, or CISS 315 with a grade of "C" or better
- Transferable:CSU
- General Education:AA/AS Area II(b)
- Catalog Date:August 1, 2024
This course is designed to cover tools that are commonly used by Information Security Professionals. Modern Operating Systems and scripting languages will be discussed as well as utilities and technologies that enable them. Topics including securing, hardening systems, incident response, automating tasks, auditing, and vulnerability assessment will be covered.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- assess and write simple scripts.
- describe the basic techniques used to create scripts for automating system administration tasks.
- assess vulnerability scanners.
- analyze exploits.
- identify the different parts of a script.
CISS 327 Cisco Networking Academy(R): Network Security
- Units:3.5
- Hours:54 hours LEC; 27 hours LAB
- Prerequisite:CISN 340 and 341 with grades of "C" or better
- Advisory:CISS 310 with a grade of "C" or better
- Transferable:CSU
- Catalog Date:August 1, 2024
This course provides the theoretical understanding of network security and the hands-on skills to implement and support network security. Topics include Cisco switch and router security, Authentication, Authorization, and Accounting (AAA), Access Control Lists (ACLs), Firewalls, Intrusion Prevention System (IPS), and Virtual Private Networks (VPNs). Additionally, the Cisco Adaptive Security Appliance (ASA) and Adaptive Security Device Manager (ASDM) are covered. Sacramento City College is a certified Cisco Networking Academy®, and all courses are taught by CISCO Certified Academy Instructors (CCAI). This course was formerly known as CISS 327: Cisco Networking Academy™: CCNA Security: Implementing Network Security.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- explain network threats, mitigation techniques, and the basics of securing a network.
- describe security threats facing modern network infrastructures.
- configure and secure Cisco devices.
- explain and configure ACLs to filter traffic, mitigate threats to routers, and networks.
- describe methods for implementing secure communications to ensure integrity, authenticity, and confidentiality.
- explain how VPNs operate.
- describe to to implement secure network design, management, and reporting.
CISS 330 Implementing Internet Security and Firewalls
- Units:3
- Hours:45 hours LEC; 27 hours LAB
- Prerequisite:CISS 310 with a grade of "C" or better
- Transferable:CSU
- Catalog Date:August 1, 2024
This course covers network and Internet security and deployment of industry standard countermeasures, including configuring Virtual Private Network (VPN) connections. Topics include the evaluation, implementation, and management of secure remote-access technologies. Also covered is the configuration of network firewalls, and allowing access to key services while maintaining security.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- describe the elements of computer-based data communication.
- define management's role in the development, maintenance, and enforcement of information security policy, standards, practices, procedures, and guidelines.
- identify limitations of firewalls.
- define personal firewalls.
- identify and implement different firewall strategies.
- define the role encryption plays in a firewall architecture.
- recommend best practices for effective configurations and maintenance of Virtual Private Networks (VPNs).
- describe user, client, and session authentication.
CISS 350 Disaster Recovery
- Units:3
- Hours:54 hours LEC
- Prerequisite:None.
- Advisory:CISS 310 with a grade of "C" or better
- Transferable:CSU
- Catalog Date:August 1, 2024
This course presents methods to identify vulnerabilities and implement appropriate countermeasures to prevent and mitigate failure risks for the business enterprise. Topics include disaster recovery, development of a disaster recovery plan, risk assessment, and development and implementation of disaster recovery policies and procedures.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- develop a disaster recovery plan system.
- assess disaster recovery risks in the enterprise.
- develop disaster recovery policies and procedures.
- analyze and establish disaster recovery roles across departments in an organization.
- illustrate inter-organizational relationships and disaster recovery plans.
- analyze and establish disaster recovery communications policies and procedures.
- discuss disaster recovery policies and procedures.
- assess disaster recovery needs, threats, and solutions.
- develop contingency plans for various size organizations to include: business continuity, disaster recovery, technology recovery, and incident response.
CISS 360 Computer Forensics and Investigation
- Units:3
- Hours:45 hours LEC; 27 hours LAB
- Prerequisite:CISS 310 or 315 with a grade of "C" or better
- Transferable:CSU
- Catalog Date:August 1, 2024
This course is an introduction to the methods used to properly conduct a computer forensics investigation beginning with a discussion of ethics, while mapping to the objectives of the International Association of Computer Investigative Specialists (IACIS) certification. Topics covered include, an overview of computer forensics as a profession; the computer investigation process; understanding operating systems boot processes and disk structures; data acquisition and analysis; technical writing; and a review of familiar computer forensics tools.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- define computer forensic concepts as a profession.
- summarize how to prepare for a computer investigation.
- analyze how data is stored and managed by an operating system.
- assess and compare computer forensic tools used in investigations.
- validate the evidence during the analysis process.
- create and prepare detailed procedures for crime scene incident processing and develop a plan for data acquisition.
- demonstrate forensic investigation data acquisition procedures.
- describe and compare graphic image recovery methods to develop high tech reports.
- differentiate common operating systems' boot procedures and disk structures.
- create and prepare detailed procedures for crime scene incident processing.
- describe the importance of network forensics.
Computer Information Science - Web (CISW) Courses
CISW 299 Experimental Offering in Computer Information Science - Web
- Units:0.5 - 4
- Prerequisite:None.
- Catalog Date:August 1, 2024
This is the experimental courses description.
CISW 306 Introduction to Web Page Creation and Web Accessibility
- Units:2
- Hours:27 hours LEC; 27 hours LAB
- Prerequisite:None.
- Advisory:CISC 305 or 310 with a grade of "C" or better
- Transferable:CSU
- Catalog Date:August 1, 2024
This course introduces foundation concepts of coding HTML, CSS, and using a content management system for the production of Web pages. Web page creation will include formatting, layout, construction, and presentation. The current version of markup language will be introduced, as identified by the World Wide Web Consortium (W3C). This course introduces methods used to design accessible websites for users integrating the use of assistive technology. Students develop code and apply page layout to meet recommended standards in compliance with Web Content Accessibility Guidelines (WCAG), an international standard, including WCAG 2.0, WCAG 2.1, and WCAG 2.2. Web “content” generally refers to the information in a web page or web application, including: natural information such as text, images, and sounds; code or markup that defines structure, presentation, etc. The course will examine the four principles of WCAG: Perceivable, Operable, Understandable and Robust. Current legal requirements for accessible websites, including the Americans with Disabilities Act (ADA) and Section 508, will be emphasized and implemented in project work produced in this course. Students will need to know how to navigate with a computer, locally and online, and will need to know how to create files and folders, and be able to upload and download files.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- code using an ASCII text editor and apply the correct syntax for HTML and CSS code. Formulate current coding structure, content, and presentation for generating accessible websites.
- use open-source tools and resources for Web development.
- manage files on a Web server using software utilities, operating systems, and file transfer protocols such as (S)FTP (Secure File Transfer Protocol).
- use the Content Management System (CMS), WordPress, to build a multi-page website.
- describe the current legal requirements for designing websites for people with disabilities.
- evaluate the accessibility levels of various types of websites utilizing various hardware and software tools.
- interpret accessibility standards and guidelines as outlined in W3C Accessibility Standards, including Web Content Accessibility Guidelines (WCAG) 2.1 and/or all current Web Content Accessibility Guidelines. Apply the four principles of WCAG: Perceivable, Operable, Understandable and Robust.
- research and test specialized browsers used for accessibility across multiple platforms; research and test current open-source tools available for creating accessible sites; introduce specialized software and other tools used for Web accessibility.
CISW 327 Introduction to Web Development coding HTML and CSS
- Units:4
- Hours:54 hours LEC; 54 hours LAB
- Prerequisite:None.
- Corequisite:CISW 306
- Advisory:CISC 310 with a grade of "C" or better; Students should be confident in managing files and folders and working on the Internet.
- Transferable:CSU; UC
- General Education:AA/AS Area II(b)
- Catalog Date:August 1, 2024
This course teaches foundations of coding HTML and CSS. Technical aspects of Web development are included for using text, images, links, objects, forms, tables, and multimedia on Web pages. CSS will be implemented using inline, embedded and external styles, media queries, selectors, web fonts, pseudo-classes, pseudo-elements, and other CSS techniques to apply advanced features for the presentation of Web pages. Open-source developer tools and online resources will be introduced. Websites will be managed locally and on a network using effective file management and file transfer protocols. World Wide Web Consortium (W3C) recommended standards will be emphasized using a structured approach in writing validated, accessible, and adaptive code for multiple devices: mobile phones, tablets and desktops. Students taking this course should have fundamental skills in file management and be familiar with fundamental operating system skills-sets for success in this course. Students should have computer navigation skills, locally and online, know how to create files and folders and understand how to upload or download files to/from the Internet.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- write HTML code using the correct syntax; apply the use of structural and semantic elements for Web pages; apply HTML character codes and symbols.
- write CSS code using the correct syntax to control page layout, visual details and demonstrate proficiency using the Box Model; apply the use of inline, embedded, and external styles.
- use open-source text editor to write code; validate code to meet recommended standards of the World Wide Web Consortium (W3C).
- write code for inline, embedded, and external styles and demonstrate proper use of the priority scheme when applying CSS.
- apply the use of Class, Id, and Descendant Selectors, and follow recommended standards of W3C (World Wide Web Consortium).
- examine techniques for responsive design to accommodate varied devices and screen sizes.
CISW 400 Client-side Web Scripting
- Units:4
- Hours:54 hours LEC; 54 hours LAB
- Prerequisite:CISP 301 and CISW 327 with grades of "C" or better
- Transferable:CSU
- General Education:AA/AS Area II(b)
- Catalog Date:August 1, 2024
This course emphasizes client-side software development skills used to create interactive, database-driven websites, and Web applications with JavaScript. Topics include core language features and common design patterns, event handling, using the Document Object Model (DOM) to dynamically modify Web pages, form validation, sending and receiving data with AJAX and JSON, and facilitating development with commonly-used libraries or frameworks.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- describe the role of client-side programming in the development of interactive, database-driven websites and Web applications, and list common tasks.
- use fundamental structured- and object-oriented programming concepts (control structures, functions, arrays, classes) as implemented in JavaScript to create Web-based projects.
- develop (analyze, design, implement, and test) an interactive Web-based project that uses client-side JavaScript with event handling, potentially aided by commonly-used libraries or frameworks.
- choose and implement common design patterns used to facilitate client-side development (e.g., factory, composite, facade).
- process submitted form data using client-side techniques, including the use of "sticky forms" to identify and permit user-correction of invalid data.
- create applications that use Document Object Model (DOM) methods, AJAX, and JSON to exchange data with a server and dynamically modify Web pages.
CISW 410 Database-Driven Web Applications
- Units:4
- Hours:54 hours LEC; 54 hours LAB
- Prerequisite:CISP 301 and CISW 327 with grades of "C" or better
- Transferable:CSU
- General Education:AA/AS Area II(b)
- Catalog Date:August 1, 2024
This course emphasizes server-side software development skills used to create interactive, database-driven websites and Web applications with a scripting language or framework such as PHP, Laravel, Django, or ASP.NET. Topics include core language features and common design patterns, use of the HTTP and CGI protocols to send and receive data, form validation, cookies and sessions, and database interaction. This course was formerly known as Middleware Web Scripting.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
- describe the role of server-side programming in the development of interactive, database-driven websites and Web applications and list common tasks.
- use server- and client-side scripting languages to dynamically generate Web page content and read, write, update, and delete data from a database.
- develop (analyze, design, implement, and test) interactive websites that allow users to view and manage database content in one-to-many and many-to-many relationships.
- implement common design patterns used to facilitate server-side development, such as the model-view-controller architectural pattern.
- process, sanitize, and validate user-submitted form data using server-side techniques.
- create Web applications that provide user authentication and authorization.
CISW 499 Experimental Offering in Computer Information Science - Web
- Units:0.5 - 4
- Prerequisite:None.
- Catalog Date:August 1, 2024
This is the experimental courses description.
Business and Computer Information Science Labs
Check Out Degree Planner
If you're interested in a transfer degree (AA-T or AS-T), then check out Degree Planner, a tool that helps you complete your degree efficiently by mapping out what courses to take and when to take them.
Business and Industry
This program is part of the Business and Industry meta major.