Academic Program

Computer Fundamentals & Business Applications

Home>Computer Fundamentals & Business Applications

OBJECTIVE

This program is designed to introduce students to computers and software currently used in business. InterAmerican Technical Institute provides the best computer training in Miami to improve your skills for computer fundamentals and applications. Its objective is to provide graduates with the skills and knowledge necessary to apply and obtain an entry level position in word-processing, computerized bookkeeping, clerical accounting, or any other position where a fundamental understanding of computers, basic accounting, databases and spreadsheets is needed or desired.

Upon graduation the student will receive a Diploma.

PROGRAM DESCRIPTION:

This program is taught via a combination of lecture and practical exercises in the laboratory.

The program includes, but it is not limited to, introduction to the most common operating systems, Word Processing, Outlook, Power Point, Keyboarding, Database applications, and an introduction to the most common fundamental accounting concepts, including computerized accounting (QuickBooks®), and Spreadsheet.

  • PROGRAM LENGTH:

720 instructional clock hours/30 Semester Credit Hours. This program also requires 180 hours of ― out of class‖ work during the program.

The student has 36 weeks to complete the program.

PROGRAM COST

Registration Fee: $150.00

Book: $350.00

Tuition: $10,200.00

Total: $10,700.00

Costs of books (digital) and supplies are included as part of tuition cost.

All prices for programs are as printed herein. There are no additional costs or supplies necessary for program completion..

FACULTY MEMBERS

- Yudeisy Ramos
[email protected]

Master in Computer Science, Licentiate in Computer Science at University of Ciego de Avila, Cuba.

PROGRAM OUTLINE

NumberTitleCredit HoursLecture HoursLab HoursInstruct. Clock HoursRequired Out-ofclass work Hours
CBA - 1100Computer Fundamental & Windows2.530306015
CBA-1200Word Processing I2.530306015
CBA-1210Word Processing II2.530306015
CBA-1300MS Outlook/Employability Skills2.530306015
CBA-1400Database Applications2.530306015
CBA-1500Power Point2.530306015
CBA-1600Business Mathematics Principles2.530306015
CBA-1700Accounting Principles2.530306015
CBA-1800Spreadsheet Applications I2.530306015
CBA-1810Spreadsheet Applications II2.530306015
CBA-1900QuickBooks I2.530306015
CBA-1910QuickBooks II2.530306015
Total30360360720180

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