Courses in Computer Careers

Foundations of Computing

COMP 1120     4.00 Credits
Course Outline
This course introduces the student to the world of information system. Students will explore the history of computing, career opportunities in information technology, and computer concepts as they apply in a business environment. Topics to be covered include an introduction to basic web-pate development, command-line interfaces, file management principles, computer numbering systems, and database principles. Students will also receive initial exposure to the IBM mid-range computer platform and computer programming and algorithms through the use of problem analysis, pseudo-code and entry level programming languages. (Prerequisite: None)

Spreadsheet/Database Integration

COMP 1125     4.00 Credits
Course Outline
The focus of this course will be on the core competencies of Excel and Access and their integration with Word, PowerPoint, and each other. Topics to be covered in Excel include: formatting, creating formulas, creating charts and pivot tables, linking files, using templates and hyperlinks, and the use of functions, including logical and lookup functions. Topics covered in Access include: understanding the concepts, design, and construction of a relational database. The student will create table structures, queries, forms, and reports. Students will integrate these applications together to create a final capstone project for the course. (Prerequisite: None)

Programming Fundamentals

COMP 1130     4.00 Credits
Course Outline
Programming Fundamentals is designed to be a person's first exposure to the world of computer programming. This course covers how to design and implement a computer program, writing a program that will make different types of decisions, how to solve problems using computer programs that remember things, make decisions, and perform repetitive tasks. The course uses both Alice and JavaScript to help the student meet these objectives. Alice is a 3-D programming environment from Carnegie Mellon University designed to teach programming concepts. It is an enjoyable and easy-to-user programming environment that assists the student in making 3-D, animated movies. JavaScript, is a popular language used for by web browsers to get input from the user. JavaScript teaches client-side scripting. This course is part of the Web Programming Certificate and the AAS Information Systems programming degree at South Central College. You will need to have a basic understanding of (X)HTML for the second half of this course which uses JavaScript. A minimum typing speed of 20-35 wpm is recommended. (Prerequisites: COMP 1120)

Web for Business

COMP 1140     3.00 Credits
Course Outline
This course approaches developing web pages from a business point of view. It covers HTML5 and CSS3 markup languages used to create web pages. The course is intended for people wanting to learn how to create and publish web pages. No previous experience with HTML or programming is required. (Prerequisites: None)

PC Hardware and Software Essentials

COMP 1200     4.00 Credits
Course Outline
PC Hardware and Software, presents an in-depth exposure to computer hardware and operating systems. Students learn the functionality of hardware and software components as well as suggested best practices in maintenance, and safety issues. Through hands on activities and labs, students learn how to assemble and configure a computer, install operating systems and software, and troubleshoot hardware and software problems. In addition, an introduction to networking is included. This course helps students prepare for CompTIA's A+ certification. (Prerequisites: None)

Introduction to Data Communications and Networking

COMP 1360     4.00 Credits
Course Outline
This course serves as a general introduction for students seeking to acquire a foundation in current network technologies for local area networks (LANs), wide area networks (WANs), and the Internet. The course provides an introduction to the hardware, software, terminology, components, design, and connections of a network. Network concepts such as the OSI model, topologies, and major protocols, as well as the basic functions of system administration and operation are also included. The course is operating system independent and provides an introduction to several popular network operating systems. (Prerequisite: COMP 1200 or instructor approval)

Advanced Spreadsheets/Database & Programming

COMP 2130     4.00 Credits
This course covers advanced topics and VBA within the Microsoft Office suite (primarily database and spreadsheet applications). The students will solve business scenarios using advanced features of Access and Excel and the Visual Basic for Applications (VBA) macro language. In addition, the students will integrate data between these applications. Students will work on individual and team projects. (Prerequisite: COMP 1125)

Web Programming

COMP 2145     4.00 Credits
This course covers the popular server-side language PHP and Drupal, a popular CMS (Content Management System). It includes important language concepts such as data types, control statements, debugging techniques, the use of SQL (Standard Query Language). PHP will give the student experience with LAMP (Linux, apache, MySQL, and PHP). (Prerequisites: COMP 1140 with a grade of C or higher, or a working knowledge of HTML, CSS, and FTP; COMP 1130 with a grade of C or higher, or a working knowledge of at least one programming language. It is strongly recommended that you have a minimum typing speed of at least 35 wpm as well as a working knowledge of Microsoft Access (COMP 1125).

Web Services

COMP 2150     4.00 Credits
This course focuses on XML (eXtendable Markup Language) and the supporting technologies of XML used in person-to-computer and computer-to-computer communications. Some of the technologies covered will include using DTDs (Document Type Definitions), Schema, Namespaces, XPath, DOM, SAX, Data Models, XSLT, SVG, Flex and SOAP as well as web services and the Semantic web. Here's what you'll learn by taking this course: 1. How to create an XML document. It's just like HTML only with customized tag names. 2. Using DTD and Schemas to validate the XML data. 3. How XML can be formatted, filtered, and transformed using a language called XSLT. 4. Several common XML technologies including SVG, SMILE, RSS, and SOAP. 5. How XML will be used to create the Semantic (intelligent) Web. Minimum typing speed of 35 wpm (60 wpm recommended) Find your typing speed at http://typingtest.com. Here's a free, open-source typing programming that's fun to play: TuxType. (Prerequisites: Successful completion of COMP 1130 and COMP 1140, with a C or higher, or a working knowledge of XHTML, CSS, and FTP)

IBM i5 (iSeries) Operating System

COMP 2200     4.00 Credits
This course covers the IBM i5 (iSeries) midrange computer and its operating system. Students will be trained in library and object management concepts, CL commands and CL programming techniques, physical and logical file management, the use of various utilities (PDM, DFU, SDA), using Query and SQL, security concepts, and backup and restore procedures. (Prerequisite: COMP 1120)

RPG IV (iSeries)

COMP 2205     4.00 Credits
This course introduces the RPG IV programming language which is primarily used on IBM iSeries mid-range computer systems. Topics to be covered range from basic input and output operations, report editing, arithmetic operations, control break logic, and table and array processing to physical and logical disk file manipulation, interactive programming, and subfiles.(Prerequisites: COMP 1130 or previous programming experience and COMP 2200 or Instructor Approval)

COBOL

COMP 2210     4.00 Credits
This course introduces the COBOL programming language. Topics include: structured program design, basic input & output operations, arithmetic operations, editing, comparing, sorting, control-break processing, table processing, subprograms, and ISAM & VSAM file updating. (Prerequisites: COMP 1120 and 1130 or Instructor Approval)

SQL/DB2

COMP 2220     4.00 Credits
This course covers Structured Query Language (SQL) and the Database Management System (DB2) commonly used on IBM platforms, such as the IBM Power System. Topics covered include data modeling and design as it pertains to the relational database model and the use of SQL commands to create schemas and tables,manipulate data, and retrieve data. (Prerequisite: COMP2200 or Instructor Approval)

Java

COMP 2300     4.00 Credits
This course covers OOP (Object Oriented Programming) using the Java language. Inheritance, polymorphism, abstract classes, and interfaces are covered. SWING, exceptions, data structures, and I/O streams will also be covered, demonstrating each of the OO concepts. Minimum typing speed of 35 wpm. You can test your typing speed at http://typingtest.com. (Prerequisites: Successful completion of COMP 1130 Programming Fundamentals (with a C grade or higher), or a working knowledge of another programming language.)

Visual Basic.Net

COMP 2310     4.00 Credits
VB.NET covers common programming techniques using in writing Visual Basic applications as well as demonstrating how to use the popular Visual Studio programming environment. Topics include: Object Oriented programming, control statements, database programming, writing reports using Crystal Reports, and producing web-based applications with ASP.NET. The Capstone Project for this course involves creating an application for a real-life business problem. Minimum typing speed of 35 wpm. Find your typing speed at http://typingtest.com. Here's a free, open-source typing programming that's fun to play: TuxType. A working knowledge of the Windows operating system and file management. (Prerequisites: Successful completion of COMP 1130 with a grade of C or higher, or a working knowledge of at least one programming language.)

Information Storage and Management

COMP 2452     4.00 Credits
Course Outline
This course is designed to provide the student with a strong understanding of underlying storage technologies. This course will cover the varied components of modern information storage infrastructure, including virtual environments. Students will learn about the architectures, features, and benefits of Intelligent Storage Systems; storage networking technologies such as FC-SAN, IP-SAN, NAS, Object-based and unified storage; business continuity solutions such as backup, replication, and archive; the increasingly critical area of information security; and the emerging field of cloud computing. It provides comprehensive learning of storage technology, allowing the student to make more informed decisions in an increasingly complex IT environment. (Prerequisite: COMP 1200)

Virtualization Technologies

COMP 2453     4.00 Credits
Course Outline
The Virtualization Technologies course is designed to get students up to speed on one of the most important aspects of today's IT environment. This course covers the fundamental concepts, components, infrastructure, as well as security and privacy considerations for virtualization systems. Through lectures, discussions, demonstrations, and labs, students learn the skills and knowledge necessary to install, configure and manage virtual environments. Students will learn how to effectively plan, implement and manage Cloud Computing in virtual data centers and complete introductory coursework in Virtualization software. Topics will include creating virtualized switches and storage, creating and managing virtual machines, establishing access controls, and performing resource monitoring. With additional effort, students can use this knowledge to pass the VCP Certification Exam. (Prerequisite: COMP 1200)

Cloud Technologies and Services

COMP 2456     4.00 Credits
Course Outline
The Cloud Technologies and Services (CTS) course educates students about cloud deployment and service models, cloud infrastructure, and the key considerations in migrating to cloud computing. The course covers technologies required to build classic (traditional), virtualized, and public / private cloud data center environments. These technologies include storage, networking, desktop and application virtualization. Fundamental models such as Software-as-a-Service (SaaS), Platform-as-a-Service (PaaS), Infrastructure-as-a-Service (IaaS) are explored. Additional areas of focus are backup/recovery, business continuity, security, and management. Students will learn about the key considerations and steps involved in transitioning from the current state of a data center to a cloud computing environment. Upon completing this course, students will have the knowledge to make informed decisions about migrating to cloud infrastructure and choosing the best deployment model for an organization. (Prerequisite: COMP 1200)

Linux Administration

COMP 2460     4.00 Credits
Course Outline
The Linux operating system is extremely popular in the world of servers and the internet and is gaining ground on the desktop. This course takes a student through the Linux operating system from learning how to use the command line and text-based shells through the administration of network services. Major topics include file management, user management, shell scripting and popular programming languages, system administration including print services and telnet, SSH, FTP, HTTP, NFS, and Samba services. (Prerequisites: COMP 1200, 1360)

Microsoft Administration

COMP 2462     4.00 Credits
Course Outline
This course provides students with a comprehensive understanding of Microsoft Windows Server and prepares them to perform server administration. The class is based on the requirements of the Microsoft Certified Professional (MCP) credential and teaches the skills to successfully implement, manage, and troubleshoot Microsoft-Windows-based operating environments. Students apply their knowledge through hands-on projects and case study assignments, and learn how to install and administer Active Directory services and manage Active Directory objects. In addition, they learn how to implement and configure core services such as Networking, Storage, Active Directory Domain Services (ADDS), Group Policy, File and Print services, and Hyper-V. Finally, students learn how to install and administer network protocols and services such as virtual private networking, Routing and Remote Access Service, DHCP, and DNS. (Prerequisites: COMP 1360)

Application of Wireless & Mobile Networks

COMP 2464     4.00 Credits
Application of Wireless and Mobile Networks is an introductory course that will focus 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 the areas of wireless LAN setup & troubleshooting, 802.11 technologies, products and solutions, Site Surveys, resilient WLAN design, installation and configuration, WLAN Security - 802.1x, LEAP, WEP, SSID, and vendor interoperability strategies. This course helps students prepare for CWNA (Certified Wireless Network Administrator) Certification Exam. (Prerequisite: COMP 1360)

Routing & Switching

COMP 2466     4.00 Credits
Course Outline
This course addresses the integration of routing and switching technologies to create efficient enterprise networks. Students will learn to design, build, and configure a network. Students will configure routing protocols and perform LAN, WAN, and VLAN troubleshooting using a structured methodology based on the OSI model. Upon completing this course, the learner will be able to select and implement the appropriate Cisco IOS services required to build a scalable, efficient, and highly available network. This course helps students prepare for the CCNA (Cisco Certified Network Administrator) exam. (Prerequisite: COMP 1360)

Security Basics

COMP 2475     4.00 Credits
Course Outline
An introduction to the various technical and administrative aspects of Information Security (INFOSEC), this course provides the foundation for understanding the key issues associated with protecting information assets, determining the levels of protection and response to security incidents, and designing a consistent, reasonable information security system with appropriate intrusion detection and reporting features. Students will be exposed to a wide spectrum of security activities, methods, methodologies, and procedures. The terminal objectives for this course as defined in NSTISSI Training Standards 4011 are: 1. Understand the threats to and vulnerabilities of information systems. 2. Recognize the need to protect data, information, and the means to process it. 3. Develop a working knowledge of INFOSEC principles and practices. 4. Design, execute, and evaluate INFOSEC security procedures and practices. (Prerequisites: COMP 1360)

Capstone - Software Development

COMP 2496     1 - 4 Credits
Course Outline
This course is used to assess and validate student learning and performance throughout the previous semesters as well as to give students an opportunity to practice their skills in a simulated business environment. It is also an opportunity for students to demonstrate that they have achieved the learning goals established by South Central College's Computer Careers Department. This course integrates learning from the courses in the major with the courses from the rest of the student's academic experience. Students will work in teams under the supervision of faculty members who will act as project managers. (Prerequisite: Instructor Approval)

Capstone - Networking Services

COMP 2498     1 - 4 Credits
Course Outline
This course is an opportunity for students to demonstrate that they have achieved the learning goals established by South Central College's Computer Careers Department. This course integrates learning from the courses in the major with the courses from the rest of the student's academic experience. It requires the application of that learning to a service learning project that meets the community need of providing technology assistance to lower income families. Students will gain real world experience using their troubleshooting skills to fix, upgrade and refurbish donated computers. These computers are then recycled back into the community to no-profit organizations and families in need. Students will have an opportunity for reflection through assignments that promote greater understanding of computer concepts and themselves. Students are strongly encouraged to "pass it on," by sharing their computer skills and knowledge through a mentoring process of community members and volunteers. This course will provide an environment, where students can develop a good balance between their technical and "soft" skills. It will include concepts such as team dynamics, conflict management, thinking "outside the box", working with diverse populations and developing professional attitudes and habits. (Prerequisite: Instructor Approval)

Emerging Technologies

COMP 2500     4.00 Credits
eCatalog Use Only

Capstone Project/Internship

COMP 2605     1 - 8 Credits
This course is used to assess and validate student learning and performance throughout the previous semesters as well as to give students an opportunity to practice their skills in a simulated business environment. Students will work in teams under the supervision of faculty members who will act as project managers. (Prerequisite: Instructor Approval)

Special Issues:

COMP 2610     1 - 3 Credits
This course allows students to pursue special interest areas and to gain exposure to emerging technologies in Information Systems and Networking. (Prerequisite: Instructor Approval)