Computer Technology/ Publishing & Design

Business Bookkeeping Computer Certificate CCCP-5500

This certificate is designed for busy adults who desire to learn the technical skills essential for bookkeeping-related positions. Learn popular accounting software and the essentials of spreadsheets and databases. Whether for a home-based business, your employer, or your next career, you will come to understand the applications used in the bookkeeping industry. A job for trained bookkeepers will be available in all types of industries and organizations, particularly for those individuals with up-to-date computer skills in accounting applications software. Classes include: Accounting Basics; Windows Basics; Word Level 1; Excel Level 1; Keyboarding; PowerPoint Level 1; Quick Books.

Ready to learn more? Complete our online form or contact us at 319-398-1022.

Upcoming Offerings:
No upcoming dates at this time. 

Tuition Assistance:
Yes. Full tuition assistance is available to support your career goals. Fill out our referral form at www.kirkwood.edu/cefunding.
*Some eligibility restrictions may apply.

Industry Credentials Earned:
None. This program does not award any nationally recognized certification upon completion.

Careers:
Source: Career Coach 2018, Kirkwood Community College region.
Bookkeeping, Accounting, and Auditing Clerks
Average hourly earnings: $18.42
Starting hourly earnings: $10.24
Projected job openings (2018 – 2023): 1,665

Brokerage Clerks
Average hourly earnings: $20.61
Starting hourly earnings: $13.68
Projected job openings (2018 – 2023): 19

Tax Preparers
Average hourly earnings: $23.28
Starting hourly earnings: $10.93
Projected job openings (2018 – 2023): 57

Entrance Requirements/Prerequisites:
None.

Delivery Method:
Classroom

Length of Program and CEU Credits:
95 hours, 12.12 CEUs

Program Completion Requirements:
This is a pass/fail certificate. There is a two-part final project for the Bookkeeping Computer Certificate. Students will be tested over the accounting concepts with a test possibly consisting of fill-in-the-blank, multiple-choice, and sequencing questions. Students must have a score of at least 70 percent for the Accounting test and a cumulative score of at least 70 percent for the Computer test in order to pass. Students must have 100 percent attendance to receive CEU credit (students are allowed to miss one class session).

Course Objectives:
• Understand basic accounting concepts, including debits, credits, double-entry bookkeeping, income statements, and balance sheets.
• Discover payroll accounting accruals, accounting for sales, cash receipts, purchases, special journals, voucher systems, and book reconciliations.
• Navigate the Windows Operating System, including managing windows and folders, sorting and filing files, running programs, managing security settings, and utilizing Window’s multimedia features.
• Multitask effectively using the task bar; minimize, maximize, resize, and move program windows; cut, copy, and paste text and pictures; and use various file storage devices.
• Navigate a Word document using the ribbon; enter and edit text; use numbered and bulleted lists; create envelopes; work with tables, borders, shading, styles, shapes, WordArt and SmartArt; set custom tabs; insert headers and footers; track changes; and save your work in different file formats.
• Using Excel, enter and edit data, format cells, work with numbers and dates, use AutoFill, and perform worksheet calculations. Rearrange data on a worksheet, manage multiple worksheets, and use functions in formulas. Create charts to compare data and utilize special features to make organizing large amounts of data easier.
• Using PowerPoint, create a presentation by choosing a theme, adding slides, choosing slide layouts, and navigating through the slides. Design and learn how to print the presentation through creating outlines and special formatting. Add graphics, animation, and multimedia to the presentation, including working with pictures, slide transitions, audio, and video.
• Learn to set up accounts, categorize transactions, add transactions to register, transfer funds, split transactions, transaction schedule, balance accounts, and create reports in QuickBooks.
• Learn to use graphics, mortgage, loan tracking, and category groups, and create and use investment accounts and budgeting in QuickBooks.
• Create advanced-level reports and graphs, customize forms, do payroll, and track and pay sales tax in QuickBooks.

Learning Outcomes:
Upon completion of this program students should be able to understand accounting concepts and execute basic accounting functions, navigate the Windows Operating System, perform basic office tasks in Microsoft Word, Excel, Access, and PowerPoint, and perform basic and advanced-level tasks in QuickBooks.

Other Items to Know About this Course:
All classroom materials are included in the tuition fee and will be provided in class.

Pathway to Credit Program:
None.

Related Information: 
NA