Home Certification

Announcements Job


  • August 31, 2015 - May 31, 2016

  • Monday through Friday 8:45 a.m. - 2:45 p.m.

Students learn software and professional skills vital to medical and other offices; prepare for Microsoft Office; QuickBooks; and AAPC (medical coding)certification; and complete 18 hours of job shadowing outside of program hours.

Fran Au
Microsoft Office Certified Instructor

Core Courses
  • Accounting I
    Understand the accounting equation and analyze transactions to journalize, post, and complete a worksheet using adjusting and closing entries, and prepare financial statements for a sole proprietorship.

  • Business Communications
    Study of grammar and style rules including punctuation, capitalization, number, and abbreviation style; plurals and possessives; correct word choice, grammar, and document formatting; provide practice in applying rules correctly; develop proofreading and editing skills to locate and correct errors.

  • Business Math I
    Fundamentals of addition, subtraction, multiplication, and division of whole numbers, decimals, and fractions; solve for rate, base, percentage, and unknowns; calculate payroll, payroll taxes, markups and markdowns, and simple interest.

  • Computer Fundamentals
    Learn computer terms, processes, hardware, and software; Windows desktop, Microsoft Office programs and ribbon components; create folders; save and manage files.

  • Keyboarding
    Development of correct alphabetic and numeric computer keyboard manipulation, input, proofread and edit data correctly.

  • Microsoft Word I
    Insert, format, and edit text and pictures in documents; add borders; apply picture styles headers, footers, and footnotes; apply/edit citations, sources and references using various manuscript styles and research papers; create bibliography lists; insert and format tables, clip art, and symbols; use tabs; set margins; edit hyperlinks; format/print envelopes and labels.

  • Microsoft Word II
    Format and modify tables; sort lists and tables; create watermarks and multilevel lists; insert and format SmartArt graphics; edit and create a data source; apply mail merge to a main document; create a directory; format a drop cap; insert a text box and column breaks; prepare for certification exam.

  • Microsoft Excel I
    Create a worksheet with an embedded chart; application of formulas, functions, and formatting; understand and practice using What-If analysis, charts, and work with worksheets.

  • Microsoft Excel II
    Use financial functions and data tables; protect/unprotect cells; create, sort, and query a table; work with multiple worksheets and workbooks; prepare for certification exam.

  • Microsoft PowerPoint I
    Create, edit, and print a presentation with clipart, enhance the presentation using pictures, shapes, and WordArt, and insert media clips in a presentation.

  • Professionalism
    Refine essential workplace skills including communication; customer service; work habits; stress and time management; leadership; teamwork; resume development and job search.

  • QuickBooks Pro Accounting
    Apply accounting fundamentals using QuickBooks Pro automated accounting software to record various business transactions and print reports.

  • Medical Terminology
    Introduces medical terminology (rootwords, suffixes, and prefixes) used in coding from a coderís perspective.

  • ICD-9-CM Coding
    Learn rules and guidelines of the ICD-9-CM coding manual; ICD-9-CM coding conventions; basic definitions; diagnoses & procedures; coding guidelines; guidelines for procedures and standards of ethical coding.

  • HCPCS/CPT Coding
    Learn service and procedure coding for medical practitioners; related coding guidelines by type of service and medical specialty; and the basic principles related to CPT coding, guidelines, and HCPCS Level II codes.

  • Introduction to ICD-10-CM Coding
    Practice ICD-10-CM coding using many conventions and guidelines introduced through the ICD-9-CM coding manual and new conventions and guidelines used with ICD-10-CM.

  • Medical Insurance/Billing
    Understand the basics of the health insurance industry; how to accurately process health insurance claims for various insurance plans (major insurances, employee group plans, Medicare, Medicaid, TRICARE, CHAMPVA and Workerís Compensation); and realize legal, professional and insurance company guidelines.


Microsoft Office Specialist is a certification program provided by Microsoft that verifies an end user's experience in Microsoft Office applications such as Word, Excel, Outlook, Project, Access and PowerPoint. Two levels of certification are available - Proficient/Core Specialist and Expert Specialist. Madison Adult Education is your Authorized Microsoft Office Specialist Testing Center. All coursework used at Madison Adult Education for Word, Excel, PowerPoint and Access classes is Microsoft Office Specialist certified and approved. Microsoft testing is available by appointment at a cost of $120 per test. A proctoring fee of $50 will be charged for those with certificates to test. To schedule an exam(s), call 419-589-6363.

Fees (1000 hour program)
*Estimated Fees include: books, software/lab fees, certification assessments, and personal/career counseling services.
Fees may change before class begins.

Articulation Agreements
Franklin University - 23.33 credit hours
(Bachelor of Science in Applied Management degree)

North Central State College - 28 credit hours
(Associate in Technical Studies/Business Administration/Office Management degree)

Contact Director:
Sonja Pluck

600 Esley Lane

Mansfield, OH 44905

Contact Adult Ed secretary: