JOMO KENYATTA UNIVERSITY OF AGRICULTURE AND TECHNOLOGY
DIT 0204 (DIT0104)
Lecture notes
Class notes DIT 0204 (DIT0104)
0 view 0 purchase
Module
DIT 0204 (DIT0104)
Institution
JOMO KENYATTA UNIVERSITY OF AGRICULTURE AND TECHNOLOGY
Get ahead in math by solving these real-world and fun-to-do word problems.Math by Example is an excellent resource of various math word problems.It is known that success on aptitude test like the SAT is directly tied to one's ability to solve word problems. This book was written with the intent of ...
JOMO KENYATTA UNIVERSITY OF AGRICULTURE AND TECHNOLOGY
DIT 0204 (DIT0104)
All documents for this subject (7)
Seller
Follow
michealmukora1
Content preview
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller michealmukora1. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £6.54. You're not tied to anything after your purchase.
