I. CF (Computer Fundamental)

• Computer Concepts

• What is a computer?
• Computer Types
• Distributed or Grid Computing

• Input System

• Types of Input, Keyboard
• Keys of Computer Keyboard
• Pointing Devices
• Mouse, Trackball, Glidepad
• Game Devices
• Pen Input, Touchscreen, Digitizers and Graphics Tablets, Terminals
• Multimedia, Sound Input, Voice Input
• Video Input, Data Automation

• Processing System

• Digital Data, Digital Codes
• Parity
• Central Processing Unit, ALU
• Applications, Control Unit, CPU, Input/Output Storage
• Main Memory, Operating System, Unused Storage, Working Storage, Machine Cycle
• The Machine Cycle, Speed, Memory Addresses
• Processor Speed
• Physical Components, Microprocessor
• Memory Devices, Speed, Motherboards
• Connectors, ISA slots, Keyboard plug , Memory slots, PO slots
• Power connections, Processor socket

• Output System

• Types of Output, Categories of Output
• Printer Features
• Printer Types
• Screen (Monitor) Features, Making Colored Pictures
• Resolution
• Type of Screens
• Other Devices
• Data projectors, Large Format Printers, Microfilm (COM), Sound

• Computer Storage

• Diskette / Floppy Disk
• Disk Format
• Disk Capacity
• Caring for Disks
• Anti-virus, Magnetic Tape
• Optical Disks
• Other Devices, Flash Memory, USB drive
• Removable hard drives, Mass storage, Smart cards, Optical cards

• Operating System :

• Using Windows XP

• Logging into Windows XP, Switching Accounts
• Switching Users
• Shut Down Before Leaving, Turning Off Your Computer
• My Computer
• How to Minimize Windows, Enlarging Windows
• A Window's Menu, Managing the Window Contents
• A Window's Toolbar
• Managing the Toolbar, Choose a new desktop theme
• Choose a desktop background, Increase the size of Windows text fonts
• Change your screen resolution
• Personal folders
• Using Fonts
• Connect to a printer
• Print a file, Check on the printing of your file
• Stop printing your file, Printer drivers
• Changing printing preferences

MS-Word

The Word Environment I 1. Using the vertical scroll bar
2. Zoom into the page using the menu
3. Creating a new Word Document

Selecting And Editing Text
4. How to select a single word I
5. Point to point selection
6. Drag paragraphs
7. Copy and paste using the clipboard
8. Turning off automatic hyprlinking I

Highlighting Text
9. Underlining a single word

Manipulating Fonts
10. Changing selected text font
11. Changing seltected text Size
12. Changing selected text color

Editing Default Settings
13. Setting page default font
14. Change default file format

Drawing I
15. Show the drawing toolbar
16. Setting line color
17. Drawing arrows with gradient color fill

Formating
18. Creating different first page headers and footers
19. Create page numbers on odd pages only
20. Creating a simple page border line
21. Changing page size to legal
22. Set page margins numerically

Customizing Menus & Toolbars
23. Setting menus to always show fully
24. Set a toolbar to show my default
25. Removing menu buttons I

Tables II
26. Sorting text alphabetically in a table I
27. Using autosum I

Drawing Toolbar II
28. Creating a polariod photoframe
29. Creating a postit note using autoshapes
30. Wordart custom pattern fill

MS-Excel

The Excel Environment 1. Closing multiple workbooks
2. Zooming in a spreadsheet
3. Using the horizontal scroll bar

Manipulation of Cell Contents

4. Copy and Paste I
5. Auto fill identical data

f x Basic Functions

6. Using The Autosum button
7. The SQRT() function

Intro to Charts

8. Changing the axis color
9. Changing the legend text font
10. Changing the line weight
11. Changing the point style

Formatting Data II

12. Formatting Decimals II
13. Formatting to Currency II

Intermediate Functions

14. The LOG() function
15. The ROMAN() function
16. The PRODUCT() function

Logical Functions

17. The TRUE function
18. The NOT function

Formatting Tables

19. Creating cell borders II
20. Set table color fills

Cell Formatting II

21. Apply conditional formatting
22. How to use the format painter

Advanced Math Functions

23. IMAGINARY()
24. IMPRODUDCT()
25. The MMULT() function
26. The MINVERSE() function