MS-Office Application

Comp and Info Tech 1
The college uses the Microsoft Office Suite programs to prepare students for entry level jobs that require them to quickly produce reports, memos, presentations, databases, and spreadsheets. Microsoft Office is a set of interrelated desktop applications that is used by most businesses. Microsoft Word, Excel, Access, Outlook, and PowerPoint are the most commonly used software programs. Research indicates that individuals with basic skills in the Microsoft Office Suite have increased competence, productivity, and credibility with their employers, co-workers, and clients.

Are you looking for Career Advancement?

Advance your career by passing the Microsoft Office Specialist Exams.

 Prince George's Community College offers classes in Microsoft Word 2010, Microsoft Excel, 2010, PowerPoint 2010, and Access 2010.

Prince George's Community College offers classes in Microsoft Word 2013, Microsoft Excel, 2013, PowerPoint 2013, and Access 2013.

Where do I take the MOS exams and what do I need to bring with me? 

Students are free to take these exams at any Certiport testing center (see www.certiport.com). The college is a private Certiport testing center which means that we only test PGCC students, faculty and staff. Contact Barbara McCreary, bmccreary@pgcc.edu for information about location and hours. You must keep track of your Certiport username and password because you will need to use them when you come in to take the exams. Proctors are unable to look up this information, so be sure you have practiced signing on to the Certiport site and can do so successfully before you come in to test. You also need to present a photo id, preferably a PGCC ID. Other testing centers may have additional requirements. Check with them before you go to take the exam, probably by appointment.     

 Microsoft Office Suite

This eight course Basic Computer Skills for Business Applications certificate program is designed to recognize a student's achievement in the use of a personal computer for general business applications using the Microsoft Office Suite, including applications for word processing, spreadsheet, and data management.

 This Program is available for Microsoft Office Suites 2010 and 2013.**New For Fall 2014

Requirements for the continuing education certificate include successful completion of the following courses. (Note: only one MS Word course is required--not both).

Introduction to Personal Computers (or equivalent experience)

Intro to Windows 7 or DPR 436 Working With Windows

MS-Word2010 or 2013

MS-Excel2010 or 2013

MS-Access2010 or 2013

PowerPoint 2010or 2013

*Additional classes are needed to fulfull the right class certificate requirements, selected from among any of the "DPR" courses listed in the course schedule.

Entry-Level Administrative Assistant

This 5 course Entry-Level Administrative Assistant certificate program is designed to recognize a student's achievement in the area of Microsoft office, office procedures and practices. You will be learning how to provide support by conducting research, preparing statistical reports, handling information requests, and performing clerical functions such as preparing correspondence, receiving visitors, arranging conference calls, and scheduling meetings.

 This program is available for Microsoft Office Suites 2010 and 2013.**New for Fall 2014

Requirements for the continuing education certificate include successful completion of the following courses. (Note: only one MS Word course is required-not both).

Applied Office Skills

MS-Word2010 or 2013

MS-Word2010 or 2013

MS-Excel2010 or 2013

PowerPoint 2010or 2013

MS Access2010 or 2013

 

OFC-314 Introduction to Keyboarding 1.8 CEUs

Keyboarding is needed for computer familiarity. Finger placement, basic computer parts, typing speed and accuracy are taught. This hands-on class prepares you for the skills needed for other computer training.

On the last night of class students will complete a diagnostic test that determines what their NWAM (Net Words A Minute) which will determine their overall proficiency.

Text book required: College Keyboarding Lessons 1-25 (Package) Pro 9 CD 18th Edition, Vanhuss Forde Wodo Text/software is available at Howard Community College or Prince George's Community College Bookstore (not included in course cost.) 978-0-321-74133-2

6 sessions, $144* (includes a $80 lab fee)

81065 T 9/16-10/21 6:30-9:30 p.m. Laurel College Center

 

DPR-714 Introduction to Personal Computers 0.6 CE (formally DPR 332)

This course is essential for those without any computer experience. Class includes hands-on computer operation and is a must for all beginning users. No prerequisites are required.

Text: Introduction to Personal Computers Using Windows, ISBN:978-1-4246-1389-2 Students should also bring a Universal Serial Business (USB)compatible flash drive to each class on which to store data.

4 sessions, $195.00*(includes a $95 lab fee)

77290 MW 7/22-7/31 6:30-9:30 p.m. CAT-139

82619 TTH 9/9-9/18 6:30 - 9:30 p.m. TBA

82620 TTH 10/14-10/23 6:30 - 9:30 p.m. TBA

******DPR-778 Applied Office Skills****** 0.9 CEUNEW COURSE

This course is essential to all administrative assistants and secretaries who are some of the most in-demand workers in the business world today. Learn how to provide support by conducting research, preparing statistical reports, handling information requests, and performing clerical functions such as preparing correspondence, receiving visitors, arranging conference calls, and scheduling meetings.

3 sessions, $140* (includes a $20 lab fee)

83189 MW 9/29-10/6 6:30 - 9:30 p.m. TBA

83190 MWF 11/10-11/14 6:30 - 9:30 p.m. TBA

DPR-753 Introduction to Windows 7 0.9 CEUs

This hand-on class introduces students to the Windows 7 features that let them personalize their screens. Students will also be taught how they can use their computer's desktop to type and edit text so they can easily create e-mails or documents, save and organize their work. Students will also be taught the tips that will help them to search the Web like an expert using the Internet Explorer web browser that comes with Windows 7, as well as how to use flash drives, CDs, and DVDs, and how to protect the system against viruses and other threats. Students should bring a Universal Serial Business (USB) compatible flash drive to store in-class work on, to all class sessions. Prerequisite: DPR-332 or DPR 714: Introduction to Personal Computers. Text: Microsoft Windows 7: Level 1 ISBN: 978-1-4246-1283-3

 

3 sessions, $165* (includes a $55 lab fee)

77354 MWF 8/4-8/8 6:30 - 9:30 p.m. CAT-139

82598 MWF 12/1-12/5 6:30 - 9:30 p.m. TBA

DPR-331 Windows 0.6 CEU

 

This class addresses the features of Windows for use on personal computers. Prerequisite: DPR-332: Introduction to Personal Computers. Students should also bring a USB Compatible flash drive to each class on which to store data. Text required. 1 session, $110* (includes a $50 lab fee)

82593 S 9/13-9/13 9:00 a.m. - 4:00 p.m. TBA

DPR-436 Working with Windows 7 0.9 CEU

 

See the basic concepts and features of this operating system, including the desktop, online Help, My Computer, Windows Explorer, Internet Explorer, accessories, and Web integration features. See
how to gain the skills needed to create a document, organize files, work with Windows Messenger, create an efficient work environment, work with media, clean up system, and find information on the Internet. Students should bring a USB compatible flash drive to store in-class work on, to all class sessions. 3 sessions,$150* (includes a $55 lab fee)

81061 MWF 9/22-9/26 6:30 - 9:30 p.m. Laurel College Center

DPR-691 Introduction to Microsoft Word 2010: Level 1 1.8 CEUs

 

This continuing education course is one of a series of courses designed to provide instruction on using the basic features of Microsoft Word 2010. Topics include how to create, edit, format, and print a document using the basic features of Word. Prerequisite: Introduction to Windows. Text required: Microsoft Word 2010, Level 1, , ISBN:978-1-4246-1644-2Students should bring a Universal Serial Bus (USB) compatible flash drive to store in-class work on, to all classes.

6 sessions, $240*(includes a $90 lab fee)

82591TTh 9/2-9/18 6:30-9:30 p.m. CAT-105

 

DPR-692 Intermediate Microsoft Word 2010 1.8 CEUs

This continuing education course is one of a series of courses designed to provide instruction on using the more advanced features of Microsoft Word 2010. Topics include how to manage lists, customize tables and charts, create customized formats with styles and themes, create customized graphics, and more. Prerequisites: Introduction to Windows. Introduction to Microsoft Word 2010 Level 1. Text required: Microsoft Word 2010, Level 2, ISBN:978-1-4246-1534-6Students should bring a USB compatible flash drive to store in-class work on, to all classes.

6 sessions, $240*(includes a $90 lab fee)

82584 T 10/14-11/25 6:30 - 9:30 p.m. CAT-139

 

DPR-693 Advanced Microsoft Word 2010: Level 3 1.8 CEUs

This continuing education course is one of a series of courses designed to provide instruction on using the most advanced features of Microsoft Word 2010. Topics include how to use Word with other programs such as Microsoft Excel and Powerpoint, adding reference marks and notes, creating forms, and more. Prerequisites: Introduction to Windows. Introduction to Microsoft Word 2010 Levels 1 and 2. Text required: Microsoft Word 2010, Level 3, ISBN:978-1-4246-1586-5Students should bring a USB compatible flash drive to store in-class work on, to all classes.

6 sessions, $240*(includes a $90 lab fee)

77408 MW 7/28-8/13 6:30 - 9:30 p.m. CAT 105

DPR-470 Microsoft-Excel: Level 11.2 CEUs

See how to create, modify, print, and format worksheets; use templates, styles and AutoFormats, and find and replace data. Prerequisite: Windows or equivalent Personal Computers (PC) skills.

 

4 sessions, $215* (includes a $80 lab fee)

81060 TTH 10/14-10/23 6:30 - 9:30 p.m. Laurel College Center

 

DPR-674 Introduction to Microsoft Excel 2010: Level 1 1.8 CEs

 

This course introduces the basic features of Excel 2010. Students will create worksheets and enter and edit text, values, formulas and pictures. Understand basic formatting techniques and functions. Learn how to use the help system and navigate worksheets and workbooks. Prerequisite: Introduction to Windows. Text required: Microsoft Excel 2010, Level 1, ISBN:978-1-4246-1630-5 Students should bring a Universal Serial Bus (USB) compatible flash drive to store in-class work on, to all class sessions.

6 sessions, $240*(includes a $90 lab fee)

 

82592 TTH 9/23-10/9 6:30-9:30 p.m. CAT-105

 

DPR-711 Intermediate Microsoft Excel 2010: Level 2 1.8 CEUs

This continuing education course is one of a series of courses designed to provide instruction on using the more advanced features of Microsoft Excel 2010. Topics include how to calculate data with advanced formulas, organizing worksheet and table data, presenting data using charts, analyzing data using pivot tables, slicers, and pivot charts, and more. Prerequisites: Introduction to Windows and Introduction to Microsoft Excel 2010 Level 1. Text required: Microsoft Excel 2010, Level 2, ISBN:978-1-4246-1546-9 Students should bring a USB compatible flash drive to store in-class work on, to all classes.

6 sessions, $240*(includes a $90 lab fee) 

82589 MW 11/24-12/15 6:30 - 9:30 p.m. CAT-139

 

DPR-681 Advanced Excel 2010: Level 3 1.8 CEUs

 

This course is a continuation of Excel 2010. Topics creating and editing in macros protecting files, auditing worksheets, importing and exporting data and more. It covers the more advanced features of Excel 2010. Text required:Microsoft Excel 2010, Level 3ISBN:978-1-4246-1578-0

 

6 sessions, $240*(includes a $90 lab fee)

77410 T/TH 7/15-7/31 6:30 - 9:30 p.m. CAT-139

 

DPR-662 Introduction to Powerpoint 2010 0.6 CEU

 

This class covers the introductory functions of the presentation software, MS-Powerpoint. Text: Powerpoint 2010: Level 1, ISBN: 978-1-4246-1642-8 Prerequisite: Introduction to Windows. Students should bring a USB compatible flash drive to store in-class work on to all class sessions.

 

2 session, $110* (includes a $50 lab fee)

 82586 S 9/13-9/20 9 a.m. - 12 p.m. CAT-105

DPR-663 Advanced Powerpoint 2010 0.6 CEU

Continue your studies of the presentation software, Microsoft PowerPoint.. Prerequisite: Introduction to Windows. Students should bring a USB compatible flash drive to store in-class work on, to all class sessions. Text: Powerpoint 2010: Level 2ISBN:978-1-4246-1572-8

2 session, $110* (includes a $50 lab fee)

82590 S 10/11-10/18 9 a.m. - 12 p.m. CAT-105

 

DPR-679 Introduction to Access 20101.8 CEUs

 

This course introduces the Microsoft-Access 2010 database program. The program enables one to design and create databases that allow for presentation, analyzation and sharing of data. Students should bring a USB compatible flash drive to store in-class work on, to all class sessions. Text required: Introduction to Microsoft Access 2010 Level 1. ISBN:978-1-4246-1636-7

6 sessions, $240*(includes a $90 lab fee)

82563 MW 11/3-11/19 6:30 - 9:30 p.m. CAT-105

DPR-603 Introduction to Microsoft Office 2010 3.6 CEUs

 

Microsoft Office 2010. This course is designed to provide students with the fundamentals of the new office interface and functionality of Microsoft Office 2010. Topics include using the navigation tools in Word, PowerPoint and Excel; creating and sharing documents, creating presentations, and preparing charts. Prerequisite: OFC-314 Introduction to Keyboarding or OFC-386 Keyboarding for Business Documents and Reports. Text: Microsoft Office Excel 2010: Level 1, Microsoft Office PowerPoint 2010: Level 1 and Microsoft Office Word 2010: Level 1 Students should also bring a USB Compatible flash drive to each class on which to store data.

6 sessions, $450* (includes a $150 lab fee)

82621 S 9/5-10/11 9 a.m. - 4 p.m. CAT-139

DPR-694 Career Track: MS-Word 2010 3.6 CEUs

This course provides instruction on using Microsoft Word 2010 basic, intermediate, and advanced features. Topics include character and paragraph formatting, editing text, creating numbered and bulleted lists, using various proofing tools, creating tables, working with page layout and document management. Intermediate topics include working with sections, columns and tables, importing data, using styles and auto text and inserting graphics into documents. Advanced topics include mail merging letters and labels, creating forms, working with large documents, this includes master documents and table of contents, collaborating documents using track changes and automating actions with macros. Prerequisite: Students should be familiar with using personal computers and have used a mouse and keyboard. Text: Microsoft Office Word 2010: Level 1, 2, 3 (Element K. Press)

12 sessions, $450* (includes a $150 lab fee)

 

DPR-604 Introduction to the Internet and E-mail Basics 1.2 CEUs

 

This course provides students with an overview of the basic features of the Internet's world wide web (www) and e-mail usage. Topics include up-to-date online Internet and e-mail tools and technologies, how to share information using different e-mail systems, Internet newsgroups, interactive collaborations, blogs, wikis, social networking, e-mail etiquette, e-mail services, and more.

4 sessions, $160* (includes a $60 lab fee)

82594 F 10/3-10/24 6 - 9 p.m. TBA

 

DPR-720 Introduction to Microsoft Project 2010: Level 1 1.8 CEUs1.8 CEUs

This continuing education course is designed to teach the basic features of Microsoft Project 2010. Topics include how to use the software to create a project plan containing tasks; organize these tasks in a work breakdown structure containing task relationships; create, assign, and manage resources; work with views and tables; finalize a task plan, and more. Prerequisite: Introduction to Windows. Students should bring a Universal Serial Business (USB) compatible flash drive to store in-class work on, to all class sessions. Text required Introduction to Microsoft and Project 2010: Level 1. ISBN: 978-1-4246-1550-6

6 sessions $230*(includes a $85 lab fee)

82611 TTH 9/9-9/25 6:30 -9:30 p.m. CAT-139

 

DPR-751 Intermediate Microsoft Project 2010 Level 2

 

Students will be taught how to use the more advanced features of Microsoft Project 2010 to manage and customize project plans during the implementation stage of a project. Topics include tracking a project from start to finish, evaluating individual tasks and assigned schedules, analyzing project progress, analyzing critical paths and costs, and overall project success and more.

6 sessions, $230*(includes a $85 leb fee)

82612 MW 10/6-10/22 6:30 -9:30 p.m. CAT-139

DPR-772 Introduction to Microsoft Outlook 2010 1.5 CEUs

 

This course is designed to provide training to students on using the 2010 version of Microsoft Outlook. Topics include: creating folders, archiving messages, organizing contacts, utilizing Outlook calendar and alert features, and Outlook customizations. Upon completion of this course, the students will be able to create folders within Outlook to organize messages, organize contacts within Outlook, customize Outlook to the individual's specifications, and utilize Outlook calendars and alerts to organize meetings and appointments.

5 sessions, $195* (includes a $95 lab fee)

82614 M 10/13-11/17 6-9:15 p.m. TBA

 

DPR-774 Introduction to Laptops and Peripherals 1.8 CEUs

 

This course will go into the pros & cons of using a laptop computer and help students decide what kind of peripherals they may want to add to their computer system. Topics include laptop features, determining the best laptop for their needs, and techniques in using computer peripherals.

 

6 sessions, $150* (includes a $30 lab fee)

82596 S 11/1-12/13 9:00 a.m. - 12:00 p.m. TBA

New for 2014

Microsoft Office Suite classes for word, excel, access and PowerPoint 2013 have been developed beginning the Fall of 2014. For more information, please contact the IT office at 301-322-0873.

 

DPR-786 Introduction to Microsoft Office 2013 3.6 CEUs NEW

 

This course is designed to provide students with the fundamentals of the new office interface and functionality of Microsoft Office 2013. Topics include: using the navigation tools in Word, PowerPoint, and Excel; creating and sharing documents;
creating presentations; and preparing charts. Students should bring a USB compatible flash drive to each class. Text: Microsoft Excel 2013: Level 1, Microsoft Office PowerPoint 2013: Level 1 and Microsoft Office Word 2013: Level 1.6 sessions,
$450* (includes a $150 lab fee)

80070 S 11/1-12/13 9 a.m.- 4 p.m. Largo

 

DPR-790 Introduction to Microsoft Word 2013: Level 1 1.8 CEUs NEW

 

This continuing education course is one of a series of courses designed to provide instruction on using the basic features of Microsoft Word 2013. Topics include: how to create, edit, format, and print a document using the basic features of Word.
Students should bring a USB compatible flash drive to each class. Text required: Microsoft Word 2013, Level 1, ISBN: 0910-24SPE. 6 sessions, $240*
(includes a $90 lab fee)

80074 MW 9/8-9/24 6:30-9:30 p.m. Largo

 

DPR-791 Introduction to Microsoft Word 2013: Level 2 1.8 CEUs NEW

 

This continuing education course is one of a series of courses designed to provide instruction on using the more advanced features of Microsoft Word 2013. Topics include: how to manage lists,customize tables and charts, create customized formats with styles
and themes, create customized graphics, and more. Prerequisite: Introduction to Micrososft Word 2013 Level 1. Students should bring a USB compatible flash drive to each class. Text required: Microsoft Word 2013, Level 2, ISBN: 0910-25SPE. 6 sessions,
$240* (includes a $90 lab fee)

80075 MW 11/17-12/3 6:30-9:30 p.m. Largo

 

DPR-782 Introduction to Microsoft Excel 2013: Level 1 1.8 CEUs NEW

 

This course introduces the basic features of Excel 2013. Students will create worksheets and enter and edit text, values, formulas, and pictures. Understand basic formatting techniques and functions. Learn how to use the help system and navigate worksheets
and workbooks. Students should bring a USB compatible flash drive to each class. Text required: Microsoft Excel 2013, Level 1, ISBN: 091014-SPE. 6 sessions, $240* (includes a $90 lab fee)

80065 MW 10/6-10/22 6:30-9:30 p.m. Largo

 

DPR-783 Intermediate Microsoft Excel 2013: Level 2 1.8 CEUs NEW

 

This continuing education course is one of a series of courses designed to provide instruction on using the more advanced features of Microsoft Excel 2013. Topics include how to calculate data with advanced formulas, organizing worksheet and table data, presenting data using charts, analyzing data using pivot tables, slicers, and pivot charts, and more. Prerequisites: Introduction to Microsoft Excel 2013, Level 1. Students should bring a USB compatible flash drive to each class. Text required: MicrosoftExcel 2013, ISBN: 91015-SPE. 6 sessions, $240*(includes a $90 lab fee)

80066 TTh 11/4-11/20 6:30-9:30 p.m. Largo

 

DPR-785 Introduction to Microsoft Access 2013 1.8 CEUs NEW

 

This course introduces the Microsoft Access 2013 database program. The program enables one to design and create databases that allow for presentation, analysis, and sharing of data. Students should bring a USB compatible flash drive to each class.
Text required: Microsoft Access 2013, Level 1, ISBN: 091004-SPE. 6 sessions, $240* (includes a $90 lab fee)

80069 MW 10/27-11/12 6:30-9:30 p.m. Largo

 

DPR-787 Introduction to PowerPoint 2013 0.6 CEU NEW

 

This class covers the introductory functions of the presentation software, MS PowerPoint. Students should bring a USB compatible flash drive to each class. Text required: Microsoft PowerPoint 2013, Level 1, ISBN: 09-1033SPE. 2 sessions, $110* (includes a $50 lab fee)

80071 S 10/18-10/25 9 a.m.-12p.m. Largo

 

DPR-784 Advanced PowerPoint 2013 0.6 CEU NEW

 

Continue your studies of the presentation software, Microsoft PowerPoint. Delete ---Prerequisite: Introduction to PowerPoint 2013. Students should bring a USB compatible flash drive to each class. Text required: Microsoft PowerPoint 2013, Level2, ISBN: 091034-SPE. 2 sessions, $110* (includes a $50 lab fee)

80068 TTh 10/21-10/23 6:30-9:30 p.m. Largo

 

DPR-788 Introduction to Microsoft Project 2013: Level 1 1.8 CEUs NEW

 

This continuing education course is designed to teach the basic features of Microsoft Project 2013. Topics include: how to use the software to create a project plan containing tasks; organize these tasks in a work breakdown structure containing task relationships; create, assign, and manage resources; work with views and tables; finalize a task plan; and more. Students should bring a USB compatible flash drive to each class. Text required: Microsoft Project 2013, Level 1, ISB-091043SPE. 6 sessions, $230* (includes a $85 lab fee)

80072 MW 11/3-11/19 6:30-9:30 p.m. Largo

 

DPR-789 Introduction to Microsoft Project 2013: Level 2 1.8 CEUs NEW

Students will be taught how to use the more advanced features of Microsoft Project 2013 to manage and customize project plans during the implementation stage of a project. Topics include: tracking a project from start to finish; evaluating individual tasks and
assigned schedules; analyzing project progress; analyzing critical paths and costs and overall project success; and more. Prerequisite: DPR-788 Introduction to Microsoft Project 2013. Text required: Microsoft Project 2013, Level 1, ISBN: 09-1044-SPE.
6 sessions, $230* (includes a $85 lab fee) Spelling fix

80073 TTh 11/25-12/16 6:30-9:30 p.m. Largo