catalogue
Chapter 1 Computer Foundation
1. 1 Computer Introduction 1
Development 1. 1. 1 computer 1
1. 1.2 Characteristics of Computer 2
1. 1.3 computer application ii
1.2 common digital systems and codes of computers 4
1.2. 1 binary number 4
1.2.2 binary and other digital systems 5
1.2.3 conversion between different binary numbers 6
1.2.4 Representation of Binary Numbers in Computer 8
1.2.5 Common information coding 9
1.3 composition of computer system
Computer system 1 1
1.3.2 Basic structure of computer
1.3.3 Hardware resources in microcomputer 13
1.3.4 basic input and output devices 17
Software configuration of 1.3.5 microcomputer 19
1.4 multimedia computer 22
1.4. 1 Basic concepts of multimedia 22
1.4.2 multimedia computer system 22
1.4.3 multimedia technology application 23
1.5 Introduction to Computer Virus and Its Prevention and Cure 23
1.5. 1
Danger 23
1.5.2 Structure and classification of computer viruses 24
1.5.3 computer virus prevention 25
1.5.4 Introduction to Common Antivirus Software 26
1.6 Introduction to Computer Industry and Main Products 27
1.6. 1 the rise and development of the computer industry 27
1.6.2 the appearance and great success of microcomputer 27
1.6.3 internationally renowned computer companies and their products
Introduction 29
1.6.4 Brief introduction of major domestic computer companies 32
Exercise 33
Chapter II Chinese Windows 98 35
2. 1 overview 35
2. 1. 1 development history 35
2. 1.2 function 35
2. 1.3 Operating environment and installation 36
2. 1.4 Start and exit 38
2.2 Basic knowledge and operation of Windows 98 38
2.2. 1 Desktop Introduction 38
2.2.2 Starting and Quitting Applications 39
2.2.3 Use of the mouse
Windows and Dialogs 4 1
Menus and Toolbars 42
Clipboard 43
Help system 44
2.3 MS-DOS mode 45
2.3. 1 DOS foundation
MS-DOS mode 48
2.4 Windows 98 Resource Manager 48
Files and Folders 48
2.4.2 "Browser" window 49
2.4.3 Managing files and folders 50
2.4.4 Use of "Recycle Bin" 53
Shortcut 54
2.4.6 Association between files and applications 55
2.5 Windows 98 Control Panel 55
2.5. 1 Adjustment of display attributes
2.5.2 Add new hardware 58
System 60
2.5.4 Printer 6 1
2.5.5 Installing and Removing Applications 62
2.6 Chinese operation processing 64
2.6. 1 Turn on and off the Chinese character input method 64
Operating instructions 64
2.6.3 Introduction to Input Method 65
Input Method Settings 65
2.7 Multimedia 66
2.7. Multimedia functions of1Windows 98 66
Multimedia attachment program 67
2.7.3 multimedia attribute settings
2.7.4 Configure Windows 98 sound scheme 7 1.
2.8 disk management 7 1
2.8. 1 disk formatting 72
2.8.2 floppy disk copy 73
2.8.3 Browse and change disk settings 73
2.9 Drawing program 74
2.9. 1 Start the "Drawing" program 74
2.9.2 "drawing" program function introduction 74
2.9.3 Creating Pictures 75
Exercise 75
Chapter 3 Word processing software Word 2000 77
3. 1 word overview 78
3. 1. 1 function 78
3. 1.2 Start and exit 79
3. Composition of1.3 Window 8 1
3.2 Basic operation of documents 84
Create a new document 84
Save the document 85
3.2.3 Open the document
3.2.4 Text input and basic editing 86
3.3 typesetting of documents 93
3.3. 1 view 93
3.3.2 Character typesetting 93
Format of paragraph 96
Page layout 99
3.4 Form 103
3.4. 1 Create table 103
Edit table 104
3.4.3 Table Attribute Settings 106
3.4.4 Conversion table and text 1 10
3.5 picture editing 1 1 1
3.5. 1 Clip Art
3.5.2 Insert WordArt 1 13.
3.5.3 Draw a graph 1 13
3.6 Print Preview and Print 1 15
3.6. 1 print preview 1 15
Print 1 16
Exercise 1 17
Chapter 4 Spreadsheet Excel 2000 1 18
4. Overview of1Excel 2000 1 18
4. 1. 1 features 1 18
4. 1.2 Start and end 1 19
4. 1.3 Composition of main window 1 19
4.2 Basic Operation of Excel 2000 120
4.2. 1 workbooks, worksheets and cells 120
Data input 120
Edit cell 123
4.2.4 Using formulas and functions 125
4.3 Worksheet Management and Format 130
4. 3. 1 Add, Delete and Rename Worksheets 130
4.3.2 Move or copy the worksheet 13 1
4.3.3 Splitting and Freezing of Worksheet Window 132
4.3.4 Format of Worksheet 133
4.4 data chart 137
4.4. 1 chart structure 137
4.4.2 Create a chart 138
4.4.3 Editing and formatting of charts 14 1
4.5 Data Management and Analysis 142
4.5. 1 data import 142
4.5.2 Adding and Deleting Records 143
4.5.3 data classification 143
4.5.4 Data Screening 144
4.5.5 Classification summary 146
PivotTables and PivotCharts 147
4.6 Page Setup and Printing 150
4.6. 1 Set page area and paging 150
4.6.2 Page Setup 152
4.6.3 Print Preview and Print 154
Exercise 156
Chapter 5 demo production software PowerPoint
2000 157
5. Basic concepts of1PowerPoint 2000 157
5. 1. 1 scope of application 157
5. 1.2 composition 157
5. 1.3 view type 158
5. 1.4 slide master, color scheme and application design
Template 159
5. 1.5 Basic operation 160
5.2 Make a simple analogy 16 1
Go 16 1
5.2.2 Preparation for presentation 16 1
5.2.3 Making a presentation by using the content prompt wizard
Manuscript 16 1
5.3 Presentation in Outline View 164
5.4 Making a Presentation in Slide View 165
Creating and Modifying Text Objects 165
5.4.2 Create and modify graphics 168.
5.4.3 Creating and Modifying Table Objects 169
5.4.4 Create and modify the organization chart object 170
5.4.5 Inserting and Modifying Clip Art Objects 172
5.4.6 Making Animation 174
5.4.7 Embedded object 174
5.5 Browse, display and print slides 176
5.5. 1 slide browsing 176
5.5.2 Slide Show 177
5.5.3 Printing of slides 180
Exercise 182
Chapter VI Computer Network and Internet Basis 183
6. 1 Basic knowledge of computer network 183
6. 1. 1 Definition of computer network
6. 1.2 Functions and applications of computer networks
6. 1.3 Composition of computer network
6. 1.4 computer network topology 185
6. 1.5 computer network classification 185
6. 1.6 network architecture and network protocol 186
6.2 Internet Foundation 189
The Origin and Development of Internet
6.2.2 China Internet 190
6.2.3 Internet Protocol IP and IP address 19 1
6.2.4 transmission control protocol TCP 195
6.2.5 Domain name address of Internet host 195.
6.2.6 Overview of Internet Services 197
6.2.7 Internet access mode 197
6.2.8 Dial-up Internet access 198
6.3 Internet Service Example: Use of E-mail 206
6.3.65438+ E-mail Overview 206
6.3.2 Setting up mail in the e-mail client
Account number 207
6.3.3 Receiving, Sending and Reading E-mail 2 1 1
6.4 Internet service example: World Wide Web 2 13
6.4. 1 network basics 2 13
6.4.2 Basic browsing method of IE 5.0 2 14
6.4.3 Web page related operations 2 17
6.4.4 Internet Option Settings 2 18
6.5 Internet service example: FTP service221
FTP Overview 22 1
6.5.2 Download files with browser 22 1
6.5.3 Download files with special client program 224
6.6 Novell Network Introduction 226
6.6. Composition of1Novell Net 226
Novell network user 227
NetWare operating system 227
6.6.4 Common NetWare Commands 228
Exercise 229
Appendix A ASCII code table 23 1
Appendix B DOS common commands 232
Appendix C Introduction to Common Websites 235