電腦專業英語教程(第二版)（簡體書）

本書綜合計算機信息技術以及英語閱讀和應用能力，便于學生日后在科技領域進行國際交流，使學生具有更強的對信息社會快速發展的適應、生存、發展和提升能力。 本書適合于高校大學生以及研究生計算機技術基礎（計算機導論）課程的雙語或全英語教學。具體內容包括課程知識要點的介紹、參考譯文、課程習題和思考等。

本教程適合高校大學生以及研究生計算機技術基礎（計算機導論）課程的雙語或全英語教學，有助于學生了解、吸收和掌握信息技術的理論知識以及實踐操作能力，掌握信息技術的英語閱讀和應用能力。具體內容包括課程知識要點的介紹、參考譯文、課程習題和思考、實踐性教學輔導和實踐作業、測試復習樣題、重要詞匯表、常用術語中英文對照表、習題和思考參考答案、復習樣題參考答案等。

Part I Knowledge Points（部分 知識點）Text 1 Introduction to Information Technology21.1 Computer Literacy21.2 Information System21.3 Information Technology21.4 Information and Communications Technology31.5 What is a Computer31.6 Components of a Computer31.6.1 Hardware41.6.2 Software61.7 Categories of Computers71.7.1 Superputers71.7.2 Mainframe Computers71.7.3 Midrange Computers81.7.4 Miniputers81.7.5 Personal Computers8Text 2 System Unit112.1 Central Processing Unit (CPU)122.1.1 Control Unit122.1.2 Arithmetic and Logic Unit122.1.3 Registers122.1.4 Characteristics of CPU132.2 Memory172.2.1 Computer Memory Cell172.2.2 Types of Memory182.2.3 RAM182.2.4 Cache182.2.5 ROM192.2.6 Virtual Memory202.3 Ports and Connectors212.3.1 Serial Ports212.3.2 Parallel Ports222.3.3 SCSI Ports222.3.4 USB Ports222.3.5 PC Card Slots22Text 3 Input and Output243.1 Input243.1.1 Input Devices243.1.2 Keyboards243.1.3 Pointing Devices253.1.4 Voice Input283.1.5 Digital Cameras283.1.6 Video Input293.1.7 Scanning and Reading Devices293.1.8 Terminals323.1.9 Biometric Input333.2 Output333.2.1 Output Devices333.2.2 Printers353.2.3 Speakers and Headphones373.2.4 Other Output Devices373.2.5 Important Concepts39Text 4 Secondary Storage404.1 Floppy Disks414.2 Hard Disks414.2.1 Formatting424.2.2 Capacity424.2.3 Rotational Speed434.2.4 Access Time434.2.5 Characteristics of a Hard Disk434.2.6 Maintaining Data Stored on a Disk444.2.7 Features of Floppy Disks and Hard Disks454.3 Flash Memory454.3.1 USB Flash Drives454.3.2 Smart Cards464.4 Optical Storage Technology464.4.1 CD Disc474.4.2 DVD Disc474.4.3 Blu-ray Disc474.4.4 MO484.5 Tapes484.6 RAID Storage Systems48Text 5 Software505.1 Categories of Software505.2 System Software525.2.1 BIOS525.2.2 Operating System525.2.3 Utility Programs605.3 Programming Languages625.3.1 Machine language635.3.2 Assembly language635.3.3 Procedural language635.3.4 Non-procedural language645.3.5 Object-oriented programming (OOP) language645.3.6 Visual programming language645.3.7 Execution of programming languages64Text 6 Introduction to Word Processing666.1 Getting Started with Word666.1.1 Select Text666.1.2 Find and Replace676.1.3 Page Setup & Print Preview686.2 Formatting696.2.1 Themes, Template, Style and Format Painter696.2.2 Character Formatting706.2.3 Paragraph Formatting706.2.4 Page Formatting756.3 Graphics, Tables, Textbox and Other Objects816.3.1 Pictures and Graphics816.3.2Shape826.3.3SmartArt826.3.4Symbol836.3.5Table836.3.6Text Box846.3.7WordArt846.3.8Equations85Text 7 Introduction to PowerPoint Presentation877.1 Getting Started with PowerPoint877.1.1 PowerPoint Views877.1.2 Start a New Presentation907.1.3 Add Slides917.1.4 Change Slide Order927.1.5 Apply or Change the Slide Layout927.1.6 Present a Slide Show927.1.7 Print Slides or Handouts937.1.8 Tips for Creating an Effective Presentation957.2 Formatting a Presentation957.2.1 Apply a Design Template957.2.2 Working with Themes957.2.3 Header and Footer967.3 Animating Your Slides977.3.1 Add Slide Transition Effects977.3.2 Animate Objects977.3.3 Hyperlink987.3.4 Action Button987.3.5 Insert a Sound and/or Video Clip on a Slide100Text 8 Introduction to Spreadsheets1028.1 Introduction to Excel1028.1.1 Definition of a Spreadsheets1028.1.2 Contents of Cells1038.1.3 Specifying a Range of Cells1038.2 Spreadsheet Formulas and Functions1058.2.1 Some Common Functions1068.2.2 Common Formula Patterns1068.2.3 Copying Formulas—Absolute vs. Relative References1078.2.4 Standard Spreadsheet Functions1078.2.5 Useful Financial Functions1108.3 Spreadsheet Charts1118.3.1 Spreadsheet Chart Elements1118.3.2 Creating Spreadsheet Charts112Text 9 Introduction to Database1169.1 Database1169.2 Database Management Systems1169.2.1 Relational Database Hierarchy1179.2.2 Examples of a Database File1189.2.3 Data Integrity1199.2.4 Data Redundancy1199.3 Introduction to Microsoft Office Access1199.3.1 Access Data Files1199.3.2 Field Data Types1199.3.3 Creating a Database File1209.3.4 Create a new table1219.3.5 Import an Excel worksheet as a table in a new database1249.4 Access Query Design1259.4.1 Top Section1259.4.2 Bottom Section1269.5 Access Report Generator1319.5.1 Access Reports Overview1319.5.2 Format of an Access Report131Text 10 Data Communications and Networks13410.1 Data Communications13410.1.1 Data Communications Components13410.1.2 MODEM13410.1.3 Communication Software13510.1.4 Data Transfer13510.1.5 Protocol13710.1.6 Direction of Data Communications13810.2 Networks13910.2.1 Types of Computer Networks14010.2.2 Network Topologies14110.2.3 Network Communication Technologies14210.2.4 Connecting Networks14510.2.5 Network Architecture14610.2.6 Communication Channel14610.2.7 Data Processing151Text 11 Introduction to 15311.1 Introduction to 15311.1.1 Web Browsers15311.1.2 Uniform Resource Locator15311.1.3 Domain Names15411.1.4 Web Servers15411.2 Introduction to HTML15511.2.1 HTML15511.2.2 Requirements15511.2.3 Tags15611.2.4 Basic HTML Document Structure15611.2.5 Some HTML Tags15611.2.6 Heading Tags15711.2.7 Font Size and Colors15711.2.8 Steps to Create a Web Page15811.3 Constructing Web Pages (1)—List, Image, Anchor15911.3.1 List15911.3.2 Adding Image16111.3.3 Anchor Tag16211.4 Constructing Web Pages (2)—Table16211.4.1 Table16211.4.2 Table Tags16211.4.3 Tables Incorporating an Inline Image166Text 12 Computers and Society17012.1 E-Business17012.1.1 E-Business Basics17012.1.2 E-Business Models17012.1.3 Electronic Shopping Carts17112.2 Electronic Data Interchange17112.3 E-mail17212.4 Instant Messaging17212.5 New Technologies and Patterns17212.5.1 Big Data17212.5.2 Inter Plus17312.5.3 Cloud Computing17312.5.4 The Inter of Things17412.5.5 Mobile Web17412.5.6 Artificial Intelligence17512.5.7 Business Intelligence17512.5.8 Deep Learning17612.5.9 Docker17712.5.10 3D Printing17712.6 Social Issues17712.6.1 Computer Crime17712.6.2 Security18012.6.3 Privacy18212.6.4 Computer Ethics184Part II Reference Version（第二部分 參考譯文）課文1 信息技術簡介1861.1 計算機文化1861.2 信息系統1861.3 信息技術1861.4 信息通信技術1871.5 什么是計算機1871.6 計算機組成1871.6.1 硬件1871.6.2 軟件1881.7 計算機的分類1891.7.1 巨型機1891.7.2 大型機1891.7.3 中型機1891.7.4 小型機1901.7.5 個人計算機190課文2 系統部件1922.1 中央處理器1922.1.1 控制單元1922.1.2 算術邏輯單元1932.1.3 寄存器1932.1.4 CPU的特性1932.2 內存1952.2.1 計算機內存單元1962.2.2 內存的分類1962.2.3 隨機存儲器1972.2.4 高速緩存1972.2.5 只讀存儲器1982.2.6 虛擬內存1992.3 端口和連接器1992.3.1 串行口2002.3.2 并行口2002.3.3 小型計算機系統接口2002.3.4 USB接口2002.3.5 PC卡接口201課文3 輸入輸出2023.1 輸入2023.1.1 輸入設備2023.1.2 鍵盤2023.1.3 定位設備2023.1.4 語音輸入2043.1.5 數碼相機2043.1.6 視頻輸入2053.1.7 掃描和識別設備2053.1.8 終端2063.1.9 生物識別輸入2073.2 輸出2073.2.1 輸出設備2073.2.2 打印機2093.2.3 揚聲器和耳機2103.2.4 其他輸出設備2113.2.5 重要概念211課文4 輔助存儲器2134.1 軟盤2134.2 硬盤2144.2.1 格式化2144.2.2 硬盤容量2144.2.3 硬盤轉速2144.2.4 訪問時間2154.2.5 硬盤的特性2154.2.6 維護磁盤上的數據2164.2.7 軟盤和硬盤的特性2164.3 閃存2164.3.1 USB閃存盤2174.3.2 智能卡2174.4 光存儲技術2174.4.1 CD光盤2174.4.2 DVD光盤2184.4.3 藍光光盤2184.4.4 磁光盤2184.5 磁帶2184.6 RAID存儲系統219課文5 軟件2205.1 軟件的分類2205.2 系統軟件2215.2.1 BIOS2215.2.2 操作系統2225.2.3 實用程序2245.3 編程語言2255.3.1 機器語言2255.3.2 匯編語言2265.3.3 過程程序設計語言2265.3.4 非過程程序設計語言2265.3.5 面向對象程序設計語言2265.3.6 可視化程序設計語言2265.3.7 程序設計語言的執行227課文8 電子表格介紹2288.1Excel介紹2288.1.1 電子表格2288.1.2 單元格的內容228課文9 數據庫介紹2309.1 數據庫2309.2 數據庫管理系統2309.2.1 關系數據庫2319.2.2 數據庫文件實例2319.2.3 數據完整性2329.2.4 數據冗余232課文10 數據通信和網絡23310.1 數據通信23310.1.1 數據通信的組成23310.1.2 調制解調器23310.1.3 通信軟件23410.1.4 數據傳輸23410.1.5 協議23410.1.6 數據通信的方向23610.2 網絡23610.2.1 計算機網絡的分類23610.2.2 網絡拓撲結構23810.2.3 網絡通信技術23910.2.4 網絡互連24010.2.5 網絡架構24210.2.6 信道24210.2.7 數據處理246課文11 萬維網簡介24711.1 萬維網24711.1.1 Web24711.1.2 統一資源定位器24711.1.3 域名24811.1.4 Web服務器24811.2 HTML簡介24911.2.1 超文本標記語言24911.2.2 基本要求24911.2.3 標記24911.2.4 編制網頁的步驟250課文12 計算機和社會25112.1 電子商務25112.1.1 電子商務基本概念25112.1.2 電子商務模型25112.1.3 電子購物車25212.2 電子數據交換25212.3 電子郵件25212.4 即時消息25312.5 新技術和新模式25312.5.1 大數據25312.5.2 互聯網 25412.5.3 云計算25412.5.4 物聯網25412.5.5 移動網絡25512.5.6 人工智能25512.5.7 商務智能25612.5.8 深度學習25612.5.9 Docker25712.5.10 3D打印25712.6 社會問題25812.6.1 網絡犯罪25812.6.2 信息安全26112.6.3 隱私權26212.6.4 計算機倫理264Part III Exercises（第三部分 習題與思考）Tutorial1 Introduction to Information Technology268Tutorial2 System Unit269Tutorial3 Input and Output Devices270Tutorial4 Secondary Storage271Tutorial5 Software272Tutorial6 Data Communications273Tutorial7 Networks274Part IV Labs（第四部分 實踐指導）Warm-up Exercise1Windows Practice Exercises276Warm-up Exercise2 Word Practice Exercises278Warm-up Exercise3 PowerPoint Practice Exercises282Lab 1 Introduction to Spreadsheets—Excel285Lab 2 Orchids Shade House Case Study290Assignment 1293Lab 3 Creating Your Webpage (1)295Lab 4 Creating Your Webpage (2)298Assignment2304Lab5 Creating a New Datafile305Lab6 Access Queries309Lab7 Access Report Generation319Assignment 3323Part V Revisions （第五部分 復習題）Revision 1330SECTION A330SECTION B333SECTION C334Revision 2340SECTION A340SECTION B343SECTION C344Revision 3349SECTION A349SECTION B352SECTION C353Revision 4358SECTION A358SECTION B361SECTION C362參考文獻368