You are here: Home instructional_framework official_framework Business and Information Technology Education Fundamentals of Administrative Technologies
Navigation
Log in


Need a new SSL certificate?
 

View Career Major Course

Course Information
Business and Information Technology Education
BT00014
Fundamentals of Administrative Technologies
120.00
This course builds on the core business skills and will provide students with the concepts, principles, and attitudes needed to understand how an office is operated and managed in a rapidly changing global environment. State-of-the-art personal computing is integrated throughout the course.
Jaclyn Arnold
(405) 743-5419
jaclyn.arnold@careertech.ok.gov
Fundamentals of Technology or Business and Computer Technology
OFFICE PROCEDURES
Correspondence (35 Hours)
-Prepare and format effective business documents including, envelopes, letters, reports,faxes, e-mail, outlines, footnotes/endnotes, and minutes.
-Demonstrate knowledge of general mail procedures, including the different classes of mailings, sorting, and distribution of mail.

Customer Service
- Effectively apply conflict resolution techniques when dealing with internal customers as well as external customers.
-Demonstrate appropriate telephone etiquette when providing customer service, including appropriate manners when handling irate customers.

Filing
-Demonstrate the ability to effectively use the many types of filing systems, including subject, standard alphabetic, and numeric.

Organization
-Use appropriate procedures to effectively prioritize and manage time, projects, and resources.
-Apply appropriate business math skills to prepare business forms and complete financial transactions.

Reading Comprehension
-Demonstrate effective use of proofreading skills, including spelling, grammar, proofreading marks, and charts/graphs.

Scheduling
-Demonstrate proper parliamentary procedure and effectively plan a meeting.
-Use appropriate procedures and resources to make travel arrangements, including preparing/securing travel documents, creating itineraries, and providing appropriate confirmations.

Terminology
-Identify and/or demonstrate the ability to use appropriate and effective language, resources, and organizations needed in an office environment.

TELEPHONE ETIQUETTE
Communication (5 Hours)
-Identify common barriers to open communication.
-Identify appropriate customer care representative behaviors.
-Distinguish between idle conversation and dialogue.
-Demonstrate ability to determine customer expectations.
-Demonstrate ability to use fact-finding techniques.
-Demonstrate proper phone etiquette and techniques.-conference calls, voice mail, pagers, video conferencing, transferring calls, ending calls, taking messages, screening calls, placing callers on hold, and using cell phones.

Answering Phones
-Demonstrate proper technique for beginning and ending calls.
-Identify methods for showing customer empathy.
-Identify methods to build customer goodwill.
-Demonstrate methods for dealing with difficult callers.

Customers
-Describe the importance of behavioral styles as it applies to telephone techniques.
-Describe the components of an ideal customer service environment.

Telephone Equipment
-Define and describe the following types of telephone equipment: speaker phone, multi-line phones, conference calls, video conference calls, and wireless communication devices.

Terminology
-Define branding.
-Define customer service effectiveness.
-Define screening call.
-Define the phrase "our customers are blind".

Handling the Call
-Demonstrate fact-finding techniques.
-Differentiate when to use open and closed-ended questions.
-Model positive impression using proper communication techniques.

Professionalism
-Demonstrate proper word choice when dealing with customers.
-Demonstrate proper techniques when transferring calls.

Develop and Demonstrate Objective and Active Listening Skills, and Telephone Personality
-Demonstrate appropriate voice quality.
-Define the four standard behavioral styles: decisive, inquisitive, rational, and expressive.
-Demonstrate techniques for handling difficult customers.

Listening
-Define the following listener types: active, passive, cohesive, constructive, emotive.
-Demonstrate the ability to listen for meaning.
-Define the following barriers to effective listening: psychological, social, sensory, organizational, emotional, bias, difficult customer, physical, preoccupation, and hearing loss.


WORD PROCESSING FUNDAMENTALS
Revising and Printing (40 Hours)
-Perform editing (e.g., cut, copy, and move information).
-Specify print options and print files.
-Set printing options for templates with fields.
-Set printing options to manage print jobs.
-Set page orientation.
-Check spelling/grammar.
-Set specialized language options.
-Identify Office Clipboard default settings.
-Utilize functions available on the task pane.

Shortcuts
-Identify and use keyboard shortcuts.
-Select text (word,line, paragraph, document) using various methods (e.g., mouse clicks, click and drag, or keyboard combinations).
-Identify templates available in Word.
-Use wizards and templates to create documents.
-Use templates and add-ins to identify styles.
-Set and modify Smart Tag options.

Formatting
-Format text for font,style, size, color, underline, effects and spacing.
-Format and modify margins.
-Apply borders and shading to paragraphs.
-Format and modify line and page breaks.

Word Processing General Knowledge
-Identify View formats.
-Use Views to display Headers/Footers.
-Identify shading types.
-Format text wrapping for clipart, shapes and text boxes.
-Identify default settings for Office Assistant.
-Identify toolbars andtoolbar buttons.
-Display, hide and modify toolbars.

Advanced Features
-Identify types of mail merge.
-Create a mail merge main document and data source.
-Identify other types of files that may be used in a mail merge.

Page Layout
-Set and edit tabs.
-Identify tab types.
-Format and modify table structure.
-Create, edit, apply and delete styles.
-Identify on-screen formatting information including breaks, paragraphs markers and tabs.
-View styles applied to a document.

Document Creation
-Open previously created documents and identify components of the open window.
-Save files in specified locations and formats and identify components of the save window.
-Insert breaks (e.g., page, column, text wrapping, and section).
-Format multicolumn layouts.
-Modify text case using Change Case option.
-Use find/replace function.
-Locate and identify items in the drop down menus.

SPREADSHEET FUNDAMENTALS
Charts (40 Hours)
-Identify fill effect options for chart titles.
-Insert a chart using the chart wizard.
-Insert and modify charts in a worksheet.
-Be able to identify if a presented chart accurately represents worksheet data show in a table.
-Insert a legend.
-Apply fill effects to a chart background.
-Insert and modify a PivotChart.
-Add titles to various areas on a chart.

Data Entry
-Modify reference to an external data link.
-Enter data into a worksheet using a Data Form.
-Use Spell-check.
-Accept labels in formulas (change numbers to text).
-List allowable characters for naming cells.
-Create and use defined names in formulas instead of cell references.
-Name the filename that stores the custom dictionary information. (CUSTOM.DIC)

Data Manipulation
-Apply Merge & Center formatting.
-Sort worksheet data.
-Apply borders and shading for a cell.
-Apply validation criteria to restrict data entry of a cell.
-List the allowable types of criteria for validating data.
-Insert and modify data.
-Apply and use various AutoFilter commands.
-Convert text from uppercase to lowercase.
-Identify & change number formats, including currency, date & time, percentage formats,and scientific notation.
-Apply conditional formatting to a range of cells.
-Filter data in place using the Advanced Filter command.
-Use the Paste Special command to transpose a range of data from a column to a row.

Formulas/Functions
-Use SEARCH.
-Use Error Checking.
-Insert arithmetic formulas into worksheet cells.
-Use common worksheet functions (e.g. SUM, AVERAGE, COUNT, DATE, IF, MID).
-Use iteration command.

Graphics
-Identify various diagram types.
-Identify default media file types.
-Apply shadow effects for an object.

Software Interface
-Use interactive worksheet components.
-Switch between sheets in an interactive workbook.
-Use the Research Task Pane.
-Apply formatting to interactive worksheets.
-Protect a shared workbook.
-Use the Freeze Pane command.
-Identify common buttons of the Formatting toolbar.
-Reset toolbar usage data.
-Share workbooks and remove a user from a workbook.
-Rename a worksheet.
-Print comments in a worksheet.
-Identify common buttons on the External Data Toolbar.
-Insert objects in custom headers or footers.
-Set and clear Print Areas.
-Print spreadsheet gridlines.
-Activate and de-activate ScreenTips.
-Use the Compare Side by Side toolbar to reset widow positions.
Microsoft Office Specialist: Word and Excel

Required Brainbench Certifications (or equivalent industry certifications):
Word (any level)
Excel (any level)
Telephone Etiquette
Office Procedures

Recommended Additional Brainbench Competency Testing:
MS PowerPoint (any level)
Customer Assistance
Listening Skills
MS Outlook
MS Access (any level)
Filing
Data Entry/10-key
Microsoft Office Specialist: Word and Excel
Brainbench: http://www.okcareertech.org/educators/assessments-and-testing/brainbench-testing
Textbooks:
A Guide to Microsoft Office 2013, Lawrenceville Press, Paradigm.
Benchmark Series: Microsoft Office (2010 or 2013), Paradigm.
Benchmark Series: Microsoft Excel (2010 or 2013) Levels 1, Paradigm.
Benchmark Series: Microsoft PowerPoint (2010 or 2013), Paradigm.
Benchmark Series: Microsoft Word (2010 or 2013) Levels 1 and 2, Paradigm.
Business Communications, Cengage Learning.
Business Principles and Management, Cengage Learning.
Interpersonal Skills, Marlene Caroselli, South-Western.
Microsoft Excel 2013: Comprehensive, Cengage Learning.
Microsoft Excel 2013: Comprehensive, Labyrinth Learning with eLab Course Management System.
Microsoft Office 2007: Advanced Concepts and Techniques, Cengage Learning.
Microsoft Office 2010: Advanced, Cengage Learning.
Microsoft Word 2013: Comprehensive, Cengage Learning.
Microsoft Word 2013: Comprehensive, Labyrinth Learning with eLab Course Management System.
Micrsoft Office 2013: Advanced, Shelly Cashman Series, Cengage Learning.
MindTap Computing Instant Access for Hunt's Enhanced Microsoft Office 2013: Ilustrated Fundamentals, Cengage.
Procedures & Theory for Administrative Professionals, Cengage Learning.
SNAP Web-Based Training and Assessment 2013, Paradigm.
SoftSkills Solutions program, JIST Publishing through Paradigm, www.JIST.com/irc/softskills.
The Office: Procedures and Technology, Cengage Learning - Student Activities and Simulations.
The Office: Procedures and Technology, Cengage Learning.
The World of Customer Service, Cengage Learning.

Business Management and Administration Career Cluster:
http://careertech.org/business.

ctYou.org Resources by Subject:
http://ctyou.org/mod/book/view.php?id=1268

Free Resources:
Microsoft Office 2010: Ultimate Tips and Tricks, Matt Smith. http://freecomputerbooks.com/Microsoft-Office-2010-Ultimate-Tips-and-Tricks.html.
GCF LearnFree: www.gcflearnfree.org.
Microsoft Office Reference Guide: http://freecomputerbooks.comMicrosoft_Office_Reference_Guide.html.
Microsoft: http://office.microsoft.com/en-us/training/.
What's New in Office 2013 - Your Unofficial Overview: http://freecomputerbooks.tradepub.com/free/w_make101/?p=w_make101.

Interactive Tools:
MindTap, Cengage Learning.
SAM, Cengage Learning.
SNAP, Paradigm.

Reference:
Gregg College Keyboarding & Document Processing, with Microsoft Word 2013, Ober, Johnson, Zimmerly, McGraw-Hill.
Gregg Reference Manual, McGraw-Hill.
Gregg Reference Manual - Basic Worksheets, McGraw-Hill.
http://www.lynda.com/
http://www.myinterpersonal.com/interpersonal-communication.html
Yes
8103
Yes
Yes
Yes
Career Majors That Sequence This Course
Career Cluster Pathway Career Major
Finance Accounting Accounts Payable/Receivable Clerk
Business Management & Administration Administrative Support Administrative Assistant
Business Management & Administration Administrative Support Administrative Medical Assistant
Business Management & Administration Administrative Support Bilingual Customer Service Representative
Business Management & Administration Administrative Support Customer Service
Business Management & Administration Business Information Management Electronic Health Record Specialist (EHR Specialist)
Business Management & Administration General Management Entrepreneur
Business Management & Administration Administrative Support Executive Administrative Assistant
Business Management & Administration Administrative Support Executive Administrative Assistant I
Finance Business Finance Financial Assistant
Finance Accounting Financial Clerk
Finance Banking Services Financial Customer Service
Finance Accounting Full Charge Bookkeeper
Hospitality & Tourism Lodging Hospitality and Tourism Manager
Business Management & Administration Human Resources Management Human Resources Assistant
Finance Insurance Insurance Customer Service Representative-Life and Health
Finance Insurance Insurance Customer Service Representative-Property & Casualty
Business Management & Administration Business Information Management Medical Coding
Business Management & Administration Business Information Management Medical Insurance Coder
Business Management & Administration Administrative Support Medical Office Assistant
Business Management & Administration Administrative Support Medical Transcriptionist
Business Management & Administration Administrative Support Microsoft Office Specialist
Business Management & Administration Administrative Support Office Information Specialist
Finance Accounting Payroll Accounting Clerk
Business Management & Administration Administrative Support Project Administrative Assistant
Transportation, Distribution & Logistics Warehousing and Distribution Center Operations Warehouse Distribution/Logistics Technology Specialist