PC Skills Specialist


450 HOURS
DIPLOMA PROGRAM
DAY CLASS

This comprehensive program is designed for students with basic keyboarding knowledge who wish to develop computer skills in a short period of time.

This Hunter program includes training in the latest word processing, spreadsheet, database, and presentation graphics software. Students completing this program are well equipped to meet the challenges of today’s automated office.

Job Titles for Graduates of the PC Skills Program

The following list includes, but is not limited to, many of the most common job titles for which this program prepares students and requires the use of the skills learned as a predominant component of the job.

Administrative Assistant General Help Order Processing Specialist
Assistant Front Office Manager Human Resources Assistant Paralegal Assistant
Bursar Office Assistant HR Coordinator Personal Assistant
Business Assistant Import Assistant Processing Clerk
Claims Processor Insurance Claims Examiner Personnel Coordinator
Clerical Assistant Intake Coordinator Purchasing Agent
Clerical Bookkeeper Inventory Clerk Purchasing Assistant
Clerk Invoice Processor Qualtiy Assurance Assistant
Collections Key Operator Quality Control Assistant
Customer Relations Rep Legal Assistant Quality Control Manager
Customer Service Rep Legal Billing Clerk Receptionist
Data Entry Specialist Legal Secretary Records Clerk
Data Management Clerk Mail Clerk Register Clerk
Data Processor Manager Research Assistant
Database Administrator Manager Assistant Secretary
Entry Level (Various Titles) Marketing Assistant Senior Secretary
Executive Assistant Marketing Rep Shipping and Receiving Clerk
Executive Secretary Office Assistant Subrogation Specialist
File Clerk Office Clerk Supervisor
File Mail Clerk Office Coordinator Telemarketing Agent
Front Desk Clerk Office Manager Transcriber
Gal/Guy Friday Office Manager Operator Typist
General Clerk Office Supervisor Word Processor
General Clerk Jr. Office Support Assistant  

Courses Offered

A101: Accounting I – 60 hours

During Accounting I, students will study the fundamental principles of general ledger accounting including journalizing, posting, worksheets, financial statements and petty cash. Emphasis will be placed on developing the ability to analyze transactions.

Prerequisite: None

MO1: Microsoft Word Basics – 30 hours

Microsoft Word Basics will provide students with the basics of Microsoft Word for Windows, as well as review business letter formatting. During this course, students will learn the use of tabs, ribbons and galleries, document orientation, correcting, saving, printing, and closing documents, moving and copying text, use of AutoCorrect, AutoFormat, spell and grammar check, use of date & time feature, undo, redo, use of the Thesaurus, use of find and replace commands, and all aspects of formatting text.

Prerequisite: None

MO2: Intermediate Microsoft Word – 30 hours

During Intermediate Microsoft Word, students will continue to master the functions of Microsoft Word. Topics covered in this course will include, but will not be limited to: setting margins, text alignment, indenting, line spacing, vertical alignment, setting tabs, bullets and numbering, sorting text, using desktop publishing to create columns, add borders and shading, inserting clip art, use of the drawing toolbar and creating diagrams and charts.

Prerequisite: MO1

KB3: Advanced Formatting Procedures – 30 hours

Advanced Formatting Procedures introduces students to more advanced keyboarding concepts, drills and production work. Some of the things students will learn during this course are keyboarding letter and memo mastery documents, some of which contain special
features and may be multiple pages in length; left-bound business reports, some of which are edited with proofreaders’ marks and contain multiple pages, references, a title page, a table of contents, and experience using Word templates to create memos and fax cover
sheets. At the conclusion of the course, the student is expected to achieve a keyboarding speed of 45 wpm with five or less errors on five minute timed writings.

Prerequisite: KB2A

EX1: Excel for Windows – 30 hours

Excel for Windows is designed to give students an understanding of the spreadsheet program, Excel for Windows. During this course, the topics covered include, but are not limited to: parts of a worksheet, selecting cells, entering and editing data, searching data, saving and
printing a worksheet, changing the appearance of a worksheet, adding color, borders, cell formats, using the fill command, inserting rows and columns, formula structure, relative, absolute, and mixed cell references, introduction to formulas using the AutoSum button.

Prerequisite: (None)

OM101: Office Machines – Electronic Calculator – 30 hours

During this course, students will learn the proper use and functions of an electronic calculator, particularly as applied to solving practical business problems. This course also includes training in the use of proper fingering, as well as mastering the numeric processes. Students will also apply their knowledge by doing simulations.

Prerequisite: None

QB1: Computerized Accounting Using QuickBooks – 30 hours

QuickBooks is a popular software program commonly used to manage both personal finances and small businesses with the accounting and business management tools they need to keep their finances organized. During this course, students will gain the knowledge and practical understanding of the revenue and expenses features of QuickBooks.

Prerequisite: A101 or BK

MO3: Advanced Microsoft Word – 30 hours

During Advanced Microsoft Word, students will continue to master the functions of Microsoft Word. Topics covered in this course will include, but will not be limited to: inserting page breaks, working with multiple documents, inserting headers and footers, creating footnotes and endnotes, using the Research Tool, document sections, applying styles, inserting and formatting tables, using templates and wizards, using the Screenshot feature, creating envelopes and labels, and the use of mail merge.

Prerequisite: MO1

ADM1: Access Database Management – 30 hours

During this course, students will learn the popular database program, Access, which is a component of the Microsoft Office package. The topics covered will include: creating a database, editing and printing, searching, filtering and sorting, querying a database, and creating forms and reports.

Prerequisite: None

PPG1: PowerPoint Presentation Graphics – 30 hours

PowerPoint is a presentation graphics program that will let students create and save visual aides to support a speech or presentation. During this course, the topics covered will include: creating and saving a presentation, working with text and objects, creating charts and graphs, and working with animation and media to enhance slide shows.

Prerequisite: (None)

EX2: Advanced Excel for Windows – 30 hours

Advanced Excel for Windows will cover advanced topics such as: function formulas, sorting and filtering data, using templates, using multiple worksheets, creating three dimensional references, creating and editing charts.

Prerequisite: EX1

MO4: Microsoft Office – 30 hours

During this course, students will work on an array of interesting and challenging projects designed to reinforce Microsoft Office skills. By the end of this course, students will have developed the ability to utilize the integration capabilities of Microsoft Word, Excel, Access, and PowerPoint.

Prerequisite: MO1, EX1 and PPG1

INT101: The Internet for Business – 30 hours

This course introduces students to the concepts and basics of using the Internet and how it is used in various business settings. During this course, students will set up, manage, and address e-mails properly for business use. Proper search techniques and Internet security will be discussed. Microsoft Outlook calendar and address book functions will also be covered and practiced.

Prerequisite: None

CD30: Career Development – 30 hours

Career Development provides an opportunity for students to prepare for a job search by path and an awareness of the need to include learning and applying critical self-examination techniques for developing a successful career life-long learning into career management. Topics include career planning research, job searching, refining interview and communication skills, developing and preparing career search documents such as resumes, job applications, cover letters and thank-you letters. Students will also be directed in use of telephone and faxing, employment testing, office behavior and etiquette, completing online applications and attaching their resumes.

Mock interviews will also be conducted.

Prerequisite: None

 

Click Here To Download Curriculum