Computer Programming and Database Management (CPDM)
Computer Programming and Database Management (CPDM)
The Computer Programming and Database Management degree program prepares students to design, program, and administer e-business and e-commerce systems on the internet, using state-of-the-art programming languages and database technologies.
All of the CPDM courses are available online using a series of short internet-based videos. This advanced online course delivery system provides students with flexibility in completing their degree requirements. Many students continue their studies for a bachelor’s degree via additional online education.
Computer Programming and Database Management (CPDM)
All degree-seeking students must complete a First Year Experience (FYE) course as part of the first 12 credit hours taken at Cincinnati State.
| Semester 1 | Lec | Lab | Credits | |
|---|---|---|---|---|
| ENG 101 | English Composition 1 | 3 | ||
| IT 110 | HTML with CSS and JavaScript | 4 | ||
| IT 105 | Information Technology Concepts | 3 | ||
| IT 100 | Computer Programming Foundations | 3 | ||
| Semester 2 | ||||
| IT 111 | Database Design and SQL | 4 | ||
| IT 101 | .NET Programming 1 | 3 | ||
| XXX XXX Humanities/Social Science Elective | 3 | |||
| BPA 130 | Business Systems Analysis and Design | 3 | ||
| Semester 3 | ||||
| CPDM 151 | ASP.NET C# 1 | 3 | ||
| CPDM 190 | Cooperative Education Preparation: Computer Programming and Database Management | 1 | ||
| IT 102 | .NET Programming 2 | 4 | ||
| ECO XXX Economics Elective | 3 | |||
| COMM 1XX Communications Elective | 3 | |||
| Semester 4 | ||||
| IT 140 | PHP and MySQL | 4 | ||
| CPDM 291 | Full-Time Cooperative Education 1: Computer Programming and Database Management | 2 | ||
| Semester 5 | ||||
| MAT XXX Mathematics Elective | 3 | |||
| ENG 10X English Composition Elective | 3 | |||
| CPDM 152 | ASP.NET C# 2 | 3 | ||
| IT 220 | Emerging Topics in Computer Software Development | 3 | ||
| Semester 6 | ||||
| CPDM 290 | Computer Programming and Database Management Capstone Design Project | 4 | ||
| CPDM 292 | Full-Time Cooperative Education 2: Computer Programming and Database Management | 2 | ||
| Total Credits: | 0 | 0 | 64 | |
ElectivesÂ
| English Composition Elective | ||
| ENG 102 | English Composition 2: Contemporary Issues | 3 |
| ENG 103 | English Composition 2: Topics in Literature | 3 |
| ENG 104 | English Composition 2: Technical Communication | 3 |
| ENG 105 | English Composition 2: Business Communication | 3 |
| Humanities/Social Science Elective | ||
| COMM 130 | Introduction to Film Studies | 3 |
| Or any ART, CULT, FRN, SPN, LIT, MUS, PHI, REL, THE, CRJ, ECO, GEO, HST, LBR, POL, PSY, SOC | ||
| Communication Elective | ||
| COMM 105 | Interpersonal Communication | 3 |
| COMM 110 | Public Speaking | 3 |
| Mathematics Elective | ||
| MAT 125 | Algebra and Trigonometry | 4 |
| MAT 130 | Intermediate Algebra for Statistics | 4 |
| MAT 131 | Statistics 1 | 3 |
| MAT 150 | Intermediate Algebra | 5 |
| MAT 151 | College Algebra | 4 |
| Economics Elective | ||
| ECO 105 | Principles of Microeconomics | 3 |
| ECO 110 | Principles of Macroeconomics | 3 |
CPDM Courses
CPDM 145 Data Reporting
4 Credits. 3 Lecture Hours. 3 Lab Hours.
A course on using Crystal Reports as the tool to design and deliver reports that include tables, charts, and graphs as part of a Web-based application linked to an SQL server database.
Prerequisites: IT 101, IT 110, IT 111 or CIT 110 (minimum grade C for all)
View Sections
CPDM 151 ASP.NET C# 1
3 Credits. 2 Lecture Hours. 3 Lab Hours.
A course on the ASP.NET framework using C#. Topics include: introduction to C# language and syntax, Web forms, server controls, master pages, AJAX, and data driven applications.
Prerequisites: IT 101, IT 110, IT 111, (minimum grade C for all)
View Sections
CPDM 152 ASP.NET C# 2
3 Credits. 2 Lecture Hours. 3 Lab Hours.
A continuation of CPDM 151. Topics include: advanced ASP.NET server controls, building custom classes, Web services, designing Web applications from abstract requirements, and effectively utilizing online reference materials.
Prerequisites: CPDM 151
View Sections
CPDM 190 Cooperative Education Preparation: Computer Programming and Database Management
1 Credit. 1 Lecture Hour. 0 Lab Hour.
A course that prepares students in the CPDM program for cooperative education. Topics include: using the PlacePro software system, resume development, interview skills, and cooperative education requirements, policies and procedures.
Prerequisites: None
View Sections
CPDM 191 Part-Time Cooperative Education 1: Computer Programming and Database Management
1 Credit. 1 Lecture Hour. 20 Lab Hours.
Students seeking an associate's degree participate in their first part-time field learning experience related to their degree. Students are expected to register for academic courses during the same semester. Students must follow cooperative education policies and procedures to earn credit. Grades issued are Satisfactory or Unsatisfactory.
Prerequisites: None
View Sections
CPDM 192 Part-Time Cooperative Education 2: Computer Programming and Database Management
1 Credit. 1 Lecture Hour. 20 Lab Hours.
Students seeking an associate's degree participate in their second part-time field learning experience related to their degree. Students are expected to register for academic courses during the same semester. Students must follow cooperative education policies and procedures to earn credit. Grades issued are Satisfactory or Unsatisfactory.
Prerequisites: CPDM 191
View Sections
CPDM 193 Part-Time Cooperative Education 3: Computer Programming and Database Management
1 Credit. 1 Lecture Hour. 20 Lab Hours.
Students seeking an associate's degree participate in their third part-time field learning experience related to their degree. Students are expected to register for academic courses during the same semester. Students must follow cooperative education policies and procedures to earn credit. Grades issued are Satisfactory or Unsatisfactory.
Prerequisites: CPDM 192
View Sections
CPDM 194 Part-Time Cooperative Education 4: Computer Programming and Database Management
1 Credit. 1 Lecture Hour. 20 Lab Hours.
Students seeking an associate's degree participate in their fourth part-time field learning experience related to their degree. Students are expected to register for academic courses during the same semester. Students must follow cooperative education policies and procedures to earn credit. Grades issued are Satisfactory or Unsatisfactory.
Prerequisites: CPDM 193
View Sections
CPDM 195 Part-Time Cooperative Education 5: Computer Programming and Database Management
1 Credit. 1 Lecture Hour. 20 Lab Hours.
Students seeking an associate's degree participate in their fifth part-time field learning experience related to their degree. Students are expected to register for academic courses during the same semester. Students must follow cooperative education policies and procedures to earn credit. Grades issued are Satisfactory or Unsatisfactory.
Prerequisites: CPDM 194
View Sections
CPDM 196 Part-Time Cooperative Education 6: Computer Programming and Database Management
1 Credit. 1 Lecture Hour. 20 Lab Hours.
Students seeking an associate's degree participate in their sixth part-time field learning experience related to their degree. Students are expected to register for academic courses during the same semester. Students must follow cooperative education policies and procedures to earn credit. Grades issued are Satisfactory or Unsatisfactory.
Prerequisites: CPDM 195
View Sections
CPDM 198 First Year Special Topics in Computer Programming and Database Management
1-9 Credits. 0 Lecture Hour. 0 Lab Hour.
A course on selected topics related to Computer Programming and Database Management, which gives students opportunities to study information not currently covered in other courses. Grades issued are A, B, C, D, or F.
Prerequisites: Instructor Approval
View Sections
CPDM 199 First Year Independent Project in Computer Programming and Database Management
1-9 Credits. 0 Lecture Hour. 0 Lab Hour.
A project related to Computer Programming and Database Management that is completed by one or more students to meet specific educational goals. Projects must have prior approval and supervision by Computer Programming and Database Management faculty. Grades issued are Satisfactory or Unsatisfactory.
Prerequisites: Instructor Approval
View Sections
CPDM 290 Computer Programming and Database Management Capstone Design Project
4 Credits. 3 Lecture Hours. 3 Lab Hours.
Students combine their programming and database skills to complete a software application project, such as developing apps for various mobile devices, implementing a functioning database-driven website for a product, programming games for the Xbox, or developing code for the CPDM EDDIE Robot Platform.
Prerequisites: CPDM 152
View Sections
CPDM 291 Full-Time Cooperative Education 1: Computer Programming and Database Management
2 Credits. 1 Lecture Hour. 40 Lab Hours.
Students seeking an associate's degree participate in their first full-time field learning experience related to their degree. Students must follow cooperative education policies and procedures to earn credit. Grades issued are Satisfactory or Unsatisfactory.
Prerequisites: None
View Sections
CPDM 292 Full-Time Cooperative Education 2: Computer Programming and Database Management
2 Credits. 1 Lecture Hour. 40 Lab Hours.
Students seeking an associate's degree participate in their second full-time field learning experience related to their degree. Students must follow cooperative education policies and procedures to earn credit. Grades issued are Satisfactory or Unsatisfactory.
Prerequisites: CPDM 291
View Sections
CPDM 293 Full-Time Cooperative Education 3: Computer Programming and Database Management
2 Credits. 1 Lecture Hour. 40 Lab Hours.
Students seeking an associate's degree participate in their third full-time field learning experience related to their degree. Students must follow cooperative education policies and procedures to earn credit. Grades issued are Satisfactory or Unsatisfactory.
Prerequisites: CPDM 292
View Sections
CPDM 294 Internship 1: Computer Programming and Database Management
2 Credits. 1 Lecture Hour. 40 Lab Hours.
Students seeking an associate's degree participate in their first unpaid field learning experience related to their degree. Students must follow applicable policies and procedures to earn credit. Grades issued are Satisfactory or Unsatisfactory.
Prerequisites: CPDM 190
View Sections
CPDM 295 Internship 2: Computer Programming and Database Management
2 Credits. 1 Lecture Hour. 40 Lab Hours.
Students seeking an associate's degree participate in their second unpaid field learning experience related to their degree. Students must follow applicable policies and procedures to earn credit. Grades issued are Satisfactory or Unsatisfactory.
Prerequisites: CPDM 294
View Sections
CPDM 298 Second Year Special Topics in Computer Programming and Database Management
1-9 Credits. 0 Lecture Hour. 0 Lab Hour.
A course on selected topics related to Computer Programming and Database Management, which gives students opportunities to study information not currently covered in other courses. Grades issued are A, B, C, D, or F.
Prerequisites: Instructor Approval
View Sections
CPDM 299 Second Year Independent Project in Computer Programming and Database Management
1-9 Credits. 0 Lecture Hour. 0 Lab Hour.
A project related to Computer Programming and Database Management that is completed by one or more students to meet specific educational goals. Projects must have prior approval and supervision by Computer Programming and Database Management faculty. Grades issued are Satisfactory or Unsatisfactory.
Prerequisites: Instructor Approval
View Sections
IT Courses
IT 100 Computer Programming Foundations
3 Credits. 2 Lecture Hours. 3 Lab Hours.
A course on fundamental concepts related to programming. Topics include: problem solving and developmental tools, design techniques such as flow charting and pseudo coding, and testing techniques used in programming.
Prerequisites: AFL 085, AFM 090 or appropriate placement test scores
View Sections
IT 101 .NET Programming 1
3 Credits. 2 Lecture Hours. 3 Lab Hours.
An introduction to concepts of object-oriented software development using Visual Basic .NET. Topics include: application design methods, stages of software development, interaction with the .NET framework, and modular programming concepts utilizing procedures and functions.
Prerequisites: AFL 085 and AFM 090, or equivalent placement test scores
View Sections
IT 102 .NET Programming 2
4 Credits. 3 Lecture Hours. 3 Lab Hours.
A continuation of IT 101. Topics include: object- oriented design and implementation using the .NET framework, developing class modules, and accessing and writing to external data storage and databases using ADO.NET and SQL.
Prerequisites: IT 101
View Sections
IT 103 .NET Programming 3
4 Credits. 3 Lecture Hours. 3 Lab Hours.
A continuation of IT 102. Topics include creating, debugging, and maintaining Web-based database applications using the .NET framework.
Prerequisites: IT 102, IT 111
View Sections
IT 105 Information Technology Concepts
3 Credits. 2 Lecture Hours. 3 Lab Hours.
A course on information technology fundamentals. Topics include; the internet, software, hardware, I/O and storage, operating systems, communications and networks, database management, security, system development, programming, enterprise computing, and numbering systems. The course is delivered through online instruction only.
Prerequisites: AFL 085 and AFM 090, or appropriate placement test scores
View Sections
IT 110 HTML with CSS and JavaScript
4 Credits. 3 Lecture Hours. 3 Lab Hours.
A course on internet programming using HTML, CSS, and JavaScript. Topics include: HTML commands, cascading style sheets, JavaScript commands, web apps, and dynamic web pages.
Prerequisites: None
View Sections
IT 111 Database Design and SQL
4 Credits. 3 Lecture Hours. 3 Lab Hours.
A course on fundamentals of relational database design and implementation using Microsoft SQL Server. Topics include: SQL Enterprise Manager, fundamentals of database design and normalization, data import and export, Structured Query Language (SQL), indexes and keys, views, and stored procedures.
Prerequisites: AFL 085 and AFM 090, or appropriate placement test scores
View Sections
IT 112 Database Design and SQL 2
4 Credits. 3 Lecture Hours. 3 Lab Hours.
A continuation of IT 111. Topics include: advanced stored procedures using transact SQL, user defined functions, triggers, user defined data types, full text searching, replication, database maintenance plans, and designing various data models from abstract requirements.
Prerequisites: IT 111 (minimum grade C)
View Sections
IT 115 Operating Systems Administration
3 Credits. 2 Lecture Hours. 3 Lab Hours.
A course on the Windows operating system used on PC's. Topics include Windows utilization and management, utilities, managing disks, disaster recovery, troubleshooting, user management, productivity tools, and performance issues.
Prerequisites: AFL 085 or appropriate placement test score
View Sections
IT 140 PHP and MySQL
4 Credits. 3 Lecture Hours. 3 Lab Hours.
A course in PHP web programming with a MySQL database. Topics include: PHP language, syntax, variables, and forms; MySQL database design; connecting to a MySQL database using PHP; inserting, editing, and deleting MySQL data using PHP; and building dynamic web pages using PHP and MySQL.
Prerequisites: None
View Sections
IT 150 Logistics and Distribution Technology
3 Credits. 2 Lecture Hours. 2 Lab Hours.
A course on technologies and software used in supply chain management for freight, air, and maritime logistics operations. Topics include: barcodes, RFID, Wi-Fi tags, logistics and inventory software, high frequency tracking, and passive/active tracking.
Prerequisites: SCM 105
View Sections
IT 161 Java Programming
4 Credits. 3 Lecture Hours. 3 Lab Hours.
An introduction to the Java programming language. Topics include: data types, variables, basic command line input/output, decisions, loops, procedures, string manipulation, arrays, object-oriented development, event programming, and database programming.
Prerequisites: IT 101
View Sections
IT 210 System Design and Implementation
3 Credits. 2 Lecture Hours. 3 Lab Hours.
A course on methodologies and techniques of the system development life cycle. Topics include: system design, project management for IT, system implementation, programming design, and system testing techniques.
Prerequisites: BPA 130
View Sections
IT 215 Scripting
3 Credits. 2 Lecture Hours. 2 Lab Hours.
A course on task automation and configuration management using Microsoft PowerShell programming language. Topics include: modifying existing PowerShell scripts, and creating new scripts to automate common tasks.
Prerequisites: NETB 155
View Sections
IT 220 Emerging Topics in Computer Software Development
3 Credits. 2 Lecture Hours. 3 Lab Hours.
A course on current topics related to Computer Software Development such as data reporting, XML, and other new concerns.
Prerequisites: IT 101, IT 110, IT 111
View Sections
Faculty
Program Chair
Bob Nields
Co-op Coordinator
Andrea Feld