6 months module of Basic computer training
58,632 views
53 slides
Jun 07, 2013
Slide 1 of 53
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
About This Presentation
No description available for this slideshow.
Slide Content
Shailendra Tewari
SNS FOUNDATION
GURGAON
COMPUTER PRACTICE SET
FOR
SNS FOUNDATION
GURGAON
COMPUTER PRACTICE SET
FOR
Practice Set SNS Foundation Page 2
SNS Foundation has been endorsed by ANAND Automotive system on
19
th
May 1976 for development of community, especially to all regions
where ANAND Group of companies has their manufacturing unit.
There are so many key areas are where development needs in India. SNS
Foundation selected some areas like Livelihoods, Health, Education and
Rural development and the environment.
Under Livelihoods, Foundation mostly focused on Vocational Training to
the youth in different courses like Computer Training
(Basic/Diploma/Tally/DTP), Beauty Culture, Mehendy Art, Nail Art,
Cutting Tailoring, Dress Designing, Fashion Designing, Nusury/Primary
Teacher Training, Spoken English, Soft Toy Making, Jewallery Making,
Automobile 2-Wheeler Technician and Electrician.
There are so many Computer books are available in the market for
developing their computer knowledge. But as far as SNS Foundation is
concerned, computer knowledge can be enhanced by good practice on the
computer.
Now a days youths are looking for short term computer courses and want
jobs in computer space, youth need proper practice based on skill required
for work places. So, to cater all the needs and to create awareness about
computers and how it is changing the world in a big way, we have designed
a weekly practice set named as ―Module for basic computer classes‖
This book is divided into 24 weekly practice set of six months basic
computer course. Book covers Typing, Notepad, Wordpad, Ms-Paint, Ms-
Office 2007 (Word, Excel, PowerPoint), Ms-Access, HTML, MS-DOS and
Internet with its applications.
PERFACE
SNS Foundation has been endorsed by ANAND Automotive system on
19
th
May 1976 for development of community, especially to all regions
where ANAND Group of companies has their manufacturing unit.
There are so many key areas are where development needs in India. SNS
Foundation selected some areas like Livelihoods, Health, Education and
Rural development and the environment.
Under Livelihoods, Foundation mostly focused on Vocational Training to
the youth in different courses like Computer Training
(Basic/Diploma/Tally/DTP), Beauty Culture, Mehendy Art, Nail Art,
Cutting Tailoring, Dress Designing, Fashion Designing, Nusury/Primary
Teacher Training, Spoken English, Soft Toy Making, Jewallery Making,
Automobile 2-Wheeler Technician and Electrician.
There are so many Computer books are available in the market for
developing their computer knowledge. But as far as SNS Foundation is
concerned, computer knowledge can be enhanced by good practice on the
computer.
Now a days youths are looking for short term computer courses and want
jobs in computer space, youth need proper practice based on skill required
for work places. So, to cater all the needs and to create awareness about
computers and how it is changing the world in a big way, we have designed
a weekly practice set named as ―Module for basic computer classes‖
This book is divided into 24 weekly practice set of six months basic
computer course. Book covers Typing, Notepad, Wordpad, Ms-Paint, Ms-
Office 2007 (Word, Excel, PowerPoint), Ms-Access, HTML, MS-DOS and
Internet with its applications.
PERFACE
Practice Set SNS Foundation Page 3
Sr. No Week No Topic Page No
1 I Typing………………………….......................................... 4
2 II Word Pad……………………………………………………………… 5
3 III Note Pad………………………………………………………………. 7
4 IV Ms-Paint………………………………………………………………. 8
5 V Ms-Word 2007……………………………………………………… 9
6 VI Ms-Word 2007……………………………………………………… 10
7 VII Ms-Word 2007……………………………………………………… 12
8 VIII Ms-Word 2007……………………………………………………… 13
9 IX Ms-Word 2007……………………………………………………… 15
10 X Ms-Excel 2007………………………………………………………. 16
11 XI Ms-Excel 2007………………………………………………………. 18
12 XII Ms-Excel 2007………………………………………………………. 24
13 XIII Ms-Excel 2007………………………………………………………. 26
14 XIV Ms-Excel 2007………………………………………………………. 32
15 XV Ms-PowerPoint 2007……………………………………………. 33
16 XVI Ms-PowerPoint 2007……………………………………………. 36
17 XVII Ms-PowerPoint 2007………………………………………….... 39
18 XVIII Ms-Access 2007……………………………………………………. 42
19 XIX Ms-Access 2007……………………………………………………. 43
20 XX Ms-Access 2007……………………………………………………. 44
21 XXI Virus and its Application………………………………………. 45
22 XXII HTML……………………………………………………………………. 46
23 XXIII MS-DOS………………………………………………………………… 47
24 XXIV Internet and its Applications…………………………………. 48
Table of Contents
Sr. No Week No Topic Page No
1 I Typing………………………….......................................... 4
2 II Word Pad……………………………………………………………… 5
3 III Note Pad………………………………………………………………. 7
4 IV Ms-Paint………………………………………………………………. 8
5 V Ms-Word 2007……………………………………………………… 9
6 VI Ms-Word 2007……………………………………………………… 10
7 VII Ms-Word 2007……………………………………………………… 12
8 VIII Ms-Word 2007……………………………………………………… 13
9 IX Ms-Word 2007……………………………………………………… 15
10 X Ms-Excel 2007………………………………………………………. 16
11 XI Ms-Excel 2007………………………………………………………. 18
12 XII Ms-Excel 2007………………………………………………………. 24
13 XIII Ms-Excel 2007………………………………………………………. 26
14 XIV Ms-Excel 2007………………………………………………………. 32
15 XV Ms-PowerPoint 2007……………………………………………. 33
16 XVI Ms-PowerPoint 2007……………………………………………. 36
17 XVII Ms-PowerPoint 2007………………………………………….... 39
18 XVIII Ms-Access 2007……………………………………………………. 42
19 XIX Ms-Access 2007……………………………………………………. 43
20 XX Ms-Access 2007……………………………………………………. 44
21 XXI Virus and its Application………………………………………. 45
22 XXII HTML……………………………………………………………………. 46
23 XXIII MS-DOS………………………………………………………………… 47
24 XXIV Internet and its Applications…………………………………. 48
Table of Contents
Practice Set SNS Foundation Page 4
Topic: - Typing Tutor
Week-I
Please write the paragraph in 10 minutes without looking at the
keyboard.
What exactly is a computer? What we see on a computer monitor are
flashing lights and full color graphics. It is easy for students to be
mystified by computers. This module introduces students to the basic
concept of a computer as a device that implements functions. It uses
simple analogies to explain how the same computer program can be
implemented in wildly different kinds of material. The second
component of the module begins with a discussion of the classical
digital computer – the only kind of computer that most of us have ever
worked with. It lays out the prominent features of digital computers
(digital, serial, local, and deterministic) and provides a flash animation
that gives a dynamic analogy to help drive home the main concepts.
The discussion then turns to non-classical computers, computers that
lack all or most of the essential features of digital computers and have
instead some or all of the following properties: analog, parallel,
distributed, non-deterministic. Some strengths and weaknesses of the
two different types of computer are briefly mentioned. [This
component does not currently include a discussion of the dynamical
systems model of mental processing. We intend [eventually!] to add a
discussion of this ―third‖ model – including a discussion of those who
argue that dynamical systems are not computers at all. If you are
interested in contributing to curriculum modules on dynamical
systems, please contact David Anderson.
Topic: - Typing Tutor
Week-I
Please write the paragraph in 10 minutes without looking at the
keyboard.
What exactly is a computer? What we see on a computer monitor are
flashing lights and full color graphics. It is easy for students to be
mystified by computers. This module introduces students to the basic
concept of a computer as a device that implements functions. It uses
simple analogies to explain how the same computer program can be
implemented in wildly different kinds of material. The second
component of the module begins with a discussion of the classical
digital computer – the only kind of computer that most of us have ever
worked with. It lays out the prominent features of digital computers
(digital, serial, local, and deterministic) and provides a flash animation
that gives a dynamic analogy to help drive home the main concepts.
The discussion then turns to non-classical computers, computers that
lack all or most of the essential features of digital computers and have
instead some or all of the following properties: analog, parallel,
distributed, non-deterministic. Some strengths and weaknesses of the
two different types of computer are briefly mentioned. [This
component does not currently include a discussion of the dynamical
systems model of mental processing. We intend [eventually!] to add a
discussion of this ―third‖ model – including a discussion of those who
argue that dynamical systems are not computers at all. If you are
interested in contributing to curriculum modules on dynamical
systems, please contact David Anderson.
Practice Set SNS Foundation Page 5
Topic: - Notepad
Week-II
Usage of mouse is prohibited during this practice test. Teachers are requested to
remove the mouse from the computer during the practice session.
Q1. Open your notepad and type the paragraph in 10 minutes without
looking to your keypad. (Font type – Times New Roman, Font Size – 12,
with Justified Alignment).
Mohandas Karamchand – known as Mahatma or "Great-Souled" – Gandhi
was born in Porbandar, the capital of a small principality in what is today
the state of Gujarat in Western India, where his father was prime minister.
His mother was a profoundly religious Hindu. She and the rest of the
Gandhi family belonged to a branch of Hinduism in which non-violence
and tolerance between religious groups were considered very important.
His family background has later been seen as a very important explanation
of why Mohandas Gandhi was able to achieve the position he held in
Indian society. In the second half of the 1880s, Mohandas went to London
where he studied law. After having finished his studies, he first went back
to India to work as a barrister, and then, in 1893, to Natal in South Africa,
where he was employed by an Indian trading company.
In South Africa Gandhi worked to improve living conditions for the Indian
minority. This work, which was especially directed against increasingly
racist legislation, made him develop a strong Indian and religious
commitment, and a will to self-sacrifice. With a great deal of success he
introduced a method of non-violence in the Indian struggle for basic human
rights. The method, satyagraha – "truth force" – was highly idealistic;
without rejecting the rule of law as a principle, the Indians should break
those laws which were unreasonable or suppressed. Each individual would
have to accept punishment for having violated the law. However, he
should, calmly, yet with determination, reject the legitimacy of the law in
question. This would, hopefully, make the adversaries – first the South
African authorities, later the British in India – recognize the unlawfulness
of their legislation.
Topic: - Notepad
Week-II
Usage of mouse is prohibited during this practice test. Teachers are requested to
remove the mouse from the computer during the practice session.
Q1. Open your notepad and type the paragraph in 10 minutes without
looking to your keypad. (Font type – Times New Roman, Font Size – 12,
with Justified Alignment).
Mohandas Karamchand – known as Mahatma or "Great-Souled" – Gandhi
was born in Porbandar, the capital of a small principality in what is today
the state of Gujarat in Western India, where his father was prime minister.
His mother was a profoundly religious Hindu. She and the rest of the
Gandhi family belonged to a branch of Hinduism in which non-violence
and tolerance between religious groups were considered very important.
His family background has later been seen as a very important explanation
of why Mohandas Gandhi was able to achieve the position he held in
Indian society. In the second half of the 1880s, Mohandas went to London
where he studied law. After having finished his studies, he first went back
to India to work as a barrister, and then, in 1893, to Natal in South Africa,
where he was employed by an Indian trading company.
In South Africa Gandhi worked to improve living conditions for the Indian
minority. This work, which was especially directed against increasingly
racist legislation, made him develop a strong Indian and religious
commitment, and a will to self-sacrifice. With a great deal of success he
introduced a method of non-violence in the Indian struggle for basic human
rights. The method, satyagraha – "truth force" – was highly idealistic;
without rejecting the rule of law as a principle, the Indians should break
those laws which were unreasonable or suppressed. Each individual would
have to accept punishment for having violated the law. However, he
should, calmly, yet with determination, reject the legitimacy of the law in
question. This would, hopefully, make the adversaries – first the South
African authorities, later the British in India – recognize the unlawfulness
of their legislation.
Practice Set SNS Foundation Page 6
When Gandhi came back to India in 1915, news of his achievements in
South Africa had already spread to his home country. In only a few years,
during the First World War, he became a leading figure in the Indian
National Congress. Through the interwar period he initiated a series of non-
violent campaigns against the British authorities. At the same time he made
strong efforts to unite the Indian Hindus, Muslims and Christians, and
struggled for the emancipation of the 'untouchables' in Hindu society.
While many of his fellow Indian nationalists preferred the use of non-
violent methods against the British primarily for tactical reasons, Gandhi's
non-violence was a matter of principle. His firmness on that point made
people respect him regardless of their attitude towards Indian nationalism
or religion. Even the British judges who sentenced him to imprisonment
recognized Gandhi as an exceptional personality.
Q2. Find how many times ‘Mohandas’ is written in these
paragraphs and also define its process?
Q3. Please Copy and paste the given below sentence 5 times and also
give them number bullets?
‘This would, hopefully, make the adversaries – first the South
African authorities, later the British in India – recognize the
unlawfulness of their legislation’
Q4. Replace ‘rule’ with ‘truth’ in the above paragraph?
Q5. Save the file by your name and enrollment number?
When Gandhi came back to India in 1915, news of his achievements in
South Africa had already spread to his home country. In only a few years,
during the First World War, he became a leading figure in the Indian
National Congress. Through the interwar period he initiated a series of non-
violent campaigns against the British authorities. At the same time he made
strong efforts to unite the Indian Hindus, Muslims and Christians, and
struggled for the emancipation of the 'untouchables' in Hindu society.
While many of his fellow Indian nationalists preferred the use of non-
violent methods against the British primarily for tactical reasons, Gandhi's
non-violence was a matter of principle. His firmness on that point made
people respect him regardless of their attitude towards Indian nationalism
or religion. Even the British judges who sentenced him to imprisonment
recognized Gandhi as an exceptional personality.
Q2. Find how many times ‘Mohandas’ is written in these
paragraphs and also define its process?
Q3. Please Copy and paste the given below sentence 5 times and also
give them number bullets?
‘This would, hopefully, make the adversaries – first the South
African authorities, later the British in India – recognize the
unlawfulness of their legislation’
Q4. Replace ‘rule’ with ‘truth’ in the above paragraph?
Q5. Save the file by your name and enrollment number?
Practice Set SNS Foundation Page 7
Topic: - WordPad
Week-III
Q1 Open your word pad and write the paragraph in 10 minutes with blue color
and Italic Style (Font type – Calibry, Font Size 12)
Lato is a sanserif typeface family designed in the Summer 2010 by
Warsaw-based designer Łukasz Dziedzic (―Lato‖ means ―Summer‖ in
Polish). In December 2010 the Lato family was published under the open-
source Open Font License by his foundry tyPoland, with support from
Google.
In the last ten or so years, during which Łukasz has been designing type,
most of his projects were rooted in a particular design task that he needed
to solve.
When working on Lato, Łukasz tried to carefully balance some potentially
conflicting priorities. He wanted to create a typeface that would seem quite
―transparent‖ when used in the body text but would display some original
traits when used in larger sizes. He used classical proportions (particularly
visible in the uppercase) to give the letterforms familiar harmony and
elegance. At the same time, he created a sleek sanserif look, which makes
evident the fact that Lawton was designed in 2010 — even though it does
not follow any current trend.
The semi-rounded details of the letters give Lato a feeling of warmth, while
the strong structure provides stability and seriousness. ―Male and female,
serious but friendly. With the feeling of the summer,‖ says Łukasz. Lato
consists of five weights (plus corresponding italics), including a beautiful
hairline style.
Q3. Insert Page Number.
Q4. Give heading ‗Google‘ to the paragraph by Using header, and write
your name on the footer in center alignment with an underline.
Topic: - WordPad
Week-III
Q1 Open your word pad and write the paragraph in 10 minutes with blue color
and Italic Style (Font type – Calibry, Font Size 12)
Lato is a sanserif typeface family designed in the Summer 2010 by
Warsaw-based designer Łukasz Dziedzic (―Lato‖ means ―Summer‖ in
Polish). In December 2010 the Lato family was published under the open-
source Open Font License by his foundry tyPoland, with support from
Google.
In the last ten or so years, during which Łukasz has been designing type,
most of his projects were rooted in a particular design task that he needed
to solve.
When working on Lato, Łukasz tried to carefully balance some potentially
conflicting priorities. He wanted to create a typeface that would seem quite
―transparent‖ when used in the body text but would display some original
traits when used in larger sizes. He used classical proportions (particularly
visible in the uppercase) to give the letterforms familiar harmony and
elegance. At the same time, he created a sleek sanserif look, which makes
evident the fact that Lawton was designed in 2010 — even though it does
not follow any current trend.
The semi-rounded details of the letters give Lato a feeling of warmth, while
the strong structure provides stability and seriousness. ―Male and female,
serious but friendly. With the feeling of the summer,‖ says Łukasz. Lato
consists of five weights (plus corresponding italics), including a beautiful
hairline style.
Q3. Insert Page Number.
Q4. Give heading ‗Google‘ to the paragraph by Using header, and write
your name on the footer in center alignment with an underline.
Practice Set SNS Foundation Page 8
Topic: - Ms-Paint
Week-IV
Q1. Insert a picture in Ms-Paint and do formatting (insert Text at top left
corner), create a rectangle box, circle and fill yellow color and type your name in
the centre of box.
Q2. Draw a Flag in Ms-Paint.
Topic: - Ms-Paint
Week-IV
Q1. Insert a picture in Ms-Paint and do formatting (insert Text at top left
corner), create a rectangle box, circle and fill yellow color and type your name in
the centre of box.
Q2. Draw a Flag in Ms-Paint.
Practice Set SNS Foundation Page 9
Topic: - Ms-Word
Week-V
Q1. Open blank Ms-Word file and type below given paragraph using Font- Times
New Roman, Font Size-12 and Font Color- Blue.
HYDERABAD: At least 100 teachers at Osmania University (OU) resigned from their
administrative posts a day after a student slapped a mass communication and
journalism professor over a PhD admission row and roughed up more teachers on
Tuesday, the latest in a series of unrest hitting the roiled campus.
The OU administration lodged a police complaint bowing to criticism from the
faculty, who had decided to take out a rally. Minutes later, the OU police station
received a counter complaint from a student alleging discrimination on backward
caste students by the professor.
Name of H2SO4 is sulfuric acid and 10
2
=100Science and Math
Name of states of India:
Delhi
Haryana
Punjab
Rajasthan
The OU administration has been drawing flak over the ongoing PhD admissions as
allegations of senior officials influencing the admission process in favor of certain
students surfaced in the recent past.
Q2. Give heading of paragraph ‘Osmania University news’ with Font Name-Times
New Roman and Font Size-15, Bold and Italic in the center by using of Mouse.
Q3. Save this file with your name at Desktop without using the mouse.
Q4. Save As this file with name ‘Rahul’ at the desktop, close and exit without using
the mouse.
Q5. Copy the second paragraph and paste three times in the last of the page.
Topic: - Ms-Word
Week-V
Q1. Open blank Ms-Word file and type below given paragraph using Font- Times
New Roman, Font Size-12 and Font Color- Blue.
HYDERABAD: At least 100 teachers at Osmania University (OU) resigned from their
administrative posts a day after a student slapped a mass communication and
journalism professor over a PhD admission row and roughed up more teachers on
Tuesday, the latest in a series of unrest hitting the roiled campus.
The OU administration lodged a police complaint bowing to criticism from the
faculty, who had decided to take out a rally. Minutes later, the OU police station
received a counter complaint from a student alleging discrimination on backward
caste students by the professor.
Name of H2SO4 is sulfuric acid and 10
2
=100Science and Math
Name of states of India:
Delhi
Haryana
Punjab
Rajasthan
The OU administration has been drawing flak over the ongoing PhD admissions as
allegations of senior officials influencing the admission process in favor of certain
students surfaced in the recent past.
Q2. Give heading of paragraph ‘Osmania University news’ with Font Name-Times
New Roman and Font Size-15, Bold and Italic in the center by using of Mouse.
Q3. Save this file with your name at Desktop without using the mouse.
Q4. Save As this file with name ‘Rahul’ at the desktop, close and exit without using
the mouse.
Q5. Copy the second paragraph and paste three times in the last of the page.
Practice Set SNS Foundation Page 10
Topic: - Ms-Word
Week-VI
Q1. Insert a table in your file as given below:
Family Details Table
S.No Relationship Age Employed/
unemployed/Student
Income
1 Ramesh Kumar 60 Unemployed 0
2 Savitri Devi 55 Unemployed 0
3 Shanker 25 Employed 6000
4 Naresh 22 Student 0
5 Sapna 8 Student 0
6
Q.2 Insert a word art as given below:
Q.3 Insert given shapes as given:
CUP
Topic: - Ms-Word
Week-VI
Q1. Insert a table in your file as given below:
Family Details Table
S.No Relationship Age Employed/
unemployed/Student
Income
1 Ramesh Kumar 60 Unemployed 0
2 Savitri Devi 55 Unemployed 0
3 Shanker 25 Employed 6000
4 Naresh 22 Student 0
5 Sapna 8 Student 0
6
Q.2 Insert a word art as given below:
Q.3 Insert given shapes as given:
CUP
Practice Set SNS Foundation Page 11
Q4. Write the paragraph is given style.
Actor wishes merry Christmas
he best thing about Christmas is
waking up in the morning and
exchanging gifts and goodies!
Although we have grown
up and stopped believing
in Santa, the present
exchanging never fails to
excite me! I am really
looking forward to Christmas this year
as I have a huge surprise gift planned
for my family and I'm sure that they
are going to be overjoyed when they
receive it.
It's Christmas time and the entire
world is gearing up to celebrate it with
galore. Christmas celebrates the birth
of Jesus but the festive is
celebrated and known for
gifts, Santa Clause and the X-
mas tree. TV celebrities share
their memories and wish our
readers a Merry Christmas!!! This
Christmas, I would like to ask Santa for
more work and lots of new
assignments, since that is what I am
appreciated for .
Q5. Give Page border using pictures.
Q6. Give Watermark in a light color.
Q7. Set Header as logo at top right corner and page no in footer.
T
Q4. Write the paragraph is given style.
Actor wishes merry Christmas
he best thing about Christmas is
waking up in the morning and
exchanging gifts and goodies!
Although we have grown
up and stopped believing
in Santa, the present
exchanging never fails to
excite me! I am really
looking forward to Christmas this year
as I have a huge surprise gift planned
for my family and I'm sure that they
are going to be overjoyed when they
receive it.
It's Christmas time and the entire
world is gearing up to celebrate it with
galore. Christmas celebrates the birth
of Jesus but the festive is
celebrated and known for
gifts, Santa Clause and the X-
mas tree. TV celebrities share
their memories and wish our
readers a Merry Christmas!!! This
Christmas, I would like to ask Santa for
more work and lots of new
assignments, since that is what I am
appreciated for .
Q5. Give Page border using pictures.
Q6. Give Watermark in a light color.
Q7. Set Header as logo at top right corner and page no in footer.
T
Practice Set SNS Foundation Page 12
Topic: - Ms-Word
Week-VII
REGISTRATION FORM
Center name _____________________________
Applicant name _____________________________
Address _____________________________
Phone _____________ Date of birth _______
Father’s name ______________________________________
Mother’s name ______________________________________
Father’s occupation _______________________________________
Family annual income __________________________________________
CategoryBPLAPLPL
IF BPL (attached proof of category)
BPL RASHAN CARD Income certificate signed by 1
st
class magistrate
Educational qualification
Standard Board/Univ. Year Marks/total %age
Secondary
s. Secondary
Graduation
P-graduation
Others (specify)
Applicant’s signature
Topic: - Ms-Word
Week-VII
REGISTRATION FORM
Center name _____________________________
Applicant name _____________________________
Address _____________________________
Phone _____________ Date of birth _______
Father’s name ______________________________________
Mother’s name ______________________________________
Father’s occupation _______________________________________
Family annual income __________________________________________
CategoryBPLAPLPL
IF BPL (attached proof of category)
BPL RASHAN CARD Income certificate signed by 1
st
class magistrate
Educational qualification
Standard Board/Univ. Year Marks/total %age
Secondary
s. Secondary
Graduation
P-graduation
Others (specify)
Applicant’s signature
Practice Set SNS Foundation Page 13
Topic: - Ms-Word
Week-VIII
Q1. Write this letter in your word document and prepare an individual letter
for all the participant's name given in the table.
To Date: -05/01/2013
[Name of person],
[School Name]
[Location and Area]
Sub: - Conference on entrepreneurs Promoters
Dear Sir/Madam,
We would like to invite you to attend the 6th Annual Entrepreneurship Promotion
Conference organized by The Entrepreneurship Promoters Inc. , which is slated to
hold from 13th Jan 2013 – 15th Jan 2013 at the Sheraton Hotel and Conference
Center, Sydney Australia.
Entrepreneurship Promoters Inc. is a Not for Profit Organization which has been
providing vital information, inspiration and motivation for the citizens of Sydney
to start and manage their own business. Every year we organize a conference
where we invite entrepreneurs around the city to discuss some tips and tools that
will promote or help their business.
Yours sincerely
[Your name and Address]
Topic: - Ms-Word
Week-VIII
Q1. Write this letter in your word document and prepare an individual letter
for all the participant's name given in the table.
To Date: -05/01/2013
[Name of person],
[School Name]
[Location and Area]
Sub: - Conference on entrepreneurs Promoters
Dear Sir/Madam,
We would like to invite you to attend the 6th Annual Entrepreneurship Promotion
Conference organized by The Entrepreneurship Promoters Inc. , which is slated to
hold from 13th Jan 2013 – 15th Jan 2013 at the Sheraton Hotel and Conference
Center, Sydney Australia.
Entrepreneurship Promoters Inc. is a Not for Profit Organization which has been
providing vital information, inspiration and motivation for the citizens of Sydney
to start and manage their own business. Every year we organize a conference
where we invite entrepreneurs around the city to discuss some tips and tools that
will promote or help their business.
Yours sincerely
[Your name and Address]
Practice Set SNS Foundation Page 14
List of Participants
Name School Name Location Area
Mr. Rajesh Kumar S S Sr Sec School Shahadra Delhi
Ms. Kavita Dayal D D Sr Sec School Lajpat Nagar Delhi
Ms. Sonam Raghuvanshi S D Sr Sec School Saket Delhi
Mr. Deepak Bhatnagar Thomas Sr Sec School Noida Delhi ( NCR )
Ms. Kalyani Mehta Marie Sr Sec School Bandra Mumbai
Mr. Ajay Srivastav Mumbai Sr Sec School Andheri Mumbai
Mr. Sawan Thakur Delhi Sr Sec School Karol Bagh Delhi
Q2. Check the spelling and grammar of the entire page without using
mouse.
Q3. Protect documents for not editing.
Q4. Format the document to change the color of text while any user
tries to delete it.
Q5. Insert cover page of each letter for sending mail merged letter.
List of Participants
Name School Name Location Area
Mr. Rajesh Kumar S S Sr Sec School Shahadra Delhi
Ms. Kavita Dayal D D Sr Sec School Lajpat Nagar Delhi
Ms. Sonam Raghuvanshi S D Sr Sec School Saket Delhi
Mr. Deepak Bhatnagar Thomas Sr Sec School Noida Delhi ( NCR )
Ms. Kalyani Mehta Marie Sr Sec School Bandra Mumbai
Mr. Ajay Srivastav Mumbai Sr Sec School Andheri Mumbai
Mr. Sawan Thakur Delhi Sr Sec School Karol Bagh Delhi
Q2. Check the spelling and grammar of the entire page without using
mouse.
Q3. Protect documents for not editing.
Q4. Format the document to change the color of text while any user
tries to delete it.
Q5. Insert cover page of each letter for sending mail merged letter.
Practice Set SNS Foundation Page 15
Topic: - Ms-Word
Week-IX
Practice on record macro and different views (Normal, Print Layout,
Web Layout, Outline, Draft, Gridline, Document Map and Thumbnails)
Topic: - Ms-Word
Week-IX
Practice on record macro and different views (Normal, Print Layout,
Web Layout, Outline, Draft, Gridline, Document Map and Thumbnails)
Practice Set SNS Foundation Page 16
Topic: - Ms-Excel
Week-X
S. No. Name Age Gender
Salary
(INR/Month)
Bonus
1 Ravi Roy 20 Male 22000
2 Joy Basu 21 Male 26000
3 Alex Cipher 22 Male 25000
4 Ram Krishan 23 Male 24000
5 Chandan Maheshwari 24 Male 27000
6 Rita Bhatnagar 25 Female 27000
7 Sunidhi Mishra 26 Female 29000
8 Charlie Joy 30 Male 25000
9 Surabhi Bhasin 32 Female 36000
10 Melisa Marlo 33 Female 27000
Q1. Enter 10000 for Male and 12000 for Female in Bonus column.
Q2. Calculate the total of Salary and bonus. And fill below given details:
Minimum Salary:
Maximum Salary:
Minimum Age:
Maximum Age:
Total Males:
Instruction:
1. Calculate the Total Payout in both the tables
Learning Objective:
1. Copying formulas
2. Using Paste Special
3. Using $
4. Using Freeze Pane
Topic: - Ms-Excel
Week-X
S. No. Name Age Gender
Salary
(INR/Month)
Bonus
1 Ravi Roy 20 Male 22000
2 Joy Basu 21 Male 26000
3 Alex Cipher 22 Male 25000
4 Ram Krishan 23 Male 24000
5 Chandan Maheshwari 24 Male 27000
6 Rita Bhatnagar 25 Female 27000
7 Sunidhi Mishra 26 Female 29000
8 Charlie Joy 30 Male 25000
9 Surabhi Bhasin 32 Female 36000
10 Melisa Marlo 33 Female 27000
Q1. Enter 10000 for Male and 12000 for Female in Bonus column.
Q2. Calculate the total of Salary and bonus. And fill below given details:
Minimum Salary:
Maximum Salary:
Minimum Age:
Maximum Age:
Total Males:
Instruction:
1. Calculate the Total Payout in both the tables
Learning Objective:
1. Copying formulas
2. Using Paste Special
3. Using $
4. Using Freeze Pane
Practice Set SNS Foundation Page 17
Table-1
Employee Salary
(INR/Annum)
Bonus (INR) Total Payout
(INR)
Employee 1 850,000 50,000
Employee 2 800,000 45,000
Employee 3 900,000 40,000
Employee 4 1,000,000 67,000
Employee 5 750,000 80,000
Employee 6 875,000 55,000
Employee 7 1,100,000 45,000
Employee 8 950,000 40,000
Employee 9 875,000 100,000
Employee 10 925,000 62,000
Total
Table-2
Employee Salary
(INR/Annum)
Bonus (INR) Total Payout
(INR)
Employee 1 850,000
Employee 2 800,000
Employee 3 900,000
Employee 4 1,000,000
Employee 5 750,000
Employee 6 875,000
Employee 7 1,100,000
Employee 8 950,000
Employee 9 875,000
Employee 10 925,000
Total
Calculate bonus at the rate of 15% in table-2
Table-1
Employee Salary
(INR/Annum)
Bonus (INR) Total Payout
(INR)
Employee 1 850,000 50,000
Employee 2 800,000 45,000
Employee 3 900,000 40,000
Employee 4 1,000,000 67,000
Employee 5 750,000 80,000
Employee 6 875,000 55,000
Employee 7 1,100,000 45,000
Employee 8 950,000 40,000
Employee 9 875,000 100,000
Employee 10 925,000 62,000
Total
Table-2
Employee Salary
(INR/Annum)
Bonus (INR) Total Payout
(INR)
Employee 1 850,000
Employee 2 800,000
Employee 3 900,000
Employee 4 1,000,000
Employee 5 750,000
Employee 6 875,000
Employee 7 1,100,000
Employee 8 950,000
Employee 9 875,000
Employee 10 925,000
Total
Calculate bonus at the rate of 15% in table-2
Practice Set SNS Foundation Page 18
Topic: - Ms-Excel
Week-XI
Activity: -1
1. Find total revenue for Albert and Charles
2. Find total revenue for Candy and Chocolate
3. Creating Pivot Tables
S.
No Employee Name Territory Product
Sales
Price
Units
Sold Revenue
1 Albert South Biscuits 12 88
1,056
2 Bob East Biscuits 14 95
1,330
3 Charles West Biscuits 16 43
688
4 David North Candy 20 6
120
5 Emily South Juice 30 71
2,130
6 Mubarak South Juice 30 13
390
7 Frank North Toffee 30 12
360
8 Albert East Juice 35 83
2,905
9 Bob East Juice 35 62
2,170
10 Charles North Biscuits 10 77
770
11 David North Candy 20 44
880
12 Emily East Chocolate 21 59
1,239
13 Mubarak East Chocolate 21 41
861
14 Frank East Chocolate 21 40
840
15 Albert East Candy 28 10
280
16 Bob South Toffee 36 25
900
17 Charles South Biscuits 12 45
540
Topic: - Ms-Excel
Week-XI
Activity: -1
1. Find total revenue for Albert and Charles
2. Find total revenue for Candy and Chocolate
3. Creating Pivot Tables
S.
No Employee Name Territory Product
Sales
Price
Units
Sold Revenue
1 Albert South Biscuits 12 88
1,056
2 Bob East Biscuits 14 95
1,330
3 Charles West Biscuits 16 43
688
4 David North Candy 20 6
120
5 Emily South Juice 30 71
2,130
6 Mubarak South Juice 30 13
390
7 Frank North Toffee 30 12
360
8 Albert East Juice 35 83
2,905
9 Bob East Juice 35 62
2,170
10 Charles North Biscuits 10 77
770
11 David North Candy 20 44
880
12 Emily East Chocolate 21 59
1,239
13 Mubarak East Chocolate 21 41
861
14 Frank East Chocolate 21 40
840
15 Albert East Candy 28 10
280
16 Bob South Toffee 36 25
900
17 Charles South Biscuits 12 45
540
Practice Set SNS Foundation Page 19
18 David North Chocolate 15 7
105
19 Emily North Chocolate 15 8
120
20 Mubarak West Biscuits 16 47
752
21 Frank North Candy 20 83
1,660
22 Albert East Candy 28 94
2,632
23 Bob East Juice 35 91
3,185
24 Charles South Toffee 36 65
2,340
25 David West Juice 40 95
3,800
26 Emily West Juice 40 44
1,760
27 Mubarak East Biscuits 14 83
1,162
28 Frank North Chocolate 15 73
1,095
29 Albert North Chocolate 15 33
495
30 Bob South Candy 24 60
1,440
31 Charles North Toffee 30 36
1,080
32 David South Toffee 36 63
2,268
33 Emily North Biscuits 10 15
150
34 Mubarak North Chocolate 15 36
540
35 Frank West Biscuits 16 14
224
36 Albert North Candy 20 34
680
37 Bob South Candy 24 85
2,040
38 Charles South Candy 24 43
1,032
39 David South Candy 24 1
24
40 Emily East Candy 28 76
2,128
41 Mubarak South Juice 30 48
18 David North Chocolate 15 7
105
19 Emily North Chocolate 15 8
120
20 Mubarak West Biscuits 16 47
752
21 Frank North Candy 20 83
1,660
22 Albert East Candy 28 94
2,632
23 Bob East Juice 35 91
3,185
24 Charles South Toffee 36 65
2,340
25 David West Juice 40 95
3,800
26 Emily West Juice 40 44
1,760
27 Mubarak East Biscuits 14 83
1,162
28 Frank North Chocolate 15 73
1,095
29 Albert North Chocolate 15 33
495
30 Bob South Candy 24 60
1,440
31 Charles North Toffee 30 36
1,080
32 David South Toffee 36 63
2,268
33 Emily North Biscuits 10 15
150
34 Mubarak North Chocolate 15 36
540
35 Frank West Biscuits 16 14
224
36 Albert North Candy 20 34
680
37 Bob South Candy 24 85
2,040
38 Charles South Candy 24 43
1,032
39 David South Candy 24 1
24
40 Emily East Candy 28 76
2,128
41 Mubarak South Juice 30 48
Practice Set SNS Foundation Page 20
1,440
42 Frank South Juice 30 65
1,950
43 Albert East Toffee 42 10
420
44 Bob West Toffee 48 14
672
45 Charles North Biscuits 10 85
850
46 David South Chocolate 18 10
180
47 Emily West Chocolate 24 22
528
48 Mubarak North Toffee 30 100
3,000
49 Frank South Juice 30 88
2,640
50 Albert West Juice 40 84
3,360
51 Bob South Biscuits 12 88
1,056
52 Charles East Biscuits 14 95
1,330
53 David West Biscuits 16 43
688
54 Emily North Candy 20 6
120
55 Mubarak South Juice 30 71
2,130
56 Frank South Juice 30 13
390
57 Albert North Toffee 30 12
360
58 Bob East Juice 35 83
2,905
59 Charles East Juice 35 62
2,170
60 David North Biscuits 10 77
770
61 Emily North Candy 20 44
880
62 Mubarak East Chocolate 21 59
1,239
63 Frank East Chocolate 21 41
861
64 Albert East Chocolate 21 40
840
1,440
42 Frank South Juice 30 65
1,950
43 Albert East Toffee 42 10
420
44 Bob West Toffee 48 14
672
45 Charles North Biscuits 10 85
850
46 David South Chocolate 18 10
180
47 Emily West Chocolate 24 22
528
48 Mubarak North Toffee 30 100
3,000
49 Frank South Juice 30 88
2,640
50 Albert West Juice 40 84
3,360
51 Bob South Biscuits 12 88
1,056
52 Charles East Biscuits 14 95
1,330
53 David West Biscuits 16 43
688
54 Emily North Candy 20 6
120
55 Mubarak South Juice 30 71
2,130
56 Frank South Juice 30 13
390
57 Albert North Toffee 30 12
360
58 Bob East Juice 35 83
2,905
59 Charles East Juice 35 62
2,170
60 David North Biscuits 10 77
770
61 Emily North Candy 20 44
880
62 Mubarak East Chocolate 21 59
1,239
63 Frank East Chocolate 21 41
861
64 Albert East Chocolate 21 40
840
Practice Set SNS Foundation Page 21
65 Bob East Candy 28 10
280
66 Charles South Toffee 36 25
900
67 David South Biscuits 12 45
540
68 Emily North Chocolate 15 7
105
69 Mubarak North Chocolate 15 8
120
70 Frank West Biscuits 16 47
752
71 Albert North Candy 20 83
1,660
72 Bob East Candy 28 94
2,632
73 Charles East Juice 35 91
3,185
74 David South Toffee 36 65
2,340
75 Emily West Juice 40 95
3,800
76 Mubarak West Juice 40 44
1,760
77 Frank East Biscuits 14 83
1,162
78 Albert North Chocolate 15 73
1,095
79 Bob North Chocolate 15 33
495
80 Charles South Candy 24 60
1,440
81 David North Toffee 30 36
1,080
82 Emily South Toffee 36 63
2,268
83 Mubarak North Biscuits 10 15
150
84 Frank North Chocolate 15 36
540
85 Albert West Biscuits 16 14
224
86 Bob North Candy 20 34
680
87 Charles South Candy 24 85
2,040
88 David South Candy 24 43
65 Bob East Candy 28 10
280
66 Charles South Toffee 36 25
900
67 David South Biscuits 12 45
540
68 Emily North Chocolate 15 7
105
69 Mubarak North Chocolate 15 8
120
70 Frank West Biscuits 16 47
752
71 Albert North Candy 20 83
1,660
72 Bob East Candy 28 94
2,632
73 Charles East Juice 35 91
3,185
74 David South Toffee 36 65
2,340
75 Emily West Juice 40 95
3,800
76 Mubarak West Juice 40 44
1,760
77 Frank East Biscuits 14 83
1,162
78 Albert North Chocolate 15 73
1,095
79 Bob North Chocolate 15 33
495
80 Charles South Candy 24 60
1,440
81 David North Toffee 30 36
1,080
82 Emily South Toffee 36 63
2,268
83 Mubarak North Biscuits 10 15
150
84 Frank North Chocolate 15 36
540
85 Albert West Biscuits 16 14
224
86 Bob North Candy 20 34
680
87 Charles South Candy 24 85
2,040
88 David South Candy 24 43
Practice Set SNS Foundation Page 22
1,032
89 Emily South Candy 24 1
24
90 Mubarak East Candy 28 76
2,128
91 Frank South Juice 30 48
1,440
92 Albert South Juice 30 65
1,950
93 Bob East Toffee 42 10
420
94 Charles West Toffee 48 14
672
95 David North Biscuits 10 85
850
96 Emily South Chocolate 18 10
180
97 Mubarak West Chocolate 24 22
528
98 Mubarak North Toffee 30 100
3,000
99 Frank South Juice 30 88
2,640
100 Frank West Juice 40 84
3,360
Activity: -2
1. Create Histogram
2. Create Pie Chart
Zone Literacy %
North
73
South
82
East
65
West
78
Central
67
1,032
89 Emily South Candy 24 1
24
90 Mubarak East Candy 28 76
2,128
91 Frank South Juice 30 48
1,440
92 Albert South Juice 30 65
1,950
93 Bob East Toffee 42 10
420
94 Charles West Toffee 48 14
672
95 David North Biscuits 10 85
850
96 Emily South Chocolate 18 10
180
97 Mubarak West Chocolate 24 22
528
98 Mubarak North Toffee 30 100
3,000
99 Frank South Juice 30 88
2,640
100 Frank West Juice 40 84
3,360
Activity: -2
1. Create Histogram
2. Create Pie Chart
Zone Literacy %
North
73
South
82
East
65
West
78
Central
67
Practice Set SNS Foundation Page 23
Activity-3
Do practice on Page set up (Margin, Page, Sheet) and print option.
73
82
65
78
67
Literacy %
North
South
East
West
Central
Activity-3
Do practice on Page set up (Margin, Page, Sheet) and print option.
73
82
65
78
67
Literacy %
North
South
East
West
Central
Practice Set SNS Foundation Page 24
Topic: - Ms-Excel
Week-XII
Activity: -1
1. Show attendance >=75% in green
2. Show attendance <75% in the red
Student Attendance Performance
S. No Student Name Statistics HRM Math Finance SCM
1 Student 1 60 62 76 55 83
2 Student 2 65 92 45 89 90
3 Student 3 70 93 80 90 82
4 Student 4 78 65 85 76 81
5 Student 5 80 94 56 83 84
6 Student 6 56 76 79 73 77
7 Student 7 87 78 87 60 56
8 Student 8 55 82 89 61 63
9 Student 9 90 84 65 54 54
10 Student 10 74 80 64 52 64
11 Student 11 76 65 60 63 78
12 Student 12 80 62 55 82 90
13 Student 13 73 71 98 89 92
14 Student 14 65 73 78 73 71
15 Student 15 78 77 84 76 70
Activity: 2
Student Table
Roll No. Student Name HRM OB GPP SCM
2013B001 Student 1 60 62 76 55
2013B002 Student 2 65 92 45 89
2013B003 Student 3 70 93 80 90
2013B004 Student 4 78 65 85 76
2013B005 Student 5 80 94 56 83
2013B006 Student 6 56 76 79 73
2013B007 Student 7 87 78 87 60
2013B008 Student 8 55 82 89 61
Topic: - Ms-Excel
Week-XII
Activity: -1
1. Show attendance >=75% in green
2. Show attendance <75% in the red
Student Attendance Performance
S. No Student Name Statistics HRM Math Finance SCM
1 Student 1 60 62 76 55 83
2 Student 2 65 92 45 89 90
3 Student 3 70 93 80 90 82
4 Student 4 78 65 85 76 81
5 Student 5 80 94 56 83 84
6 Student 6 56 76 79 73 77
7 Student 7 87 78 87 60 56
8 Student 8 55 82 89 61 63
9 Student 9 90 84 65 54 54
10 Student 10 74 80 64 52 64
11 Student 11 76 65 60 63 78
12 Student 12 80 62 55 82 90
13 Student 13 73 71 98 89 92
14 Student 14 65 73 78 73 71
15 Student 15 78 77 84 76 70
Activity: 2
Student Table
Roll No. Student Name HRM OB GPP SCM
2013B001 Student 1 60 62 76 55
2013B002 Student 2 65 92 45 89
2013B003 Student 3 70 93 80 90
2013B004 Student 4 78 65 85 76
2013B005 Student 5 80 94 56 83
2013B006 Student 6 56 76 79 73
2013B007 Student 7 87 78 87 60
2013B008 Student 8 55 82 89 61
Practice Set SNS Foundation Page 25
2013B009 Student 9 90 84 65 54
2013B010 Student 10 74 80 64 52
2013B011 Student 11 76 65 60 63
2013B012 Student 12 80 62 55 82
2013B013 Student 13 73 71 98 89
2013B014 Student 14 65 73 78 73
2013B015 Student 15 78 77 84 76
Using above given table prepare Mark Sheet of student in below given format
by using Vlookup function and calculate grade (hints: IF (K9>=75,"A", IF
(K9>=60,"B","C")))
Mark Sheet
Program: Business Leadership
Roll No.: 2013B005
Name: Student 5
Subject Marks Grade
HRM 80 A
OB 94 A
GPP 56 C
SCM 83 A
Students have to do practice on Functions as : Sum (), Sumif (), Count (),
Countif (), CountA (), Max (), Min (), Proper (), Lower (), Upper (),
concatenate (), Int (), Round (), if (), And (), now (), Today (), Hour (), Year ().
2013B009 Student 9 90 84 65 54
2013B010 Student 10 74 80 64 52
2013B011 Student 11 76 65 60 63
2013B012 Student 12 80 62 55 82
2013B013 Student 13 73 71 98 89
2013B014 Student 14 65 73 78 73
2013B015 Student 15 78 77 84 76
Using above given table prepare Mark Sheet of student in below given format
by using Vlookup function and calculate grade (hints: IF (K9>=75,"A", IF
(K9>=60,"B","C")))
Mark Sheet
Program: Business Leadership
Roll No.: 2013B005
Name: Student 5
Subject Marks Grade
HRM 80 A
OB 94 A
GPP 56 C
SCM 83 A
Students have to do practice on Functions as : Sum (), Sumif (), Count (),
Countif (), CountA (), Max (), Min (), Proper (), Lower (), Upper (),
concatenate (), Int (), Round (), if (), And (), now (), Today (), Hour (), Year ().
Practice Set SNS Foundation Page 26
Topic: - Ms-Excel
Week-XIII
Activity: 1
1. Sort Data as per Revenue
2. Sort Employee Name then Territory
3. Make the sheet ready for printing
S.
No
Employee
Name Territory Product
Sales
Price
Units
Sold Revenue
39 David South Candy 24 1
24
40 Emily South Candy 24 1
24
18 David North Chocolate 15 7
105
19 Emily North Chocolate 15 7
105
4 David North Candy 20 6
120
19 Emily North Chocolate 15 8
120
20 Emily North Candy 20 6
120
21 Mubarak North Chocolate 15 8
120
33 Emily North Biscuits 10 15
150
34 Mubarak North Biscuits 10 15
150
46 David South Chocolate 18 10
180
47 Emily South Chocolate 18 10
180
48 Albert West Biscuits 16 14
224
35 Frank West Biscuits 16 14
224
15 Albert East Candy 28 10
280
16 Bob East Candy 28 10
280
17 Albert North Toffee 30 12
360
Topic: - Ms-Excel
Week-XIII
Activity: 1
1. Sort Data as per Revenue
2. Sort Employee Name then Territory
3. Make the sheet ready for printing
S.
No
Employee
Name Territory Product
Sales
Price
Units
Sold Revenue
39 David South Candy 24 1
24
40 Emily South Candy 24 1
24
18 David North Chocolate 15 7
105
19 Emily North Chocolate 15 7
105
4 David North Candy 20 6
120
19 Emily North Chocolate 15 8
120
20 Emily North Candy 20 6
120
21 Mubarak North Chocolate 15 8
120
33 Emily North Biscuits 10 15
150
34 Mubarak North Biscuits 10 15
150
46 David South Chocolate 18 10
180
47 Emily South Chocolate 18 10
180
48 Albert West Biscuits 16 14
224
35 Frank West Biscuits 16 14
224
15 Albert East Candy 28 10
280
16 Bob East Candy 28 10
280
17 Albert North Toffee 30 12
360
Practice Set SNS Foundation Page 27
7 Frank North Toffee 30 12
360
8 Frank South Juice 30 13
390
6 Mubarak South Juice 30 13
390
43 Albert East Toffee 42 10
420
44 Bob East Toffee 42 10
420
29 Albert North Chocolate 15 33
495
30 Bob North Chocolate 15 33
495
47 Emily West Chocolate 24 22
528
48 Mubarak West Chocolate 24 22
528
17 Charles South Biscuits 12 45
540
18 David South Biscuits 12 45
540
19 Frank North Chocolate 15 36
540
34 Mubarak North Chocolate 15 36
540
44 Bob West Toffee 48 14
672
45 Charles West Toffee 48 14
672
36 Albert North Candy 20 34
680
37 Bob North Candy 20 34
680
3 Charles West Biscuits 16 43
688
4 David West Biscuits 16 43
688
5 Frank West Biscuits 16 47
752
20 Mubarak West Biscuits 16 47
752
10 Charles North Biscuits 10 77
770
11 David North Biscuits 10 77
770
12 Albert East Chocolate 21 40
7 Frank North Toffee 30 12
360
8 Frank South Juice 30 13
390
6 Mubarak South Juice 30 13
390
43 Albert East Toffee 42 10
420
44 Bob East Toffee 42 10
420
29 Albert North Chocolate 15 33
495
30 Bob North Chocolate 15 33
495
47 Emily West Chocolate 24 22
528
48 Mubarak West Chocolate 24 22
528
17 Charles South Biscuits 12 45
540
18 David South Biscuits 12 45
540
19 Frank North Chocolate 15 36
540
34 Mubarak North Chocolate 15 36
540
44 Bob West Toffee 48 14
672
45 Charles West Toffee 48 14
672
36 Albert North Candy 20 34
680
37 Bob North Candy 20 34
680
3 Charles West Biscuits 16 43
688
4 David West Biscuits 16 43
688
5 Frank West Biscuits 16 47
752
20 Mubarak West Biscuits 16 47
752
10 Charles North Biscuits 10 77
770
11 David North Biscuits 10 77
770
12 Albert East Chocolate 21 40
Practice Set SNS Foundation Page 28
840
14 Frank East Chocolate 21 40
840
45 Charles North Biscuits 10 85
850
46 David North Biscuits 10 85
850
47 Frank East Chocolate 21 41
861
13 Mubarak East Chocolate 21 41
861
11 David North Candy 20 44
880
12 Emily North Candy 20 44
880
16 Bob South Toffee 36 25
900
17 Charles South Toffee 36 25
900
38 Charles South Candy 24 43
1,032
39 David South Candy 24 43
1,032
1 Albert South Biscuits 12 88
1,056
2 Bob South Biscuits 12 88
1,056
31 Charles North Toffee 30 36
1,080
32 David North Toffee 30 36
1,080
33 Albert North Chocolate 15 73
1,095
28 Frank North Chocolate 15 73
1,095
29 Frank East Biscuits 14 83
1,162
27 Mubarak East Biscuits 14 83
1,162
12 Emily East Chocolate 21 59
1,239
13 Mubarak East Chocolate 21 59
1,239
2 Bob East Biscuits 14 95
1,330
3 Charles East Biscuits 14 95
1,330
840
14 Frank East Chocolate 21 40
840
45 Charles North Biscuits 10 85
850
46 David North Biscuits 10 85
850
47 Frank East Chocolate 21 41
861
13 Mubarak East Chocolate 21 41
861
11 David North Candy 20 44
880
12 Emily North Candy 20 44
880
16 Bob South Toffee 36 25
900
17 Charles South Toffee 36 25
900
38 Charles South Candy 24 43
1,032
39 David South Candy 24 43
1,032
1 Albert South Biscuits 12 88
1,056
2 Bob South Biscuits 12 88
1,056
31 Charles North Toffee 30 36
1,080
32 David North Toffee 30 36
1,080
33 Albert North Chocolate 15 73
1,095
28 Frank North Chocolate 15 73
1,095
29 Frank East Biscuits 14 83
1,162
27 Mubarak East Biscuits 14 83
1,162
12 Emily East Chocolate 21 59
1,239
13 Mubarak East Chocolate 21 59
1,239
2 Bob East Biscuits 14 95
1,330
3 Charles East Biscuits 14 95
1,330
Practice Set SNS Foundation Page 29
30 Bob South Candy 24 60
1,440
31 Charles South Candy 24 60
1,440
32 Frank South Juice 30 48
1,440
41 Mubarak South Juice 30 48
1,440
42 Albert North Candy 20 83
1,660
21 Frank North Candy 20 83
1,660
26 Emily West Juice 40 44
1,760
27 Mubarak West Juice 40 44
1,760
28 Albert South Juice 30 65
1,950
42 Frank South Juice 30 65
1,950
37 Bob South Candy 24 85
2,040
38 Charles South Candy 24 85
2,040
40 Emily East Candy 28 76
2,128
41 Mubarak East Candy 28 76
2,128
5 Emily South Juice 30 71
2,130
6 Mubarak South Juice 30 71
2,130
9 Bob East Juice 35 62
2,170
10 Charles East Juice 35 62
2,170
32 David South Toffee 36 63
2,268
33 Emily South Toffee 36 63
2,268
24 Charles South Toffee 36 65
2,340
25 David South Toffee 36 65
2,340
22 Albert East Candy 28 94
2,632
23 Bob East Candy 28 94
30 Bob South Candy 24 60
1,440
31 Charles South Candy 24 60
1,440
32 Frank South Juice 30 48
1,440
41 Mubarak South Juice 30 48
1,440
42 Albert North Candy 20 83
1,660
21 Frank North Candy 20 83
1,660
26 Emily West Juice 40 44
1,760
27 Mubarak West Juice 40 44
1,760
28 Albert South Juice 30 65
1,950
42 Frank South Juice 30 65
1,950
37 Bob South Candy 24 85
2,040
38 Charles South Candy 24 85
2,040
40 Emily East Candy 28 76
2,128
41 Mubarak East Candy 28 76
2,128
5 Emily South Juice 30 71
2,130
6 Mubarak South Juice 30 71
2,130
9 Bob East Juice 35 62
2,170
10 Charles East Juice 35 62
2,170
32 David South Toffee 36 63
2,268
33 Emily South Toffee 36 63
2,268
24 Charles South Toffee 36 65
2,340
25 David South Toffee 36 65
2,340
22 Albert East Candy 28 94
2,632
23 Bob East Candy 28 94
Practice Set SNS Foundation Page 30
2,632
49 Frank South Juice 30 88
2,640
50 Frank South Juice 30 88
2,640
8 Albert East Juice 35 83
2,905
9 Bob East Juice 35 83
2,905
48 Mubarak North Toffee 30 100
3,000
49 Mubarak North Toffee 30 100
3,000
23 Bob East Juice 35 91
3,185
24 Charles East Juice 35 91
3,185
50 Albert West Juice 40 84
3,360
51 Frank West Juice 40 84
3,360
25 David West Juice 40 95
3,800
26 Emily West Juice 40 95
3,800
Q1. Give the Correct Sr. Number in the Table.
Q2. Give a heading Name ' Total Expense ' to the table using Merge and
Centre (Font Size - 15, Font Type - Times New Roman)
Q3. Fit the Address into the cell without disturbing its width (Hint: Use
Wrap Text)
Q4. Format all the cell columns and fit them according to their width and
height.
Q5. What is the total of revenue?
Q6. What is the total No. of Units Sold?
Q7. What is the Total of Sales Price?
2,632
49 Frank South Juice 30 88
2,640
50 Frank South Juice 30 88
2,640
8 Albert East Juice 35 83
2,905
9 Bob East Juice 35 83
2,905
48 Mubarak North Toffee 30 100
3,000
49 Mubarak North Toffee 30 100
3,000
23 Bob East Juice 35 91
3,185
24 Charles East Juice 35 91
3,185
50 Albert West Juice 40 84
3,360
51 Frank West Juice 40 84
3,360
25 David West Juice 40 95
3,800
26 Emily West Juice 40 95
3,800
Q1. Give the Correct Sr. Number in the Table.
Q2. Give a heading Name ' Total Expense ' to the table using Merge and
Centre (Font Size - 15, Font Type - Times New Roman)
Q3. Fit the Address into the cell without disturbing its width (Hint: Use
Wrap Text)
Q4. Format all the cell columns and fit them according to their width and
height.
Q5. What is the total of revenue?
Q6. What is the total No. of Units Sold?
Q7. What is the Total of Sales Price?
Practice Set SNS Foundation Page 31
Q8. How many people are doing their Business in Northern Territory?
Q9. Total revenue for the Business in Biscuits (Hint: Use Filter for question
number 8 & 9)
Q10. Make Table of given data for printing.
Activity: -2
Give Data validation to not enter less than 100 and more than 1000 in a selected
range of row and columns.
Q8. How many people are doing their Business in Northern Territory?
Q9. Total revenue for the Business in Biscuits (Hint: Use Filter for question
number 8 & 9)
Q10. Make Table of given data for printing.
Activity: -2
Give Data validation to not enter less than 100 and more than 1000 in a selected
range of row and columns.
Practice Set SNS Foundation Page 32
Topic: - Ms-Excel
Week-XIV
Practice on Insert Comments, Freeze panes and different types of
View, Spelling & Grammar checking and Record Macro.
Topic: - Ms-Excel
Week-XIV
Practice on Insert Comments, Freeze panes and different types of
View, Spelling & Grammar checking and Record Macro.
Practice Set SNS Foundation Page 33
Topic: - Ms-PowerPoint
Week-XV
Create a PowerPoint Presentation as given below:
Topic: - Ms-PowerPoint
Week-XV
Create a PowerPoint Presentation as given below:
Practice Set SNS Foundation Page 34
Practice Set SNS Foundation Page 35
Practice Set SNS Foundation Page 36
Topic: - PowerPoint
Week-XVI
Activity: -1
Using insert function insert the below mentioned objects
Activity : -2
Create a slide and insert below mentioned symbols
Topic: - PowerPoint
Week-XVI
Activity: -1
Using insert function insert the below mentioned objects
Activity : -2
Create a slide and insert below mentioned symbols
Practice Set SNS Foundation Page 37
Practice Set SNS Foundation Page 38
Practice Set SNS Foundation Page 39
Topic: - Ms-PowerPoint
Week-XVII
Activity : -1
Create a slide and insert an Audio/Video format in it
Activit: :-2 CreatePowerPointt slide as given below and give animation
on each line of slide (Trainer has to ensure students have given proper
animation and design or not)
Topic: - Ms-PowerPoint
Week-XVII
Activity : -1
Create a slide and insert an Audio/Video format in it
Activit: :-2 CreatePowerPointt slide as given below and give animation
on each line of slide (Trainer has to ensure students have given proper
animation and design or not)
Practice Set SNS Foundation Page 40
Practice Set SNS Foundation Page 41
Practice Set SNS Foundation Page 42
Topic: - Ms-Access
Week-XVIII
Activity No: - 1 Create a students table in Ms-Access and enter the
details of students as given below:
Add a new field course name for each student and do filter, find
according to enrollment no of students.
Activity No: -2
1. Save the table on the desktop with your name
2. Add new field name as a course
3. Add new record in the current table
4. Delete one field from a table
5. Change the font color
6. Fill color in existing table.
Topic: - Ms-Access
Week-XVIII
Activity No: - 1 Create a students table in Ms-Access and enter the
details of students as given below:
Add a new field course name for each student and do filter, find
according to enrollment no of students.
Activity No: -2
1. Save the table on the desktop with your name
2. Add new field name as a course
3. Add new record in the current table
4. Delete one field from a table
5. Change the font color
6. Fill color in existing table.
Practice Set SNS Foundation Page 43
Topic: - Ms-Access
Week-XIX
Activity No:1 Import the data of Ms-Excel in Ms-Access.
Activity No: -2 Export Ms-Access data into Ms-Excel, Ms-Word and
Notepad.
Activity No: -3 Design a Form using Form design command for entry
the Marks of students in a table.
Activity No : -4 Create Report uses report design.
Activity No: -5 Create different types of Table using Table templates.
Activity No: -6 Create Label using current data of table
Topic: - Ms-Access
Week-XIX
Activity No:1 Import the data of Ms-Excel in Ms-Access.
Activity No: -2 Export Ms-Access data into Ms-Excel, Ms-Word and
Notepad.
Activity No: -3 Design a Form using Form design command for entry
the Marks of students in a table.
Activity No : -4 Create Report uses report design.
Activity No: -5 Create different types of Table using Table templates.
Activity No: -6 Create Label using current data of table
Practice Set SNS Foundation Page 44
Topic: - Ms-Access
Week-XX
Activity No: -1 Different types of View as
1. Datasheet View
2. Pivot Table View
3. Pivot Chart View
4. Design View
Activity No: -2
1. Hide/Unhide Row or Column
2. Freeze and Unfreeze the data
3. Formation of Row and columns.
4. Rename the Field name
Practice on Week no 18
th
& 19
th
Topics.
Topic: - Ms-Access
Week-XX
Activity No: -1 Different types of View as
1. Datasheet View
2. Pivot Table View
3. Pivot Chart View
4. Design View
Activity No: -2
1. Hide/Unhide Row or Column
2. Freeze and Unfreeze the data
3. Formation of Row and columns.
4. Rename the Field name
Practice on Week no 18
th
& 19
th
Topics.
Practice Set SNS Foundation Page 45
Topic: - Ms-Virus and its applications
Week-XXI
Practice on above given practice sets
Topic: - Ms-Virus and its applications
Week-XXI
Practice on above given practice sets
Practice Set SNS Foundation Page 46
Topic: - HTML
Week-XXII
Activity: :-1 Design this page using HTML tags
Activity: :-2 Design this page using HTML tags
Topic: - HTML
Week-XXII
Activity: :-1 Design this page using HTML tags
Activity: :-2 Design this page using HTML tags
Practice Set SNS Foundation Page 47
Topic: - Introduction to DOS
Week-XXIII
Practice on given command:
a. Date
b. Time
c. Ver
d. MD
e. CD
f. RD
g. Del
h. Copy Con
i. Deltree
j. Ren
k. Edit
l. DIR
m. Cls
n. Xcopy
o. Sort
Topic: - Introduction to DOS
Week-XXIII
Practice on given command:
a. Date
b. Time
c. Ver
d. MD
e. CD
f. RD
g. Del
h. Copy Con
i. Deltree
j. Ren
k. Edit
l. DIR
m. Cls
n. Xcopy
o. Sort
Practice Set SNS Foundation Page 48
Topic: - Internet and its application
Week-XXIV
Activity: Create your Email ID, login and download files
Topic: - Internet and its application
Week-XXIV
Activity: Create your Email ID, login and download files
Practice Set SNS Foundation Page 49
Practice Set SNS Foundation Page 50
Practice Set SNS Foundation Page 51
Practice Set SNS Foundation Page 52
Practice Set SNS Foundation Page 53
Activity:2 Search any things using search engine sites
Activity:2 Search any things using search engine sites
Tags
Categories
EducationDownload
Download Slideshow Get the original presentation fileQuick Actions
Statistics
- Views 58,632
- Slides 53
- Favorites 28
- Age 4560 days
Related Slideshows
11
TLE-9-Prepare-Salad-and-Dressing.pptxkkk
MaAngelicaCanceran
30 views
12
LESSON 1 ABOUT MEDIA AND INFORMATION.pptx
JojitGueta
24 views
60
GRADE-8-AQUACULTURE-WEEKQ1.pdfdfawgwyrsewru
MaAngelicaCanceran
39 views
26
Feelings PP Game FOR CHILDREN IN ELEMENTARY SCHOOL.pptx
KaistaGlow
39 views
![Jeopardy_Figures_of_Speech_Template.pptx [Autosaved].pptx](https://slidepub.com/thumb/5828/284015828.jpg)
54
Jeopardy_Figures_of_Speech_Template.pptx [Autosaved].pptx
acecamero20
23 views
7
Jeopardy_Figures_of_Speech.pptxvdsvdsvsdvsd
acecamero20
24 views