刘朝斌主编的《大学计算机基础与应用(英文版)》根据教育部制定的《高等学校非计算机专业计算机课程基本要求》,结合目前计算机的发展和高校新生的现状而编写。全书共分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.