Home Certification

Announcements Job


  • September 26, 2016 - June 9, 2017 (Externship through June 30, 2017)

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

Students learn software and professional skills vital to medical, accounting, and varios types of offices; Prepares students for Microsoft Office; QuickBooks; and NHA Certified Medical Administrative Assistant certification.
Students also complete a 60-hour externship outside of classroom hours which provides valuable employer connections.

Dorothy Sharrock Elaine Oswalk
Microsoft Office Certified Instructor CHDS, CPC-A

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
    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
    Learn medical terminology (root words, suffixes and prefixes) used in the medical practices.

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

  • ICD-10-CM Coding
    Practice ICD-10-CM coding using many conventions and guidelines.

  • Medical Office Procedures
    Practice effective communication, patient reception,registration and scheduling; telephone skills, and office/waiting room management.

  • Medical Insurance/Billing
    Learn the health insurance industry basics, legal guidelines and how to accurately process health insurance claims for major insurances, employee group plans, Medicare, Medicaid, TRICARE, CHAMPVA and Worker’s Compensation.

  • Medical Records Management
    Recognize and prepare medical records and charts. Describebenefits and challenges of electronic health records systems. Use electronic health record software to add/edit data, runreports, and manage templates.

  • Healthcare Provider CPR
    Learn how to perform basic life support (adult/child/infant) and AED in a variety of healthcare settings.

  • First Aid
    Manage illness and injuries within the first few minutes oftheir occurrence. Students will receive a Pass or Fail grade.


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: