The Administrative Office Specialist certificate is designed to prepare students for entry-level clerical positions in the business office.
The program offers a series of skill-building courses with related courses in administrative office procedures and information processing.
ACC 121. Introductory Accounting (3). General ledger bookkeeping and preparing financial statements. Three lecture.
1. Analyzing and recording transactions: general journal and general ledger
2. Trial balance and adjusting entries
3. Financial statements
4. Closing entries and post-closing trial balance
5. The accounting cycle for a merchandising concern – periodic inventory method
6. Cash accounting and banking procedures
7. Sales and cash receipts
8. Purchases and cash payments
9. Ethics in accounting
1. Use generally accepted accounting principles to perform general ledger bookkeeping for a service business. (1, 2, 4, 6)
2. Analyze and record financial transactions into a general ledger bookkeeping system for a merchandising concern. (5-8)
3. Prepare general-purpose financial statements for service and merchandising concerns. (3, 5)
4. Prepare a bank reconciliation report. (6)
5. Appraise financial scenarios for ethical concerns. (9)
BSA 105. Business English (3). Developing or reviewing good language skills for occupational purposes. Covers spelling, punctuation, capitalization, sentence structure and word usage. Utilizes business-oriented materials. Prerequisite: Reading Proficiency. Three lecture.
1. Basic language skills
c. Word usage
d. Numbers in business
2. Business vocabulary
3. Business correspondence
b. Parts of a business letter
1. Define more than 100 business terms.
2. Master a spelling list emphasizing business terms.
3. Demonstrate basic grammar and punctuation skills.
4. Identify the parts of a business letter and envelope.
5. Select appropriate salutations and closings.
6. Demonstrate techniques of paragraphing a business letter.
||Admin Office Management
BSA 225. Administrative Office Management (3). Office management including management of administrative office resources, supervision and staffing issues, and filing and records management practice. Three lecture.
1. The administrative office
a. administrative functions
b. organizational objectives
c. internal and external communication
d. financial functions
e. meetings and events
2. Office resources
a. office layout
b. equipment and furniture
c. computer systems
d. office productivity
3. Information and records management
a. filing systems
b. retention and disposition of records
c. database management
d. forms control
4. Management of office employees
a. recruitng and hiring
d. motivational techniques
e. performance appraisals
5. Career opportunities
1. Develop policies and procedures for the administrative office. (1-4)
2. Plan and coordinate meetings, special events, and travel arrangements. (1)
3. Design an effective office environment. (2)
4. Develop an information management plan for the administrative office. (3)
5. Identify the skills needed for leadership of a diverse workforce. (4)
6. Research career opportunities for office managers in all types of companies. (5)
BSA 233. Business Communications (3). Communication theory, writing for the workplace, business letters and reports, electronic communication, professional presentations and communicating for employment. Prerequisite: Reading Proficiency. Three lecture.
1. Communication foundations
a. process of communication
b. verbal and nonverbal communication
c. using words effectively
2. Written communication in the workplace
a. positive and negative messages
b. persuasive writing
3. Letters and reports
a. business letter formats
b. short reports
4. Electronic media and communication
a. email messages
b. communicating with new technology
c. social networking in the workplace
5. Professional presentations
a. oral presentations
b. public speaking skills
c. presentation software
6. Communicating for employment
a. resume and cover letter
b. interview preparation
1. Identify the elements of effective communication. (1)
2. Create purposeful written messages to a specific business audience. (2)
3. Compose business letters and short reports to communicate information or data. (3)
4. Identify methods of communication using the latest technology. (4)
5. Prepare and deliver an oral presentation. (5)
6. Compose a professional resume and employment cover letter. (6)
CSA 111. Keyboarding (1). Presentation of the keyboard including the 10-key pad by touch. Development of correct techniques for a variety of applications including word processing, computer programming, data entry, and computer interaction. One lecture.
1. Alphabetic keyboarding
2. Numeric keyboarding
3. Skill development
1. Employ keyboarding techniques and posture. (1, 3)
2. Use touch system techniques when operating alphabetic keys. (1, 3)
3. Use touch system when operating the 10-key numerical pad. (2)
4. Produce copy at 25 words per minute with no more than one error per minute. (1, 3)
||Keyboarding Skill Building
CSA 112. Keyboarding Skill Building (1). Improving keyboarding speed and accuracy. Emphasis on techniques and strategies for job-related keyboarding proficiency. Prerequisite: CSA 111. One lecture.
1. Diagnostic testing
2. Keyboarding kill building techniques
3. Speed drills
4. Accuracy drills
5. Timed writings
1. Show a minimum of 15% improvement in key stroking rate and accuracy. (1-5)
||Microsoft Word Desktop Publish
CSA 134. Microsoft Word Desktop Publishing (2). Desktop Publishing using advanced Microsoft Word feature to plan, define, and incorporate desktop publishing concepts and the design and creation of business and personal documents. Prerequisite: CSA 140 . One lecture. Three lab.
1. Understanding the desktop publishing process
2. Planning and creating letterheads, envelopes, business cards, resumes, and certificates
3. Planning and creating promotional documents such as flyers, brochures and gift certificates
4. Planning and creating web pages
5. Planning and creating publications such as newsletters, reports, and manuals
1. Produce internal business documents such as memos, agendas, press releases, and fax cover sheets with a variety of typefaces, type styles, type size, and special symbols.
2. Produce business letterheads, envelopes, and business cards using a variety of templates, fonts, and ruled lines.
3. Create resumes, calendars, personal address labels, and certificates.
4. Produce promotional documents such as flyers, brochures and announcements using Word's Tables and Borders toolbar, Picture toolbar, Drawing toolbar, Picture Editor, Word Art, and Autoshapes.
5. Create specialty promotional documents, such as gift certificates, postcards, name tags, business greeting cards, and invitations.
6. Create a Web home page with hyperlinks using Microsoft Word and apply basic desktop publishing concepts to the layout and design of the Web page.
7. Create newsletters using Word features such as columns and styles and design elements, such as masterheads, sidebars, pull quotes, kickers, jump lines, and color.
8. Prepare reports, term papers, manuals, and forms containing elements such as a cover page, table of contents, title page, and indexes.
CSA 140. Microsoft Word (2). Practical application of Microsoft Office Word. Practical application of Microsoft Office Word. Emphasis on creating and formatting content, working with visual content, and organizing documents. Two lecture.
2. Graphics and Watermarks
3. Headers and Footers
4. Merged Documents
5. Tables and Charts
6. Footnotes and Endnotes
7. Tables of Content and Figures
12. Web Pages
13. Links and Embeds Between Applications
14. Text and Paragraph Formatting
15. Page Setup
1. Create office documents using basic and advanced formatting features. (1-17)
2. Create templates. (10)
3. Create merged documents. (4)
4. Create forms. (11)
5. Create web pages. (12)
6. Create linked or embedded documents. (13)
CSA 138. Microsoft Excel (2). Practical application on the basic functions of Microsoft Office Excel. Emphasis on creating worksheets for data input and analysis. Two lecture.
1. Data entry and analysis
2. Formulas and functions
4. Headers and footers
6. Charts and graphs
8. Pivot tables
9. Web pages
11. Links and embeds between applications
1. Create worksheets containing data and formulas. (1-2)
2. Create worksheets with advanced features. (3-11)
3. Format and analyze data. (11-14)
4. Format, modify, and organize worksheets. (12-14)
CSA 139. Microsoft Access (2). Practical application of Microsoft Access. Emphasis on relational databases and query design to summarize and analyze information. Two lecture.
1. Relational Databases
5. Fields and Records
6. Table Properties
7. Field Properties
8. Data Sorts and Filters
9. Data Analysis
10. Report Printing
11. Import and Export of Data
1. Create relational databases. (1, 5-7)
2. Create queries to manage and analyze data. (2, 8-9)
3. Create data entry forms. (3)
4. Create reports to detail selected information. (4, 8-10)
5. Import and Export data. (11)