If you really want to add a skill to yourself, you should consider taking at least Level 3 instead of Level 2.
The purpose of most people taking this exam is very simple, which is nothing more than adding a sentence to their resumes, so that the units that see their resumes know that they have such skills; Or, like me, passive participation
Let's talk about people who take the computer level 2 exam in order to find a job. I'm not familiar with the job-hunting part, because I'm not involved myself. But I don't think this second-class certificate will help you find a job. Because the content of the computer level 2 exam is basically not practical, it can't show that the candidate has any computer professional level. At best, it can only show that he has the most basic knowledge of computer programming, or that he is interested in&uot dealing with … This kind of exam is easy.
Computer Level 2 exam includes C language, Basic, Foxbase, isual FoxPro and isual Basic. Candidates choose one of them as an examination item. The exam is divided into two parts, computer and written test. The written test is some basic operating methods, programming methods, and computers have to program themselves. Review materials can be purchased at the time of registration, including: exam syllabus, level 2 teaching materials, and mock exam CDs. It sounds mysterious, but in fact, the examination method and content are extremely simple-if you really read the review materials carefully. I think, if you really want to add a skill to yourself, you should consider taking at least Level 3 instead of Level 2.
The reason why I took the exam is funny-hard and fast rules. When I returned to Yanyuan in my sophomore year, I suddenly heard from my classmates that our major had to pass the computer level 2 exam, otherwise. Now I haven't figured out why I have to make such a rule. But since there will be consequences if you don't take the exam, you have to take the exam obediently. Now that I think about it, at that time, I might as well make a little effort and take the computer level 3 exam.
Second, the preparation process of computer level 2 exam
It can be said that with the CD-ROM of the mock exam, after understanding and mastering, the final computer exam will become a completely meaningless reflex movement. The key is to be willing to spend some time practicing.
Sophomore was told to pass the computer level 2 exam, and many students in the class started early. In class, we often hear people discuss some terms about computers, programming methods, how to install and store them and so on. At that time, my understanding of these things was limited to computer classes, and I learned very little from them. Listening to their discussion is like listening to a gobbledygook. I'm at a loss. But to be honest, I didn't pay much attention to this exam, so I'm not in a hurry. After all, there is still a long time before graduation.
Later, some students always asked me: Have you passed the second grade? I told you, nothing is ready yet! So someone kindly advised me to take the exam as soon as possible, and if I failed, there was still a chance to remedy it. It sounds as if the exam is very difficult, because many people who passed the exam failed-especially the computer part. Although I was a little scared, I still put it off until the next semester of my junior year and prepared for the exam at the beginning of my senior year.
The registration time of computer grade examination is about 1 and June each year, corresponding to the examination in April and September respectively. If you are in Peking University, just pay attention to the red banner hanging in front of the audio-visual education. I chose isual Basic, which is my first time to take the exam. Because I have studied a little computer class before, I know something about its content and interface. Before the end of my junior summer vacation, I made up my mind to break through second-class B this summer vacation. It was not until the holiday that I realized that what I had set before the holiday was really fragile. A few days after the summer vacation, I went to Chengdu to play: there were too many things that attracted me: mountains and rivers, snacks and friends. Before I left, I pretended to put a second-level textbook in my luggage. As a result, it didn't play any role except holding a few photos of me.
After mid-August, I was able to calm down and prepare for the unlucky exam. I opened the book, read it page by page, and thought about the after-school exercises in each chapter and section. Half a month passed, in fact, there were some lazy days in the middle, but after reading a book, I felt suddenly enlightened. So after school, I put down my books and made a simulated CD. The topic of computer programming is not difficult at all, and the simulation problem is much simpler than the exercise after calculation. But you can't always get good results when you judge software. After careful examination, I know that only my own program and the so-called &; Uot correct answer &; Uot is exactly the same, and you can get full marks. However, there are different ways to write programs to achieve the same results. Now I know why the computer exam is so difficult. The only way to deal with it is to give answers seriously and experience some skills and rules. It should be no problem to pass the exam. It can be said that with the CD-ROM of the mock exam, after understanding and mastering, the final computer exam will become a completely meaningless reflex movement. The key is to be willing to spend some time practicing.
Third, the exam practical articles
Let's start with the written test. Including selection and filling in the blanks, are some basic concepts and programming methods. As long as you read the book carefully, you won't fail the written test. Some people I know who have passed the exam generally think that the written test is easy. I was calm when I entered the examination room. After seeing the paper, I read all the nouns and contents I am very familiar with, and I did it very smoothly. Do it seriously, don't underestimate your enemy. There was silence in the examination room and everyone worked hard. Less than half of the exam time has passed, and I have finished all the questions. I sat patiently in my seat and checked it from beginning to end. At this time, it is too far away from the end of the exam. I couldn't wait, so I handed in my paper and left the classroom. Two words-not difficult.
Let's talk about the computer exam. Now sit outside the examination room, listen to the teacher describe the examination rules, and then enter the examination room. Everyone has a computer, and the questions are randomly selected from the question bank. Everyone has different questions, so the task of the invigilator is not heavy. However, it also caused the atmosphere of the examination room to be chaotic, and people around it were whispering. We should overcome this kind of chaotic interference and concentrate on our own problems. Do the questions carefully at the beginning of the exam, and try to do them according to the idea of simulating the answers on the CD. But the problem is too familiar and unfamiliar, just like the problem on the CD. I finished eight problems by three times five divided by two. Two hours of exams, 40 minutes out of the examination room. One of the invigilators came out and stopped me. I think I didn't violate the exam discipline, but he kindly came up and asked me to review my experience and so on. In fact, I don't have much experience, just reading books and doing problems.
Fourth, summary.
Many exams are flawed-this computer level 2 exam is also included. But I'm afraid it's not that easy to get out.
Maybe you will think I am too arrogant when you see it. In fact, when I looked at the results, more than 70% or 80% of the score sheets failed the written test or computer test. However, these losers must not pay attention to it, at least they didn't spend a few days preparing for the exam seriously. In fact, from the above article, readers can see that I didn't have any positive comments when I took the exam myself, but I did prepare carefully. In fact, as long as you have read the book, people who have done the mock exam CD will feel the same way: with these review materials, the final exam becomes meaningless-just a very ordinary little exercise.
Many exams are flawed-this computer level 2 exam is also included. But I'm afraid it's not that easy to get out. For those who want to consolidate their computer knowledge or have some basic programming knowledge, the second-level exam may really play some role, and passing the exam is also very simple: like me, it is enough to spend half a month reading books and doing problems. If you want to be helpful to your future work, it is far more useful to spend a little time, read more relevant books and really learn something than this examination certificate.
National Computer Rank Examination (Level 2) Examination Outline
basic requirement
1. Have basic computer knowledge.
2. Understand the basic concepts of operating system and master the use of common operating systems.
3. Master the basic data structure and common algorithms, and be familiar with the use of algorithm description tool-flow chart.
4. Be able to skillfully use a high-level language or database language to write programs and debug programs.
Examination content
First, basic knowledge and basic operation
(1) Basic knowledge 1. Main technical indexes and system configuration of computer system.
2. Computer systems, hardware, software and their interrelationships.
3. The basic composition of microcomputer hardware system. Includes processor (arithmetic unit and controller), internal memory (RAM and ROM), external memory (hard disk, floppy disk and CD), input devices (keyboard and mouse) and output devices (display and printer).
4. Composition of software system, system software and application software; Basic concepts and documents of software; Programming languages and language processors (assemblers, compilers, interpreters).
5. Number systems commonly used in computers (binary, hexadecimal and their conversion to decimal); The basic unit of data (bit, byte, word, word length).
6. Safe operation of the computer; Prevention and cure of computer virus.
7. General knowledge of computer networks.
8. General knowledge of multimedia technology.
(2) the basic operation of dos1. Basic functions and classification of operating system.
The basic composition of 2.2. DOS operating system.
3. Basic concepts of files, directories and paths.
4. Commonly used DOS operations, including:
Initialization and startup; File operations (type, copy, del, ren, xcopy, Attrib); Directory operations (dir, MD, CD, rd, tree, path); Disk operations (format, diskcopy, chkdsk); Function operation (er, date, time, CLS, prompt, help); Batch processing (creating and executing batch files, automatic batch files); Input and output change direction.
(3) The basic operation of window 1. The characteristics, basic composition and running environment of Windows.
The basic elements of 2.2. Windows user interface. Include windows, icons, menus, dialogs, buttons, cursors, etc.
3. foundation 3. Windows operation. Include startup and exit, mouse operation, window operation, icon operation, menu operation and dialogue operation.
Second, the program design
1. Can use structured programming method to write programs.
2. Master the basic data structure and common algorithms.
3. Proficient in using a high-level or a database language (including BASIC, FORTRAN, PASCAL, C, FOXBASE, etc.), candidates can choose one. Attached to the examination content of each language).
Third, computer operation
Use a microcomputer to complete the following operations within the specified time:
1. Complete the specified basic computer operations (including machine startup and use of operation commands).
2. Write and run the program according to the given requirements.
3. Debugging the program, including modifying and supplementing the given imperfect program to get the correct result.
Examination content in various languages
First, the basic language programming
(a) the basic concept of BASIC 1. Data types provided by BASIC.
2. Concepts of constants and variables, naming rules of variables and description of variable types.
3. Operators and operation rules (arithmetic operation, relational operation, logical operation and character operation).
4. The concept and evaluation of expressions (arithmetic expressions, relational expressions, logical expressions and character expressions).
(2) Sequence structure programming 1. Assignment of variables (LET statement).
2. Data output (print report).
3. Data INPUT (input statement, READ/DATA statement, RESTORE statement).
4. The program stops executing (END statement, stop statement).
5. Program comments (REM statements).
(3) Select structural programming 1. Line IF statement.
2. block the IF structure.
3. Select the case structure.
4. Select the nesting of structures.
(4) Loop structure programming 1. The concept of cycle.
2.WHILE loop structure.
3.FOR-NEXT loop structure.
4. Make a circular structure.
5. Nesting of circular structures.
(5) Array 1. Arrays and array elements.
2. Method of array definition.
3. Method of referencing array elements.
4. Static arrays and dynamic arrays.
5. One-dimensional arrays and arrays.
6. Array operations.
(6) Functions and subroutines 1. Standard function.
2. Definition and reference of single-line custom function and multi-line custom function.
3. Subroutines in block subroutines (GOSUB-RETURN statement, ON GOSUB-RETURN statement and ON KEY(n)GOSUB-RETURN statement).
4. Definition (SUB-END SUB statement) and CALL (call statement) of module subroutine.
5. Definition (function statement at function end) and call of modular function.
6. Data transmission between modules (combination of reality and reality).
7. Global variables and local variables.
8. Nested calls of procedures.
9. Recursive call of procedure.
(7) Character processing 1. Concepts of strings and string variables.
2. Assignment of string variables.
3. The operation of the string.
4. String function. 5. String array. (8) Document1. The concept of document.
2. Operation of source files.
3. Operation on sequential files. 4. Record the definition of variables (TYPE-END TYPE statement) and the operation of random files.
(9) Screen control and drawing 1. Screen control (CLS statement, positioning statement).
2. Control of display mode (screen statement).
3. Color setting (color declaration).
4. Standard drawing statements (PSET statement, preset statement, straight line statement, drawing statement and circle statement).
5. Coloring of graphics (PAINT statement).
Second, FORTRAN language programming
(The structure and writing rules of FORTRAN program 1. FORTRAN program composition (main program and subroutine).
2.2 writing format. FORTRAN source program.
(2) Data type and its operation 1. Types of constants and variables (integer, real number, double precision, complex number, logic and character).
2. Methods of defining variable types (implicit description and explicit description with I-N rules).
3. Symbolic constant and its definition method (parameter statement).
4. Operator and operation priority.
5. Expressions (arithmetic expressions, relational expressions, logical expressions and character expressions) and their evaluation rules. Mixed operation of different types of data.
(3) The most basic statement 1. Assignment statements (arithmetic, logic and character assignment statements).
2. Table controls the input and output of the format.
3. Format input and output:
(1) format editor (x, h, i, f, e, d, a, l,/), format repetition.
(2) Interaction between format statements and input and output statements (including reading and writing statements).
(3) The method of including format description in input and output statements.
4. Pause statement (STOP statement) and stop statement (END statement).
5. Initial value statement (data statement).
6. Transfer statement (go to statement).
(d) Select structural programming 1. Logical IF statement.
2. block the IF structure. 3. Select the nesting of structures.
(5) Cycle structure programming 1. When loop and until loop.
2. Use the DO statement to realize the loop:
⑴ Calculation of the number of cycles when using DO statement.
(2) The concept of a circular object.
(3) Loop terminal statement and continue statement.
3. Use block IF and GOTO statements to realize the loop. 4. Circular nesting.
(vi) Application of array 1. Method of defining an array (define a DIMENSION or array with dimension statement and type statement).
2. Reference array elements correctly.
3. The storage order of the array in memory (by column).
4. The method of assigning values to arrays.
5. Input and output of array. 6. Adjustable array.
(vii) Functions and subroutines 1. Calling method of internal function.
2. Definition and reference method of statement function.
3. The structure and calling method of function subroutine.
4. Subroutine structure and calling method.
5. Data transmission between modules (combination of reality and reality).
(8) Data 1. COMMON statement, unknown public areas and well-known public areas 2. Block subroutine (9) Character processing 1. String, character variable and character array.
2. Assignment and operation of character data.
3. Input and output of character data.
(10) 1. Concepts of documents and records.
2. Open and close files.
3. Access method of sequential files.
4. Access method of direct files.
Third, Pascal language programming
(1) Composition of Pascal program 1. Language elements of the source program.
2. Program header, interpretation part and execution part.
3. Programming rules.
(2) Data type and its operation 1. The data types, definition methods and uses of Pascal;
(1) Standard types (real number type, integer type, Boolean type and character type).
⑵ User-defined type (enumeration type, sub-binding type). (3) Structure type (array type, type, record type, file type).
(4) Pointer type.
2. Operators and expressions (including arithmetic, mathematics, relations and Boolean).
3. Compatibility of data types.
(3) Basic statement 1. Assignment statement. 2. Input and output statements and their format control.
3. Compound statements.
(4) Select structural programming 1. Using IF statement to realize the selection structure.
2. Use CASE statement to realize multi-branch selection structure.
3. Select the nesting of structures.
(5) Cycle structure programming 1. For periodic structures.
2. Repetitive circulation structure.
3.WHILE loop structure.
4. Nesting of circular structures.
(vi) Array 1. Basic concepts, definition methods and methods of referencing array elements of one-dimensional arrays and arrays.
2. The concept of compressed array.
3. Strings and character arrays.
(7) Process and function 1. The concept of process and function.
2. Standard process and standard function.
3. Definition methods and calling methods of procedures and functions.
4. The combination of formal parameters and real parameters, the use of value parameters and variable parameters.
5. Recursive calls of procedures and functions.
6. The range of identifiers (local quantity of total quantity).
(8) Dynamic data structure 1. The concept of pointer variable.
2. Development, publication and reference of dynamic storage unit.
3. Operation of one-way linked list and circular linked list.
(9) Document1. The concept of document.
2. Basic operations of files (creation, opening, closing and accessing).
Fourth, C language programming
(1) The structure of C language 1. The program is composed of functions and other functions.
2. Header file, data description, start and end marks of functions.
3. The writing format of the source program.
4. the style of c language.
(2) Data type and its operation 1. C data types (basic type, structure type, pointer type, null type) and their definition methods.
2. Type, operation priority and combination of C operator.
3. Conversion and operation between different types of data.
4.c expression types (assignment expression, arithmetic expression, relational expression, logical expression, conditional expression, teasing expression) and evaluation rules.
(3) Basic statement 1. Expression statements, empty statements and compound statements.
2. Input and output of data, and call of input and output functions.
3. Compound statements.
4.4. Use of goto statement and statement target.
(4) Select structural programming 1. Using if statement to realize the selection structure.
2. Implement multi-branch selection structure with switch statement.
3. Select the nesting of structures.
(5) Loop structure programming 1.for loop structure.
2.while and do while loop structure.
3. Continue statement and interrupt statement.
4. Circular nesting.
(vi) Definition and reference of array 1. Definition, initialization and reference of one-dimensional arrays and arrays.
2. Strings and character arrays.
(7) Function 1. Correct call of library function.
2. Definition method of function. 3. Type and return value of the function.
4. Transmission of formal parameters, real parameters and parameter values.
5. Correct call, nested call and recursive call of functions.
6. Local variables and global variables.
7. Storage category of variables (automatic, static, register, external), range and life of variables.
8. Internal and external functions.
(8) Compile preprocessing 1. Macro definition: a macro definition without parameters; Macro definition with parameters.
2.&uot This file contains &; Uot processing.
(9) pointer 1. Concepts of pointers and pointer variables, pointers and operators.
2. Pointers to variables, arrays, strings, functions and structures, and pointer variables to variables, arrays, strings, functions and structures. Reference the above types of data through pointers.
3. Use pointers as function parameters.
4. A pointer function that returns a pointer value.
5. Pointer array, pointers to pointers and command line parameters in functions.
(10) structure (i.e. &; Uot structure and uot) and universal body (i.e. &; Uot United airlines; )。
1. Definition method and reference method of structure and common body data.
2. Use pointers and structures to form linked lists, and establish, output, delete and insert unidirectional linked lists.
(eleven) bit operation 1. The meaning and usage of bit operators.
2. Simple bit operation.
(12) File operations only need a buffered file system (i.e. an advanced disk I/O system), and do not need a nonstandard buffered file system (i.e. a low-level disk I/O system).
1. file type pointer (file type pointer).
2.fopen, fclose) file.
3. Read and write files (fputc, fgetc, fputs, fgets, fread, fwrite, fprintf, fscanf functions) and location files (rewind, fseek functions).
Five, database language programming
(a) database system and FoxBASE+ basic knowledge 1. Basic concepts: database, database management system, database system, database model and their relationships II. Relational database:
(1) relational model, relational schema, relationship, tuple, attribute, domain.
(2) relational operation: selection, projection, connection and the embodiment of three relational operations in FoxBASE+.
3. System performance and working mode:
(1) Various file types and characteristics and command formats.
(2) Main performance indicators of the system.
(3) Two working modes: interactive mode and program running mode.
4. Data elements of Foxbase+:
(1) Constants: Numeric, character, logical and date constants.
(2) Variables: save and restore field variables, simple memory variables, arrays and memory variables.
(3) Expression: the type and operation of expression.
(4) Common functions: numerical calculation function, character processing function, date function, data type conversion function and test function.
(2) Basic operation of database 1. Create, modify and:
(1) Establishment, modification and development of database structure.
(2) Add, delete and modify database records.
(3) file management command.
2. Reorganization and query of the database:
(1) Direct query and record pointer positioning.
(2) Database sorting and indexing.
(3) Search and find quickly.
3. Data statistics and calculation:
(1) Count the number of records, sum and average.
(2) classified summary.
4. Multiple database operations:
(1) Selection and use of workspace.
(2) Database association and connection set relation, connection.
(3) Data update between databases.
(3) Programming (command file) 1. Establishment and operation of command file.
2. Three basic structures of the program: (1) sequence structure.
(2) Select the structure:
Use the conditional selection statement IF-ELSE-ENDIF and its nested form.
Use multi-branch selection statement to do CASE-ENDCASE.
(3) Loop structure: Use loop statement DO WHILE-ENDDO and its nested form.
3. Layout design:
Use (1) format to design the command @.
(2) The establishment and use of screen format.
(3) The design of ribbon menu.
4. Subroutines and processes:
(1) subroutine design and call.
(2) Process and process documents. (3) Parameter transfer and procedure call in local variables and global variables.
5. Compilation and use of command files.
(4) System environment and state parameters 1. Common SET commands:
(1) Common switch state setting command.
(2) Common environmental parameter setting commands.
2.FoxBASE+ system configuration file. Foreign exchange configuration file.