Chongqing Zhao Chun information technology must memorize knowledge points.

The necessary knowledge points of Chongqing Spring Recruitment Information Technology include word and chart processing, computer network technology foundation and online resource retrieval.

First, text and chart processing

1, commonly used word processing software are: Microsoft Word; ; The commonly used chart processing software is Microsoft Excel.

2.Excel workbooks usually consist of several independent worksheets, which are composed of cells. A cell is the smallest unit of an Excel workbook.

3. Worksheet: An independent table composed of rows and columns is called a worksheet.

4. Column numbers are identified by letters, and line numbers are identified by numbers.

5. The intersection of rows and columns is called a cell.

Second, the computer network technology foundation

1, the disadvantages of bus topology are limited transmission distance and communication range. When the interface fails, it will affect the whole network and it is difficult to diagnose and isolate. Only one end user can send data at a time, and the other end users have to wait until they get the right to send, so the media access control mechanism is more complicated.

2. The star topology structure is simple to control, easy to diagnose and isolate faults, and convenient to maintain.

3. The disadvantage of star topology structure is that the cable length and installation workload are quite large, and the load of the central node is heavy, which forms the bottleneck of information transmission rate and requires the central node to have high reliability and redundancy.

4. Ring topology is a closed loop composed of sites and links connecting sites. Each station can receive data from one link and send data serially to another link along the ring at the same rate.

5. Each end user of the ring structure is connected with two adjacent end users, so there is a point-to-point link, but it always runs in one direction. There are upstream users and downstream users.

Third, online resource retrieval.

1, three commonly used information retrieval methods on the Internet:

A. Topic Directory: It is a hierarchical index of topic categories, and most topics are divided into several categories or subdirectories.

B, search engine.

C. Meta-search engine: also known as multi-search engine or parallel search engine.

2. Subject catalogs organize all kinds of information in the form of classified catalogs by hypertext links, and subdivide categories step by step according to levels.

3. The lowest-level subject directory consists of hyperlinks to specific World Wide Web sites or web pages.

4. It is convenient to find information through the subject catalogue, but there are some problems such as narrow search scope, less related content, low efficiency and difficulty in retrieving more professional information.

5. Two core technologies of search engine: automatic web search technology and full-text retrieval technology.