MINISTRY OF EDUCATION
DIPLOMA IN
INFORMATION COMMUNICATION
TECHNOLOGY
KENYA INSTITUTE OF CURRICULUM DEVELOPMENT
STUDY NOTES
Computer Applications I
MODULE I: SUBJECT NO 2
Page 1 of 212
,Contents
CHAPTER 1: INTRODUCTION TO COMPUTER APPLICATIONS ....................................................................... 6
Computer Application/Application software ............................................................................................ 6
Classification of Computer software......................................................................................................... 6
Stating the applications in a computers ................................................................................................... 7
Computer - Applications ......................................................................................................................... 10
CHAPTER 2: INTRODUCTION TO OPERATING SYSTEM ENVIRONMENT...................................................... 14
Introduction to OS .................................................................................................................................. 14
Function of Operating system................................................................................................................. 14
Types of Operating System ..................................................................................................................... 16
Use of operating systems command ...................................................................................................... 19
DOS Internal and External Commands.................................................................................................... 20
CHAPTER 3: WORD PROCESSING ................................................................................................................ 26
Introduction to Word processing ............................................................................................................ 26
Features of a word processor ................................................................................................................. 26
Examples of word processor programs .................................................................................................. 26
Types of word processing applications ................................................................................................... 27
Features of Standard Word Processors .................................................................................................. 27
Opening Microsoft Word 2007 in the practical room ............................................................................ 28
Screen Layout.......................................................................................................................................... 29
Quick Access Toolbar .............................................................................................................................. 30
Using the Keyboard in MS Word ............................................................................................................. 31
Basic actions with documents................................................................................................................. 32
Editing document .................................................................................................................................... 33
Formatting text ....................................................................................................................................... 34
Formatting Paragraphs ........................................................................................................................... 37
Adding Tables .......................................................................................................................................... 40
Graphics .................................................................................................................................................. 41
Page Formatting ...................................................................................................................................... 42
Footnotes ................................................................................................................................................ 43
Bulleted and Numbered Lists .................................................................................................................. 43
Proofing a Whole Word 2007 Document ............................................................................................... 44
Page 2 of 212
, Mail merge .............................................................................................................................................. 49
Show or hide comments or tracked changes.......................................................................................... 53
Automating Common Word Tasks .......................................................................................................... 56
Table of content, Figures and tables....................................................................................................... 60
Print an MS Word document .................................................................................................................. 67
CHAPTER 4: SPREADSHEET.......................................................................................................................... 70
Introduction to Spreadsheets ................................................................................................................. 70
The Main Spreadsheets .......................................................................................................................... 70
Basic MS Excel Skills ................................................................................................................................ 71
Excel Formula and Functions .................................................................................................................. 73
Making Changes to the Contents of a Spreadsheet Cell......................................................................... 75
Saving Your Spreadsheet ........................................................................................................................ 75
Printing a Spreadsheet ............................................................................................................................ 75
Editing a Spreadsheet ............................................................................................................................. 76
Formatting a Spreadsheet ........................................................................................................................ 78
Sorting Filtering and Data Validation ..................................................................................................... 79
Charts ...................................................................................................................................................... 80
What if analysis....................................................................................................................................... 81
Create a Scenario PivotTable Report ...................................................................................................... 86
Summarizing, consolidating and outlining data...................................................................................... 92
Automating simple task .......................................................................................................................... 96
Print a Worksheet ................................................................................................................................... 98
CHAPTER 5: DATABASE ............................................................................................................................. 101
Introduction to Databases .................................................................................................................... 101
Traditional File Organization ................................................................................................................. 101
What are Data Models? Type of Data Models. ..................................................................................... 102
Introduction to Microsoft Access.......................................................................................................... 103
Database Concepts ................................................................................................................................ 104
Introduction to Access 2007.................................................................................................................. 105
Exploring Access 2007 ......................................................................................................................... 107
Creating a New Database ...................................................................................................................... 112
Displaying Different Views .................................................................................................................... 113
Page 3 of 212
, Converting and Compatibility Issues .................................................................................................... 116
Navigation Pane features and controls................................................................................................. 118
Exploring an Access Database ............................................................................................................... 118
CHAPTER 6: DESKTOP PUBLISHING ........................................................................................................... 128
Introduction to Desk Top Publishing..................................................................................................... 128
Microsoft Publisher ............................................................................................................................... 129
Publisher Basics and Feature ................................................................................................................ 129
Create a table ........................................................................................................................................ 135
Working with Color Schemes ................................................................................................................ 136
Change page size, paper size, or page orientation ............................................................................... 138
Import a Word document ..................................................................................................................... 141
Insert a file ............................................................................................................................................ 142
Add, change, or remove a border in Publisher ..................................................................................... 142
Determine your desktop printer's nonprintable region ................................................................... 142
Prepare, publish, and maintain your Publisher Web site ..................................................................... 145
CHAPTER 6: PRESENTATIONS .................................................................................................................... 152
Introduction to Presentation ................................................................................................................ 152
Microsoft PowerPoint ........................................................................................................................... 152
The Basics: Creating and Editing a Presentation................................................................................... 153
Create a New Presentation ................................................................................................................... 154
Entering Text on a Slide ........................................................................................................................ 156
Adding Clip Art to a Slide .................................................................................................................... 157
Editing Slide Text ................................................................................................................................. 158
Formatting Text Slides .......................................................................................................................... 159
Preparing to Deliver a Presentation ...................................................................................................... 162
Adding Transitions to a Slide Show ....................................................................................................... 165
How to Set Transition Effects................................................................................................................ 165
Animating Text ...................................................................................................................................... 166
Printing Slides, Speaker Notes, and Handouts...................................................................................... 166
Creating a Custom Design Template ..................................................................................................... 167
Inserting Graphics ................................................................................................................................. 168
Adding Footers ...................................................................................................................................... 169
Page 4 of 212
DIPLOMA IN
INFORMATION COMMUNICATION
TECHNOLOGY
KENYA INSTITUTE OF CURRICULUM DEVELOPMENT
STUDY NOTES
Computer Applications I
MODULE I: SUBJECT NO 2
Page 1 of 212
,Contents
CHAPTER 1: INTRODUCTION TO COMPUTER APPLICATIONS ....................................................................... 6
Computer Application/Application software ............................................................................................ 6
Classification of Computer software......................................................................................................... 6
Stating the applications in a computers ................................................................................................... 7
Computer - Applications ......................................................................................................................... 10
CHAPTER 2: INTRODUCTION TO OPERATING SYSTEM ENVIRONMENT...................................................... 14
Introduction to OS .................................................................................................................................. 14
Function of Operating system................................................................................................................. 14
Types of Operating System ..................................................................................................................... 16
Use of operating systems command ...................................................................................................... 19
DOS Internal and External Commands.................................................................................................... 20
CHAPTER 3: WORD PROCESSING ................................................................................................................ 26
Introduction to Word processing ............................................................................................................ 26
Features of a word processor ................................................................................................................. 26
Examples of word processor programs .................................................................................................. 26
Types of word processing applications ................................................................................................... 27
Features of Standard Word Processors .................................................................................................. 27
Opening Microsoft Word 2007 in the practical room ............................................................................ 28
Screen Layout.......................................................................................................................................... 29
Quick Access Toolbar .............................................................................................................................. 30
Using the Keyboard in MS Word ............................................................................................................. 31
Basic actions with documents................................................................................................................. 32
Editing document .................................................................................................................................... 33
Formatting text ....................................................................................................................................... 34
Formatting Paragraphs ........................................................................................................................... 37
Adding Tables .......................................................................................................................................... 40
Graphics .................................................................................................................................................. 41
Page Formatting ...................................................................................................................................... 42
Footnotes ................................................................................................................................................ 43
Bulleted and Numbered Lists .................................................................................................................. 43
Proofing a Whole Word 2007 Document ............................................................................................... 44
Page 2 of 212
, Mail merge .............................................................................................................................................. 49
Show or hide comments or tracked changes.......................................................................................... 53
Automating Common Word Tasks .......................................................................................................... 56
Table of content, Figures and tables....................................................................................................... 60
Print an MS Word document .................................................................................................................. 67
CHAPTER 4: SPREADSHEET.......................................................................................................................... 70
Introduction to Spreadsheets ................................................................................................................. 70
The Main Spreadsheets .......................................................................................................................... 70
Basic MS Excel Skills ................................................................................................................................ 71
Excel Formula and Functions .................................................................................................................. 73
Making Changes to the Contents of a Spreadsheet Cell......................................................................... 75
Saving Your Spreadsheet ........................................................................................................................ 75
Printing a Spreadsheet ............................................................................................................................ 75
Editing a Spreadsheet ............................................................................................................................. 76
Formatting a Spreadsheet ........................................................................................................................ 78
Sorting Filtering and Data Validation ..................................................................................................... 79
Charts ...................................................................................................................................................... 80
What if analysis....................................................................................................................................... 81
Create a Scenario PivotTable Report ...................................................................................................... 86
Summarizing, consolidating and outlining data...................................................................................... 92
Automating simple task .......................................................................................................................... 96
Print a Worksheet ................................................................................................................................... 98
CHAPTER 5: DATABASE ............................................................................................................................. 101
Introduction to Databases .................................................................................................................... 101
Traditional File Organization ................................................................................................................. 101
What are Data Models? Type of Data Models. ..................................................................................... 102
Introduction to Microsoft Access.......................................................................................................... 103
Database Concepts ................................................................................................................................ 104
Introduction to Access 2007.................................................................................................................. 105
Exploring Access 2007 ......................................................................................................................... 107
Creating a New Database ...................................................................................................................... 112
Displaying Different Views .................................................................................................................... 113
Page 3 of 212
, Converting and Compatibility Issues .................................................................................................... 116
Navigation Pane features and controls................................................................................................. 118
Exploring an Access Database ............................................................................................................... 118
CHAPTER 6: DESKTOP PUBLISHING ........................................................................................................... 128
Introduction to Desk Top Publishing..................................................................................................... 128
Microsoft Publisher ............................................................................................................................... 129
Publisher Basics and Feature ................................................................................................................ 129
Create a table ........................................................................................................................................ 135
Working with Color Schemes ................................................................................................................ 136
Change page size, paper size, or page orientation ............................................................................... 138
Import a Word document ..................................................................................................................... 141
Insert a file ............................................................................................................................................ 142
Add, change, or remove a border in Publisher ..................................................................................... 142
Determine your desktop printer's nonprintable region ................................................................... 142
Prepare, publish, and maintain your Publisher Web site ..................................................................... 145
CHAPTER 6: PRESENTATIONS .................................................................................................................... 152
Introduction to Presentation ................................................................................................................ 152
Microsoft PowerPoint ........................................................................................................................... 152
The Basics: Creating and Editing a Presentation................................................................................... 153
Create a New Presentation ................................................................................................................... 154
Entering Text on a Slide ........................................................................................................................ 156
Adding Clip Art to a Slide .................................................................................................................... 157
Editing Slide Text ................................................................................................................................. 158
Formatting Text Slides .......................................................................................................................... 159
Preparing to Deliver a Presentation ...................................................................................................... 162
Adding Transitions to a Slide Show ....................................................................................................... 165
How to Set Transition Effects................................................................................................................ 165
Animating Text ...................................................................................................................................... 166
Printing Slides, Speaker Notes, and Handouts...................................................................................... 166
Creating a Custom Design Template ..................................................................................................... 167
Inserting Graphics ................................................................................................................................. 168
Adding Footers ...................................................................................................................................... 169
Page 4 of 212
