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 Programming C 10152506

Explores object-oriented programming concepts and C# .NET syntax and features, with a focus on iterative development and testing. This course uses a variety of resources including Unified Modeling Language (UML) diagrams to present design principles and concepts. Learners will create console and GUI C# .NET applications which incorporate n-tier design principles and object-oriented design principles and patterns, emphasizing the use of composition over inheritance, interfaces and polymorphism. Additional topics include: file access and serialization, delegates, anonymous methods, lambda expressions, and LINQ.

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.

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.

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.

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.

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.

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.

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.

Programming Concepts B 10152502

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.

Pipefitting And Valves For MMMP Trades (C-11) 50423720

Course introduces apprentices to pipe sizes, materials and schedules, examine fittings, tubing and valves, and develops skills related to layout, installation and maintenance.

Bearings For The MMMP Trades (M-1) 50423730

Apprentices will examine bearing types and applications, and compare equipment bearings. Then learners will develop skills related to bearing inspection, selection, removal, mounting, lubrication and diagnosing bearing failures.

Precision Measurements For MMMP Trades (C-4) 50423713

This course develops apprentice skills in precision measurement. Types of measuring instruments will be compared and then measuring skills using tapes, steel rules, micrometers, calipers, indicators, and gauges will be developed.

Electricity (l-4) 50423509

Build a complete motor control circuit using simulation software. Construct a complete motor control cirucuit using industrial components. Apply troubleshooting skills using a multi-meter in the circuits.

Fasteners For MMMP Trades (C-3) 50423712

Course provides apprentices with a chance to compare fasteners and their uses, analyze fastener failures, and install mechanical fasteners.

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

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.

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.

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.

Object-Oriented Programming A 10152504

Explores object-oriented programming concepts and C# .NET syntax and features, with a focus on iterative development and testing. This course uses a variety of resources including Unified Modeling Language (UML) diagrams to present design principles and concepts. Learners will create console and GUI C# .NET applications which incorporate n-tier design principles and object-oriented design principles and patterns, emphasizing the use of composition over inheritance, interfaces and polymorphism. Additional topics include: class libraries, exception handling, event handlers and basic user interface design and validation. 

Programming Concepts A 10152501

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.

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.

Collaborative Application Development 10152391

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.

Conveyors For The MMMP Trades (M-7) 50423736

Course examines chain, belt, and other types of conveyors and related components.

Couplings & Alignment For The MMMP Trade (M-2) 50423731

Course compares different coupling types and examines common misalignment problems. Apprentices will develop skills related to inspecting, troubleshooting, and preparing couplings for removal and installation, and also aligning and lubricating couplings.

Rigging For MMMP Trades (c-5) 50423714

Apprentices will compare types of rigging equipment and their uses; determine safe loads, rig and crib loads, and move a load with cranes and hoists in this course.

Sheet Metal And Structural Steel Fabrication For The MMMP Trades (M-9) 50423738

Course compares types of sheet metal and tools used by the trade. Apprentices will develop skills related to fabricating sheet metal and structural steel and then erecting structural steel.

Packings, Seals, Gaskets For MMMP Trades (C-13) 50423722

Apprentices will examine packing, seals and gaskets and compare materials and applications. Then skill in layout, cutting, inspecting, removing and installing these components will be developed.

Mobile Programming B 10152592

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.

Object-Oriented Programming B 10152505

Explores object-oriented programming concepts and C# .NET syntax and features, with a focus on iterative development and testing. This course uses a variety of resources including Unified Modeling Language (UML) diagrams to present design principles and concepts. Learners will create console and GUI C# .NET applications which incorporate n-tier design principles and object-oriented design principles and patterns, emphasizing the use of composition over inheritance, interfaces and polymorphism. Additional topics include: advanced event handlers and timers, recursion, sorting and searching algorithms and various data structures.

Belts, Sheaves, Pullys And Drives For The MMMP Trades (M-4) 50423733

Course compares different types of drive components. Apprentices will develop skills related to inspecting, troubleshooting, removing, selecting, and installing belt drive systems.

SDS & Adhesives And Sealants For MMMP Trade (C-14) 50423723

Course compares adhesives and sealant types and applications. Then apprentice skills will be developed related to applying adhesives and sealants to repair applications, interpreting MSDS information, and handling hazardous materials.

Gears, Gearboxes, Gear Assemblies For The MMMP Trades (M-5) 50423734

Course compares gear types and applications. Apprentices will develop skills inspecting gear assemblies, troubleshooting gear problems, removing gears and components, and reassembling gear drive systems.

Equipment Installation For The MMMP Trades (m-8) 50423737

Apprentices will layout equipment installations, plan for moving equipment, and set and level equipment.

Pumps For The MMMP Trades (M-3) 50423732

Course compares different pump types and their applications. Apprentices will complete a field inspection of pumps and learn how to troubleshoot, remove, overhaul, install and perform preventative maintenance on pumps.

Welding For MMMP Trades (C-6) 50423715

Course compares common welding processes and develops apprentice skills related to welding, cutting, heating and using oxy-gas. Welding with arc, MIG and TIG is included, along with common cutting and joining techniques.

Mobile Programming C 10152593

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.

Mechanical Power Transmission For The MMMP Trades (M-6) 50423735

Course examines drive transmission systems and their applications, including roller chains. Apprentices will develop skills inspecting power transmission systems and troubleshooting mechanical drive systems.

Metallurgy For MMMP Trades (C-7) 50423716

This course develops apprentice skills regarding metallurgic concepts. Apprentices will compare various metals and their applications, apply metallurgic techniques to work processes, test metals for hardness, and examine heat treating applications.