Some of the basic knowledge of computer science level 2 is back to the bottom

There are many classes in the second level, which one do you want?

1. The basic operation is the simplest of all the questions, and it is almost a scoring question. The main tests are copying, pasting, moving (cut first and then paste), creating shortcuts, renaming, etc., all of which can be found in the right-click on the file.

2. The other is to modify the file attributes, the method is to select the file first, then right-click, select the attributes, and you can modify the calendar. It should be noted that when renaming, if it involves an extension, such as "中".docx" is the suffix of the file.

The default is off, you need to show the extension first, by opening a random folder, clicking "Organize folders and search options View" in the advanced settings bar uncheck "Hide the extension of known files".

Here's how to review the computer:

1. Read the exam syllabus carefully and determine your own review according to the exam syllabus.

2. The computer is a computer-based test, so you need to be diligent in practicing, and while reading hard, don't forget to practice on the computer to improve your typing speed.

3. Pay attention to all parts of the exam, and treat selection, judgment, and major questions equally, and do not abandon choice and judgment.

4. When reviewing, learn to look for similarities and differences in the questions, and summarize the rules.

5. Distinguish priorities and allocate time reasonably during the exam.

6. Bring your student ID, admission certificate and other test materials during the exam, and arrive at the exam room in advance to avoid panic.

7. The contents that need to be learned are: basic concepts and methods, SQL interaction under the MySQL platform, MySQL database programming, MySQL management and maintenance, MySQL application programming, etc.

Computer Level 2 Exam Content:

1. The second-level computer examination includes: advanced application of programming and office software, including computer language and basic programming ability, and requires candidates to master a computer language.

2. The optional categories include high-level language programming, database programming, etc.; The advanced application ability of office software requires the candidate to have computer application knowledge and advanced application ability of MS Office office software or WPS Office, and be able to carry out specific applications in the actual office environment.

1. Correct review method and suitable review time.

In fact, the second level of computer science is not difficult, most of it is memorization knowledge, and there is little need to be used flexibly. Therefore, it is not advisable to prepare for Level 2 too early, and it is advisable to start preparing one and a half months before the exam. Therefore, the textbook should be read through at least twice, memorize everything that should be remembered (such as variables, functions, etc.), and constantly review and reinforce.

The reference materials should not be too complicated, and the tactics of the sea of questions are not the most effective, so the question types can be appropriately classified and sorted according to the exam syllabus. For example, in the written examination of the second-level examination, there are generally four categories, and each category has a number of subcategories, including the common sense of computer hardware and software systems, some basic concepts, number systems, common sense of various peripherals, common sense of the host, etc., as well as some basic common sense of the latest development of computers, such as the Internet, multi-**, etc.; the second is the knowledge of the DOS operating system, such as directories, paths, files, etc.; the third is the basic knowledge of a certain language, such as the function and usage of command functions; The fourth is the reading and comprehension of the program in the language, which is generally given a small program and requires the candidate to understand its meaning, or choose or fill in the blanks.

2. The written examination review focuses on real questions and practice.

It is best to do the written test questions on the computer. If it is a program problem, you can enter the program into the computer and run it, and you can see what the result is. If it's commands and functions, you can also test them on your computer, so you'll find a lot of interesting tricks or something else to remember.

Generally speaking, only five sets of mock test questions plus two sets of past papers are required for the written part. However, when doing these sets of questions, we should not take a casual view, but should practice repeatedly, carefully analyze, and summarize them.

3. Practice more and prepare early for computer-based test review.

The computer-based test is relatively difficult, and 80% of those who have not passed the second level are planted in the computer-based test. There is no other way to do this than to practice more for the computer-based test. There are many scores in the programming questions on the computer, and if it is only on paper and there is no actual programming experience, it is difficult to cope with the exam.

For Level 2 candidates, in order to prepare for computer programming, they should be proficient in about 30 50 program examples. Computer-based problems generally have output results, and in order to produce output results, it is necessary to run the program and use the program debugging method. Debugging a program on the fly is an important skill.

4. Arrive in advance to ensure that nothing goes wrong.

Before the test, you should go to the waiting room 30 minutes in advance, and bring the admission ticket and ID card, in order to avoid loss, it is best to seal it in a transparent plastic bag. After entering the interface, you should carefully check the admission ticket number and ID card number to avoid unnecessary trouble. Do you want to carefully review the questions word for word, such as asking the generated forms or menus to be stored in the specified directory?

Should I go back to this directory to check? Not only to see if the content fits the topic? Also pay attention to capitalization.

What about programming or correcting mistakes? Should it be run again? Make sure nothing goes wrong.

It is best not to leave immediately after pressing "Submit Paper" after the test, and wait for the invigilator to confirm that the paper is handed in normally and agree to leave before leaving. In the unfortunate event of a crash, don't panic and shut down and restart without authorization, but raise your hand to report to the invigilator.

A computer network is a large number of independent, but interconnected, computers that work together to complete computer tasks. Below I have collected some common knowledge points of computer level 2 word, I hope you will read carefully!

1. Basic knowledge of databases1.Basic Concepts:

Databases, data models, database management systems, classes and objects, events.

2.Basic Concepts of Relational Databases:

Relational models (integrity of entities, integrity of references, integrity of user definitions), relational patterns, relationships, tuples, attributes, fields, fields, values, primary keywords, etc.

3.Basic Concepts of Relational Operations:

Select operations, projection operations, join operations.

4.SQL Basic Commands:

Query commands, operation commands.

5.Introduction to the Access System:

1) Basic features of the Access system.

2) Basic objects: tables, queries, forms, reports, pages, macros, modules.

2. Basic operations on databases and tables1.Create a database:

1) Create an empty database.

2) Use the wizard to create a database.

2.Creation of the table:

1) Build the table structure: use the wizard, use the table designer, use the data table.

2) Set the field properties.

3) Input data: Directly input data to obtain external data.

3.Establishing and Modifying Relationships Between Tables:

1) The concept of inter-table relationship: one-to-one, one-to-many.

2) Establish relationships between tables.

3) Set referential integrity.

4.Table'Maintenance:

1) Modify the table structure: add fields, modify fields, delete fields, and reset the main keyword.

3) Adjust the appearance of the table.

5.Other operations for the table:

1) Look for data.

2) Replace data.

3) Sort records.

4) Filter records.

3. Basic operations of inquiry.

1.Query Category:

1) Select Query.

2) Parameter query.

3) Crosstab queries.

4) Operational queries.

5) SQL queries.

2.Query Guidelines:

1) Operators.

2) Functions.

3) Expressions.

3.Create a query:

1) Use the wizard to create a query.

2) Use the designer to create a query.

3) Calculated in the query.

4.Actions on queries that have been created:

1) Run the query that has been created.

2) Fields in the query.

3) The data source in the query.

4) Sort the results of the query.

The Level 2 Word knowledge points in computer science are different every year, and this year follows the 2022 exam syllabus. The following is a detailed introduction to the knowledge points to be tested in Word this year.

The first is the operation that we usually use. Include the following: how to create, save, print, and protect documents, where protecting documents should be relatively unfamiliar; how to change font and paragraph formatting, set the theme style and layout of the document after finishing the text; How to create a **, which may involve how to change the style, insert text, etc.; The processing of ** may include insertion, modification, cropping and other operations, as well as the insertion of symbols and formulas, etc.; Set columns, sections, citations, page numbers, etc. for document content.

Then there are the operations that are usually relatively unfamiliar, these operations are more high-end and high-end, and you may need to use some tools and add-ins that come with Word, and you should pay more attention and practice when learning. These actions include review and revision of documents, mail merge capabilities, multi-document, controls, and macro capabilities, to name a few.

Finally, word is not a separate subject in the computer level 2 exam, it belongs to the ms office subject, if you want to register for this exam, in addition to word, you also need to master the relevant knowledge of excel and powerpoint, the exam syllabus can be on the official website of the computer grade test**, there are related textbooks, follow the learning is no problem.