Basic computer knowledge learning and basic computer knowledge
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.
What should I read when I learn basic computer knowledge?
Computer learning has become unavoidable in this era. Many young people regard computer as a tool for future survival. How to grasp this technology as soon as possible has become increasingly impatient. Now that you want to learn a computer, you should always get started. To learn everything, you must get started. Generally, "Everything starts hard." However, due to the ease of use of computers, I don't think it is difficult to get started with a computer, but the key is the degree to which this entry is worth discussing. I have been studying Computer for several years. Of course, my skills are not experts, but I have always had some experiences after so many years of study. When talking about my computer learning experience, of course, "Getting Started" is indispensable. "Getting Started" seems simple, but it is actually not. How to get started, it will have a great impact on further study in the future. Here, I don't want to introduce a specific method of some technology. I just want to give my own views on the problems existing in my primary computer learning and hope to provide some reference for my friends who are new to computers.
The process of getting started with computers is full of difficulties and frustrations, but the joy of success is self-evident. How to overcome difficulties and get happiness is what we will discuss. Now, I am going to talk about how to get started with computer from four common problems: Interest Cultivation, operating system, WINDOWS, and Chinese character input.
1. Interest is a wonderful result
Interest is almost the key to learning a variety of knowledge, and interest cultivation is the most difficult, but it depends on whether there are correct training methods. The diversity of computer technology has been applied in almost all fields. When we see the effects of computer design for the first time, everyone will be amazed at the wonders of the computer, this is the initial interest that comes out of the box. With this step, you may have a strong learning idea, which is also the easiest time to give up. When we started learning, we found that what we learned was not so wonderful. It was nothing more than simple operations and text input. When you typed it again, you will feel bored and give up learning after you repeat it. At this time, you should stop for a while, but never put it aside. You should stick to it, or listen to songs, and enjoy others' exquisite designs, if your computer is connected to the Internet, you can access the Internet and do things unrelated to learning. Slowly, the idea of learning a computer will sprout again. You will always think that other people's design is so beautiful, and you will ask yourself if you can make the same effect. Of course, you can. Computer interest is generated after repeated experiences, and is getting stronger and stronger.
Ii. How to step by step the operating system.
In computer learning, the most basic thing should be the learning of the operating system, which involves basic operations so that you can access other things. Of course, we will not discuss it from the switch-on machine. Let's talk about the operating system. Nowadays, most popular computer mainstream operating systems are Windows. In such a variety of window operating systems, people's operations become very stupid, as if everything is very simple, generally, a person who has no access to a computer can understand what is "folder", "Notepad", "Drawing", and "mine" in a short period of time, however, such learning results do not enable people to understand the associations between various computer operations, and you will never understand what these things are. Instead, they make people feel that computers are too simple to be interested. Here I recommend that you learn about DOS. DOS is an operating system in the early stage of computer development. It can further access the underlying computer. In fact, the running mode of Win98 inherits most of the features of DOS. Learning DOS makes us realize the basic knowledge of "directory" and "file", and understand its relevance. In the process of learning DOS, understanding the doscommand is essential, but we usually only need to know the general disk and file operation commands, because DOS is not necessary for future use after all, we learn it just to pave the way for future learning, and it is a basic foundation.
3. Windows is a simple and complicated world.
The birth of Windows has changed the way people use computers and their lifestyles. Its powerful multimedia functions make us enter a new digital world. To understand Windows, we should first understand its multi-user and multi-task features. What is multi-user and multi-task? If you have been in touch with DOS before, it is for DOS ...... the remaining full text>
What should I read when I learn basic computer knowledge?
Computer learning has become unavoidable in this era. Many young people regard computer as a tool for future survival. How to grasp this technology as soon as possible has become increasingly impatient. Now that you want to learn a computer, you should always get started. To learn everything, you must get started. Generally, "Everything starts hard." However, due to the ease of use of computers, I don't think it is difficult to get started with a computer, but the key is the degree to which this entry is worth discussing. I have been studying Computer for several years. Of course, my skills are not experts, but I have always had some experiences after so many years of study. When talking about my computer learning experience, of course, "Getting Started" is indispensable. "Getting Started" seems simple, but it is actually not. How to get started, it will have a great impact on further study in the future. Here, I don't want to introduce a specific method of some technology. I just want to give my own views on the problems existing in my primary computer learning and hope to provide some reference for my friends who are new to computers.
The process of getting started with computers is full of difficulties and frustrations, but the joy of success is self-evident. How to overcome difficulties and get happiness is what we will discuss. Now, I am going to talk about how to get started with computer from four common problems: Interest Cultivation, operating system, WINDOWS, and Chinese character input.
1. Interest is a wonderful result
Interest is almost the key to learning a variety of knowledge, and interest cultivation is the most difficult, but it depends on whether there are correct training methods. The diversity of computer technology has been applied in almost all fields. When we see the effects of computer design for the first time, everyone will be amazed at the wonders of the computer, this is the initial interest that comes out of the box. With this step, you may have a strong learning idea, which is also the easiest time to give up. When we started learning, we found that what we learned was not so wonderful. It was nothing more than simple operations and text input. When you typed it again, you will feel bored and give up learning after you repeat it. At this time, you should stop for a while, but never put it aside. You should stick to it, or listen to songs, and enjoy others' exquisite designs, if your computer is connected to the Internet, you can access the Internet and do things unrelated to learning. Slowly, the idea of learning a computer will sprout again. You will always think that other people's design is so beautiful, and you will ask yourself if you can make the same effect. Of course, you can. Computer interest is generated after repeated experiences, and is getting stronger and stronger.
Ii. How to step by step the operating system.
In computer learning, the most basic thing should be the learning of the operating system, which involves basic operations so that you can access other things. Of course, we will not discuss it from the switch-on machine. Let's talk about the operating system. Nowadays, most popular computer mainstream operating systems are Windows. In such a variety of window operating systems, people's operations become very stupid, as if everything is very simple, generally, a person who has no access to a computer can understand what is "folder", "Notepad", "Drawing", and "mine" in a short period of time, however, such learning results do not enable people to understand the associations between various computer operations, and you will never understand what these things are. Instead, they make people feel that computers are too simple to be interested. Here I recommend that you learn about DOS. DOS is an operating system in the early stage of computer development. It can further access the underlying computer. In fact, the running mode of Win98 inherits most of the features of DOS. Learning DOS makes us realize the basic knowledge of "directory" and "file", and understand its relevance. In the process of learning DOS, understanding the doscommand is essential, but we usually only need to know the general disk and file operation commands, because DOS is not necessary for future use after all, we learn it just to pave the way for future learning, and it is a basic foundation.
3. Windows is a simple and complicated world.
The birth of Windows has changed the way people use computers and their lifestyles. Its powerful multimedia functions make us enter a new digital world. To understand Windows, we should first understand its multi-user and multi-task features. What is multi-user and multi-task? If you have been in touch with DOS before, it is for DOS ...... the remaining full text>