Table of Contents
Preface ix
Acknowledgments xi
Chapter 1 Concepts and Computer Fundamentals 1
1.1 Introduction 1
1.2 Data, Processing, and Information 2
1.3 Defining The Computer System 3
1.4 Computer Classification 4
1.5 Block Diagram 8
1.6 Hardware Versus Software 10
1.7 Input Devices 10
1.8 Output Devices 15
1.9 Computer Memory 18
1.10 Storage Devices: DASD/SASD (Direct Access Storage Devices/Sequential Access Storage Devices) 20
1.10.1 Magnetic Tape 20
1.10.2 Floppy Disk 23
1.10.3 Hard Disk 24
1.10.4 Optical Disk 26
1.10.5 Pen Drive 27
1.10.6 Flash Memory 28
1.11 Basic System Configuration 28
1.12 Processing Speed 30
1.13 Uses of a Computer System 30
Test Your Knowledge 32
Chapter 2 Software: An Introduction 35
2.1 Software: AD Introduction 35
2.2 Types of Software 35
2.3 Assembler/Interpreter/Compiler 36
2.4 Generations of Computer Languages 39
2.5 Uses of Computer Languages 40
2.6 Operating Systems 41
2.6.1 Definition 41
2.6.2 Functions of an Operating System 42
2.6.3 Types and Classifications of Operating Systems 43
2.6.4 Components of an Operating System 46
2.7 What is Graphical User Interface (GUI)? 47
2.7.1 Elements of GUI-Based Operating Systems 48
Test Your Knowledge 62
Chapter 3 Microsoft Office 65
3.1 Microsoft Office 65
3.2 Working with MS Word 65
3.2.1 What is a Ribbon? 65
3.2.2 Office Button 66
3.2.3 HOME TAB 70
3.2.4 Insert Tab 81
3.2.5 The Page Layout Tab 114
3.2.6 Mail Merge 118
3.3 What is Microsoft Excel? 128
3.3.1 Cell Addressing 129
3.3.2 Range 130
3.3.3 Changing the Row Height or Column Width 131
3.3.4 Cell Alignment 133
3.3.5 Sheets 135
3.3.6 Creating and Inserting Charts in Excel 137
3.3.7 Sort and Filter 143
3.4 Working with Powerpoint 151
3.4.1 Home Tab 151
3.4.2 Insert Tab 153
3.4.3 Design Tab 154
3.4.4 Animation Tab 155
3.4.5 Slideshow Tab 158
3.4.6 View Tab 159
3.4.7 PowerPoint Show 161
3.5 Database Management System Using Microsoft Access 161
3.5.1 File Terminologies 161
3.5.2 Types of Data Files 162
3.5.3 Types of Records 163
3.5.4 Database Management System 164
3.5.5 Database 165
3.5.6 Properties of a Database 165
3.5.7 Advantages of Database Management System 166
3.5.8 Uses of a Database Management System 167
3.5.9 Applications of a Database Management System 168
3.5.10 Creating a Database Files or Tables in MS Access 168
3.5.11 Data Type 170
3.5.12 Elements of a Database 172
3.5.13 Primary Key/Record Key/Unique Key 173
Test Your Knowledge 175
Chapter 4 Management Information Systems 179
4.1 Need for Data and Information 179
4.2 Levels of Information 180
4.3 Characteristics and Presentation Qualities of Information 181
4.4 Value of Information 182
4.5 Information System 183
4.6 Components of an Information System 186
4.7 Types of Information Systems 186
4.7.1 Operation Support Systems 187
4.8 Management Support Systems 191
4.8.1 Management Information Systems 191
4.8.2 Decision Support System 192
4.8.3 Executive Support System 192
4.8.4 Expert Systems 193
4.9 Relationship of One Information System to Another 195
4.10 Decision Making and MIS 196
4.11 Level of Decision Making 196
4.12 MIS Support for Decision Making 197
4.13 Types of Decisions 199
4.14 Artificial Intelligence Technologies in Business 199
4.14.1 Neural Networks 200
4.14.2 Fuzzy Logic 200
4.14.3 Virtual Reality 201
4.15 Cross-Functional MIS 202
Test Your Knowledge 203
Chapter 5 Application of Cross-Functional Management Information Systems 205
5.1 Enterprise Resource Planning 205
5.2 Objectives of ERP 206
5.3 Benefits of The ERP System 207
5.4 ERP Solution Structure 207
5.5 Basic ERP Features 208
5.6 ERP Selection 208
5.6.1 Vendor Evaluation 208
5.6.2 Technology Evaluation 208
5.6.3 ERP Solution Evaluation 209
5.7 Customer Relationship Management 210
5.7.1 CRM and e-CRM 211
5.8 Security and Ethical Challenges of It 211
5.9 Business Ethics 213
5.10 Cybercrimes 214
Test Your Knowledge 218
Index 219
