Center for Business and Workforce Development · 1127 West Fourth Street, Williamsport, PA · (570) 327-4775 · Fax (570) 321-5546 · wdce@pct.edu

WDCE Course Descriptions


MST - Microsoft

MST178
Mastering Photoshop - Level I
Learn the powerful tools of Photoshop for selecting parts of images and moving, duplicating, and resizing. Learn to use layers and to apply layer effects and filters to create special effects. Use painting tools and blending modes to create shading effects and perform adjustments to contrast and color balance.
Prerequisite(s): Experience with computers and work processors

MST184
Mastering Photoshop - Level II
Get a firm grasp of Photoshop concepts that are applicable to almost every facet of using the application. Learn to use Quick Mask mode, alpha channels, and Layer Masks to isolate image areas. Create vector paths. Control color. Perform one-step edits. Use Background Eraser and the Extract command.
Prerequisite(s): Mastering Photoshop - Part I or permission of the instructor

MST192
Fundamentals of Building Web Pages
Good foundations are necessary for good buildings. Learn to create Web pages the way they should be created. Learn the essential elements of all Web pages and how to make them work effectively. By the end of the course, be able to create and publish a personal Web page.
Prerequisite(s): Basic computer skills.

MST367
Introduction to QuickBooks 2008
Learn the powerful features of this easy-to-learn accounting software. QuickBooks is the No. 1 accounting software for individuals and businesses with lttle bookkeeping knowledge. Participants quickly learn to effectively create and track accounts, generate invoices, process payments, and leverage Internet technologies for accounting activities.
Prerequisite(s): Basic understanding of the Windows operating system and experience with Word processing.

MST369
Introduction to Personal Computing
This course is designed for those who are not comfortable using a PC. The relaxed classroom environment coupled with small class size makes this an exciting opportunity to learn, experiment, and ask questions without embarrassment. Our highly skilled instructors maintain a comfortable pace and present the most relevant material for participants. Students will learn basic computer concepts and essential skills for the effective use of a personal computer at home or on the job.

MST370
Introduction to Windows XP
Learn how to tap into the power of the Windows Operating System with confidence. This course is a customized, dynamic, interactive class for new to intermediate computer users. Students will create, save, and retrieve files, create and manage folders, and understand the proper design of directories. Gain control of the Windows work environment by customizing the desktop, creating shortcuts and essential system clean up.
Prerequisite(s): Introduction to Personal computers or permission of the instructor

MST405
Getting a Grip on Elements
Elements is Adobe's cost-effective, mid-level photo editing program aimed at photographers and advanced home users. This class explores the powerful capabilities of Elements, enabling you to get the most out of your images. Topics include importing images from scan and digital cameras, resizing images, and much more.
Prerequisite(s): Experience with computers and the Windows operating system.

MST441
Microsoft Word 2003 Level I
Gain confidence and proficiency in using the world's most popular word processing program. Learn to create, save, retrieve, edit, format, manage, and print high-impact documents. Make effective formatting easier. Leverage powerful proofing tools. Capitalize on time-saving tips and techniques. Overcome frustrating mistakes.
Prerequisite(s): Knowledge of personal computers and experience in the Windows operating system

MST442
Microsoft Word 2003 Level II
Grasp the powerful, advanced features of Microsoft Word 2003. Take hold of styles and templates, create tables and charts, and use mail merge. Quickly modify documents with a single click. Drill through complex tasks and create powerful, effective documents with ease. Leverage Word's exciting, built-in productivity tools and gain greater proficiency.
Prerequisite(s): Word 2003 Level I or permission of the instructor.

MST443
Microsoft Excel 2003 Level I
Learn to use Excel 2003 with confidence and begin creating rich spreadsheets to analyze, share, and effectively report data in a matter of hours. Learn to create, modify, and format a functional spreadsheet. Set up formulas and functions with skill. Capture attention using powerful charts and vivid graphs. Exploit Excel's formatting tools to capture attention and emphasize information. Dig into information with sorting, filtering, and editing lists.
Prerequisite(s): Knowledge of personal computers and experience with the Windows operating system.

MST444
Microsoft Excel 2003 Level II
Craft personal and business value by tapping into the superior functionality of Microsoft Excel 2003. Prevent accidental or intentional corruption of data. Double check the accuracy of data entries with validation. Use old data in new and constructive ways using functions to convert and interpret information. Leap ahead with pivot tables and vibrant pivot charts. Enter the potent world of database functions. Enhance clarity with advanced filters and formatting.
Prerequisite(s): Microsoft Excel 2003 Level I or permission of the instructor.

MST445
Microsoft Access 2003 Level I
Understand database terminology; uncover the secrets of wizards, task panes, and clever navigation tools. Easily enter, move, insert, and modify records. Unlock a fountain of knowledge with a new primary key. Navigate the confusing world of relational databases with confidence and quickly create powerful forms and tools that organize, analyze, and transform data into significant value.
Prerequisite(s): Knowledge of personal computers and experience in the windows operating system.

MST447
Microsoft PowerPoint 2003 Level I
Mold bland information into stimulating content. Uncover the secret potential of the format painter. Make an ordinary bulleted list extrordinary. Learn tips and tricks for creating eye-catching charts, adding animations, and taking your presentation on the road. Begin creating and managing robust presentations that effectively communicate, educate, and convince any audience.
Prerequisite(s): Basic understanding of the Windows operating system or permission of the instructor.

MST474
Microsoft Access 2003 Level II
Learn advanced features of Microsoft Access 2003. Manage data with customized tables and special purpose reports. Enhance data entry with customized forms. Save time by speeding up repetitive tasks using dynamic macros. Uncover the secrets of locking down and protecting data. You can revolutionize the way you or your company organizes, analyzes, and leverages information. Microsoft Access 2003 is a relational database-management system. This course introduces the advanced features of the software. Participants will learn to make data entry easier and more accurate, manage data using smaller related tables, enhance the functionality of forms, and create special-purpose reports. Learn the techniques for automating a database with macros and managing a database with special-action queries and utilities. Some of the powerful techniques students will discover are: Custom designing a useful database; Creating complex queries; Developing personalized custom forms and subforms; Quickly create customized reports that deliver powerful information and secrets for locking down a database to protect data. Access 2003 can revolutionize the way you or your company organize, analyze and share information. in
Prerequisite(s): Microsoft Access 2003 Level I or permission of the instructor

MST475
Project Management Fundamentals
Learn how to use project management techniques to plan, organize, control, document, and close out projects successfully and with minimum risk. This course overviews the basics of project management and provides the theory and core methodology needed to manage projects or participate on project teams.
Prerequisite(s): Basic understanding of the Windows operating system and how to launch an application and create and save files.

MST499
Advanced QuickBooks 2008
Learn the advanced features of this widely-used accounting software. Participants will learn to effectively interact with the QuickBooks user interface to create reports, maximize the efficiency of forms, leverage business services, improve handling of sales taxes, explore job estimating, and learn tips and tricks for more flexible navigation within QuickBooks Pro. Learn to manage complex financial accounts with confidence.

MST574
Computer Skills for College Survival
An introductory computer class covering the basic skills needed to survive in a college program. Includes internet search skills, e-mails and attachments, basic word processing for research papers and reports, and saving and trasporting files. This course should be especially helpful to non-traditional students wanting to return to school.

MST576
Windows Vista Administration & Support
Windows Vista is the newest desktop operating system from Microsoft. This course covers the differences between each version of Windows Vista, its new functionalities, and its advanced security features. While suitable for IT professionals and participants alike, this course is geared more towards those who are looking to understand and plan the deployment of this new operating system in their business environment.
Prerequisite(s): Basic working knowledge of computers and networks

MST580
Basic Word 2007
Are you new to Word or frustrated with the new interface? This course is for you. Learn how to navigate using the ribbon. Find new ways to edit and format text, paragraphs, and entire documents. Understand and utilize the most powerful tool for controlling and presenting information-the table.

MST581
Intermediate Word 2007
Are you already proficient with Word 2007? This course takes you to the next level. Learn how to enhance the impact of documents with graphics and speed up productivity with themes and building blocks. Reach into styles and templates, manage long documents, and leverage styles and templates.

MST582
Advanced Word 2007
Master the advanced features of Word 2007. Learn how to work with references and integrate Word with other programs. Learn advanced graphics and create forms for gathering, controlling, and analyzing information. Uncover Word's collaboration features. Make Word work for you with customization techniques.

MST583
Basic Excel 2007
Are you new to Excel or frustrated with the new interface? This course is for you. Learn how to navigate using Excel's ribbon. Jump into formulas and functions. Craft the appearance of information with formatting. Create impact with charts. Unleash the power to analyze data in order to enhance the decision-making process.

MST584
Intermediate Excel 2007
Are you already proficient with Excel 2007? This course propels beginners to new levels of expertise. Learn how to get a grip on data that can be overwhelming. Quickly generate tables and analyze table data. Speed-up tasks with automations tools. Take your charts to the next level for enhanced impact and clarity.

MST586
Basic Access 2007
Are you new to Access or frustrated with the new interface? This course is for you. Learn how to navigate using the Access ribbon. Learn data mining by building and using queries. Uncover the secrets of forms and reports. Learn the methods for modifying database structures.

MST587
Intermediate Access 2007
Are you already proficient with Access 2007 queries, forms, and reports? This course helps you drive beyond the basics to higher levels of expertise. Assemble multiple tab queries and enhance your forms. Dig deeper into analyzing data with reports. Get a grip on importing and exporting data. Fine tune your skills with real world data analysis and crafting advanced queries.

MST589
Basic PowerPoint 2007
Are you new to PowerPoint or frustrated with the new interface? This course is for you. Uncover new methods for quickly creating and modifying useful presentations. Understand the power of objects. Add the finishing touches and speed things up with advanced tools and masters.

MST592
Microsoft Publisher 2007
Microsoft Publisher 2007 is an easy-to-use, flexible program for creating newsletters, brochures, business cards, postcards, flyers, etc. for print, e-mail, and the Web. In this course, you will explore how to create a publication from scratch or use one of the hundreds of business and personal designs available in Publisher.

MST593
Mastering Windows XP
This course is a dynamic, interactive class for individuals currently using a computer. Participants will learn how to manage multiple windows, create folders, manage directories, use the control panel, create shortcuts, and much more. Installing and deleting applications, enhancing the Windows environment, and tips and tricks for mastering the Internet are also covered. End frustrations and enhance productivity with this valuable class.

MST594
Microsoft Office Project 2007
Create a project plan containing tasks. Organize tasks in a work breakdown structure containing task relationships. Create and assign resources. Finalize the project to implement the project plan. Learn to update and modify plans once they have reached the project implementation phase to keep projects moving on track. Exchange project plan data with other applications, update project plans, create visual reports, and reuse project plan information.

MST595
Managing Projects
Participants will acquire the knowledge and skills to build, maintain, and control well-formed project plans. This course is intended for both novice and experienced project managers and schedulers responsible for scheduling, estimating, coordinating, controlling, budgeting, and staffing projects.

MST613
Getting a Grip on Windows Vista
Learn the new features of Microsoft Vista that improve workflow efficiency and business productivity. Understand and configure Windows Explorer, the new Sidebar, and Windows Aero. This course also introduces searching, managing files and folders, sharing and collaboration, optimizing Windows, enhancing security, and more.
Prerequisite(s): Some experience working in either a Windows XP or Windows 2000 desktop operating system environment or Getting a Grip on Computers.

MST619
Introduction to Dreamweaver
Now the industry standard, this versatile Web-publishing tool makes it easy to design Web sites that work with both major browsers. Learn how to master the interface to create Web sites in minutes. Added features of the class include using images as links, creating image maps, and building a frame-based site to assist the viewer in navigation.

MST620
Intermediate Dreamweaver
You have created basic Web pages, and now it's time to develop professional looking Web sites. Topics include working in code view, formatting with style sheets, creating an effective user-navigation interface, working with AP elements, automating tasks, creating forms, and authoring with SML-based data.
Prerequisite(s): Proficient with Windows based computers, comfortable with Internet Explorer, basic understanding of HTML and design, and completion of Introduction to Dreamweaver or permission of the instructor.

MST621
Introduction to Flash
Take this course and learn how to create flash-based movies that contain graphics, text, and animations that display correctly in almost any browser. Topics include creating and working with graphics, managing text, adding animations to a flash document, adding interactive buttons, working with movie clips, adding video to a movie, and publishing flash documents.
Prerequisite(s): Proficient with Windows based computers, comfortable with Internet Explorer, basic understanding of HTML and design, and media application such as Freehand and Fireworks.

MST622
Introduction to Illustrator
Adobe Illustrator is a sophisticated graphics program capable of creating complex and attractive illustrations and type effects. You might need to create logos, advertisements, and other illustrations in Illustrator. If you have little or no experience with Illustrator, it can be overwhelming to start creating complex illustrations. In this course, you'll start by drawing and manipulating simple shapes to create logos. You'll also combine text and graphics to create advertisements.
Prerequisite(s): Proficient with Windows based computers

MST623
Introduction to InDesign
You are starting to familiarize yourself with print layout and design using InDesign. If you would like to learn about the tools and features available to you in InDesign CS3, this course is for you. You'll work with tools that help you create eye-catching printed documents using InDesign. Topics include managing the InDesign environment, designing and enhancing documents, adding tables, and finalizing documents.
Prerequisite(s): Proficient with Windows based computers

MST628
Introduction to Adobe Captivate
Captivate enables computer monitor capture and recording, creates online scenario based training, and develops and deploys software simulations. This course is designed for beginners and intermediate Adobe Captivate 3.0 users who want to create software demonstrations and interactive simulations. You will learn how to record and modify projects, add quizzes, create question pools, and evaluate user performance. Additional topics include publishing and organizing projects.

MST659
Microsoft OneNote
OneNote has something for everyone. It is an idea processor, a notebook, and information organizer. It could even be called an "add-on pack for your brain." Easily save important information and organize scraps of information for quick and easy retieval. Collect research from the Web and add personal annotations. Create shape and embed content. Stay prepared for meetings, projects, and tasks. Many people find OneNote indispensible once they start using it, and we hope you do too!

MST660
Microsoft Outlook 2007 - Level II
If you have been using Microsoft Office Outlook 2007 as a communications tool then you know how to send an e-mail message, schedule appointments and meetings, and create contacts, tasks and notes. This course is the second in a series of three Microsoft Outlook 2007 courses. You will customize your Outlook environment, calendar, e-mail, folders, and track, share, assign and quickly locate various Outlook items.

MST661
Microsoft Outlook 2007 - Level III
This course is the third in a series of Microsoft Office Outlook 2007 courses. It builds on the e-mail and calendaring skills already obtained and will provide you with the skills needed to personalize e-mail, organize Outlook items, manage Outlook data files, share and link contacts, save and archive e-mail, create forms, and work offline and remotely.

MST882
Microsoft Windows Server 2003 Administration
Real-world examples, interactive activities, and hands-on projects reinforce key concepts in Microsoft Windows Server 2003 networking technology in this class designed for individuals who are interested in the technology but not necessarily interested in certification. Topics include Windows 2003 network administration, managing Windows Server 2003 hardware and software, administering active directory, managing group policy, administering file resources, managing printers, publishing, auditing, disk resources, administering Web resources in Windows Server 2003, administering TCP/IP, administering DNS, monitoring and troubleshooting Windows Server 2003, and administering remote access services.
Prerequisite(s): Some experience administering and supporting Windows network and directory services. Should have a background in basic computer concepts and operating systems.

MST933
Network Fundamentals 2008
Network Fundamentals provides a baseline level of knowledge of today's networking technologies. This course explores all aspects of networking standards, theory, and design. Along with a focus on networking operating systems, this course provides up-to-date coverage of Microsoft Windows XP and Server 2003 technologies, along with a review of some of the new technology found in Windows Vista. Other technologies covered include cabling, protocols, switching, wireless, security, broadband/DSL, and network management.
Prerequisite(s): Good working knowledge of computers, Windows XP, and basic computer terminology.

MST936
Implementing Microsoft Office SharePoint Server 2007
This course provides participants with the knowledge and skills required to implement Microsoft Office SharePoint Server 2007 successfully in their organization. The intended audience is business application administrators, Web administrators, and server administrators who are engaged in the planning, design, and selection of line-of-business (LOB) applications (including Office SharePoint Server) in conjuction with internal business customers. Their primary responsibility is the deployment, customization, management, and support of LOB applications. They routinely monitor application status and troubleshoot application problems.
Prerequisite(s): View full course outline for more information and prerequisites.

MST937
Windows 2008 Server Administration - A First Look
Microsoft's latest server operating system provides administrators with powerful and flexible tools to overcome today's networking challenges and manage complex server environments. This course is meant to examine this new system and its features while giving maximum learning potential to new Windows administrators, Window developers, and anyone else wanting to learn about Windows Server 2008. Topics included are introduction to Windows Server 2008, new licensing models, networking models, Windows Server 2008 roles, installation and upgrade, configuration tools and techniques, active directory, server management, file systems, data storage devices, network services, remote access (RAS), virtual private network (VPN), terminal services, DHCP, DNS, WINS, QoS, Internet information services (IIS), security, and virtual server capabilities.