Material**: Computer Level 2 Treasure Book app
This guide is full of dry goods! To help you understand the computer level 2 exam in an all-round way, Xiaobai will directly stop and watch carefully!
1. Information literacyAs the saying goes, "firewood workers are only good at sharpening knives", so be prepared to collect exam-related information before preparing for the exam.
Exam Subjects
From the perspective of major types, computer level 2 is mainly divided into database, language and office software, to be more specific:
Databases: Access database programming, MySQL database programming.
Languages: C, J**A, C++, Web, Python Hypothesis.
Office software: WPS Office Advanced Application and Design, MS Office Advanced Application and Design.
Advice on the selection of subjects to be taken:
If you are majoring in management or grammar, such as administrative management, business administration, Chinese language and literature, law, etc., and you want to engage in related work in the future, you can take the WPS Office Advanced Application and Design, MS Office Advanced Application and Design.
If you are a computer science major and want to engage in related work in the future, you can choose to take the C language, J**A, C++, Web, Python hypothesis, VB, etc. Among them, the certificates of C language, J**A, and C++ will be higher.
If you are majoring in economics, such as finance, investment, accounting, insurance, etc., you can take MySQL database programming, access database programming, and OpenGauss database programming.
If you are a big data major and want to engage in web development in the future, you can take the web programming test if you want to be a big data analyst, web front-end engineer, or web architect.
From the point of view of practicality alone, it is highly recommended that you apply for MS OfficeThis is also the largest number of applicants at the moment. Because its function is very powerful, covering all the operation content of WPS Office, it is more in-depth than WPS, very practical, can meet all daily office needs, and the gold content of the certificate is naturally very high, which is an aspect that many employers pay more attention to during interviews.
Exam content
C language: DOS commands, computer composition principles, multi-**, database operation, computer networking, C language programming, computer-based exam.
C++: Overview of the C++ language, data types, operators and expressions, basic control statements, arrays, pointers and references, functions, class and object inheritance, templates, and more.
j**a: Introduction to the J**a language, j**a data types, operators and expressions, flow control, class, array and string operations, exception handling, input/output and file operations, thread and object serialization, writing graphical user interfaces, applet programming, jzsdk and operations, j**a applications.
Python: basic syntax elements, basic data types, program control structure, file and data formatting, and Python computing ecology.
MS Office: Basic knowledge of computers, functions and usage of Word, Excel, PowerPoint.
WPS Office: The functions and usage of WPS software
access: database systems, databases and tables, database query forms, reports, data access pages, macros, modules, and so on.
MySQL: basic database concepts and methods, SQL, interactive operations, MySQL database programming, MySQL management and maintenance, MySQL application programming, etc.
Web: Web Technology Basics, HTTP Protocol Basics, HTML Basics, CSS Basics, J**Ascript Programming Basics, and Dynamic Web Technologies Overview.
OpenGauss: basic database operations, SQL language used to complete database interaction operations on the OpenGauss platform, OpenGauss database programming, OpenGauss database management and maintenance technology.
3.Exam time
March and September are national examinations, and there will be supplementary questions (2-4 sets);
June and December are exams in some regions, and there are generally no supplementary questions.
The total duration of the exam is 120 minutes.
4.Exam format
Computer-based assessment (out of 100 points).
A score of 60 or less is considered unsatisfactory, 60-79 is a pass, 80-89 is good, and 90-100 is excellent.
2. Data selection
As the saying goes, "if you want to do a good job, you must first sharpen your tools", and you must choose the review materials before preparing for the exam. You don't need to prepare too much information for the computer level 2 MS office exam, just prepare one question bank and one course.
Computer Level 2 Treasure Book Question Bank + Course
Textbooks are not necessities, students who don't like to chew books, or who don't have enough time to prepare for the exam, can choose not to buy them, just follow the class and brush the questions. The question bank is definitely something that every computer learner has to brush before the exam, and if necessary, they have to brush it twice! Three brushes! Brush up on the practical practice! Use the question bank and supporting ** lessonsThe efficiency of learning will be higher, and you don't have to worry about taking detours at all. The main thing is that it is easy to understand, and it is more suitable for computer novices. Not only will I talk about the knowledge points, but I will also talk about the operation over and over again, you can intuitively feel what the specific operation process is like, and you can quickly get started when you go to practice after listening to yourself, and the practicality is relatively high.
Especially in the excel section, the connection between the various links is really strong, it can be said that it is interlocking, and as the most difficult of the three operation problems, it must be taken seriously. In short, as long as you can thoroughly understand the question bank and real question operation of computer level 2 before the exam, it is still easy to think about the passing line for the exam.
Moreover, the questions in the computer test are randomly selected from the question bank, and more than 90% of them are original questions, which means that the questions we usually brush are likely to be encountered in the examination room, so we must go through the real question papers of the past years at least once before the exam. The computer second-level treasure book question bank contains all the real questions, as well as new question types, it can be said that the question types are very rich, the amount of questions is enough, thirty-seven sets, on the basis of listening to the lecture to master these real questions thoroughly, the exam is absolutely stable.
IIIReview process (30 days).
10 days to watch the class: understand all the knowledge points in MS Office
The course and the real test practice are matched with each other to learn, don't come up and focus all on listening to the class, especially for the pure novice who has no foundation, and don't think that you can master the knowledge points just by listening to the lecture and memorizing the test points, which will inevitably not work. Note: Finally, it is necessary to put the center on the operation problem, and the efficiency of the problem is raised, which is very important, and it must be paid attention to! Teach you a little trick to better assist yourself in memorizing knowledge points:Practice while listening to the class, and the effect is doubled. When the teacher is talking about practical exercises, don't just listen, you can practice together, and after speaking, practice by yourself to see how effective your listening is.
In this way, you can not only improve your concentration in class, but also check and fill in the gaps in time, and when you encounter any doubts, you can return the course in time to take a look at it, and do a good job of supplementing the knowledge points, so that the later practice will be smoother.
25 days of past papers: Proficiency in the operation of various question types
The importance of question banks has already been emphasized, so I won't say much about it here. I only emphasize one point: we must do a good job of summarizing and reviewing in time during the brushing stage!
Summary: Every time you finish the question, don't look at the analysis twice and feel that you know how to understand, and the next time you encounter the same type of test question, you will still make mistakes. Therefore, it is necessary to develop a good habit of sorting out the wrong questions from the beginning, carefully analyze the wrong questions, sort out the knowledge points investigated into the wrong question book, and summarize the types of questions that are often wrong, think about why you are wrong, and pay more attention to this regard when you do it next time. In addition, you should also summarize the answer order that suits you every time you brush the questions, and see how to answer the questions most efficiently to avoid the situation of incomplete answers in the examination room.
Review: After the mistakes are sorted out, you must be good at reviewing, and you can't just leave it alone. Set aside at least half a day for yourself every week to take out the wrong questions of the week and do it again, solve any doubts in time, look at the course again if you don't understand, and at the same time find the same type of test questions to practice again, the purpose is to solve all the doubts before the exam as much as possible.
5 days to do a sprint: pay attention to the memorization of multiple-choice knowledge points
At this stage, on the basis of ensuring the amount of daily operation questions, we should focus on multiple-choice questions, try to memorize knowledge points in the form of brushing questions, and subconsciously memorize the answers to multiple-choice questions every time I finish brushing, and do a good job of assault, and I can get a very good score in the exam.
Fourth, the preparation experience summary
Brush question order: Multiple choice questions ppt word excel
When preparing for the exam, I will focus on the operation questions first, and then focus on the multiple-choice questions about a week before the test.
However, when answering questions in the exam room, you must make choices before doing the operation, and you should pay attention to the fact that after the multiple choice questions are submitted, you cannot go in and make modifications, so you must make sure that you have completed all the multiple choice questions and checked them before submitting.
PPT in the operation questions is generally relatively simple, you can do it first; Word is generally not difficult, but the amount of questions is generally relatively large, and it takes a bit more time to answer the questions, so you can put it in the second place; Excel is the most difficult, especially the problem of dealing with functions, which can be left to the end.
In short, no matter what order you answer, you must always keep in mind the principle of easy first and then difficult, and what suits you is the best.
2.PPT must get points, as much as possible to get full marks!!
This module is the easiest type of question in the operation question, and it doesn't take a lot of time to answer the questions, as long as you can thoroughly understand the course when preparing for the exam, and then brush up a few more sets of real questions by yourself, you can basically summarize where the test center is, and it is really good to get points in the exam room.
3.The second biggest score point of word must be caught!!
The biggest feature of this module is that the knowledge points examined are very miscellaneous, the difficulty is higher than that of PPT, and the amount of exam questions is also relatively large, which requires us to have enough patience and carefulness.
Every time I brush the questions in this module, I spend a lot of time, and I don't think that I can get a full score, at least I can ensure that I can do the questions correctly, and reach a score of more than 20.
4.Excel focuses on the memorization of function formulas!!
The reason why I find it difficult is that there are so many function formulas that need to be memorized, so it can be said that if the formula can't remember the problem, it will not be able to do it correctly. In addition, there is a strong correlation between each step of excel, and I have to think carefully for a long time every time I do a question, for fear that I am afraid that I will lose all the games if I accidentally do it, because as long as one of the steps is wrong in this type of question, I will not get a full score.
To put it bluntly, this piece is not for good and excellent, so just work hard to get as many points as possible, and don't force yourself to ...... too much if you can't learn
5.Points to note when taking the exam
There are a total of 20 multiple-choice questions, one point for each question, and it is recommended that the answering time should not exceed 10 minutes. The first 10 complex questions (there are calculation questions, it is not recommended to spend too much time), and the last 10 questions are slightly simpler. Finally, leave about 10 minutes to check it, mainly to see if you have any missing questions that you have not answered. Do it at any time and save it at any time!! Ctrl+S" quick save key for me to remember!!
5. Determination to take the exam
The difficulty of the computer test is not high, and it is actually not too late to start, as long as you can put more effort into it before the test, the final result will definitely not be very bad. And it is a qualification exam, we don't need to study hard, spend an hour or two every day listening carefully to the class and brush up on the questions, and the exam will almost be passed. Everyone must build up confidence in preparing for the exam and strive to pass the computer level 2 exam at one time!