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, and Access.

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.   

 

Basic Computer Skills for Business Application Certificate 

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.

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

  DPR-714: Introduction to Personal Computers  (or equivalent experience)  (formerlly DPR 332)

 DPR-753: Intro to Windows 7  or   DPR 436:  Working with Windows

 DPR-691: MS-Word

 DPR-354: MS-Word  

 DPR-674: MS-Excel  

 DPR-679: MS-Access

 DPR-662: PowerPoint 2010

 Additional classes as needed to fulfill the eight class certificate requirement, selected from among any of the "DPR" courses listed in this Schedule. Once a student has completed all of the requirements for either of these programs, he/she should call

301-322-0873 or e-mail itcerts@pgcc.edu for verification and to request a certificate.

 

 Entry-Level Administrative Assistant Certificate Program

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. 

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

DPR-778:      Applied Office Skills

DPR-691        MS-Word

DPR-354        MS-Word

DPR-674        MS-Excel

DPR 662        PowerPoint 2010

DPR 679        MS Access

 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. 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.)

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

76488     T       4/22-5/27                   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)

74188           TTH    4/22-5/1            6:30 -9:30 p.m.                            TBA

77289           TTH    6/10-6/19           6:30 - 9:30 p.m.                          TBA

77290           TTH     7/22-7/31          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)

77291  MWF  5/12-5/16  6:30 - 9:30 p.m.   CAT-139

77292  MWF  7/14-7/18  6:30 -9:30 p.m.    CAT-139

 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:  Students should be familiar with using personal computers and have used a mouse and keyboard. 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/85    6:30 - 9:30 p.m.     CAT-139

  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 Universal Serial Business (USB) compatible flash drive to store in-class work on, to all class sessions.

 3 sessions, $150* (includes a $95 lab fee)   

75779           MWF       4/7-4/9          6:30-9:30 p.m.                      Laurel College Center

77552            MWF       7/21-7/25     6:30 - 9:30 p.m.                    Laurel Colleg Center

 DPR-331 Windows   0.6 CEU 

This class addresses the features of Windows for use on personal computers. Prerequisite:  Students should be familiar with using personal computers and have used a mouse and keyboard . Students should also bring a USB Compatible flash drive to each class on which to store data. 

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

74180       S        4/5-4/5        9:00 a.m. - 4:00 p.m.                           CAT-105   

79422           S          6/7-6/7          9:00 a.m. - 4:00 p.m.                                 CAT-105

 DPR-691 Introduction to Microsoft Word 2010: Level 1  1.8 CEU's

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:  Students should be familiar with using personal computers and have used a mouse and keyboard. Text required: Microsoft Word 2010, Level 1, ISBN:  978-1-4246-1644-2  Students 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)

77390 T/TH     5/27-6/12                       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 Microsoft Word 2010 Level 1. Text required: Microsoft Word 2010, Level 2, ISBN:  978-1-4246-1534-6  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)  

77395        M/W      7/7-7/23                        6:30 - 9:30 p.m.                             CAT-105

 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 Microsoft Word 2010 Levels 1 and 2. Text required: Microsoft Word 2010, Level 3,  ISBN:  978-1-4246-1586-5  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)

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

 DPR-470 Microsoft-Excel: Level 1    1.2 CEUs   

See how to create, modify, print, and format worksheets; use templates, styles and AutoFormats, and find and replace data. Prerequisite: Students should be familiar with using personal computers and have used a mouse and keyboard.

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

77532       T/TH     8/12-8/21                        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: Students should be familiar with using personal computers and have used a mouse and keyboard . 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)

77406       M/W   5/19-6/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 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)    

77401                     M/W    6/16-7/2          6:30 - 9:30  P.M.               cat-105
 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.   Prerequisite:  Introduction to Microsoft Excel 2010 Level 2, and 3.  Text required:  Microsoft Excel 2010, Level 3  ISBN:  978-1-4246-1578-0  

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

74156      T/TH        4/1-4/24              6:30 - 9:30 p.m.                                           TBA

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: Students should be familiar with using personal computers and have used a mouse and keyboard75283Students should be familiar with using personal computers and have used a mouse and keyboard. 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)  

77398  S     6/21-6/28 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 Powerpoint 2010. Students should bring a USB compatible flash drive to store in-class work on, to all class sessions  Text: Powerpoint 2010: Level 2  ISBN:  978-1-4246-1572-8   

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

77403       S     7/12-7/19  9 am - 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)

74196            TTH       5/6-5/22         6:30 - 9:30 p.m.                 TBA   

 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.  Students should also bring a USB Compatible flash drive to each class on which to store data. Text: Microsoft Office Excel 2010: Level 1, Microsoft Office PowerPoint 2010: Level 1 and Microsoft Office Word 2010: Level 1 

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

 77356     S       7/19-8/23            9 a.m.-4 p.m.    CAT-139

  DPR-694 Career Track:  Microsoft 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 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.  Prerequisite:     Text required: Microsoft Office Word 2010: Level 1, 2, 3 (Element K. Press).

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

77355              M/W    6/2-7/9               6:30 -9:30 p.m.     CAT-139

 

 

 

Contact Information

Barbara McCreary

Phone:

301-322-0873

Email us:

mccreabc@pgcc.edu