Part Ⅰ Theory Part 3
Chapter 1 Computer Basics and Digitization 3
1.1 Computer Basics 3
1.1.1 An Overview of the Computer Development 4
1.1.2 The Digital Revolution 5
1.1.3 Computer Types and uses 6
1.2 Digital Data Representation 8
1.2.1 An Overview of the Digital Data Representation 8
1.2.2 Numbering Systems 10
1.2.2.1 Operations on Binary Numbers 11
1.2.2.2 Conversion Between Different Numbering Systems 11
1.2.2.3 Representation about Negative Numbers 13
1.2.3 More Data Representations 14
1.2.3.1 Text Representation 14
1.2.3.2 Audio Representation 16
1.2.3.3 Images Representation 17
1.3 Information Security 21
1.3.1 An Overview of Information Security 21
1.3.2 Information Security Techniques 21
Exercises 23
Chapter 2 Computer Hardware 24
2.1 An Overview of the Computer Hardware 24
2.2 Microprocessors 27
2.2.1 Microprocessors Basics 27
2.2.2 Processor Logic 28
2.2.3 Microprocessor's Performance 30
2.3 Memory 32
2.3.1 Random Access Memory 32
2.3.2 Read-only Memory 33
2.3.3 Cache Memory 34
2.3.4 Virtual Memory 34
2.4 Storage Devices 35
2.4.1 Storage Basics 35
2.4.2 Magnetic Storage Technology 36
2.4.3 Optical Storage Technology 37
2.4.4 Solid State Storage Technology 38
2.5 Input and Output Devices 39
2.5.1 Input Devices 39
2.5.2 Output Devices 43
2.5.3 Installing Peripheral Devices 51
Exercises 53
Chapter 3 Computer Software 55
3.1 An Overview of the Computer Software 55
3.1.1 Software Aspects 55
3.1.2 Software Development 56
3.2 Software Categories 60
3.2.1 System Software 60
3.2.2 Application Software 63
3.2.3 Development Software 69
3.3 Installing Software 70
3.3.1 Installation on Windows 70
3.3.2 Installation on UNIX/Linux 72
3.4 Security Software 73
Exercises 76
Chapter 4 Operating System 77
4.1 An Overview of the Operating System 77
4.2 Operating System Basics 80
4.2.1 Operating System Activities 80
4.2.2 User Interfaces 82
4.2.3 The Boot Process 83
4.3 Types of Operating Systems 84
4.4 File Management 88
4.4.1 File Basics 88
4.4.2 Application-based File Management 92
4.4.3 File Backup 97
Exercises 102
Chapter 5 The Networks 103
5.1 An Overview of the Networks 103
5.2 Network Devices 104
5.2.1 Wired Devices 104
5.2.2 Wireless Devices 107
5.2.3 Transmission Media 107
5.2.3.1 Cables 107
5.2.3.2 Broadcast 109
5.2.4 Network Topologies 109
5.3 LAN 111
5.3.1 Communications Protocols 111
5.3.2 Network Setup 118
5.4 Internet 120
5.4.1 Internet Basics 120
5.4.2 Internet Access 126
5.4.3 Internet Services 131
5.5 The Web and E-mail 135
5.6 The Network Security 145
Exercises 149
Chapter 6 Computer Careers and Ethics 150
6.1 Computer Careers 150
6.2 Professional Ethics 153
Part Ⅱ Practice Part 157
Chapter 7 Microsoft Word 2010 157
7.1 An Overview of Word 2010 157
7.1.1 Microsoft Word 2010 Components 157
7.1.2 Layouts in Word 2010 159
7.2 Building a Basic Document 161
7.2.1 Creating a Document 162
7.2.2 Using Template to Create a Document 162
7.2.3 Saving a Document 162
7.2.4 Closing the Document 163
7.3 Functions of Word2010 164
7.3.1 Editing the Text 164
7.3.2 Spelling and Grammar Check 165
7.3.3 Document Settings 168
7.3.4 Integrating Pictures and Text 176
7.3.5 Table 177
7.3.6 Page Design and Printing 180
Chapter 8 Microsoft Excel2010 182
8.1 An Overview of Microsoft Excel 2010 182
8.1.1 Microsoft Excel Interface 182
8.1.2 More about Worksheets 182
8.2 Working with Worksheets 188
8.2.1 Entering Worksheet Content 188
8.2.2 Editing Worksheet Content 189
8.2.3 Formatting a Worksheet 192
8.3 Functions of Excel2010 195
8.3.1 Using Formulas and Functions 195
8.3.2 Analyzing Excel Data 200
8.3.3 Creating a Chart 204
Chapter 9 Microsoft PowerPoint 2010 212
9.1 An Overview of PowerPoint 2010 212
9.1.1 Components of Microsoft PowerPoint 2010 212
9.1.2 Presentation as a Slide Show 216
9.2 Creating,Formatting Slides and Slide Views 216
9.2.1 Creating Slides 216
9.2.2 Formatting Slides 216
9.2.3 Slide Views 218
9.2.4 Basic Operations of Slides 221
9.3 Settings in Presentation and Slides Show 223
9.3.1 Setting Presentation Appearance 223
9.3.2 Setting Slide Show Effect 226
9.4 Presenting Slides 231
9.4.1 Slide Show 231
9.4.2 Hiding a Slide and Showing a Hidden Slide 232
References 234