Advanced Data: Cloud and BI 10152572

Introduces learners to Business Intelligence tools and Cloud Storage. Learners distinguish between star and snowflake schema in order to leverage capacities in OLTP and BI systems. Learners create views and visualizations of data tables. Additional topics include use of Power BI, Amazon Web Services, and Google Cloud.

Object-Oriented Design C 10152509

Builds upon the object-oriented concepts learned in earlier courses, continuing with an in-depth application of object-oriented design principles and patterns. Learners will survey design patterns and implement them in C# .NET applications. Additional topics include the observer, template, state, and command design patterns.

Database Design And SQL C 10152536

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.

Web Design 2 C 10152556

Extends knowledge of HTML and Cascading Style Sheets (CSS). Learners review basic HTML/CSS concepts, apply their knowledge of the box model, learn additional HTML concepts and CSS styling techniques and create responsive websites. Additional topics include: using tools and techniques to assist in troubleshooting and a brief introduction to JavaScript.

Client-Side Web Development 1 C 10152563

Explores the intermediate concepts of client-side development using JavaScript, with an emphasis on JavaScript Object Notation (JSON), server-side JavaScript, mobile JavaScript environments, the DOM and HTML APIs and European Computer Manufacturers Association (ECMA script) versus JavaScript versions. Learners will also explore JavaScript frameworks.

Client-Side Web Development 2 C 10152566

Applies the basic concepts of client-side development using JavaScript, with an emphasis on understanding the similarities and differences between JavaScript and other object-oriented languages, array structures, objects, debugging, and exploring the Document Object Model (DOM). Learners will create and debug JavaScript applications using an IDE.

Data Concepts B 10152532

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.

Web Design 1 C 10152553

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.

Programming Concepts C 10152503

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.

IT Development and Design Fundamentals 10152500

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.

Web Design 1 B 10152552

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.

Data Concepts C 10152533

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.

Software Architecture 10152392

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.

Advanced .NET Programming: Web Services 10152512

Explores a variety of advanced C# .NET syntax and language features. This course provides a framework for deep learning by utilizing a variety of resources and tools. Learners will use API test utilities and create C# .NET web API applications. Additional topics include invoking, deploying, and securing web APIs.

Database Design And SQL A 10152534

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.

Web Design 1 A 10152551

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.

Open-Source Web Development A: Php/MySQL 10152567

Introduces server-side web development using PHP and MySQL. Learners will create open-source, server-side web applications. Additional topics include: web security and creating and writing web services.

User Experience Design A 10152524

Examines the fundamental principles and concepts of user experience research. Learners will apply user experience standards in the research phase of the User Experience Design process to provide a quality user experience. Topics include: psychological and interaction principles, user research, and requirements analysis.

Client-Side Web Development 1 A 10152561

Applies the basic concepts of client-side development using JavaScript, with an emphasis on understanding the similarities and differences between JavaScript and other object-oriented languages, array structures, objects, debugging, and exploring the Document Object Model (DOM). Learners will create and debug JavaScript applications using an IDE.

Application Development Capstone Project 10152393

Builds team software development and communication skills. Learners will form small teams, each identifying, designing and implementing an attractive and usable software application. The project teams will each use Agile software development principles to manage their projects, communicate project status, adapt to changing requirements and overcome technical challenges. Additional topics include a review of the Agile software development methodology.

Mobile Programming A 10152591

Collaborative Computing 10152371

Introduces collaborative computing solutions from the user, developer and administrator perspectives. Learners will create a needs assessment, develop a project plan and implement a collaboration solution. Additional topics include workflows, the telecommuting workplace, remote work environments and real-time accessibility.

Web Design 3 10152213

Introduces the web design cycle, applies responsive web design concepts and prepares learners for real world website design. Learners will use current responsive frameworks in the creation of a website. Additional topics include the Canvas tag and the management of web projects.

IT Career Skills 10152398

Surveys the skills required to succeed in the IT job market. Learners will write IT-targeted resumes/cover letters, complete IT job applications, perform IT job searches, participate in IT mock interviews, self-market using social media, create a portfolio and network with IT professionals. Additional topics include creating a targeted cover letter/resume and IT interview preparation.

Advanced .NET Programming: Security And Optimization 10152510

Explores a variety of advanced C# .NET syntax and language features. This course provides a framework for deep learning by utilizing a variety of resources and tools. Learners will create C# .NET applications which incorporate advanced features including generics and multi-threading. Additional topics include string optimization, memory management and enumerated types.

Database Design And SQL B 10152535

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

Open-Source Web Development B: Angular 10152568

Introduces full stack web development using Angular open-source framework. Additionally, technologies, such as Express, Node, .Net Core and Entity Framework integration will be explored. Learners will create open-source web applications. Additional topics include: web security and creating and writing web services.

User Experience Design B 10152525

Examines the fundamental principles and concepts of the design and prototyping phase of the User Experience Design process. Learners will apply user experience standards in the design of web and software interfaces to provide a quality user experience. Topics include: psychological and interaction principles, requirements analysis, style guides, usability testing, and visual design principles.

Client-Side Web Development 1 B 10152562

Applies the concepts of client-side development using JavaScript, with an emphasis on understanding security, the Document Object Model (DOM), arrays, objects, as well as functions and modularity and exploring AJAX communication.

Mobile Programming B 10152592

Data Concepts A 10152531

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.

Advanced .NET Programming: The CLR 10152511

Explores a variety of advanced C# .NET syntax and language features. This course provides a framework for deep learning by utilizing a variety of resources and tools. Learners will create C# .NET applications which incorporate advanced features related to the common language runtime. Additional topics include reflection, custom attributes, dynamic UI generation and data binding.

Open-Source Web Development C: React 10152569

Introduces server-side web development using the JavaScript-based React framework. Learners will create open-source, server-side web applications. Additional topics include: web security, authentication and React Native.

User Experience Design C 10152526

Applies the principles and concepts of the design and prototype and testing phase of the User Experience Design process.  Learners will apply user experience standards in the development of an interactive prototype to provide a quality user experience. Topics include: psychological and interaction principles, designing for different devices, usability and user experience testing, and interactive design principles.

Mobile Programming C 10152593