Business Information Professional
29 courses · Antelope Valley College · 2026-2027 Catalog
Classes: Fall 2026 · Spring 2027
BIP 100 Introduction to Business Information Professional
- Units
- 3
- Hours
- 54 lecture hours, 54 contact hours total
This course provides the learner with a survey of skills and topics covered in the Business Information Professional Program certificates and degree program. Business English, entry-level office procedures such as the role of a business information professional, the workplace environment, workplace communication, ethics, customer focus, and teamwork are covered. The focus is an introduction to skills that are relevant to success as an office clerk, administrative assistant, office manager, or other business information professional roles.
BIP 105 Computer Literacy
- Units
- 1
- Hours
- 13.5 lecture hours, 13.5 lab hours, 27 contact hours total
This course is designed for those with little or no computer experience. Learners practice file management, email, instant messaging, Internet browsing and searching. This course includes a brief introduction to industry standard Microsoft Office (word processing, spreadsheet, and presentation) application programs. Computer terminology and identification of fundamental hardware and software applications is introduced.
BIP 106 MS Outlook
- Units
- 1
- Hours
- 13.5 lecture hours, 13.5 lab hours, 27 contact hours total
This course introduces personal management software and use of Microsoft Outlook functions. Topics include management of e-mail, organization of contacts, creation and scheduling of events using the calendar, and creating and managing tasks for personal and business use. Customization of Outlook features is also covered.
BIP 110 Keyboarding I
- Units
- 1
- Hours
- 13.5 lecture hours, 13.5 lab hours, 27 contact hours total
This is a beginning-level keyboarding course designed to build effective keyboarding skills with an emphasis on building correct touch-typing techniques for alphanumeric, symbol, and punctuation keys. A foundation for keyboarding speed and accuracy is developed and proofreader's marks are introduced. Successful completion of this class results in a minimum keyboarding speed of 15 net words per minute on a two-minute timed writing. Completion of BIP 110 with a satisfactory grade may substitute for OT 101.
BIP 111 MS Word I
- Units
- 1
- Hours
- 13.5 lecture hours, 13.5 lab hours, 27 contact hours total
This course provides the initial introduction to Microsoft Word which is a document processing application. Students will learn to create and edit documents, navigate and format a document, create tables and multi-page reports, and enhance page layout and design. This class is designed for the end-user seeking administrative office skills. This vocationally-oriented course will serve students seeking a certificate, associate degree, or desiring to transfer to a four-year institution. Completion of BIP 111, 121, and 131 with a successful grade may substitute for OT 113.
BIP 112 MS Excel I
- Units
- 1
- Hours
- 13.5 lecture hours, 13.5 lab hours, 27 contact hours total
This course is designed to provide the learner with a basic understanding of Microsoft Excel beginning with spreadsheet design, creation, revision, formatting, and printing a workbook. Basic formulas, functions, and syntax are introduced along with an introduction to using charts and graphs. Problem solving for Excel solutions is also emphasized. This course begins preparation for the Microsoft Office User Certification exam for Excel. Completion of BIP 112, 122, and 132 with a satisfactory grade may substitute for OT 121.
BIP 113 MS Access I
- Units
- 1
- Hours
- 13.5 lecture hours, 13.5 lab hours, 27 contact hours total
This course is designed to provide the learner with a basic understanding of fundamental relational database design and management. Building and editing basic tables, forms, queries, and reports are introduced. This course begins preparation for the Microsoft Office User Specialist exam for MS Access.
BIP 114 MS PowerPoint I
- Units
- 1
- Hours
- 13.5 lecture hours, 13.5 lab hours, 27 contact hours total
This course provides the learner with experience planning, creating, editing, viewing, and printing PowerPoint presentations. Included is the opportunity to add and modify both text and graphics; insert and modify information graphics and multimedia; apply, modify, and create master pages; and to apply, modify, and create templates. Integration with other Microsoft programs is included. This course is designed for all individuals including professionals acquiring or updating basic skills in creating and editing professional presentations. This course prepares for the Microsoft Office User Certification in MS PowerPoint. Completion of BIP 114 and BIP 124 with a satisfactory grade replaces the former CA 141 course.
BIP 115 Practical Math for Business and Consumers
- Units
- 3
- Hours
- 54 lecture hours, 54 contact hours total
This course introduces practical mathematical applications for business information professionals. Topics include, solving business problems using an electronic calculator, banking, payroll, invoicing, markups/markdowns, interest, present and future value, credit cards, student loans, types of insurance, installment buying, and mortgages.
BIP 120 Keyboarding II
- Units
- 1
- Hours
- 13.5 lecture hours, 13.5 lab hours, 27 contact hours total
- Prerequisite
- Completion of or concurrent enrollment in BIP 110.
This intermediate-level course builds on a basic keyboarding foundation with correct touch typing techniques, including alphabetic, numeric, and symbol keyboarding, as well as 10-Key numeric keypad. Skill-building includes introductory formatting of documents using Microsoft Word. Successful completion of this class results in a minimum keyboarding speed of 30 net words per minute on a three-minute timed writing. Completion of OT 102 with a satisfactory grade may substitute for BIP 120 (note -- BIP 120 cannot substitute for OT102).
BIP 121 MS Word II
- Units
- 1
- Hours
- 13.5 lecture hours, 13.5 lab hours, 27 contact hours total
- Prerequisite
- Completion of or concurrent enrollment in BIP 111.
This course is designed to provide the learner with an intermediate level of understanding of word processing with Microsoft Word, including complex document creation, mail merge, columns, formatting, plus integration with other applications, and collaborating on documents using Microsoft Word. Themes, templates, and styles are also covered. This course continues preparation for the Microsoft Office User Exam for Microsoft Word. Completion of BIP 111, 121, and 131 with a satisfactory grade may substitute for OT 113.
BIP 122 MS Excel II
- Units
- 1
- Hours
- 13.5 lecture hours, 13.5 lab hours, 27 contact hours total
- Prerequisite
- Completion of or concurrent enrollment in BIP 112.
This course is designed to provide the learner with an intermediate understanding of Microsoft Excel. Analyzing data, working with multiple worksheets and functions, pivot tables, resolving conflicts, tracking changes, data validation, chart formatting, templates, and macros are covered. Problem solving for Excel solutions is also emphasized. This course continues preparation for the Microsoft Office User Certification exam for Excel. Completion of BIP 112, 122, and 132 with a satisfactory grade may substitute for OT 121.
BIP 123 MS Access II
- Units
- 1
- Hours
- 13.5 lecture hours, 13.5 lab hours, 27 contact hours total
- Prerequisite
- Completion of or concurrent enrollment in BIP 113.
This course is designed to provide the learner with an intermediate understanding of database design and management. Advanced Queries, table design, custom forms and reports as well as integration of Access with the web and other programs is covered. This course continues preparation for the Microsoft Office User Specialist exam for MS Access.
BIP 124 MS PowerPoint II
- Units
- 1
- Hours
- 13.5 lecture hours, 13.5 lab hours, 27 contact hours total
- Prerequisite
- Completion of or concurrent enrollment in BIP 114.
This second-level PowerPoint course builds on a fundamental skillset to feature the use of PowerPoint as a tool for designing, producing, and controlling visual elements to build and deliver effective presentations. Creating templates, publishing, customizing, and protecting presentations as well as inserting audio, video, and animations and integrating with other programs is included. This course focuses on design and effective delivery methods which are explored through project presentations. Completion of BIP 114 and BIP 124 with a satisfactory grade replaces the former CA 141 course.
BIP 125 Adobe Acrobat
- Units
- 1
- Hours
- 13.5 lecture hours, 13.5 lab hours, 27 contact hours total
This course is designed to provide the learner with a basic understanding of Adobe Acrobat. Topics include creating portable document files (PDF), working with PDF files, annotation and editing of files plus interactive forms. Distribution and management of PDFs is also covered.
BIP 126 Workplace Communication
- Units
- 3
- Hours
- 54 lecture hours, 54 contact hours total
This course covers essential communication skills and techniques important to the modern workplace, including written, verbal, listening, and nonverbal communication. Learners discuss, critique, and practice business-writing strategies to produce messages, letters, reports, and workplace communication while developing critical thinking skills.
BIP 127 Introduction to Accounting
- Units
- 3
- Hours
- 45 lecture hours, 27 lab hours, 72 contact hours total
- Prerequisite
- Completion of BIP 115.
This course covers basic accounting concepts and procedures that are required to complete an accounting cycle using generally accepted accounting principles (GAAP). Employer tax responsibilities and payroll is covered. Account types, (assets, liabilities, equity, revenue, expenses) as well as procedures for bank reconciliations, and petty cash, are introduced. Learners complete business transactions from source documents to closing entries and the preparation of year end documents such as a balance sheet, income statement, and statement of owner's equity using QuickBooks.
BIP 130 Keyboarding III
- Units
- 1
- Hours
- 13.5 lecture hours, 13.5 lab hours, 27 contact hours total
- Prerequisite
- Completion of or concurrent enrollment in BIP 120.
This is an advanced-level course that builds on an intermediate keyboarding foundation with correct touch typing techniques, including alphabetic, numeric, and symbol keyboarding as well as 10-Key numeric keypad. Skill-building includes introductory formatting of documents using Microsoft Word. Successful completion of this class results in a minimum keyboarding speed of 50+ net words per minute on a five-minute timed writing. Completion of OT 103 with a satisfactory grade may substitute for BIP 130 (Note -- BIP 130 cannot substitute for OT103).
BIP 131 MS Word III
- Units
- 1
- Hours
- 13.5 lecture hours, 13.5 lab hours, 27 contact hours total
- Prerequisite
- Completion of or concurrent enrollment in BIP 121.
This course is designed to provide the learner with an advanced level of understanding of word processing with Microsoft Word, including the creation of templates, macros, advanced table formatting, and the use of long documents and sub-documents. Customizing and automating work and online forms are also covered. This course completes preparation for the Microsoft Office User exam for Word. Completion of OT 113 or CA 111 with a satisfactory grade may substitute for BIP 131. (Note -- BIP 131 cannot substitute for OT 113 or CA 111).
BIP 132 MS Excel III
- Units
- 1
- Hours
- 13.5 lecture hours, 13.5 lab hours, 27 contact hours total
- Prerequisite
- Completion of or concurrent enrollment in BIP 122.
This course is designed to provide the learner with an advanced understanding of Microsoft Excel. Financial and what-if analysis, data tables, scenario management, importing and exporting data, enhancing with Visual Basic, sub-routines, modifying default settings, and problem-solving tools are covered. Problem solving for Excel solutions is also emphasized. This course completes preparation for the Microsoft Office User Certification exam for Excel. Completion of BIP 112, 122, and 132 with a satisfactory grade may substitute for OT 121.
BIP 133 MS Access III
- Units
- 1
- Hours
- 13.5 lecture hours, 13.5 lab hours, 27 contact hours total
- Prerequisite
- Completion of or concurrent enrollment in BIP 123.
This course is designed to provide the learner with an advanced understanding of database design and management. Action Queries, table relationships, and automating tasks with macros are covered. Visual Basic for Applications is introduced to enhance database construction and functionality. Managing replication and synchronization is included.
BIP 150 Business Information Professional
- Units
- 3
- Hours
- 54 lecture hours, 54 contact hours total
- Advisory
- Complete BIP 150 at the same time as the BIP Level III Certificate.
Designed for the last semester of study in this major, this course is designed to integrate and refine business information skills presented throughout the program in advanced preparation for the administrative professional occupation. Further administrative procedures including but not limited to travel arrangements, organizing meetings or conferences, and electronic records management are introduced. Emphasis is on time management, customer service, human relations, workplace ethics, and effective communication. A final focus on job applications, interviewing, and employment documents is included.
BIP 151 Basic Principles of Coding for the Medical Office
- Units
- 3
- Hours
- 54 lecture hours, 54 contact hours total
- Prerequisite
- Completion of or concurrent enrollment in MOA 101.
This is an introductory course in the basic principles of coding for the medical office using American Medical Association (AMA) standardized coding procedures and methodology.
BIP 152 Beginning Medical Insurance
- Units
- 3
- Hours
- 54 lecture hours, 54 contact hours total
This course provides a comprehensive and concise overview of medical insurance terms and physician billing procedures. It also provides beginning instruction in current ICD CM and CPT coding systems, medical terminology, and an overview of confidentiality issues and legal terms related to medical billing. Students will complete medical insurance forms for group and private insurances, Blue Cross/Blue Shield, HMOs, Medicare, Medi-Cal, and the TRICARE/CHAMPUS Programs. Also covered will be insurance and related forms for Unemployment Insurance, State Disability Insurance, and Workers' Compensation. An overview of hospital billing procedures will be included.
BIP 199 Work Experience Education
- Units
- 1-8
- Hours
- 432 lab hours
- Transfers to
- CSU
Students must also attend a scheduled orientation or meet individually with the supervising instructor for an individual orientation. Work Experience Education is supervised employment designed to provide students a realistic learning experience through work. The ultimate goal is to teach students skills and attitudes that will equip them to function and adapt as an employee in a variety of situations and jobs. Work Experience Education is supervised employment extending classroom-based occupational learning in an on-the-job learning situation related to the students' educational major or occupational goal. Credit may be accrued at the rate of one to eight units per semester.
BIP 205 Medical Office Procedures
- Units
- 3
- Hours
- 54 lecture hours, 54 contact hours total
- Formerly
- OT 205
- Transfers to
- CSU
Designed to provide a thorough understanding and offer practical application of the skills needed as a medical administrative assistant. Topics include professional conduct, receptionist duties, telephone techniques, appointment scheduling, organizing and maintaining records, composing medical business correspondence, office maintenance and management, financial responsibilities including the billing process and collections, computer and information processing in the medical office, and preparation for a position as a medical administrative assistant. Continuation of basic knowledge of medical terminology is included. Issues of confidentiality, medical law, and medical ethics will be emphasized. Students will use a medical office simulation software to simulate the administrative office environment.
BIP 995 Foundations of Artificial Intelligence in Business
- Units
- 0
- Hours
- 54 lecture hours, 54 contact hours total
This introductory course provides small business owners, entrepreneurs, and community members with a practical understanding of artificial intelligence concepts and their applications in business. Students will learn to define key AI terms in non-technical language, explore real-world use cases, and compare traditional workflows with AI-enhanced processes. The course emphasizes task-based learning and ethical considerations, enabling participants to identify opportunities to apply AI tools to improve efficiency, decision-making, and customer engagement. No prior technical background is required.
BIP 996 Applications of AI Tools for Business Productivity
- Units
- 0
- Hours
- 54 lecture hours, 54 contact hours total
This course provides hands-on experience with artificial intelligence tools that support entrepreneurship, small business operations, and organizational productivity. Students will explore AI-driven applications for market research, branding, customer engagement, and business planning. Emphasis is placed on practical, task-based learning, including the use of AI platforms for content creation, financial analysis, and competitive intelligence. By the end of the course, students will be able to apply AI tools to streamline operations, enhance decision-making, and strengthen their business strategy. No prior technical background is required.
BIP 997 AI for Daily Business Management
- Units
- 0
- Hours
- 54 lecture hours, 54 contact hours total
This course explores how artificial intelligence can be applied to everyday business operations. Students will learn to integrate AI tools into customer service, scheduling, and human resource management, while also applying AI to inventory control, supply chain forecasting, and vendor relations. Instruction emphasizes practical, task-based learning that prepares students to implement AI-driven analytics for financial monitoring and to design personalized marketing campaigns. By the end of the course, students will be able to use AI to improve efficiency, strengthen customer engagement, and support data-informed decision-making. No prior technical background is required.