St. Charles Community College Logo

St. Charles Community College
4601 Mid Rivers Mall Drive
Cottleville, MO 63376 | 636-922-8000
Student Information
Community Programs
General Information
Site Index

Computer Course Descriptions


CPT/BAS 103 Microcomputer Applications ... 3
Introduces use of business applications in word processing, spreadsheets, databases, and presentations. Windows application package used for each application. Keyboarding skills recommended. (Students may not receive credit for both BAS 103 and CPT 103.)

CPT 104 Introduction to Programming for Animation and Computer Games ... 3
Prerequisite: Student must have completed any remedial reading courses they have been required to take. Basic computer programming techniques using the "Alice" programming tool, to create virtual worlds containing animation and or simple games. Utilizes traditional problem solving techniques and logic to assist in program development. "Alice" tool uses "Drag and Drop" technology to create their virtual worlds; additional computer language is not required.

CPT/BUS 105 Computer Ethics ... 3
Introductory survey of classical and contemporary ethical theories related to current business and computer situations and problems with an emphasis on case studies and examples. Course fulfills AA general education requirements. (formerly CPB 105)

CPT 106 PC Operating Systems ... 3
Introduction to the concepts of computer operating systems, including DOS, Linux and Windows XP. Covers the three types of interfaces: command line, menu, and graphical. Operating concepts of file, disk, and other resource management.

CPT 107 A+ (Computer Repair and Maintenance) ... 5
Preparation to meet the requirements of the A+ certification exam. How to build, configure, upgrade, and troubleshoot PCs. Combination of lectures, demonstrations, discussions, and hands-on labs.

CPT 115 Introduction to Data Processing ... 3
Introduction to computer systems with topics that include system components, data storage techniques, binary arithmetic, operating systems, device characteristics, and programming. Course fulfills AA general education requirements. Recommended Corequisite: CPT 106.

CPT 121 Basics of Data Communications ... 3
Prerequisite: CPT 115. Understanding and appreciation of data communications from user's perspective. Overview of data communications concepts to address data communications issues in contemporary home or business environment. Online only (formerly CPC 120).

CPT 130 Introduction to the UNIX Operating System ... 3
Prerequisite: CPT 106. Introduction to UNIX operating system. Covers essential components of operating system, concept of shell, and basic editing techniques. Includes file structures, file access, linking files, and script files. Fall

CPT 165 Computer Programming Logic ... 3
Prerequisite: CPT 115. Understanding and appreciation of computer problem solving methods. Applies knowledge of specific characteristics of computer language and coding mechanics to logical solution of given problem. Logic and programming techniques apply to any of machine-oriented or high-level languages currently available.

CPT 172 FORTRAN Programming ... 3
Prerequisite: MAT 121. Continues development of good programming style using FORTRAN language. Emphasis is on development and use of single and multi-dimensional arrays and on development and use of subroutines and functions. Recommended corequisite: CPT 165.

CPT 174 COBOL Programming I ... 3
General orientation to concept of structured COBOL programming and the use of COBOL language features and programming techniques. Taught on IBM-compatible PC. Recommended corequisite: CPT 165. Fall.

CPT 175 COBOL Programming II ... 3
Prerequisite: CPT 174. Continuation of COBOL Programming I. Introduces programs of increased complexity, using advanced features of COBOL language, including sorts, indexed files, and subroutines. Taught on IBM-compatible PC. Spring.

CPT 182 Programming in C ... 3
Prerequisite: CPT 106 or CPT 115. Advanced programming topics using the C language. Emphasis on data structures and file handling. Recommended corequisite: CPT 165. Fall.

CPT 185 Programming in C# (C Sharp) ... 3
Prerequisite: CPT 106 or CPT 115.  Object-oriented approach to programming as well as the C# programming language. Spring

CPT 186 Object Oriented Programming in C++ ... 3
Prerequisite: CPT 182. Working knowledge of object-oriented programming using C++ language. Features extensive hands-on programming development using C++ compiler on IBM-compatible system. Spring.

CPT 198 Computer Science Internship ... 1-3
Requires prior approval of department chair or dean. Students placed in a position in business to gain practical experience and learn specific operational technologies.

CPT 200 Systems Analysis and Design ... 3
Prerequisite: CPT 165. Orientation to the development of computer-based man-machine information systems. Study of system life cycles, development of logical systems specification, data collection techniques, human factors design, and standards for documentation. Spring.

CPT 201 Introduction to Database Management ... 3
Prerequisites: CPT 103, CPT 115. Practical foundation for the design, implementation, and management of database systems. Includes the Internet’s impact on how databases are designed, implemented, and used (formerly CPB 201). Fall.

CPT 204 Advanced Applications ... 3

Prerequisite: CPT 103. Continuation of topics covered in elementary applications course. Emphasis on spreadsheet macros, functions, graphics, and database form development, modeling, and merging features using word processor (formerly CPB 101). Fall.

CPT 220 Data Integration Techniques ... 3
Prerequisites: CPT 204. Creation and use of custom menus, forms, and other features in spreadsheet and database environments, and use of logic structures, control loops and other branching techniques. Emphasis on handling data by defining properties and by creating value trees, event trees, and data links to external data files (formerly CPB 220). Spring.

CPT 230 Advanced UNIX ... 3
Prerequisite: CPT 130. In-depth look at UNIX operating system and how it works. Advanced file access and programming in shell. Covers basic system administration and close look at security administration (formerly CPC 230). Spring.

CPT 240 SQL Basics ... 3

Prerequisite: CPT 103 or CPT 115. Extensive hands-on activities using in-class SQL-based relational database to transform request into SQL query. How to create and test increasingly complex queries, how to build tables using data definition capabilities of SQL, how to create views for querying and manipulating data, and how to index in SQL database (formerly CPB 240). Spring.

CPT 243 Intranets and E-Commerce ... 3
Prerequisite: CPT 115. Definition of E-Commerce, Intranets and Extranets. Exploration of major business opportunities, limitations, issues, and risks of all these technologies as well as how they are conducted and managed (formerly CPC 220). Spring. Online only.

CPT 245 Telephony ... 3
Prerequisite: CPT 115. Coverage of signaling protocols used in telephony and the convergence of the telephone network with data networks (formerly CPC 280). Fall. Online only.

CPT 246 Computer Security ... 3
Prerequisite: CPT 121. Exploration of LAN and WAN network security issues and various resolutions to the problems (formerly CPC 282). Spring. Online only.

CPT 249 Network Architecture and Protocol ... 3
Prerequisite: CPT 121. Terminology, operating systems, network topology, computer network architecture and hardware, and introduction to network protocols. Protocols covered include block-oriented send and wait protocols and streaming protocols. Includes introduction to Internet working protocols (formerly CPC 200). Fall. Online only.

CPT 250 Database Programming ... 3
Prerequisites: CPT 103 or CPT 115. Special topics course about how to program in a commercially popular database language and integrating databases for the Web. Spring

CPT 260 Oracle Programming ... 3
Prerequisites: CPT 103 or CPT 115. In-depth coverage of Oracle’s current Programming Language/ Structured Query Language (PL/SQL) bringing all benefits and capabilities of a high-level programming language to the database environment. Spring

CPT 265 DB2 Programming ... 3
Prerequisites: CPT 165, CPT 201, CPT 240. Production of application programs manipulating DB2 databases in a UNIX, Windows NT, Windows 95, or OS/2 environment. Emphasis on embedding static SQL statements and preparing programs for execution.

CPT 271 Programming in Perl ... 3
Prerequisites: CPT 130, CPT 165, CPT 201. Quick prototyping, systems utilities, software tools, database access, and www programming. Perl modules and extensions greatly reduce development time for any given task. Perl scripting included. Role of Perl in bioinformatics.

CPT 280 Visual BASIC ... 3
Prerequisite: CPT 106 or CPT 115. Using Visual Basic 2005. Principles of effective graphic user interface design, and how to import and adopt code from other versions of BASIC. Building applications by selecting and creating appropriate controls, defining their properties, and coding their events. Fall.

CPT 282 Advanced Visual BASIC ... 3
Prerequisite: CPT 280. Advanced topics will include object-oriented programming with Visual Basic 2005, XML processing, database integration, as well as web forms and services. Spring.

CPT 284 Java Programming ... 3
Prerequisites: CPT 106 or CPT 115. Essentials of Java programming with emphasis on object-oriented features. Explores inter-relationship of Java and the Web. Fall.

CPT 287 Advanced Java Programming ... 3
Prerequisite: CPT 284. Advanced topics in Java programming including servlets, database development, and advanced object-oriented design using Swing and Java Beans. Spring