LETI Vocational School
Bilingual Administrative and Technical Training
Entrenamiento Administrativo y Técnico Bilingüe
 •   •   •   • 
Effective fall 2019
Bookkeeping Assistant Certificate

Overview





Catalog • Catálogo

Quarter Course Number Course Title & Description Clock Hours
1 STY 200 Study Skills
Active listening, reading comprehension, notetaking, stress management, time management, testing taking, and memorization are only a few of the topics addressed in our study skills guides.
20
1 ACCT 146 10 Key
Introduction to the computer 10-key, keypad and the functions of the desktop calculator.
10
1 KEY 100 Beginning Data Entry
In this course you will learn how to organize files and collect data to be entered into the computer. Analyze data for error and reporting problems with the data. Accurately entering information into various computer programs and keeping sensitive customer or company information confidential.
30
1 COM 110 Computer Fundamentals
In this introductory course, students will become familiar with the basic principles of a personal computer, including the internal hardware, the operating system, and software applications. The focus is on the basics: learning and using the applications, understanding the roles and responsibilities of the software, hardware, and operating system applications such as word processors, spreadsheets, and presentation software, as well as understanding social and ethical issues around the Internet, information, and security.
50
1 ENG 201 Business English
This class is designed to teach you to communicate effectively in English in professional contexts. You will expand your English vocabulary, improve your ability to write and speak in English in both social and professional interactions, and learn terminology and skills that you can apply to business negotiations, telephone conversations, written reports and emails, and professional presentations.
50
2 COM 120 Computer Fundamentals II
The focus is on gathering and analyzing data and on using the right tools and methods to collect and present data.
50
2 EXC 110 Excel I
In this course, you'll start by learning skills like navigating spreadsheets, using shortcuts, and performing calculations. Then you'll dive deeper into more complex formulas and functions, like v-lookups, pivot tables, and creating visualizations.
30
2 BUS 145 Business Mathematics
Apply mathematical concepts using numerical data in Excel to complete business applications. Create formulas and use functions of Excel to compute basic math operations, fractions, percent, percent increase/decrease, bank reconciliation, payroll, taxes and insurance, discounts, markup/markdown, interest, mortgages, depreciation, and financial statements.
50
2 ACCT 101 Practical Accounting I
An introduction to the basic concepts and standards underlying financial accounting systems. Covers beginning accounting fundamentals, including journalizing, posting, financial statements and computer applications. Course Level Objectives 1. Use the rules of the fundamental accounting equation to analyze and explain accounting information. 2. Use spreadsheets to input, manage, and interpret information to meet the needs of a single proprietorship. 3. Use analytical skills to support business transactions of a single proprietorship. Requirement: 4. Apply critical thinking and analytical skills in decision making and problem solving. 5. Create professional and accurate financial documents. 6. Work independently to apply reasoning skills and critical thinking. 7. Perform in ways that reflect ethics and standard bookkeeping expectations related to a single proprietorship.
50
2 ACCT 101 LAB Practical Accounting Lab I w/QuickBooks
Hands-on practice of QuickBooks including preparing A/R, A/P, bank reconciliations and generating financial reports. For students with limited or no experience using QuickBooks. Course-level Learning Objectives (CLOs) Upon successful completion of this course, students will be able to: 1. Demonstrate how to set up QuickBooks files, create invoices, pay bills, record deposit and prepare bank reconciliations. 2. Prepare and communicate Balance Sheet, Profit and Loss statement, Accounts Receivable aging report and Accounts Payable aging report. Special Requirement: ACCT 102 and ACCT 102 LAB must be taken together in the same Quarter.
50
3 ACCT 102 Practical Accounting II
Theory of asset, liability, and stockholders' equity accounts; construction of financial statements. Course-level Learning Objectives (CLOs) 1. Recognize accounting transactions and record them in journals using proper formats. 2. Apply the concepts of accrual accounting to transactions that span fiscal periods. 3. Trace the effects of those transactions to financial statements. 4. Record accounting transactions for merchandising operations and understand how to cost inventories using a variety of methods. 5. Journalize transactions specific to managing cash and accounts receivable. 6. Record transactions for uncollectible accounts using generally accepted principals. 7. Prepare financial statements including income statements, statements of retained earnings, and balance sheets. 8. Calculate and explain the significance of liquidity and profitability ratios. ACCT 102 LAB Special Requirement: ACCT 102 and ACCT 102 LAB must be taken together in the same Quarter.
50
3 ACCT 102 LAB Practical Accounting Lab II w/QuickBooks
Hands-on practice of QuickBooks including setting up files, creating customer and vendor lists, developing a chart of accounts, preparing A/R, A/P, bank reconciliations, processing payroll and generating financial reports. Course-level Learning Objectives (CLOs) Upon successful completion of this course, students will be able to: 1. Demonstrate how to set up QuickBooks files, create invoices, pay bills, record deposit and prepare bank reconciliations. 2. Prepare accounts receivable and accounts payable aging reports. 3. Interpret and communicate QuickBooks information and reports.
20
3 EXC 112 Excel II Analysis & Design
Introduces key concepts to develop and analyze business spreadsheets. Topics include formulas, formatting, logical, financial, and lookup functions, charts, pivot tables, data tables, and multiple workbooks. Projects integrate skills to create business spreadsheets that communicate financial and operational performance. Prerequisite: EXC 110
50
3 ACCT 135 Business Payroll –Tax Reports
Examines systems and operations of payroll tax accounting. Students learn to prepare Form 941, 940, and W-2. The use of software such as Microsoft Excel is incorporated into the course. Topics include the Fair Labor Standards Act and Social Security Act.
30
TOTAL CLOCK HOURS 510
In case of conflict between this page and the official printed catalog the printed catalog shall prevail.