This is the first course in a sequence that develops foundational skills in the use of Microsoft Office Excel features to efficiently and effectively produce business spreadsheets. Students will apply Microsoft Excel skills to solve practical problems in a project-based format. Activities will work on creating a spreadsheet, incorporate appropriate formulas and functions to report accurate data, and chart results. Recommended computer foundations: Windows competency, including solid file management skills; basic math fundamentals. This course will use Microsoft Office 2019 or Office 365.
Students will learn to use MS Excel. Credit B activities will include using advanced features of formulas, object linking and embedding, multiple worksheets, 3-D references, macro basics and database basics. COREQUISITE: 10103151 MS Excel A.
This hands-on course covers formatting styles of business letters, business and academic reports, memos, tables, and business documents. The course also includes drill work for improving keying speed and accuracy. Students should be able to key 40 words per minute.
This course presents common health insurance terminology and selected private and government insurance coverages. Students are introduced to basic principles of disease coding and procedural coding from the physician/provider perspective and follow the life cycle of the medical insurance claim with the aim of accurate and efficient reimbursement for services provided. This is not for experienced coders. PREREQUISITE: 10501101 Medical Terminology.
Simulates handling patients and employees, applying customer service skills, and the use of computers in a medical/clinical setting. Hands-on experience in scheduling appointments, work in electronic medical records, establishing a fee schedule, and practice management. Utilizes Microsoft Office software, electronic billing software, electronic medical record software, telephone systems, internet, fax and e-mail. PREREQUISITE: 10160143 Medical Office Procedures and Customer Service.
Emphasizes insurance preparation and reimbursement of claims to Commercial, Medicare, Medicaid and Worker's Compensation. Applies ICD, CPT and HCPCS coding resources to complete CMS 1500 and CMS 1450 insurance claims. Computerized billing software will be utilized throughout the course. PREREQUISITE: 10160134 Medical Insurance Claims.
This course develops professional skills and attitudes needed in a medical business environment. Skills developed include an ability to communicate effectively with patients and other medical office staff, manage time effectively, schedule patients, greet patients, use the telephone properly, process mail, apply ergonomics and office safety, and use medical computer software efficiently.
Medical Administrative Practice is a capstone course for the Medical Administrative Professional degree, which brings together skills and knowledge learned in other classes and applies them in decision-making situations and in completing job tasks. This course provides the student with the training required to keep consistent with computer software that is used in the billing areas of the medical office. Topics covered are medical office procedures, practice management, basic billing skills and billing collection via real-life activities and simulations. Upon completion, students should be able to demonstrate the skills necessary to work in the medical office. PREREQUISITE: 10160140 Medical Office Administration COREQUISITE: 10160134 Medical Insurance Claims
Focuses on the component parts of medical terms: prefixes, suffixes and word roots. Students practice formation, analysis and reconstruction of terms. Emphasis on spelling, definition and pronunciation. Introduction to operative, diagnostic, therapeutic and symptomatic terminology of all body systems, as well as systemic and surgical terminology.
This course integrates algebraic concepts, proportions, percents, simple interest, compound interest, annuities, and basic statistics with business/consumer scenarios. It also applies math concepts to the purchasing/buying and selling processes. Emphasis is placed on the use of complex formulas for sinking funds and for present/future value and payments in both the accumulation and distribution phases of an annuity as well as to the development of formulas for business scenarios such as finding effective interest rates and finding the proceeds of a third-party discount.
Total: 26 Credits
Choose a campus to view contact information, or for general assistance, please contact us.