Software Applications

 

 

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

Are you a new AutoCAD user? If you require comprehensive training to produce 2D drawings in AutoCAD, this course is for you. It 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 good working knowledge of PC’s and Microsoft Windows is necessary for this class. An understanding of basic drafting skills and blueprint reading is helpful.
$630/ WCOAP 6064 WB1, C50 & C70
Newtown Campus/ WB1/ W, 2/6-4/24, 6:30-9:30 pm
Upper Bucks Campus/C70/6 Sa, 2/9-3/16, 9 am-3:30 pm
Lower Bucks Campus/C50/6 Sa, 2/23-4/6, 9 am – 3:30 pm (no class 3/30
Approved Hours: 36 (Act 48, Engineers)

AutoCAD 3D Modeling 2012 2nd Level (Approved Hours: 36, Act 48)
If you are already using AutoCAD for 2D designs but want to add 3D modeling to your list of skills, then this course is for you. It 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, and 3D solid models, and making multi-view drawings. Prerequisites: working knowledge of AutoCAD and Microsoft Windows OS, plus understanding of basic draftingc skills and blueprint reading.
$630 (plus book fee)/WCOAP 6065 WB1,C70
Upper Bucks Campus/C70/6 Sa, 4/6-5/11, 9 am-3:30 pm
Newtown Campus/WB1/ 9 W, 5/1-6/26, 6-10 pm
Approved Hours: 36 (Act 48, Engineers)

Revit®Architecture Basics
Revit® 2012 is a parametric 3D modeling software that works the way architects and designers think. This course will introduce you to Building Information Modeling (BIM) and the tools for parametric design and documentation. You will quickly gain an understanding of how Revit can enhance your project designs by communicating your ideas faster and easier. The course will cover the concepts and introduce 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.
$750 (plus book fee)/WCOAP 6068 WB1, C50
Newtown Campus/$745/WCOAP 6068 WB1
6 Sa, 10/13-11/17m 8:30 am-3 pm
Approved Hours: 36 (Act 48, Engineers)

Microsoft Access 2010® Basic (Approved Hours: 9, Act 48, CPA)
You will learn the basic functions and features of Access 2010. After an introduction to database concepts and the Access environment and Help systems, students will learn how to design and create databases. Then you will work with tables, fields, and records; sort and filter data; and set field properties and data entry rules. You will then learn to create queries, forms, and reports. This course will help you prepare for the Microsoft Office Specialist exam for Access 2010 (exam 77-885). For comprehensive certification training, you should complete the Basic, Intermediate, and Advanced courses for Access 2010. Tuition $184, Course # WCOAP 3030, Text: Axzo Press, Access 2010: Basic + CertBlaster, Student Manual, ISBN# 978-1-4260-2146-6.

Microsoft Access 2010® Intermediate (Approved Hours: 9, Act 48, CPA)
You will build on the skills and concepts taught in Access 2010: Basic. You will learn how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculated fields, and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use PivotTables and PivotCharts. This course will help you prepare for the Microsoft Office Specialist exam for Access 2010 (exam 77-885). For comprehensive certification training, you should complete the Basic, Intermediate, and Advanced courses for Access 2010. Tuition $184, Course # WCOAP 3031, Text: Axzo Press, Access 2010: Intermediate + CertBlaster, Student Manual, ISBN # 978-1-4260-2149-7.

Microsoft  Access 2010® Advanced (Approved Hours: 12, Act 48, CPA)
You will build on the skills and concepts taught in Access 2010: Intermediate. You will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; interact with XML documents; create hyperlink fields; optimize, split, and back up databases; password-protect and encrypt databases; and set Access options and properties. This course will help you prepare for the Microsoft Office Specialist exam for Access 2010 (exam 77-885). For comprehensive certification training, you should complete the Basic, Intermediate, and Advanced courses for Access 2010. Tuition $245, Course # WCOAP 3034, Text: Axzo Press, Access 2010: Advanced + CertBlaster, Student Manual, ISBN # 978-1-4260-2152-7.

Microsoft Excel 2010® Basic (Approved Hours: 9, Act 48, CPA)
You will learn the basic functions and features of Excel 2010. After an introduction to spreadsheet terminology and Excel's window components, you will learn how to use the Help system and navigate worksheets and workbooks. Then you will enter and edit text, values, formulas, and pictures, and you will save workbooks in various formats. You will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, and printing. Finally, you will create and modify charts, and learn how to manage large workbooks.Course manual comes with CertBlaster exam prep software (download). This course will help you prepare for the Microsoft Office Specialist core-level exam for Excel 2010 (exam 77-882) and the Microsoft Office Specialist Expert exam for Excel 2010 (exam 77-888). For comprehensive certification training, you should complete the Basic, Intermediate, and Advanced courses for Excel 2010. Tuition $184, Course # WCOAP 1535, Text: Axzo Press, Excel 2010: Basic + CertBlaster, Student Manual, ISBN # 97978-1-4260-2155-8.

Microsoft Excel 2010® Intermediate (Approved Hours: 9 (Act 48, CPA)
You will builds on the skills and concepts taught in Excel 2010: Basic. You will learn how to use multiple worksheets and workbooks efficiently, and you will start working with more advanced formatting options including styles, themes, and backgrounds. You will also learn how to create outlines and subtotals, how to create and apply cell names, and how to work with tables. You will save workbooks as Web pages, insert and edit hyperlinks, and learn to share workbooks by email. This course also covers advanced charting techniques, use of trendlines and sparklines, worksheet auditing and protection, file sharing and merging, and workbook templates. Finally, you will learn to work with PivotTables and PivotCharts. Course manual comes with CertBlaster exam prep software (download). This course will help you prepare for the Microsoft Office Specialist core-level exam for Excel 2010 (exam 77-882) and the Microsoft Office Specialist Expert exam for Excel 2010 (exam 77-888). For comprehensive certification training, you should complete the Basic, Intermediate, and Advanced courses for Excel 2010. Tuition $184, Course # WCOAP 1536, Text: Axzo Press, Excel 2010: Intermediate + CertBlaster, Student Manual, ISBN # 978-1-4260-2158-9.

Microsoft Excel 2010® Advanced (Approved Hours: 9, Act 48, CPA)
You will build on the skills and concepts taught in Excel 2010: Intermediate. You will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, you will learn about data validation and database functions such as DSUM. You will learn how to import and export data, and how to query external databases. Finally, you will learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, SmartArt graphics, and conditional formatting with graphics. Course manual comes with CertBlaster exam prep software (download). This course will help you prepare for the Microsoft Office Specialist core-level exam for Excel 2010 (exam 77-882) and the Microsoft Office Specialist Expert exam for Word 2010 (exam 77-888). For comprehensive certification training, you should complete the Basic, Intermediate, and Advanced courses for Excel 2010. Tuition $184, Course # WCOAP 1537, Text: Axzo Press, Excel 2010: Advanced + CertBlaster, Student Manual, ISBN # 978-1-4260-2161-9.

Microsoft Word 2010® Basic (Approved Hours: 9, Act 48, CPA)
You will gain the necessary skills to create, edit, format, and print basic Microsoft Office Word 2010® documents. This course covers the basic functions and features of Word 2010. After an introduction to Word's window components, you will learn how to use the Help system and navigate documents. Then you will enter and edit text, create and save documents, and learn how to enhance the appearance of a document by using various formatting options. You will also create tables, insert headers and footers, proof and print documents, and insert graphics. Course manual comes with CertBlaster exam prep software (download). This course will help you prepare for the Microsoft Office Specialist core-level exam for Word 2010 (exam 77-881) and the Microsoft Office Specialist Expert exam for Word 2010 (exam 77-887). For comprehensive certification training, students should complete the Basic, Intermediate, and Advanced courses for Word 2010. Tuition $184, Course # WCOAP 0064, Text: Axzo Press, Word 2010: Basic + CertBlaster, Student Manual, ISBN # 978-1-4260-2164-0.

Microsoft Word 2010® Intermediate (Approved Hours: 9 (Act 48, CPA)
You will build on the skills and concepts taught in Word 2010: Basic. You will work with styles, sections, and columns and will use the Navigation pane to work with outlines. You will format tables, print labels and envelopes, and work with graphics. You will also use document templates, manage document revisions, and work with Web features. Course manual comes with CertBlaster exam prep software (download). This course will help you prepare for the Microsoft Office Specialist core-level exam for Word 2010 (exam 77-881) and the Microsoft Office Specialist Expert exam for Word 2010 (exam 77-887). For comprehensive certification training, students should complete the Basic, Intermediate, and Advanced courses for Word 2010. Tuition $184, Course # WCOAP 0065, Text: Axzo Press, Word 2010: Intermediate + CertBlaster, Student Manual, ISBN # 978-1-4260-2167-1.

Microsoft Word 2010® Advanced (Approved Hours: 9, Act 48, CPA)
You will build on the skills and concepts taught in Word 2010: Intermediate. You will perform mail merges, create and use forms, and create master documents that include a table of contents, a table of figures, footnotes, endnotes, an index, bookmarks, cross-references, and Web frames. You will also create macros, customize the ribbon and Quick Access toolbar, and work with XML documents. Course manual comes with CertBlaster exam prep software (download). This course will help you prepare for the Microsoft Office Specialist core-level exam for Word 2010 (exam 77-881) and the Microsoft Office Specialist Expert exam for Word 2010 (exam 77-887). For comprehensive certification training, students should complete the Basic, Intermediate, and Advanced courses for Word 2010. Tuition $184, Course # WCOAP 0066, Text: Axzo Press, Word 2010: Advanced + CertBlaster, Student Manual, ISBN # 978-1-4260-2170-1.

PowerPoint 2010® Basics (Approved Hours: 9, Act 48)
You will learn the basic functions and features of PowerPoint 2010. After an introduction to PowerPoint's window components and Help system, you will learn to create, save, and rearrange presentations. Then you will format text, use drawing objects, work with graphics, and insert tables and charts. You will then learn to use templates and themes, slide masters, and transition effects. Finally, you will learn to proof, run, and print presentations. Course manual comes with CertBlaster exam prep software (download). This course will help you prepare for the Microsoft Office Specialist exam for PowerPoint 2010 (exam 77-883). For comprehensive certification training, students should complete the Basic and Advanced courses for PowerPoint 2010. Tuition $184, Course # WCOAP 1071, Text: Axzo Press, PowerPoint 2010: Basic + CertBlaster, Student Manual, ISBN # 978-1-4260-2068-1.

PowerPoint 2010® Advanced (Approved Hours: 9, Act 48)
You will build on the skills and concepts taught in PowerPoint 2010: Basic. You will customize PowerPoint by modifying the Ribbon and changing application settings. You will also apply themes and templates, and you will work with SmartArt graphics and tables. You will add multimedia content and interactive elements to slides, and you will learn about presentation distribution options including PDF, HTML, and online broadcasts. Finally, you will integrate PowerPoint with Word and Excel. Course manual comes with CertBlaster exam prep software (download). This course will help you prepare for the Microsoft Office Specialist exam for PowerPoint 2010 (exam 77-883). For comprehensive certification training, you should complete the Basic and Advanced courses for PowerPoint 2010. Tuition $184, Course # WCOAP 107X, Text: Axzo Press, PowerPoint 2010: Advanced + CertBlaster, Student Manual, ISBN # 978-1-4260-2071-1.

QuickBooks Pro/Premier 2012 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 $304, Course # WCOAP 1606, Text: Intuit QuickBooks Fundamentals Learning Guide 978-1-57338-114-7

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 $124, Course # WCOAP 1607, Text: Intuit QuickBooks Fundamentals Learning Guide 978-1-57338-114-7

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 $84, WCOAP 1605.

Introduction to Microsoft Outlook 2010 (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

Introduction to Microsoft Project 2010 (Approved Hours: 12, Act 48, PMI)
If you are a current Project Manager or Administrator, or see this as your next career step, this course is for you! Learn the basic functions and features of this powerful project management tool: how to create a new project file, create and modify task lists, create a Work Breakdown Structure, and work with task relationships. You’ll also learn how to create resource calendars, work with different project views and tables, and more. 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; students should have access to a computer with MS Project 2010 outside of class. Tuition $245, Course # WCOAP 3054, Text Microsoft Office Project 2010 Basic (Student Edition) ISBN # 1-4260-2049-X. Instructor: (On Campus) Bruno Ciaralli, M.B.A., PMP.(Online) Celine Gullace, PMP

Microsoft Project 2010 Advanced (Approved Hours: 12, Act 48, PMI)
Build on the concepts and skills learned in Introduction to Project 2010. 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: Microsoft Office Project 2010 Advanced with Data (Student Edition) ISBN # 1-4260-2052-X. Instructor: Bruno Ciaralli, M.B.A., PMP (On Campus), Celine Gullace, PMP (Online).

OpenOffice.org 3 (30 hours)
OpenOffice.org 3 is the leading open-source office software suite for word processing, spreadsheets, presentations, graphics, databases and more. It is available in many languages and works on all common computers. It stores all your data in an international open standard format and can also read and write files from other common office software packages. It can be downloaded and used completely free of charge for any purpose.  Many features that are available as extra cost add-ins in other office suites are free with OpenOffice. There are no hidden charges now or in the future.  Students are required to bring a 2 Gb USB Flash drive to class. Knowledge of basic word processing skills is recommended. Tuition $470, Course # WCOAP 7010, Text: Practical OpenOffice.org 3 ISBN # 978-1-440-45175-1.

Introduction to Microsoft Publisher 2007 (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

Introduction to Information Technology and Medical Office Applications (Approved hours: 60)
This course can be taken as part of the Electronic Health Record and Practice Management Specialist Certificate Program or can be taken separately. Topics covered in this course are:
• Overview of IT in the Medical Office
• Introduction to PC’s. You will learn personal computer basics, the main components of a typical computer system and how to  navigate in Windows Explorer, organize files and folders, search for items; learn how to browse the Web and protect your computer from malware and viruses.
• Basic and Advanced functions of Windows 7 such as working with devices and printers, protecting important patient files, maintaining and troubleshooting your computer and medical applications, and setting security features.
• Excel for the Medical Office learning general skills along with use of Medical Templates for Medical office charge-capture issue report, Medication log, Health History Questionnaire, and Medical Bill Tracker.
• Word for the Medical Office learning general skills along with use of templates to create personalized letters and pre-addressed envelopes or mailing labels for mass mailings, download a health history template or a personal health record template for use in the medical office.
• Outlook for the Medical Office where you will learn how to create and schedule appointments, read, create, send, and forward e-mail messages, manage contacts, work with tasks, and schedule meetings.
Tuition $999, Course # WCOAP 4000, Text (8 books), Axzo Press:
Introduction to Personal Computers, Windows 7 Edition + CertBlaster, Student Manual with Data, ISBN 978-1-4260-1934-0
Windows 7: Basic + CertBlaster, Student Manual with Data, ISBN 978-1-4260-1811-4  
Windows 7: Advanced + CertBlaster, Student Manual with Data, ISBN 978-1-4260-1814-5
Excel 2010: Basic + CertBlaster, Student Manual with Data, ISBN 978-1-4260-2155-8 
Excel 2010: Intermediate + CertBlaster, Student Manual with Data, ISBN 978-1-4260-2158-9
Word 2010: Basic + CertBlaster, Student Manual with Data, ISBN 978-1-4260-2164-0
Word 2010: Intermediate + CertBlaster, Student Manual with Data, ISBN 978-1-4260-2167-1
Outlook 2010: Basic + CertBlaster, Student Manual with Data, ISBN 978-1-4260-2116-9
Prerequisite: Healthcare Core Curriculum