Sub: Information Technology

Admission No
Roll No.
Name:
Class & Section
D.A.V. Multipurpose Public School, Sonipat
 Activity -1
Objective- Creating Templates in Open
Office Writer and saving for distribution.
Task- Creating a document looks like a
screenshot and save as a template follow
bellow given institution. Apply page border
as per your choice page orientation must be
landscape.
 Give your desired formatting for
School Name, School Address and text
written in the certificate.
 Save your file as template and give the
name certificate template.
 Save as Custom template
 [SCHOOL NAME]
[SCHOOL ADDRESS]

SCHOOL

LOGO

This certificate is awarded to Mast. /Ms. [Name of the Student]

of class [Class] in honor of his/her securing the [rank] Position
in the [name of the competition/ event] occasion [occasion]
conducted on [date].

Principal Competition Judge Master in-charge

 Activity -2
Objective- Creating and understanding the
use of heading and hierarchy of headings.
Task- Write a complete chapter from your
text in Open Office Writer. Use the proper
level of headings in the document.
WORKING INDEPENDENTLY
1.1INTRODUCTION
We human being are social animals, and we are nothing without others. Right
from our childhood, we have been taught about having team-spirit, the art of
working in teams, and so on. Having the quality of being a team-player is indeed
excellent quality. However, in life, not all the occasions and situations demand a
team-work. Many conditions require that one must be able to handle the
situation on one’s own and work independently.

In this session, we shall discuss the very small quality, i.e. working independently
and what all it takes to work independently.

1.2 INDEPENDENT WORKING

Some scenarios require independent working such as self-learning, understanding
and grasping a concept, doing self-regulated research working on an independent
project and so on. Important things about independent working are:-
• You take full responsibility of the work.
• You take the ownership of it, i.e. you make yourself accountable for it.
• You are ready to under supervised work, i.e. you do not require
constant.
 Activity -3
Objective- Creating Table of Contents.
Task- Add a blank page on the top of the
page. Now create a table of content of this
document.
Table of Contents
WORKING INDEPENDENTLY………………………………………………….1
1.1 Introduction………….........................................................1
1.2 Independent Working…………………………………………..………1
Advantage of Independent Working ……………………..……..2
1.3 Work Style for Independent Working……………………..…….2
1.3.1 Action Planning…………………………………………………….4
1.4 Qualities for independent working ……………………………….4
1.4.1 Self Awareness…………………………………………….……….4
1.4.2 Self-Motivation………………………………………….………...5
1.4.3 Self-Regulation ……………………………………….……………6
 Activity -4
Objective- Insert a Table using an insert
table command and data into a table.
Task- Create the following table using
Insert -> Table command in Open Office
Writer and Insert Data.
Apply auto fill option: distribute columns
evenly, save your file with the name.
 Inter House Cricket Final Score Board

[Link] Name of Batsman Wicket Details Runs Balls 4s 6s

1 Sumit C Aman 45 31 4 1
2 Yash LBW Umang 12 15 1 0
3 Aditya B Nirbhay 35 37 3 1
4 Rahul St Karan 37 13 4 2
 Activity -5
Objective- Selecting Objects and applying to
Format.
Task- Apply different background colours to
row and columns.
 Inter House Cricket Final Score Board

[Link] Name of Batsman Wicket Details Runs Balls 4s 6s

1 Aman C Vivek B Amit 40 31 3 1
2 Umang LBW B Anuj 15 15 1 1
3 Nirbhay B Sagar 55 37 3 3
4 Karan C and B Manish 27 20 3 2
 Activity -6
Objective- Calculate for Subtotal
Task- Prepare following worksheet and
display the sum of item accordingly to item
and region.
 Activity -7
Objective- Data Consolidation
Task- Create a new workbook and enter
the following information onto Sheet 1.
Double click on the tab to rename it as East.
 Click on sheet 2 tab and enter the
following information onto sheet2.
Double Click & rename it as West.
 Click Tab of Sheet 3 and rename it as
combined.
 Enter the following information into
sheet3.
 Write commands so B3:B9 of
combined shows total of respective
ranges of east and west as “1st quarter
total’.
 Write command so C3:C9 of combined
shows total of respective ranges east or
west as ‘2nd quarter total’.
 Write commands to D3:D9 of combine
(Sheet3) shows total of respective
ranges of east and west as ‘3rd quarter
Total’.
 Write command of E3:E9 of combined
shows total of respective ranges of east
and west as 4th quarter total.
 Save your workbook as “Total Sales.
Ods”
1 Year 10 Record Sales In Thousands (Combined)
Annual:
2 1st Qua 2nd Qua 3rd Qua 4th Qua 5th Qua
3 POP 408 457 340 599 1804
4 Soul 319 308 379 554 1560
5 R&B 477 415 541 778 2211
6 Country 546 571 600 936 2653
7 Classical 57 73 30 152 312
8 Soundtracks 117 159 222 287 785
9 Children 46 35 35 101 217
 Activity -8
Objective- Solve Queries on SQL.
Task- Consider the Table Named
“Hospital”. Write commands of SQL for:-
1. To show all information about the patients of cardiology department.

Ans: SELECT * FROM hospital WHERE department=’Cardiology’;

2. To list the names of female patients who are in orthopedic dept.

Ans: SELECT name FROM hospital WHERE sex=’F’ AND

department=’Orthopedic’;

3. To list names of all patients with their date of admission in ascending

order.

Ans.: SELECT name, dateofadm FROM hospital ORDER BY

dateofadm;

4. To display Patient’s Name, Charges, age for male patients only.

Ans: SELECT name, charges, age FROM hospital WHERE sex=’M’;

 TABLE : HOSPITAL

No Name Age Department Datofadm Charges Sex

1 Sandeep 24 Surgery 23/02/22 3000 M
2 Ravina 55 Orthopedic 02/07/22 4000 F
3 Karina 36 Orthopedic 22/06/22 2510 F
4 KumKum 25 ENT 21/09/22 2651 F
5 Ankita 65 Cardiology 29/06/22 3698 F
6 Manisha 41 ENT 27/08/22 1258 F
7 Shaliya 42 Cardiology 13/11/22 1565 F

SELECT name, charges, age FROM hospital WHERE sex=’M’;

TABLE : HOSPITAL

Name Charges Age

Sandeep 3000 24
 Activity -9
Objective- Solve Queries on SQL.
Task- Consider the Table Named
“Hospital”. Write commands of SQL for:-
To Create the above Table
Create Table Hospital (NO Number (4), Name Char(20), Age (3),
Department Varchar(20), Dateofadm Date, Charges Number (6), Sex
char(1));
To insert shown record in table.
Insert into Hospital Values (1, ‘Sandeep’, 24, ‘Surgery’, ’23-Feb-22’,
3000,M);
Add One More column in the table Hospital.
Alter Table Hospital Add (Address Varchar(200));
Delete Column Address from the Table Hospital.
Alter Table Hospital Drop (Address);
Remove complete Table.
Drop Table Hospital;
Select * From Hospital;
TABLE : HOSPITAL

No Name Age Department Datofadm Charges Sex Address

1 Sandeep 24 Surgery 23/02/22 3000 M
2 Ravina 55 Orthopedic 02/07/22 4000 F
3 Karina 36 Orthopedic 22/06/22 2510 F
4 KumKum 25 ENT 21/09/22 2651 F
5 Ankita 65 Cardiology 29/06/22 3698 F
6 Manisha 41 ENT 27/08/22 1258 F
7 Shaliya 42 Cardiology 13/11/22 1565 F