Contents
Part One Computer Hardware 1
Passage A Computer Overview 1
Key Words and Expressions 4
Notes 4
Exercises 5
Tips 5
Passage B System Unit 6
Key Words and Expressions 7
Notes 7
Exercises 8
Tips 9
Passage C Input and Output Devices 9
Key Words and Expressions 15
Notes 16
Exercises 16
Tips 17
Passage D Memory&Storage Devices 17
Key Words and Expressions 21
Notes 22
Exercises 22
Tips 23
Reading Material Types of Computers 24
Part Two System Software 28
Passage A The Overview of the Operating System 28
Key Words and Expressions 31
Notes 31
Exercises 32
Tips 33
Passage B Windows 33
Key Words and Expressions 36
Notes 37
Exercises 37
Tips 38
Passage C UNIX and Linux 39
Key Words and Expressions 42
Notes 42
Exercises 42
Tips 43
Passage D Office Automation 43
Key Words and Expressions 45
Notes 46
Exercises 47
Tips 47
Reading Material Microsoft Office 2007 47
Part Three Database Management System 50
Passage A Database Basics 50
Key Words and Expressions 53
Notes 54
Exercises 54
Tips 55
Passage B Structured Query Language (SQL) 55
Key Words and Expressions 58
Notes 58
Exercises 59
Tips 59
Passage C Microsoft SQL Server 60
Key Words and Expressions 62
Notes 62
Exercises 63
Tips 63
Passage D Oracle Database 64
Key Words and Expressions 66
Notes 66
Exercises 66
Tips 67
Reading Material Microsoft Access 2007 77
Part Four Software Development 80
Passage A Software around Us 80
Key Words and Expressions 82
Notes 83
Exercises 83
Tips 84
Passage B Programming Language Technology 84
Key Words and Expressions 86
Notes 86
Exercises 87
Tips 87
Passage C What is Java 88
Key Words and Expressions 90
Notes 90
Exercises 91
Tips 91
Passage D Software Testing 92
Key Words and Expressions 94
Notes 94
Exercises 95
Tips 95
Reading Material Creating Visual Basic COMponents for ASP 96
Part Five Internet and Information Technology 100
Passage A The Internet 100
Key Words and Expressions 102
Notes 102
Exercises 102
Tips 103
Passage B What is the WWW 104
Key Words and Expressions 107
Exercises 107
Tips 108
Passage C What’s E-mail 108
Key Words and Expressions 111
Notes 112
Exercises 112
Tips 113
Passage D What Download Tools Do 113
Key Words and Expressions 115
Exercises 115
Tips 116
Passage E Instant Messaging Make Our Life Convenient 117
Key Words and Expressions 119
Exercises 119
Tips 120
Reading Material Useful Virtual Conference 120
Part Six Multimedia 123
Passage A Multimedia 123
Key Words and Expressions 124
Notes 125
Exercises 125
Tips 126
Passage B Photoshop 126
Key Words and Expressions 128
Notes 129
Exercises 129
Tips 129
Passage C Animation 130
Key Words and Expressions 132
Notes 133
Exercises 133
Tips 134
Passage D Digital Film 135
Key Words and Expressions 136
Notes 137
Exercises 137
Tips 138
Reading Material The 3rd Generation of Apple iPod Nano 139
Part Seven Network Technology 143
Passage A About the Topology 143
Key Words and Expressions 145
Notes 145
Exercises 145
Tips 146
Passage B Popular Network Devices 147
Key Words and Expressions 149
Notes 149
Exercises 149
Tips 150
Passage C DHCP and DNS 150
Key Words and Expressions 153
Notes 154
Exercises 154
Tips 154
Passage D The Networking Reference Model 155
Key Words and Expressions 157
Notes 157
Exercises 157
Tips 158
Reading Materials Transmission Media 159
Part Eight Computer Security 161
Passage A Computer Security 161
Key Words and Expressions 163
Notes 163
Exercises 164
Tips 165
Passage B Firewall 166
Key Words and Expressions 168
Notes 169
Exercises 169
Tips 170
Passage C Computer Virus 171
Key Words and Expressions 173
Notes 174
Exercises 174
Tips 175
Passage D Encryption 176
Key Words and Expressions 178
Notes 178
Exercises 179
Tips 180
Reading Material 40 Million People Hacked 180
Exercises Answer 183
Reference 194