Course Descriptions
COMP1120 - FOUNDATIONS OF COMPUTING
4 credits
This course introduces the student
to the world of information systems. Students
will gain knowledge of the history of computing, the career opportunities available
in information technology, the concepts of data warehouses & data mining, and
ethical issues in information systems. An orientation to command-line interfaces and
file management techniques will also be covered. In addition, students will be introduced
to the structure and capabilities of the typical IBM mainframe computer and the IBM
i5 (iSeries) midrange computer. Topics covered on these systems include basic operating
system features and executing jobs using IBM’s
z/OS operating system for mainframes and IBM’s i5/OS operating system for the
i5 (iSeries). These computer systems are commonly used in medium to large companies
as complements to network systems. Students will also receive initial exposure to
computer programming and algorithms through the use of problem analysis, pseudo-code
and entry level programming languages.
Prerequisite: None
COMP1125 - SPREADSHEET/DATABASE INTEGRATION
4 credits
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
COMP1130 - PROGRAMMING FUNDAMENTALS
4 credits
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 that will remember things, make decisions, and perform
repetitive tasks. Students will explore the worlds of both procedural and objectoriented
programming. The course involves the use of analytical procedures,
pseudo-code, programming languages designed specially for academic use as well as
those in use in today’s businesses, and an introduction to 3D graphics and gaming.
Prerequisites: COMP1120 Foundations of Computing or Instructor Approval. It is highly recommended that you be able to type at least 20wpm before registering for this class.
COMP1140 - WEB DEVELOPMENT
4 credits
This course focuses on using XHTML to create attractive web presentations.
Students will be trained on creating a presence on the Web. Topics include essential
HTML elements and techniques, effective graphical design using CSS, Search Engine
Optimization (SEO), using FTP to transfer files, tables, and forms. DreamWeaver, a
popular web development tool, is taught as an optional portion with this course and
there is a brief introduction to photo editing software focusing on creating graphics
for the Web.
Prerequisites: 20 WPM and knowledge of computer file management.
COMP1200 - PC HARDWARE AND SOFTWARE ESSENTIALS
4 credits
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
COMP1360 - INTRODUCTION TO DATA COMMUNICATION AND NETWORKING
4 credits
This course serves as a general introduction for students to acquire a foundation
in current data communication and networking technologies. 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 covered. The course is operating system independent and provides an
introduction to several popular network operating systems. The focus of the course
will be hands on, with an emphasis being placed on information pertaining to the
Network+ Certification examination.
Prerequisites: COMP1200 PC HardwareSoftware Essentials [A+]
COMP2130 - ADVANCED SPREADSHEET/DATABASE & PROGRAMMING
4 credits
The focus of this course will be on advanced abilities of Excel and Access. Topics
to be covered in Excel include: advanced filtering, data validation, use of financial
functions and tools, using what-if analysis tools (data tables, scenario manager,
the
solver), connecting to external data sources, and working with macros and Visual
Basic for Applications (VBA). Topics covered in Access include: customizing of
forms and reports, understanding the construction of queries through the use of
SQL, creating action queries to update tables, automating tasks using macros, and
writing VBA code to modify macros.
Prerequisites: COMP1125 Spreadsheet/Database Integration
COMP2145 - WEB PROGRAMMING (PHP and ASP.NET)
4 credits
This course covers the popular server-side languages: ASP.NET, PHP, and Flex.
It includes important language concepts such as data types, control statements,
debugging techniques, Object-Oriented Programming (OOP), and the use of SQL
(Standard Query Language). The ASP.NET uses Microsoft’s Visual Studio. PHP
will give the student experience with LAMP (Linux, Apache, MySQL, and PHP).
Prerequisites: 35 WPM, C or better in COMP1140, C or better in COMP1130 or equivalent programming experience.
COMP2150 - WEB SERVICES (XML)
4 credits
This course focuses on XML and the supporting technologies that are used in
person-to-computer and computer-to-computer communications. Some of the technologies
covered will include using DTDs (Documnet 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:
- How to create an XML document. It's just like HTML only with customized tags
- Using DTD and Schemas to validate the XML data.
- How XML can be formatted, filtered, and transformed using a language called XSLT.
- Several common XML technologies including SVG, RSS, and SOAP.
- How XL will be used to create the Semantic (intelligent) Web.
Prerequisites: C or better in COMP1140 Web Development, C or Better in COMP1130 Programming Fundamentals or equivalent programming experience.
COMP2200 - I5 (ISERIES) OPERATING SYSTEM
4 credits
This course covers the IBM i5 (iSeries) midrange computer and its operating system.
Students will be trained in library and object management, work 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, iSeries Access and iSeries Navigator, and backup and restore
procedures.
Prerequisites: COMP1120 – Foundations of Computing
COMP2205 - RPG IV (ISERIES)
4 credits
This course introduces the RPG programming language which is used primarily
for IBM iSeries mid-range computer systems. Topics include: basic input
and output, report editing, arithmetic operations, comparing, control break
logic, tables, array processing, disk file creation and updating, embedded SQL,
interactive programming, and sub files.
Prerequisites: COMP1130 Programming Fundamentals, COMP2200 i5 (iSeries) Operating System
COMP2210 - COBOL (ZSERIES)
4 credits
This course concentrates on the COBOL programming language, one of the most
popular in use in today’s business world. Students will master structured program
design and develop COBOL programs on an IBM mainframe that will enable
them to solve many of today’s business problems. The course includes interfacing
COBOL applications with SQL databases as well as standard mainframe datasets.
Prerequisites: COMP1130 Programming Fundamentals and COMP1120 Foundations of Computing
COMP2300 - JAVA
4 credits
This course is an introduction into the popular Java language. Students will be
trained on data types, control statements, methods, overloading, and data structures.
Cross-platform debugging techniques will be introduced as well as programming
development concepts. This course will also include OOP (Object-Oriented
Programming) concepts such as inheritance, polymorphism, abstract classes,
interfaces, JDBC, data structures, and internationalization. Many current languages
are based on Java and successful completion of this course will ensure a quick
learning curve with languages such as ActionScript, PHP, C#, C++, JavaScript, and
VB.NET.
Prerequisites: A typing speed of 35wpm or higher. A C or Better in COMP1130 Programming Fundamentals or Equivalent Programming Experience
COMP2310 - VISUAL BASIC.NET
4 credits
VB.NET covers common programming techniques used in writing Visual Basic applications
as well as demonstrating how to use the popular Visual Studio programming enviroment.
Topics include:
- Object Oriented Programming (OOP)
- Control statements
- Database programming
- Writing reports using Crystal Reports
- Producing web-based applications with ASP.NET
Prerequisites: C or Better in COMP1130 Programming Fundamentals or Equivalent Programming Experience.
COMP2460 - LINUX
4 credits
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 textbased
shells through the administration of network services. Major topics include
file management, user management, shell scripting and popular programming
languages, system administration including printing, telnet, ssh, ftp, http, and
Samba services.
Prerequisites: COMP1360 Introduction to Data Communication and Networking
COMP2462 - MICROSOFT NETWORK ADMINISTRATION
4 credits
The main goal of this course is to provide students with a comprehensive
understanding of Microsoft Windows Server and to prepare students to tackle
server administration. The course focuses on the requirements of the Microsoft
Certified Systems Administrator (MCSA) credential and the skills to successfully
implement, manage, and troubleshoot the ongoing needs of Microsoft Windows®
2003 based operating environments. Students have an opportunity to apply their
knowledge through hands-on projects and case study assignments. Students will
learn how to install and administer Active Directory services and how to manage
Active Directory objects. Students will use Microsoft Management Console to
monitor system performance, to administer Internet Information Services, and to
administer user accounts, group accounts, and group policies. They will learn how
to administer print services. They will learn how to install and administer network
protocols and services such as virtual private networking, Routing and Remote
Access Service, DHCP, WINS, and DNS.
Prerequisites: COMP1360 Introduction to Data Communication and Networking
COMP2464 - APPLICATION OF WIRELESS AND MOBILE NETWORKS
4 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, EAP, LEAP, WEP, SSID, and vendor interoperability strategies This course
helps students prepare for CWNA™ (Certified Wireless Network Administrator),
Certification Exam (Exam #PW0-100) ACM Performance Objectives: NTT02 through, NTT06,
NTT09, NTT10 and NTT12
Prerequisites: COMP1360 Introduction to Data Communication and Networking
COMP2466 - ADVANCED NETWORKING
4 credits
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 CCNA™ (Cisco
Certified Network Administrator)
Prerequisites: COMP1360 Introduction to Data Communication and Networking
COMP2475 - INFORMATION WARFARE
4 credits
With the threats of cyber terrorism and corporate espionage increasing, the need
for trained network security professionals continues to grow. This course covers
penetration-testing tools and techniques that ethical hackers and security testers
use to protect computer networks. This course provides a structured knowledge
base for preparing security professionals to discover vulnerabilities and recommend
solutions for tightening network security and protecting data from potential
attackers.
Prerequisites: COMP1360 Intro to Data Comm
COMP2496 - CAPSTONE – SOFTWARE DEVELOPMENT
1 – 4 credit (Capstone)
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
COMP2498 - CAPSTONE - NETWORKING SERVICES
1 – 4 credit (Capstone)
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
