Network administrators are generally difficult and need certain professional knowledge!
It can be said that the information processing technician is the simplest, that is, some basic hardware performance parameters, the basic concepts and operations of Microsoft office processing software and database applications, and the basic operations of the Internet and its commonly used software.
This is easy to learn! The following is a summary of information processing technicians:
Information Processing Technician (added in 2005)
First, the examination instructions
1. Examination requirements
(1) Understand the basic concepts of information technology;
(2) Familiar with the composition of the computer, the functions and performance indicators of the main components;
(3) Understand the basic knowledge of computer network and multimedia;
(4) Familiar with commonly used information processing equipment;
(5) Familiar with the basic knowledge of computer system installation and maintenance;
(6) Familiar with the basic knowledge of computer information processing;
(7) Master the basic concepts and operations of operating system and file management;
(8) Master the basic knowledge and operation of word processing;
(9) Master the basic knowledge and operation of spreadsheets;
(10) Master the basic knowledge and operation of demonstration;
(1 1) Be familiar with the basic concepts and operations of database application;
(12) Be familiar with the basic operation of the Internet and its commonly used software;
(13) Understand the basic knowledge of computer and information security;
(14) Understand the main points of relevant laws and regulations;
(15) correctly read and understand simple English commonly used in computer use.
2. Qualified personnel who have passed this examination have basic knowledge of computers and information processing, can skillfully use computers to effectively and safely carry out information processing operations according to the requirements of application departments, can carry out daily maintenance of personal computer systems, and have the practical working ability and professional level of assistant engineers (or technicians).
3. The subjects set in this exam include:
(1) Basic knowledge of information processing, examination time 150 minutes, written test and multiple-choice questions;
(2) Information processing application technology, the examination time is 150 minutes, computer test and operation questions.
Second, the scope of the examination
Examination subject 1: Basic knowledge of information processing
1, the basic concept of information technology
Information society and the application of information technology.
1.2 Basic knowledge of elementary mathematics
Simple statistics of data, common statistical functions and common statistical charts
2. Basic knowledge of information processing
The whole process of information processing
Information processing requirements (accuracy, security and timeliness)
Information processing system, rules and regulations related to information processing
Data collection method, classification method and coding method
Data input methods and requirements, data verification methods
Data output form, file organization and access method
File storage format, file compression and decompression
2. Basic knowledge of computer system
2. 1 hardware foundation
Connection of main components
Main performance indexes of CPU
Types and characteristics of main memory, main performance indicators
Types, characteristics and main performance indexes of auxiliary memory
Types and characteristics of common storage media and protection methods.
Types, characteristics and main performance indexes of commonly used input devices
Types, characteristics and main performance indexes of commonly used output devices
Categories and characteristics of common I/O interfaces
Common knowledge of installation, use and maintenance of common information processing equipment
3.2 Basic knowledge of software
Basic concepts of operating system
Basic concepts of file system
Basic knowledge of application software
Basic knowledge of application system development
3.3 Basic knowledge of multimedia
Multimedia data format
Multimedia authoring tools and applications
4. Basic knowledge of system use and file management.
Understand the desktop environment
Basic concepts and operation methods of icons, windows and their components.
Basic concepts of file, folder and directory structure
Operation method of file management
5. Basic knowledge of word processing
The basic process of word processing
Basic knowledge of text typesetting
Basic functions and operation methods of word processing software
File type and format compatibility
6. Basic knowledge of spreadsheets
Basic concepts of spreadsheets
Composition of electronic form
Basic functions and operation methods of spreadsheet software
Common data formats and common functions
7. Basic knowledge of demonstration
Basic concepts of demonstration
Basic functions of commonly used demonstration software
Demonstration method
8. Basic knowledge of database application
Basic concepts of database application
Basic functions and operation methods of database management system
9. Basic knowledge of computer network application
Basic concepts of local area network
The basic concept of Internet, TCP/IP protocol and its main applications
Types and characteristics of common network communication equipment
Common Internet connection methods
Sending, receiving and managing methods of e-mail
Methods of browsing, searching and downloading online information
10, information security basics
Basic safety knowledge of computer installation, connection and use.
Basic knowledge of health and safety in computer environment
Basic knowledge of computer virus prevention and control
Common methods of information security guarantee
(file access control, data encryption/decryption, backup and recovery, digital signature, firewall)
1 1, information processing practice
Understand the information processing needs of the application department and the existing information processing environment.
Conceiving and selecting information processing methods
Find problems in information processing and seek solutions.
Improve information processing methods and write technical summaries.
12, basic knowledge of relevant laws and regulations
Regulations on the protection of computer software
Concepts of shareware, freeware and user license
Laws, regulations and professional ethics requirements related to information security
(Protection of trade secrets and personal information, etc. )
13, professional English
Correctly read and understand simple English commonly used in computer use
Examination subject 2: information processing application technology
Description: Take the computer test in batches. Candidates' computers are equipped with operating system Windows and office software (using popular software and versions in society). Candidates can choose the appropriate software during the examination, complete the operation tasks according to the requirements of the test questions and save the operation results.
1, basic computer operation
Check the basic parameters of the computer system: CPU category, RAM size, operating system and version, computer name connected to the network.
View and change the desktop configuration: date and time, volume setting, screen setting, screen saver and wallpaper.
View and change the settings of the control panel.
Set Chinese character input method
Install I/O device drivers and common software.
Use and maintenance of common I/O equipment
Use the help function
Window operation, icon operation and command line operation.
Create a shortcut for the application and run the application.
defrag a hard disc
Kill the virus
2. Information management
Understand the tree directory, view and personalize the properties of folders/files, and identify the types of files.
Create, rename, move, copy and delete files or folders.
Back up disk files or folders to floppy disks or removable disks.
Compression and decompression, encryption and decryption of files and directories
Find the specified file on the hard disk by file name, file type or update date.
Empty the Recycle Bin and restore the deleted files to the Recycle Bin.
File sharing and printer sharing between online neighbors
3. Word processing
Create a new file, open an existing file, save the file, save it as a file, and then close the file.
Use the help function
Type text, select, move, copy, cut and paste file blocks.
Format selected text blocks, hypertext links, basic modifications, string search and replacement, and macro actions.
Insert tables, graphics, special symbols, files (including images), and establish directories and indexes.
Basic operation of the form
Conversion of various document formats (plain text, doc, html, document module, PDF format)
Set the header, footer and page number.
Page setup, print preview and printing in various specified ways.
Draw simple figures
Merge mail
Use templates to make formatted documents and create new templates.
Typesetting and layout design
4, spreadsheet processing
Create, open, save, save as, and close spreadsheets.
Use the help function
Adjust the basic settings of the spreadsheet (change the viewing mode, zoom tools, modify the toolbar, and adjust the rows and columns).
References to absolute and relative addresses
Format cells.
Insert text, special symbols, formulas, images and macro actions in cells.
Selection, Editing, Search, Replacement and Sorting of Spreadsheet Data
Use formulas and common function operations to copy or increment data items by using the auto-fill/copy handle tool.
Identify error messages
According to the data table, make various charts to analyze the data, and edit and modify the charts to make them beautiful and practical.
Screening, classification and summary of tabular data
Pivot table making
Document layout, print preview and print worksheet/workbook.
Multi-file format conversion (word processing documents, spreadsheets, database tables)
Set the header, footer and page number.
5. Demonstration processing
Create a new presentation, select the appropriate module, and use and operate the master.
Insert a new slide and enter text, tables and graphics.
Insert and edit various objects, such as formulas.
Open the presentation document, edit and modify the contents of the slide, format, decorate and set the background.
Copy, move, delete and reorder slides.
Set the slide switching mode, add the speaker's comments, add animations, and set hyperlinks.
Browse the presentation and adjust the show time.
Use the help function
Conversion of various file formats (word processing documents, spreadsheets, database tables, presentations)
Connect the projector for demonstration operation.
6, database processing
Create new databases, data tables and views, create data table structures, enter data records and browse data tables.
Open database tables, edit data records, build indexes, sort and save/save database tables.
Copy the database/table structure, copy the database and make backup files.
Query data records according to specified criteria, create queries using multiple criteria, save queries, and add/delete filters.
Create, modify and print reports, set headers and footers, and conduct data grouping statistics.
Use the help function
Multi-file format conversion (word processing documents, spreadsheets, database tables)
7. Internet communication
Set network connection and TCP/IP properties.
Settings of browser and e-mail processing software
Browse the webpage according to the URL, and save and print the specified webpage.
Enter the portal website and search the web page with keywords and logical operators.
Download the required information through FTP or HTPP protocol.
Bookmark a webpage and open a bookmarked webpage.
Set up a new email account in the email management software to receive emails.
Create various styles of emails, edit emails and send emails (with attachments).
Create new mail folders, move, search, sort, copy and delete messages between folders.
Establish address book, input, edit, classify, export and import e-mail addresses.
Send email with address book, reply email with reply function, and forward email.
Third, examples of questions
(1) multiple choice questions
The target of data file backup is _ _ (1) _ _ _ _.
(1) A: All data should be backed up.
B. Don't put the earliest documents on the website.
C. data backup should be accurate.
D. be able to recover quickly.
(2) Operation questions
Use the Resume Wizard template to create a resume.
Resume style: tabular format;
Type: time type;
Title: skills, work experience, education, certificate, language, political views.
Requirements: the contents of the form are customized, and simulated pictures are inserted into the photos. After completing the content required by the topic, save your resume in the specified folder with the file name of T 1.DOC.