Solano Community College

An introduction to the hardware and software components of basic computer information systems. Also, an examination of information systems and their role in business. A review of historical, social and cultural implications of computer technology in today’s society. Course content will include hands-on familiarization with a computer operating system and common application software. Additionally, the course includes an introduction to computer programming using an object-oriented programming language such as Java, Python, C++ or Visual Basic.Net. Students will learn to develop problem specifications, detailed analyses, design algorithms, and construct structured computer programs.

An introduction to Object Oriented Programming (OOP) using Visual Basic.NET, emphasizing problem-solving techniques using structured design and development. An extensive coverage of the Visual Basic computer language will be conducted using the Microsoft.Net environment. Students will construct forms and define procedures, events, properties, methods and objects to solve a variety of business-oriented problems.

A hardware-oriented programming course dealing with programming a computer at the assembler language level. Emphasis will be on the assembly language of computers.
Prerequisite**: CIS 015, CIS 022 or CIS 035
 

An introduction to the discrete structures used in Computer Science with an emphasis on their applications. Topics covered include: Functions, Relations and Sets; Basic Logic; Proof Techniques; Basics of Counting; Graphs and Trees; and Discrete Probability.
Prerequisite**: CIS 023 and Math 020
 

An introduction to computer programming. The course’s content will include ‘hands-on’ development of structured algorithms and programs through top-down design, modular and object oriented programming, and standardized control structures. Taught using an object oriented computer programming language such as C++, C#, Java, etc.
Prerequisite**: CIS 001
 

A study of the basic concepts associated with the creation and manipulation of data structures and their related processing algorithms. Topics include software engineering principles, the selection, design, and implementation of data structures including arrays, sequential and random access files, strings, stacks, queues, linked lists, and binary trees, and the development of efficient algorithms for sorting, searching, and manipulating these data structures. Taught using an object-oriented computer programming language such as C++, C#, Java, etc.
Prerequisite**: CIS 022
 

Introduces Object Oriented Programming (OOP) using the JIava programming language. Includes hands-on development of Java applets and Java applications using objects, classes, interfaces and Graphical User Interface (GUI) components.
Prerequisite**: CIS 015, CIS 022 or CIS 023
 

An introduction to microcomputers and the more frequently used applications software. The course is designed for the microcomputer user who is not a computer science major. The purpose of this course is to help students to understand the concepts and fundamentals of working with: an operating system with its associated graphical user interface, word processing, spreadsheets, databases and presentation software.

An analysis of the UNIX operating system, its terminology, user utilities, file structure, file security, commands, shells, shell programming, system architecture, and system administration. Emphasis will be placed on the shell environment, shell programming and utilities. The course will include hands-on exercises for the students to complete using the UNIX operating system (Currently taught using LINUX).

Course Advisory: CIS 001; basic keyboarding skills
How to use the Graphical User Interface (GUI) and the command line interface in carrying out system tasks in the MS Windows operating systems. Topics include file management, hard disk management, system tools, batch files, connectivity, and the registry.

Prepares students to use the Internet, a world wide computer network. Emphasis is on introducing features of the Internet, including electronic mail, the World Wide Web, Gopher, FTP (file transfer protocol), Telnet, and Usenet, as well as other Internet services and utilities. Students will explore hands-on the vast resources of the Internet, learn to access information using a variety of methods, and will construct a simple Web page.

Prepares students to develop web sites that interact with databases. Emphasis is on the creation of Web sites with interactive Web pages, data access Web pages, and web pages with interactive components. Students will explore hands-on access to the Internet and an HTML editor to create and maintain Web sites.

Covers the creation of vector-based graphics, animation, and interactivity within the Web environment. Emphasis will be placed on applying design principles to the elements of motion and interactivity. The basic operating principles of Adobe Animate will be applied in order to create Web content with animation, interactive buttons, and sound. Issues of optimal delivery and web accessibility will also be covered. A portfolio-quality professional level capstone project will be developed and presented.

An in-depth look at designing multimedia for the Web. Topics include developing graphic elements such as buttons, background textures and images for a Web site, using Cascading Style Sheets to position graphics, using Adobe Animate CC to create web site interactivity, adding audio and/or video to a Web site, and manipulating Web multimedia file formats.

An introduction to relational database management using microcomputers. Microsoft’s Access database management program is used. Students will learn how to create and maintain relational database structures, organize and manipulate data, ask questions of the data, create custom forms for entering data and custom reports for printing the data. How to publish objects on the Internet’s World Wide Web is presented. The student will learn how to construct a complete application combining previously created tables, queries, forms, and reports. Visual BASIC Applications (VBA) and Structured Query Language (SQL) are introduced. Advanced database design is explored and the student learns how to ‘normalize’ a database structure.

Provides knowledge and skills in advanced database systems that use the SQL language such as IBM’s DB2, Oracle, Sybase and Microsoft’s SQL Server. This course is designed for the end user, the database designer and the database administrator. Microsoft SQL Server 2008 is the database system currently used for this course.

Emphasizes the creation of interactive web sites using a server-sided scripting language such as ASP.Net, CGI, or Perl. Topics include core features of the server-side scripting language, control structures, functions, arrays, form validations, regular expressions, environmental variables, and database-driven web applications.

Web server installation and administration for the internet and intranet. Topics covered include the installation, configuration, management and tuning of web services, security, online transaction processing, and FTP services.

An introduction to the graphics software program, Adobe InDesign. Students will learn to produce and publish publications, employing vector graphics, and typography as well as color and print management. This course will establish an understanding of the basic features in Adobe InDesign for use in both print and digital media.

An introduction to the graphics software program, Adobe Illustrator. Students will learn to create vector shapes, import, export and modify graphics, and use Illustrator tools. This course will establish an understanding of the basic features in Adobe Illustrator for use in digital media.

A general introductory overview of networking. Network design, media, protocols, architectures, operations, and administration will be discussed. Local area networks, wide area networks, and network connectivity (including Internet) are covered. This course is the foundation of all other network classes and helps prepare the student to be successful when taking various certified examinations.

An introduction to features and design concepts utilized in developing powerful presentations using a package software such as Microsoft PowerPoint.

An introduction to Outlook’s features. Students will work with the Contact address book; Inbox and e-mail; Journal; Notes; Tasks; use Calendar to track and schedule appointments, events and meetings; work with forms and templates; use Outlook with other applications.

Planning, designing, installing and configuring wireless LANs. The course offers in-depth coverage of wireless networks with extensive step-by-step coverage of IEEE 802.11b/a/g/pre-n implementation, design, security, and Troubleshooting.

Presents the structure of modern personal computer architecture including the names, purpose, and characteristics of components such as motherboards, CPUs, RAM, disk drive storage, printers and networks. This course also addresses upgrading computer components, optimizing computer performance, preventative maintenance, safety, and computer hardware troubleshooting. Prepares the student for CompTIA A+ Hardware Service Technician Certification.

Presents the purpose and capabilities of computer operating systems, operating system components and utilities. The course emphasizes initial investigation of personal computer operating systems and demonstrates the uses of the operating system and other software for isolating troubles and completing the repair of personal computers. Prepares the student for CompTIA A+ Operating Systems Technologies certification.

Presents the architecture of computer networks, including the names, purpose, and characteristics of network components such as network interface card (NIC), hubs, routers, cabling and connectors; as well as topologies, protocols and standards. This course also addresses network implementation, network support and troubleshooting. Prepares the student for CompTIA Network+ Computer Network Certification. As a team, in a laboratory environment, the class will assemble and implement a complete network, with a server running a Microsoft server network operation system (NOS) and several computers running the Microsoft Windows XP Professional Operating System. All of the required cabling will be assembled in the lab by the students under the supervision of the instructor.

Presents the vulnerability, threats, and risks to data and other computer assets from spyware, Trojan horses, viruses, worms, and other security attacks. This course also addresses the fundamental policies and procedures for maintaining the security of a computer network. Prepares the student for the Computing Technology Industry Association’s (CompTIA) Security+ Certification.