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.

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.

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.

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.

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.

Mobile Programming A 10152591

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.

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.

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.

Desktop Publishing 10106188

Explore foundational concepts of desktop publishing, analyze components of planning a document, apply design techniques, and explore safety, ethical and legal concepts of desktop publishing. Design and create professional-quality documents for personal and business use including flyers, newsletters, brochures, logos, calendars and other media.

Document Management 10106157

Improve proper use of punctuation, number usage, capitalization, grammar, word choice and spelling to communicate effective writing and proofreading in a business environment. Refine proofreading, business writing and formatting skills (both print and electronic mediums) in industry-specific business documents.

Keyboarding 2 10106129

Applies keyboarding techniques (proper finger usage and body position) through hands-on touch typing on a QWERTY keyboard (alphabet, number and symbol keys). Learners are expected to enter this course with a minimum of 27 wpm. Learners will develop an increased rate of touch-typing at a minimum of 40 words per minute (wpm) and 26 npm (numbers) by the end of the course.

Principles of Customer Service 10106171

10-key By Touch 10106144

Introduces proper techniques (proper finger usage and body position) and touch method using a numeric keypad. Learners will develop speed and accuracy to meet industry standards for data entry of 8,000+ ksph. Challenge test available.

Office Internship 10106202

Applies skills developed through business technology program courses and updates career documentation and completes a 45-hour supervised work experience in an office setting applying previously learned skills (business writing; customer service; office software; problem-solving; work organization; team work, and soft skills) related to an office environment.

Integrated Microsoft Applications 10106186

Prepare documents, worksheets, presentations, databases and publications that incorporate a variety of software applications encouraging creative, problem solving, composition and critical thinking.

Microsoft Word Applications 10106142

Develop intermediate and advanced Microsoft Word features with an emphasis in business writing and formatting techniques based on a business standard style guide. Design, create and modify a variety of business documents.

Integrated Medical Office 10106112

Provides experience working with integrated medical office software that covers practice management and Electronic Health Records (EHR). Learners will utilize a web-based system to practice common daily medical office tasks such as scheduling, insurance billing and setting up patient records.

Modern Office Technologies 10106100

Introduces the learner to modern office technology with hands-on experience using a variety of existing and emerging technologies. Learners troubleshoot minor problems and conduct preventive maintenance common to office equipment and research new office technology. Prerequisites include a working knowledge of computers and the current Windows operating system.

Office Portfolio 10106201

Evaluate career opportunities and compare to relative skills to prepare appropriate career documentation and a mock interview. Develop a career portfolio and recognize the process of the job search as well as accepting and leaving a position.

Records Management 1 10106200

Explores the comprehensive field of records and information management (RIM). Learners develop ARMA principles and practices incorporating the knowledge by applying these skills to a simulated record systems environment.

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.

Meeting, Travel & Event Planning 10106107

Introduces skills to effectively plan and manage meetings, event pre-planning activities, facilitate meetings and events, produce minutes of meetings, coordinate equipment and facility setup, complete travel arrangements and conduct follow-up activities.

Introduction To Business Technology Programs 10106189

Introduces the learner to techniques for success in the Business Technology Programs. Learners will examine proper communication etiquette, set and achieve SMART goals, learn engagement opportunities, and establish a program schedule. The course will also address program outcomes, professional development opportunities, and the creation of a portfolio to be developed throughout their program. Through focused activities and assessments, students will be equipped for both academic and career success.

Computer Keyboarding 10106178

Introduces keyboarding techniques (proper finger usage and body position) through hands-on touch typing. Learners are introduced to the QWERTY keyboard (alphabet, number and symbol keys).

Microsoft Outlook 10106118

Introduces the learner to managing and creating professional business email communication, contacts/groups, appointments, and meeting scheduling within Microsoft Outlook. Learners will further examine and manage the Microsoft Outlook environment for productivity.

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

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.

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.

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

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.

Records Management 2 10106203

Explore records management with further examination into records and information management applying ARMA rules to numeric, subject, and geographic filing methods manually and digitally.

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.

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.