Computer Applications

3 class hrs/wk, 3 cr.

Introduces computerized accounting principles using QuickBooks including setup, managing revenue and expenses, payroll, bank reconciliation, financial statements, inventory, and file maintenance.

Prerequisite: grade of “C” or better in BT090 or BA211.

F, W

1 class hr/wk, 1 cr.

Provides an overview of bookkeeping tasks that can be performed via the computer program Quick- Books. Includes introduction to setup, managing revenue, and expenses.

Prerequisite: grade of “C” or better in BT090 or BA211, or consent of instructor.

Offered as needed.

1 class hr/wk, 1 cr.

Provides an overview of bookkeeping tasks that can be performed via the computer program Quick- Books. Includes introduction to payroll, bank reconciliation, and inventory.

Prerequisite: grade of “C” or better in BT090 or BA211, or consent of instructor.

Offered as needed.

1 class hr/wk, 1 cr.

Provides an overview of bookkeeping tasks that can be performed via the computer program Quick- Books. Includes introduction to budgets, fi nancial statements, graphs, year-end procedures, and fi le maintenance.

Prerequisite: grade of “C” or better in BT090 or BA211, or consent of instructor.

Offered as needed.

3 class hrs/wk, 3 cr.

Introduces Microsoft Publisher publication software. Includes formatting and enhancing text, working with art, using design gallery and drawing tools, and using the Catalog feature for creating publications. Includes using styles; flowing text into multiple columns; creating drop caps and reversed text; using BorderArt, WordArt, text wrap, and mail merge. Covers features for improving publications design, creating multiple-page publications, and creating a Web site.

Prerequisite: computer literacy (prior experience with computer and mouse device) and touch keyboarding ability of 25 words per minute.

Offered as needed.

1 class hr/wk, 1 cr.

Provides part one of a hands-on introduction to Microsoft Publisher publication software. Covers topics including formatting and enhancing text, working with art, Design Gallery and drawing tools, and using the Catalog feature for creating publications.

Prerequisite: computer literacy (prior experience with computer and mouse device) and touch keyboarding ability.

Offered as needed.

1 class hr/wk, 1 cr.

Presents part two of a hands-on introduction to Microsoft Publisher publication software. Includes using styles, fl owing text into multiple columns, and creating drop caps and reversed text. Covers features for improving publications and creating multiple-page publications.

Prerequisite: grade of “C” or better in CA117A or equivalent, computer literacy (prior experience with computer and mouse device) and touch keyboarding ability.

Offered as needed.

1 class hr/wk, 1 cr.

Offers part three of a hands-on introduction to Microsoft Publisher publication software. Includes using special features such as BorderArt, WordArt, text wrap around objects, mail merge, and preparation for commercial printing. Covers features for working effi ciently and creating a Web site.

Prerequisite: grade of “C” or better in CA117B or equivalent, computer literacy (prior experience with computer and mouse device) and touch keyboarding ability.

Offered as needed.

1 class hr/wk, 1 cr.

Introduces operating systems software currently used in business and industry. Includes exploring and managing disk organization and using the accessories.

Prerequisite: computer literacy (prior experience with computer and mouse device) and touch keyboarding ability.

F, W, Sp, Su

1 class hr/wk, 1 cr.

Introduces building and editing worksheets, formatting and printing worksheets, working with formulas and functions, and charting using Microsoft Excel.

Prerequisite: computer literacy (prior experience with computer and mouse device), touch keyboarding ability, or consent of instructor.

F, W, Sp, Su

1 class hr/wk, 1 cr.

Covers use of special features including using and analyzing list data, using macros, enhancing charts, sharing Excel fi les, and saving as a Web page.

Prerequisite: computer literacy (prior experience with computer and mouse device), touch keyboarding ability, grade of “C” or better in CA118B1, or consent of instructor.

Offered as needed.

1 class hr/wk, 1 cr.

Focuses on “what-if ” analysis, PivotTables, linking, embedding, and customizing using Microsoft Excel.

Prerequisite: computer literacy (prior experience with computer and mouse device), touch keyboarding ability, grade of “C” or better in CA118B2, or consent of instructor.

Offered as needed.

1 class hr/wk, 1 cr.

Introduces database basics for tables design, forms design, simple queries, and reports.

Prerequisite: computer literacy (prior experience with computer and mouse device), touch keyboarding ability, or consent of instructor.

F, W, Sp, Su

1 class hr/wk, 1 cr.

Introduces multiple table and advanced queries and reports; PivotTables and PivotCharts; forms and subforms; and importing, exporting, and linking data.

Prerequisite: computer literacy (prior experience with computer and mouse device), touch keyboarding ability, grade of “C” or better in CA118C1 or consent of instructor.

Offered as needed.

1 class hr/wk, 1 cr.

Introduces the Internet and demonstrates how this resource may be used effectively in a modern offi ce. Emphasizes information currently needed by office professionals.

Prerequisite: grade of “C” or better in CA118A or CIS101.

F, W, Su

1 class hr/wk, 1 cr.

Introduces offi ce software currently used in business and industry. Th e brands of software in this class may change as industry standards evolve. Covers electronic messaging, (e-mail management), use of the address book, calendar, and task management.

Prerequisite: computer literacy (prior experience with computer and mouse device) and touch keyboarding ability.

F, W

1 class hr/wk, 1 cr.

Introduces presentation software with an emphasis on designing and formatting business-related presentations.

Prerequisite: computer literacy (prior experience with computer and mouse device), touch keyboarding ability or consent of instructor.

F, W, Su

3 class hrs/wk, 3 cr.

Introduces publication planning, typography, publication design principles, and hands-on desktop publishing preparation of offi ce publications, including the features of text threading, layers, frames, kerning, and tracking.

Prerequisite: touch keyboarding ability of 25 words per minute; computer literacy (prior experience with computer and mouse device).

F

2 class and 3 lab hrs/wk, 3 cr.

Presents basic touch keyboarding skills on standard microcomputer keyboard. Emphasizes speed and accuracy, the basic vocabulary of entering or retrieving information, and the formatting business letters and reports.

F, W, Sp, Su

2 lab hrs/wk, 1 cr.

Covers basic touch keyboarding for the standard microcomputer keyboard or typewriter keyboard.

F, W, Sp, Su

2 lab hrs/wk, 1 cr.

Reviews alphabetic keyboarding and emphasizes the development of speed and accuracy in touch keyboarding. Introduces number and symbol keys.

Prerequisite: grade of “C” or better in CA121A or touch keyboarding ability of 15 words per minute.

Offered as needed.

2 lab hrs/wk, 1 cr.

Emphasizes drills to increase speed and accuracy in touch keyboarding. Includes formatting different types of business letters and a short report.

Prerequisite: grade of “C” or better in CA121A and CA121B or touch keyboarding ability of 20 words per minute.

Offered as needed.

1 class and 4 lab hrs/wk, 3 cr.

Uses exercises to improve keyboarding profi ciency, speed and accuracy.

Prerequisite: touch keyboarding ability of 25 words per minute; 30 wpm recommended. Course may be repeated for a maximum of six credits.

F,W,Sp,Su

2 lab hrs/wk, 1 cr.

each Improves keyboarding skill, including keyboard proficiency, speed, and accuracy. May be taken any time after one has learned the keyboard and is keyboarding approximately 25 words per minute.

Prerequisite: grade of “C” or better in CA121 or consent of instructor. Each course may be repeated for a maximum of two credits each.

Offered as needed.

3 class hrs/wk, 3 cr.

Presents basic word processing training in the operation of Microsoft Word software.

Prerequisite: touch keyboarding ability of 30 words per minute.

F, W, Sp, Su

2 lab hrs/wk, 1 cr.

each Offers basic to intermediate word processing training in the operation of Microsoft Word for Windows.

Prerequisite: CA201D1: Touch keyboarding ability of 30 words per minute. CA201D2: Grade of “C” or better in CA201D1. CA201D3: Grade of “C” or better in CA201D2.

Offered as needed.

3 class hrs/wk, 3 cr.

Offers intermediate word processing training using Microsoft Word software for those with prior basic skills and knowledge of word processing.

Prerequisite: grade of “C” or better in CA201D or equivalent and touch keyboarding ability of 35 words per minute.

F, W, Sp

2 lab hrs/wk, 1 cr.

each Offers intermediate word processing training using Microsoft Word software for persons with prior basic skills and knowledge of word processing.

Prerequisite: CA202D1: Grade of “C” or better in CA201D or equivalent and touch keyboarding ability of 35 words per minute. CA202D2: Grade of “C” or better in CA202D1. CA202D3: Grade of “C” or better in CA202D2.

Offered as needed.

3 class hrs/wk, 3 cr.

Offers a hands-on microcomputer desktop publishing course providing beginning level training in the use of Adobe PageMaker desktop publishing software. Includes setting up and printing publications, importing and formatting text and graphics, using styles, using graphics tools, using spot color and tints, and using layers and frames.

Prerequisite: touch keyboarding ability of 25 words per minute; computer literacy (prior experience with computer and mouse device).

Offered as needed.

3 class hrs/wk, 3 cr.

Introduces the production of computer presentations for the workplace. Includes software techniques, design and typography basics, and production techniques for slides, overheads, and/or screen shows.

Prerequisite: grade of “C” or better in CIS101 or equivalent or consent of instructor.

F, W

3 class hrs/wk, 3 cr.

Brings together the knowledge, skills, and abilities required of one-year Business Technology students and serves as a review for students continuing for a degree. Uses a business simulation to reinforce and expand computer and other office skills.

Prerequisite: grade of “C” or better in CIS101, CA118A, CA118B1, CA118C1, CA201D, BT116, and BT120 (or concurrent enrollment).

W, Sp

3 class hrs/wk, 3 cr.

Focuses on publication planning, typography, publication design principles, and hands-on desktop publishing preparation of office publications, including the features of color, graphics, tables, transparency, books, printing/print shops, and exporting to PDF files.

Prerequisite: grade of “C” or better in CA119 or consent of instructor.

W

3 class hrs/wk, 3 cr.

Covers development of correct formats for business reports, letters, memos, tabbed columns, and forms. Uses a variety of input methods, such as CD ROM dictation, voice recognition software, and printed rough drafts. Develops basic skill in the transcription of recorded documents. Stresses application of language arts skills. Develops the skill to produce documents accurately within specifi ed timed guidelines and touch type at a minimum of 40 words per minute on 3-minute timings (with specifi ed error limits).

Prerequisite: touch keyboarding ability of 35 words per minute (no penalty for errors; 3-minute timings) and grade of “C” or better in BT099 and CA202D.

Sp

2 class and 2 lab hrs/wk, 3 cr.

Provides a work-flow simulation that gives students experience in working as team members with office co-workers. Includes practice in decision making, prioritizing, and time management. Brings together skills acquired in prerequisite courses.

Prerequisite: grade of “C” or better in BA214 and CA213.

W, Sp

3 class hrs/wk, 3 cr.

Emphasizes critical thinking skills to apply previous computer and business knowledge in the creation of individual and group projects. Studies and applies procedures for importing, exporting, linking, embedding, and merging. Uses electronic mail, peripheral equipment, and presentation software in the production of business documentation and oral reports.

Prerequisite: grade of “C” or better in CA118A, CA118B1, CA118C1, CA202D, and CA213.

W