Spreadsheet: 16c80026-d94d-444b-a0a1-4a7eede841c6
Sheet: Sheet1

Unit/Standard Number | High School Graduation Years 2013, 2014 and 2015  Administrative Assistant & Secretarial Science, General CIP 52.0401 Task Grid | Proficiency Level Achieved: (X) Indicates Competency Achieved to Industry Proficiency Level
 | Secondary Competency Task List
100 | ORIENTATION
101 | Follow school rules and policies.
102 | Follow classroom rules and regulations.
103 | Describe safety concerns in an office environment.
200 | COMPUTER AND INTERNET
201 | Identify different types of computers, and how individual computers relate to networks.
202 | Differentiate between operating systems and applications software.
203 | Identify the functions of computer hardware, software, and peripheral devices in the Information Processing Cycle.
204 | Utilize the Internet and network resources  safely, legally, and ethically.
205 | Assess, interpret, and manipulate Internet research.
300 | DOCUMENT PROCESSING SOFTWARE
301 | Utilize templates to prepare business documents (e.g. invoices, fax cover sheets, time sheets).
302 | Create, edit, and format business correspondences and technical documents efficiently (e.g. letters, memos, agendas, minutes, press release reports, and itineraries).
303 | Enhance documents with graphics
304 | Create and format tables.
305 | Create and format forms.
306 | Generate form letters, mailing labels, and envelopes using Mail Merge.
307 | Import and Export data into other applications.
400 | SPREADSHEET SOFTWARE
401 | Create, edit, and format spreadsheets.
402 | Enhance spreadsheets with graphics.
403 | Define and demonstrate the integration of worksheet applications through pasting, linking, and embedding.
404 | Create, format, and modify charts.
405 | Create formulas and use standard functions.
406 | Create spreadsheets using range names, worksheet protection, and look-up tables.
407 | Manipulate multiple worksheets and workbooks.
408 | Import and Export data into other applications.
500 | DATABASES
501 | Enter data and update databases.
502 | Create databases.
503 | Query databases.
504 | Understand and develop relationships to create queries.
505 | Create reports, forms and combo boxes.
506 | Import and Export data into other applications.
600 | PRESENTATIONS
601 | Create, edit, and format presentations.
602 | Enhance a presentation with advanced features.
603 | Deliver a well-planned professional business presentation.
700 | DESKTOP PUBLISHING
701 | Create, edit, and format publications.
702 | Enhance a publication with advanced features.
703 | Understand design principles related to page layout.
800 | COMMUNICATIONS SOFTWARE
801 | Utilize electronics communications software.
802 | Apply proper electronics communications etiquette.
803 | Use scheduling and contact management software.
900 | OFFICE SKILLS
901 | Build keyboarding speed and accuracy.
902 | Use copier, fax, projectors and scanners.
903 | File and manage records and materials.
904 | Process incoming and outgoing mail.
905 | Demonstrate proper interpersonal communication skills in a diverse work environment.
906 | Package and ship materials and verify and receive shipments.
907 | Compile data and compose documents.
908 | Assist with travel arrangements and event planning.
909 | Create and maintain a budget.
910 | Apply proofreader's marks and revise text utilizing correct grammar, punctuation and spelling in all business communications.
1000 | OFFICE MANAGEMENT
1001 | Plan and manage office activities (e.g. meetings, workshops, travel arrangements).
1002 | Describe the roles and responsibilities of an office manager.
1003 | Demonstrate proper workplace ergonomics.
1004 | Develop time management skills by settling priorities and perform multiple tasks.
1100 | BUSINESS MATH
1101 | Perform calculations using addition, subtraction, multiplication and division.
1102 | [NAME] decimals, percents and fractions to their equivalent parts.
1103 | Properly maintain business checking and savings accounts.
1104 | Calculate discounts and sales tax.
1200 | ACCOUNTING
1201 | Understand the accounting equation and classify accounts.
1202 | Analyze transactions effecting assets, liabilities and owner's equity.
1203 | Analyze transactions into debit and credit parts.
1204 | Post to general ledger.
1205 | Reconcile bank statements and establish and replenish petty cash fund.
1206 | Prepare worksheet and adjusting entries.
1207 | Prepare balance sheet and income statement.
1208 | Record adjusting and closing entries.
1209 | Prepare payroll records.
1210 | Prepare payroll accounting taxes and reports.
1300 | Business Law and Ethics
1301 | Learn business law and business ethics vocabulary.
1302 | Explain crimes often associated with business and organizations (e.g., embezzlement, extortion, computer crimes).
1303 | Identify improper use of business technology and property (e.g., computers, personal digital assistants, cell phones, telephones).
1304 | Explain the importance of confidentiality in the workplace.
1305 | Compare types of contracts, including related accountability.
1400 | Office Procedures and Customer Service Communications
1401 | Demonstrate proper electronics and telephone communications etiquette and procedures.
1402 | Describe the advantages of customer service in building a loyal customer base.
1403 | Describe how data is collected to improve customer service.
1404 | Demonstrate the use of effective face-to-face communication with customers.
1405 | Identify the ways a customer service representative can develop a rapport with customers.