List of Programs
1. Write a Business letter and convert into the following styles : (max 180-200 words for each style)
Indented Style
Block Style/Fully Blocked Style
Semi Block Style
2. Write Office Correspondence for the following (max 180-200 words) :
Write a Memorandum(grant of annual increment / notice / reminder / suggestion / grant
of leave)
Office Order(change of working hours/warning letter/show cause /transfer)
DO letter
Office Note(suggestions/advice/views/comments)
3. Create a specimen with fair copy of manuscript (Manuscripts of 200 words containing at least 10
proof corrections in MS word)
4. Create a power point presentation on any one sustainable development goal with at least 7-8
slides.
5. Create a power point presentation on any one topic (festival/sports/technology/climate
change/negative effect of social media etc.) with at least 7-8 slides including :
Adding text box
Adding WordArt
Inserting bulleted points
Inserting of picture/clip arts
Creating Custom Animation Effects for objects
Creating slide transition effects
6. Screenshot of any two Popular Search Engines and screenshot of searching information along
with the result displayed by one search engine.
7. Screenshot of composing an email with attachment
8. Create 5 excel worksheets having tables with at least 5-6 columns and 6-8 rows including main
heading and column heading. The tables should have the following features of MS Excel :
Calculations (using formula max, min, AutoSum, average or simple arithmetic operations like
exponential, subtraction, multiplication, division)
Create table using Relative, Absolute and Mixed Referencing
Using Functions – Through functions Library- Sum(), sumif(), Average(), Max(), Min(), count(),
countif()
Create any one chart in Excel using any one table :
(Column chart/Bar chart/Area chart/Line chart/Pie chart)
****************
Suggestions for Excel worksheets :
Example 1 :
Assignment -1
Use of Formulas Sum, Average, If, Count, Counta, Countif & Sumif
Roll No
Student Name
Hindi
English
Math
Physics
Chemistry
Total
Average
Grade
1
RAM
20
10
14
18
15
77
15.4
A
2
ASHOK
21
12
14
12
18
?
?
?
3
MANOJ
33
15
7
14
17
?
?
?
4
RAJESH
15
14
8
16
20
?
?
?
5
RANJANA
14
17
10
13
18
?
?
?
6
POOJA
16
8
20
17
15
?
?
?
7
MAHESH
18
19
3
10
14
?
?
?
8
ASHUTOSH
19
20
7
14
18
?
?
?
9
ANIL
22
13
8
12
19
?
?
?
10
PREM
26
12
10
11
27
?
?
?
Q.1 Find the Total Number & Average in all Subjects in Each Student .
Q.2 Find Grade Using If Function - If Average Greater >15 then "A" Grade otherwise "B" Grade
Q.3 How Many Student "A" and "B" Grade
Use of Countif
Q.4 Student Ashok and Manoj Total Number and Average
Use of Sumif
Q.5 Count how many Students
Use of Counta
Q.6 How Many Student Hindi & English Subject Number Grater Then > 20 and <15
Use of Countif
Assignment -1
Use of Formulas Sum, Average, If, Count, Counta, Countif & Sumif
Roll No
Student Name
Hindi
English
Math
Physics
Chemistry
Total
Average
Grade
1
RAM
20
10
14
18
15
77
15.4
A
2
ASHOK
21
12
14
12
18
?
?
?
3
MANOJ
33
15
7
14
17
?
?
?
4
RAJESH
15
14
8
16
20
?
?
?
5
RANJANA
14
17
10
13
18
?
?
?
6
POOJA
16
8
20
17
15
?
?
?
7
MAHESH
18
19
3
10
14
?
?
?
8
ASHUTOSH
19
20
7
14
18
?
?
?
9
ANIL
22
13
8
12
19
?
?
?
10
PREM
26
12
10
11
27
?
?
?
Q.1 Find the Total Number & Average in all Subjects in Each Student .
Q.2 Find Grade Using If Function - If Average Greater >15 then "A" Grade otherwise "B" Grade
Q.3 How Many Student "A" and "B" Grade
Use of Countif
Q.4 Student Ashok and Manoj Total Number and Average
Use of Sumif
Q.5 Count how many Students
Use of Counta
Q.6 How Many Student Hindi & English Subject Number Grater Then > 20 and <15
Use of Countif
Q.1 Find the Total Number & Average for each student .
Q.2 Find Grade Using If Function - If Average Greater >15 then "A" Grade otherwise "B" Grade
Q.3 How Many Student got "A" and "B" Grade Use of Countif
Q.4 Student scored minimum and maximum (based on Total column) Use of min & max
Q.5 How Many Student Hindi & English Subject Number Grater Then > 20 and <15 Use of Countif
Example 2 :
Create a student worksheet for 10 students with Name, RollNo, Stream and Total Marks.
Calculate the Grade using If function.
Total Marks Grade
450-500 A
350-450 B
200-350 C
0-200 D
Example 3 :
Create an employee worksheet with basic salary and calculate HRA, DA and Total Salary.
HRA=24% of basic salary
DA=35% of basic salary
Total Salary= Basic Salary+HRA+DA
Calculate the Grade using If function.
Total Salary Grade Officer
75000 and above A
50000-75000 B
Less than 50000 C
Example 4 :
Q.1 Using of Product Fomula for Calculate Amount = Qty*Rate
Q.2 How Many Items in a List
Q.3 How Many Items qty Greater Then > 20 and Less Then <20
Q.4 If Items Amount is Greater > 500000, Then Items "Expensive" otherwise "Lets Buy it"
Example 5 :
Number of Schools in Selected Cities of Rajasthan
District Secondary Primary
Ajmer 68 89
Jaipur 124 97
Kota 98 86
Sikar 54 112
Sawai 13 37
Jodhpur 89 150
Calculate total number of secondary school and primary school using SUM function
Find out total number of schools in each district using formula
Find out average number of secondary school using function of average
Find out average number of primary school using function of average
Find out minimum and maximum number of schools both for Secondary and Primary
Calculate the % of Primary Schools to Total
Calculate the % of Secondary Schools to Total
