Complete List of Tests and Associated KSAs Included in OPAC Version 9
- Microsoft® Excel 2000 Pre-Assessment
- Knowledge of areas of Microsoft® Excel 2000 that are commonly tested during certification exams.
- Microsoft® Excel XP Pre-Assessment NEW!
- Knowledge of areas of Microsoft® Excel XP that are commonly tested during certification exams.
- Microsoft® Excel [Basic]
- Skill in manipulating financial data and text within various cells and spreadsheets.
- Skill in sorting data according to criteria that will organize the data in various structures.
- Skill in relocating and reworking data in an existing Microsoft® Excel document.
- Skill in formatting/editing data in an existing Microsoft® Excel document.
- Microsoft® Excel [Intermediate]
- Skill in sorting data according to criteria that will organize the data in various structures.
- Skill in adding headers to an existing Microsoft® Excel document.
- Skill in creating/moving existing worksheets.
- Skill in creating charts using data provided in an existing Microsoft® Excel document.
- Skill in renaming worksheets to custom naming conventions.
- Skill in inserting comments on cells within an existing Microsoft® Excel document.
- Skill in hiding and unhiding rows within an existing Microsoft® Excel document.
- Microsoft® PowerPoint
- Skill in creating new presentations from blank document.
- Skill in adding hyperlinks within an existing presentation that direct users to various locations.
- Skill in changing the background texture/color of existing Power Point slides.
- Skill in modifying, transitioning, and animating elements of a slide or presentation.
- Skill in inserting and modifying graphics within an existing presentation.
- Skill in adding speakers notes to existing slides within a presentation.
- Microsoft® Windows
- Skill in navigating through and customizing the Microsoft® Windows operating system
- Microsoft® Word 2000 Pre-Assessment
- Knowledge of areas of Microsoft® Word 2000 that are commonly tested during certification exams.
- Microsoft® Word XP Pre-Assessment NEW!
- Knowledge of areas of Microsoft® Word XP that are commonly tested during certification exams.
- Microsoft® Word [Basic]
- Skill in creating or editing text in a new Microsoft® Word document.
- Skill in formatting various aspects of the page setup in an existing Microsoft® Word
- document.
- Skill in using and constructing tables within an existing Microsoft® Word document.
- Skill in modifying text to appear with various fonts, sizes, weights and other effects.
- Microsoft® Word [Intermediate]
- Skill in using and constructing tables within an existing Microsoft® Word document.
- Skill in creating unique headers within an existing Microsoft® Word document.
- Skill in using bullets/numbers to organize text within an existing Microsoft® Word document.
- Skill in creating page sections within an existing Microsoft® Word document.
- Skill in using the auto complete function within an existing Microsoft® Word document to automatically finish typing words.
- Skill in inserting and creating footnotes within an existing Microsoft® Word document.
- Skill in inserting symbols/pictures into an existing Microsoft® Word document.
- Skill in creating borders for pages of an existing Microsoft® Word document.
- Database
- Skill in accessing and opening a specific database file.
- Skill in sorting data according to criteria that will organize the data in various structures.
- Skill in printing data from an existing database.
- Skill in saving data in an existing database.
- Skill in deleting data and tables within an existing database.
- Skill in editing data and structure within an existing database.
- Skill in appending data within an existing database.
- Skill in designing tables within an existing database.
- Editing/Formatting from a Rough Draft
- Skill in changing text within an existing electronic document to be underlined, bolded, or italicized.
- Skill in adjusting the indentation of text within an existing electronic document.
- Skill in using various alignments to position text within an existing electronic document.
- Skill in copying and deleting text within an existing electronic document.
- Skill in adjusting the page breaks within an existing electronic document.
- Skill in using the hard return function to begin a new line of text within an existing electronic document.
- Skill in inserting text, symbols, or objects into an existing electronic document.
- Skill in moving text, symbols, or objects to various locations within an existing electronic document.
- Skill in printing an existing electronic document.
- Skill in using the spell check function to identify errors and make the appropriate corrections within an existing electronic document.
- Editing/Formatting from a Rough Draft [Advanced]
- Skill in using and setting various decimal tabs in an existing electronic document.
- Skill in changing text to be double underlined within an existing electronic document.
- Skill in using the spell check function to identify errors and make the appropriate corrections within an existing electronic document.
- Skill in viewing and editing headers and footers within an existing electronic document.
- Skill in searching for and replacing specific text throughout an existing electronic document.
- Skill in changing font settings to include subscript and superscript characters to an existing electronic document.
- Skill in using the hard return function to begin a new line of text within an existing electronic document.
- Skill in aligning text to the left or right justified tab setting.
- Skill in adjusting the automatic page breaks set by the word processing program within an existing electronic document.
- Spreadsheet
- Skill in editing and deleting data within an existing spreadsheet.
- Skill in constructing and using formulas in an existing spreadsheet to manipulate data.
- Skill in inserting text, symbols, or objects into an existing spreadsheet.
- Skill in printing an existing spreadsheet.
- Skill in saving an existing spreadsheet.
- 10-Key
- Skill in quickly entering numeric data into an adding machine format.
- Skill in accurately entering numeric data into an adding machine format.
- Keyboarding
- Skill in quickly typing text from a paper or electronic document.
- Skill in accurately typing text from a paper or electronic document.
- Keyboarding 2 (This is a new Keyboarding test, specifically designed measuring the ability to perform 21st Century keyboarding tasks)
- Skill in quickly typing text from a paper or electronic document.
- Skill in accurately typing text from a paper or electronic document.
- Data Entry 1: Vendor
- Skill in quickly entering alphabetic and numeric vendor data (including addresses and telephone numbers).
- Skill in accurately entering alphabetic and numeric vendor data (including addresses and telephone numbers).
- Data Entry 2: Inventory
- Skill in quickly entering alphabetic and numeric data in an inventory format.
- Skill in accurately entering alphabetic and numeric data in an inventory format.
- Data Entry 3: Invoice
- Skill in quickly entering multiple sales orders including addresses, phone numbers, stock items and quantities.
- Skill in accurately entering multiple sales orders including addresses, phone numbers, stock items and quantities.
- Alpha Filing
- Knowledge of the English language alphabet.
- Skill in assigning correct filing names to files or groups of files.
- Skill in sorting files or groups of files in a computer-simulated filing cabinet.
- Composing Minutes
- Skill in composing and formatting minutes of a meeting or other events in which hand-written notes are taken.
- Formatting A Letter
- Skill in formatting letters with the use of instructions.
- Proofreading 1
- Skill in proofreading and identifying errors in an existing document.
- Knowledge of correct grammar in the English language.
- Knowledge of correct punctuation in the English language.
- Knowledge of correct number usage in the English language.
- Knowledge of correct spelling in the English language.
- Knowledge of correct usage of passives in the English language.
- Knowledge of correct capitalization in the English language.
- Knowledge of correct abbreviation in the English language.
- Proofreading 2
- Skill in proofreading and identifying errors in an existing document.
- Knowledge of correct grammar in the English language.
- Knowledge of correct punctuation in the English language.
- Knowledge of correct number usage in the English language.
- Knowledge of correct spelling in the English language.
- Knowledge of correct usage of passives in the English language.
- Knowledge of correct capitalization in the English language.
- Knowledge of correct abbreviation in the English language.
- Proofreading Practice
- Additional testing material for the proofreading tests.
- Practices using:
- Skill in proofreading and identifying errors in an existing document.
- Knowledge of correct grammar in the English language.
- Knowledge of correct punctuation in the English language.
- Knowledge of correct number usage in the English language.
- Knowledge of correct spelling in the English language.
- Knowledge of correct usage of passives in the English language.
- Knowledge of correct capitalization in the English language.
- Knowledge of correct abbreviation in the English language.
- Spelling
- Knowledge of correct spelling commonly used words in the English language.
- Ability to properly spell and use words according to the context in which they are employed.
- Transcription
- Skill in transcribing a letter from an audio sound file.
- Skill in listening comprehension.
- Basic Math
- Basic mathematic skill including addition, subtraction, multiplication, division and the use of decimals.
- Bank Deposit
- Basic mathematic skill including addition, subtraction, multiplication, division and the use of decimals to complete an electronic bank deposit slip.
- Ability to identify discrepancies between figures calculated in a deposit slip.
- Bank Reconciliation
- Basic mathematic skill including addition, subtraction, multiplication, division and the use of decimals to reconcile a bank account.
- Ability to identify discrepancies between figures calculated in a reconciliation.
- Petty Cash
- Basic mathematic skill including addition, subtraction, multiplication, division and the use of decimals to complete an electronic petty cash voucher.
- Ability to identify discrepancies between figures calculated in a petty cash voucher.
- Legal Keyboarding
- Skill in quickly typing text from a paper or electronic document that is similar to what would be found in a legal position.
- Skill in accurately typing text from a paper or electronic document that is similar to what would be found in a legal position.
- Legal Proofreading
- Skill in proofreading and identifying errors in a legal document.
- Knowledge of correct grammar in the English language.
- Knowledge of correct punctuation in the English language.
- Knowledge of correct number usage in the English language.
- Knowledge of correct spelling in the English language.
- Knowledge of correct usage of passives in the English language.
- Knowledge of correct capitalization in the English language.
- Knowledge of correct abbreviation in the English language.
- Legal Terminology
- Knowledge of legal terminology used by legal assistants and legal secretaries.
- Legal Transcription
- Skill in transcribing a legal document from an audio sound file.
- Skill in listening comprehension.
- Medical Keyboarding
- Skill in quickly typing text from a paper or electronic document that is similar to what would be found in a medical position.
- Skill in accurately typing text from a paper or electronic document that is similar to what would be found in a medical position.
- Medical Proofreading
- Skill in proofreading and identifying errors in a medical document.
- Knowledge of correct grammar in the English language.
- Knowledge of correct punctuation in the English language.
- Knowledge of correct number usage in the English language.
- Knowledge of correct spelling in the English language.
- Knowledge of correct usage of passives in the English language.
- Knowledge of correct capitalization in the English language.
- Knowledge of correct abbreviation in the English language.
- Medical Terminology
- Medical terminology used by medical assistants and medical support professionals.
- Medical Transcription
- Skill in transcribing a medical document from an audio sound file.
- Skill in listening comprehension.
- Sentence Clarity
- The ability to write clearly in order to communicate information effectively to others
- Telephone Customer Service NEW!
- Skill in typing and entering customer names and phone numbers.
- Skill in listening comprehension.
- Ability to use sound judgment when presented with a customer service complaint.
- Ability to effectively solve customer problems by choosing the most effective response to the situation.
- Skill in verbal communication for responding to customer requests and complaints.
- Knowledge of appropriate language to use when resolving customer requests and complaints.
- Telephone Order Entry NEW!
- Skill in typing and entering customer names, addresses, phone numbers, and product orders delivered via audio
- Ability to identify the correct field to enter data delivered via audio.
System Requirements
Call OPAC Testing Software today at 800.999.0438 ext. 248
|
