Introduces students to foundational concepts of data, information, and data management. Learners identify and use different types of data models. Learners use Microsoft Visio to create diagrams that illustrate how entities are related. Additional topics include eliminating data redundancy, explaining structures of relational tables, and compiling a data dictionary.

Introduces the field of IT software development and design. Learners will explore degree and career paths, IT tools and processes and begin to demonstrate professional communication. Learners will create or modify a simple computer program using an integrated development environment.

Emphasizes programming concepts and standards, building on the object-oriented approach of 10-152-502 Programming Concepts B, with a focus on iterative development and testing. This course uses C# .NET, the Unified Modeling Language (UML) and other tools to present concepts from a variety of perspectives. Learners will create UML diagrams and write/debug C# .NET applications, applying the object-oriented basics of abstraction, encapsulation, inheritance.

Reinforces programming concepts and standards, building on the object-oriented approach introduced in 10-152-501 Programming Concepts A, with a focus on iterative development and testing. This course uses C# .NET, the Unified Modeling Language (UML) and other tools to present concepts from a variety of perspectives. Learners will create UML diagrams and write/debug C# .NET applications, applying the object-oriented basics of abstraction and encapsulation. Additional topics include: utilization of a debugger, object multiplicity and constructors.

Introduces programming concepts and terminology using an object-oriented approach, with a focus on iterative development and testing. This course uses C# .NET, the Unified Modeling Language (UML) and other tools to present concepts from a variety of perspectives. Learners will create UML diagrams and write/debug C# .NET applications that incorporate classes, fields, methods and variables. Additional topics include: utilization of an Integrated Development Environment (IDE), value and reference types, object instantiation/lifetime/scope and mathematical/conditional/logical expressions.

Introduces Hypertext Markup Language (HTML), Cascading Style Sheet (CSS) coding techniques. Learners will create/modify web pages using HTML tags and style the web pages with CSS. Additionally, learners will create and edit text content. For the final course project, learners will create a personal website portfolio. Additional topics include: text editors, FTP utilities and browser tools.

Introduces Hypertext Markup Language (HTML) and Cascading Style Sheet (CSS) coding techniques along with the development of text content to communicate clearly, concisely and effectively on the web. Learners will create/modify web pages using HTML tags and style the web pages with CSS. Additionally, learners will create and edit text content. For the final course project, learners will begin a personal website portfolio. Additional topics include: copyright considerations, text editors, and browser tools.

Create database models and database objects using T-SQL statements. Learners use data manipulation language (DML) to modify and create data. Learners manipulate the structure of existing tables to add, modify, and remove columns and constraints. Additional topics include foreign key relationships and indexes.

Learners describe primary keys and how to select them. Learners explain normalization and its role in the database design process. Learners apply normalization rules to evaluate and correct table structures. Learners use SQL Server and retrieve information from data tables. Learners use to SQL queries to join tables, aggregate data, and restrict data retrieval.

Introduces Hypertext Markup Language (HTML), Cascading Style Sheet (CSS) coding techniques. Learners will create/modify web pages using HTML tags and style the web pages with CSS. Additionally, learners will create and edit text content. For the final course project, learners will create a personal website portfolio. Additional topics include: text editors, FTP utilities and browser tools.

Examines proven strategies designed to help learners achieve greater personal, academic, and professional success. Learners will apply personal responsibility thinking and behaviors; self- management, awareness, and motivation strategies; as well as interdependence skills to develop a proactive life plan.

Builds upon the basic database principles learned in Data Concepts, further exploring database design/normalization and introducing more complex and varied SQL statements. Learners will create/modify data objects and populate/retrieve data using SQL. Additional topics include: understanding constraints and keys on tables.

Introduces the Agile software development methodology and applies it to managing a software development project. Learners will work in small teams, taking an application through its entire lifecycle including the phases of requirements gathering, analysis, design, development, testing, deployment and maintenance. Additional topics include an introduction to the following disciplines and related tools: project management, version control, issue tracking, unit/regression testing and automated build/deployment.

TBD

TBD

TBD

Focus on error handling and database security. Learners engage with data from disparate sources in order to understand basics of extract, transform, load (ETL) procedures. Learners will build a database and move data from source to target and also build simple data reports to illustrate what is in the database.

Builds on Database Design and SQL 1, learners use data manipulation language and data definition language to create and update more complex tables and data. Learners build views, indexes, and functions. Additional topics include database performance and SQL

TBD

Introduces N-tier software architecture where learners work in Agile teams to create and deploy ASP.NET applications comprised of data access, business and presentation layers using MVC architecture. The application will access data from a relational database using an object-relational mapping (ORM) framework. Additional topics include: Agile project management, version control, authentication, authorization and consuming web services.

TBD

TBD