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)

 6080 T 1/20-2/24 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)

87405 MW 2/2-2/11       6:30 - 9:30 p.m. TBA

87407 MW 4/6-4/15       6:30 - 9:30 p.m. TBA

DPR-778 Applied Office Skills 0.9 CEU

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)

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

87381  MWF 3/9-3/13      6:30 - 9:30 p.m. TBA

87382 MWF 5/4-5/8         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)

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

87449 W       4/8-4/22   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)

87446   S   2/7-2/7          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)

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)

87170     TTh 1/20-2/5 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)

87123 MW 3/16-3/25     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)

87461 TTH 2/10-2/26 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) 

87427 TTH 3/3-3/19    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)

87425 S 2/21-2/28     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)

87428 S 3/14-3/21 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)

87423TTH 4/28-5/14 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)

87442 S 1/31-3/7     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)

87447 F 3/6-3/27     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)

87450 TTH 2/20-2/26 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)

87451 TTH 3/10-3/26   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)

87408 M 4/6-5/4        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)

3/7-4/1887448 S  9:00 a.m. - 12:00 p.m. TBA

New for 2014

2013  Microsoft Office Suite classes for word, excel, access and PowerPoint     2013 

 

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 16 sessions, $240*
(includes a $90 lab fee)

86087 MW 1/26-2/11 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 6 sessions,
$240* (includes a $90 lab fee)

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

87435 MW 3/16-4/8    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. 6 sessions, $240* (includes a $90 lab fee)

87444 MW  2/28-3/11  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  Level 2. 6 sessions, $240*(includes a $90 lab fee)

87440 TTH    3/23-4/15   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 16 sessions, $240* (includes a $90 lab fee)

87433 MW  4/13-4/29    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. 2 sessions, $110* (includes a $50 lab fee)

87438 S 3/21-3/28      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 

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

87441 S    4/11-4/18      9:00- 12:00 p.m. 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 16 sessions, $230* (includes a $85 lab fee)

87452 MW 4/7-4/23     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) 

87453 TTh 5/5-5/21        6:30-9:30 p.m. Largo