Home Certification

Announcements Job

Program Options Schedule
  • 1000 Hour Program - Core courses plus one concentration

  • 700 Hour Program - Core courses only
  • Monday through Friday 8:45 a.m. - 2:45 p.m.

  • Program Core: September 4, 2014 - March 13, 2015

  • Program Concentration: March 16, 2015 - June 3, 2015

Skills taught through Core courses provide students with a solid foundation of software and professional skills vital to any office setting and helps students prepare for Microsoft Office Certification. Students who complete the Medical Office Concentration prepare for AAPC (medical coding) certification and may also work in a variety of medical offices. Accounting students prepare for QuickBooks certification and may also work as bookkeepers, account/payroll clerks or other positions in a variety of offices.

The program is 1,000 hours (700 hours core + 300 hours area of concentration in Medical Office or Accounting)

        Students are required to complete 18 hours of job shadowing.
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.

  • Business Math II
    Continuation of Business Math I; application of depreciation methods and inventory costing methods; explore business statistics; analyze financial statements solving for ratios.

  • Computer Fundamentals
    Understand basic computer terms, processes, hardware, and software; examine Windows 7 desktop, Microsoft Office programs and Ribbon components; create folders; save and manage files.

  • Keyboarding
    Development of correct alphabetic and numeric manipulation of the computer keyboard and number pad; input data correctly; develop proofreading and editing skills.

  • Professionalism
    Development of skills essential to the workplace, including oral and written communications; discuss customer service skills, professional work habits, stress and time management, leadership skills, and teamwork; prepare for employment.

  • Microsoft Publisher
    Introduces user to software to create and design flyers, brochures, and newsletters.

  • Microsoft Word I
    Provides practice inserting, formatting, and editing text and pictures; adding page borders; and applying picture styles; create research papers by applying citations and references using various manuscript styles; apply headers, footers, and footnotes; edit sources and citations; create a bibliography lists; insert and format tables, clip art, and symbols; use tabs and set margins; edit hyperlinks; address and print envelopes and labels.

  • Microsoft Word II
    Continuation of Microsoft Word I; 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; merge and print a form letter; format a drop cap; insert a textbox and column breaks.

  • Microsoft Excel I
    Provides instruction and practice to 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
    Continuation of Microsoft Excel I; study of financial functions and use data tables; instruction to protect and unprotect cells; create, sort, and query a table; and work with multiple worksheets and workbooks; prepare for certification exam.

  • Microsoft PowerPoint I
    Provides instruction and practice to create, edit, and print a presentation with clipart, enhance the presentation using pictures, shapes, and WordArt, and insert media clips in a presentation.

  • Microsoft PowerPoint II
    Continuation of PowerPoint I; provides instruction and practice inserting and formatting a SmartArt graphic, charts, and tables; use reviewer’s changes and comments to enhance a presentation; inspect and protect the presentation, and package the presentation; prepare for certification exam.

Office Accounting Concentration
  • Accounting II
    Continuation of Accounting I; instruction in accounting fundamentals to record transactions using the sales and cash receipts journals, and the purchases and cash payments journals; payroll and payroll taxes, depreciation and inventory methods; adjusting, closing, and reversing entries; completion of a worksheet and financial statements.

  • QuickBooks Pro Accounting
    Application of accounting fundamentals using automated software to record business transactions, print reports, and prepare for certification testing.

  • Microsoft Access
    Instruction and practice in the design and creation of a database, create a query and form, and print reports; query a database and create a report; maintain a database by adding, deleting, or sorting records

Medical Office Concentration
  • Medical Terminology
    Introduces the student to the medical terminology (root words/ suffixes/prefixes) used in medical coding and covers medical terminology from a coder’s perspective.

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

  • HCPCS/CPT Coding
    Introduces students to service and procedure coding for medical practitioners and related coding guidelines by type of service and medical specialty. Students will learn the basic principles and conventions related to CPT coding and become familiar with CPT coding guidelines, as well as HCPCS Level II codes.

  • Introduction to ICD-10-CM Coding
    Helps students understand the structure of an ICD-10-CM code and the layout of the ICD-10-CM coding manual.


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.

*Estimated Fees include: books, software/lab fees, certification assessments, and personal/career counseling services.
Fees may change before class begins.
Core Course (700 hours)

Core & Accounting Concentration (1000 hours)

Core & Medical Office Concentration (1000 hours)

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: