What is the main content of the computer grade examination MS-OFFICE?
Basic requirements 1. Have the basic knowledge of using microcomputer (including common knowledge of computer virus prevention). 2. Understand the composition of microcomputer system and the functions of each component. 3. Understand the basic functions and functions of the operating system, and master the basic operations and applications of Windows. 4. Understand the basic knowledge of word processing, master the basic operation and application of word processing software "MS Word", and master a Chinese character (keyboard) input method skillfully. 5. Understand the basic knowledge of spreadsheet software and master the basic operation and application of spreadsheet software "Excel". 6. Understand the basic knowledge of multimedia presentation software and master the basic operation and application of presentation software "PowerPoint". 7. Understand the basic concepts of computer network and the preliminary knowledge of Internet, and master the basic operation and use of IE browser software and Outlook Express software. Examination content 1. Basic knowledge 1. The concept, types and application fields of computers; Configuration and main technical indexes of computer system. 2. Representation of data in computer: binary concept, binary representation of integers, ASCII representation of western characters, Chinese characters and their codes (national standard codes), and data storage units (bits, bytes and words). 3. The concept of computer virus and its prevention. 4. Composition and functions of computer hardware system: functions of CPU, memory (ROM, RAM) and common input and output devices. 5. Composition and function of computer software system: concepts of system software and application software, and programming languages (machine language, assembly language and high-level language). Second, the function and use of the operating system 1. The basic concept, function, composition and classification of operating system. 2.2. Basic concepts and common terms. Windows operating system, such as files, file names, directories (folders), directory (folder) trees and paths. 3. Basic operation and application of Windows operating system: (1)Windows overview, features and functions, configuration and running environment. (2) Use of 2)Windows start button, taskbar, menu, icon, etc. (3) Running and quitting of the application. (4) Master the operation and application of resource management systems "My Computer" and "Resource Manager". Create, move, copy, delete, rename, find, print and set the properties of files and folders. (5) Floppy disk formatting, whole disk copying, disk attribute viewing and other operations. (6) Installation, deletion and selection of Chinese input methods; Settings for the monitor. (7) The setting and use of shortcut keys. Third, the function and use of word processing software 1 Basic concepts of word processing software, basic functions of Chinese word, running environment, startup and exit. 2. Document creation, opening and basic editing operations, text search and replacement, multi-window and multi-document editing. 3. Save, protect, copy, delete and insert files. 4. Basic typesetting operations such as font format setting, paragraph format setting and document page setting. Print preview and print. 5.Word object operation: the concept and types of objects, the editing of graphics and image objects, and the use of text boxes. 6.6 table making function. Word: the creation and decoration of tables, the input and editing of data in tables, the sorting and calculation of data. Fourth, the function and use of spreadsheet software 1 The basic concept of spreadsheet, the function of Chinese Excel, the running environment, startup and exit. 2. Basic concepts of workbooks and worksheets, creation, data entry, editing and typesetting of worksheets. 3. Basic operations such as inserting, copying, moving, renaming, saving and protecting worksheets. 4. The concepts of absolute address and relative address of cells, the input of formulas in worksheets, and the use of common functions. 5. The concept of data table, the use of record table, the classification, screening, retrieval and classification of records. 6. Chart creation and format. 7. Page setup, print preview and printing of the worksheet. V. Functions and usage of the software for making electronic presentations 1. The function, running environment, startup and exit of Chinese PowerPoint. 2. Create, open and save the presentation. 3. Use of demonstration view, production of slides, text arrangement, insertion of pictures and charts, and selection of templates. 4. Insertion and deletion of slides, change of presentation order, setting of slide format, setting of slide show effect, insertion of multimedia objects, packaging and printing of presentations. Preliminary knowledge and application of intransitive verbs on the Internet 1. The concept and classification of computer network. 2. Basic concepts and access methods of Internet. 3. Simple applications of Internet: dial-up connection, using browser (IE6.0), sending and receiving e-mails and using search engines. Examination method 1. Paperless examination and computer operation. Examination time: 90 minutes. Second, the software environment: operating system: Windows2000;; Office software: Microsoft Office 2000. 3. Complete the following operations with a microcomputer within the specified time: 1. Multiple choice questions (basic knowledge of computer and computer network). (20 points) 2. Chinese character input ability test (input 150 Chinese characters, limited time 10 minutes). (10) 3. The use of 3. Windows operating system. (10) 4. Word operation. (25 points) 5. Excel operation. (15) 6. PowerPoint operation. (10) 7. Simply use the browser (IE6.0) and send and receive emails. (10 points