Software Applications

 

AutoCAD

AutoCAD® Essentials (Approved Hours: 36, Act 48)

This course incorporates the features, commands, and techniques for creating, editing, and printing 2D drawings with AutoCAD. You will learn skills that can be used in all disciplines of AutoCAD, and specifically Engineering. Hands-on exercises throughout the course explore how to create 2D production drawings.
Prerequisite: A working knowledge of PC’s and Microsoft Windows is necessary. An understanding of basic drafting skills and blueprint reading is helpful. Text: AutoCAD 2011 Tutorial First Level 2D Fundamentals, ISBN# 978-1-58503-552-6

$630 (plus book fee)/ WCOAP 6064 C01-C70
Newtown Campus/ C01/ 12 Tu, 9/9-11/25,
6:30-9:30 pm
Bristol Campus/ C50/ 6 Sat, 10/18-11/22,
9:00am- 3:30pm
Upper Bucks Campus/ C70/ 11 Mon, 10/6-12/15, 5:30-9:30pm

AutoCAD 3D Modeling 2nd Level (Approved Hours: 36, Act 48)

For those familiar with AutoCAD, this course incorporates the features, commands, and techniques used to create, edit, and print 3D drawings with AutoCAD hands-on exercises throughout the course explore creating 3D wire frame models, 3D surface models, 3D solid models, and making multi-view drawings. Prerequisites: working knowledge of AutoCAD and Microsoft Windows OS, plus understanding of basic drafting skills and blueprint reading. Text: AutoCAD 2011 Tutorial Second Level 3D Modeling, ISBN# 978-1-58503-553-3

$630 (plus book fee)
Look for course offerings in Spring 2015
Approved Hours: 36 (Act 48, Engineers)

Revit®Architecture Basics (Approved Hours: 36)

The course covers the concepts and introduces Revit tools to create a schematic design from construction documentation to design visualization. Pre-requisite: A working knowledge of computers, MS Windows, and previous experience in architectural design, drafting, or engineering is necessary. No previous CAD experience is necessary. Text: Revit Architecture 2012 Basics:  From the Ground Up, ISBN# 978-1-58503-676-9

Newtown Campus/$750 (plus book fee)/ WCOAP 6068 C01
6 Sat, 11/1-12/20 (no class 11/29, 12/6), 9:00am- 3:30pm
Approved Hours: 36 (Act 48, Engineers)

AutoDesk Inventor (36 Hrs)

Autodesk Inventor software serves as a flexible development platform for building specialized mechanical design applications, as well as for interfacing with upstream, downstream, and enterprise applications for manufacturers.

Bristol Campus/$675 (plus book fee)/ WCOAP 6070 C50
12 Wed, 9/10-12/10 (no class 9/24, 11/26), 6:30-9:30pm

Access 2013

Microsoft Access 2013® Basic (Approved Hours: 12, Act 48, CPA)

This course covers the basic skills and concepts you need to use Microsoft Access 2013 productively and efficiently. After an introduction to the Access 2013 environment, you will learn how to plan databases and create tables. Then you will learn to organize fields and records, and to work with data entry rules. You will learn how to create basic queries, and how to work with forms and reports.


This course will help you prepare for the Microsoft Office Specialist exam for Access 2013 (exam 77-424). For comprehensive certification training, you should complete the Basic, Intermediate, and Advanced courses for Access 2013. The instructor will provide an online test preparation application for this course. Tuition $225, Course # WCOAP 3041, Text: Access 2013: Basic, MOS Edition, Student Manual AX1426036132 (Rev 1), ISBN# 1-4260-3613-2.

Microsoft Access 2013® Intermediate (Approved Hours: 12, Act 48, CPA)

This course provides you with additional skills and concepts needed to use Microsoft Access 2013 productively and efficiently. You will learn to normalize data, join tables while observing referential integrity, query multiple tables, format forms and reports, insert background images and charts; and create specialized objects such as lookup fields, subforms and subreports, navigation forms, and calculated fields. This course will help you prepare for the Microsoft Office Specialist exam for Access 2013 (exam 77-424). For comprehensive certification training, you should complete the Basic, Intermediate, and Advanced courses for Access 2013. The instructor will provide an online test preparation application for this course. For comprehensive certification training, you should complete the Basic, Intermediate, and Advanced courses for Access 2013. Tuition $225, Course # WCOAP 3042, Text: Access 2013: Intermediate, MOS Edition, Student Manual AX1426036612 (Rev 1), ISBN # 1-4260-3661-2.

Microsoft  Access 2013® Advanced (Approved Hours: 12, Act 48, CPA)

This course builds on the skills and concepts taught in Access 2013: Basic and Access 2013: Intermediate. This course will help you prepare for the Microsoft Office Specialist exam for Access 2013 (exam 77-424). For comprehensive certification training, you should complete the Basic, Intermediate, and Advanced courses for Access 2013. The instructorwill provide an online test preparation application for this course. For comprehensive certification training, you should complete the Basic, Intermediate, and Advanced courses for Access 2013. Tuition $255, Course # WCOAP 3034, Text: Access 2013: Advanced, MOS Edition, Student Manual AX1426036191 (Rev 1), ISBN # 1-4260-3619-1.

Excel 2013

Microsoft Excel 2013® Basic (Approved Hours: 12, Act 48, CPA)

This course will familiarize you with spreadsheet terminology and the fundamental concepts of Microsoft Excel 2013, including identifying Excel window components, navigating worksheets, and downloading templates. In addition, you will learn the basics of entering and editing text, values, and formulas, and how to save workbooks in the native Excel format, as well as in other formats. You will learn how to move and copy data and formulas, how to determine absolute and relative references, and how to work with ranges, rows, and columns. You will also learn how to use simple functions, and how to easily apply formatting techniques to worksheet data. You will create and modify charts, and work with graphics. Finally, you will review workbooks for spelling errors, modify page setup, and print worksheets. This course will help you prepare for the Microsoft Office Specialist core-level exam for Excel 2013 (exam 77-420) and the Microsoft Office Specialist Expert exam for Excel 2013 (exam 77-421). For comprehensive certification training, you should complete the Basic, Intermediate, and Advanced courses for Excel 2013. the instructor will provide an online test preparation application for this course.  Tuition $225, Course # WCOAP 1580, Text: Excel 2013: Basic, MOS Edition, Student Manual AX1426036809, ISBN # 1-4260-3680-9.

Microsoft Excel 2013® Intermediate (Approved Hours: 12 (Act 48, CPA)

This course will teach you how to work with large worksheets in Microsoft Excel 2013, and use multiple worksheets and workbooks efficiently. It will introduce you to more advanced formatting techniques, such as applying special number formats, using workbook styles and themes, adding backgrounds, and mimicking watermarks. In addition, you will learn how to create outlines and subtotals, and how to create and apply cell names. You will sort and filter data, and create and format tables. You will learn how to save workbooks as Web pages, how to insert and edit hyperlinks, and how to share workbooks via email. You will learn how to audit worksheets for errors, how to protect worksheets, how to share and merge workbooks, and track changes in a workbook. Finally, you will customize the Excel environment, and create and modify custom templates. This course will help you prepare for the Microsoft Office Specialist core-level exam for Excel 2013 (exam 77-420) and the Microsoft Office Specialist Expert exam for Excel 2013 (exam 77-421). For comprehensive certification training, you should complete the Basic, Intermediate, and Advanced courses for Excel 2013. The instructor will provide an online test preparation application for this course. For comprehensive certification training, you should complete the Basic, Intermediate, and Advanced courses for Excel 2013. Tuition $225, Course # WCOAP 1581, Text: Excel 2013: Intermediate, MOS Edition, Student Manual‌ AX1426036833, ISBN # 1-4260-3683-3.

Microsoft Excel 2013® Advanced (Approved Hours: 12, Act 48, CPA)

In this course, you will further build on the skills acquired in the Microsoft Excel 2013 Basic and Intermediate courses. You will work with advanced functions and formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, you will learn about data validation, and will use advanced data filtering. You will apply advanced chart formatting options, and create more complex charts. You will work with PivotTables and PivotCharts, export and import data, and query external databases. You will learn about the analytical features of Excel, such as Goal Seek, and how to create scenarios. Finally, you will run and record macros, and explore VBA code. This course will help you prepare for the Microsoft Office Specialist core-level exam for Excel 2013 (exam 77-420) and the Microsoft Office Specialist Expert exam for Excel 2013 (exam 77-421). For comprehensive certification training, you should complete the Basic, Intermediate, and Advanced courses for Excel 2013. The instructor will provide an online test preparation application for this course.  Tuition $225, Course # WCOAP 1582, Text: Excel 2013: Advanced, MOS Edition, Student Manual AX1426036868, ISBN # 1-4260-3686-8.

Word 2013

Microsoft Word 2013® Basic (Approved Hours: 12, Act 48, CPA)

This course covers the basic skills and concepts you need to use Microsoft Word 2013 productively and efficiently. After an introduction to Word's window components, you will learn how to create and save documents and how to navigate documents. Then you will edit, copy and paste, and find and replace text. You will also learn how to enhance the appearance of a document by using various formatting options. In addition, you will create tables, adjust page layout, work with graphics, and proof and print documents. This course will help you prepare for the Microsoft Office Specialist core-level exam for Word 2013 (exam 77-418) and the Microsoft Office Specialist Expert exam for Word 2013 (exam 77-419). For comprehensive certification training, you should complete the Basic and Advanced courses for Word 2013. The instructor will provide an online test preparation application for this course. Tuition $225, Course # WCOAP 0164, Text:Word 2013: Basic 3-Day MOS Series Student Manual AX1426037309 (Rev 1), ISBN # 1-4260-3730-9.

Microsoft Word 2013® Intermediate (Approved Hours: 12 (Act 48, CPA)

In this course, you will further build on the skills acquired in the Microsoft Word basic course. You will learn to use styles and outlines, and how to format tables. Then you will insert SmartArt diagrams, work with shapes, and format text graphically. You will also learn how to format a document by adding sections, columns, and design elements such as watermarks and themes. In addition, you will use Track Changes and prepare documents for sharing and exporting. Finally, you will learn how to work with fields and perform a mail merge. This course will help you prepare for the Microsoft Office Specialist core-level exam for Word 2013 (exam 77-418) and the Microsoft Office Specialist Expert exam for Word 2013 (exam 77-419). For comprehensive certification training, you should complete the Basic and Advanced courses for Word 2013. The instructor will provide an online test preparation application for this course.  Tuition $225, Course # WCOAP 0165, Text: Word 2013: Intermediate 3-Day MOS Series Student Manual AX1426037333 (Rev 1), ISBN # 1-4260-3733-3.

Microsoft Word 2013® Advanced (Approved Hours: 12, Act 48, CPA)

This course covers advanced skills and concepts you need to use Microsoft Word 2013 productively and efficiently. You will learn to add interactive elements such as forms and content from other applications, and to save a file as a web page. Then you will learn how to use document references such as citations, indexes, and tables of contents. Next, You will learn to work more efficiently in Word by customizing the ribbon, creating macros, using building blocks, and inserting subdocuments. In addition, you will learn to record and copy macros, to create and modify VBA modules, and to control Word objects in the Visual Basic Environment. Finally, you will learn the fundamentals of VBA programming through creating control structures, designing VBA forms, and debugging programs. This course will help you prepare for the Microsoft Office Specialist core-level exam for Word 2013 (exam 77-418) and the Microsoft Office Specialist Expert exam for Word 2013 (exam 77-419). For comprehensive certification training, you should complete the Basic and Advanced courses for Word 2013. The instructor will provide an online test preparation application for this course. Tuition $225, Course # WCOAP 0166, Text: Word 2013: Advanced 3-Day MOS Series Student Manual AX1426037368 (Rev 1), ISBN # 1-4260-3736-8.

PowerPoint 2013

PowerPoint 2013® Basics (Approved Hours: 9, Act 48)

This course covers the basic functions and features of PowerPoint 2013. After an introduction to PowerPoint’s window components, you will open and run a presentation and switch between views. You’ll create a basic presentation and add content; arrange, insert, and delete slides; and apply templates and design themes. Then, you’ll learn how to create and edit shapes, insert and modify WordArt objects and pictures, and work with tables, charts, and diagrams. Finally, you’ll learn how to proof a presentation, create speaker notes, and present and share their presentations. This course will help you prepare for the Microsoft Office Specialist exam for PowerPoint 2013 (exam 77-422). For comprehensive certification training, you should complete the Basic and Advanced courses for PowerPoint 2013. The instructor will provide an online test preparation application for this course. Tuition $225, Course # WCOAP 1083, Text: PowerPoint 2013: Basic, MOS Edition, Student Manual,  AX1426036892 (Rev 1), ISBN #1426036892.

PowerPoint 2013® Advanced (Approved Hours: 9, Act 48)

This course builds on the skills and concepts taught in PowerPoint 2013: Basic. You will learn to control global settings by using slide masters, and to apply effects such as transitions and timings. You’ll learn more about working with images, and how to include media files, animation, and a photo album in a presentation. Next, you’ll explore advanced tools for working with SmartArt, tables, and charts, and then learn how to create action buttons and equations. You will also integrate other Microsoft Office files, embed and link external resources, and create hyperlinks. Then, you’ll insert review comments, protect a presentation with a password, and prepare a presentation for delivery in various formats. Finally, you’ll customize application settings and toolbars, and create and apply custom themes. This course will help you prepare for the Microsoft Office Specialist exam for PowerPoint 2013 (exam 77-422). For comprehensive certification training, you should complete the Basic and Advanced courses for PowerPoint 2013. The instructor will provide an online test preparation application for this course. Tuition $225, Course # WCOAP 1084, Text: PowerPoint 2013: Advanced, MOS Edition, Student Manual AX1426036922 (Rev 1), ISBN #1-4260-3692-2.

QuickBooks 2013

QuickBooks Fundamentals 2013 Comprehensive (Approved Hours: 15, Act 48, CPA)

You will learn to automate your business accounting function without the technical jargon of accountants and programmers;   to setup a new company, work with the chart of accounts, customer and vendor lists, handle cash, accounts receivable and payable;  the most comprehensive tools for fast and easy financial management to help your business achieve better results. Theories of basic business accounting and management principles will also be covered. Tuition $375, Course # WCOAP 1606, Text: Intuit QuickBooks 2014 Fundamentals Learning Guide, ISBN# 978-0-99110-0224

QuickBooks Payroll Module (Approved Hours: 6, Act 48, CPA)

You will learn how to process payroll in the most popular accounting program today. Through this hands-on class you will learn how to set up payroll very easily, process paychecks, and get familiar with the screen elements. Navigating with QuickBooks is a breeze. Prerequisite: Student should have taken the Quick- Books Comprehensive class (WCOAP 1606) or have good working knowledge of QuickBooks. Tuition $125, Course # WCOAP 1607, Text: Intuit QuickBooks 2014 Fundamentals Learning Guide 978-0-99110-0224

QuickBooks: Tips and Tricks - Advanced (Approved Hours: 4, Act 48, CPA)

You will be learn Top Ten QuickBooks® Tips, Tricks and Techniques and many power user tips and tricks available to help maximize your use of QuickBooks. Also you will learn the areas of advanced data mining and reporting techniques.  Tuition $85, WCOAP 1605.

Outlook 2013

Introduction to Microsoft Outlook 2013 (Approved Hours: 24, Act 48, CPA)

Learn the essentials of Microsoft Outlook from an expert instructor. Get up and running quickly with the most important aspects of the program, and even create a Google Gmail account for class assignments and personal use.
Online, Tuition $99, Course # ECOAP 0063

Project 2013

Introduction to Microsoft Project 2013 (Approved Hours: 12, Act 48, PMI)

This course teaches the basic commands and features of Microsoft Project 2013. You will learn how to create and modify task lists, establish a project schedule, create calendars, assign resources to tasks, track costs, and work with different views and tables. You will also apply filters and groups, and sort task and resource data. Finally, you will learn how to resolve resource conflicts. Prerequisite: Experience with Microsoft WORD and EXCEL (or equivalent) ; some experience on a project team or completion of a course in the fundamentals of Project Management; you should have access to a computer with MS Project 2013 outside of class. Tuition $245, Course # WCOAP 3054, Text: Project 2013: Basic, Student Manual AX1426037015 (Rev 1), ISBN #1-4260-3701-5.

Microsoft Project 2013 Advanced (Approved Hours: 12, Act 48, PMI)

Build on the concepts and skills learned in Introduction to Project 2013. Topic coverage includes baseline and interim plans, analysis of project statistics, project file formatting, custom views, and exchanging project data. Prerequisite: Completion of a basic level course in MS Project (any version); access to a computer with MS Project 2010 outside of class. Tuition $245, Course # WCOAP 3052, Text: Project 2013: Advanced, Student Manual AX142603704X (Rev 1), ISBN # 1-4260-3704-x.

Publisher 2013

Introduction to Microsoft Publisher 2013 (Approved Hours: 24, Act 48)

In this hands-on, project-oriented class for beginners, you’ll learn how to design, create, and publish a wide variety of stunning documents using Microsoft Publisher 2007.
Online, Tuition $95, Course # ECOAP 0053