Basic computer knowledge learning

WEEK 1

I. In terms of knowledge, it is to learn basic computer knowledge.

1. Understand the development, application, composition, and network of computers;

2. Learning about computer operating systems: common operating systems, operating system functions and classifications;

3. Learning office software: Word \ Excel \ PPT, such as the numbering format in word, automatically generated directory, the application of conditional format in Excel, the insertion of charts, and the use of various basic functions:

= Sum (EOO * $ e $3, foo * $ F $3, Goo * $ G $3) indicates: returns the sum after the numbers in the E \ f \ G column are multiplied by E3 \ F3 \ G3. The count (IF) \ A counting function is used,

= Countif (C4: C34, "male") count (IF) \ A counting function, which indicates the number of male cells in C4 to C34,

= Large (H4: h34, 1) Large \ small: For details, see the number of rows and columns in the cell "first" and "second,

= Averageifs (H4: h34, C4: C34, "female", D4: d34, "retail") Multi-condition \ condition average value: calculate the average value for the values from H4 to h34, the first condition is that cells from C4 to C34 are displayed as female, and cells from D4 to d34 are displayed as retail values for average,

= Median (H4: h34) MAX \ min \ median function indicates that the maximum, minimum, and median values from H4 to h34 are displayed in cells,

PPT creation: Mainly learns how to create animation effects and trigger settings: animation effect: insert an image, crop the image, and select several images, in the format, select to be placed on the top layer. For more information, see the combination of several images. Then, select the entire image, customize the animation, add effects, Action paths, and align to left/right, when a line appears on the image, you can pull the line and set the path length of the image. Generally, the time is the slowest. If you think the time is too fast, you can select a small triangle. After selecting an advanced daily table, A pale yellow area appears after the image name. You can set the start time and end time as you wish before and after dragging the area. Set the trigger: After selecting the image to be triggered, select a custom animation, after the image name is followed by a small triangle, click, select the effect option, timing, trigger, click the following object to start the effect, select the image you want to achieve the triggering effect, there are also some categories of PPT insert images, insert sound and other effects, just need to set the path, basically there is no problem.

4. Brief Introduction to Internet. Here I learned several different network protocols: HTTP (hypertext protocol, used for sending and receiving web pages), FTP (text protocol, that is, for receiving various files ), in addition to SMTP, there are also basic TCP/IP Working principles.

5. Some basic command line exercises: ipconfig/all view the detailed network configuration of the current local machine

Server to view the current version of the Local Machine

Ping to check whether the current machine is successfully connected to the target computer

Dir display disk directory

CD + space + Space = .. return the upper level of the opened file

6. Learning the Mind Map, learning the hand-drawn Mind Map, and using the software Buzan's imind map to draw the Mind Map.