Basic Computer Training Course

(Designed for the school teachers of BCICT Programme implemented Schools)

This book covers the following courses:

ü  Introduction to computer

ü  Computer History

ü  Windows OS

ü  MS-Word 2000/XP

ü  MS-Excel 2000/XP

ü  MS-Power Point 2000/XP

ü  MS-Access 2000/XP

ü  Adobe PageMaker 6.5/7.0

ü  Q-Basic

ü  Multimedia Overview

ü  E-mail & Internet

ü  Virus Scanning

ü  Basic Hardware

Introduction to computer [ 4  hours ]

What is computer?

Hardware

Software

User

Data administrator, Data Entry Operator, Desktop Publisher, Designer and Developer etc.

Software Types

Ø  System Software,  Application Software,  Utilities Software

Computers: History and Development

Overview

Early Computing Machines and Inventors

Generations of Modern Computers

First Generation (1945-1956)

Second Generation Computers (1956-1963)

Third Generation Computers (1964-1971)

Fourth Generation (1971-Present)

Fifth Generation (Present and Beyond)

Types of Computer

·         According to size

v       Super computer,  Mainframe computer,  Mini computer, Micro computer

                        Desktop: ,  Laptop:

·         According to function

v       Analogue Computer, Digital Computer, Hybrid Computer

Computer System   [ 4  hours ]

1. Input Unit

2. Processing Unit

ALU: Arithmetic and Logic Unit

CU: Control Unit

MU: Memory Unit

There are two types of memory

·         Primary Memory : RAM, ROM

·         Secondary Memory : Hard Disk, Floppy Disk, Compact Disk, Zip Disk

3. Output Unit

0                   Monitor, Printer

0                   Binary Language

0                   Binary Digit (BIT)

0                   Bits and Bytes

Peripherals of Computer (Hardware of PC)

Computer Starting

Shutting Down the computer

Operating Systems

MS-DOS   [ 6 hours ]

Types of booting:

Files,  Filename,  Extension,  Directory,  DOS Prompt,  DOS Command

Microsoft ®Windows Operating System [ 10 hours ]

To find a file or folder

Locking/unlocking the taskbar

Moving the taskbar

Resizing the taskbar

Changing the properties of the taskbar

Placing Toolbar to the Taskbar

Creating new folder on the desktop 

To change the name of folder

To open the folder

To delete the folder 

To undelete the deleted items

To copy files from one folder to another folder

To copy file or folder by mouse.

To move file or folder by mouse.

Arranging your desktop icons.

Creating desktop shortcuts

To create a program folder and put program items on it

Removing items from the start menu

To place wallpaper

To put screensaver

Right-click on empty desktop > click properties > click screensaver tab

To change the appearance of windows

Windows Explorer

-          Open Windows

-          Explore Windows

o   Create new folder

-          Edit (Cut, Copy, Paste Selection, undo)

-          View

-          Go

-          Tools (Find)

-          Help

Start Menu

-          Shut Down

-          Log off

-          Run

-          Setting  (Task and Start Menu)

-          Program (Start up, A accessories, Paint, Word pad, calculation0

-          Documents (Recent Document)

Microsoft Word   [ 20 hours ]

Ø  Create new file, open an exiting file, save file, import and export a saved file.

Ø  Help to set page margin, paragraphs and sections within a document,

Ø  Adjust indents and hanging indents,

Ø  Add bulleted and numbered lists,

Ø  Change the fonts, font styles and font size according to our wish,

Ø  Edit text by inserting, deleting, moving and coping passages of text,

Ø  View document changing in different size,

Ø  Set tab stops and select different types of tabs,

Ø  Create and edit tabular information,

Ø  Set tabs for dot leaders,

Ø  Find specified text and replace one text using with another

Ø  Insert page breaks, page numbers, reference points, special symbols, date and time in a document and equation, etc.

Ø  Insert header (top of the document), footer (bottom of the document) and annotation, etc,

Ø   Insert frames for sidebars, run-arounds and other special effects,

Ø  Create and edit columnar information (i.e. column),

Ø  Create and insert pictures using the drawing toolbar,

Ø  Check spelling, thesaurus, and grammar,

Ø  Sort text and hyphenation,

Ø  Create and edit Excel Worksheets,

Ø  Automate our work by recording and playing macros and

Ø  Print document and envelopes.

How to enter Microsoft word?

SOME SHORT CUT KEYS

How to move CURSOR?

What is highlighting?

How to highlighting text-using Cursor?

How to highlight text-using mouse?

How to delete text?

How to save document?

File

New, Open, Close; Save, Save As; Page Setup, Print Preview, Print.

Edit

Undo, Redo, Cut, Copy, Paste, Find, Replace, Go to.

View:

Normal, Web Layout, Print Layout; Toolbar, Ruler, Document Map, Header and Footer, Footnote, Zoom.

Insert

Breaking page /column, Inserting page number, Inserting date/ time, Creating auto text, Inserting auto text, Inserting symbol, Inserting footnote /endnote, Inserting clip art picture, Inserting picture from file, Inserting auto shapes, Inserting Word art, Inserting chart, Wrapping text around the picture, Inserting text box

Format

Font, Paragraph, Bullet and Numbering, Boarder and Shading; Column, Tab, Drop Cap, Text Direction, Change Case, Style.

Tools

Spelling and gummer, Language, Word Count, Auto Correct, Protect Document, Mail Merge, Macro, Customize, Option

Table

Draw Table, Insert, Delete, Select, Merging cell, Splitting Cell, Splitting Table, Table Auto Format, Auto Fit, Heading Row Repeat, Convert, Sort, Formula, Table Property.

Window

New Window, Arrange All, Split, Change File.

Help

Microsoft Word Help, What's This.

=THE END= 

Microsoft Excel     [  10 hours ]

Entering Excel

Some useful terms

*          Multiplication  / Division        + Addition      - Subtract        > Greater than

<          Less than         >= Greater than equal to         <= Less than equal to

Entering Date 

Create a new Workbook.

Saving, Opening, Closing, RE-saving, Page Setting, Previewing the documents

Copying, Moving, finding, replacing the data:

Creating serial number

Deleting Data

Deleting the worksheet

Moving data from one book to another book or form one sheet to another sheet

Adding header/footer

Inserting cells, rows, columns or worksheet

Inserting chart:

Breaking page:

Using function

Inserting picture

Changing number format

Arranging data

Changing font, font’s style and fonts size

Adding border and shading

Changing width and height of rows and columns

Note:

Hiding or displaying rows or columns or sheet

Changing sheet name

Inserting background picture

Apply auto format to worksheet

Displaying or hiding gridlines

Sorting data in ascending or descending order

Filtering data

From

Subtotals

Converting text into column

How to do page set up

How to print preview:

How to view formula bar:

Splitting windows

Freezing windows

=THE END=

MS POWERPOINT   [ 6 hours ]

Duplicating Slide

Deleting Slide

Slide Show

Inserting new slide

Slide Number

Movies and Sound:

Slide Layout

Slide color Scheme

Adding Background

Apply Design Template

Color and line

View Show

Rehearse and Timing

Present animation

Custom Animation

Slide sorter

Slide notes

Slides miniature

Slide master

Change case

Slide transition

= The End =

Access 2000/XP  [ 6 hours]

            -Introduction of Access

            -Introduction of Database

-Types of Database

                        -DBMS

                        -RDBMS

-Data Types

            -Rules to Declare Data types

-Creating Tables

                        -Design  View

                        -Wizard View

                        -Entering  data view

-Creating Form

                        -Design View

                        -Wizard View

-Creating Report

                        -Design View

                        -Wizard view

Creating  Pages of database for web

                        -Design View

                        -Wizard View

                        -Existing View

Creating  Queries

                        -Design View

                        -Wizard View

Module Description

Creating Functions

                        -user defined

                        -Built In functions

Macros Descriptions

Creating Relationship

                        -One to One Relationship

                        -Many to many relationship

                        -One to Many Relationship

Security for  Database

            -Creating user

            -Set Database Password

            -User & user Permit ion

            -Deleting  user and Database Password

QBasic Programming   [ 10 hours ]

-Introduction of QBasic Programming

            -Basic terms used  in QBasic

            -Basic Statement and Commands

Variables

            -Declaring variable

            -Types of variables

Operators

            -Arithmetic Operators

            -Conditional Operators

            -Logical Operators

Basic Programs

            -INPUT

            -PRINT

Looping for Programs

            -For Loops

            -While loops

                        -Inner loops

                        -Outer loops

Functions

            -Built in Functions

            -User Defined functions

Array

            -Singular Array

            -Double Array

            -Multidimensional Array

Adobe PageMaker 6.5   [ 6 hours ]

Introduction

To start PageMaker

To work with PageMaker

Changing the PageMaker’s view

Revert:

Document setup

Print

Preference

Paste multiple

Edit story

Go to page

Insert pages

Remove pages

Sort pages

Go Back / Forward

Column guides

To change font

To change font size

To change line spacing [leading]

To change type style

To change export tracking

Horizontal scale

Character

Paragraph

Fill

Stroke

Fill & stroke

Arrange

Text wrap

Group

Ungroup

Lock / unlock position

Mask

Unmask

Polygon settings

Hiding or displaying rulers

Setting zero lock on or off

Locking or unlocking guides

Applying bullets and numbering

Changing case

Adding drop cap

Setting indents

Applying rounded corner

=THE END=

Using Windows Media Player        [   2 hours ]

Windows Media Player play commands

• Play/Pause /Stop
• Skip Back
• Skip Forward
• Rewind (available for video files in Windows Media Format only)
• Fast Forward (available for video files in Windows Media Format only)
• Shuffle/Repeat
• Volume

Copying and playing CDs

Playing music from CDs

Viewing album details

To create your own CD

Understanding the CD Audio feature

Adding files to Media Library

To create a playlist

To add a file to a playlist

To delete an individual item from Media Library

To delete a playlist from Media Library

To restore an individual item in Media Library

To permanently delete playlist from Media Library and computer

==The end==

INTERNET AND E-MAIL   [ 4 hours ]

Internet

What is internet?

Requirement To Access Internet

Steps of surfing the net:

-          Favorites

o   Add to favorites

o   Organize favorites

o   Internet option

-          View

o   Tool bar

o   Text size

o   Source

E-mail:

What is email?

Advantages of e-mail

Internet Mai

 (Hotmail, Yahoo, Rediff etc)

Email (pop)

-          Set up new account

-          Identity Management and Creation

-          Import mails from backup

-          Edit

-          View

-          Tools

o   Send and receive

o   Address Book

o   Message rules

o   Account

o   Option

-          Message

o   New Message

o   Reply to sender

o   Block sender

-          Create folder at local mails

== The end==

COMPUTER VIRUS    [ 2 hours ]

Types of Computer Viruses:

ü   Boot Sector Viruses

ü   Source code viruses

ü   File Viruses

ü   Visual Basic Worms

ü   Polymorphic Viruses

ü   Macro Virus

ü   Batch file virus

ü   Companion viruses

ü   Macro viruses

ü   System Sector Viruses

ü   File Viruses

ü   Macro Viruses

ü   Companion Viruses

ü   Cluster Viruses

ü   Batch File Viruses

ü   Source Code Viruses

ü   Visual Basic Worms

Scanning and Removing virus

"The End"

Basic Computer Hardware [ 30 hours ]

1.     Main Parts of Computer

(A)       Mother Board

1. ISA Mother Board, 2. PCI Board

(B)        CPU

(C)        Computer Memory

1)    Main Memory

(a) RAM (Random access memory), (b) ROM (Read only memory)

2)    Auxiliary Storage

(a) Floppy Disk, (b) Hard Disk, (c) Compact Disk etc.

(D)       Power Supply

(E)        Cards (Types of Card : ISA, PCI, AGP)

1. IO Card, 2. Display Card, 3. Sound Card, 4. Modem, 5. Network (LAN) Card, 6. TV Tuner Card etc.

(F)         Input Device

1. Keyboard, 2. Mouse, 3. Scanner, 4. Light Pen, 5. Joystick etc.

(G)       Output Device

1)    Soft output device

Monitor

2)    Hard output unit

Printers

(a) Impact Printers

(b) Non‑impact Printer

2.     Computer Assembling

3.     Software Installation

(A)       Operating System Installation

(B)        Application Software Installation, Manage Software.

(C)        Driver Software Installation

4.     Troubleshooting

5.     Networking

6.     Computer Maintenance Tools

(Software CD, Driver CD, Screw Driver Etc.)