A computer competency course to familiarize students with computer concepts, software applications and the implications of living in the digital age. Introduces students to computer concepts, including, but not limited to the Microsoft Windows environment, Microsoft Office Applications, hardware terminology, social media and the Internet.
Hands-on approach to planning, design, and developing published web sites using HTML tags in a text editor. The class focuses on basic HTML coding using HTML 5 models. Hyperlinks, images, cascading style sheets, forms, accessibility and design principles will be covered, as well as tools such as FTP clients, accessibility checkers, and validators.
Hands-on approach to software design using object-oriented programming. Planning an application, building a user interface, using variables and constants, calculating, accumulating, counting, making decisions, using functions, and using menus.
Focuses on the advanced database capabilities using a current version of Microsoft Access. Topics include design, construction, and documentation of a database management system, designing reports, forms, advanced form techniques, advanced queries, customizing tables, and creating and using an application system with macros.
Plan and publish a standards-based, accessible web site via a variety of tools, including the Adobe Creative Suite. Complete market and user-needs analysis to best target site content and design. Create a graphical web site mock-up, then use CSS (including a framework and pre-processors), scripts, and multimedia to realize site goals. Emphasizes professional design techniques.
Focuses on advanced spreadsheet capabilities using a current version of Microsoft Excel. Topics include design, construction, and documentation of spreadsheets, use of templates, multiple worksheets, complex formulas, functions and filtering, Pivot Tables, advanced chart features, sorting, database capabilities, finding data, creating subtotals, using lookup tables, finding trends and forecasting, creating and editing macros, validating data, and working with controls.
This course focuses on advanced word processing features using the latest version of Microsoft Word. Topics include using tables, merging form letters and data source files, desktop publishing, large document capabilities including master documents and indexes, and linking and embedding objects between Office applications.
Introduction to the theory and practical foundations of the Windows, Linux/UNIX, and macOS desktop operating systems. Discussion of and practice with OS administration through installation, configuration, networking, security, and virtualization.
Introduction to the Linux command line and software development tools. Covers how to use the command line and build tools, including VIM, GCC/G++, make, gdb, and others. Students will gain experience with the build tools by writing and debugging relatively complex programs in both C and C++.
This course introduces the architecture, structure, functions, components, and models of the Internet and other computer networks. The principles and structure of IP addressing and the fundamentals of Ethernet concepts, media, and operations are introduced to provide a foundation for the curriculum. By the end of the course, students will be able to build simple LANs, perform basic configurations for routers and switches, and implement IP addressing schemes. This course, along with CS-152, cover the topics on the CISCO CCENT exam.
Practices the building and servicing of basic computer networks. Topics include physical media, network design, addressing, routing, switching, and management used in common LANs and the Internet. This course, in conjunction with CS-151, covers the topics of the CompTIA Network+ exam.
Examines foundational computing subjects used in Computer Science and Information Technology. Topics include computer architecture, electronic logic, data representation, networking, algorithms and programming, which are used in successive Computer Science courses. Information about degrees in Computer Science and Information Technology is also covered.
Introduction to fundamental concepts of structured programming, including problem solving, algorithm and program design, data types, loops, control structures, subroutines, and arrays. Learn to write structured programs in a high level programming language.
Introduces fundamental concepts of object oriented programming and dynamic memory management. Covers objects, classes, pointers, dynamic memory allocation, linked lists, and program correctness, verification, and testing.
Explores creating dynamic and interactive websites via the use of a current content management systems (CMS). Includes installation of CMS/database, working with templates, creating efficient site navigation, enhancing sites using components, modules, plugins, and extensions, to include shopping cart utilities.
Introduction to computer systems from a software perspective. Topics include: Basic machine organization, system programming in C and assembly language, introduction to system programming tools (gcc, makefile, gdb), data representation (bits & bytes, characters, integers, floating point numbers), implementation of control flow, procedure calls, and complex data types at the machine level, linking and loading, exceptions and interrupts, process control and signals, system calls, file I/O, timing and improving program performance, basic memory hierarchy, and dynamic memory allocation techniques.
Students will become familiar with advanced C++ and Java syntax for object-oriented programming. Use of the file system, operating system calls, and shell-level programming; low-level debugging of high-level programs. Programming exercises will include applications of data structures and memory management techniques.
Addresses professional and interpersonal skills needed by technicians who support and manage hardware and software information systems. Customer service skills; troubleshooting; helpdesk operation; product needs analysis, evaluation, purchase, and installation; technical documentation and training.
An in-depth course in computer hardware. Covers operational concepts, identification, installation, configuration, and troubleshooting of power supplies, motherboards, microprocessors, memory modules, disk drives, optical drives, and expansion cards. This course, in conjunction with CS-228, covers the topics of the CompTIA A+ certification exam.
An in-depth course in operating system maintenance and troubleshooting. Covers configuration, maintenance, and troubleshooting of desktop and mobile operating systems, the fundamentals of cloud computing, and client network configuration and troubleshooting. This course, in conjunction with CS-227, covers the topics on the CompTIA A+ certification exam.
In-depth exploration of creating dynamic websites using the jQuery function library. Topics include creating AJAX applications, XML and JSON data formats, image effects like sliders and lightboxes, navigation effects, mobile-friendly effects and more.
Use PHP and MySQL to develop dynamic web sites for use on the Internet. Develop web sites ranging from simple online information forms to complex online applications. Introduce programming fundamentals including variables, control structures, functions and objects. Applications developed use MySQL as the backend database and will explore database connectivity, querying, and security.
Covers the fundamentals of the Linux operating system. Topics include: system architecture, installation, command line and file system. This course, along with CS-241L, covers the topics of the Linux LPIC-1 (or CompTIA Linux+) certification exam.
Covers the fundamentals of installing, configuring, troubleshooting, and supporting the macOS operating system. Topics include: installation and setup, user accounts, file systems, data management, applications, network configuration, network services, peripherals, startup and troubleshooting. This course covers the topics of the Apple macOS Support Essentials certification exam.
Covers the fundamentals of installing, configuring, troubleshooting, and supporting the Windows operating system. Topics include: installation, managing disks and file systems, file access security, users, profiles and policies, groups, security, backup, remote access, printing, and troubleshooting. This course covers the topics of the Microsoft Configuring Windows Devices certification exam.
Students will be introduced to discrete structures and techniques for computing. The course, which is the first in the two-term sequence, aims to convey the skills in discrete mathematics that are used in the study and practice of computer science. Topics include: Sets; Graphs and trees; Functions: properties, recursive definitions, solving recurrences; Relations: properties, equivalence, partial order; Proof techniques: inductive proof; Counting techniques and discrete probability.
Continuation of the introduction to discrete structures and techniques for computing started in CS-250. The course, which is the second in the two-term sequence, aims to convey the skills in discrete mathematics that are used in the study and practice of computer science. Topics include: Logic: propositional calculus, first-order predicate calculus; Formal reasoning: natural deduction, resolution; Applications to program correctness and automatic reasoning; Introduction to algebraic structures in computing.
Covers common data structures used for the storage and manipulation of data, as well as data abstraction, sorting algorithms, and algorithm analysis. Data structures include linked lists, stacks, queues, binary trees, btrees, hash tables, and graphs.
Focuses on design of a relational database management systems (RDMS). Topics will include database development using the a) requirement, b) design, c) implementation model, database theory from flat table design to relational systems, entity-relationship models, one-to-one, one-to-many, and many-to-many relationships, referential integrity, normalization of tables, database programming and querying with SQL, and database security. Although other platforms may be demonstrated, the majority of work will be done with MySQL Server.
Covers the fundamentals of installing, configuring, troubleshooting, and supporting the Microsoft Windows Server operating system and network infrastructure. Topics include: installation, Active Directory, data storage, resource access, security, monitoring, and disaster recovery. This course introduces the topics of the Microsoft Installation, Storage, and Compute with Windows Server certification exam.
Cooperative Work Experience. This course provides supervised work experience to supplement the academic classroom environment. Work examples include user support, work with computer applications or programming languages, installation or management PC computer systems, and developing websites. Variable Credit: 1-6 credits. May be repeated for up to 9 credits. Required: Student Petition.
This course provides an introduction to the core security skills needed for monitoring, detecting, investigating, analyzing and responding to security events, thus protecting systems and organizations from cybersecurity risks, threats and vulnerabilities. This course covers the topics of the Cisco Cybersecurity Fundamentals and Cybersecurity Operations certification exams.
Continued coverage of network services and administration using Microsoft Windows Server. Topics include: IPv4 and IPv6 addressing, DNS, DHCP, IPAM, network protection, and remote access. This course covers the topics of the Microsoft Networking with Windows Server certification exam.
An introduction to Apache httpd and Microsoft Internet Information Server. Topics include: installation, administration, security, and troubleshooting, as well as the http, https, and ftp protocols.
The capstone course for the Computer & Network Administration AAS program. Provides the opportunity to combine the discrete information learned from program classes together towards the completion of an enterprise-level computer project. Focus can also be placed on researching, practicing, and obtaining an industry-standard certification credential. Emphasis will be placed on project planning, timeline management, creation of training documentation, and oral presentation of completed works.
The capstone course for the web development AAS programs. Provides the opportunity to function in a production design environment, work cooperatively with students from other focus areas, and research emerging website technologies. Emphasis will be placed on client interaction, project teams, and accountability, as well as the development of a professional portfolio web site or completion of a research project in an emerging web-related technology.