MASSACHUSETTS DEPARTMENT OF EDUCATION

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 VOCATIONAL TECHNICAL WORK 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 www.mccte.org 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: 11/2007


MASSACHUSETTS DEPARTMENT OF EDUCATION

 
Vocational Technical TEACHER TESTING Program 

SCOPE OF TEST CODE #26 OFFICE TECHNOLOGY

PERFORMANCE EXAM

TIME ALLOWED: 4 HOURS

PERCENT OF TEST:

 

50 % Microcomputer Applications

- Word Processing

- Spreadsheets

- Databases

- Presentations

- Web Design

 

10 % Computer Fundamentals

- Operating Systems Networking

- File Management

 

16 % Accounting Principles

- Journals

- Financial Statements

- Payroll

 

4 % Office Procedures

- Filing according to American Records Management Rules

 

12 % Business Communications

- Grammar, Punctuation

- Proofreading Symbols

 

8 % Career Planning

- Resume Writing

- Interview

- Job Search

 

 

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.  

 

 


SCOPE OF TEST CODE #26 – OFFICE TECHNOLOGY

 

-Page 2-

 

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

 

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

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

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

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

Excel Word 2003 Comprehensive Concepts and Techniques by Shelly, Cashman, & Pratt Course Technology 2007

Microsoft Office Specialist Exam Reference 2003 by Campbell Thomson Course Technology 2007

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

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

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

Working Thomson by Bailey Thomson South-Western 2007

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

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

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 2005

 

Equipment that will be supplied:

IBM Compatible Pentium Computer

Software used:

Windows XP Operating System

Office 2003

Internet Explorer

Candidate is responsible for bringing:

Pens, Pencils and a Ruler

 

UPDATED: 11/2007