Author: Liu Yuan Jianbo
ISBN 978-7-5058-9240-8
Economic Science Press 20 10.5 Computers have penetrated into all aspects of human social life, and the application of computers has become the basis for the development of various disciplines. Therefore, learning and mastering the basic knowledge of computer has become an urgent requirement for people. Only by mastering the basic skills and operating skills of computer application can we stand at the forefront of the times, adapt to the requirements of social development and become a new type of useful talents. As we all know, Microsoft has made great contributions to people's information processing. Since the first version of Windows and Office was released, we have witnessed great changes in people's work and life. With the continuous progress of technology, people's work efficiency is also constantly improving, even affecting people's behavior, thoughts and habits. In order to adapt to the understanding of basic computer knowledge by all social strata and popularize the basic application of computers, we have compiled the book "Computer Basic Culture" by combining the rich experience accumulated in computer teaching practice for many years, adopting the teaching concept of "task-driven" and keeping up with the trend of computer technology.
This book is written on the basis of projects and tasks, learning knowledge points in the process of completing tasks, so that students can learn useful things. This book is mainly divided into ten items. The first and second projects talk about the basic knowledge of computers, including the development, characteristics, application and composition of computers, the representation of data in computers, and the concept of computer viruses. The third project introduces Windows XP operating system, and introduces the basic concepts, concepts and basic operations of files in Windows XP through specific cases. The fourth project introduces the word processing system Word 2007, which mainly completes the tasks of text input and editing, document formatting, mixed arrangement of pictures and texts, table editing and processing. Project 5 describes the spreadsheet processing system Excel 2007, which mainly completes the creation, arrangement and format setting of spreadsheets, analyzes and processes data by formulas or functions, and establishes charts in various formats. Project six completed the production of PowerPoint 2007 slides through a complete case; Project 7 introduces the use of Access 2007 database, and completes the creation of Access database and tables, the operation of records, the design and creation of queries and the design of forms through several tasks. Project 8 tells the basics of computer network and Internet, mainly introducing the basic concept of network, the development and application of Internet, the use of IE and the knowledge of e-mail. Item 9 introduces the related knowledge of multimedia technology; Project 10 lists several comprehensive training cases according to the previous contents.
Considering the characteristics of beginners, this book adopts modular structure, with illustrations and prominent points. The content of each project has detailed operation steps, which are easy to understand, and there are corresponding exercises after each project. This book can be used as a teaching material for non-computer majors in higher vocational colleges, and also as a teaching material or reference book for basic computer courses for applied undergraduate students.
This book is edited by Liu and Yuan Jianbo, with Chang, Wei Shengli, Li Chunyu, Guo Jianlin, Guo and Zhou as deputy editors. Other editors include Zhu Lihua, Sang Shujuan, Lu Na and Li Gang. Among them, Li Chunyu compiled projects 1 2, Guo, Zhu Lihua and Sang Shujuan compiled projects 3 and 7, Wei Shengli compiled projects 4, Guo Jianlin, Chang edited projects 5, Liu edited projects 6 and Li Gang compiled projects 8 and 9, and finally Yuan Jianbo was responsible for the compilation and compilation of the whole book. Due to the limitation of the author's level, there are inevitably some shortcomings in the book. Please criticize and correct me. Project 1: Understanding Computers 1
Task 1: Understand the development process and trend of computers 1
Task 2: Investigate the application fields of computers.
Item 2 Basic Computer Knowledge 8
Task 1: master the composition of computer system 8
Task 2 Microcomputer Hardware Composition 14
Task 3 Understanding the Representation of Data in Computer 19
Task 4 Computer Virus 26
Item 3 Windows XP Operating System 28
Task 1 Make a personalized desktop 29
Task 2 Create Folder 40
Task 3 Moving and Deleting Folders 43
Task 4 Project Management 46
Task 5 Computer Management 5 1
Item 4 Word 2007 Word Processing Software 57
Task 1: Create a new Word document 58
Task 2: Making a Notice in the Newly Created Document 67
Task 3: Make Resume Form 79
Task 4: Making Student Report Form 85
Task 5: Make personalized stationery 9 1
Task 6: Make a postcard 97
Item 5 Excel 2007 Spreadsheet Processing Software 105
Task 1 Understanding Excel 2007 Work Interface 106
Task 2 Basic Operation of Excel 2007 (1) 1 10
Task 3 Basic Operation of Excel 2007 (2) 1 15
Task 4 Use of Formulas and Functions (1) 125
Task 5 Use of Formulas and Functions (2) 129
Task 6 Use of Formulas and Functions (3) 13 1
Task 7 Use of Formulas and Functions (4) 134
Task 8 Data Analysis (1) 136
Task 9 Data Analysis (2) 139
Task 10 data analysis (3) 14 1
Task 1 1 data analysis (4) 143
Task 12 Chart Operation (1) 146
Task 13 chart operation (2) 150
Project 6 PowerPoint 2007 Presentation Making Software 155
Task 1 Understanding PowerPoint 2007 Work Interface 156
Task 2 Creating a Presentation 159
Task 3 Editing Presentation 166
Task 4 Design the appearance of the presentation 175
Task 5 Set Animation Effect 182
Task 6 Add Hyperlink 186
Task 7 Display Presentation 187
Task 8 Print Presentation 189
Task 9 Publish Presentation 19 1
Project 7 Access 2007 Database Management System 196
Task 1 Understanding Database 197
Task 2 Understanding Access 2007 Work Interface 203
Task 3 Create the Employee Salary database 205.
Task 4 Create Employee Payroll 207
Task 5 Edit Employee Payroll 2 1 1
Form Design of Table 2 16 of Task 6 "Employee Salary"
Report Design of Task 7 "Employee Salary" Table 22 1
Item 8 Computer Network 227
Task 1 Understanding Computer Networks 228
Task 2 Understanding the Classification of Computer Networks 230
Task 3 Understand the basic structure of computer network topology 23 1
Task 4 Understanding Network Protocols and Architecture 234
Task 5 Understanding Generic Network Hardware 236
Task 6 Mastering the Basic Knowledge of the Internet 239
Task 7 Applying Internet Explorer 244
Task 8 Apply for and Use Free E-mail 250
Task 9 Using Outlook to Send and Receive E-mail 254
The use of task 10 download software FlashGet 257
Task 1 1 Use search engines to find useful information 26 1
Item 9 Multimedia Technology and Application 265
Task 1 Photoshop 7? Installation and uninstallation of 0 265
Task 2 Image File Size Editing and Format Conversion 268
Task 3 Simple Flash Shape Animation 27 1
Task 4 Simple Audio Processing 273
Task 5 Understanding Media and Multimedia Technologies 277
Task 6 Understanding Multimedia Communication Technology 280
Project 10 Comprehensive Training 282
Comprehensive training I 282
Comprehensive training II 282
Comprehensive training III 283
Comprehensive Training IV 284
Comprehensive training v 285
Comprehensive training VI 286
Comprehensive training VII 287
Comprehensive training 8 288