Computer Software Development Major and Computer Software Development Certificate (CSD & CSDC)

This is an archived copy of the 2020-2021 catalog. To access the most recent version of the catalog, please visit http://catalog.cincinnatistate.edu.

Computer Programming and Database Management - Computer Software Development Major (CSD)

The Computer Programming and Database Management - Computer Software Development Major (CSD) is an online degree focuses on the design, development, implementation, and maintenance of software used in a variety of industries. Students gain knowledge of computer operating systems and software development using several programming languages. 

Graduates earn an Associate of Applied Science degree and are prepared to enter the workforce as skilled computer programmers and systems integrators. Graduates may continue their education in a bachelor's degree program in computer science, information systems, business informatics, or business administration. 

The Computer Software Development Major is primarily offered as an online degree for students who seek that instructional method. Some of the required courses can be taken through in-person classes.

For more information, please contact the Engineering and Information Technologies Division at (513) 569-1743.

To apply for this program at Cincinnati State, visit the Admissions section of the College website.

Computer Software Development Certificate (CSDC)

The Computer Software Development Certificate assists individuals seeking computer skills needed in a variety of industries, focusing on current software development languages, object-oriented programming concepts, and database theory. 

The certificate is intended for experienced programmers looking to update or enhance their skills, or for individuals preparing to enter the information technology field who already have a bachelor's degree in another discipline.

The certificate can be completed in three semesters, and all courses are offered through online education.

For more information, please contact the Engineering and Information Technologies Division at (513) 569-1743.

To apply for this program at Cincinnati State, visit the Admissions section of the College website.

Computer Programming and Database Management - Computer Software Development Major (CSD)

Semester 1LecLabCredits
FYE 100College Survival Skills ( B) 101
ENG 101English Composition 1 ( G) 303
IT 100Computer Programming Foundations ( B) 233
PHI 110Ethics ( G) 303
MAT XXX Mathematics Elective (G)  223
Semester 2  
IT 101Programming 1 ( B) 233
IT 111Database Design and SQL 1 ( B) 233
ENG 10X English Composition Elective (G)  303
CPDM 210System Analysis and Design ( T) 233
Semester 3  
IT 102Programming 2 ( B) 233
CPDM 120Fundamentals of Object-Oriented Programming using Python ( T) 233
XXX XXX Technical Track Elective 1 (T)  233
ECO 1XX Economics Elective (G)  303
Semester 4  
IT 161Java Programming 1 ( T) 233
SET 151C Programming 1 ( T) 233
IT 117Web Application Development 1 ( T) 233
XXX XXX Technical Track Elective 2 (T)  1402
Semester 5  
CPDM 290Computer Programming and Database Management Capstone ( T) 233
SET 252C Programming 2 ( T) 233
IT 262Java Programming 2 ( T) 233
IT 218Web Application Development 2 ( T) 233
Total Credits:  448460

Electives 

Mathematics Elective
MAT 124Applied Algebra and Geometry4
MAT 125Algebra and Trigonometry *4
MAT 131Statistics 13
MAT 151College Algebra4
Economics Elective
ECO 105Principles of Microeconomics3
ECO 110Principles of Macroeconomics3
English Composition Elective
ENG 102English Composition 2: Contemporary Issues3
ENG 103English Composition 2: Writing about Literature3
ENG 104English Composition 2: Technical Communication3
ENG 105English Composition 2: Business Communication3
Technical Track Electives (Choose courses from 1 track)
Database Analytics Track
IT 112Database Design and SQL 23
IT 212Business Intelligence, Data Warehousing, and Reporting3
Experiential Learning Track (Choose courses from 1 experiential learning group)
Cooperative Education Experiential Learning
CPDM 190Cooperative Education Preparation: Computer Programming and Database Management1
CPDM 291Full-Time Cooperative Education 1: Computer Programming and Database Management2
CPDM 292Full-Time Cooperative Education 2: Computer Programming and Database Management2
Project-Based Experiential Learning
CPDM 190Cooperative Education Preparation: Computer Programming and Database Management1
CPDM 296Project-Based Learning 12
CPDM 297Project-Based Learning 22

Some courses are offered in alternative versions identified with a letter after the course number-- for example, ENG 101 and ENG 101A.

  • This curriculum displays only course numbers without the added letter.
  • The alternative version, when available, meets the requirements of the course version without the added letter.

The letters G, B, and T (displayed after course titles or elective descriptions) identify types of courses required by the Ohio Department of Higher Education as part of an associate’s degree curriculum. 

G = General Education course in this curriculum

B = Basic Skills course in this curriculum

T = Technical course in this curriculum

Computer Software Development Certificate (CSDC)

First Year
Semester 1LecLabCredits
IT 101Programming 1 233
IT 111Database Design and SQL 1 233
Semester 2  
IT 102Programming 2 233
CPDM 120Fundamentals of Object-Oriented Programming using Python 233
Semester 3  
XXX XXX Technical Elective 1  233
XXX XXX Technical Elective 2  233
Total Credits:  121818

Electives

Technical Electives (select 2 courses)
IT 161Java Programming 13
SET 151C Programming 13
IT 117Web Application Development 13

Some courses are offered in alternative versions identified with a letter after the course number-- for example, ENG 101 and ENG 101A.

  • This curriculum displays only course numbers without the added letter.
  • The alternative version, when available, meets the requirements of the course version without the added letter.

Computer Programming and Database Management (CINS, CSD, SET)

  • Ability to collect, disseminate, analyze, and apply the requirements for a specific software development project.
  • Ability to write, test, and maintain software applications utilizing current and relevant programming languages.
  • Ability to design and implement a normalized relational database(s) to meet the needs of the software development project.
  • Ability to effectively utilize databases and database management systems to organize, store, and retrieve data for use in application software.
  • Ability to create application software that is intuitive for a wide range of users.
  • Ability to effectively articulate ideas, recommendations, and solutions.
  • Ability to lead and/or participate effectively in teams.
  • Ability to utilize appropriate resources to broaden individual knowledge and to apply the industry’s latest development tools, techniques, and standards. 

CPDM Courses

CPDM 120 Fundamentals of Object-Oriented Programming using Python
3 Credits. 2 Lecture Hours. 3 Lab Hours.

A course on fundamentals of object-oriented programming using the Python programming language. Topics include: understanding Python; applying concepts of object-oriented design and programming by developing classes, methods, and properties using the principles of encapsulation, abstraction, inheritance, and polymorphism.
Prerequisites: IT 101 and IT 111 (minimum grade C for both)

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)

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)

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

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

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

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

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

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

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

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

CPDM 210 System Analysis and Design
3 Credits. 2 Lecture Hours. 3 Lab Hours.

A course on fundamental concepts in system analysis and design, within the framework of the system development life cycle. Topics include: business case analysis, requirement gathering, requirement modeling, enterprise modeling, and development strategies.
Prerequisites: None

CPDM 211 Business Application Development 1: RPGLE/DB2
4 Credits. 3 Lecture Hours. 3 Lab Hours.

A course on the IBM operating system and utilities, including DB2, Control Language, Query, SDA, and SQL. Topics include: RPGLE utilization of forms/specifications, language operation codes and special functions used to generate reports, and transaction-level file maintenance.
Prerequisites: IT 102

CPDM 212 Business Application Development 2: RPGLE/DB2
4 Credits. 3 Lecture Hours. 3 Lab Hours.

A continuation of CPDM 211. Topics include: RPGLE procedural programming including arrays/list processing, interactive applications, and subfiles; interactive and embedded SQL; and ILE programming through service programs to address introductory cross-platform programming.
Prerequisites: CPDM 211

CPDM 230 Mobile Application Development
4 Credits. 3 Lecture Hours. 3 Lab Hours.

A course on designing and programming applications for current mobile devices. Topics include: GUI programming application structure; and considerations related to networks, databases, video, GPS sensors, and multi-touch technology.
Prerequisites: IT 102

CPDM 240 Emerging Technologies: Web and Mobile Applications
4 Credits. 3 Lecture Hours. 3 Lab Hours.

A course on emerging technologies in software and applications development for the web and mobile devices.
Prerequisites: CPDM 230

CPDM 250 Game Design and Society
3 Credits. 2 Lecture Hours. 3 Lab Hours.

A course that examines the interdisciplinary natures of games and the fundamentals of game design. Topics include: history of games and play in society; game genres; game technical and experiential features; characteristics of game players; and creating game concepts, worlds, and characters.
Prerequisites: IT 117

CPDM 255 Web Game Development
3 Credits. 2 Lecture Hours. 3 Lab Hours.

A course on introductory programming for web games and similar interactive media using web programming languages such as JavaScript and HTML. Topics include: game programming frameworks, web programming syntax, web programming libraries for games, using a game loop, using sprites, interactive GUI programming, and creating the game environment.
Prerequisites: CPDM 250

CPDM 290 Computer Programming and Database Management Capstone
3 Credits. 2 Lecture Hours. 3 Lab Hours.

Students work on a team project that demonstrates mastery of skills gained throughout their degree studies. Topics include: developing a project idea, conducting a feasibility study for the idea, gathering and analyzing requirements, and designing and implementing a solution.
Prerequisites: IT 218 or IT 262 or SET 253

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

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

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

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

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

CPDM 296 Project-Based Learning 1
2 Credits. 1 Lecture Hour. 40 Lab Hours.

Students seeking an associate's degree participate in their first full-time project-based learning experience related to their degree. Grades issued are Satisfactory or Unsatisfactory.
Prerequisites: IT 102

CPDM 297 Project-Based Learning 2
2 Credits. 1 Lecture Hour. 40 Lab Hours.

Students seeking an associate's degree participate in their second full-time project-based learning experience related to their degree. Grades issued are Satisfactory or Unsatisfactory.
Prerequisites: CPDM 296 or CPDM 291

IT Courses

IT 100 Computer Programming Foundations
3 Credits. 2 Lecture Hours. 3 Lab Hours.

A course on fundamental concepts related to computer programming. Topics include: problem solving and developmental tools, design techniques such as flow charting and pseudo coding, and testing techniques used in programming.
Prerequisites: ENG 085 and MAT 093, or appropriate placements

IT 101 Programming 1
3 Credits. 2 Lecture Hours. 3 Lab Hours.

An introduction to software development. Topics include: application design methods, application testing methods, the sequential structure of programming, the conditional structure of programming, variables, and modular programming concepts using procedures and functions.
Prerequisites: ENG 085 and MAT 093, or appropriate placements

IT 102 Programming 2
3 Credits. 2 Lecture Hours. 3 Lab Hours.

A continuation of IT 101. Topics include: the iterative programming structure, database programming, array processing, and string manipulation techniques.
Prerequisites: IT 101 and IT 111 (minimum grade C for both)

IT 103 .NET Programming 3
3 Credits. 2 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 and IT 111

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, input/output (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: ENG 085 and MAT 093, or appropriate placements

IT 110 HTML with CSS and JavaScript
3 Credits. 2 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 applications (apps), and dynamic web pages.
Prerequisites: None

IT 111 Database Design and SQL 1
3 Credits. 2 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: ENG 085 and MAT 093, or appropriate placements

IT 112 Database Design and SQL 2
3 Credits. 2 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 data models from abstract requirements.
Prerequisites: IT 111 (minimum grade C)

IT 115 Operating Systems Administration 1
3 Credits. 2 Lecture Hours. 3 Lab Hours.

A course on the Windows operating system used on PCs. Topics include Windows utilization and management, utilities, managing disks, disaster recovery, troubleshooting, user management, productivity tools, and performance issues. This course prepares students for a Microsoft Certification exam.
Prerequisites: ENG 085 or appropriate placement

IT 116 Operating Systems Administration 2
3 Credits. 2 Lecture Hours. 3 Lab Hours.

A continuation of IT 115. Topics include: managing software problems; managing virtualization; and client configuration, development, deployment, and security. This course prepares students for a Microsoft Certification exam.
Prerequisites: IT 115 (minimum grade C)

IT 117 Web Application Development 1
3 Credits. 2 Lecture Hours. 3 Lab Hours.

A course on fundamentals of web-based application development. Topics include: current front-end and back-end technologies used to develop business-related applications, and understanding infrastructure to support application development.
Prerequisites: IT 102 and CPDM 120 (minimum grade C for both)

IT 118 Web Application Development 2
3 Credits. 2 Lecture Hours. 3 Lab Hours.

A continuation of IT-117. Topics include: using current front-end and back-end technologies to develop business-related applications.
Prerequisites: IT 117

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: IT 101 and IT 110

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, radio-frequency identification (RFID), Wi-Fi tags, logistics and inventory software, high frequency tracking, and passive/active tracking.
Prerequisites: None

IT 161 Java Programming 1
3 Credits. 2 Lecture Hours. 3 Lab Hours.

A course on fundamentals of 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: CPDM 120 and IT 102 (minimum grade C for both)

IT 162 Java Programming 2
3 Credits. 2 Lecture Hours. 3 Lab Hours.

A continuation of IT 161. Topics include: Java Server Pages (JSP) and complex database applications using Java and JSP.
Prerequisites: IT 161

IT 212 Business Intelligence, Data Warehousing, and Reporting
3 Credits. 2 Lecture Hours. 3 Lab Hours.

A course on concepts, technologies, and techniques used to effectively consolidate, arrange, and analyze large amounts of data. Topics include: decision support systems, data mining, and how to derive business value from large amounts of data.
Prerequisites: IT 112

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

IT 218 Web Application Development 2
3 Credits. 2 Lecture Hours. 3 Lab Hours.

A continuation of IT 117. Topics include advanced front-end and back-end processing to develop advanced web-based applications.
Prerequisites: IT 117

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

IT 262 Java Programming 2
3 Credits. 2 Lecture Hours. 3 Lab Hours.

A continuation of IT 161, with focus on completing complex projects using Java and associated technologies.
Prerequisites: IT 161

Faculty

Program Chair/Advisor

Robert (Bob) Nields, MBA
robert.nields@cincinnatistate.edu

Co-op Coordinator

Noelle Grome, MEd, MA
noelle.grome@cincinnatistate.edu

Advisor

Bernell Prince, BS
bernell.prince@cincinnatistate.edu