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. 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
QuickBooks 2011 - Level I
Learn the powerful features of this easy-to-learn accounting software. QuickBooks is the No. 1 accounting software for individuals and businesses with little bookkeeping knowledge. Quickly learn to effectively create and track accounts, generate invoices, and process payments.
Prerequisite(s): Basic understanding of the Windows operating system and experience with Word processing.

MST369
Introduction to Personal Computing
Not comfortable using a PC? Learn, experiment, and ask questions without embarrassment in a small, relaxed classroom environment. 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 in this customized, dynamic, interactive class for new to intermediate computer users. Learn to create, save, and retrieve files; create and manage folders; and understand the proper design of directories. Gain control of the Windows environment by customizing the desktop, creating shortcuts, and essential system clean up.
Prerequisite(s): Introduction to Personal computers or permission of the instructor

MST419
Computer Camp for Seniors
This fun course introduces the computer for enjoyment purposes. Topics explored include games, e-mail, the Internet, Facebook, basic word processing for letter writing, and other practical applications.

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.

MST580
Basic Word 2007
Designed for those who want to gain basic knowledge of Word. Participants create, revise, and save documents for printing and future retrieval. Topics include formatting text and paragraphs, adding tables to documents, controlling a document's page setup and overall appearance, and proofing documents.

MST581
Intermediate Word 2007
Learn to create complex documents by adding components such as customized lists, tables, charts, and graphics. Create personalized efficiency tools. Topics include managing lists, customizing tables and charts, formatting with styles and themes, modifying pictures, creating customized graphic elements, controlling text flow, using templates to automate document creation, automating mail merges, and using macros.

MST582
Advanced Word 2007
Designed for those who want to gain the skills necessary to manage long documents, collaborate with others, and secure documents. Topics include using Word 2007 with other programs, managing document versions, adding reference marks and notes, making long documents easier to use, and securing documents.

MST583
Basic Excel 2007
Designed for those new to 2007. Learn how to navigate using Excel's ribbon. Create, edit, format, and print basic worksheets. Jump into formulas and functions. Craft the appearance of information with formatting and more.

MST584
Intermediate Excel 2007
Designed for those who desire to gain the skills necessary to create templates, sort and filter data, import/export data, analyze data, and work with Excel on the web. PivotTables and PivotCharts are also introduced.

MST585
Advanced Excel 2007
Designed for those desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import/export data. Participants should already have knowledge of Excel basics, including how to create, edit, format, and print worksheets including charts and sorted and filtered data.

MST586
Basic Access 2007
Designed for those who wish to learn the basic operations of Access to perform their day-to-day responsibilities and understand the advantages that using a relational database application can bring to their business. Topics include designing, creating, and managing new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database.

MST587
Intermediate Access 2007
Designed for those who have mastered the concepts covered in the Basic course and who would like to learn intermediate level operations of the program. Topics include maintaining data integrity, handling complex queries, forms, customized reports, and sharing data between Access and other applications.

MST588
Advanced Access 2007
Designed for the individual whose job responsibilities including working with related tables; creating advanced queries, forms, and reports; and writing macros to automate common tasks and perform general database maintenance.

MST589
Basic PowerPoint 2007
Presentations have moved far beyond flip charts and overhead projectors. Audiences not only expect that your presentations are in an electronic format, but they also demand your presentations be unique and sophisticated. Using PowerPoint, participants will capture an audience's attention and communicate ideas more effectively.

MST619
Introduction to Dreamweaver
This web-publishing tool makes it easy to design websites that work with both major browsers. Learn how to master the interface to create websites in minutes. Added features include using images as links, creating image maps, and building a frame-based site to assist the viewer in navigation.
Prerequisite(s): Microsoft Windows and Microsoft Word skills

MST620
Intermediate Dreamweaver
Topics in this course 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.

MST622
Illustrator CS5: Level I
This is a sophisticated graphics program capable of creating complex and attractive illustrations and type effects. Start by drawing and manipulating simple shapes to create logos. Combine text and graphics to create advertisements.
Prerequisite(s): Proficient with Windows based computers

MST623
InDesign CS5: Level I
Work with tools that help you create eye-catching printed documents. Topics include managing the environment, designing and enhancing documents, adding tables, and finalizing documents.
Prerequisite(s): Familiar with Windows-based computers

MST685
Getting a Grip on Your MAC
Computers are used in almost all fields of work. To work with a computer, it is essential to understand the computer environment and the traits of its various applications. In this course, you'll explore a number of interface elements and applications that make Mac Leopard a significant and user-friendly operating system. Specifically, you will explore Mac OS X Leopard's environment and learn to use its various applications such as Safari, iChat, and iLife. You will also use the OS to manage your files and folders, save information, and manage storage space.
Prerequisite(s): Familiarity with Mac's

MST696
Intro to Crystal Reports
This course is designed for persons who need output from a database. In some cases, database programs have limited reporting tools and/or such tools may not be accessible. Organizations use reporting tools to access data sources and generate customized reports. Crystal Reports enhances report building and report processing techniques with a wide range of features that add value to your presentation or reports. In this course, you will see the creation of a basic report by connecting to a database and modifying its presentation. This course is information-packed, complete with demonstrations and discussion.
Prerequisite(s): Familiarity with computers, database functions, and Windows operating system

MST699
Microsoft Windows 7: Level I
Explore and identify the different components in the Windows 7 interface, customize the desktop, manage files and folders, use the common tools and programs available, and browse the Internet.

MST941
Network Administration for the Office Manager
Designed for the office manager who is wearing the part-time network administrator hat, learn the fundamental principles behind the use of a client server network, the components and use of devices on a network, software licensing strategies, basic Windows server support tasks, and recommended maintenance tasks.

MST950
Mastering Windows 7
Gain skills to help you leverage and manage the advanced functionality in Windows 7. Get familiar with the advanced customization techniques and work with built-in applications and programs. Work with Internet Explorer 8, manage network communications and data, and enhance system performance.

MST951
Crossing Over to Windows 7 from Windows XP
Use the new features in Windows 7 to streamline your workflow efficiency and business productivity.

MST961
Intermediate Word 2010
Designed for those who are able to create and modify standard business documents in Word 2010, but need to know how to create or modify complex business documents and customize Word efficiency tools. Topics include managing lists, customizing tables and charts, creating customized formats with styles and themes, modifying pictures, creating customized graphic elements, inserting content using quick parts, controlling text flow, using templates, and automating mail merge.

MST962
Basic Access 2010
Learn how to leverage the features of Access to increase effectiveness and enhance productivity. Gain the fundamental knowledge and techniques needed to use more complex Access features such as maintaining databases and using programming techniques. Topics include building the structure of a database, managing data in a table, querying a database, design forms, and generating reports.

MST963
Basic Excel 2010
Designed for those new to Excel 2010. Participants gain the skills necessary to create basic worksheets, perform calculations, modify and format worksheets, and manage and print workbooks.

MST964
Basic PowerPoint 2010
Learn how to work with PowerPoint 2010 to create presentations. Topics include creating a basic presentation; formatting text on slides; inserting image shapes, tables, and charts; and prepare to deliver the presentation.

MST965
Basic Word 2010
Designed for those who wish to learn the basic operations of Word 2010. Provides the fundamental knowledge and techniques needed to advance to using more complex Word features. Topics include editing text, modifying the appearance of text, inserting special characters and graphical objects, organizing data in tables, proofing documents, controlling the appearance of pages, and printing documents.

MST966
Intermediate Access 2010
Designed for those who wish to learn intermediate level operations of the Access program. Participants improve and customize tables, queries, forms, and reports and share Access data with other applications. Topics include controlling data entry, joining tables, creating flexible queries, improving forms, customizing reports, and sharing data across applications.

MST967
Intermediate Excel 2010
Designed for those desiring to gain advanced skill sets necessary for calculating data using functions and formulas, sorting and filtering data, using PivotTables and PivotCharts for analyzing data, and customizing workbooks.

MST969
Files, Folders & Shares in Windows Server 2008
If you are having difficulty understanding the new functions in the File Server Role, this course is for you. Designed as a "lunch and learn" workshop, this session will engage in topics and lively discussions about this dynamic role in Microsoft's latest server offering. Please bring your lunch.

MST970
Installing & Upgrading to Windows Server 2008 R2
Delve into the changes since Windows Server 2000 and 2003. Learn about installation requirements and 64-bit support and issues. Gain hands-on installation instructions and walk through the entire installation process.

MST977
Advanced Word 2010
Participants learn to manage lengthy documents, collaborate with others, and secure documents. Topics include using Word 2010 with other programs, managing document versions, adding reference marks and notes, and creating forms.
Prerequisite(s): Microsoft Office Word 2010: Basic, Intermediate

MST978
Advanced Excel 2010
Participants delve into some of the more specialized and advanced capabilities of Excel. Topics include automating common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.

MST981
Security Concepts & Best Practices (High-Level Approach)
Explore security in-depth and the best practices that are involved in this approach. Topics discussed include firewalls, intrusion detection/ prevention systems, web and e-mail security, employee education, and much more. This class is lecture based.

MST982
Security for Home Computers
Focus on the skills required to keep your personal computers up to date and protected from malware. Emphasis is on the Windows 7 operating system.

MST983
QuickBooks 2011 - Level II
Learn the advanced features of this widely-used accounting software. Topics include memorized transactions, customizing forms, creating reports and graphs, tracking and paying sales tax, and preparing payroll.

© 1995 Pennsylvania College of Technology

One College Avenue
Williamsport, PA 17701

570-326-3761
800-367-9222