Computer fundamental and ms office
Computer overview And Awareness
What is a computer?
A computer is an electronic machine which we enter
data, then computer process the data and retrieve data
Dataà0-9 / a-z
Benefits of computer
· Speed
· Accuracy
· Diligence
· memory
Limitations of computer
It does not have brain
How does a computer works
Ià P àO cycle
Input à Process à Output
Parts of computer system
1. Monitor
a. CRT (Cathode Ray Tube)
b. LCD (Liquid crystal Display)
c. LED(Light emitting diode)
2. CPU( Central processing unit )
3. Mouse
a. Ball mouse
b. Optical mouse
4. Keyboard à (Normal
5. Speaker
a. Normal
b. Woofer(home theatre)
6. Printer
a. Dot matrix Ink àribbon 1/mnt
b. Ink jet Ink àliquid 5/mnt
c. Laser inkàpowder 10/mnt
7. Scanner
8. Web cam
9. Mic
How to close computer
Start
↓
Turn off / shut down
↓
Turn off / shut down
↓
Ok
Hardware
Physical component of computer system which we can see and touch is called as hardware
Ex:
- part of computer
Software
Set of instruction to perform a specific task is
called as software
Types of software
Operating system software
OS
|
Application software
AS
|
Start
computer
àBoot Process
management
Close
computer
àshut down / turn off
Types of OS
1. DOS
2. Windows 95
3. Windows 98
4.
Windows XP
5. Windows NT
6. Windows ME
7. Windows 2000
8. Windows
9. windows 7
10.
ubuntu
|
To
perform various task on computer we use application
software
· Paint
· Notepad
· Word
· Excel
· PowerPoint
· internet
· Tally
· Window media player
· Etc.
|
10.LINUX/UNIX
|
|
Desktop
First
screen of any computer after boot is called as desktop.
Component of desktop
· Wallpaper
· Icon
· Taskbar
Wallpaper
Background screen of desktop is called
wallpaper
How to change wallpaper
Right click on desktop
¯
Properties
¯
Desktop
¯
Choose any one
¯
Apply
¯
Ok
Screen saver
How to set a screen saver
Right-click on desktop
¯
Properties
¯
Screen saver
¯
Choose any one
¯
Wait-->1,2,3….
¯
Apply
¯
Ok
Icon
Small picture like symbol on desktop is
called as icon
Ex:
1. Folder
2. My documents
3. My computer
4. Recycle bin
5. files
Folder
Folder is a container in which you can store your
files and folder
How to create folder
Right click on desktop
¯
New
¯
Folder
¯
Type àsandeep
How to save file on folder
File
↓
Save as
↓
Save inàFolder
↓
File name àfile name
↓
Save
My documents
My documents contains files and folders
How to save files on my documents
File
↓
Save as
↓
Save inàMy documents
↓
File name àsandeep
↓
Save
My computer
My computer contains information about secondary
storage devices
Storage
Primary / temporary storage
|
Secondary / permanent storage
|
||||
 RAM
àRandom Access Memory
·
256
MB
·
 512 MB
· 1 GB
· 2 GB
|
1.
Hard Disk (C: / D :)
1,2,3
….320, 500GB
2. CD driveà(700 MB)
3. Pen driveà1,2…40 GB
|
Units of measure
8 Bit = 1 byte (a-z, 0-9)
1024 Byte = 1 KB (Kilobytes)
1024 KB = 1 MB (Megabytes)
1024 MB = 1 GB (Gigabytes)
1024 GB= 1 Terra byte
1024 TB= 1Peta Byte
1024 PB=1 Exa Byte
1024 EB=1 Zeta Bytes
1024 ZB=1 Yotta Byte
1024 YB=1 Bronto Byte
1024BB=1 Geop Byte
How to save file on my computer
File
↓
Save as
↓
Save inàmy computer
↓
Save inàC: / D: / pen drive
↓
File name à deep
↓
Save
Recycle Bin
Recycle bin stores deleted files and
folders
 |
Recycle
bin Hard
disk
How to delete files and folders
Select file or folder
↓
Right click
↓
Delete
↓
Yes
How to restores files and folders
Open Recycle bin
↓
Select file or folder
↓
Right click
↓
Restores
↓
Close
How to save file on desktop
File
↓
Save as
↓
Save inàDesktop
↓
File name àsan
↓
Save
MS office
1. MS word
2. MS excel
3. MS PowerPoint
Microsoft word
MS
word is word processing software it
is used to create documentation
Uses
of MS word
1. Application
2. Report
3. letters
4. cards
5. Bio-data
6. forms
7. Documentation
How to start MS word
Start
↓
Programs
↓
Microsoft office
↓
Microsoft word
Start
↓
Runàwinword
↓
Ok
Component of word window
v Title bar
v Menu bar
v Toolbar
v Ruler bar
v Work space
v Status bar
Copy and paste
This option is
used to duplicate any text, files and folder.
Select any
text
↓
Home
↓
Copy
↓
Position the
cursor
↓
Paste
Cut and paste
This option is
used to move any text from one location to another location
Select any
text
↓
Home
↓
Cut
↓
Position the
cursor
↓
Paste
Spelling & grammar
This option is used to check spelling
and grammar
Right click on word
↓
Choose correct option
Font
This option is used to change text
color, size, style etc.
Select any text
↓
home
↓
Font
↓
Fontàtimes new roman / kruti dev
Font colorà…………….
Font size à…………
Font styleà………
↓
Ok
Change case
This option is used to change small to
capital letter
Select any text
↓
Home
↓
Change case
↓
Sentence caseà……….
lower caseà……….
UPPER CASEà……..
Title Caseà……….
tOGGLE cASEà…….
↓
Ok
Format painter
This option is used to copy one text’s style, color,
size into another text
Select first text
↓
Home
↓
Click on format painter
↓
Select second text
Bullets and numbering
This option is used for listing a
document
Home
↓
Bullets and numbering
↓
Bullets
↓
Choose any one
↓
Ok
Alignments
This option is used to change alignment
of the text
Select any text
↓
Home
↓
Click on left / center / right / justify
Border and shading
This option is used to apply page border on the
documents
page layout
↓
Page border
↓
Art
↓
Choose any one
↓
Ok
Text box
This option is used draw text box
|
Insert
↓
Text box
↓
Draw from mouse
Word art
This option is used to create designer word
Insert
↓
Picture
↓
Word art
↓
Choose any one
↓
Ok
↓
Type àSonia
↓
Ok
Clip art
This option is used to insert picture on the documents
Insert
↓
Picture
↓
Clip art
↓
Choose any one
Hyperlink
This option is used to link with another
file
Select any text
↓
Insert
↓
Hyperlink
↓
Look inà………………….
↓
Select file
↓
Ok
Background
This option is used to change background color of
the documents
Page layout
↓
Page Color
↓
Background
↓
Choose any one color
How to set two colors on background
Page layout
↓
Page Color
↓
Fill effects
↓
Gradient
↓
One color / two color /
preset color
↓
Shading style
↓
Variant
↓
Ok
Printed watermark
This option is used to set watermark on
the documents
Page layout
↓
Printed watermark
↓
Text watermark / picture
watermark
↓
Ok
Drop cap
Used to design first letter of any text
Select first letter
↓
Insert
↓
Drop cap
↓
Dropped
↓
Ok
Column
This option is used to set column
Page layout↓
↓
Column
↓
Number of columnà1,2,3…….
↓
ok
Break
This option is used for page break
Position the cursor
↓
Insert
↓
Break
↓
Page break
↓
Ok
Symbol
This option is used to insert symbol on
the documents
Insert
↓
Symbol
↓
Choose any one
↓
Shortcut key
↓
Press new shortcut key àctrl+a-z
↓
Assign
↓
Close
↓
Close
É 07782 ¿ 9977833997
xÅy àxy’+x’y
N
How to remove symbol
Select symbol
↓
Insert
↓
Symbol
↓
Shortcut key
↓
Current key àctrl+a-z
↓
Remove
↓
Close
↓
Close
Page number
This option is used to insert page number on the
documents
Insert
↓
Page number
↓
Position àtop / bottom
Alignment àleft / center / right
↓
Format
↓
Number format-à1, 2, 3……..
↓
Ok
↓
Ok
Date & time
This option is used to insert current
date & time
Insert
↓
Date & time
↓
Choose any one
↓
Ok
Qaaaaaaaaaa/Klk
My
computer
How to remove hyperlink
Right click on hyperlink
text
↓
Remove hyperlink
Auto text
This option is used to
create ready made words
Office button
↓
Word option
↓
proofing
↓
Auto correct
↓
Auto correct
↓
Replaceàb
WithàBless computer education society
↓
Add
↓
Ok
Header and footer
Header àthis option is used to apply
heading on the documents
AND
Footer àthis option is used to apply
page number on the documents
Insert
↓
Header and footer
↓
Type àpriya
↓
Click on footer
↓
Insert auto text
↓
Page
↓
Close
View
By using view option we can see our document in
different views
View
↓
Web layout view
Print layout view
Outline view
Find and replace
àFind àthis option is used to search any text in the
documents
And
Replaceàthis option is used to change find text
Home
↓
Find
↓
Find what àOld text
↓
Replace
↓
Replace withànew text
↓
Replace all
↓
Close
Undo
This option is used to cancel any task
Home
↓
Undo Ctrl+z
Redo
This option is used to cancel undo
Home
↓
Redo Ctrl+y
Table
Table consist of rows and columns
RowàHorizontal line is called row
Columnàvertical line is called column
Insert
↓
Table
↓
Number of columnà1,2,3……….
Number of rowsà1,2,3………..
↓
Ok
How to insert new column, rows
Position the cursor
↓
Layout
↓
Insert
↓
Column to the right / Column
to the left
Rows above/ rows below
How to delete row, column and table
Position the cursor
↓
Layout
↓
Delete
↓
Table
Column
Row
New
This option is used to open new blank
documents
Office Button
↓
New
↓
Blank documents
↓
Ok
Print preview
This option is used to see the documents
before printing
Office button
↓
Print preview
↓
Close
Print
This option is used to printing any
documents
Office Button
↓
Print
↓
Allà…………
Current pageà……………
Pagesà…22-30
↓
Number of copiesà1,2,3…..
↓
Ok
Page setup
This option is used to set page
Page layout
↓
Page setup
↓
Topà…………..
Bottomà…………
Leftà……….
Rightà…………
↓
Portrait / landscape |
Ok
Shortcut keys
1. copy àCtrl+c
2. cutà Ctrl+x
3. Pasteà Ctrl+v
4. undoà Ctrl+z
5. Redoà Ctrl+y
6. save à Ctrl+s
7. Bold à Ctrl+b
8. Italic à Ctrl+i
9. Underline à Ctrl+u
10.
Left alignà Ctrl+q,L
11.
Center align à Ctrl+e
12.
Right align -> Ctrl+r
13.
Justify à Ctrl+j
14.
Font -> Ctrl+d
15.
Font size à Ctrl+[ ]
16.
Print à Ctrl+p
17.
New à Ctrl+n
18.
Open à Ctrl+ o
19.
Select allà Ctrl+a
20.
Change caseàchange case
21.
Find à Ctrl+f
22.
Find and replaceà Ctrl+g
23.
Hyperlinkà Ctrl+k
24.
Break àAlt+enter
25.
closeàAlt+F4
26.
closeàCtrl+F4
27.
print previewà Ctrl+F2
Extension Name
|
Stand for
|
.BMP
|
Bitmap
|
.CUR
|
Cursor
|
.GIF
|
Graphics Interchange format
|
.ICO
|
Icon
|
.JPEG
|
Joint photographic expert group
|
.WMF / emf
|
Window / enhanced meta
|
.RLE
|
Run length encoded
|
Microsoft excel
MS
excel is a workbook which contains the worksheet, and worksheet contains rows
and column
Workbook
¯
Worksheet / sheet /
spreadsheet
¯
Rows & column
¯
Cell
Use of ms excel
1. Tables
2. Calculation
3. Recalculation
4. Database
5. Charts
How to start ms
excel
Start
¯
Programs
¯
Microsoft office
¯
Microsoft excel
Start
¯
Runàexcel
¯
Ok
Merge and center
This option is sued to merge rows and
columns
Select rows or columns
¯
Click on merge and center
Wrap text
This option is used to display multiple line of text within a cell
Select cell
¯
Format
¯
Cells
¯
Alignment
¯
Wrap text
¯
Ok
Vertical
Using this option you can set text into top, center,
and bottom position
Select cell
¯
Format
¯
Cells
¯
Alignment
¯
Vertical àtop / center / bottom
¯
Ok
Degrees
This option is used to rotate any text
in various degrees.
Select cell
¯
Format
¯
Cells
¯
Alignment
¯
Degreeà90….
¯
Ok
Sort ascending
& sort descending
This option is used to arrange any list
in order
Select table
¯
Click on sort ascending
& sort descending
Custom list
This option is used to store any type of
list.
Tools
¯
Options
¯
Custom list
¯
New list
¯
Typeà cd,dvd,tv,computer,mobile,camera
¯
Add
¯
Ok
How to delete custom list
Tools
¯
Options
¯
Custom list
¯
Select list
¯
Typeà cd,dvd,tv,computer,mobile,camera
¯
Delete
¯
Ok
¯
Ok
Filter
This option is used to see selected data
Select table
¯
Data
¯
Filter
¯
Auto filter
How to remove filter
Select table
¯
Data
¯
Filter
¯
Auto filter
How to insert new
sheet
Right click on sheet
¯
Insert
¯
Worksheet
¯
Ok
How to rename
sheet
Right click on sheet
¯
Rename
¯
Type àdeep
How
to delete sheet
Right click on sheet
¯
Delete
¯
Ok
Chart
Option is used to graphical
representation of data.
Types of charts
v Column chart
v Bar chart
v Line chart
v Pie chart
Column chart
Select table
¯
Insert
¯
Chart
¯
Column
¯
Next
¯
Next
¯
Chart titleà……….
X axisà…….
Y axisà……..
¯
Next
¯
Finish
Bar chart
Select table
¯
Insert
¯
Chart
¯
Bar
¯
Next
¯
Next
¯
Chart titleà……….
X axisà…….
Y axisà……..
¯
Next
¯
Finish
Line chart
Select table
¯
Insert
¯
Chart
¯
line
¯
Next
¯
Next
¯
Chart titleà……….
X axisà…….
Y axisà……..
¯
Next
¯
Finish
Pie chart
Select table
¯
Insert
¯
Chart
¯
pie
¯
Next
¯
Next
¯
Chart titleà……….
¯
Next
¯
Finish
Page setup
File
¯
Page setup
¯
Page
¯
Orientationàportrait / landscape
¯
Paper sizeàA4
¯
Ok
Header & footer
File
¯
Page setup
¯
Header and footer
¯
Custom headeràshobhna
¯
0Footeràpage1
¯
Ok
Microsoft PowerPoint
MS
PowerPoint is application software it is used to create presentation
How to start PowerPoint
Start
¯
Programs
¯
Microsoft office
¯
Microsoft PowerPoint
Start
¯
Runàpowerpnt
¯
Ok
How to insert new slide
Insert
¯
New slide
¯
Choose any One
¯
How to show slide
View
¯
Slide show F5
How to change background design
Format
¯
Slide Design
¯
Choose any one
How to set animation on slide
Choose slide
¯
Select text / picture
¯
Slide show
¯
Custom animation
¯
Add effect
¯
Choose any one
¯
Ok
How to set automatically slide show
Slide show
¯
Slide transition
¯
Automatically afterà00:01
¯
Apply to all slides
¯
F5
This comment has been removed by the author.
ReplyDelete