MASSACHUSETTS Vocational Technical TEACHER TESTING Program

 

SCOPE OF TEST CODE #26 – OFFICE TECHNOLOGY

 

WRITTEN EXAM – 100 QUESTIONS

 

TIME ALLOWED: 3 HOURS

 

 

PERCENT OF TEST:

 

 

15% ACCOUNTING

 

30% MICROCOMPUTER APPLICATIONS – MICROSOFT WINDOWS ENVIRONMENT

            - Word Processing

            - Spreadsheets

            - Databases

            - Presentations with Multimedia, Print and Audio Tech.

 

15 % OFFICE ADMINISTRATION

            - Business Meetings

            - Policies and Procedures

            - Customer Service

            - File Management

            - Resource Management

 

  5 % OFFICE BUSINESS CONCEPTS

            - Business Math

            - Communications

 

  5 % OFFICE HEALTH AND SAFETY

 

10 % PRINCIPLES OF MANAGEMENT

            - Management Activities

            - Small Business

            - Entrepreneurship

            - Project Management

 

10 % PLAN, PRODUCE AND MANAGE A WEBSITE

            - Web Design

            - Programming Concepts

            - E-Commerce

            - Market Products and Services

 

10 % TELECOMMUNICATIONS AND COMPUTER CONCEPTS

            - Operating Systems and Windows

            - E-Mail

            - Internet

            - Telecommunications

            - Electronic Devices


SCOPE OF TEST CODE #26 – OFFICE TECHNOLOGY

-Page 2-

 

THE WRITTEN EXAMINATION IS ALIGNED WITH THE MATCHING MASSACHUSETTS VOCATIONAL TECHNICAL EDUCATOR FRAMEWORKS.  SOME QUESTIONS REQUIRE A SYNTHESIS OF KNOWLEDGE BASED ON THIS EXPERIENCE AND MAY NOT BE FOUND IN ANY BOOK. HOWEVER, CANDIDATES ARE ENCOURAGED TO STUDY FOR THEIR EXAMS BY REVIEWING CURRENT TEXTBOOKS AND REFERENCE MATERIAL WHICH CAN USUALLY BE FOUND IN THE LIBRARIES OF MOST VOCATIONAL TECHNICAL SCHOOLS AND SCHOOLS WHICH OFFER CHAPTER 74 PROGRAMS.

 

You may refer to http://www.doe.mass.edu/cte/frameworks for the Massachusetts Vocational Technical Educator Frameworks.

 

THE FOLLOWING LIST OF REFERENCE MATERIALS WAS DEVELOPED AS A GUIDE FOR WRITTEN EXAM CANDIDATES:

 

Cashman, Shelly, Microsoft Office 2003, Introductory Concepts and Techniques (Work 2003, Excel 2003,

            Access 2003, PowerPoint 2003 and Outlook 2003), 2004

 

Ristau, Eggland, Diabay, Buttow and Doughtrey, South-Western Introduction to Business, 3rd Edition, 1997

 

Real World Applications, Glencoe Microsoft Office 2003, 2006

 

Intuit, QuickBooks Learning Guide, 2006

 

Schwalbe, Kathy, Introduction to Project Management, 2005

 

Gorman, Mary, Stubbs, Todd, Introduction to Operating Systems: A Survey Course, 2nd Edition, 2003

 

YOU MAY WANT TO CHECK WITH YOUR LOCAL LIBRARY FOR OBTAINING THESE RESOURCES THROUGH THE INTERLIBRARY LOAN PROGRAM.

 

 

The written exam consists of 100 multiple choice questions.  Each question consists of one incomplete sentence or a questions followed by four choices.  Listed below are several sample items:

 

A plus sign in Windows Explorer is called the ____ button.

 

            a.         Collapse

            b.         Plus

*           c.         Expand

            d.         Reduce

 

Google, Ask Jeeves, and Yahoo are all popular:

 

*           a.         search engines.

            b.         providers.

            c.         web pages.

            d.         home pages.

* indicates correct answer

 

THE TEACHER TESTING PROGRAM WILL PROVIDE NON-PROGRAMMABLE CALCULATORS FOR USE IN COMPLETING THE WRITTEN EXAM. DOCUMENTATION REGARDING THESE CALCULATORS WILL

BE INCLUDED IN YOUR ADMISSION PACKAGE.

UPDATED: 7/2008


MASSACHUSETTS Vocational Technical TEACHER TESTING Program

 

SCOPE OF TEST CODE #26 OFFICE TECHNOLOGY

 

PERFORMANCE EXAM

 

TIME ALLOWED: 4 HOURS

 

PERCENT OF TEST:

 

10 % Business Communications

- Grammar, Punctuation

- Proofreading Symbols

 

65 % Microcomputer Applications

- Word Processing

- Spreadsheets

- Databases

- PowerPoint Presentations

- HTML

 

20% Preparing Financial Statements

- Income Statement

- Balance Sheet

 5% Communications

- Operating Systems

- Career Management

Although keyboarding skills will not be evaluated, candidates will be expected to be proficient in keyboarding skills in order to efficiently complete Office Technology Subtests.  

 

THE FOLLOWING LIST OF REFERENCE MATERIALS WAS DEVELOPED AS A GUIDE FOR PERFORMANCE EXAM CANDIDATES:

Microsoft Office 2007

·         Microsoft Access 2007 Comprehensive Concepts and Techniques by Shelly, Cashman & Pratt Course Technology

·         Microsoft PowerPoint 2007 Comprehensive Concepts and Techniques by Shelly, Cashman, & Pratt Course Technology

·         Microsoft Publisher 2007 Complete Concepts and Techniques by Shelly, Cashman, & Pratt Course Technology

·         Microsoft Word 2007 Comprehensive Concepts and Techniques by Shelly, Cashman, & Pratt Course Technology  

·         Microsoft Excel 2007 Comprehensive Concepts and Techniques by Shelly, Cashman, & Pratt Course Technology Microsoft Office Specialist Exam Reference 2007 by Campbell Thomson Course Technology


SCOPE OF TEST CODE #26 – OFFICE TECHNOLOGY

-Page 2-

Other

·         The Office by Oliverio, Pasewark & White Thomson South-Western

·         The Administrative Professional by Fulton-Calkins Thomson South-Western

·         Integrated Business Projects 2nd Edition, by Olinzock, Arney & Skean Thomson South-Western

·         Working Thomson by Bailey Thomson South-Western

·         How 11 A Handbook for Office Professionals by Clark & Clark Thomson South-Western

·         Multimedia & Image Management by Lake & Bean Thomson South-Western

·         Computer Concepts 9th Edition by June, Jamrich, Parsons and Dan Oja Thomson Course Technology 2007

·         Computer Literacy Basics by Ambrose, Bergerud, Busche, Morrison and Wells-Pusins by Thomson Course Technology 2007

·         Keeping Financial Records for Business Schultheis, Kaliski, Passalacqua South-Western Thomson Learning 2007

·         Century 21 Accounting General Journal, by Claudia Bienias Gilbertson, Mark W. Lehman & Kenton E. Ross Thomson South-Western 2006

·         HTML 4.0 Fundamentals, by Curt Robbins

      DDC Publishing 2000

·         HTML 4.0 Intermediate, by Curt Robbins

      DDC Publishing 2000

·         HTML 4.0 Advanced, by Curt Robbins

      DDC Publishing 2000

 

Equipment that will be supplied:

IBM Compatible Pentium Computer

 

Software used:

Windows XP Operating System

Microsoft Office 2007

(Word, Excel, PowerPoint, Access, Publisher and Outlook)

Internet Explorer

Notepad

 

Candidate is responsible for bringing:

Pens, Pencils and a Ruler

 

 

You may refer to http://www.doe.mass.edu/cte/frameworks for the Massachusetts Vocational Technical Educator Frameworks.

 

 

 

 

 

 

UPDATED: 6/2009 lmb