Computer Fundamentals & Business Applications

PROGRAM CURRICULUM

CBA -1100 COMPUTER FUNDAMENTALS & WINDOWS - 60 Clock hours

The student will learn basic computer terminology and concepts and get a fundamental understanding of the functions and specifications of the different parts and components that make-up a typical microcomputer system. This basic course also presents an overview of the features of the Microsoft Windows operating system and the components of managing files and folders in the Windows environment. In this hands-on course, students learn to use and customize the start menu; work with Windows accessory programs; open data files; manage disks, folders and files; create shortcuts; customize the desktop, and others essential features. No prior computer knowledge is needed since this is an introductory level course.

CBA -1200 WORD PROCESSING I - 60 Clock hours

This course provides students with the fundamental skills needed to use Microsoft Word in a business environment. Topics include creating, editing, formatting, moving, copying, saving, and printing documents. Students also enhance the appearance of documents by formatting text, blocking text for modifications, searching and replacing words, using the speller and treasures, and other applications. In addition, this course is also designed to teach students to operate the keyboard correctly by developing touch control of the keyboard and proper typing technique. Prerequisite: MC 1100 Computer Fundamentals & Windows.

CBA -1210 WORD PROCESSING II - 60 Clock hours

This course covers intermediate to advanced Word concepts and skills. It is a continued application of Microsoft Word text editing features including creation of envelopes and labels, mail merge, sorting, styles, templates, wizards, macros, document notations, tables of contents and indexes, and introduction to creating Web pages. Headers and footers, columns, and use of graphic elements in documents are mastered. During the course, the student will also expand the level and speed of keyboarding (typing) and will receive basic formatting instructions for business letters and reports. Prerequisite: MC 1200 Word Processing I

CBA -1300 OUTLOOK/Employability Skills - 60 Clock hours

Students are introduced to Microsoft Outlook and learn how to perform a wide range of communication and organizational tasks, such as sending, receiving, and filing e-mail; organizing contacts; scheduling appointments, events, and meetings; creating a to-do list and delegating tasks; and writing notes. During this course, the student will attend a one-week Job Placement Workshop. Prerequisite: MC 1100 Computer Fundamentals & Windows.

CBA -1400 DATABASE APPLICATIONS - 60 Clock hours

Students are introduced to the concept of a database and shown how to use Access to create a database. Topics include creating a database; creating a table; defining the fields in a table; opening a table; adding records to a table; closing a table; and previewing and printing the contents of a table. Additional topics include using a form to view data; using the report wizard to create a report; and other applications. This is an introductory level course. Prerequisite: MC 1100 Computer Fundamentals & Windows.

CBA -1500 POWERPOINT - 60 Clock hours

Students will review basic arithmetic operations and learn their applications to business problems in the areas of financing, accounting and banking, including the study of commissions, trade and cash discounts, interest, promissory notes, payroll, profit and loss, and federal income tax (individual).

CBA -1700 ACCOUNTING PRINCIPLES - 60 Clock hours

Students will learn how to start an accounting system, analyze transactions into debit and credit parts, journalize and post business transactions, accounts receivable, accounts payable, sales tax, notes and interest, and accrued items. They will also learn how to plan adjusting entries on a work sheet and complete end-of-fiscal period. Payroll and three accounting control systems—a voucher system, a petty cash system, and an inventory system—will also be introduced.

CBA -1800 SPREADSHEET APPLICATIONS I - 60 Clock hours

Students are introduced to Excel terminology, the Excel window, and the basic characteristics of a worksheet and workbook. Topics include exploring the Excel components; entering text, dates, and numbers; selecting and editing cell content; selecting a range; using the AutoSum button and frequently used Excel functions; changing font size; formatting worksheets; centering across columns; using the Auto Format command; saving and opening a workbook; editing a worksheet; sorting data in a list; and other applications. A math review is also included. Prerequisite: MC 1100 Computer Fundamentals & Windows.

CBA -1810 SPREADSHEET APPLICATIONS II - 60 Clock hours

This course covers intermediate Excel concepts. It will provide students with the skills needed to analyze and summarize information. Topics include sorting data; filtering a list using autofilters; charting using the Chart Wizard; using more advanced Excel functions; working with multiple worksheets and workbooks; customizing form letters using an Excel list; creating merged documents; integrating excel with other programs; and other spreadsheet applications. Prerequisite: MC 1800 Spreadsheet Applications I

CBA -1900 QUICKBOOKS I - 60 Clock hours

This course provides students with hands-on experience using microcomputers to start and use an automated accounting system (QuickBooks®). The student will learn about the types of information they need to track in a business and how to enter that information. Topics include setting up QuickBooks, working with lists, working with bank accounts, entering sale information, receiving payments and making deposits, and entering and paying bills.

CBA -1910 QUICKBOOKS II - 60 Clock hours

This course covers more advanced features of QuickBooks. Topics include setting up inventory, analyzing financial data, tracking and paying sales tax, doing payroll with QuickBooks, and customizing forms and creating and writing QuickBooks letters. Prerequisites: CBA 1900 - QuickBooks I