劉朝斌主編的《大學計算機基礎與應用(英文版)》根據教育部制定的《高等學校非計算機專業計算機課程基本要求》,結合目前計算機的發展和高校新生的現狀而編寫。全書共分7章,主要內容包括計算機基礎知識、操作系統基礎、常用Office軟件、Web和HTML基礎、Web開發初步、數據庫基礎。 本書內容翔實,結構合理,注重理論和實踐相結合,具有通俗易懂、實用性和操作性強的特點。 《大學計算機基礎與應用(英文版)》適合作為各類高等學校非計算機專業教材,也可作為高等學校成人教育的計算機基礎雙語培訓教材或自學參考書。
Chapter 1 Fundamentals of Computer
1.1 Numbering Systems
1.1.1 An
Overview of the Numbering Systems
1.1.2 Operations on Binary Numbers
1.1.3
Conversion Between Different Numbering Systems
1.1.4 Representation about
Negative Numbers
1.1.5 More Data Representations
1.2 Computer
System
1.2.1 Hardware
1.2.2 Software
1.3 Information Security
1.3.1
An Overview of Information Security
1.3.2 Threat Classification
1.3.3
Information Security Techniques
1.3.4 Computer
Virus
Exercises
Solutions to Exercises
Reference
Chapter 2 Operating
Systems
2.1 Introduction to Operating Systems
2.1.1 What is an operating
system
2.1.2 Classification of Operating Systems
2.1.3 Common Features of
Operating Systems
2.2 Functions of Operating Systems
2.2.1 Processor
Management
2.2.2 Memory Management
2.2.3 Device Management
2.2.4 File
Management
2.3 Typical Operating Systems
2.3.1 DOS
2.3.2 Microsoft
Windows
2.3.3 UNIX
2.3.4 Linux
2.3.5 Embedded Operating Systems
2.4
An Introduction to Windows XP
2.4.1 An Overview of Windows XP
2.4.2 the
Management of File and Disk
2.4.3 Control Panel in Windows
XP
……
Chapter3 Microsoft Word2003 64
Chapter4 Microsoft Powerpoint2003
96
Chapter5 Microsoft Excel2003 111
Chapter6 Fundamentals of Web
Development 137
Chapter7 Database System 170
Exercises 218
Solutions to
Exercises 220
Reference 221
(1) Arithmetic Addition
In the arithmetic addition, negative numbers are
initially in 2'scomplement, and if the sum obtainedafter the addition is
negative,it is in 2's-complement form. The addition of negative numbers
isobtainedfrom the addition of their corresponding signed binarynumbers
represented in signed-2'scomplement form,including theirsign bits. And, a carry
out of the sign-bit position isdiscarded.
In the above four examples, each
operation performed is additionwith the sign bit included. Anycarry out of the
sign-bit positionis discarded, and negative results are automatically in
2'scomplementform. To determine the value of a negative numberwhen.it's in
signed-2's complement, it is necessary toconvert it toa positive number to place
it in a more familiar form.
The procedure is very simple. For example, the
signed binary number11010101 is negativebecause the leftmost bit is ,1, that is,
its2's complement is 00101011, which is the binary equivalent Of+43.Therefore,
the original negative number is equal to-43.
(2) Arithmetic
Subtraction
Take the 2'S complement of the subtrahend (including the sign
bit)and add it to the minuend(including the sign bit). A carry out ofthe
sign-bit,'position is discarded.