CLASS XI INFORMATION TECHNOLOGY PRACTICALS
EX – 1 TEXT FORMATTING USING OPEN OFFICE WRITER
AIM:
To create a document and do all the formatting options in open office writer.
PROCEDURE:
a) Desktop → Open Office → Text Document.
b) Type the document.
c) Select the paragraph and apply Ctrl+L,Ctrl+R, Ctrl+E etc.
d) Highlight the text using bold, Italic, Underline etc.
e) Change the foreground, background color font face and size etc.
f) Save the document as,
g) File → save as → D:/ → select the folder → textformat.odt
OUTPUT:
RESULT:
The document created and applied the formatting options successfully.
***************
1
CLASS XI INFORMATION TECHNOLOGY PRACTICALS
EX – 2 - PAGE COLUMNS USING OPEN OFFICE WRITER
AIM:
To create a 2-page 2-column article having pictures and text. Create a hyperlink to a web page. Also
state the number paragraphs, lines, words and characters in the document. Perform spell check on the
document using open office writer.
PROCEDURE:
a) Desktop → Open Office → Text Document.
b) Format menu → page → page style → Columns → Columns as 2
c) Type the topic and go to Properties → Text and format it.
d) Insert menu → Picture → From File
e) Type the text and select all the text.
f) Go to side bar → properties → paragraph → align justified
g) Insert menu → Picture → From file → Select the file
h) Insert menu → Hyperlink → type the website name as “www.cbse.nic.in”
i) Select all the 2 pages and 2 columns
j) To show the number of paragraphs, lines, words and characters in the document,
File menu → Properties → Statistics
k) Select all the pages.
l) Tools → Spell Check Grammar
m) Save the document as,
n) File → save as → D:/ → select the folder → pagecolumn.odt
2
CLASS XI INFORMATION TECHNOLOGY PRACTICALS
OUTPUT:
RESULT:
Document was created successfully.
****************
3
CLASS XI INFORMATION TECHNOLOGY PRACTICALS
EX – 3 DIFFERENT CHARTS IN OFFICE CALC
AIM:
To create the following worksheet:
Create a bar graph for the above data.
Create a pie chart for column Y.
Create a line chart between X and Y.
PROCEDURE:
Desktop → Open Office → Spreadsheet and type the above data in the worksheet.
a) Create a bar graph for the above data.
Select the data cells.
Go to the Insert menu → Click Chart option
Chart Wizard Dialog box appears
Choose chart type-> Bar chart, chart elements-> give the titles and legend
Click Finish
Bar chart appears on the screen.
b) Create a pie chart for column Y.
Select the data 'Y' column.
Go to the Insert menu → Click Chart option
Chart Wizard Dialog box appears
Choose chart type-> Pie chart, chart elements-> give the titles and legend
Click Finish
Pie chart appears on the screen.
c) Create a line chart between X and Y.
Select the data cells.
Go to the Insert menu → Click Chart option
4
CLASS XI INFORMATION TECHNOLOGY PRACTICALS
Chart Wizard Dialog box appears
Choose chart type-> Line chart, chart elements-> give the titles and legend
Click Finish
Line chart appears on the screen.
Save the spreadsheet as,
File → save as → D:/ → select the folder → charts.ods
OUTPUT:
RESULT:
The worksheet has been created successfully.
************
5
CLASS XI INFORMATION TECHNOLOGY PRACTICALS
EX – 4 MACROS IN OFFICE CALC
AIM:
To Create a macro in Open Office Calc which will set all borders of the cells D3:J15, set the colour
of cells as blue and set the first row to have font style as bold and center aligned text.
PROCEDURE:
a) Desktop → Open Office → Spreadsheet.
b) Go to the Tools tab on the Menu bar->Macros->Record Macro
c) A small dialog box appears on the worksheet
d) Calc has started recording the Macro.
e) Select D3:J15 and right click it
f) Choose Format cells → Borders-> all borders
g) Goto properties->cell appearance-> cell background ->select blue color
h) Select D3:J3, goto properties ->Text-> click 'Bold' option, Alignment-> 'center'
i) Click Stop recording and a dialog box appears
j) Give filename for Saving the macro
k) Go to the Tools tab on the Menu bar->Macros->Run Macros
l) Select macro file → Run
m) Save the spreadsheet as,
n) File → save as → D:/ → select the folder → macrocalc.ods
6
CLASS XI INFORMATION TECHNOLOGY PRACTICALS
OUTPUT:
RESULT:
The worksheet has been created successfully.
*************
7
CLASS XI INFORMATION TECHNOLOGY PRACTICALS
EX – 5 PRESENTATION ON IMPORTANCE OF ENVIRONMENT
AIM:
To create a five slide presentation showing the importance of saving the environment
using Open Office Impress.
PROCEDURE:
a) Desktop → Open Office → Presentation (Open Office Impress)
b) Create the master slide and format the background, font face etc.
c) Right Click the slide → slide → set the background picture (or)
d) Format → page → background → select the background color
e) Add a heading to the title and format it.
f) Insert → slide → Properties → master pages → select the slide
g) To insert a picture into a presentation , Insert → Pictures → environment → From File
h) Add the text and format it.
i) Insert → slide.
j) Same procedure followed for adding , formatting the text.
k) Properties → custom Animation → select the option → Click 'Add'
l) Slide show → Slide Transition → Select the option
m) Slide Show → Slide Transition → Set the speed and Sound
n) Advance Slide → Any one option
o) Click “Apply for all”
p) Slide show → slide show (or) F5
8
CLASS XI INFORMATION TECHNOLOGY PRACTICALS
q) Save the file as, File → Save as → D:/ → Select the folder → environment.odp
OUTPUT:
RESULT:
The presentation has been created successfully
**************
9
CLASS XI INFORMATION TECHNOLOGY PRACTICALS
EX – 6 PRESENTATION USING ADVANCED TOOLS
AIM:
To create a five slide presentation having hyperlink on each slide to a web resource
(audio, page, video) around the theme of beautiful nature.
PROCEDURE:
a) Desktop → Open Office → Presentation
b) Right Click the slide → slide → set the background picture (or)
c) Format → page → background → select the background color
d) Add a heading to title and format it.
e) To insert a picture into a presentation ,
f) Insert → Pictures → environment → From File
g) Insert → hyperlink → thrillophilia.com
h) Insert → Movies and Sound → add sound
i) Add the text and format it.
j) Insert → slide
k) Same procedure followed for adding , formatting the text.
l) For each slide, add hyperlink to web resources video
m) Properties → custom Animation → select the option → Click 'Add'
n) Slide show → Slide Transition → Select the option
o) Slide Show → Slide Transition → Set the speed and Sound
p) Advance Slide → Any one option
10
CLASS XI INFORMATION TECHNOLOGY PRACTICALS
q) Click “Apply for all”
r) Save the file as, File → Save as → D:/ → Select the folder → nature.odp
OUTPUT:
RESULT:
The presentation has been created successfully
***************
11
CLASS XI INFORMATION TECHNOLOGY PRACTICALS
EX – 7 SQL COMMANDS EXERCISE 1
AIM:
To write Queries for the following Questions based on the given table: INFO
EmpID Name Gende Age Dept DOJ Salary City
r
1 Praveen M 25 Sales 1989-06-08 20000 Chennai
2 Arun M 29 Marketing 1989-09-26 22000 Chennai
3 Usha F 27 Finance 1994-08-09 25000 Bangalore
4 Bala M 31 Sales 1990-03-23 27000 NULL
5 Rani F 28 Marketing 1990-04-23 27000 Mumbai
6 Nisha F 26 NULL 1991-02-24 18000 Bangalore
7 Manoj M 32 Finance 1982-05-06 30000 Goa
(a) Write a Query to Create a new database in the name of " EMPLOYEES ".
CREATE DATABASE EMPLOYEES;
(b) Write a Query to Open the database EMPLOYEES
USE EMPLOYEES;
(c) Write a Query to create the above table called: Info
CREATE TABLE INFO
(EmpID int primary key,
Name varchar(15),
Gender varchar(3),
Age int,
Dept varchar(15),
DOJ date,
Salary int,
City varchar(10));
(d) Write a Query to list all the existing database names.
SHOW DATABASES;
12
CLASS XI INFORMATION TECHNOLOGY PRACTICALS
(e) Write a Query to insert all the rows of above table into Info table.
INSERT INTO INFO VALUES (1,'Praveen','M', 25,'Sales','1989-06-08','20000','Chennai');
INSERT INTO INFO VALUES(2,'Arun','M',29,'Marketing','1989-09-26',22000,'Chennai');
INSERT INTO INFO VALUES(3,'Usha','F',27,'Finance','1994-08-09',25000,'Bangalore');
INSERT INTO INFO VALUES(4,'Bala','M',31,'Sales','1990-03-23',27000,NULL);
INSERT INTO INFO VALUES(5,'Rani','F',28,'Marketing','1990-04-23',27000,'Mumbai');
INSERT INTO INFO VALUES (6,'Nisha','F', 26, NULL,'1991-02-24', 18000,'Bangalore');
INSERT INTO INFO VALUES (7,'Manoj','M', 32,'Finance','1982-05-06', 30000,'Goa');
(f) Write a Query to display all the details of the Employees from the above table 'INFO'.
SELECT * FROM INFO;
Output:
13
CLASS XI INFORMATION TECHNOLOGY PRACTICALS
EX – 8 -SQL COMMANDS EXERCISE -2
AIM:
To write Queries for the following Questions based on the given table:
TABLE : STUDENT
Rollno Name Gender Age Dept DOA Fees
1 Arun M 24 COMPUTER 1997-01-10 120
2 Ankit M 21 HISTORY 1998-03-24 200
3 Anu F 20 HINDI 1996-12-12 300
4 Bala M 19 NULL 1999-07-01 400
5 Charan M 18 HINDI 1997-09-05 250
6 Deepa F 19 HISTORY 1997-06-27 300
7 Dinesh M 22 COMPUTER 1997-02-25 210
8 Usha F 23 NULL 1997-07-31 200
a) Write a Query to insert all the rows of above table into STUDENT table.
INSERT INTO STUDENT VALUES (1,'Arun','M', 24,'COMPUTER','1997-01-10', 120);
INSERT INTO STUDENT VALUES (2,'Ankit','M', 21,'HISTORY','1998-03-24', 200);
INSERT INTO STUDENT VALUES (3,'Anu','F', 20,'HINDI','1996-12-12', 300);
INSERT INTO STUDENT VALUES (4,'Bala','M', 19, NULL,'1999-07-01', 400);
INSERT INTO STUDENT VALUES (5,'Charan','M', 18,'HINDI','1997-06-27', 250);
INSERT INTO STUDENT VALUES (6,'Deepa','F', 19,'HISTORY','1997-06-27', 300);
INSERT INTO STUDENT VALUES (7,'Dinesh','M', 22,'COMPUTER','1997-02-25', 210);
INSERT INTO STUDENT VALUES (8,'Usha','F', 23, NULL,'1997-07-31', 200);
14
CLASS XI INFORMATION TECHNOLOGY PRACTICALS
(b) Write a Query to display all the details of the Employees from the above table 'STUDENT'.
SELECT * FROM STUDENT ;
Output:
(c)Write a query to Rollno, Name and Department of the students from STUDENT table.
SELECT ROLLNO,NAME,DEPT FROM STUDENT;
Output:
(d) Write a Query to select distinct Department from STUDENT table.
SELECT DISTINCT(DEPT) FROM STUDENT;
Output:
(e) To show all information about students of History department.
SELECT * FROM STUDENT WHERE DEPT='HISTORY';
15
CLASS XI INFORMATION TECHNOLOGY PRACTICALS
Output:
*********************
EX – 9 SQL COMMANDS EXERCISE – 3
Aim: To write Queries for the following Questions based on the given table:
TABLE: EMPLOYEE
EmpID Name Gender Age Dept DOJ Salary City
1 Praveen M 25 Sales 1989-06-08 20000 Chennai
2 Arun M 29 Marketing 1989-09-26 22000 Chennai
3 Usha F 27 Finance 1994-08-09 25000 Bangalore
4 Bala M 31 Sales 1990-03-23 27000 NULL
5 Rani F 28 Marketing 1990-04-23 27000 Mumbai
6 Nisha F 26 NULL 1991-02-24 18000 Bangalore
7 Manoj M 32 Finance 1982-05-06 30000 Goa
(a) Write a Query to Display Employees’ name and City from the above table.
SELECT NAME, CITY FROM EMPLOYEE;
Output:
16
CLASS XI INFORMATION TECHNOLOGY PRACTICALS
(b) Write a Query to Display all details of Employees who are living in Chennai.
SELECT * FROM EMPLOYEE WHERE CITY='CHENNAI';
Output:
17
CLASS XI INFORMATION TECHNOLOGY PRACTICALS
( C) Write a Query to get the name and salary of the employee whose salary is above
15000 and gender is not male.
SELECT NAME,SALARY FROM EMPLOYEE
WHERE SALARY >15000 AND GENDER<>'M';
Output:
(d) Write a query to update increase 10% Salary of an employee whose City is 'CHENNAI' and
Gender is 'MALE'.
UPDATE EMPLOYEE SET SALARY=SALARY+ SALARY*0.10)
WHERE CITY='CHENNAI' AND GENDER='MALE';
Output (After Updating):
(e)Write a Query to delete the details of Employee Id 6.
DELETE FROM EMPLOYEE WHERE EMPID=6;
Output (After Deletion):
SELECT * FROM EMPLOYEE;
******************************
18
CLASS XI INFORMATION TECHNOLOGY PRACTICALS
JAVA PROGRAMMING LANGUAGE
EX – 10 TEXT CONCATENATION
AIM:
To write a java program for join two text entries and display them
SOURCE CODE:
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt)
{
String first=jTextField1.getText();
String second=jTextField2.getText();
jTextField3.setText(first+second);
}
OUTPUT:
RESULT:
The program is executed successfully.
************
19
CLASS XI INFORMATION TECHNOLOGY PRACTICALS
EX – 11 SIMPLE INTEREST
QN: Write a java code to find simple interest for the principal, rate of interest and time.
AIM:
To write a java code to find simple interest for the principal, rate of interest and time.
SOURCE CODE:
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt)
{
int principal=Integer.parseInt(jTextField1.getText());
int rate=Integer.parseInt(jTextField2.getText());
int year=Integer.parseInt(jTextField3.getText()); float si;
si=(principal*rate*year)/100; jTextField4.setText("The simple
interest is rs. "+si);
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
System.exit(0);
OUTPUT
RESULT:
The program is executed successfully.
*************
20
CLASS XI INFORMATION TECHNOLOGY PRACTICALS
EX – 12 ARITHMETIC CALCULATION
QN: Write a java program to Perform simple arithmetic calculation using operators and display the result.
AIM:
To write a java program to Perform simple arithmetic calculation using operators and display the result.
SOURCE CODE:
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt)
{ int num1=Integer.parseInt(jTextField1.getText());
int num2=Integer.parseInt(jTextField2.getText()); int
result=num1+num2; jTextField3.setText(""+result);
}
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt)
{ int num1=Integer.parseInt(jTextField1.getText());
int num2=Integer.parseInt(jTextField2.getText()); int result=num1-
num2; jTextField3.setText(""+result);
}
private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) { int
num1=Integer.parseInt(jTextField1.getText());
int num2=Integer.parseInt(jTextField2.getText()); int
result=num1*num2; jTextField3.setText(""+result);
}
private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) { int
num1=Integer.parseInt(jTextField1.getText());
int num2=Integer.parseInt(jTextField2.getText()); int
result=num1/num2; jTextField3.setText(""+result);
}
private void jButton5ActionPerformed(java.awt.event.ActionEvent evt)
{
System.exit(0);
}
21
CLASS XI INFORMATION TECHNOLOGY PRACTICALS
OUTPUT:
RESULT:
The program is executed successfully.
****************************
22
CLASS XI INFORMATION TECHNOLOGY PRACTICALS
EX – 13 DISPLAYING A MESSAGE – JOPTION PANE
QN: Write a java program using Joption Pane display a message “welcome to INFORMATION
TECHNOLOGY”
AIM:
To write a java code Using Joption Pane display a message “welcome to INFORMATION
TECHNOLOGY”
SOURCE CODE:
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt)
{ String message= jTextField1.getText(); JOptionPane.showMessageDialog(this,message);
}
OUTPUT:
RESULT:
The program is executed successfully.
***************
23
CLASS XI INFORMATION TECHNOLOGY PRACTICALS
EX – 14 WEEKDAY FINDER
QN: Write JAVA code to perform an operation based on the criteria input by the user in a radio button .
(WEEK DAY FINDER)
AIM:
To Write JAVA code to perform an operation based on the criteria input by the user in a
radio button . (WEEK DAY FINDER)
SOURCE CODE:
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
if (jRadioButton1.isSelected())
jTextField1.setText("MONDAY");
else if(jRadioButton2.isSelected())
jTextField1.setText("TUESDAY");
else if(jRadioButton3.isSelected())
jTextField1.setText("WEDNESDAY");
else if(jRadioButton4.isSelected())
jTextField1.setText("THURSDAY");
else if(jRadioButton5.isSelected())
jTextField1.setText("FRIDAY");
else if(jRadioButton6.isSelected())
jTextField1.setText("SATURDAY");
else if(jRadioButton7.isSelected())
jTextField1.setText("SUNDAY");
else jTextField1.setText("Day not selected");
}
24
CLASS XI INFORMATION TECHNOLOGY PRACTICALS
OUTPUT
RESULT:
The program is executed successfully.
**********************
25
