5th STD Computer Book Final Aligned
5th STD Computer Book Final Aligned
N
Title of Lesson Page no
o
1. Introduction to Computers 2
3. Spreadsheet 16
4. Presentation 27
6. Computer Security 40
7 E-mail 44
1
1. Introduction to Computers
We will learn in this lesson
After studying this lesson, you will be able to:
Today computers have changed our lifestyle. They are being used
everywhere. Whatever happens anywhere, we come to know about
it immediately. People are getting employed due to computer skills.
Education in schools is given with the help of computers. Computers
are being used in hospitals for recording the details of the patients.
There are new techniques for farming and agriculture.
2
1.1 Creating, Saving and Opening File in Word
Processor (MS-WORD)
3
Saving a Document
II Method:
Press Ctrl+S after typing the text Save As window will open. Click on
Desktop option and then type the file name as ‘India is My Country’
then click the save button. Your document gets saved by the
given name.
4
We can open the saved document in future and work on it again.
Deleting a File
5
Method 1: We, will see our file (India is my country) on the desktop.
Right click on this file and select delete from the given options.
Delete dialog box will appear, click on Yes.
Method 2: Click on the File icon and press delete key. Delete dialog
box will appear for your confirmation. We can press Yes to delete the
file. If you are not sure to delete it, you can click on ‘No’ option
6
2.Word Processing: Advantage and Features
We will learn in this lesson
After studying this lesson, you will be able to:
• type in Hindi.
7
2. Now click insert tab
3.You will see illustration group (fig. 2.5 b), click on picture option
(fig. 2.5 c).
8
4. Now click on desktop option. A list of present files will appear
and select flower.jpg file (2.5 d) and click insert.
To arrange the picture properly in the document click on it, you will
find small square on the corners (fig. 2.5 e). Using the mouse we can
increase the size of the picture by dragging outside and decrease by
taking it inside.
In this picture we have corners to resize the image as per our desire.
Typing in Hindi
We can use our computer to write in any language. This has made it
easy for people to learn computer. Many people in villages, towns
and cities are learning to work on computers and earn their living
through it.
9
Size and style of words is called font. There are many types of fonts.
We can type in different languages like Hindi, Punjabi, Sanskrit &
Urdu etc. with the help of font.
After creating a new document press Ctrl key with one hand and D
with other; font dialog box will open, now select Shusha for typing in
Hindi and click OK. We will see Shusha written in place of Calibri in
our document.
If we type Mera naam ram hai: It will appear as (see fig. below)
10
With a little practice we can learn to type in Hindi or any other
language very easily.
Mail Merge
Suppose it is your birthday and you want to invite your friends and
relatives. The letter that you want to send to all is the information
and the address of friends & relatives is the data. Let us see how it is
done –
11
4. Now a database window will open
12
5. Click customize columns and add the fields which we require
and delete the unnecessary fields. See fig. here we have kept
first name, last name, Address - 1 field and removed rest of the
fields. (fig. 2.8 (f)
13
6.Press OK. Now save the data table in My Document folder by the
name of guest list (fig. 2.8(g) )
7. Now you will reach the word window. (Fig. 2.8 (h)).
8. Click insert Merge field tab and click the field name you want to
insert at the desired place. (fig. 2.8 (h)).
14
Closing Ms-Word
15
3.Spreadsheet
We will learn in this lesson
• make corrections in spreadsheet.
Editing
16
Delete or backspace key. And there after type the new data and
finally press the Enter key. It is necessary to press the Enter key
after making corrections. It is required just as we need to put a
full stop after writing a sentence in English.
Writing a Formula
Once we press the Enter key we will find the sum (in our
case it will be 9) in the cell D1 but when we look at the
formula bar, we will find the formula i.e. “=A1+B1” written
there.
17
To subtract two numbers we will use minus (-) operator, to
multiply two numbers the multiplication operator (*) is used
whereas to divide a slash (/) be used.
Copying a Formula
18
Cell Formatting
19
3. Placing the data towards left, right or center. This process of
placing the data towards the left margin, right margin or in center is
known as alignment.
1. Right click the cell which you want to format and click “Format
Cells” option.
2. “Format Cells” dialog box will open. Now click on Font tab.
Change font colour, size or type according to your liking and
then click O.K.
20
Now this cell will look different from the rest of the cells. We can
apply formatting to multiple cells by selecting them. We will press
and hold the shift key and drag the mouse till the desired cell for
example H15. All cells from A1 to H15 will be selected. Now apply
desired font colour, size and style.
Alignment
1. Select the cell or range of cells and right click on them. Select
format cells option. Format cells dialog box appears, click on
Alignment tab.
2. In horizontal group click down arrow next to general.
3. Now click on center. Now we will see all the numbers and text
appears in center. Steps for alignment.
Border
21
1. Select cell A1 to C3 now right click.
22
Background Colour
1. Select cell range and right click to select format cells option.
23
Saving a file
(iv) Click Ok. Our file will be saved with the given name in My
Documents folder.
Printing a file
To print a file we have to open the file and check if it is ready to print
& is error free.
24
Creating a New File
25
1. Click office button
2. Click on Open
4. Click on Open.
4. Presentation
26
We will learn in this lesson
• show how to make a presentation in PowerPoint;
• format a presentation.
Now we will click on save button and our presentation will be saved
by the name’ Mathematics’.
27
After saving the presentation, we can continue to work on the blank
slides. If we do not want to work then we would close the
presentation by clicking on Microsoft Office Button and selecting
close menu from the scroll down list.
Inserting Slide
We are seeing the complete slide presentation and its small form on
the left side with sequence numbers 1, 2.
Now we will insert a new slide between first and second slide of our
presentation.
We will click on the first slide from the slide tab. We will see the first
slide on the main screen. After clicking on home tab, then on new
slide, a new slide will be inserted between first and second slide.
28
In this slide, we will write ‘Sender’ then our name. We will write’
National Institute of Schooling’ in the bottom.
When we click on second slide and we will see the big rectangle in
second slide.
Now click on the insert tab of ribbon. Now click on the picture button
and a new window will be opened. Now click library button, then
picture button and we see sample pictures button. On clicking it we
see something like fig. 5. This will show all the pictures which are
stored in our computer.
29
We can insert chart in the same way.
Text Formatting
We will select the word ‘uses’. Then we will click on the home tab.
We can change the font size, under lining, Italic, Bold etc.
After selecting ‘uses’ font size is selected 60 and italics and underline
button we will see changes as shown in Figure (Picture 7).
30
Presentation of Slides-Slide Show
31
There is “Advance Slide” button to the right of Transaction to this
slide group. The first option is On Mouse click. If this option is clicked
(Ö) then, the slides will move only after clicking the mouse. This is
what we need this. We will know about other methods later on. We
will see a tick mark by clicking on this option, (Ö) which can be
removed by clicking it again. Now we will present presentation. For
this we will click on slide show tab
Now, we will click on Start Slide Show and in the given options we
will click on From Beginning and thus our presentation will start
We will see that only first slide is seen on monitor’s screen. There is
nothing else on the screen. The whole screen is covered by first slide.
32
the screen. There is nothing wrong in it. When we click mouse, we
will move on next slide. It is because we had selected the option of
Mouse Click for slide show of our presentation.
In the same way we will move on the next side. When we mouse
click on the last slide, the presentation ends. We will see a black
screen there. Now click ‘Escape’ from keyboard to see the
PowerPoint screen back on the computer screen.
If we press escape key after any slide, the presentation will end at
that time. For this, we will open presentation and click on first
animations tab from ribbon.
Now click on second option in advance slide and click on option two
put 00:05 on the right side. This means that the computer will
automatically move on the next slide after 5 slides. We can add 10 on
place of 05 if we desire.
33
Now we will click on Apply To All option. This will set the time of 5
second to all the slides.
34
5.Internet and its Advantages
We will learn in this lesson
Connect to Internet?
Know world wide web, website and web page.
Open different websites, search information and read
newspaper.
35
Connecting to Internet using Data Card
Many people confuse internet with web but actually they are
different
36
browser connects computer with World Wide Web. Some of the
common examples of web browser are: internet explorer, Google
chrome, Mozilla, Firefox, opera and safari etc.
Web page - It is a page full of information which is seen with the help
of web browser. This is an electronic page on web which has content,
picture and sound etc. We can easily navigate from one web page to
another.
Search Engine
Some of the main search engines are, rediff, yahoo, google, etc.
37
As we have learnt earlier that we need web browser program to
connect to world wide web of internet. Internet explorer is also a
popular web browser. We will follow the following steps to open a
website:
3. Take your pointer to all programs and see the list of all
programs and select internet explorer.
38
5. Type the address of website which you want to open in the blank
box on the screen. Type website address. If you want to see the
website of National Institute of Open Schooling (NIOS); type
www.nios.com.
6. Now press enter or go button; now you will see the website of
NIOS. We can see other websites in the same manner.
We can read any news paper easily on internet. We will follow the
following steps in this regard.
39
6.Computer Security
Computer Virus
Some virus destroys the data from our file. They delete some files.
This further stops us from doing work on another computer.
40
them on our behalf. Thus, the computers of our contacts also get
infected.
Some virus asks for password through mails. They have the excuse
that we have been a victim of a cyber attack. Internet explorer has
such systems to block them and follow the security code. Internet
service providers also save us from virus infected mails. Internet
service providers check the email id of the sender. If it finds
something suspicious like virus or phishing then it keeps it in junk or
spam folder. We should open such mails when we are fully satisfied.
Internet has changed our life. The danger has been widened with the
techniques of network and increased use of computer by persons
and in businesses. Virus attacks can completely damage the
computer. This includes destroying the files, crashing of hard disk,
damaging operating system etc. Virus attack destroys the secrecy of
the system. This also uses our computer as a weapon against another
computer. Now we will see what other kinds of attack are there.
1. We have a fear that our secret information like log on information
file, data etc can get lost and it damages our file and data. Therefore,
we should keep our password powerful and secure. You have learnt
about this earlier in this chapter.
41
2. We have learnt about virus before virus can come into our
computer by internet. To save our computer from internet virus, we
should use firewall and antivirus software. We should think twice
before opening an email from unknown person. If our known person
sends a suspicious mail, we should not open it. Our known person
should be asked if he had sent that mail or not.
4. In this way, they control the function of computer and send e-mail
from our side. It also sends information to other computers many
times. By getting or taking over functions of many computers they
can hijack network and websites. This is known as Denial of services.
5. Some mails take us to the website and give us perks like showing
attractive pictures. Sometimes they tell us that there are errors in
your bank account which are to be answered on websites. They take
us to fake websites which ask secret information like password.
These passwords are misused. These attacks are known as phishing.
42
4. We should not visit bank and other important website through
unsafe sites or e-mail.
5. Do not keep one password for all sites. Make different passwords
for websites.
6. We should always keep firewall on. We should follow the rules of
firewall.
7. We should use authentic antivirus software which should be
updated from time to time.
43
7.E-mail
We will learn in the lesson
After studying this lesson, you will be able to:
Benefits of e-mail
E-mail Account
To send an e-mail, you should have your own e-mail account. There
are many websites on internet where you can create a free e-nail
account. You need not to pay anything for your e-mail account.
There sites are:
www.yahoo.com
www.gmail.com
www.hotmail.com
www.rediffmail.com
44
We can make our e-mail account on any site. However, it should be
noted that we should work regularly to keep our account working
otherwise our e-mail account could be cancelled or deactivated after
some time.
Here you will see a new page which will look like a registration
form
You have to fill your name, user id, password, date of birth,
phone number etc in the form
45
If your user id is accepted by hotmail, then you will see a new
page with your name and user id.
After that you can open your e-mail inbox and send new mail.
This helps you to know that your registration on hotmail.com has
been successfully done.
To make an e-mail message, we will click on the new button (see fig.
7.6). After clicking the button, we will see a blank form.
To: here, we will type e-mail address f the sender. You can write the
name of many persons together. The e-mail messages typed here
will receive the message.
46
Cc: we will type that e-mail address to which we want to send the
copy of e-mail. Cc means carbon copy. We can write the names of
more than one person separated by coma (,).
Then a blank space is seen here where we can type the message. This
is known as body of e-mail.
After preparing the message, we will press end button. Then our e-
mail will be sent to desired address.
Address Book
Address book saves all the e-mail address with a star. Thus, we need
not type the e-mail address again and again. If we want to select a
particular e-mail address, it is automatic form in e-mail id.
We can add new address or delete old address from address book.
You can also find search contact button at the bottom of the screen.
File Attachment
Any file that is stored on computer can be sent through e-mail. It can
be text, photo, picture, video etc. this is known as file attachment,
You have already read about file earlier. Suppose we want to get an
admission of our daughter in a school. Then we can send thus
application to the school principal as a file attachment to e-mail
address. The whole process is shown below
47
E-mail address of principal:
principalsunbeamschool@hotmail.com.
See where application file is saved. See the name
application.doc. The extension name of the word file is .doc.
When we open e-mail window, we will first type the e-mail
address of the principal.
We can leave Cc blank because we need not send carbon copy
to anybody else.
We can write 'application for admission' as subject.
We will type the following message in the body of the e-mail:
Dear Sir,
I am attaching all the information relating to admission of my
daughter. Kindly do the needful.
Thank You
We will type this message in English
48
the file by searching the folder where it is stored. The file is now
attached. Now click the send button.
We can give reply to the mail like the same way we reply to a letter
received by us. E-mail gives us facility that we cab reply to the mail
instantly or save it or reply later on.
To reply, we should click reply button
49
We need not type e-mail address again, it comes automatically in the
mail. We will find Re in the subject which stands for reply. We can
type our reply and send it.
Printing an e-mail
We can click on printer button to print our e-mail message. This is
known as hard copy. The file kept in computer is known as soft copy.
50