目　录　
　　
Chapter 1　Fundamentals of Computer　1
1.1　Numbering Systems　1
1.1.1　An Overview of the Numbering Systems　1
1.1.2　Operations on Binary Numbers　2
1.1.3　Conversion Between Different Numbering Systems　3
1.1.4　Representation about Negative Numbers　6
1.1.5　More Data Representations　9
1.2　Computer System　14
1.2.1　Hardware　14
1.2.2　Software　18
1.3　Information Security　20
1.3.1　An Overview of Information Security　20
1.3.2　Threat Classification　21
1.3.3　Information Security Techniques　22
1.3.4　Computer Virus　23
Exercises　25
Solutions to Exercises　27
Reference　28

Chapter 2　Operating Systems　29
2.1　Introduction to Operating Systems　29
2.1.1　What is an operating system　29
2.1.2　Classification of Operating Systems　30
2.1.3　Common Features of Operating Systems　32
2.2　Functions of Operating Systems　33
2.2.1　Processor Management　33
2.2.2　Memory Management　36
2.2.3　Device Management　37
2.2.4　File Management　39
2.3　Typical Operating Systems　41
2.3.1　DOS　41
2.3.2　Microsoft Windows　42
2.3.3　UNIX　43
2.3.4　Linux　43
2.3.5　Embedded Operating Systems　44
2.4　An Introduction to Windows XP　45
2.4.1　An Overview of Windows XP　45
2.4.2　the Management of File and Disk　45
2.4.3　Control Panel in Windows XP　54
2.4.4　Windows Accessories　58
Exercises　61
Solutions to Exercises　63
Reference　63

Chapter 3　Microsoft Word 2003　64
3.1　An Overview of Word 2003　64
3.1.1　Microsoft Word 2003 Components　64
3.1.2　Layouts in Word 2003　65
3.1.3　Online Help　65
3.1.4　Closing MS Word 2003　66
3.2　Building a Basic Document　66
3.2.1　Creating a Document　66
3.2.2　Using Template to Create a Document　67
3.2.3　Saving a Document　67
3.2.4　Closing the Document　68
3.3　Editing the Text　68
3.3.1　Selecting the Text　68
3.3.2　Cut, Copy and Paste　69
3.3.3　Undoing/Redoing (Ctrl+Z /Ctrl+Y)　70
3.3.4　Finding and Replaceing Text or Other Items　70
3.3.5　Spelling and Grammar Check　71
3.4　Document Settings　71
3.4.1　Character Formatting　71
3.4.2　Paragraph Formatting　72
3.4.3　Bullets and Numbering　75
3.4.4　Styles and Formatting　76
3.4.5　Creating an Index　78
3.5　Integrating Pictures and Text　78
3.5.1　Graphics　78
3.5.2　WordArt　81
3.5.3　Drawing Shapes　81
3.5.4　Inserting Text Boxes　83
3.5.5　Inserting Equation　83
3.6　Table　84
3.6.1　Creating Tables　84
3.6.2　Formatting Tables　85
3.6.3　Formatting a Table and its Content　87
3.7　Page Design and Printing　89
3.7.1　Page Design　89
3.7.2　Previewing and Printing　92
Exercises　92
Solutions to Exercises　94
Reference　95

Chapter 4　Microsoft Powerpoint 2003　96
4.1　An overview of PowerPoint 2003　96
4.1.1　Components of Microsoft PowerPoint 2003　96
4.1.2　Presentation and Slide　97
4.1.3　Slide Views　97
4.1.4　Basic Presentation Operations　97
4.2　Creating and Formatting Slides　98
4.2.1　New Slide　98
4.2.2　Slides Formatting　99
4.2.3　Basic Slide Operations　99
4.3　Setting Presentation Appearance　99
4.3.1　Using Masters　99
4.3.2　Applying a Design Template　101
4.3.3　Changing the Color Scheme of Slides　101
4.4　Setting Slide Show Effect　102
4.4.1　Animation Effect　102
4.4.2　Setting Slide Transition　102
4.4.3　Hyperlink　103
4.4.4　Action Button　105
4.4.5　Adding Sound and Video to a PowerPoint Presentation　105
4.5　Presenting Slides　107
4.5.1　Slide Show　107
4.5.2　Hiding a Slide and Showing a Hidden Slide　108
Exercises　108
Solutions to Exercises　110
Reference　110

Chapter 5　Microsoft Excel 2003　111
5.1　Getting Started with Excel　111
5.1.1　Microsoft Excel Interface　111
5.1.2　More about Worksheets　112
5.2　Working with Worksheets　113
5.2.1　Entering Worksheet Content　113
5.2.2　Editing Worksheet Content　115
5.2.3　Formatting a Worksheet　117
5.3　Using Formulas and Functions　120
5.3.1　Entering Formulas　121
5.3.2　Functions　123
5.4　Analyzing Excel Data　126
5.4.1　Building a List　126
5.4.2　Sorting a List　127
5.4.3　Filtering a List　128
5.5　Creating a Chart　131
5.5.1　Setting up a New Chart　131
5.5.2　Updating and Changing a Chart　133
5.5.3　Formatting and Editing a Chart　134
Exercises　134
Solutions to Exercises　136
Reference　136

Chapter 6　Fundamentals of Web Development　137
6.1　An Overview of the Web　137
6.1.1　Web Design　137
6.1.2　Web Development　138
6.2　HTML　138
6.2.1　HTML Tags　139
6.2.2　Basic Concepts　140
6.2.3　Input tags　144
6.2.4　HTML Style　147
6.2.5　HTML Form　148
6.2.6　Character Entity References in HTML　150
6.3　Related Web Languages　151
6.3.1　CSS　151
6.3.2　JavaScript Fundamentals　153
6.3.3　PHP Fundamentals　162
Exercises　167
Solutions to Exercises　168
Reference　169

Chapter 7　Database System　170
7.1　An Introduction to Database-System　170
7.1.1　An Introduction to Database　170
7.1.2　Database Architecture　171
7.1.3　Database-management System　172
7.2　Relational Database System　172
7.2.1　The Entity-Relationship Model　172
7.2.2　The Common Data Models　175
7.2.3　Basic Terminology of Relational Model　176
7.3　The Relational Algebra　178
7.3.1　The Basic Relational-algebra Operations　178
7.3.2　The Special Relational-algebra Operations　180
7.4　SQL Query Language　182
7.4.1　An Introduction to SQL　182
7.4.2　Data Definition Language　182
7.4.3　Data Manipulation Language　185
7.4.4　Data Query Language　187
7.4.5　Data Control Language　192
7.5　Application Development　192
7.5.1　Database Development　192
7.5.2　Usage of WampServer　193
7.5.3　Usage of Navicat　195
7.5.4　Student Information Management System　202
Exercises　218
Solutions to Exercises　220
Reference　221