| |
COURSE-I: FUNDAMENTALS OF COMPUTER AND OPERATING SYSTEM |
| 1.1 |
Introduction to Computer |
| 1.2 |
History of Computer |
| 1.3 |
Generation of Computer |
| |
1.3.1 |
First Generation - 1940-1956: Vacuum Tubes |
| |
1.3.2 |
Second Generation - 1956-1963: Transistors |
| |
1.3.3 |
Third Generation - 1964-1971: Integrated Circuits |
| |
1.3.4 |
Fourth Generation - 1972-Present: Microprocessor |
| |
1.3.5 |
Fifth Generation Computer |
| 1.4 |
Classification of Computer |
| |
1.4.1 |
Analog computer |
| |
1.4.2 |
Digital computer |
| |
1.4.3 |
Classification of digital computer |
| |
1.4.4 |
Hybrid computer |
| 1.5 |
Introduction to Computer Hardware and Software |
| 1.6 |
Introduction to Basic Input, Output device and Processing |
| 1.7 |
Starting up/ Turn on the Computer |
COURSE-II: OPERATING SYSTEM (MICROSOFT WINDOWS-XP) |
| 2.1 |
Desktop Icons and Components |
| 2.2 |
Working with start Menu |
| 2.3 |
Configuring the Desktop Environment |
| 2.4 |
Introducing to Essential Features of Windows XP |
| 2.5 |
Introducing to Notepad |
| 2.6 |
Uses of the Keyboard & Mouse |
| |
2.6.1 |
Keyboard |
| |
2.6.2 |
Mouse |
| |
2.6.3 |
2.6.2.1 |
Using the Mouse |
| 2.7 |
File & Folder Management |
| |
2.7.1 |
Opening Folders |
| |
2.7.2 |
Creating Folders |
| |
2.7.3 |
Copying Folders and Files |
| |
2.7.4 |
Moving Folders and Files |
| |
2.7.5 |
Deleting Folders and Files |
COURSE-III: MICROSOFT WORD- WORD PROCESSING APPLICATION |
| 3.1 |
Start MS Word |
| 3.2 |
Introduction to the components of MS Word Window |
| 3.3 |
Use of the Keyboard and Mouse in MS Office Environment |
| 3.4 |
Creating a New Document |
| |
3.4.1 |
Toolbars |
| |
|
3.4.1.1 |
Moving and Resizing the Toolbar |
| |
3.4.2 |
Rulers |
| |
3.4.3 |
The Status Bar |
| |
3.4.4 |
Page Setup |
| |
3.4.5 |
Saving Documents (Save/ Save as) |
| |
3.4.6 |
Open a Saved Document/ MS Word File |
| |
3.4.7 |
Print Preview and Print (Documents Printing) |
| |
3.4.8 |
Exiting Word |
| 3.5 |
Editing Documents/ Text |
| |
3.5.1 |
Entering Text |
| |
|
3.5.1.1 |
Moving Around the Document with the Mouse |
| |
|
3.5.1.2 |
Typing Anywhere on the Page |
| |
3.5.2 |
Going to a Specific Page |
| |
|
3.5.2.1 |
Using Go To for Changes |
| |
|
3.5.2.2 |
Other Uses of the Go To Feature |
| |
3.5.3 |
Entering Text Manipulation |
| |
|
3.5.3.1 |
Text Selection |
| |
|
3.5.3.2 |
Click and Drag |
| |
|
3.5.3.3 |
Selecting text |
| |
|
3.5.3.4 |
De-selecting text |
| |
3.5.4 |
Inserting Text |
| |
3.5.5 |
Combining and Splitting Paragraph |
| |
3.5.6 |
Working with Smart Tags |
| |
3.5.7 |
Inserting a Tab |
| |
3.5.8 |
Seeing Paragraph, Tab, and Space Marks |
| 3.6 |
Formatting Character and Paragraphs |
| |
3.6.1 |
Formatting Toolbar |
| |
3.6.2 |
Making Text Bold, Italic, and Underlined |
| |
3.6.3 |
Changing the Font and Font Size |
| |
|
3.6.3.1 |
Highlighting and Changing text color |
| |
|
3.6.3.2 |
Changing Paragraph Alignment |
| |
3.6.4 |
Changing Line Spacing |
| |
3.6.5 |
Adding Indent |
| |
3.6.6 |
Creating Bulleted and Numbered Lists |
| |
3.6.7 |
Setting a Custom Left or Right Tab |
| |
3.6.8 |
Setting a Custom Center or Decimal Tab |
| |
3.6.9 |
Adding a Border to a Paragraph |
| |
3.6.10 |
Shading a Paragraph |
| |
3.6.11 |
Copying Font and Paragraph Formatting (Format Painter) |
| |
3.6.12 |
Checking the Formatting of Your Text |
| |
3.6.13 |
Changing Case |
| 3.7 |
Formatting Pages |
| |
3.7.1 |
Formatting Options |
| |
3.7.2 |
Changing Margins |
| |
3.7.3 |
Inserting a Page Break |
| |
3.7.4 |
Centering a Page Vertically |
| |
3.7.5 |
Numbering Pages |
| |
3.7.6 |
Creating Headers and Footers |
| |
3.7.7 |
Inserting Dates and Page Numbers in Headers and Footers |
| 3.8 |
Handy Editing Techniques |
| |
3.8.1 |
Searching for text |
| |
3.8.2 |
Finding and Replacing Text |
| |
3.8.3 |
Using the Thesaurus |
| |
3.8.4 |
Using Automatic Spell Checking |
| |
3.8.5 |
Checking Your Spelling with the Spell Checker |
| |
3.8.6 |
Checking Grammar |
| |
3.8.7 |
Inserting a Special Character |
| |
3.8.8 |
Inserting the Date |
| |
3.8.9 |
To Insert Comments in your Documents |
| 3.9 |
Using Column and Table |
| |
3.9.1 |
Creating Columns |
| |
3.9.2 |
Formatting Columns |
3.10 |
Creating a Table |
| |
3.10.1 |
Deleting a Table |
| |
3.10.2 |
Navigating a Table |
| |
3.10.3 |
Adding, Deleting, and Resizing Rows and Columns |
| |
3.10.4 |
Formatting a Table |
| |
3.10.5 |
Drawing a Table
|
| |
3.10.6 |
Adjusting the Appearance of Your Table |
| 3.11 |
Adding Images to Your Document |
| |
3.11.1 |
Inserting an Image in the Document |
| |
3.11.2 |
Inserting an Image in the Document |
| |
3.11.3 |
Moving and Sizing an Image |
| |
3.11.4 |
Cropping an Image and Adding Borders |
| |
3.11.5 |
Controlling Text Flow Around an Image |
| |
3.11.6 |
Adding Shapes to Your Document |
| |
3.11.7 |
Creating WordArt |
| |
3.11.8 |
Performing Mass Mailings |
| |
|
3.11.8.1 |
Starting the Main Document |
| |
|
3.11.8.2 |
Choosing the Fields for Your Data Source |
| |
|
3.11.8.3 |
Entering Records into the Data Source |
| |
|
3.11.8.4 |
Sorting and Editing the Recipient List |
| |
|
3.11.8.5 |
Completing the Main Document |
| |
|
3.11.8.6 |
Previewing Your Merged Letters |
| |
|
3.11.8.7 |
Running the Merge |
| |
|
3.11.8.8 |
Beginning an Envelope Mail Merge |
| |
|
3.11.8.9 |
Finishing an Envelope Mail Merge |
| |
|
3.11.8.10 |
Beginning a Label Mail Merge |
| |
|
3.11.8.11 |
Finishing a Label Mail merge |
| 3.12 |
Word and the Web |
| |
3.12.1 |
Inserting Hyperlinks in a Word Document |
| |
3.12.2 |
Converting a Word Document to a Web Page |
| |
3.12.3 |
Converting a Web Page to a Word Document |
| 3.13 |
Bangla Typing |
COURSE-IV: SPREAD SHEET APPLICATION- MICROSOFT EXCEL |
4.1 |
Starting with Microsoft Excel |
| |
4.1.1 |
Screen Elements of MS Excel |
| |
4.1.2 |
To enter text into a worksheet |
| |
4.1.2.1 |
To enter numbers into a worksheet |
| |
4.1.3 |
To save a workbook |
| |
4.1.4 |
To minimize a workbook window |
| |
4.1.5 |
To close a file |
| |
4.1.6 |
To exit Microsoft Excel |
4.2 |
Using MS Excel |
| |
4.2.1 |
Creating and Opening Workbooks |
| |
|
4.2.1.1 |
To create a new default workbook |
| |
|
4.2.1.2 |
To open a file |
| |
4.2.2 |
Data Entry Techniques |
| |
|
4.2.2.1 |
To fill a range of cells with the same data |
| |
|
4.2.2.2 |
To fill a range of cells with the 'automatic' data |
| |
4.2.3 |
Navigating in the Worksheet |
| |
|
4.2.3.1 |
To move to a particular cell (quick way) |
| |
4.2.4 |
Selection Techniques |
| |
4.2.5 |
Inserting and Deleting |
| |
4.2.6 |
Special Use of Copy and paste using Clipboard |
4.3 |
Formatting using Excel |
| |
4.3.1 |
Formatting - Fonts |
| |
|
4.3.1.1 |
To change the font used in a cell or range of cells |
| |
|
4.3.1.2 |
To change other font characteristics |
| |
4.3.2 |
Formatting - Alignment |
| |
4.3.3 |
The Excel Formatting - Colors |
| |
4.3.4 |
The Excel Formatting - Numbers |
| 4.4 |
Excel Formula and Function |
| |
4.4.1 |
Excel Formula |
| |
|
4.4.1.1 |
To enter a formula |
| |
|
4.4.1.2 |
To enter a cell or range reference by pointing |
| |
4.4.2 |
Excel Function |
| |
|
4.4.2.1 |
To enter functions directly into the worksheet cell |
| |
|
4.4.2.2 |
To use the AutoSum function |
4.5 |
Create an Excel Chart |
4.6 |
Create and Use Excel Template |
| |
4.6.1 |
To create a template |
| |
4.6.2 |
To use a template |
| |
4.6.3 |
Template vs Style |
| |
4.6.4 |
To create a style |
| |
4.6.5 |
To apply a style |
| 4.7 |
Excel Macro – Make Your Complex Tasks Automated |
| |
4.7.1 |
To record a macro |
| |
4.7.2 |
To assign a shortcut key to the macro |
| |
4.7.3 |
To run a macro using the Tools Macro command |
| |
4.7.4 |
To run a macro using the assigned shortcut key |
| |
4.7.5 |
To create a button and assign an Excel macro to it |
| |
4.7.6 |
To run the macro, simply click on the button |
| |
4.7.7 |
To delete a button |
| 4.8 |
Worksheet and Workbook Protection |
| |
4.8.1 |
To specify a password for opening and modifying a workbook |
| |
4.8.2 |
To remove a password from a workbook |
| |
4.8.3 |
To protect a workbook |
| |
4.8.4 |
To unprotect a workbook |
| |
4.8.5 |
To protect a worksheet |
| |
4.8.6 |
To protect a worksheet |
| |
4.8.7 |
To unprotect a worksheet |
| 4.9 |
Printing in Excel |
| |
4.9.1 |
Page Setting |
| |
|
4.9.1.1 |
To change Page Setup options |
| |
|
4.9.1.2 |
To set the printing paper orientation |
| |
|
4.9.1.3 |
To set the scale of the page |
| |
|
4.9.1.4 |
To set other printing options |
| |
|
4.9.1.5 |
Margins Settings |
| |
|
4.9.1.6 |
Header/Footer Settings |
| |
|
4.9.1.7 |
Excel Printing - Sheet Settings |
| |
|
4.9.1.8 |
To change the Excel printing settings |
| 4.10 |
Using the Excel conditional Formatting |
| |
4.10.1 |
To format cells using conditional formatting |
| 4.11 |
Install, Remove and Get Free Excel Add-in |
| |
4.11.1 |
To install Excel Add-ins |
| |
4.11.2 |
To uninstall Excel Add-ins |
| |
4.11.3 |
Excel Function (IF) |
| |
|
4.11.3.1 |
Logical _test |
| |
|
4.11.3.2 |
Logical operators |
| |
|
4.11.3.3 |
To demonstrate the Excel IF function |
4.12 |
Excel Function (CHOOSE) |
4.13 |
Date Function |
| |
4.13.1 |
Mathematical Date Functions |
| 4.14 |
Create Pie Chart |
| |
4.14.1 |
Step 1: The Chart Wizard (1) – Chart Type |
| |
4.14.2 |
Step 2: The Chart Wizard (2) – Data Source |
| |
4.14.3 |
Step 3: The Chart Wizard (3) – Chart Options |
| |
|
4.14.3.1 |
To add title to a chart |
| |
|
4.14.3.2 |
To customize chart legend |
| |
|
4.14.3.3 |
To customize data labels |
| |
4.14.4 |
Step 4: The Chart Wizard (4) – Chart Location |
| |
|
4.14.4.1 |
To define the chart location |
| 4.15 |
Use the Excel Paste Special Feature |
| |
4.15.1 |
To use Paste Special to link to Excel data |
| |
4.15.2 |
To use Paste Special to link data from another program (MS Word) |
| COURSE-V: DATABASE APPLICATION-MICROSOFT ACCESS |
| 5.1 |
Features of Microsoft Access |
| 5.2 |
Definitions |
| |
5.2.1 |
Program |
| |
5.2.2 |
Data |
| |
5.2.3 |
Database |
| |
|
5.2.3.1 |
Uses of Databases |
| |
|
5.2.3.2 |
The Database Window |
| |
5.4.1 |
Creating Table3 |
| |
5.4.2 |
Creating Field |
| |
5.4.3 |
The Primary Key |
5.5 |
Data Entry in the Table |
5.6 |
Opening existing/ prepared Database and Table |
| |
5.6.1 |
Creating Order Table |
| |
5.6.2 |
Creating Product Table in Design View |
| |
5.6.3 |
Data Sorting |
| 5.7 |
Running Query in Design View |
| |
5.7.1 |
Other Queries form Credit Field |
| |
5.7.2 |
Query using OR Statement |
| |
5.7.3 |
Query using OR & AND condition |
| 5.8 |
Creating Form |
| |
5.8.1 |
Creating Auto Forms |
| 5.9 |
Creating Report |
| COURSE-VI: PRESENTATION APPLICATION-MICROSOFT POWER POINT |
| 6.1 |
Starting MS Power Point |
| |
6.1.1 |
To enter text into a presentation |
| |
6.1.2 |
Saving and Closing a presentation |
| |
|
6.1.2.1 |
To save a presentation |
| |
|
6.1.2.2 |
To close a presentation |
| |
|
6.1.2.3 |
To exit Microsoft PowerPoint |
| 6.2 |
Creating PowerPoint Presentation Slide |
| |
6.2.1 |
To display Task Pane (if it has been closed) |
| |
6.2.2 |
To switch to other Task Panes |
| |
6.2.3 |
To display the New Presentation Pane |
| |
6.2.4 |
To open an existing presentation |
| 6.3 |
To create a new blank presentation |
| |
6.3.1 |
The Outline and Slides Tabs |
| |
|
6.3.1.1 |
To change the size of the Outline and Slides Tabs |
| |
|
6.3.1.2 |
Different PowerPoint Views |
| 6.4 |
The PowerPoint Toolbars and Slide Manipulations |
| |
6.4.1 |
To show a toolbar |
| |
|
6.4.1.1 |
To hide a toolbar |
| |
|
6.4.1.2 |
The Standard Toolbar |
| |
|
6.4.1.3 |
The Formatting Toolbar |
| |
6.4.2 |
Power point Toolbar and Managing Slide |
| |
|
6.4.2.1 |
To insert a new slide |
| |
|
6.4.2.2 |
To insert a duplicate slide |
| |
|
6.4.2.3 |
Copy and Paste Slides |
| |
|
6.4.2.4 |
To copy slides with the Outline tab |
| |
|
6.4.2.5 |
To paste the slide |
| |
|
6.4.2.6 |
Deleting Slides |
| |
|
6.4.2.7 |
To delete slides with the Outline tab |
| |
|
6.4.2.8 |
To delete slides with the Slides tab |
| |
|
6.4.2.9 |
To delete slides in Slide Sorter view |
| 6.5 |
PowerPoint Design and AutoContent Wizard |
| |
6.5.1 |
To create a new presentation from a design template |
| |
6.5.2 |
PowerPoint AutoContent Wizard |
| |
|
6.5.2.1 |
To create a new presentation using the AutoContent Wizard |
6.6 |
PowerPoint Slide Manipulations |
| |
6.6.1 |
PowerPoint Slide Layout |
| |
|
6.6.1.1 |
To display the Slide Layout Pane (if it has been closed) |
| |
|
6.6.1.2 |
To apply a text layout to a slide |
| |
|
6.6.1.3 |
To apply a content layout to a slide |
| |
|
6.6.1.4 |
To apply text and content layouts to a slide |
| |
|
6.6.1.5 |
To apply other layouts to a slide |
| |
6.6.2 |
PowerPoint Slide Background |
| |
|
6.6.2.1 |
To select a Slide Background Color |
| |
|
6.6.2.2 |
To select a Slide Background Fill Effect |
| |
6.6.3 |
PowerPoint Slide Headers and Footers |
| |
|
6.6.3.1 |
To insert slide Headers and Footers |
| |
6.6.4 |
Bullets and Numbering |
| |
|
6.6.4.1 |
To add or remove bullets |
| |
|
6.6.4.2 |
To change bullet style |
| |
|
6.6.4.3 |
To create Custom Bullets |
| |
|
6.6.4.4 |
To add or remove numbering |
| |
|
6.6.4.5 |
To change numbering style |
| |
|
6.6.4.6 |
To change Bullets or Numbering Color |
| 6.7 |
The PowerPoint Drawing Toolbar |
| |
6.7.1 |
To display the drawing toolbar |
| |
|
6.7.1.1 |
To add an AutoShape |
| |
|
6.7.1.2 |
To draw a line |
| |
|
6.7.1.3 |
To draw an arrow head |
| |
|
6.7.1.4 |
To draw a rectangles |
| |
|
6.7.1.5 |
To draw an ovals |
| |
|
6.7.1.6 |
To create a text box |
| |
|
6.7.1.7 |
To create a vertical text box |
| |
|
6.7.1.8 |
To create a WordArt object |
| |
|
6.7.1.9 |
To create a Diagram or Organization Chart |
| |
|
6.7.1.10 |
To insert a clipart |
| |
|
6.7.1.11 |
To insert a picture |
6.8 |
To create your own design template |
6.9 |
PowerPoint Slide Design - the Color and Animation Schemes |
| |
6.9.1 |
Power Point Slide Design - Design Templates |
| |
6.9.2 |
PowerPoint Slide Design - Color Schemes |
| |
|
6.9.2.1 |
To apply a Color Scheme to One Slide |
| |
|
6.9.2.2 |
To customize Color Schemes |
| |
|
6.9.3 3 |
PowerPoint Slide Design - Animation Schemes |
| |
|
6.9.3.4 |
To apply an Animation Scheme to One Slide |
| |
|
6.9.3.5 |
To apply an Animation Scheme to All Slides |
| 6.10 |
Power Point Slide Show |
| |
6.10.1 |
To view a Slide Show from the first Slide |
| |
6.10.2 |
To view a Slide Show from the current Slide |
| |
6.10.3 |
To move to the next slide in a Slide Show |
| |
6.10.4 |
To move to the previous slide in a Slide Show |
| |
6.10.5 |
To move to a specific slide in the Slide Show |
| |
6.10.6 |
To Pause the Slide Show |
| |
6.10.7 |
To Turn the Screen Black |
| |
6.10.8 |
To Turn the Screen White |
| |
6.10.9 |
Pointer Options |
| |
6.10.10 |
To use the arrow pointer |
| |
6.10.11 |
To select the arrow pointer |
| |
6.10.12 |
To change the pointer to a pen |
| |
6.10.13 |
To change pen color |
| 6.11 |
PowerPoint Presentation Printing |
| |
6.11.1 |
To change Page Setup options |
| |
6.11.2 |
To print |
| |
6.11.3 |
Printer section |
| |
|
6.11.3.1 |
Properties Button |
| |
|
6.11.3.2 |
Print range section |
| |
|
6.11.3.3 |
Copies section |
| |
|
6.11.3.4 |
Print what section |
COURSE-VII: INTERNET BROWSING/ SURFING |
7.1 |
Before Start Browsing |
7.2 |
INTERNET SEARCHING EXERCISE – RSI |
7.3 |
Installing Programs & Hardware |
| |
7.3.1 |
Install New Fonts: |
7.4 |
Installing Hardware |
7.5 |
Installing or Uninstalling Program |
| |
7.5.1 |
Installing Programs |
| |
7.5.2 |
To Uninstall Program |
