Docstoc

Business Office Applications

Document Sample
Business Office Applications Powered By Docstoc
					Business Office Applications
Associate of Applied Science Degree                                      accounting and bookkeeping principles, electronic spreadsheets,
Administrative Assistant Major                                           and computerized accounting software packages. This certificate
                                                                         is also available as an online/distance learning (DL) option.
Administrative Assistant Medical Cognate
Bookkeeping Certificate                                                  Columbus State Community College’s business degree programs
Office Skills Certificate                                                are accredited by the Association of Collegiate Business Schools
Office Specialist Certificate                                            and Programs (ACBSP).

The Occupational Outlook Handbook, published by the United               Upon completion of the Associate Degree in Business Office Ap-
States Department of Labor, has forecast that this occupation            plications, the graduate will be able to:
is expected to be among those with the largest number of new             • Develop and maintain electronic and manual filing systems
jobs. This handbook indicates that opportunities should be best          • Compose or draft responses to business correspondence, use
for applicants with extensive knowledge of business software                correct grammar, and use punctuation rules accurately
applications. Administrative assistants today perform fewer cleri-       • Perform bookkeeping tasks using spreadsheet software
cal tasks and are increasingly taking on the roles of information        • Prepare written and oral presentations using presentation graph-
and communication managers. The Business Office Applications                ics software
Technology offers an Associate Degree in Business Office Ap-             • Demonstrate knowledge of management theory, functions, and
plications with an Administrative Assistant major that will enable          skills
students to acquire advanced software and keyboarding skills             • Demonstrate a working knowledge of current legal, ethical,
as well as management and team-building skills. Students will               social, financial, and economic environmental factors as they
participate in office simulations and an office internship that will        apply to business
prepare them to become an integral part of any office management         • Use appropriate business office applications technology and
team. These skills will enable a graduate to assume responsibility          other resources to research, analyze, and integrate data to solve
without direct supervision, display initiative, exercise judgment,          business problems
and prepare business communications documents.                           • Work effectively as a member of a team.

The Medical Cognate prepares students to work in medical set-            Administrative Assistant Major
tings such as hospitals, medical offices, clinics, dental offices, and   In addition to the general Business Office Applications compe-
insurance companies.                                                     tencies, a graduate in the Administrative Assistant major will be
                                                                         able to:
Three certificates are also available. The Office Skills Certificate     • Use operating systems and desktop features and functions to
program prepares students for entry-level office positions. Students        organize and manage files and documents effectively to increase
develop skills and business application knowledge in word pro-              productivity
cessing, electronic spreadsheets, database management systems,           • Prepare presentation graphics and present information
presentation graphics, information management, keyboarding,              • Research information using a variety of resources including
and bookkeeping.                                                            the Internet
                                                                         • Use computers to integrate business office applications and
Columbus State’s Office Specialist Certificate program prepares             graphics into documents
students for the globally-recognized Microsoft® Business Ap-             • Transcribe a variety of documents accurately and at an accept-
plications Specialist certification. In today’s workplace, more             able production rate.
employers require that office workers be knowledgeable in all
areas of Microsoft Office software applications. Students develop
skills in word processing, electronic spreadsheets, presentation
                                                                         Administrative Assistant Medical Cognate
graphics, database management, and desktop management. These
                                                                         In addition to the general competencies, a graduate choosing the
skills prepare students to be more productive while using the most
                                                                         Medical Cognate will be able to:
up-to-date technologies. This certificate is available as an online/
                                                                         • Demonstrate an understanding of the structure and organiza-
distance learning (DL) option.
                                                                              tion of current health care systems
                                                                         • Demonstrate the ability to spell, pronounce, and define basic
The Bookkeeping Certificate prepares students for a career in
                                                                              medical terminology.
office bookkeeping. This bookkeeping certificate includes prepa-
ratory courses enabling students to sit for a nationally recognized
Bookkeeping certification exam. This certificate program may
be completed in three quarters and provides a solid foundation of
                                                                                                                                       6/2011
Administrative Assistant Major                                                                                  Administrative Assistant Medical Cognate
COURSE                                                                                       CR                 The following two courses are required:
Quarter 1                                                                                                       MLT 100         Introduction to Health Care ..................................................3
MATH 101    Business Math.......................................................................5               MULT 101        Medical Terminology............................................................2
BOA 101     Business Grammar ...............................................................3
BOA 132     Document Formatting and Skill Building I ..........................3                                Choose 10 or more additional credit hours from the following courses:
BOA 105     Desktop and Document Management...................................1                                 BIO 261         Human Anatomy ...................................................................5
BOA 191     Word I (Modules 1 and 2) .....................................................2                     HIMT 112        Electronic Health Concepts. .................................................2
BOA 150     Office Procedures I ...............................................................3                HIMT 113        Managed Care Trends ...........................................................2
TOTAL CREDIT HOURS ............................................................................17               HIMT 121        Advanced Medical Terminology ..........................................3
                                                                                                                HIMT 133*       Legal Aspects of Health Information....................................3
Quarter 2                                                                                                       HIMT 135*       Health Data Management .....................................................3
BOA 151     Office Procedures II ..............................................................3                *Check prerequisites; signature may be required to enroll in this class.
BMGT 101*   Principles of Business ...........................................................5
BOA 133     Document Formatting and Skill Building II .........................3
BOA 192     Word II (Modules 3 and 4) ...................................................2
BOA 189     Access (Modules 1 and 2).....................................................2                      Bookkeeping Certificate
BOA 188     PowerPoint (Modules 1 and 2) .............................................2
BOA 172     Excel I (Modules 1 and 2) ....................................................2                     COURSE                                                                                       CR
TOTAL CREDIT HOURS ............................................................................19               Quarter 1
                                                                                                                BOA 172A    Excel (Module 1) ..................................................................1
Quarter 3                                                                                                       BOA 172B    Excel (Module 2) ..................................................................1
BMGT 102    Managing Interpersonal Skills ..............................................3                       BOA 111     Bookkeeping Basics I ...........................................................4
ENGL 101    Beginning Composition ........................................................3                     BOA 113     QuickBooks I (first term) ......................................................1
BOA 121     Records Management ...........................................................3                     BOA 114     QuickBooks II (second term)................................................1
BOA 111     Bookkeeping Basics I ...........................................................4                   TOTAL CREDIT HOURS ..............................................................................8
BOA XXX*    Technical Elective .................................................................3
BOA 173A    Excel Module 3 .....................................................................1               Quarter 2
BOA 173B    Excel Module 4 .....................................................................1               BOA 173A    Excel Module 3 .....................................................................1
TOTAL CREDIT HOURS ............................................................................18               BOA 173B    Excel Module 4 .....................................................................1
                                                                                                                BOA 115     Computer Bookkeeping with Peachtree® ............................3
                                                                                                                BOA 112     Bookkeeping Basics II ..........................................................4
Quarter 4
                                                                                                                TOTAL CREDIT HOURS ..............................................................................9
BMGT 216    Business Ethics and Leadership............................................4
BOA 138     Computer Transcription ........................................................3
                                                                                                                Quarter 3
BOA 193     Word III.................................................................................3
                                                                                                                BOA 116     Adjusting Entries and Error Corrections ..............................2
BOA XXX*    Technical Elective .................................................................3
                                                                                                                BOA 117     Payroll ...................................................................................2
ENGL 102    Essay and Research...............................................................3
                                                                                                                BOA 118     Inventory and Depreciation ..................................................2
BOA 125     MS Outlook ® ......................................................................3
                                                                                                                BOA 119     Internal Controls and Fraud Prevention................................2
TOTAL CREDIT HOURS ............................................................................19
                                                                                                                TOTAL CREDIT HOURS ..............................................................................8
                                                                                                                TOTAL CERTIFICATE CREDIT HOURS ................................................25
Quarter 5
BOA 195     Office Integration ..................................................................1
NSCI 101    Natural Science I...................................................................5
FMGT 101*   Personal Finance ...................................................................4
HUM XXX     111, 112,113, 151, 152 (or) 224 ............................................5                       Office Skills Certificate
COMM 105    Speech (or)
COMM 110    Conference and Group Discussion .......................................3                            COURSE                                                                                       CR
TOTAL CREDIT HOURS ............................................................................18               Quarter 1
                                                                                                                BOA 101     Business Grammar ................................................................3
                                                                                                                BOA 105     Desktop and Document Management...................................1
Quarter 6
                                                                                                                BOA 132     Document Formatting and Skill Building I ..........................3
BOA 106             Internet Research ..................................................................1
                                                                                                                BOA 150     Office Procedures I ...............................................................3
COMM 200            Business Communications ....................................................3
                                                                                                                BOA 191     Word I (Modules 1 and 2) .....................................................2
LEGL 264            Legal Environment of Business ............................................4
                                                                                                                TOTAL CREDIT HOURS ............................................................................12
BOA 250             Capstone ...............................................................................4
BOA 270             Business Office Applications Practicum...............................2
                                                                                                                Quarter 2
BOA 271             Business Office Applications Practicum Seminar ................2
                                                                                                                BOA 151     Office Procedures II ..............................................................3
TOTAL CREDIT HOURS ............................................................................16
                                                                                                                BOA 133     Document Formatting and Skill Building II .........................3
TOTAL DEGREE CREDIT HOURS.........................................................107                           BOA 172     Excel I (Modules 1 and 2) ....................................................2
*Students specializing in the medical cognate will substitute from the cognate                                  BOA 188     PowerPoint (Modules 1 and 2) .............................................2
list for this course.                                                                                           BOA 189A    Access (Module 1) ................................................................1
                                                                                                                BOA 189B    Access (Module 2) ................................................................1
Technical Electives                                                                                             TOTAL CREDIT HOURS ............................................................................12
BOA 113          QuickBooks I ........................................................................1
BOA 114          QuickBooks II.......................................................................1          Quarter 3
BOA 139          Keyboarding Improvement ...................................................1                   BOA 111     Bookkeeping Basics I ...........................................................4
BOA 190A         Access Module 3...................................................................1            BOA 138     Computer Transcription ........................................................3
BOA 190B         Access Module 4...................................................................1            BOA 192     Word II (Modules 3 and 4) ...................................................2
BOA 112          Bookkeeping Basics II ..........................................................4              BOA 121     Records Management ...........................................................3
BOA 167          Desktop Publishing ...............................................................3            TOTAL CREDIT HOURS ............................................................................12
BOA 115          Computer Bookkeeping with Peachtree® ............................3                             TOTAL CERTIFICATE CREDIT HOURS ................................................36
BOA 116          Adjusting Entries and Error Corrections ..............................2
BOA 117          Payroll ...................................................................................2
BOA 118          Inventory and Depreciation ..................................................2
BOA 119          Internal Controls and Fraud Prevention................................2
BOA 196          Office Specialist Review I ....................................................1
BOA 197          Office Specialist Review II ...................................................1
Office Specialist Certificate                                                                        BOA 106 Internet Research (A, W, SP, SU, DL)                       1 credit
                                                                                                     This course prepares students to use the Internet effectively for research in
COURSE                                                                                      CR       a business and workplace environment. Students will learn how to perform
Quarter 1                                                                                            basic and complex Internet searches, use search engines and subject guides
BOA 191A    Word Module 1 .....................................................................1     effectively, evaluate and cite online resources, and utilize specialized research
BOA 172A    Excel Module 1 .....................................................................1    tools, including newsgroups and intelligent search agents. Students will also
BOA 188A    PowerPoint Module 1 ...........................................................1
                                                                                                     learn about copyright issues and when it is appropriate to download and
BOA 189A    Access Module 1...................................................................1
BOA 131     Introduction to Keyboarding ................................................3
                                                                                                     use media from the Internet, and when it is necessary to obtain permission.
BOA 105     Desktop and Document Management...................................1                      Computer and Internet experience is recommended.
TOTAL CREDIT HOURS .............................................................................8    Lab: 2 hours       Lab fee: $2.00

Quarter 2                                                                                            BOA 111 Bookkeeping Basics I (A, W, SP, SU, DL)                 4 credits
BOA 191B    Word Module 2 .....................................................................1     This course is designed to provide students with a basic understanding of book-
BOA 172B    Excel Module 2 .....................................................................1    keeping principles and procedures including analysis of business transactions,
BOA 188B    PowerPoint Module 2 ...........................................................1
                                                                                                     journalizing, posting, adjusting and closing entries, and financial statement
BOA 189B    Access Module 2...................................................................1
TOTAL CREDIT HOURS ..............................................................................4
                                                                                                     preparation. Also included are transactions involving payroll accounting, bank
                                                                                                     accounts, and cash funds. Any DEV math classes needed are to be taken before
Quarter 3                                                                                            scheduling this course. Recommended: Students should complete BOA 172
BOA 192A    Word Module 3 .....................................................................1     Excel before taking this course.
BOA 173A    Excel Module 3 .....................................................................1    Lecture: 4 hours – Lab: 0 hours       Lab fee: $5.00
BOA 190A    Access Module 3...................................................................1
BOA 125     MS Outlook ® ......................................................................3     BOA 112 Bookkeeping Basics II (A, W, SP, SU, DL)               4 credits
BOA 196     OS Specialist Review I .........................................................1
                                                                                                     This course is a continuation of BOA 111 Bookkeeping Basics I. The course is
TOTAL CREDIT HOURS ..............................................................................7
                                                                                                     designed to provide students with a strong basic knowledge of accounting and
Quarter 4                                                                                            bookkeeping terminology, concepts, and procedures. Topics include combined
BOA 192B    Word Module 4 .....................................................................1     journals, payroll accounting, special journals, and the full accounting cycle
BOA 173B    Excel Module 4 .....................................................................1    for a merchandising firm.
BOA 190B    Access Module 4...................................................................1      Lecture: 4 hours – Lab: 0 hours
BOA 197     OS Specialist Review II .......................................................1         Prerequisite: BOA 111 with “C” grade or higher        Lab fee: $5.00
BOA 195     Office Integration ..................................................................1
TOTAL CREDIT HOURS ..............................................................................5
                                                                                                     BOA 113 QuickBooks I (A, W, SP, SU, DL)                      1 credit
TOTAL CERTIFICATE HOURS.................................................................24
                                                                                                     This is an introductory course for QuickBooks accounting software in which
                                                                                                     students learn to keep a set of computerized books for a small company.
                                                                                                     Any DEV math classes needed are to be taken before scheduling BOA 113.
                                                                                                     Recommended: Students should complete BOA 111 Bookkeeping Basics I
                                                                                                     before taking this course.
                                                                                                     Lecture: 0 hours - Lab: 2 hours      Lab fee: $2.00

                                                                                                     BOA 114 QuickBooks II (A, W, SP, SU, DL)                      1 credit
                                                                                                     This is an intermediate course in which students will gain additional knowl-
                                                                                                     edge in the use of QuickBooks software. Adjustment of company inventory,
                                                                                                     payroll processing, and banking transactions are covered along with other
                                                                                                     selected topics.
                                                                                                     Lecture: 0 hours – Lab: 2 hours
                                                                                                     Prerequisite: BOA 113       Lab fee: $2.00

                                                                                                     BOA 115 Computer Bookkeeping with Peachtree®
Course Descriptions                                                                                  (A, W, SP, SU, DL)                                             3 credits
                                                                                                     This course contains basic accounting procedures using computerized account-
BOA 101 Business Grammar (A, W, SP, SU, DL)                     3 credits                            ing software Peachtree ® 2007. The course covers how to create a company
This course is a structured program reviewing the parts of speech in detail.                         file, run accounts payable, manage inventory and payroll, track inventory and
In addition, it is designed to help students become skillful in sentence                             fixed assets, maintain ledgers and journals, and create reports.
analysis, word choice, punctuation, vocabulary, capitalization, number                               Lecture: 2 hours – Lab: 2 hours
expression, and spelling. Any DEV classes needed are to be taken before                              Prerequisite: BOA 111       Lab fee: $2.00
scheduling this challenging review course. It is recommended that students
take BOA 101 prior to ENGL 101. Business Office Applications majors                                  BOA 116 Adjusting Entries and Error Corrections
must earn a “C” grade or better in BOA 101.                                                          (A, W, SP, SU, DL)                                              2 credits
Lecture: 2 hours – Lab: 2 hours        Lab fee: $2.00                                                Students will learn to set up the trial balance, compute and record all end-of-
                                                                                                     period adjustments, and present the adjusted trial balance. Also included in
BOA 105 Desktop and Document Management                                                              this course is how to do the monthly bank reconciliation, correcting errors in
(A, W, SP, SU, DL)                                            1 credit                               the trial balance and in the accruals and deferrals.
This is a foundation course preparing students to manage the computer                                Lecture: 2 hours
desktop and documents. Students will learn to create and manage docu-                                Prerequisites: BOA 111        Lab fee: $2.00
ment folders, download and upload documents and folders, download and
use utility software to view PDF files, videos, and multimedia presenta-                             BOA 117 Payroll (A, W, SP, SU, DL)                              2 credits
tions, condense and extract zipped files and folders.                                                This course examines paying wages, withholding, depositing, and reporting
Lecture: 0 hours – Lab: 2 hours      Lab fee: $2.00                                                  taxes, as well as the correct use of government forms. In this course, students
will learn who gets overtime pay and who does not; how to process a              different three-minute timings, each demonstrating a minimum speed of
W-4 and complete the 941, 940, W-2 and W-3; how and when to deposit              35 words a minute (“D” grade) with accuracy of three or fewer errors.
withheld taxes using actual forms.                                               Students must earn a “C” grade or better as a prerequisite for BOA 133
Lecture: 2 hours                                                                 Document Formatting and Skill Building II.
Prerequisite: BOA 111      Lab fee: $2.00                                        Lecture: 2 hours – Lab: 2 hours
                                                                                 Prerequisite: “C” grade or better in BOA 131 or proficiency exam
BOA 118 Inventory and Depreciation (A, W, SP, SU, DL) 2 credits                  Lab fee: $3.00
Students will learn the perpetual and periodic methods of recording
inventory. They will also discover how to cost out inventory and record          BOA 133 Document Formatting and Skill Building II
cost of goods sold using weighted and moving average, FIFO, LIFO, and            (A, W, SP, SU, DL)                                               3 credits
lower of cost or market (LCM). Students will learn to compute and record         BOA 133 presents an advanced interactive system reinforcing keyboard-
depreciation for book and tax purposes; the 4 major methods of GAAP              ing skills by touch. Applications using Microsoft Word software are
depreciation; MACRS depreciation for tax purposes, including Section             designed to continue instruction of business correspondence, tabulations,
179 deductions; and tax depreciation of cars, SUVs and other vehicles.           manuscripts, reports, and various business forms with emphasis on correct
Lecture: 2 hours                                                                 techniques, proofreading, decision-making skills, and accuracy; further
Prerequisite: BOA 111        Lab fee: $2.00                                      development of keyboarding speed measured in words per minute and
                                                                                 accuracy of one error per minute on five-minute timings. To receive credit
BOA 119 Internal Controls and Fraud Prevention                                   for this course, students must demonstrate assigned formatting skills and
(A, W, SP, SU, DL)                                           2 credits           be able to key at least two different five-minute timings, each demonstrat-
This course examines internal controls and their role in the prevention          ing a minimum speed of 45 words per minute (“D” grade) with accuracy
of fraud. This is a core course in the Bookkeeping Certificate program.          of five or fewer errors. A grade of “C” or better is required in BOA 133
Lecture: 2 hours                                                                 in order to graduate from the BOA program.
Prerequisite: BOA 111         Lab fee: $2.00                                     Lecture: 2 hours – Lab: 2 hours
                                                                                 Prerequisite: “C” grade or better in BOA 132         Lab fee: $3.00
BOA 121 Records Management (A, W, SP)                          3 credits
This course is designed to provide knowledge of efficient management             BOA 138 Computer Transcription (SP)                            3 credits
of electronic and manual business records, ARMA filing methods and               This course is designed to develop skill in the use of machine transcrip-
systems, and principles for the selection of records systems and supplies.       tion equipment. Final form copy is the goal in transcribing audio tapes
Any DEV classes needed should be taken before scheduling BOA 121.                of business correspondence, technical reports, drafts, and other business
Lecture: 2 hours – Lab: 2 hours                                                  communications in a broad range of business formats. Emphasis on
Prerequisites: BOA 189 Access Modules 1 and 2           Lab fee: $5.00           the fundamentals of English in grammar, spelling, and vocabulary will
                                                                                 reinforce transcription skills. Recommended: Students should complete
BOA 125 Outlook (A, SP, DL)                                   3 credits          BOA 101 before taking this course.
This course is a desktop information management application using Mi-            Lecture: 2 hours – Lab: 2 hours
crosoft Outlook software. Students will learn problem-solving techniques         Prerequisite: BOA 132 Corequisite: BOA 133            Lab fee: $5.00
to organize and manage a variety of tasks, such as file management,
calendar, e-mail, contacts, tasks, and journals. The goal of this course         BOA 139 Keyboarding Improvement (A, W, SP, SU, DL) 1 credit
is to promote independent problem-solving proficiency while working              This elective course is designed to provide students with increased skill
simultaneously as a member of an office team. Prior computer experience          in the use of the keyboard by touch. Students need to be able to key by
is strongly recommended.                                                         touch from text at least 40 wpm with reasonable accuracy, using correct
Lecture: 2 hours – Lab: 2 hours                                                  finger placement. The emphasis will be on speed and accuracy using
Prerequisites: BOA 105 and 191 (or BOA 191A and BOA 191B)                        straight-copy material, time writings, and drills. The grading system is
Lab fee: $3.00                                                                   Satisfactory or Unsatisfactory.
                                                                                 Lab: 2 hours      Prerequisite: BOA 132 or permission from instructor
BOA 131 Intro. to Keyboarding (A, W, SP, SU, DL)                   3 credits     Lab fee: $2.00
BOA 131 is an introductory interactive system of keyboarding, teaching
the “touch” system of typing. Development of basic keyboarding skills            BOA 150 Office Procedures I (A, SP)                               3 credits
is measured in words per minute and accuracy of one error per minute.            This foundation course will provide continuity and integration with all
To receive credit for this course, students must complete all keyboarding        BOA courses by focusing on the essential knowledge, skills, abilities,
lessons in assigned text and demonstrate ability to key at least two different   qualities, and attitudes that are critical for success in an office environ-
two-minute timings, each with a minimum speed of 25 words a minute               ment. In addition to soft skills, students will learn to plan business meet-
(“D” grade) and accuracy of two or fewer errors. Students must earn a            ings and travel as well as organizing a workplace environment. The third
“C” grade or better as a prerequisite for BOA 132 Document Formatting            component of this course will introduce students to development of an
and Skill Building I.                                                            electronic portfolio. This electronic portfolio will be integrated into all
Lecture: 2 hours – Lab: 2 hours                                                  courses in the curriculum.
Lab fee: $3.00                                                                   Lecture: 2 hours – Lab: 2 hours         Lab fee: $5.00

BOA 132 Document Formatting and Skill Building I                                 BOA 151 Office Procedures II (W, SU)                          3 credits
(A, W, SP, SU, DL)                                           3 credits           As a continuation of BOA 150 Office Procedures I, this course covers
BOA 132 presents an intermediate interactive system reinforcing                  additional topics essential to the success of an office employee and will
keyboarding skills by touch. Applications using Microsoft Word are               continue to provide continuity and integration with all BOA courses and
designed to teach formats for business correspondence, tabulations, and          curriculum. This course will emphasize business information and financial
manuscripts with emphasis on correct techniques, proofreading, decision-         systems, managing office records, preparing and delivering presentations,
making skills, and accuracy; further development of keyboarding speed            teamwork in the workplace, planning and advancing your career, and
measured in words per minute and accuracy of one error per minute on             professional development.
three-minute timings. To receive credit for this course students must            Lecture: 2 hours – Lab: 2 hours
demonstrate assigned formatting skills and be able to key at least two           Prerequisite: BOA 150        Lab fee: $5.00
BOA 167 Desktop Publishing (A, SP)                               3 credits    BOA 188B PowerPoint Module 2 (A, W, SP, SU, DL)                 1 credit
This course utilizes a desktop publishing software program widely used        This course is a continuation of introductory features/functions using
to design sophisticated publications. This course begins with the basics      Microsoft PowerPoint presentation software. Students will learn to add
and builds upon this knowledge to demonstrate how to work with text           visual appeal, animation, and visual elements to PowerPoint presentations.
frames and layers, format text, apply styles, add graphics, and much more.    Recommended: Keyboarding and computer experience.
It is recommended that students taking this course possess the follow-        Lecture: 0 hours – Lab: 2 hours
ing skills: 35 words per minute keyboarding, computer experience, and         Prerequisite: BOA 188A        Lab fee: $5.00
facility with word processing software.
Lecture: 2 hours – Lab: 2 hours        Lab fee: $5.00                         BOA 189 Access (Modules 1 and 2) (A, W, SP, SU)                  2 credits
                                                                              This is a foundation course using Microsoft Access database software.
BOA 172 Excel (Modules 1 and 2) (A, W, SP, SU)               2 credits        Students will learn to create and modify database tables, create data forms
This is a foundation course using Microsoft Excel software. Students          and queries, generate reports, and use database wizards. Recommended:
will explore Excel features and functions used in business applications.      Keyboarding and computer experience.
Students will learn to plan and create worksheets, modify and maintain        Lecture: 1 hour – Lab: 3 hours        Lab fee: $5.00
worksheets, insert formulas, create charts, and enhance the display of
workbooks. Recommended: Keyboarding and computer experience.                  BOA 189A Access Module 1 (A, W, SP, SU, DL)                    1 credit
Lecture: 1 hour – Lab: 3 hours      Lab fee: $5.00                            This is an introductory course in Microsoft Access database software.
                                                                              Students will learn to create, modify, and enhance tables in a database.
BOA 172A Excel Module 1 (A, W, SP, SU, DL)                    1 credit        Recommended: Keyboarding and computer experience.
This is an introductory course in Microsoft Excel spreadsheet software.       Lecture: 0 hours – Lab: 2 hours       Lab fee: $2.00
Students will learn to create a worksheet, modify worksheets, and create
formulas. Recommended: Keyboarding and computer experience.                   BOA 189B Access Module 2 (A, W, SP, SU, DL)                    1 credit
Lecture: 0 hours – Lab: 2 hours       Lab fee: $2.00                          This is a continuation of Microsoft Access database software features
                                                                              and functions. Students will learn to modify tables, create forms, create
BOA 172B Excel Module 2 (A, W, SP, SU, DL)                   1 credit         reports, and use database wizards.
This is a continuation of introductory and intermediate skills using          Lecture: 0 hours – Lab: 2 hours
Microsoft Excel spreadsheet software. Students will learn to move data        Prerequisite: BOA 189A       Lab fee: $5.00
within and between workbooks, maintain workbooks, create charts in
Excel, and enhance the display of workbooks.                                  BOA 190A Access Module 3 (A, W, SP, SU, DL)                     1 credit
Lecture: 0 hours – Lab: 2 hours                                               This is a course using intermediate features/functions of Microsoft Access
Prerequisite: BOA 172A      Lab fee: $5.00                                    database software. Students will learn to create and modify advanced
                                                                              tables, create and modify forms, refine queries, and use advanced report
BOA 173A Excel Module 3 (A, SP, DL)                              1 credit     features.
This is a course using intermediate features/functions of Microsoft Excel     Lecture: 0 hours – Lab: 2 hours
spreadsheet software. Students will learn to format worksheets using ad-      Prerequisite: BOA 189B        Lab fee: $5.00
vanced formatting techniques, work with templates and workbooks, use
advanced features for financial, math, statistical, and logical functions.    BOA 190B Access Module 4 (A, W, SP, SU, DL)                   1 credit
Students are responsible for the software in this distance-learning course.   This is a course using intermediate and advanced features/functions of
Lecture: 0 hours – Lab: 2 hours                                               Microsoft Access database software. Students will learn to use Access
Prerequisite: BOA 172B         Lab fee: $5.00                                 tools, create database applications, and use data from the Internet and
                                                                              other sources.
BOA 173B Excel Module 4 (A, SP, DL)                              1 credit     Lecture: 0 hours – Lab: 2 hours
This is a course using intermediate and advanced features/functions of        Prerequisite: BOA 190A       Lab fee: $5.00
Microsoft Excel spreadsheet software. Students will learn to use Excel’s
analysis tools, manage and audit worksheets, collaborate with workgroups,     BOA 191 Word I (Modules 1 and 2) (A, W, SP, SU)              2 credits
and use data from the Internet and other sources. Students are responsible    This is a foundation course using Microsoft Word software. Students will
for the software in this distance-learning course.                            learn to create, modify and maintain documents, format and customize
Lecture: 0 hours – Lab: 2 hours                                               documents, create tables and charts, and enhance documents with spe-
Prerequisite: BOA 173A         Lab fee: $5.00                                 cial features. Students must earn a “C” grade or better in BOA 191 as a
                                                                              prerequisite for BOA 192 Word II. Recommended: Keyboarding skill of
BOA 188 PowerPoint (Modules 1 and 2) (A, W, SP, SU) 2 credits                 at least 35 words per minute and computer experience.
This is a foundation course using Microsoft PowerPoint presentation           Lecture: 1 hour – Lab: 3 hours       Lab fee: $5.00
graphics software. Students will learn to create and enhance slide pre-
sentations using clipart, charts, photographs, videos, and sound. More        BOA 191A Word Module 1 (A, W, SP, SU, DL)                      1 credit
advanced visual elements and animation are also incorporated in this          This is an introductory course using Microsoft Word software. Students
course. Recommended: Keyboarding and computer experience.                     will learn to create and edit a document, format documents, arrange text,
Lecture: 1 hour – Lab: 3 hours      Lab fee: $5.00                            and use simple graphics. Recommended: Keyboarding and computer
                                                                              experience.
BOA 188A PowerPoint Module 1 (A, W, SP, SU, DL)                 1 credit      Lecture: 0 hours – Lab: 2 hours       Lab fee: $2.00
This is an introductory course to Microsoft PowerPoint presentation
graphics software. Students will learn the fundamentals of creating and       BOA 191B Word Module 2 (A, W, SP, SU, DL)                     1 credit
enhancing a presentation using clip art, charts, photographs, videos, and     This is a continuation of features and functions using Microsoft Word
sound. Recommended: Keyboarding and computer experience.                      software. Students will learn to modify and maintain documents, custom-
Lecture: 0 hours – Lab: 2 hours Lab fee: $2.00                                ize documents, create tables and charts, and enhance documents with
                                                                              special features. Recommended: Keyboarding and computer experience.
                                                                              Lecture: 0 hours – Lab: 2 hours
                                                                              Prerequisite: BOA 191A         Lab fee: $5.00
BOA 192 Word II (Modules 3 and 4) (A, W, SP, SU)                2 credits        complete an electronic portfolio and participate in a community service
Provides additional skills and refines techniques presented in BOA 191.          project related to the program of study.
This is an intermediate and advanced level course using Microsoft Word           Students must earn a “C” grade or better in BOA 250 in order to graduate
software. Students will learn to merge documents, sort and select data,          from the BOA program.
format with special features, add visual elements, and format using macros       Lecture: 2 hours – Lab: 4 hours
and styles. Students will learn how to work with shared documents, share         Prerequisites: BOA 101, 111, 121, 133, 151, and 195
data, and create specialized tables and indexes. Recommended: Key-               Lab fee: $3.00
boarding skill of at least 35 words per minute and computer experience.
Lecture: 1 hour – Lab: 3 hours                                                   BOA 270 Business Office Applications Practicum (A, SP) 2 credits
Prerequisite: “C” grade or better in BOA 191         Lab fee: $5.00              The practicum is a professional field experience program designed to
                                                                                 provide the student with an opportunity to work in a professional office
BOA 192A Word Module 3 (A, W, SP, SU, DL)                    1 credit            environment. This opportunity allows students to integrate the theory
This is an intermediate course using Microsoft Word software. Students           and knowledge of course content with the application of principles and
will learn to customize paragraphs and pages, sort and insert Building           practices in a work environment.
Blocks, format with special features, add visual elements, and format            Lecture: 0 hours – Lab: 14 hours
using macros and styles.                                                         Prerequisites: BOA 101, 121, 133, 151, and 195
Lecture: 0 hours – Lab: 2 hours                                                  Corequisite: BOA 271         Lab fee: $5.00
Prerequisite: BOA 191B       Lab fee: $5.00
                                                                                 BOA 271 Business Office Applications Practicum Seminar
BOA 192B Word Module 4 (A, W, SP, SU, DL)                     1 credit           (A, SP)                                                         2 credits
This is an intermediate/advanced course using Microsoft Word software.           This seminar provides opportunities for discussion and activities related to
Students will learn how to work with shared documents, share data, create        a business office environment. Students will discuss the work experience
specialized tables and indexes, and use XML in Word.                             and demonstration of ability to transfer program skills and technology
Lecture: 0 hours – Lab: 2 hours                                                  to an office environment. Students will prepare weekly reports and com-
Prerequisite: BOA 192A        Lab fee: $5.00                                     plete work-related projects and assignments. This course must be taken
                                                                                 as a corequisite with BOA 270 Business Office Applications Practicum.
BOA 193 Word III (A, W, SP, SU, DL)                                3 credits     Lecture: 2 hours – Lab: 0 hours
This is an advanced level course using Microsoft Word software. Rein-            Corequisite: BOA 270
forcement of important design concepts such as consistency, focus, bal-          Prerequisites: BOA 101, 111, 121, 133, 151, and 195
ance, directional flow, contrast, color, proportion, legibility, and readabil-   Lab fee: $5.00
ity will be emphasized. Students will learn to create professional-looking
business documents in the form of letterheads, business cards, calendars,        BOA 297 Special Topics in Business Office Applications
certificates, newsletters, brochures, booklets, and forms.                       (On Demand)                                                 1– 3 credits
Lecture: 2 hours – Lab: 2 hours                                                  BOA 297 provides an opportunity for detailed examination of selected
Prerequisite: “C” grade or better in BOA 192         Lab fee: $5.00              topics of interest in office applications and administration.
                                                                                 Lecture: Varies – Lab: Varies
BOA 195 Office Integration I (A, W, SP, SU, DL)                1 credit          Prerequisite: Varies      Lab fee: $3.00
This course offers intermediate and advanced features to integrate Word,
Excel, PowerPoint, Access, and Outlook applications. Students will learn
to join office applications that work together.
Lecture: 0 hours – Lab: 2 hours
Prerequisites: BOA 192A, 173A, 188B, 189B         Lab fee: $3.00

BOA 196 Office Specialist Review I (A, SP, DL)               1 credit
This course is designed for students who have completed Word, Excel,
PowerPoint, and Access modules 1 and 2. The course will provide stu-
dents with a structured review and hands-on practice using Word, Excel,
PowerPoint, and Access features and functions in preparation for office
systems certification.
Lecture: 0 hours – Lab: 2 hours
Prerequisites: BOA 172B, 188B, 189B, 191B
Lab fee: $3.00

BOA 197 Office Specialist Review II (A, SP, DL)            1 credit
This course is designed for students who have completed Word, Excel,
and Access modules 1 through 3, PowerPoint modules 1 and 2, and
Outlook. The course will provide students with a structured review
and hands-on practice using Word, Excel, PowerPoint, and Access, and
Outlook intermediate and advanced features in preparation for office
systems certification.
Lecture: 0 hours – Lab: 2 hours
Prerequisite: BOA 196       Lab fee: $3.00

BOA 250 Capstone (A, SP)                                     4 credits
This capstone course provides a hands-on application environment
where students work in teams to plan, develop, implement, and present                          It’s where the world is going.
automated business and financial office applications. Students will also                      614/287-5353 • www.cscc.edu

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:6
posted:8/6/2011
language:English
pages:6