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. Including CPU (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 (version, 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 (* * * there are five languages such as QBASIC, FORTRAN, PASCAL, C, FOXBASE, etc., and candidates can choose one of them. 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, QBASIC language programming
The basic concept of (1)q Basic 1 Data types provided by QBASIC.
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 multidimensional 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-terminal statement) and call (call statement) of independent 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. Methods of defining arrays (defining one-dimensional or multi-dimensional arrays with dimension statements and type statements).
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 association 1. COMMON statement, unknown common area and well-known common area 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, collection type, record type, file type).
(4) Pointer type.
2. Operators and expressions (including arithmetic, set, relation 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 array and multi-dimensional array.
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. Composition, main functions and other functions of the program.
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, comma 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 statements and statement labels.
(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 array and multidimensional array.
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. "File inclusion" processing.
(9) pointer 1. Concepts of pointers and pointer variables, pointer and address 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 of the main function.
(10) structure (i.e. "construction") and * * * object (i.e. "combination").
Definition and reference methods of 1. structure and * * * 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 the database 1. Establishment, modification and replication of database;
(1) Establishment, modification and replication of database structure.
(2) Add, delete, modify and copy 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.
National Computer Rank Examination Level 2 VFP Examination Outline
-
LEARNING.SOHU.COM May 3, 2004
basic requirement
1, with basic knowledge of database system.
2, basic understanding of the concept of object-oriented.
3. Master the basic principles of relational database.
4, master the database programming method.
5. A small database application system can be established by using VISUAL F OXPRO.
Examination content
First, the basic knowledge of VISUAL FOXPRO
1, basic concept
Database, data model, database management system, classes and objects, events and methods.
2. Relational database:
(1) relational database: relational model, relational schema, relationship, tuple, attribute, domain, primary key, external relationship.
Key words.
(2) relational operation: selection, projection and connection.
(3) Consistency and integrity of data: entity integrity, domain integrity and citation integrity.
3. Features and working mode of VISUAL FOXPRO system:
Characteristics of (1) WINDOWS version database.
(2) Data type and main file type.
(3) Various devices and wizards
(4) Working mode: interactive mode (command mode, visual operation) and program running mode.
4. Basic data elements of 4.VISUAL FOXPRO:
(1) Constants, variables, expressions.
(2) Common functions: character processing function, numerical calculation function, date and time function, data type conversion function,
Test function.
Second, the basic operation of VISUAL FOXPRO database
1, establishment, modification and validity test of databases and tables;
Establishment and modification of (1) table structure.
(2) Browse, add, delete and modify table records.
(3) Create a database and add or delete tables from the database.
(4) Set field-level rules and record rules.
(5) Index of table: main citation, candidate index, general index and unique index.
2. Multi-table operation:
(1) Select a workspace.
(2) Establish the association between tables: one-to-one association; A one-to-many relationship.
(3) Set referential integrity.
(4) table connection: internal connection; External connection: left connection, right connection and complete connection.
(5) Establish temporary association between tables.
3. Establish views and data queries:
(1) Query file creation, execution and modification.
(2) Create, view and modify view files.
(3) Establish multi-table query.
Third, the relational database standard language SQL
Data definition functions of 1 and SQL:
(1) Create table SQL
(2) Change table SQL
2. Data modification function of 2.SQL:
(1) Delete -SQL
(2) Insert–-SQL
(3) Update SQL
3. The data query function of 3.SQL:
(1) Simple query.
(2) Nested query.
(3) Connection query.
(4) Grouping and computing queries.
(5) Joint operation of sets.
Four. Use of Project Manager, Designer and Wizard
1, using the project manager:
(1) Use the Data tab.
(2) Use the "Documents" tab.
2, using the form designer:
(1) Add and modify control objects in the form.
(2) Set the data environment.
3. Use the menu designer:
(1) establishes the main option.
(2) Design a submenu.
(3) Program code for setting menu options.
4. Using Report Designer:
(1) Generate a quick report.
(2) Modify the report layout.
(3) Design grouping reports.
(4) Design multi-column reports.
5. Use the application wizard.
Verb (abbreviation of verb) VISUAL FOXPRO programming
1, command file creation and operation:
Establishment of (1) program file.
(2) Simple interactive input and output commands.
(3) Debugging and execution of application programs.
2. Structured programming:
(1) sequence structure programming.