The comprehensive professional examination includes C language, database and network technology, and each subject has a certain score.
That is to say, take both exams.
Shenyang University 20 1 1 Undergraduate Computer Science and Technology Major Comprehensive Course Examination Outline
Author: Shenyang University Vocational and Technical College Source: Shenyang University Vocational and Technical College Click Rate: 75
-
I. Guiding ideology
Through this entrance examination, it mainly tests the comprehensive mastery of computer professional knowledge learned by candidates during their college studies, and provides unified, objective and fair competition conditions and opportunities for candidates and enrollment schools.
Second, the principle of proposition
1. It is put forward in strict accordance with the contents and requirements stipulated in the examination syllabus, and there are no overstepping, digression or strange questions.
2 papers should not only pay attention to the assessment of basic concepts and theoretical knowledge, but also pay attention to the assessment of basic professional skills.
Second, the principle of proposition
The examination is divided into two parts: professional comprehensive course examination and skill test, with a full score of 300.
The professional comprehensive course examination is a closed-book written examination with a full score of 200. Including: C language (80 points), database (60 points) and computer network technology (60 points).
Skills test score 100, the content is computer operation skills (100). The examination form is practical operation.
Part I: C Language Examination Outline (80 marks)
"Database" examination outline (60 points)
"Computer Network Technology" examination outline (60 points)
Part II: Computer Operation Skills Examination Outline (100 mark)
Part I: Specialized comprehensive courses
"C language" examination outline (80 points)
First, the basic part.
1. Familiar with constants and variables
2. Master arithmetic operators and expressions.
3. Proficient in data input and output.
Second, simple programming.
Requirements: be able to write programs, improve programs, judge programs, and write correct running results.
1. Master the sequence structure.
2. Master the branch structure skillfully.
If ... otherwise ...
Switch ...
3. Familiar with the cycle structure
While loop; Do-while loop; For loop
Third, the array
65438+
2. Master sorting and selecting numbers from the array.
3. Understand the usage of strings and string functions.
4. Master the print format of the array
Fourth, function
1. Master the definition and call of functions.
2. Understand how values are passed.
3. Master the use of recursive functions.
Verb (abbreviation for verb) pointer
1. Understanding pointers to variables
2. Master the pointer of one-dimensional array
Six, the structure and * * * the same body
1. Understanding definition and initialization
2. Understand the use of structural variables
Seven. certificate
1. Learn how to open a file.
2. Master the use of file reading and writing functions.
3. Master the establishment and output of text files.
Reference materials:
C Language Programming, edited by Xiao Xia and Chen Liangsheng, Northeastern University Press.
C Language Programming, edited by Bi Wanxin, Dalian University of Technology Press.
"Database" examination outline (60 points)
I introduction of database system
1. Understand information, data and their relationships.
2. Understand the database, database management system and functions.
3. Grasp the characteristics of the database system
4. Understand the composition of the database system
5. Data model
(1) Master the definition and classification of data models.
(2) Master the representation method of conceptual model.
(3) Understand the most commonly used structured data models.
6. Database system architecture
(1) Familiar with the three-level schema structure of the database.
(2) Master the two-level mapping function and data independence of the database.
Second, the relational database
1. Learn about the relational model overview.
2. Grasp the data integrity of the relational model.
3. The relational database standard language SQL
(1) Understand the basic concepts of SQL language.
(2) Master the basic functions of SQL language.
Third, relational data theory and database design
1. Mastering functional dependencies
2. Master the paradigm and 2NF skillfully.
3. Understand the steps of database logical structure design.
4. Master the transformation from E-R model to relational model.
Fourth, the basic operation of data
1. Master the definition, deletion and modification (creation, deletion and modification) of basic tables.
2. Understand index definition and deletion (creation and deletion)
3. Master the query (select)
4. Master data update (insert, update and delete)
5. Understand the definition, query and function of the view.
Fourth, basic knowledge of FOXPRO language
1. Understand data types, constants and variables, and expressions.
2. Common functions and their applications
Master digital processing function
Proficient in character processing functions
Understand date and time functions
Master the function of type conversion
Understand the test function
Five, the basic operation of database
1. Understand the establishment of database file structure
2. Master the editing and modification of database records.
3. Database statistics and calculation
Master the statistics of the number of records, the sum of numerical fields, the average value of numerical fields and classified summary.
4. Understand sorting and indexing queries
5. Be familiar with index files
6. Grasp the database sequential query
Six, FOXPRO programming
1. Master basic input and output commands.
2. Structured programming
Understand the sequence structure.
Master the choice structure
Familiar with circulation structure.
3. Understand the nesting of structures
4. Processes and functions
Understand the concepts of main program and subroutine.
Understanding the definition of process
Understand the call of the procedure.
Reference materials:
Database Application Technology, edited by Shen Shikai and Li Haiyan, China Railway Publishing House.
Visual Foxpro Programming and Application Course, edited by Fan Linan and Zhang Yu, Science Press.
"Computer Network" examination outline (60 points)
I. Overview of computer networks
Understand the concept of computer network.
2. Master the composition of computer network.
3. Familiar with the classification and characteristics of computer networks.
4. Master the function of computer network.
5. Understand the application of the Internet.
Second, the basis of data communication
1. Master the basic concepts of data communication.
2. Master the data transmission mode.
Third, the network architecture
1. Understand the basic concepts of architecture
2. Master the composition of OSI architecture.
3. Master the TCP/IP architecture and the main functions of each layer.
4. be familiar with IP addresses.
Fourth, establish a local area network.
1. Master the classification and characteristics of LAN.
2. Master the common interconnection equipment of LAN.
3. Master the classification and topology of WLAN.
Verb (abbreviation for verb) network management
Understand the definition of network management.
2. Understand the function of network management.
Reference materials:
Computer Network Training Course (2nd Edition), edited by Zhang Haojun, Higher Education Press.
Part II Skills Test
Computer Operation Skills Examination Outline (100)
Skills test requires students to disassemble the corresponding hardware and assemble a complete microcomputer according to the provided software and hardware environment; At the same time, system software can be installed.
A, the structure of the microcomputer
1. Understand the composition and structure of microcomputer system.
2. Understand the types of microcomputers
3. Master the installation of various hardware in the microcomputer.
Second, the motherboard.
1. Understand the structure and function of the motherboard.
2. Master the installation of the motherboard
3. Be familiar with the disassembly and assembly of motherboard power supply (P8, P9) and central processing unit (CPU).
Third, internal memory.
1. Understand the classification of memory.
2. Be familiar with the interface of memory on the motherboard and the disassembly and assembly of memory.
Fourthly, magnetic storage devices.
1. Understand the structure of floppy drive and hard disk.
2. Master the use of floppy disks.
3. Be familiar with the disassembly and fixation methods of 3-inch floppy drive and the connection of data cable and power supply.
4. Be familiar with the removal of hard disk and the connection of data cable and power supply.
Verb (abbreviation for verb) output device
1. Understand the classification and structure of graphics cards and monitors.
2. Be familiar with the disassembly and connection of video cards and monitors.
Six, the input device
1. Understand the classification and structure of keyboard and mouse.
2. Master the connection between keyboard and mouse.
Seven, power supply
1. Understand the function of power supply.
2. Master the classification and function of each output plug of power supply.
3. Be familiar with the installation of power box and the connection of output plug.
Eight, the main components in the motherboard disassembly
1. Understand the functions of battery and reset, power LED, SPK and hard disk LED plug-ins on the motherboard.
2. Master the disassembly and assembly of the motherboard battery.
3. Master the reset on the motherboard, the disassembly and assembly of power LED, SPK and HDD LED plug-ins.
Nine, software installation
1. Master the software installation process.
2. Familiar with the basic CMOS settings.
3. Familiar with hard disk partition and formatting.
4. Be familiar with the installation method of DOS system and the installation of corresponding files.
Reference materials:
Computer Maintenance and Repair, edited by Chen, Mechanical Industry Press.