St Cloud Technical and Community College · Courses
CMSC
14 courses with the subject CMSC, each shown exactly as we captured it from the college's catalog, with every element we hold. Where the wording looks broken, that is our reading of the catalog, not the college's text.
CMSC 1203Structured Programming Logic
This course introduces students to the programming major and lays the founda- tion for continued skill development in programming. Students will study both object-oriented and procedural programming and learn essential programming design methods and structures. Students will create algorithms, examine array constructs, and explore object-oriented topics such as classes and inheritance. The course includes team programming projects and introduces software col- laboration tools. By using a mix of theory and practical application, students will develop the introductory skills needed in structured program logic to succeed in the programming major. Student Learning Outcomes: * Create algorithms to solve programming problems. * Identify common programing structures. * Discuss modularization and its importance in programming. * Examine array concepts. * Discuss object-oriented programming concepts such as classes, inheritance, and polymorphism. * Collaborate in team programming projects. * Use software collaboration tools. * Create programs that use looping and decision structures and integrate user input. * Create programs that use arrays and modularization. * Create programs that utilize classes. Course Content/Topics: * Introduction to Computers and Programming * Input, Processing, and Output * Decision Structures and Boolean Logic * Repetition Structure * Functions * Files and Exceptions * Lists and Tuples * Dictionaries and Sets * Class, Inheritance, and Polymorphism (3 C: 2 lect/pres, 1 lab, 0 other)
CMSC 1206Introduction to Information Technology Concepts
This course will provide students with an introduction to information technology concepts in order to prepare them for a career in IT. During this class students will learn about hardware, cloud applications and data management systems. The student will be introduced to operating systems concepts, application software may change without notice. Page 135
This course will teach the student how to create web pages using the markup language HTML. Students will follow industry standards by using JavaScript and Cascading Style Sheets, which is used to make the web pages dynamic, formatted and styled. Students will also complete exercises using links, graphics, tables and forms. The programming techniques include proper coding syntax, passing information via web pages, and responsive design (mobile-friendly design) The HTML 5 and CSS3 standards will be reviewed in the course. Student Learning Outcomes: * Develop and build web pages using HTML, HTML5, JavaScript and CSS3. * Create dynamic web pages with JavaScript and JavaScript libraries such as jQuery. * Format web pages with Cascading Style Sheets (CSS). * Integrating links, graphics, tables and forms in HTML pages. * Create responsive web pages using media queries, flexbox and bootstrap framework concepts. * Publish code to production web servers. (3 C: 2 lect/pres, 1 lab, 0 other)
Databases are an integral part of modern computer applications. This course introduces students to basic relational database concepts, relational database terminology, and data modeling concepts. Students will create a conceptual data model using entity-relationship diagrams, understand the importance of referen- tial integrity, and learn how to enforce data integrity constraints when creating a database. SQL Data Manipulation Language and Data Definitions Language will be used to create database objects and to insert, read, update, and display data in a relational database management system. An introduction to NOSQL databases will also be covered. Student Learning Outcomes: * Install and configure a relational database in a Virtual PC environment. * Employ database normalization techniques. * Create and maintain relational databases, tables and other objects using Struc- tured Query Language (SQL). * Write SQL statements to create indexes, views, referential, entity, domain and user-defined constraints on database tables. * Write SQL statements and scripts to insert, delete, update and retrieve data in tables. * Write SQL statements to extract and manipulate data from database objects using joins. * Determine differences between different relational databases and not-relation- al databases (3 C: 2 lect/pres, 1 lab, 0 other)
The goal of data analytics is to gain knowledge and communicate conclusions drawn from data. This is an introductory data analyst course using commonly available data management systems. Throughout the course the students will make extensive use of spreadsheets including formulas, graphs and pivot tables. This course covers concepts such as percentages, trends and basic statistical con- cepts and database fundamentals. The course is targeted towards individuals who would like to apply the practices and potential use of large-scale data analytics to PLEASE NOTE: All program plans are preliminary and curriculum ma 2026-2027 St. Cloud Technical & Community College data sets. Student Learning Outcomes: * Demonstrate an understanding of the analytical process * Compare different data analysis tools * Recognize how data analysis tools automate and enhance the data analysis process * Identify the role statistical concepts play in analytics * Apply basic spreadsheet modeling for use in analytics * Create flexible data aggregations using pivot tables * Represent data visually using spreadsheet tools * Employ advanced spreadsheet functions to analyze data * Create a basic data model and connect to external data * Demonstrate an understanding of the importance of databases in the analytical process (3 C: 2 lect/pres, 1 lab, 0 other)
As internet and mobile use continues to grow, users expect web applications to perform like desktop applications. Single-page web apps (SPAs) deliver this func- tionality for the user. SPAs integrate client-side JavaScript frameworks to allow the application to seamlessly and dynamically integrate front-end user interfaces with back-end databases and server processing. Because SPAs only send the data that has been changed back to the server, they also offer the user a better applica- tion experience. These factors have increased the popularity and use of SPAs in the internet development environment. Student Learning Outcomes: * Construct a SPA programming environment. * Utilize JavaScript framework to develop SPAs. * Write SPAs that integrate JavaScript variables and constructs. * Integrate HTML templates into SPAs. * Utilize JSON for SPA database access and manipulation. * Integrate routing into SPAs to manipulate the SPA content. * Integrate sessions into SPAs to manage user profile information. * Integrate security into SPAs to manage user authentication and SPA security. Prerequisite(s): CMSC1255. (3 C: 2 lect/pres, 1 lab, 0 other)
Java is a widely used programming language, crucial for various types of soft- ware development, including web services, mobile applications, and enterprise solutions. This course aims to deepen students' understanding of both funda- mental and advanced programming constructs in Java, with a particular focus on object-oriented programming and development best practices. In this course students will set up a Java development environment and explore the key differ- ences between Java's strongly typed system and loosely typed languages such as Python. They will also explore core object-oriented programming concepts such as inheritance, polymorphism. And encapsulation, and advanced concepts includ- ing interfaces, collections, and exception handling. The course places significant emphasis on development methodologies including unit testing, employing popular frameworks like Junit, and introduces students to essential debugging techniques. Through a range of hands-on exercises and a final project, students will not only create new Java programs but will also engage in comprehensive unit testing and debugging, ensuring the development of robust, reliable software. Student Learning Outcomes: * Create the JDK and JRE environment. * Implement variables, data types, and control structures in Java. * Apply constructors, method overloading, inheritance, polymorphism, and encapsulation to Java programs. * Integrate interfaces, abstract classes, and exception handling in Java programs. * Implement File 1/0 operations. * Develop unit tests using testing frameworks. * Use debugging tools and best practices to troubleshoot Java applications. Prerequisite(s): CMSC1203. (4 C: 2 lect/pres, 2 lab, 0 other)
This course lays the groundwork for server-side programming, essential for developing dynamic, interactive web applications. It aims to equip students with critical skills in server-side logic, database management, and seamless data exchange between web servers and clients. It prepares students for a variety of y change without notice. Page 136
Database Modeling II is an advanced database modeling course designed to introduce the student to the management side of relational databases. This course builds on the skills learned in course prerequisites with a review of database maintenance and creation. Database reporting, administration and program- ming skill development will be the primary focus of this course. Advanced skill development in design, installation, configuration, maintenance, and analysis of performance will be highlighted throughout the course. Student Learning Outcomes: * Create, configure, and maintain SQL Server databases, tables, views, con- straints, indexes, queries * Construct UDF's, stored procedures, and triggers * Import data into database systems * Export data from database systems * Design security policies for operating and database users * Perform and maintain database systems * Implement database performance monitoring and tuning * Create and configure user permissions on database systems * Design and implement data backup and recovery plans on database systems * Create end user reports * Implement a basic Create, Read, Update, Delete interface * Explore alternative database models and software systems Prerequisite(s): CMSC1203, CMSC1216. (3 C: 2 lect/pres, 1 lab, 0 other)
This course introduces students to C# which is an object-oriented, type-safe programming language. C# enables developers to build many types of secure and robust applications that run in .NET. In this course students will learn the basics of Visual C# program structure, language syntax, and implementation. The focus of this course will be desktop application development. Students will also be introduced to software project management by participating in project-based, team-oriented groups while developing applications. Students will learn team dy- namics through changing project roles, meetings, demonstrations, and maintain- ing technical documentation for their projects. Practical usage of version control tools, such as Git, will also be emphasized in this course. Student Learning Outcomes: * Use C# programming language to create Windows Presentation Foundation (WPF) applications. * Employ data access with Graphical User Interface (GUI) controls and external data sources. * Apply source control into WPF applications. * Use current project development techniques and best practices. * Use software collaboration tools and version control. * Explain software project and team development roles. PLEASE NOTE: All program plans are preliminary and curriculum m 2026-2027 St. Cloud Technical & Community College Prerequisite(s) CMSC1236, CMSC2266. (3 C: 2 lect/pres, 1 lab, 0 other)
This course is a continuation of CMSC 2203 - C# Programming I and will expose the student to advanced C# concepts which will increase their programming expertise and value in the industry. Students will build additional knowledge and skills by creating cross platform .NET Core cloud enabled applications. The use of Generics, Delegates, Collections, Events, Lambda expressions, and Unit Testing will be reinforced. Students will integrate remote database connectivity and develop .NET applications and services. In addition, advanced programming performance techniques will be reviewed and implemented. Students will also build on the structured product development and collaboration techniques used in CMSC 2203 to deliver full featured C# applications. Student Learning Outcomes: * Create C# applications to access and manipulate data in a database using .NET. * Develop .NET applications. * Deploy .NET applications. * Create C# applications that use generics, delegates, collections and events. * Design anonymous functions using Lambda expressions. * Create multi-threaded applications * Create applications that utilize tasks and asynchronous techniques. * Demonstrate software project and team development roles. Prerequisite(s): CMSC2203. (3 C: 2 lect/pres, 1 lab, 0 other)
